Skip to main content

Search Bar Icon Close Menu

Columbia College
Evening Campus
1001 Rogers Street
Columbia, MO 65216
(800) 231-2391

COURSE SYLLABUS

17 / FALL1 - Early Fall 8-Week Session

Course Syllabus

Print this Syllabus « Return to Previous Page

Course Syllabus
17 / FALL1 - Early Fall 8-Week Session
Evening Campus
1001 Rogers Street
Columbia, MO 65216
(800) 231-2391

 
Course Prefix and Number: CISS 280
 
Course Title: Systems Analysis and Design I
 
Semester Credit Hours: 3
 
Class Day and Time: Mon 
5:30 PM-9:30 PM
Additional Notes:

There is no class September 4th, 2017 in observance of Labor day.  The make up day is Friday September 8th, 2017.

This course is web-enhanced, taught entirely in a classroom setting using D2L course management software to supplement in-seat content.

 

Catalog Description

The first in a two-course sequence (see CISS 320). 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.

Prerequisites/Corequisites

CISS 234 or CISS 238 or CISS 241.

Text

Modern Systems Analysis and Design 8th edition
Author: Valacich (Pearson)
ISBN: 9780134204925

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 analysis.

Additional Instructor Objectives

· Introduction to the Systems Development Life Cycle · Feasibility Study and Cost-Benefit Analysis · Fact-Finding and Communication · The Analysis Process · Modeling Tools · Systems Design

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 mistakes that occur when creating data flow diagrams.
· Discuss the 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.

Instructional Methods

Lectures conducted illustrating concepts and techniques used in business and industry.

Out of Class Activities

Assignments given according to syllabus and due by beginning of class of the assigned date. Assignments include reading and hands-on practical lessons and projects. Student should be familiar with Microsoft Office. A System Analysis and Design project will be developed throughout the semester incorporating topics within the readings and assignments.

Graded Activities

Assignments200 Points50% of grade
Description -

Assignments are due at the beginning of class on the scheduled day according to the syllabus. Assignment time may be allowed at the end of each lecture. This allows students to ask questions and solve any issues they may have. Use of computers other than Columbia College computers may result in compatibility problems that may lead to extra work on the student behalf. Theory will be taught and applied; students will use software tools used in today’s business in a System Analysis and Design project.

Method of Evaluation -

System Analysis and Design Project
#1 Discuss Influences of Information Systems 30
#2 Proposal 25
#3 Pert Chart 10
#4 Gant Chart 10
#5 WBS 15
#6 Requirements Document 10
#7 Fact Finding Survey 10
#8 Data Flow Diagram (DFD) 30
#9 Entity Relationship Diagram (ERD) 30
#10 Feasibility 30
Total 200

 
Exam I & II200 Points50% of grade
Description -

Examinations are non-comprehensive over the material in the text and lectures. Tests consist of objective questions including multiple choice, matching, true/false, fill in the blank, and/or short answer. Class will be held before the examination to discuss any questions students may have regarding topics on the test. If for any appropriate reason a student has to miss an exam, prior scheduling may be done to take the exam.

Method of Evaluation -

Exam I 100 Points
Exam II 100 Points

 

Grading Scale

90-100 A
80-89 B
70-79 C
60-69 D
0-59 F

Additional Information / Instructions

All software used in class is available at the Columbia College Computer Lab. Various Microsoft products will be demonstrated but not required.  Students should have an understanding of Microsoft Office. In addition Microsoft Visio and Microsoft Project will be demonstrated. Some research may be required to complete assignments. Students may hand in Assignments electronically through D2L or by hard copy. Students should be prepared to discuss the Chapters on the night of class.  Discussions will highlight topics covered in the reading assignments. Exams will cover concepts included in the chapter readings along with class discussion.

Schedule of Activities and Assignments

Week 1
Introduction to System Analysis
Activities:

