Software Engineering

Program Specifications

University : Helwan University

Faculty: Faculty of Computers and Information

Program  Specification

A- Basic Information

1- Program Title: Software Engineering

2- Program Type:       Single           Double            Multiple      

3- Department : Information Systems

4- Coordinator:…Prof.  Torky  E. Sultan  ……

5- External Evaluator(s):  N/A………….

6- Last date of program specifications approval: Oct 2012

B- Professional Information

1- Programme aims

·      Enable graduates to exhibit a high level of practical and theoretical skills over a broad range of Information Technology together with knowledge of currently available techniques and technologies.

·      Explore the principles that support developments in a rapidly changing environment.

·      Provide opportunities for students to understand the wide range of research challenges facing Information Technology, as well as the breadth and depth of research undertaken in this top-rated school, so they are prepared to get on research here or elsewhere.

·      Develop competent professionals able to play a leading part in many different commercial, industrial and academic activities and adapt rapidly to changing technology.

·      Meet industry demand for high caliber graduates who will take a lead in continuing technological change.

·      Prepare students for the social, organizational and professional context in which they will be working.

2- Intended Learning Outcomes (ILOs)

A-     Knowledge and understanding

The graduate should show a critical knowledge and understanding of:

A1. Identify the basics of Mathematics.

A2. Identify the basics of Electronics for computer design.

A3 List the basics of Management.

A4. Describe the basics of Networking.

A5. Recognize different Networks Designs.

A6. Identify the basics of software design.

A7. Create design of components, objects and patterns.

A8. Identify the basics of database design.

A9. Describe Programming principles.

A10. Classify Problem solving techniques.

A11. Explain Software systems analysis.

A12. Recognize Software systems design.

A13. Describe legal, moral and ethical aspects of software systems.

A14. Describe Social impacts of software engineering.

A15. Explain economical impacts of Software Engineering.

A16 produce tools for software engineering production and engineering.

A17. Explain Software quality assurance.

A18. Recognize Software verifications and validation.

A19. Describe security in Software systems.

A20. Specify safety and environmental issues in software engineering.

A21. Apply Software project management.

A22. Apply applications of software systems to business environment.

A23. Outline advanced topics in software engineering.

A24. Recognize professional ethics in computer-based systems.

A25. Clarify human rights.

Knowledge and understanding are developed through participation in lectures, tutorials, labs and workshops, directed and general reading, and primary and secondary search, e.g. using the Internet, library, etc.

B-    Intellectual skills

At the end of the program, the graduate should be able to:

B1. Model problems mathematically.

B2. Model problems by programming.

B3. Model problems using software engineering techniques.

B4. Create and/or design software components, objects and classes.

B5. Reconstruct patterns, components and relation in modeling data and information.

B6. Select appropriate solutions for problems in software design and development.

B7. Analyze risks and economical aspects in the management of software projects.

B8. Assess and evaluate the performance of software systems.

B9. Solve the problems encountered in software design and production.

B10. Complete the limitations of the computation capabilities.

B11. Select appropriate tools and technologies used in software engineering.

B12. Model the practical criteria and constraints in the adoption of the software systems in business environment.

B13. Analyze the results of computational models.

B14. Investigate advanced tools in software engineering.

B15. Judge and estimate the cost of software systems.

B16. Estimate the quality and reliability of software systems.

B17. Judge the environmental impact of the adoption of the software.

B18. Analyze systems.

B19. Perform requirement specifications.

B20. Compare between different design schemes.

B21. Summarize and document different Solutions.

Intellectual skills are developed through successful completion of set assessment tasks, self-appraisal and self-evaluation, and critical evaluation of concepts, assumptions, arguments and data.

    C- Professional and practical skills

At the end of the program, the graduate should be able to:

C1. Use mathematics for solving problems and modeling solution.

C2. Use programming concepts for solving problems.

C3. Solve problems in software productions and adoption.

C4. Analyze data.

C5. Design test cases.

C6. Use software tools in order to collect and interpret data.

C7. Design software solutions.

C8. Design and develop software services.

C9. Apply software engineering principle in developing software projects.

C10. Describe the  software engineering skills to market and industry.

C11. Apply principles of safety, reliability in developing software.

C12. Prepare technical materials.

C13. Design the Management software projects.

C14. Consider the neatness and aesthetics in software design.

    D- General and transferable skills

At the end of the program, the graduate should be able to:

D1. Show Work efficiently in a team.

D2. Show Work in stressful environment and within constraints.

D3. Create Communicate effectively.

D4. Use IT tools efficiently.

D5. Lead teamwork efficiently.

D6. Take apart of Manage  tasks and resources.

