Skip to main content

Search Bar Icon Close Menu

Online classes

Effective: Late Fall 8-Week, 2018/2019

CISS 280: Systems Analysis & Design I

Course Description

The first in a two-course sequence (CISS 320), this course explores requirements and methods for documenting and analyzing existing business information systems; includes investigation and development of alternative solutions.  

Prerequisite: CISS 234 or CISS 238 or CISS 241

Proctored Exams: Final



Syllabus Contents

Textbooks

Required

  • Whitten, Jeffrey and Lonnie Bentley. Introduction to Systems Analysis and Design Methods. 7th. McGraw-Hill, 2007.
    • ISBN-978-0-07-305233-5

MBS Custom Version of the Required Text

Whitten, Jeffrey L and Lonnie Bentley. Systems Analysis and Design I. 7th. McGraw-Hill, 2007.

ISBN: 978-1-307-02331-2


This ISBN is for a custom e-book that consists of the first half of Introduction to Systems Analysis and Design Methods, which covers all that is required for this course.  The second half of this text is used in CISS 320, and that course also has a custom e-book that consists of the necessary chapters.   

MBS Information

Textbooks for the course may be ordered from MBS Direct. You can order

For additional information about the bookstore, visit http://www.mbsbooks.com.


Course Overview

Welcome to Systems Analysis and Design I!  The information we are going to exchange in the context of this course will enable all of us to appreciate the complexity of information systems and their role in assisting decision making in a business setting.  Information system refers broadly to a computer-based system that provides managers with the tools for organizing, evaluating and efficiently running their departments.  In order to provide past, present and prediction information, an information system can include software that helps in decision making, data resources such as databases, the hardware resources of a system, decision support systems, people/project management applications, and any computerized processes that enable the department to run efficiently.  Your participation is vital to not only your understanding of the material, but also to add to your fellow classmates understanding of principals and concepts.  In addition to your own “book” work, the instructor will be sending you out to the Internet for material vital to this discipline.  Together we can make this a great learning experience.  



Technology Requirements

Participation in this course will require the basic technology for all online classes at Columbia College:
  • A computer with reliable Internet access
  • A web browser
  • Acrobat Reader
  • Microsoft Office or another word processor such as Open Office

You can find more details about standard technical requirements for our courses on our site.


Course Objectives

  • To understand information systems and the systems development life cycle from a management perspective.
  • To examine the structured tools and techniques used to analyze and document business information systems.
  • To learn techniques for fact-finding, oral and written communications, and cost-benefit systems.

Measurable Learning Outcomes

  • 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 methods used to define the logic associated with all data flow diagram processes.
  • Discuss the importance of evaluating project feasibility and how to perform cost based analysis.

Grading

Grading Scale
Grade Points Percent
A 900-1000 90-100%
B 800-899 80-89%
C 700-799 70-79%
D 600-699 60-69%
F 0-599 0-59%
Grade Weights
Assignment Category Points Percent
Discussions (10) 150 15%
Dropbox Assignments (20) 400 40%
Case Study Projects (3) 100 10%
Research Paper 100 10%
Midterm Exam 100 10%
Final Exam 150 15%
Total 1000 100%


Schedule of Due Dates

Week 1
Assignment Points Due
Introductions - Wednesday/Sunday
Discussions 1 & 2 30 Wednesday
Dropbox Assignments 1 & 2 40
Dropbox Assignments 3 & 4 40 Sunday
Week 2
Assignment Points Due
Discussions 3 & 4 30 Wednesday/Sunday
Dropbox Assignments 5 & 6 40 Wednesday
Dropbox Assignments 7 & 8 40 Sunday
Research Paper Topic -
Proctor Information N/A
Week 3
Assignment Points Due
Discussion 5 15 Wednesday/Sunday
Dropbox Assignment 9 20 Wednesday
Dropbox Assignment 10 20 Sunday
Case Study Project 1 33
Week 4
Assignment Points Due
Discussion 6 15 Wednesday/Sunday
Dropbox Assignment 11 20 Wednesday
Dropbox Assignment 12 20 Sunday
Midterm Exam 100
Week 5
Assignment Points Due
Discussion 7 15 Wednesday/Sunday
Dropbox Assignment 13 20 Wednesday
Dropbox Assignment 14 20 Sunday
Case Study Project 2 33
Week 6
Assignment Points Due
Discussion 8 15 Wednesday/Sunday
Dropbox Assignment 15 20 Wednesday
Dropbox Assignment 16 20 Sunday
Week 7
Assignment Points Due
Discussion 9 15 Wednesday/Sunday
Dropbox Assignment 17 20 Wednesday
Dropbox Assignment 18 20 Sunday
Case Study Project 3 34
Research Paper 100
Week 8
Assignment Points Due
Discussion 10 15 Wednesday/Saturday
Dropbox Assignment 19 20 Wednesday
Dropbox Assignment 20 20 Saturday
Final Exam 150
Total Points 1000