Syllabus Chapter 1 Context of System Analysis and Design
Information System Building Blocks

Reading:

Syllabus
Chapter 1

Assignments:

Assignment #1 Discuss Influences of Information Systems

 
Week 2
Information System Development
Activities:

Chapter 2
Information System Development

Reading:

Chapter 2

Assignments:

Assignment #2 Proposal (brief)

Additional Notes:

Assignment #1 due

 
Week 3
Project Management
Activities:

 Chapter 3 Project Management

Reading:

Chapter 3

Assignments:

LAB Assignment #3 Pert Chart
LAB Assignment # 4 Gant Chart
LAB Assignment # 5 WBS

 
Week 4
Requirement Documentation
Activities:

System Analysis
Chapter 6
Fact Finding Techniques for Requirement Discovery

Reading:

Chapter 6

Assignments:

Assignment #6 Requirements Document
Assignment #7 Fact Finding Survey

Additional Notes:

Assignment #2 Due
Assignment #3,#4,#5 due

 
Week 5
Process Modeling
Activities:

Exam I
Chapter 7
Process Modeling

Reading:

Chapter 7 Process Modeling

Assignments:

Assignment # 8 DFD
Assignment # 9 ERD

Examinations:

Exam I 

 
Week 6
Process & Data Modeling
Activities:

Chapter 7 & 8

Reading:

Chapter 8 Data Modeling

Assignments:

Work on Lab  8 & 9

Additional Notes:

Assignment #6 & #7 due

 
Week 7
Feasibility Analysis
Activities:

Chapter  5
Feasibility Analysis

Assignments:

Assignment # 10 Feasibility

Additional Notes:

Assignment #8 & #9 due

 
Week 8
Final Exam
Activities:

Review
Final Exam

Examinations:

Exam II

Additional Notes:

Assignment #10 Due

 

Library Resources

Columbia College Resources - Online databases are available at http://www.ccis.edu/offices/library/index.asp. You may access them using your CougarTrack login and password when prompted.

Course Policies and Procedures

Attendance

Columbia College Policy - Columbia College students are expected to attend all classes and laboratory periods for which they are enrolled. Students are directly responsible to instructors for class attendance and work missed during an absence for any cause. If absences jeopardize progress in a course, an instructor may withdraw a student from the course with a grade of "F" or "W" at the discretion of the instructor.

Campus Policy - Regular attendance is expected of all students. Attendance is one of the most important measures of your interest and desire to do well academically. Your attendance helps your instructor facilitate better discussions and your fellow students benefit from your ideas and experiences.

Unforeseen circumstances occasionally dictate that you must miss class; please make every effort to discuss such circumstances with your instructor before the absence. Remember that if you are not in class, you are absent - regardless of the reasons - and that you are still responsible for all in-class assignments made. Your instructor is not responsible for providing this information to you - you must plan ahead with another student who would agree to share notes, etc., with you and vice versa.

Academic Integrity

Columbia College Policy - Columbia College students must fulfill their academic obligations through honest, independent effort. Dishonesty is considered a serious offense subject to strong disciplinary actions. Activities which constitute academic dishonesty include plagiarism, unauthorized joint effort on exams or assignments, falsification of forms or records, providing false or misleading information, or aiding another in an act of academic dishonesty. Possible penalties for these activities are discussed in detail in the AHE Degree Completion Catalog.

Class Conduct and Personal Conduct

Columbia College Policy - Students must conduct themselves so others will not be distracted from the pursuit of learning. Students may be disciplined for any conduct which constitutes a hazard to the health, safety, or well-being of members of the college community or which is deemed detrimental to the college's interests. Discourteous or unseemly conduct may result in a student being asked to leave the classroom. Examples of misconduct and possible disciplinary actions are described in the AHE Degree Completion Catalog.

Cancelled Class Make-Up

Columbia College Policy - Classes cancelled because of inclement weather or other reasons must be rescheduled.

