Effective: Early Spring 8-Week 2018/2019

CISS 320: Systems Analysis & Design II

Back to Top

  Course Description

CISS 320 is a continuation of CISS 280. The course explores the design and implementation of information systems, selection of alternatives, object-oriented design techniques and ISO 9001 software quality assurance mechanisms. 

Prerequisite: CISS 280 with a grade of C or higher

Proctored Exams: Final



  • 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 II. 7th. McGraw-Hill, 2007.

ISBN: 978-1-307-02332-9

This ISBN is for a custom e-book that consists of the second half of Introduction to Systems Analysis and Design Methods, which covers all the material needed for this course.  

Textbook Resources

Be sure to take advantage of the textbook’s Online Learning Center as soon as you receive your text. 

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

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.

Audio equipment is required for this course.  Examples are a microphone built into a laptop, a microphone from a webcam, plug-in headset or a USB microphone.

  Course Learning Outcomes

  1. Develop moderately complex programs for a business problem.
  2. Present alternative solutions to a business problem.
  3. Present recommendations to a business problem in a written report and oral presentation.
  4. Write user manual for computer programs.
  5. Write technical document for computer programs.


Grading Scale

Grade Points Percent
A 873-970 90-100%
B 776-872 80-89%
C 679-775 70-79%
D 582-678 60-69%
F 0-581 0-59%

Grade Weights

Assignment Category Points Percent
Discussions (8) 120 12%
Dropbox Assignments (15) 300 31%
Case Study Projects (7) 200 21%
Research Paper 100 10%
Midterm Exam 100 10%
Final Exam 150 15%
Total 970 100%

  Schedule of Due Dates

Week 1

Assignment Points Due
Discussion 1 15 Wednesday/Sunday
Introductions - Wednesday
Dropbox Assignment 1 20
Dropbox Assignment 2 20 Sunday
Case Study Project 1 28

Week 2

Assignment Points Due
Discussion 2 15 Wednesday/Sunday
Dropbox Assignment 3 20 Wednesday
Dropbox Assignment 4 20 Sunday
Case Study Project 2 28
Research Paper Topic -
Proctor Information N/A

Week 3

Assignment Points Due
Discussion 3 15 Wednesday/Sunday
Dropbox Assignment 5 20 Wednesday
Dropbox Assignment 6 20 Sunday
Case Study Project 3 28

Week 4

Assignment Points Due
Discussion 4 15 Wednesday/Sunday
Dropbox Assignment 7 20 Wednesday
Dropbox Assignment 8 20 Sunday
Case Study Project 4 28
Midterm Exam 100

Week 5

Assignment Points Due
Discussion 5 15 Wednesday/Sunday
Dropbox Assignment 9 20 Wednesday
Dropbox Assignment 10 20 Sunday
Case Study Project 5 28

Week 6

Assignment Points Due
Discussion 6 15 Wednesday/Sunday
Dropbox Assignment 11 20 Wednesday
Dropbox Assignment 12 20 Sunday
Case Study Project 6 28

Week 7

Assignment Points Due
Discussion 7 15 Wednesday/Sunday
Dropbox Assignment 13 20 Wednesday
Dropbox Assignment 14 20 Sunday
Case Study Project 7 32

Week 8

Assignment Points Due
Discussion 8 15 Wednesday/Saturday
Dropbox Assignment 15 20 Wednesday
Research Paper 100 Saturday
Final Exam 150
Total Points: 970

  Assignment Overview


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


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).  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.  Your answers need to be in meaningful paragraphs composed of well-formatted sentences with appropriate flow.  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 seven, distinct projects.  The case study will be broken into the following groups: Introduction and Milestone 1; Milestone 2; Milestone 3; Milestones 4 and 5; Milestone 6; Milestone 9 and 10; and Milestone 11.  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.  You will use Word, Excel and PowerPoint and/or a drawing tool of your choice to complete these assignments.   The files you will need are located in the Content area under the appropriate weekly module.

Oral Presentation

As part of the requirements for this class you will prepare and submit an oral presentation which will be in the form of a narrated PowerPoint for the Week 2 case study.   Communication is a key element in the work place for everyone but especially so for the systems analyst.  You have to be able to express yourself in project meetings, one-on-one conversations with your stakeholders and their staff as well as your colleagues in your department.  Often you will addressing people of differing levels in the organization.   See the details for this assignment in Week Two as the second part of the running case assignment will be used.  

Research Presentation

This paper is to fulfill a key requirement in the class.  Your topic must be related to material that is covered in the class.  Submit your topic by the end of Week 2.  The reason for previewing your topic is to make sure you have the proper scope for a paper of this size. Please submit your topic via the correct Dropbox folder.

