Systems Analysis and Design - CIS54

Professor: Priscilla Grocer

Course Description: Systems analysis and design from the programmer's perspective is the focus of this course. Emphasis is placed on today's tools for analyzing business problems, designing solutions and documenting the results. The student will learn the effective use of systems tools, the use and integration of microcompute applications, and develop an understanding of the analysis and design process.

COURSE OBJECTIVES: The objective of this course is to teach the student about the area of systems analysis and design and to develop abilities in this area. At the completion of this course, the following objectives should have been accomplished:

• the student should understand how an analyst does a preliminary and detailed analysis
• the student should understand how an analyst does a systems design
• the decision should be able to work with PERT, CPM and other project charts/tools
• the decision should be able to make and use decision tables and other logical tools
• the student should have a better understanding of how to logically analyze problems
• the student should understand protyping including the use of an application generator to develop prototype examples
• the student should understand and be able to use SQL to gain information from a database
• the student should know how to read and draw a decision flow diagram and a systems flowchart
• the student should understand the use of a CASE tool
• the student should understand the use of presentation tools
• the student should know how to design input, output and files (including relational databases) as well as processing
• the student should understand the design process of a normalized relational database
• the student should know how to effectively and completely document a system
• the student should understand the testing and implementation of a system and the role of the programmer and analyst in these steps
• the student will build on the information in this course and in previous coures to develop an understanding of how a computer can be effectively used in a business environment
• the student should be able to use a standard business package to set up a model system
• the student should learn about software evaluation using typical business solution packages
• e-commerce and its impact

Systems Analysis and Design
Shelly, Cashman and Adamski
Shelly Cashman Series
Course Technologies

1. Introduction to Systems Development
2. Preliminary Investigation
3. Systems Analysis
4. Analyzing Requirements
   1. Data Flow Diagrams
   2. Data Dictionaries
   3. Logic tools - emphasis on decision tables
5. Completing the Systems Analysis Phase and Considering Alternative Tools
   1. Prototyping
   2. Application generator as a prototyping tool
6. Output Design
7. Input Design
8. File Concepts
9. File and Database Design
10. Software Design and Completing the Systems Design Phase
11. Project Management and Costs
12. Programming, Testing and Documentation
13. Systems Implementation and Evaluation
14. Systems Operation

1. e-commerce
2. relational database design
3. SQL
4. Presentation Graphics
5. Accounting Package
6. Other Business Packages
7. Software Projects
8. Systems Projects
9. Internet Projects

REQUIREMENTS AND GRADING:

The student will be expected to complete all assigned work. Homework assignments will be due in two class days, other projects and papers will have an assigned due date. There will be approximately two assignments per week. In addition there will be a final exam.

Homework/Projects/Papers:	80%
Class participation, responsibility about work, keeping up to date, quality of work, adding extras that are above and beyond, showing initiative, figuring out problems etc.:	10%
Final:	10%

Grading: The instructor reserves the right to change these percents in certain appropriate cirdcumstances. Grading will be based on A (90-100), B (80-89), C (70-79), D(60-69, F below 60).