D7. Search for information and learn independently.

D8. Specify the workflow of commercial and industrial enterprises.

D9.  Demonstrate critical thinking.

D10. Show analytical thinking and the ability to solve problems.

Skills for life and work (general skills) are developed through working in groups to complete work set, such as presentations and projects and managing time to complete assignments by deadlines.

3- Academic Reference Standards

We developed our own Academic Reference Standards (ARS) for software engineering specialization, which is based on the National Academic References Standards (NARS) for Computing Academic Programs, developed by Computing and Engineering Sector in the Supreme Council of Universities.

3.1 Matching the academic reference standards to the programme's ILOs

1. Knowledge and Understanding

2. Intellectual Skills

3. Professional and Practical Skills

4. General and transferable skills

4- Academic Reference Marks

            N/A

5- Curriculum Structure and Contents

4.a- Program duration:  Typically 8  Semesters – Credit hours system – So no specific no. of hours per week are assumed for every student. What is given here is for an  average student.

General Outlines of the Program

-     Total number of credit hours is 129

-     University requirements 12 CH

-     Faculty requirements 54 CH

-     Specialization requirement  54 CH

-     Free electives 9 CH

A) University requirements:

12 CH:  6 Compulsory + 6 Electives

B) Faculty requirements:

54 CH:  45 Compulsory + 9 Electives

C) Specialization requirements:

54 CH:  42 Compulsory + 12 Electives

D)  Free Electives (9 CH)

يختار الطالب مجموعة مقررات بما يعادل (9) ساعات معتمدة من أي مقررات تقدمها الجامعة بموافقة المشرف الأكاديمي وبشرط ألا تكون من مقررات تخصص هندسة البرمجيات.

6.1 The Courses and their ILOs

a) Obligatory Course

a.1) General

a.2) Faculty requirements

a.3) Program requirements

b. Elective courses

b.1 General

b.2 Faculty Elective

b.3 Department elective

6.2 Courses Contents

IS 110 Introduction to Informatics                            نال 110  مقدمة في المعلوماتية            

Introduction to computer and information systems. Types of computers. Computer hardware and software components. Data representation and number systems. Introduction to networking. Introduction to internet, hardware and software components for internet access. Algorithm development, algorithm representation, stepwise refinement, problem solving tools. Office tools.

IS 211 Database Systems 1                                                                                              

نال 211    نظم قواعد البيانات 1  

The main objective of this course is to provide students with the background to design, implement, and use database management systems. Topics Include:  Evolution of database management systems, Relational Data Model and Relational Algebra, Structured Query Language, Entity Relationship Modeling and Design, ERM to RM Conversion,  Tables Normalization, Forms / Reports / Menus Implementation
Upon successful completion of this course, students will have the skills to analyze business requirements and produce a viable model and implementation of a database to meet such requirements.

IS 241 Modeling and Simulation       

نال 241 النمذجة والمحاكاة

Fundamentals of computer simulation as a modeling technique are presented. Simulation will be versus mathematical modeling. The value of simulation as an experimental tool to support solving the problem and decision making process. Time management in simulation models (concepts of timing routine). Stochastic versus deterministic models. Discrete versus continuous simulation. Deterministic fixed time advance simulation. Stochastic discrete event simulation (event, activity and process-based models). Random sampling on computers. An overview of statistical methods in simulation experiments. Introduction to software tools for simulation purposes. The development of simulation models using procedural and simulation programming languages is stressed throughout the course.

IS 312 Database Systems 2                            

نال 312   نظم قواعد البيانات2

The main objective of this course is to provide students with an in-depth understanding of the design and implementation of database systems and the administration features of any DBMS. Topics Include:  Review of Relational model, E-R Diagramming, Normalization, SQL, Review of Relational Algebra, Query Processing and Optimization, Transaction Processing, Concurrency Control and Recovery, Database Security and Authorization, Database Architectures, Distributed Databases: Architecture, Distributed transaction processing, Object Oriented Databases, Data Warehousing: Heterogeneous component systems, data scrubbing, DW Design. On-Line Analytical Processing (OLAP). Upon successful completion of this course, students will have advanced skills to effectively develop, implement and manage medium to large-scale database management systems.

IS 313 Data Storage and Retrieval    

نال 313  تخزين و استرجاع البيانات       

This course presents the study of file structures through an object-oriented approach allowing students to acquire the fundamental tools needed to design cost-effective and appropriate solutions to file structure problems. The course includes the following topics: indexing, consequential processing and the sorting of large files on disk and on tape, multilevel indexing and B-trees with its variants, indexed sequential access to files, hashing and extendible hashing. The course is supported with programming assignments on the studied topics.