The length of your paper should be a minimum of 10 full pages, double spaced.  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.  There are point reductions for papers short of the required length.  See the Research Paper Rubric.   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 cite 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.  Late papers are not accepted.  Paper is to be original work.  Previously submitted papers are not acceptable.


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 12-15. 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 or true/false questions and 5 essay questions.  The final exam is comprehensive, but will concentrate on Chapters 16-17 and 19 and 20.

  Course Outline

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


Chapter 12: System Design

Discussion 1

Review Question 1 on page 468.   What is the essential difference between systems analysis and systems design?


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.

Dropbox Assignment 1

Review Questions page 468. What are the five high- level tasks involved in con-ducting system design for a development project to be built in- house? Due Wednesday.

Dropbox Assignment 2

Problems and Exercises page 469.  Consider the issues raised by the preceding question and write a one- or two- page policy and procedures memorandum to all systems analysts and designers in your organization regarding prototyping. Due Sunday.

Case Study Project 1

Milestones Introduction & 1: See the information in the Content area for Week 1, Case Study Project 1.  Also, review Chapter 4.  Please submit via the correct Dropbox folder by midnight Sunday.


Chapter 13: Application Architecture

Discussion 2

Review Questions No. 12 on page 512. What is the network architecture used in e- commerce? Please explain how each layer is related.

Dropbox Assignment 3

Problems and Exercises No. 1 on page 512.  You are in the middle of the system design phase for a project to develop a corporate intranet, and the project team is holding a planning meeting. One of the system users on the project, who has said very little during the meeting, finally speaks up and says, All you techies keep talking about the application architecture were going to be designing. I don’t have a clue what you’re talking about. Define and explain what application architecture is to the nontechnical system users in the group.  Due Wednesday.

Dropbox Assignment 4

Problems and Exercises No. 7 on page 512.  You are working in the IT shop of a rapidly growing organization that is planning to implement a new client/ server system. Initially, there will be slightly fewer than 100 clients, with a substantial amount of data input and data analysis activity across the network. The business drivers are to be able to get data in and to crunch it quickly. The budget for the project is robust and allows for the purchase of powerful workstations and personal computers. The designers on the team are pretty well evenly divided between a two- tiered and three- tiered client/ server architecture. They are looking to you for advice. What would you recommend? Why?  Due Sunday.

Case Study Project 2

Milestone 2: See the information in the Content area for Week 2, Case Study Project 2.  Also, review pages 133 & 134.  Please submit via the correct Dropbox folder by midnight Sunday.

Research Paper Topic

Submit your paper topic via 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.

Chapter 14: Database Design

Discussion 3

Problems and Exercises 3 on page. 544.  The textbook states that data is a resource that must be controlled and managed. Explain this statement, and indicate whether you agree or not, and why.

Dropbox Assignment 5

Problems and Exercises 2 on page 544.  Although database systems have become the systems of choice for new and reengineered systems, are there any situations where a traditional file- based system might be chosen instead? Explain your answer. Due Wednesday.

Dropbox Assignment 6

Problems and Exercises 12 on page 545.  The deletion rules for enforcing referential integrity include both Delete: Cascade and Delete: Restrict. In general, what criteria should a DBA use in deciding whether to use a Delete: Cascade or Delete: Restrict rule for deletion? Give examples of each. Due Sunday.

Case Study Project 3

Milestone 3: See the information in the Content area for Week 3, Case Study Project 3.  Also review Chapter 7.  Please submit via the correct Dropbox folder by midnight Sunday.


Chapter 15: Output Design and Prototyping 

Discussion 4

Review Question 11 on page 575.  What are the two most important kinds of criteria that analysts should consider when they specify physical output requirements? Why are they important?

Dropbox Assignment 7

Problems and Exercises 8 on page 576.  The sales manager has asked you to develop an automated chart to show the company’s annual sales by quarter for the past five years. The manager considers bar charts boring and wants to use a pie chart, instead, to show the five- year sales report in an easy- to- read report. What are your thoughts about the manager’s idea? Explain.  Due Wednesday.

Dropbox Assignment 8

Problems and Exercise 13 on page 576.  You have volunteered to work on the Web site of your local library. The library plans to develop an online catalog of books that can be reserved by library patrons from their home computers via the Internet. Many of these patrons are senior citizens. What are some of the screen design issues that should be taken into consideration? Due Sunday.

Case Study Project 4

Milestones 4 & 5: See the information in the Content area for Week 4, Case Study Project 4. Please submit via the correct Dropbox folder by midnight Sunday.

Midterm Exam
This exam consists of 25 multiple-choice or true-false questions that cover Chapters 12-15.   Please complete by midnight Sunday. This exam is not proctored.