Assignment Overview

Readings

Text and website readings should be completed prior to submitting assignments for the week.

Discussions

Discussion postings should be completed by Wednesday of each assigned week, and responses to at least three (3) classmates should be posted by Sunday of the assigned week.

Dropbox Assignments

Dropbox Assignments are written assignments designed to deepen your understanding of specific information/concept(s).  The link for Dropbox 1 will not be visible until you read the instructions in the Content section.  To complete the assignments, you will need to read the Dropbox Assignment Instructions in the Content area for each week. Be sure to read the assignment instructions three times in order to fully understand all the details that you are required to submit. Bulleted or numbered lists are not acceptable. Meaningful paragraphs composed of well-formatted sentences with appropriate flow are expected. Be sure to restate the question in your answers in order to ensure you cover all of the material requested. There is no minimum page limit for this assignment. References should be included and properly cited when appropriate.


Case Study Projects

During this course, you will read, study, and analyze one case study by completing three, distinct projects. The case study will be broken into the following three groups: Introduction and Milestone 1; Milestones 2 and 3; and Milestone 4. Each project must be submitted to the correct Dropbox folder. These projects will require you to download a file and complete required analysis and deliverables as specified. Be prepared to read ahead in the textbook to gain background knowledge. Full instructions on which chapters to read will be detailed in the individual Case Study Project assignments. You will use Word, Excel and PowerPoint to complete these assignments.  Assignment instructions and the files you will need are located in the Content area under the appropriate weekly module.

Research Paper

This paper is to fulfill a key requirement in the class. The length of your paper should be a minimum of 10 full pages, double spaced.  There are penalties for papers that are short of the length requirement.  See the Research Paper Rubric.  The cover page and bibliography are not to be included in this page count; but both are required. An abstract is your choice, but again not included in the page count.  Late papers are not accepted.  Paper must be original work. Papers that have been submitted to other classes are not acceptable.

Use MLA or another compatible citation style. The font size is limited to 12, with one-inch margins all around. Images should be limited and must be of reasonable size. You must site from 5 to 7 references.  If you use an internet source, it must have a valid URL associated with it. Your textbook is not to be used as a reference.  

Examinations

There will be a midterm and a final exam. The final exam is proctored. Each exam will have a 2-hour time limit. You will have one attempt on each exam; be sure to save your work often.  The midterm exam will be open from 8:00 a.m. Wednesday until midnight Sunday of Week 4. This exam is comprised of 25 multiple-choice questions that cover Chapters 1-6. The final exam will be open from 8:00 a.m. Tuesday until 6:00 p.m. Saturday of Week 8. This exam is comprised of 50 multiple-choice questions. The final exam is comprehensive, but will concentrate on Chapters 7–9 and 11.


Course Outline

Click on each week to view details about the activities scheduled for that week.

Week 1: The Context of Systems Analysis and Design Methods
Readings
  • Chapter 1: The Context of Systems Analysis Designs and Methods
  • Chapter 2:  Information System Building Blocks
Introductions
  • Introduce yourself to your classmates.  Write about you and your family, work history, where you are in school and what your hobbies or interests are.  
