CPSC 310 Computer Information Systems (4 Credit Course)
From MWCSWiki
This Page Is Currently Under Construction And Will Be Available Shortly, Please Visit Reserve Copy Page
Click Here for an Easy to Read Version
NEW COURSE PROPOSAL
CPSC 310 Computer Information Systems
I. Course History
A. Has this course been taught as a "Topics" or Experimental Course"? If so, list previous title and number. (NOTE: Under current guidelines, courses do not have to be taught on an "experimental" basis before being approved.) NO.
B. What were enrollments in all previous offerings? NA
C. When was the course taught? NA
II. Catalogue Description
A. Department/discipline and proposed number.
· CPSC 310 (Betty Bradshaw has approved the course number)
B. Brief description of course content (include a syllabus).
· This course introduces the student to the use and implications of information technology in the business environment. This course covers such topics as data management, networks, analysis an design, computer hardware and software, decision support systems, database management systems, transaction processing systems, executive information systems, and expert systems. It also provides activity with computer and non-computer based problems/cases and includes programming in a high-level language and real world projects.
C. Prerequisites.
· CPSC 220
D. Number of credits proposed.
· 4 Credits.
III. Relevance and Importance of the course:
A. To department/discipline offerings.
1. What is the reason for this course proposal (i.e., how does it relate to other courses in the department's curriculum)?
· The computer science major with an emphasis in information system, which focuses on the use of information technology to solve organizational problems, is designed to prepare students in the areas of systems analysis and design. According to a U.S. Department of Commerce report the jobs related to the information system profession will expand astronomically over the next 5 to 10 years and the U.S will face a massive shortage of information system professionals [1]. The only three occupations expected to have over 100% growth in the next 5 to 10 years in number of job positions are technology related. The computer information system course is crucial to our new proposed concentration in Computer Information System. Without this course the Computer Information System concentration would not have the complete foundation to successfully implement the concentration. CPSC 310, Computer Information System, combined with the computer science core courses, CPSC 220 Computer Science I, CPSC 230 Computer Science II, CPSC 330 Object Oriented Design, CPSC 350 Database, and CPSC 430 Software Engineering, provide the necessary foundation of the Computer Information System concentration.
References
[1] Meares, C.A. and J. F. Sargent, Jr., The Digital Work Force: Building Infotech Skills at the Speed of Innovation, Published by the U.S. Department of Commerce Office of Technology Policy, June, 1999.
2. If this course is approved, which course(s), if any, would be deleted from your current offerings?
· NONE
3. Will this course:
a) Be required for the major? Yes, the Computer Information System Concentration
b) Be an elective in the major? Yes, the Computer Science Major without the a concentration with Computer Information System
c) Not count in the major? NO
B. To the Curriculum of the College:
2. How is this course related to the courses in other departments?
· CPSC 310, Computer Information Systems improves students’ programming skills with an emphasis in the application of technology in the business environment. This course has been developed and discussed with the Department of Business Administration and works well for students interested in both business and computer science.
3. Why is the proposing department the appropriate one to offer the course?
· In the department, we have the practical and academic background that is required to teach this course.
IV. Resource Requirements
A. Does the library have the materials needed to support the course (provide a list of material needed for the course that the library does not have on hand)? YES
B. Will this course require staff time from departments other than your own (Audio Visual, Library, etc.)? NO
C. Does the College have the faculty to teach the course (who, and how will this affect their current teaching duties)? We are anticipating a joint position with CGPS that will enable our faculty to teach this course.
D. Does the College have the equipment, facilities, etc., currently on hand, that will be needed to teach the course, and, if not, tell how and where you will obtain these resources)? YES
V. Effective Date
1. Fall of 2007
VI. Each proposal must be signed by the department chair and dated.
NAME ____________________________________________
Signature___________________________________________ date___________________________
VII. Syllabus
COURSE SYLLABUS
Computers Information Systems
FALL 2007
GOALS AND/OR OBJECTIVES
Upon the completion of this course, each successful student should be prepared to:
A. Understand and describe the terminology, concepts, components and capabilities of computer-based information systems.
B. Implement and administer a system using a database application that will capture and store data and allow users to retrieve information
C. Describe how the Internet works and create web pages.
D. Describe career opportunities in the information systems field.
CONTENT OUTLINE
1. Basic concepts of computer-based information systems
1. Computer Hardware and Software
2. Networking/Connectivity
3. Data Stores
2. Information Systems
1. Basic Systems Concepts
i. Definitions
ii. Components
2. Information and Data
i. Data as raw facts
ii. Utility of information for decision making
3. Types of Information Systems
i. Transaction Processing Systems
ii. Management Reporting Systems
iii. Decision Support Systems
iv. Executive Information Systems
v. Expert Systems
3. Information Systems Architectures
1. Centralized Systems
2. Distributed Systems
4. Analysis and Design
1. Top-down Problem Decomposition
2. Systems Development Life Cycle
3. Modeling Methods
i. Data Flow Diagrams
ii. Entity-Relationship Diagrams
5. Data Management
1. Data Representation
2. File Management Systems
3. Database Management Systems
i. Database Architectures
ii. Database Design
4. SQL and queries
5. Networks/Connectivity
1. Wide Area Networks
2. Local Area Networks
3. The Internet
i. Internet Technology
ii. Intranets and Extranets
iii. Security Considerations
4. The World Wide Web
i. HTTP
ii. HTML
iii. ftp
iv. telnet
v. XML
7. UNIX
1. History
2. Pros and Cons
3. Basic commands for manipulating files
8. Career Opportunities in Information Systems
1. Programmer
2. Systems Analyst
3. Data Base Administrator
4. End User Support
5. Web Master
METHODS
· A variety of methods will be used including lecture, discussion, hands-on in-class projects.
EVALUATION PROCEDURES
· Student performance will be evaluated using a combination of exams, quizzes, homework assignments, and projects.
COURSE REQUIREMENTS
1. A midterm exam and a final exam.
2. Various hands-on computer assignments.
3. Reading Assignments: Students will be held accountable for all reading assignments. Time constraints may prevent some material from being discussed in class, but it will likely be reflected in exams and quizzes.
4. Attendance: Students are expected to attend every class. Since some lectures may deviate from the text in the way of additional information, it is strongly recommended that students participate in every class and take careful notes. These topics may be included as part of the examinations.
INTEGRITY OF SCHOLARSHIP and ACADEMIC HONESTY
Honesty in all academic work is expected of every student. This means giving one's own answers in all class work, quizzes, and examinations without help from any source not approved by the instructor. Written material is to be the student's original composition. Appropriate credit must be given for outside sources from which ideas, language, or quotations are derived. Honesty during written tests is expected of every student. Anyone detected cheating, whether aiding or being aided, will be reported to the Honor Council. This is to be taken seriously.
TEXTS New Perspectives on Computer Concepts, Ninth Edition, Brief
Book cover image for New Perspectives on Computer Concepts, Ninth Edition, Brief
June Jamrich Parsons, Dan Oja
ISBN: 1-4188-3946-9 © 2007
ISBN-13: 978-1-4188-3946-8
Publish date: May 8, 2006
GRADING POLICY:
Two exams..............................30% Final Exam..............................30% Homework Assignments........30% Participation............................10%
Final letter grades will be determined according to the following department grading scale. I reserve the right to lower these standards, but will not raise them.
A 92-100%
A- 89-91%
B+ 87-88%
B 83-86%
B- 79-82%
C+ 77-78%
C 73-76%
C- 69-72%
D+ 67-68%
D 60-68%
F below 60%
NO ASSIGNMENT WILL BE ACCEPTED AFTER ITS DUE DATE unless the reasons for this have been written down and submitted to the instructor. If you have a problem with a specific assignment feel free to discuss it with me but only after some attempt has been made to do the assignment on your own. NOTE: Assignments will not necessarily show step-by-step how to complete them. Some intuition, adventuresomeness, and associative thinking are expected of every student when working with computers.
TENTATIVE SCHEDULE
Weeks
Topics/Events
1-2
Basic computer concepts
3-5
Intro to Information Systems
6-7
Problem Solving Methodologies
8
Midterm Exam (Friday of this week)
9-13
Data Management
14
Networks/Connectivity
15
Career Opportunities in Information Systems
Finals Week
Final Exam (Comprehensive)