Chapter 16: Input Design and Prototyping

Discussion 5

Review Question 7 on page 607.  Why is smart card technology able to store a tremendous amount of information? What are some examples of the applications of smart card technology?  Provide an example using a solution you have found outside the text book.

Dropbox Assignment 9

Problems and Exercises 4 on page 608, Point of sale (POS) terminals, such as those used in ATMs, gas stations, and in stores, have become extremely common due to their convenience and versatility. But in terms of human interface de-sign, their input methods sometimes leave some-thing to be desired. What are the areas where you think improvement is needed?  Due Wednesday.

Dropbox Assignment 10

Problems and Exercises 13 on page 609.  As the Internet continues to grow in its business influence, it is increasingly being used for applications that were formerly client/ server- based applications. What are some of the similarities in data input design between Web- based applications and client/ server- based applications? What are some of the differences? Give two examples of each.  Due Sunday.

Case Study Project 5

Milestone 6: See the information in the Content area for Week 5, Case Study Project 5. Please submit via the correct Dropbox folder by midnight Sunday.


Chapter 17 : User Interface Design

Discussion 6

Review Question 3 on page 641.  Why can some user interfaces cause users to feel confused, panicky, or frustrated?

Dropbox Assignment 11

Problems and Exercises 2 on page 641.  Menu- driven interfaces, although older than GUI interfaces, are still very common. What type of user dialogue strategy does a menu- driven inter-face employ? What is the main difference between menu- driven interfaces and GUI inter-faces? What is the major advantage of a menu-driven interface, and what is its major disadvantage? Due Wednesday.

Dropbox Assignment 12

Problems and Exercises 10 on page 642.  At one time, most software applications came with a thick user’s manual. Many of these users manuals have disappeared in favor of sophisticated online help systems and tutorials. If you are a systems designer designing the help system for a new application, what are some of the important considerations to keep in mind? Due Sunday.

Case Study Project 6

Milestones 9 & 10: See the information in the Content area for Week 6, Case Study Project 6. Please submit via the correct Dropbox folder 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.

Chapter 19: System Construction and Implementation

Discussion 7

Problems and Exercises 2 on page 696.  Consider a variation of the preceding (1) question. You work as a testing analyst for a software development contractor that has been engaged to develop this enterprise system. If the project is not completed on schedule, your company loses a substantial bonus. Since design and construction ran behind, you will have to cut system testing in half. Your company is putting a great deal of implicit pressure on you to compress testing so the project can finish on schedule and the company will receive its bonus. You have qualms that if testing is compressed, some serious problems may be missed, even with a risk- based testing strategy. What do you do?

Dropbox Assignment 13

Review Question 6 on page 695.  What are the three kinds of testing suggested in the textbook? Define each one.  Due Wednesday.

Dropbox Assignment 14

Projects and Research 2 on page 697. You are a systems analyst working on a major project for an organization that has several hundred employees in its headquarters office, and about a dozen offices located in this country, in Canada, and in Mexico. The objective of the project is to implement an enterprise- wide mission- critical in-formation system. The project is now in the construction and implementation phase, and you have been assigned responsibility for selecting the con-version strategy and for developing the conversion plan. Prepare a summary analysis of the different installation strategies discussed in the book, and recommend the one that you feel would be most appropriate.  Due Sunday.

Case Study Project 7

Milestone 11: See the information in the Content area for Week 7, Case Study Project 7. Please submit via the correct Dropbox folder by midnight Sunday.


Chapter 20: Systems Operations and Support

Discussion 8

Problem and Exercises 6 on page 716.  One of the common support activities occurs when a software manufacturer, such as Oracle or Microsoft, releases an updated version of one of their software packages. Often the effort to up-grade is significant, while the changes to the soft-ware appear minor. This raises the question, why upgrade? Please discuss.

Dropbox Assignment 15

Problem and Exercises 1 on page 716.  Your company has grown rapidly in the past several years, and its organizational structure has lagged behind. The CIO has asked you to reorganize the systems operation and support section of the IT shop. As you are reorganizing it, what are the four major support activities you need to be aware of, and what is a critical requirement for each of these activities regarding the staff that will be performing them? Due Wednesday.

Research Paper

Please submit your Research Paper via the appropriate Dropbox folder by Saturday midnight.

Final Exam
This proctored exam consists of 50 multiple-choice and true-false questions and 5 essay questions that cover all chapters, but concentrates on Chapters 16-17 and 19-20.   Please complete the exam by Saturday.  Note the course closes at Midnight Central Time.  No work submitted after that time will be graded.

  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.


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.


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.