Campus Policy - Information about class cancellations due to inclement weather will be available at 875-SHUT (875-7488). Class cancellation information will also be broadcast over local radio and television stations. Students may also check the college website, www.ccis.edu.

If a class is cancelled due to weather or any other reason a make up night will be scheduled.   The typical make up night will be scheduled for a Friday night.   Watch your CougarMail concerning the class make up schedule.

Make-Up Examinations

Columbia College Policy - Make-up examinations may be authorized for students who miss regularly scheduled examinations due to circumstances beyond their control. Make-up examinations must be administered as soon as possible after the regularly scheduled examination period and must be administered in a controlled environment.

Campus Policy - Make up examinations are scheduled on designated Saturday mornings 9am in  102 Buchanan. Students must present a picture I.D. in order to be admitted to the testing session.  Students must arrange with the instructor to take the exam before or after it is given in class and permission to take a makeup examination (or any graded activity) is granted at the discretion of the instructor.

Adding, Dropping or Withdrawing from a Course

Columbia College Policy - Students may add a course through Wednesday of the first week of the session and drop a course without academic or financial liability through close of business on Monday of the second week of the session. Once enrolled, a student is considered a member of that class until he or she officially drops or withdraws in accordance with College policy. An official drop/withdrawal takes place only when a student has submitted a Drop/Add/Withdrawal form. A failure to attend class, or advising a fellow student, staff or adjunct faculty member of an intent to withdraw from a class does not constitute official drop/withdrawal. The drop/add/withdrawal periods begin the same day/date the session starts, not the first day a particular class begins. If a student stops attending a class but does not submit the required Drop/Withdrawal form a grade of "F" will be awarded. The AHE Degree Completion Catalog contains details concerning drop/withdrawal and financial liability.

Withdrawal Excused

Columbia College Policy - A student may request an excused withdrawal (WE) under extraordinary circumstances by submitting a Drop/Withdrawal form accompanied by a complete explanation of the circumstances and supporting documentation to the location director. The WE request must include all classes in which the student is currently enrolled. The Vice President for Adult Higher Education is the approving authority for all WE requests. A student who receives approval of their WE request may still be required to return some or all of the federal financial assistance received for the session. See the AHE Degree Completion Catalog for details.

Incomplete