Discussions 1 & 2
  • Question 1: Review Questions: Number 8 page 37
    In addition to the business and computing knowledge that system analysts should possess, what are the other essential skills that they need to effectively complete their jobs? 
  • Question 2: Review Questions: Number 2 page 61
    How do transaction processing systems (TPSs), management information systems (MISs), and decision support systems (DSSs) interact with each other? 
Dropbox Assignments 1 & 2
  • Dropbox 1: Problems and Exercises: Number 5 page 38
    As information systems increase in complexity and comprehensiveness, ethical issues regarding accessing and using data from these systems are also increasing. What are some of these ethical issues?  Please submit by midnight Wednesday.
  • Dropbox 2: Problems and Exercises: Number 12 page 38
    Industry studies indicate that mobile and wireless technology has become one of the major technology drivers for designing new information systems. Why is this the case and what is the impact? Please submit by midnight Wednesday.
Dropbox Assignments 3 & 4
  • Dropbox 3: Problems and Exercises: Number 1 page 61
    Companies generally need to use more than one information system to support all their different business functions. These functions are frequently referred to as either front- office information systems or back- office systems. Define each of these two types of systems and identify some of the typical business functions sup-ported by them. Please submit by midnight Sunday.
  • Dropbox 4: Problems and Exercises: Number 6 page 61
    Assume you are designing a retail point-of-sale (POS) system for your company. What are the typical system interfaces of a point-of-sale system that need to be taken into account in designing the POS system? Please submit by midnight Sunday.
Week 2: Information Systems Development
Readings
  • Chapter 3: Information Systems Development
  • Chapter 4: Project Management
Discussions 3 & 4
  • Discussion 3: Problems and Exercises: Number 4 page 114
    Systems development methodology and system life cycle are two terms that are frequently used and just as frequently misused. What is the difference between the two terms?  Please submit by midnight Wednesday.
  • Discussion 4: Review Questions: Number 9 page 151
    Why is negotiating scope important? What is the deliverable in the process of negotiating the scope?  Please submit by midnight Wednesday.
Dropbox Assignments 5 & 6
  • Dropbox 5: Problems and Exercises: Number 10 page 114
    The requirements analysis phase is an essential part of a system development methodology. According to the FAST methodology, which stake-holders typically participate in this phase? What is the primary focus of requirements analysis? What is not the focus? How should each pro-posed requirement be evaluated? What critical error must be avoided? Please submit by midnight Wednesday.
  • Dropbox 6: Problems and Exercises: Number 8 page 114
    Each phase of a project includes specific deliverables that must be produced and delivered to the next phase. Using the textbooks hypothetical FAST methodology, what are the deliverables for the requirements analysis, logical design, and physical design/ integration phases? Please submit by midnight Wednesday.
Dropbox Assignments 7 & 8
  • Dropbox 7: Problems and Exercises: Number 3 page 151
    As a newly appointed project manager, you are eager to get started on your first project. What should your first activity be? How important is it? Who is typically involved? What questions do you need to make sure are answered? What’s the ultimate outcome from this activity, and what is included in this deliverable? Please submit by midnight Sunday.
  • Dropbox 8: Problems and Exercises: Number 6 page 152
    The methodology used in your organization calls for change requests to be considered by a change control board (CCB). After some reflection and a discussion with the programmer, you have decided to submit a change request to the CCB to add the new features. In your presentation to the CCB, what reason might you give for the change request and what things should you take into consideration? Please submit by midnight Sunday.
Research Paper Topic
Submit the topic for your Research Paper to the correct Dropbox folder by midnight Sunday.
Proctor Information
Submit your proctor form to the appropriate Dropbox folder by the end of the week. Remember to “Save” the form before placing it in Dropbox. See the Content area for more information.
Week 3: Systems Analysis
Readings
  • Chapter Five: Systems Analysis
Discussion 5
  • Discussion 5: Review Questions: Number 15 page 202
    What are some ways to identify candidate solutions? 
Dropbox Assignment 9
  • Dropbox 9: Problems and Exercises: Number 1 page 202
    There are many different approaches to systems analysis. Despite these different approaches, what is the universally accepted definition of systems analysis? What is the general consensus as to when systems analysis begins and when it ends? As a project manager, what is important to know regarding the definition of systems analysis, and what is important to ensure in your organization regarding the definition? Please submit by midnight Wednesday.