IS 321 Software Project Management           

نال 321 إدارة مشروعات البرمجيات                                                                                          

Evaluation, selection, and organization of technical projects. Concepts of the network-based project management methodology. Network development. Project planning, scheduling, and control. Project cost management. Resource constrained projects. A case study approach is adopted during the course. Commercial software packages will be used throughout the course. The course will also introduce some contemporary project management subjects such as: e-projects, and Intelligent project management.

IS 351 Software Engineering -1

نال351 هندسة برمجيات 1

Overview of software engineering, software requirement: requirement engineering processes, system models, software prototyping. Design: architecture design, distributed system architecture, object oriented design, user interface design.

IS 345 Internet Applications                                                     نال 345 تطبيقات الأنترنت

 The Principles of the internet and its protocols, Learning how to design of a simple home page using HTML. DHTML, CSS, the use of script language such as JavaScript and VB Script, The ADO and the XML.

IS 333 Management Information Systems                

نال333  نظم المعلومات الادارية

The course is a practical, managerial-oriented approach to show how IT is used in organizations for the improvement of quality and productivity. It lays down the concrete and profound managerial framework in IT management. It features cases drawn from major corporations and small businesses to illustrate how Information Technology innovations can solve organizational problems and challenges. It contains `a variety of cases which highlight problems many corporations encounter, as well as international cases, written by prominent international figures in the field , to illustrate  how IT can be adapted to conform to other cultures. It covers a substantial coverage of new technology and applications.

IS 334 Accounting Information Systems      

نال334  نظم المعلومات المحاسبية

An overview of the principles of computerized accounting systems. Topics covered include concepts and fundamentals, Transaction information system functions, transaction cycles:  Expenditure cycle, Revenue cycle, Production cycle and Human Resources cycle , transaction processing control; systems security,  and new developments in computer-based systems,

IS 352 Software Engineering - 2

نال 352  هندسة برمجيات  2                                                            

            This module aims at enabling the students to understand the range of life cycle approaches, methodologies, tools and techniques available for the design of various aspects of information systems. This module builds on the module Information Systems Analysis and Design I, which would be assumed to have given the students systems analysis skills using at least one systems analysis methodology and related tools and techniques.  The course content includes the architectural design (including the identification of architectural alternatives and evaluating them), software and information systems design & application architecture design; the design of IS interfaces.

IS 414 Database Design  - 1                                        نال 414 تصميم قواعد البيانات - 1

Phases of database design, Conceptual database design, Classification, specialization, and aggregation abstraction, The Entity-Relationship model, Extended Entity-Relationship model, View design in conceptual schema, Conceptual schema integration, Transforming conceptual schema to relations, Logical database design, Characteristics of good relation schema, Anomalies in relational schema, Functional dependencies, Inference rules for functional dependencies, Closure and minimal covers for functional dependencies, Normal forms, Transforming relations into third and Boyce-Codd normal forms, Multivalued dependencies and fourth normal form.

IS 421 Data Mining                                                   

نال 421 التنقيب فى البيانات

Knowledge discovery in databases, Data mining process, Data cleaning and preparation, Mining association rules, Classification, Prediction, Clustering, Web mining, Applications of data mining, Mining advanced databases.

IS415 Object Oriented Databases     

نال 415 قواعد البيانات الشيئية                 

History of data models, Semantic data models, Problems in record-oriented models, Object data model, Classes and inheritance, Methods and messages, Multiple inheritance, Object queries, Object query language OQL, Indexing in object databases, Processing object queries, Object transactions, Concurrency control in object databases, Security in object databases, Using the object model in advanced applications.

IS 453 Information Systems Development Methodology

نال 453 منهجيات تطوير نظم المعلومات                                                                        

This module aims at enabling the students to understand the broad principles and concerns that underpin a range of traditional and modern information systems and software development methodologies. This understanding is necessary for the student to be able to compare and contrast current and future tools, techniques, methodologies and life cycle models that are aimed at supporting the information systems engineer in producing satisfactory information systems on time and within budget. This understanding will help the student in choosing as well as configuring his or her own methods and technique tool kit in response to a particular information systems development situation.

IS 442 E-Commerce                                                                                                  

نال  442التجارة الالكترونية

The course addresses what electronic commerce is, how it is being conducted and managed, and its major opportunities, limitations, issues,  and risks,  taking a managerial  orientation  and interdisciplinary approach.  It contains sections on applications, supporting electronic commerce, technological infrastructure, and advanced topics like global electronic commerce and future directions.  It emphasizes E-Commerce Application and Implementation through Business Models and Technology Essentials.

IS 447 E-Business                                                                      الأعمال الإلكترونية   447 نال

Basic concepts of E-Business ; Enterprise Resources planning  ;   Business on the internet ; Basics of E-Commerce ; Development of E- Business ; E-Business requirements ;  Tools for E- Business ;  Case studies and applications.

IS 434 Quality Assurance of Information Systems and Programming             

نال 434 تأكيد جودة البرمجيات ونظم المعلومات                  

The aim of this course is to apply quality assurance requirements in all the systems development life cycle phases : IS planning – IS detailed analysis – IS design – IS construction & Software Engineering – IS implementation – IS testing – IS  documentation – IS installation – IS maintenance & Follow-up. Also, the course will cover the Capability Maturity Model (CMM) requirements regarding quality assurance.

IS 435 Information Centres Management                                                                   

نال435 إدارة مراكز المعلومات                                                                                 

Operations in information centres, organisational structure and management functions. personnel recruitment, advancement and appraisal. Budgeting, charges and financial analysis. Site selection and preparation, Hardware and Software acquisition. Information centre standards, procedures and workflow. Job scheduling, resource allocation , users’ needs, data communication and performance evaluation. IS project management techniques, project appraisal and selection.

IS 422 Data Warehouses              

نال422 مستودعات البيانات                            

Introduction to Data Warehousing, Evolution of DSS, DW General Topics, Data Warehouse Structure: Granularity, Data Warehouse Design, Building Dimensional DW, OLAP tools, Aggregates, ELT- Extraction/Transformation/ Load processes and tools, Issues of DW Architecture, Enterprise DW vs. Data Marts, DW and Data Mining

IS 332 Business Functions Classification

نال 332 التقسيم الوظيفى للأعمال     

A business firm is a formal complex organization that delivers products or services and seeks to maximize profits. A business model may include employees, departments, products, customers, accounts, vendors, suppliers, orders, warehouses, and so forth. A business works in a complex environment. This course helps the student to understand such a model and environment. This understanding is essential for the student who is going to develop information systems to serve the business. The major business functional areas include: manufacturing and production systems, sales and marketing systems, finance and accounting systems, and human resources system.  The course covers the details and particularities of these systems. The input, processing, and output components of each system will be studied.

IS 454 Information Engineering                                                  454 هندسة المعلومات  نال  

Basic Concepts of Information Engineering ; Information Architecture ; Information Engineering Projects ; Informatics Strategic Planning ; Development of Strategic Models ; Business Process Re-engineering ; IT Security and Quality ; IT Quality Standards ; Information Plans ; IRM ; Information Distribution and Integrity ; National and International Information Policies ; Human and Social Aspects of Information Engineering.

IS 444 Multimedia Information Systems

نال 444 نظم معلومات لوسائط المتعددة                                                                                   

Multi dimensional data structure (K-d tree, Point trees, M-X trees and R trees). Image database and the different techniques of compression and segmentation. An overview about the text/document database, Video database and Audio one.

IS 446 Internet Information Systems

نال 446 نظم معلومات الشبكة الدولية                                                                                

This course is the advanced course of the last one, after this course we can learn ASP, ASP. Net, how to connect a different types of database (Oracle, SQL server and access) with my home page, java applet and application and in the end we can see the Internet security and the interface design.

IS 451 Decision Support Systems

نال 451 نظم دعم اتخاذ القرار

Problem solving, decision-making process , model building , types  of  computer based information systems Approaches and techniques to construct and implement an effective computer-based Decision Support Systems (DSS). Alternative software development tools or generators of a DSS. The role of computational tools (simulation, optimization, statistical and other quantitative models) and computer information systems (MIS, AI and ES) to support and enhance the capability of the DSS. Discussion and analysis of real life case studies of integrated DSS is stressed throughout the course.

IS396 Selected Topics in Software Engineering

نال 396 موضوعات مختارة فى هندسة البرمجيات                                                               

This course aims at introducing students to novel topics in software engineering that need to be identified in a responsive manner as technology and its use evolve and develop. This course is essentially a flexibility enhancing will be filled on a year-by-year basis.

IS 498 Project                                                                               نال 498 مشروع

This component is Final Year BSc project, which is essentially an exercise in systematic independent study and work, which must be executed and reported on to a satisfactory standard. The project provides students with the experience of planning and bringing to fruition a major piece of individual or group work. The module aims to encourage and reward creativity, initiative, intellectual discipline, clarity of communicating ideas and application of effort. Group projects also give the students a valuable experience of co-coordinating work with and organizing a group that aims at a technical product. A wide range of tasks can be undertaken, but almost always leading to the implementation of an information system, software or other information technology artifact.