SANTA BARBARA CITY COLLEGE
ASSOCIATE DEGREE CREDIT COURSE OUTLINE
Department: Computer Information Systems
Subject Area and Course Number: CIS 101
Course Title: Introduction to Computers and Information Systems
Discipline: Computer Information Systems
Catalog Course Description: Introduction to the role of computer information systems within modern organizations. Topics include hardware and software functions, programming, systems development and networks. Students use computers for programming, as well as popular microcomputer applications such as word processing, spreadsheets, and database management.
Description for Schedule of Classes: Introduction to the role of computer information systems within modern organizations. Students will use computers for programming and microcomputer applications. (TR: UC/CSU)
Lecture Hours per week: 4.3 (64-72 Total Semester Hours)
Laboratory Hours per week: None
Plus Hours: 2 (30 Total Semester Hours)
Skills Advisories: Eligibility for English 110 or English 110HR or English 110GB
Course Advisories: None
Limitation on Enrollment: None
Course Objectives: Upon completion of prescribed work for this course, the student should be able to:
1. Identify the components in a computer system including CPU, memory, ports, buses, and input/output devices, and describe the functions of each.
2. Identify and describe categories of software, including operating systems and utilities.
3. Describe the purpose of the major programming languages.
4. Design, code, and test elementary programs in a high-level programming language.
5. Describe the variety and uses of application software including word processing, spreadsheets and database management, and presentation graphics.
6. Describe and discuss the role and functions of system software.
7. Convert numbers between binary and decimal base system.
8. Describe the importance of a database management system, including how data is organized in a database; entering data and querying a database.
9. Describe communications and networking concepts such as local area networks, wide area networks, wiring, modems, security and firewalls.
10. Describe and discuss the principles of organization and management for a CIS department in a business organization.
11. Describe the ethical issues involved in the application and use of computer technology.
12. Describe and discuss the functions and benefits to be derived from computer use in businesses.
13. Describe the phases of the system development life cycle: analysis, design, implementation and support.
14. Demonstrate knowledge of Internet concepts such as the World Wide Web, browser, search engines, and e-mail.
15. Demonstrate facility in elementary word processing.
16. Create and use spreadsheets for financial planning and management, including entering data, cell operations, formatting, functions, and charting.
17. Create elementary databases and extract information from them.
Course Content and Scope:
1. The need to process data and information: Social and ethical issues.
2. Overview of Internal Computer Operations.
3. Computer Systems: hardware, software, capacities.
4. Input Operations: Media, data entry, data organization.
5. Processing Operations: CPU, memory processing cycle, ports and buses
6. Secondary Storage Operations: Disk, tape and optical.
7. Output Operations: Printers, displays, audio.
8. The Computer Information System: Users, business problem solving, project development, and the system development life cycle.
9. Application Programs and Their Development: Evolution of different levels of languages and structured programming.
10. Application Program Development: Survey of common languages.
11. System Software: Operating systems such as Windows, Unix, multiprogramming and multiprocessing; network systems.
12. Microcomputer Applications: Variety, use and impact in business.
13. Computer-related Careers and Organizational Roles: Programmer, analyst, operations, technical and software.
14. Introduction to Computer Programming: Interactive editing tools, variables, elementary data types, arithmetic and relational operators, algorithmic design, control structures, subroutines, flowcharts and pseudo code, coding testing and error correction.
15. Database concepts including how data is organized in a database, entering and querying a database.
16. Information systems development including the systems development life cycle: analysis, design, implementation and support.
17. Information systems: Transaction processing systems, management information systems, decision support systems, and expert systems.
18. Communications and network concepts including LAN, WAN, wiring, modems, security, and firewalls.
19. Word Processing. Creating and editing text, page appearance options, spell checking, and printing.
20. Spreadsheets: Creating spreadsheets, entering data, cell operations, formatting, formulas and functions, editing, saving and printing, and charts.
21. Database Management: Defining a database, entering and querying data, defining fields, forms and reports, sorting data; relational database concepts.
22. Presentation Software: Creating and editing a presentation.
Methods of Instruction: Predominantly lecture format. Film, videotape and guest lecturers are used where appropriate. Students prepare computer assignments in the lab at their own convenience. For fully online class only: See attached.
1. Appropriate Readings: Students are required to read assigned textbook chapters as well as supplemental handouts.
2. Written Assignments: Students will complete miscellaneous written assignments based on textbook material.
3. Appropriate Computer-Based Assignments: Students are required to prepare various assignments demonstrating their knowledge of word processing, spreadsheets, database management, and presentation graphics software.
Sample Assignment: Compare and contrast two computer configurations.
Methods of Evaluation:
2. Assignments in the use of word processing, spreadsheets, database management and other software that may be used.
3. Flowcharts and program assignments.
4. Other homework assignments.
5. At least two one-hour exams.
6. A comprehensive final examination.
For fully online class only: Assignments will be submitted through the Internet. All testing will be done online. Attendance will be evaluated based on the regular use of online communications tools.
Appropriate Texts and Supplies:
New Perspectives on Computer Concepts (Comprehensive) by June J. Parsons and Dan Oja (Course Technology, 2008).
Student Learning Outcomes:
1 - Terms - Use critical computing concepts and terms in context
2 - IT Role - Explain the role of computer technology in modern organizations
3 - Ethics Privacy - Debate the ethical and privacy issues resulting from the use of computer technology
4 - IT Implement - Evaluate appropriate technologies required in selecting and implementing computer information systems
5 - Tech Use - Demonstrate competency in the use of information system technologies
Approved September 26, 2005
FRC (Word Proc Center)