Dropbox Assignment 10
  • Dropbox 10: Problems and Exercises: Number 8 page 203
    What is the difference between functional and nonfunctional requirements, and what is the purpose of categorizing them into these categories? What are two formats that an analyst can use to document the functional system requirements? Please submit by midnight Sunday.
Case Study Project 1

This assignment will cover the Introduction and Milestone 1 portions of this case.  Please read the Overview & Hints for Case Study 1, Introduction: Client Technology Tracking System, Milestone 1: Scope Definition, and the case study-related material.  There are three deliverables for this assignment: 1) The Request for Systems Services, 2) The Problem Matrix and 3) The Feasibility Matrix.  Please submit your completed project by midnight Sunday.

Week 4: Fact Finding Techniques for Requirements Discovery
Readings
  • Chapter 6: Fact-Finding Techniques for Requirements Discovery
Discussion 6
  • Discussion 6: Review Questions: Number 2 page 237
    What are the possible consequences if you fail to identify system requirements correctly and completely? 
Dropbox Assignment 11
  • Dropbox 11: Problems and Exercises: Number 3 page 237
    What common error does a new systems analyst often make when analyzing a problem? What are the potential consequences of this error? What tool can be used to help avoid this problem? Please submit by midnight Wednesday.
Dropbox Assignment 12
  • Dropbox 12: Problems and Exercises: Number 11 page 238
    What are some of the reasons to use joint requirements planning (JRP) as a fact- finding technique? What should be the basis for selecting which users and managers will participate in the JRP session, and who generally selects them? What skills should the facilitator and scribe possess? What is the role of IT staff during JRP sessions? What is the typical duration of the JRP sessions? Please submit by midnight Sunday.
Midterm Exam

This exam consists of 25 multiple-choice questions that cover Chapters 1-6.   Please complete the exam by midnight Sunday.

Week 5: Modeling System Requirements
Readings
  • Chapter 7: Modeling System Requirements
Discussion 7
  • Discussion 7: Review Questions: Number 3 page 263
    In addition to encouraging user involvement, use case modeling provides numerous other benefits. Explain the benefits that use- case modeling provides. 
Dropbox Assignment 13
  • Dropbox 13: Problems and Exercises: Number 2 page 264
    In use case modeling, what two main artifacts does the systems analyst use? Describe each of these artifacts and explain their purpose. Please submit by midnight Wednesday.
Dropbox Assignment 14
  • Dropbox 14: Review Questions: Number 11 page 263
    What should we be aware of when we are looking for business requirements use cases? Please submit by midnight Sunday.
Case Study Project 2
This assignment will cover the Milestone 2 and Milestone 3 portions of this case.  Read Overview & Hints for Case Study 2, Milestone 2: Problem Analysis, Milestone 3: Modeling System Requirements, and the case study-related material.  Then, complete the templates available in the Content area.  Please submit your completed project by midnight Sunday.
Week 6: Data Modeling and Analysis
Readings
  • Chapter 8: Data Modeling and Analysis
Discussion 8
  • Discussion 8: Review Questions: Number 3 page 311
    Why is it necessary to create an implementation-dependent model of a system? 
Dropbox Assignment 15
  • Dropbox 15: Review Questions: Number 5 page 311
    A relationship is a natural business association between entities. What is the relationship between student and teacher? Does it depend on how many classes a student can take, or how many classes a teacher can teach? Please submit by midnight Wednesday.
Dropbox Assignment 16
  • Dropbox 16: Projects and Research: Number 3 page 311
    Go to a grocery store and make a purchase. What type of data would a good information system maintain on a transaction? What does a good information system do for a business? Please submit by midnight Sunday.
Course Evaluation
Please evaluate the course. You will have an opportunity to evaluate the course near the end of the session. A link sent to your CougarMail will allow you to access the evaluation. Please note that these evaluations are provided so that I can improve the course, find out what students perceive to be its strengths and weaknesses, and in general assess the success of the course. Please do take the time to fill this out.
Week 7: Process Modeling and Analysis
Readings
  • Chapter 9: Process Modeling