Columbia College Policy - A student may request that the instructor award a grade of "I" due to extraordinary circumstances (unforeseen or unexpected circumstances beyond the student's control) that prevent a student from completing the requirements of a course by the end of a session. An "I" will not be given because a student is failing, negligent or not meeting requirements. If the instructor believes an "I" is appropriate, the instructor will specify the work needed to complete the course and the time allowed to complete the work. Work missed must be made up within two subsequent sessions unless the instructor specifies an earlier date. Extensions beyond two sessions must be approved by the Vice President for Adult Higher Education. If the work is completed during the specified time period, the instructor will change the "I" to the grade earned. If the work is not completed during the specified time, the instructor may allow the incomplete to remain on the student's permanent record or change it to any other letter grade.

Grade Appeal

Columbia College Policy - A student may appeal any grade given if it is believed to be in error or in conflict with Columbia College policy and procedures. The student must state in writing to the location director why the grade awarded is believed to be in error and request a desired remedy. The faculty member who awarded the grade will be given the opportunity to comment on all student allegations. If the issue cannot be resolved at the location the appeal will be transmitted through the Director to the Vice President for Adult Higher Education. A grade appeal must be received for review by the Vice President for Adult Higher Education prior to the end of 60 days from the date the grade was awarded.

Prerequisites

Columbia College Policy - Course prerequisites are established to ensure that a student has adequate academic preparation to succeed in a particular course.  Staff members will attempt to ensure that students meet prerequisite requirements.  However, it is the student's responsibility to closely examine the AHE Degree Completion Catalog course descriptions to determine if prerequisites exist and to enroll in courses in the proper sequence.  In some exceptional cases it may be apparent that the student possesses the required skills and knowledge to succeed in a particular course, even though they have not taken the prerequisite course.  In this case the prerequisite course may be waived by the location director.  Waiver of a course as a prerequisite does not remove the requirement to complete the course if it is a requirement for the student's degree program.

CougarTrack

Columbia College Policy - The college provides all students access to CougarMail (the official means of e-mail communication for the College), online resources from the Stafford Library, and their Columbia College records (transcripts, grades, student schedules, etc.) through CougarTrack.

Use of Cougarmail

Columbia College Policy - The official student email address (also known as CougarMail) will be used for all official correspondence from faculty and staff. Students are responsible for the information received and are required to monitor their email account on a regular basis. Students may forward their CougarMail to another email account but will be held responsible for the information sent over CougarMail, even if there is a problem with the alternate mail service.

Cell Phones

Columbia College Policy - Cell phones can be a distraction to the learning process. Location directors or course instructors may require that cell phones be turned off or set to vibrate during class periods. Students requiring special arrangements to receive a cell phone call during class should make prior arrangements with their location director or course instructor.

Course Textbooks

Columbia College Policy - The textbooks listed on this syllabus are required for this course. They are guaranteed to be available through the authorized textbook suppliers designated by Columbia College. The college is not responsible for the academic or financial consequences of late textbook orders or incorrect editions not purchased from a college-authorized vendor.

FERPA

Columbia College Policy - The Family Educational Rights and Privacy Act (FERPA) affords students certain rights with respect to their education records. These rights are described in detail in the AHE Degree Completion Catalog.

Student Accessibility Resources

Columbia College Policy - 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.

Alcohol and Other Drugs: Columbia College Policies & Resources

Columbia College Policy - The Drug-Free Schools and Communities Act of 1989 Amendments requires that Columbia College provide a copy of its Alcohol and Other Drugs Policy to each student, faculty and staff member on an annual basis. Please read the copy of our policy below. You may also find a copy of the policy on the Columbia College website at http://www.ccis.edu/policies/alcohol-and-other-drugs-policy.aspx.

Alcohol and Other Drugs Policy

Purpose: Columbia College recognizes the negative health effects associated with the use, possession and distribution of controlled and/or illicit substances and their detrimental impact on the quality of the educational environment. Therefore, all members of the college community share in the responsibility of protecting the campus environment by exemplifying high standards of professional and personal conduct.

Scope: This policy applies to all members of the college community.

Policy on Alcohol and Controlled and/or Illicit Substances


- Columbia College prohibits the manufacture, possession, use, distribution and sale of alcohol and controlled and/or illicit substances by Columbia College students and employees, regardless of age, on college-owned property and at college-sponsored or supervised events or activities.

- Public intoxication on campus property is expressly prohibited. Those conditions considered to indicate intoxication include but are not limited to affected manner or disposition, speech, muscular movements, general appearance or behavior as apparent to the observer.

- Containers that contain alcohol as well as empty alcohol containers are prohibited on campus and in the residence halls. Possession of empty alcohol containers will be regarded as a violation of this policy.

- Campus displays or advertisements that support or promote alcohol or drug use, possession, manufacture or distribution are prohibited.

- Behavior resulting from intoxication or the illegal use of controlled or illicit drugs will incur disciplinary action.

- Possession of drug paraphernalia and misuse of prescription drugs will be regarded as violations of this policy.

- Alcohol and other controlled and/or illicit substances possessed or consumed in violation of this policy are subject to confiscation. The president retains the authority to make exceptions to this policy with regard to alcohol, including granting permission to serve alcoholic beverages at college functions where meals are served. Requests for exceptions to the policy must be submitted to the president in writing prior to the event and will be considered on an individual basis. Notification of the president's decision will be made in writing to the person(s) making the request.

It is the responsibility of students, faculty and staff to know and uphold the Columbia College Alcohol and Other Drugs Policy. In accordance, students and employees must be held accountable for their personal behavior. Excessive use, manufacture, possession or distribution of alcohol and/or controlled or illicit substances and the associated behavioral problems will be the basis for disciplinary action. Columbia College has made the decision to notify parents/guardians of students under the age of twenty-one (21) who have been found responsible for violating the Alcohol and Other Drugs Policy by the campus judicial system following a final determination.

Representatives of the college will cooperate with outside authorities in their efforts to enforce existing laws regarding alcohol and/or controlled or illicit substances.

Standards of Conduct: Violations of Columbia College rules and regulations pertaining to alcohol and/or controlled or illicit substances can result in disciplinary a tion up to and including dismissal for students and termination for employees. Additionally, in conjunction with or in lieu of the imposition of any disciplinary sanctions, students and employees may also be referred to appropriate local, state or federal law enforcement agencies for arrest and prosecution and/or be required to complete an appropriate treatment or rehabilitation program. In accordance with the mandates of the Drug Free Workplace Act of 1988, and as a condition of employment at Columbia College, all employees (including student employees) must notify their supervisor of any criminal drug statute condition for a violation occurring in the workplace no later than five (5) days after such a conviction. Employees undergoing treatment for alcohol or drug abuse must meet all standards of conduct and job performance.

Legal Sanctions: Any Columbia College student or employee found possessing, manufacturing or distributing controlled and/or illicit substances or unlawfully possessing or attempting to possess alcohol or driving a motor vehicle while under the influence is violating local, state and federal laws. It is unlawful under state law to purchase or otherwise provide alcohol to a minor. Federal law prohibits, among other things, the manufacturing, distributing, selling and possession of controlled substances as outlined in 21 United States Code, Sections 801 through 971. Depending on the amount, first offense maximum penalties for trafficking marijuana ranged from up to five (5) years' imprisonment and a fine of up to $250,000 to imprisonment for life and a fine of $4 million. Depending on the amount, first offense maximum penalties for trafficking other controlled substances (e.g., methamphetamine, heroin, cocaine, cocaine base, PCP, LSD, fentanyl and fentanyl analogue) range from five (5) years to life imprisonment and fines range from $2 million to $4 million. First offense penalties and sanctions for the illegal possession of small amounts of controlled substances, ncluding marijuana, ranged from up to one (1) year in prison or a fine of at least $1,000. Penalties are more severe for subsequent offenses. In addition to these provisions, a student is ineligible for federal student aid if convicted, under federal or state law, of any offense involving the possession or sale of a controlled substance (generally meaning illegal drugs, not to include alcohol or tobacco).

Medical Amnesty: Medical amnesty encourages students to seek medical attention for themselves or a fellow student suffering from an alcohol or other drug overdose or medical emergency. This policy encourages students to call for medical assistance by removing the threat of campus judicial repercussions. However, the student in need will still participate in mandated substance abuse education and treatment services. These health protection strategies will not shield students from disciplinary action when other rules or codes of conduct have been violated. Students will still be subject to legal consequences for violating other codes of conduct and state or federal laws.

Health Risks: Alcohol and other drugs are associated with many health risks. The use and abuse of alcohol and other drugs may have negative effects on one's school or work performance and personal relationships. Some common health risks are addiction; damage to liver, heart and to a developing fetus; accidents as a result of impaired judgment; and unwanted sexual activity that could result in sexual assault or sexually transmitted infections.

For more information about the health risks associated with particular types of drugs and alcohol, please visit https://www.drugabuse.gov/drugs-abuse/commonly-abused-drugs-charts.

Resources

Division of Student Affairs - (573) 875-7400

Human Resources (for Employee Assistance Program information) - (573) 875-7495

Al ohol and Drug Abuse Referral Hotline - (800) 454-8966

Narcotics Anonymous - (800) 945-4673, www.na.org

Alcoholics Anonymous - www.alcoholics-anonymous.org

Phoenix Programs - www.phoenixprogramsinc.org

Tobacco-Free Policy

Columbia College Policy - The following policy goes into effect on August 21, 2017.  Additional information may be found at http://www.ccis.edu/policies/tobacco-free.aspx.

Purpose

Columbia College values and is concerned for the health and well-being of its students, employees and visitors. The College is committed to providing a healthful and productive educational and employment environment for members of the College community. Consistent with this commitment and in the interest of the general health and welfare of the College community, the College prohibits the use of all tobacco products and related devices on all College property and premises.

Scope

This policy applies to all members of the College community on College premises, including, but not limited to, students, employees, third parties and visitors.

Policy

The use and/or consumption of all tobacco products is prohibited on all College properties, premises, facilities, in College vehicles, and in personal vehicles while on College property. For purposes of this policy, this prohibition includes, but is not limited to:

     - Traditional tobacco products, such as cigarettes, cigars, pipes, and smokeless tobacco; and

     - Electronic smoking devices, which includes any product containing or delivering tobacco and/or nicotine or any other substance intended for consumption that can be used by a person in any manner for the purpose of inhaling vapor or aerosol. This includes any such device, whether manufactured, distributed, marketed, or sold as an e-cigarette, e-cigar, e-pip, e-hookah or vape pen, or under any other product name.

Additionally, no tobacco-related advertising or sponsorship shall be permitted on College property or premises, at College-sponsored events, or in publications produced by the College, with the exception of advertising in a newspaper or magazine that is not produced by the College and that is lawfully sold, bought or distributed on College property. For the purposes of this policy, "tobacco-related" applies to the use of a tobacco brand or corporate  name, trademark, logo, symbol, motto or selling message.

No tobacco products, tobacco-related products or tobacco paraphernalia shall be sold or distributed on College property or premises.

Because the College is tobacco free, signs prohibiting smoking and the use of tobacco products are posted at many points of entry to the College and at building entrances as reminders to members of the College community. No ashtrays shall be provided at any College location.

Smoking cessation assistance and resources will be made available to assist and encourage individuals who wish to quit smoking and/or using tobacco.

Questions or inquiries regarding this policy should be directed to the College's Human Resources Office via phone at 573-875-7495 or via email at humanresources@ccis.edu.

Enforcement

This policy is a community health initiative and therefore, the entire College community bears responsibility for implementing and enforcing this policy.  There may be instances when outside third parties, contractors, vendors, guests, visitors, etc. on College premises subject to this policy may be unaware of this policy.  In these situations, a violation of this policy should be reported as soon as possible to the Campus Safety Department or the College department responsible for the outside third party, contractor, vendor, guest, visitor, etc. being present on College premises.

College students and employees are responsible for compliance with this policy.

In the event a student violates this policy, a report should made as soon as possible to the Office for Student Conduct in the Office of Student Affairs or the Campus Safety Department.

In the event a College employee violates this policy, a report should be made as soon as possible to the Human Resources Department or the Campus Safety Department.

Consequences for violating this policy include, but are not limited to, removal from campus, and student and employee discipline, up to and including dismissal or termination.

ADDITIONAL CAMPUS POLICIES

Course Evaluations - All students are encouraged to complete the online course evaluations. Students are notified by way of CougarMail when the evaluations are available. The evaluations are used to help instructors improve their teaching techniques. They are reviewed carefully by the Evening Campus Director, Assistant Director, and several AHE Administrators. Student should know that all responses are completely confidential, instructors only view results after grades are posted. Your input is valued and appreciated.

Late graded assignment/activity policy - All graded assignments or activities are due when stated in the syllabus or by the instructor. Graded assignments or activities submitted after the stated due date/time will not receive any credit unless the instructor has specifically stated that full or partial credit may be awarded to late submissions.

+

Request info