This course explores the structured tools, techniques, methodologies, and the system development life cycle used to plan, analyze, design, implement/build, and maintain computer information systems. Prerequisite: CISS 234 or CISS 238 or CISS 240.
Prerequisite(s) / Corequisite(s):
CISS 234 or CISS 238 or CISS 240.
Course Rotation for Day Program:
Most current editions of the following:
Systems Analysis and Design
By Kendall & Kendall (Prentice Hall) Recommended
Systems Analysis and Design Methods
By Whitten, Bentley,& Barlow ( Irwin/McGraw-Hill) Recommended
Systems Analysis and Design in a Changing World
By Satzinger, Jackson, & Burd (Course Technologies, Inc.) Recommended
Introduction to Systems Analysis and Design: A Structured Approach
By Kendall, Penny (Business and Educational Technologies.) Recommended
Systems Analysis, Design and Implementation
By Burch (Boyd and Fraser) Recommended
To understand information systems and the systems development life cycle from a business perspective.
To examine the structured tools and techniques used to analyze and design business information systems.
To learn techniques for fact-finding, oral and written communications, feasibility analysis, and project management.
Explain intelligently the purpose of structured systems analysis and design.
Identify the common phases associated with the software/systems development life cycle.
Explain the importance of information to an organization and why and how it should be managed as any other resource owned by the organization.
Identify and describe common types of information systems.
Explain when and why data sampling should occur during systems analysis and design.
Explain the creation of effective interviews and questionnaires.
Identify the function of entity relationship diagrams in structured systems analysis and design.
Define the function of data flow diagrams in structured systems analysis and design.
Identify common mistakes that occur when creating data flow diagrams.
Explain the common methods used to define the logic associated with all data flow diagram processes.
Create CRUD synchronization matrixes for data/process, data/location, and process/location.
Explain the importance of program management during structured systems analysis and design.
Explain the importance of evaluating project feasibility and how to perform cost-based analysis.
Explain the function provided by both the request for proposal and the request for comment.
Explain those tasks that occur during systems implementation.
Identify those tasks that occur during systems maintenance.
Introduction to structured systems analysis and design - The need for structured systems analysis and design - The Systems Development Life Cycle (SCLC)
The systems analyst and information systems stakeholders - System analyst skills - Information system stakeholders and their roles
Business and information systems - Understanding information as a resource - Understanding the structure of organizations - Understanding the culture of organizations - Types of information systems - Electronic commerce (E-commerce) and the World Wide Web
Using CASE tools - Upper CASE tools - Lower CASE tools
Gathering user requirements and information analysis - Data sampling - Interviewing techniques - Creating questionnaires - Observing stakeholders and their environment(s) - Prototyping - Joint Application Development (JAD) - Rapid Application Development (RAD)
Data modeling - Entity relationship diagrams
Process modeling - Data flow diagrams - Structured english - Decision tables - Decision trees
CRUD synchronization matrices
Data dictionaries and information system metadata
Project management - Gantt charts and PERT diagrams
Feasibility and cost benefit analysis
Economic, technical, schedule, and operational feasibility
Preparing and writing system proposals - Request for Proposal (RFP) - Request for Comment (RFC) - Working with HW/SW vendors
Systems design - Building and testing databases and files - Building and testing network infrastructure - Writing and testing programs - Installing and testing purchased software
Systems implementation - Testing - Conversion planning - User training
Systems maintenance - Systems enhancement - Reengineering - Reverse engineering - System failure recovery - Technical support
Recommended maximum class size for this course: 30
NOTE: The intention of this master course syllabus is to provide an outline of the contents of this course, as specified by
the faculty of Columbia College, regardless of who teaches the course, when it is taught, or where it is taught. Faculty members teaching this
course for Columbia College are expected to facilitate learning pursuant to the course objectives and cover the subjects listed in the topical
outline. However, instructors are also encouraged to cover additional topics of interest so long as those topics are relevant to the course's
subject. The master syllabus is, therefore, prescriptive in nature but also allows for a diversity of individual approaches to course material.