Discussion 9
  • Discussion 9: Review Questions: Number 14 page 362
    What process model is used to document the scope for an information system, and what is depicted in this process model?
Dropbox Assignment 17
  • Dropbox 17: Problems and Exercises: Number 3 page 363
    In a decomposition diagram, how do you show one child for a parent, and how do you show more than one parent for a child? Why don’t the connections on a decomposition diagram show arrowheads, like most other diagrams? Why aren’t the connections named? Please submit by midnight Wednesday.
Dropbox Assignment 18
  • Dropbox 18: Projects and Research: Number 1 on page 364
    Suppose you are starting work on a project for an organization that has never used any modeling techniques or tools in designing a system. (Yes, it is hard to imagine, but it does exist.) Your manager is reluctant to change from the way they have always done things. Write a one- to two-page issue paper (or a PowerPoint presentation as an alternative) on why systems modeling is worth the time and resources involved. Please submit by midnight Sunday.
Case Study Project 3

This assignment will cover the Milestone 4 portions of this case.  Read Overviews & Hints for Case Study 3, Milestone 4: Data Modeling, and the case study-related material.  Prepare the template as instructed through the reading.  Note: if you do not have drawing software for the Use Model, you can complete this exercise on regular paper, scan the document, and send it via email.  Please submit your completed project by midnight Sunday.

Research Paper
Submit your Research Paper via the appropriate Dropbox folder by midnight Sunday.
Week 8: Feasibility Analysis and the System Proposal
Readings
  • Chapter 11:  Feasibility Analysis and the System Proposal
Discussion 10
  • Discussion 10: Review Questions: Number 7 page 438
    What are the characteristics of development costs and operating costs? List three examples of each kind of cost. 
Dropbox Assignment 19
  • Dropbox 19: Problems and Exercises: Number 3 page 438
    What are the six categories of feasibility tests, and what are the criteria each of them uses to measure feasibility? Please submit by midnight Wednesday.
Dropbox Assignment 20
  • Dropbox 20: Problems and Exercises: Number 4 page 438
    You are a systems designer on a project which is getting close to finishing the systems design phase. A working prototype has been developed, and you’ve been tasked with doing a usability analysis. Draft a one- or two-page plan detailing your approach to conducting the usability analysis. You will have to do outside research (Google) to fully prepare your answer.  Please submit by midnight Saturday.
Final Exam
This proctored exam consists of 50 multiple-choice questions that cover all chapters, but concentrates on Chapters 7-9 and 11.  The exam will be open on Tuesday 8:00 am of the final week.  Please complete the exam by 6:00 pm Saturday.


Course Policies

Student Conduct

All Columbia College students, whether enrolled in a land-based or online course, are responsible for behaving in a manner consistent with Columbia College's Student Conduct Code and Acceptable Use Policy. Students violating these policies will be referred to the office of Student Affairs and/or the office of Academic Affairs for possible disciplinary action. The Student Code of Conduct and the Computer Use Policy for students can be found in the Columbia College Student Handbook. The Handbook is available online; you can also obtain a copy by calling the Student Affairs office (Campus Life) at 573-875-7400. The teacher maintains the right to manage a positive learning environment, and all students must adhere to the conventions of online etiquette.

Plagiarism

Your grade will be based in large part on the originality of your ideas and your written presentation of these ideas. Presenting the words, ideas, or expression of another in any form as your own is plagiarism. Students who fail to properly give credit for information contained in their written work (papers, journals, exams, etc.) are violating the intellectual property rights of the original author. For proper citation of the original authors, you should reference the appropriate publication manual for your degree program or course (APA, MLA, etc.). Violations are taken seriously in higher education and may result in a failing grade on the assignment, a grade of "F" for the course, or dismissal from the College.

Collaboration conducted between students without prior permission from the instructor is considered plagiarism and will be treated as such. Spouses and roommates taking the same course should be particularly careful.

All required papers may be submitted for textual similarity review to Turnitin.com for the detection of plagiarism. All submitted papers may be included in the Turnitin.com reference database for the purpose of detecting plagiarism. This service is subject to the Terms and Conditions of Use posted on the Turnitin.com site.

