Discipline: Computer Information Systems Degree Credit  [X]
Non Credit  [ ]
Nondegree Credit  [ ]
Comm Service  [ ]
 

Riverside Community College District
Integrated Course Outline of Record

Computer Information Systems 20


COURSE DESCRIPTION
20 Systems Analysis and Design Units: 3.00
 
Prerequisite(s):
CIS-2.

Advisory: Students should have a working knowledge of MS Access
Structured design techniques for the development and implementation of computerized business applications. Course includes project planning, analysis of current system, design of a new system, implementation, consideration of data base design and development; file organization, and modular programming techniques. 54 hours lecture and 18 hours of laboratory.
 
SHORT DESCRIPTION FOR CLASS SCHEDULE
Exposure to the techniques used in the development of effective computer systems for business applications.
 
ADVISORY ENTRY SKILLS
Before entering the course, students will be able to:
  1. Have a good understanding of Systems Analysis as applied to the effective use of computers in the business world, and be able to apply the techniques of structured analysis.

  2. Have a good working knowledge of MS Access equivalent to CIS 62, as the course ends with students developing an information system using MS Access.
STUDENT LEARNING OUTCOMES
 Upon successful completion of the course, students should be able to:

1.   Demonstrate an understanding of System Architecture,
      Implementation, Operations, Support and Security.

2.   Create cost benefit analysis using various tools available to
      compare alternative Developmental methodologies.

3.   Demonstrate an understanding of Project Management tools like
      Gantt Charts and PERT/CPM Charts.

4.   Evaluate some of the CASE tools currently available on the market.

5.   Convert the analysis and design specifications into a working
      model of a business information system.
 
COURSE CONTENT
  TOPICS
 

1.   Review of Structured Analysis Concepts
      a.   Convert the user’s problem definition to a logical design of the
            required system using the tools available in structured
            methodology
2.   System Architecture
      a.   Enterprise Resource Planning:
            1.   Total Cost of Ownership
            2.   How to interface with Legacy Systems
      b.   Client/Server
      c.   Internet based and E-commerce
      d.   Processing methods
            1.   Online
            2.   Batch
      e.   Network models
      f.   Completion of System Design
3.   System Implementation
      a.   Software Quality Assurance and ISO
      b.   Application Development
            1.   Steps for Design to Development
            2.   Tools: Structure Charts, Cohesion and Coupling
            3.   Object Oriented Design and Development
      c.   Coding: Program Development
      d.   Testing the programs and the system
      e.   Four levels of Documentation
      i.   Program, System, User, Operations
      f.   System Installation and Evaluation
      g.   Importance of Training and various methodologies
      h.   Data conversion: from old to new
      i.   System Changeover methods: direct, parallel, pilot, phased
4.   Systems Operation, Support and Security
      a.   Maintaining the System:
            1.   Corrective, Adaptive, Perfective, Preventive
            2.   Priorities, Releases, Versions
      b.   Managing System Performance
      c.   Security: Network, Application, File, User
      d.   Backup and Disaster Recovery Management
5.   Tools
      a.   Communication
      b.   CASE
      c.   Financial Analysis
      d.   Project Management
      e.   Object Oriented
      f.    Internet Resource
6.   Project Development
      a.   Convert a narrative to a logical design
      b.   Create a Requirements Analysis report
      c.   Create a physical design of the system
      d.   Create a model of the system in MS Access
 
METHODS OF INSTRUCTION
 Methods of instruction used to achieve student learning outcomes may include, but are not limited to:

  • Lectures and discussions on how businesses use Information Systems to control their business operations
  • Computer games on the author/publisher’s web site  to enhance the understanding of structured design concepts like System Architecture
  • PowerPoint presentations on the Project Management and CASE tools
  • Demonstration of a working system in MS Access (Northwind.mdb) to illustrate good design methods.
  • Use of discussions and discussion board to make students interact on specific topics like System Security
  • Handouts to reinforce understanding of various topics like the various steps of System Implementation
  • Class exercises on various topics like the use cost benefit analysis
  • Cooperative learning tasks to encourage teamwork and leadership skills
  • Individual conferences as necessary to assist with problems students may be having
  • Guest lecturers from industry to demonstrate system analysis and design uses in the workplace
  • Distance Education: Online, Hybrid, and Web Enhanced
 
METHODS OF EVALUATION
 Students will be evaluated for progress in and/or mastery of learning outcomes by methods of evaluation which may include, but are not limited to:

  • Oral reports/presentations
  • Written reports at various key stages of structured analysis: the preliminary investigation and the requirements analysis stages
  • Quizzes for each of the concepts of Structured Development
  • Written answers to Review Questions to confirm the understanding of basic concepts of Structured Design like Systems Operations, Support and Security
  • Case studies to determine how the student applies structured concepts to analyze business situations as related to Information Technology
  • Assignments dealing with the use of Project Management and CASE tools
  • Situation analysis to determine student critical thinking skills in various topics like Cost Benefit Analysis
  • Participation in classroom or online discussion board on various topics covered in the class
  • Development of a working Information System based on analysis notes and discussions provided in the class
  • Final examination to demonstrate students’ ability to explain and apply techniques used in the development of effective computer systems for business applications
ASSIGNMENTS

Required Reading Assignments


Required Writing Assignments


Other Outside-of-Class Assignments
 
COURSE MATERIALS
 All materials used in this course will be periodically reviewed to ensure that they are appropriate for college level instruction. Possible texts include:

  • Shelly, Gary, Cashman, Thomas and Harry Rosenblatt. Systems Analysis and Design. 7th ed. Boston, MA: Thompson Course Technology, 2007.
  • Adamski, Joseph, and Kathleen Finnegan. Microsoft Access 2003 . 2nd ed. Boston: Course Technology, 2006.
11/06
525