Non-Discrimination

There will be no discrimination on the basis of sex, race, color, national origin, sexual orientation, religion, ideology, political affiliation, veteran status, age, physical handicap, or marital status.

Student Accessibility Resources

Students with documented disabilities who may need academic services for this course are required to register with the office of Student Accessibility Resources. Until the student has been cleared through this office, accommodations do not have to be granted. If you are a student who has a documented disability, it is important for you to read the entire syllabus as soon as possible. The structure or the content of the course may make an accommodation not feasible. Student Accessibility Resources is located in Student Affairs in AHSC 215 and can be reached by phone at (573) 875-7626 or email at sar@ccis.edu.

Online Participation

You are expected to read the assigned texts and participate in the discussions and other course activities each week. Assignments should be posted by the due dates stated on the grading schedule in your syllabus. If an emergency arises that prevents you from participating in class, please let your instructor know as soon as possible.

Attendance Policy

Attendance for a week will be counted as having submitted any assigned activity for which points are earned. Attendance for the week is based upon the date work is submitted. A class week is defined as the period of time between Monday and Sunday (except for week 8, when the work and the course will end on Saturday at midnight.) The course and system deadlines are based on the Central Time Zone.

Cougar Email

All students are provided a CougarMail account when they enroll in classes at Columbia College. You are responsible for monitoring email from that account for important messages from the College and from your instructor. You may forward your Cougar email account to another account; however, the College cannot be held responsible for breaches in security or service interruptions with other email providers.

Students should use email for private messages to the instructor and other students. The class discussions are for public messages so the class members can each see what others have to say about any given topic and respond.

Late Assignment Policy

An online class requires regular participation and a commitment to your instructor and your classmates to regularly engage in the reading, discussion and writing assignments. Although most of the online communication for this course is asynchronous, you must be able to commit to the schedule of work for the class for the next eight weeks. You must keep up with the schedule of reading and writing to successfully complete the class.

No late discussion posts will be accepted.

Late assignments will only be accepted with prior approval by the instructor.  Unapproved late assignments cannot receive full credit.  The amount of the deduction will be determined by how long the assignment is overdue.  Twenty percent (20 %) will be deducted for each 24 hours past the due date.  The only exception to the above is the Research Paper Assignment.  Because of the normal increased load at the end of a term, research papers must be turned in on time.  Late papers are not accepted for any reason.

Course Evaluation

You will have an opportunity to evaluate the course near the end of the session. A link will be sent to your CougarMail that will allow you to access the evaluation. Be assured that the evaluations are anonymous and that your instructor will not be able to see them until after final grades are submitted.

Proctor Policy

Students taking courses that require proctored exams must submit their completed proctor request forms to their instructors by the end of the second week of the session. Proctors located at Columbia College campuses are automatically approved. The use of ProctorU services is also automatically approved. The instructor of each course will consider any other choice of proctor for approval or denial. Additional proctor choices the instructor will consider include: public librarians, high school or college instructors, high school or college counseling services, commanding officers, education service officers, and other proctoring services. Personal friends, family members, athletic coaches and direct supervisors are not acceptable.


Additional Resources

Orientation for New Students

This course is offered online, using course management software provided by Desire2Learn and Columbia College. The course user guide provides details about taking an online course at Columbia College. You may also want to visit the course demonstration to view a sample course before this one opens.

Technical Support

If you have problems accessing the course or posting your assignments, contact your instructor, the Columbia College Helpdesk, or the D2L Helpdesk for assistance. Contact information is also available within the online course environment.

Online Tutoring

Smarthinking is a free online tutoring service available to all Columbia College students. Smarthinking provides real-time online tutoring and homework help for Math, English, and Writing. Smarthinking also provides access to live tutorials in writing and math, as well as a full range of study resources, including writing manuals, sample problems, and study skills manuals. You can access the service from wherever you have a connection to the Internet. I encourage you to take advantage of this free service provided by the college.

Access Smarthinking through CougarTrack under Students -> Academics -> Academic Resources.


+

Request info