Center for Curriculum and Transfer Articulation
Survey of Computer Information Systems
Course: CIS105

First Term: 2011 Fall
Lec + Lab   3.0 Credit(s)   4.0 Period(s)   3.7 Load  
Course Type: Occupational
Load Formula: S


Description: Overview of computer technology, concepts, terminology, and the role of computers in business and society. Discussion of social and ethical issues related to computers. Use of word processing, spreadsheet, database, and presentation software. Includes uses of application software and the Internet for efficient and effective problem solving. Exploration of relevant emerging technologies.



MCCCD Official Course Competencies
1. Identify common hardware components of computer systems and describe their uses. (I)
2. Identify different types of software and their uses. (II)
3. Describe common uses of networks. (III)
4. Describe Website Technology. (IV)
5. Use the Internet to communicate, collaborate, and retrieve information. (IV, VII)
6. Explore system security and privacy issues. (III, IV, VII)
7. Create macros and understand the basics of Visual Basic for Applications (VBA). (V)
8. Describe the steps in planning and implementing technology solutions. (VI)
9. Determine when technology is useful and select the appropriate tool(s) and technology resources to address a variety of tasks and problems. (VI, VIII)
10. Identify terminology and the uses of technology in business and society, including limitations. (VI)
11. Identify positive social and ethical behaviors when using technology and the consequences of misuse. (VII)
12. Describe how technology is used in the departments of a business and in various career paths. (VIII)
13. Use word processing, spreadsheet, database, and presentation software. (IX)
 
MCCCD Official Course Outline
I. Hardware
   A. Processing Unit
   B. Storage Devices
   C. Input Devices
   D. Output Devices
   E. Expansion Slots and Cards
II. Software
   A. System Software
      1. Operating System
      2. Utilities
      3. Device Drivers
   B. Application Software
      1. Word Processing
      2. Spreadsheets
      3. Databases
      4. Presentation Software
   C. Specialized Application Software
   D. Web Authoring Application Software
III. Networks
   A. Types of Networks
      1. Local Area Network (LAN)
      2. Wide Area Network (WAN)
   B. Uses of Networks
      1. Sharing Resources
      2. Communication
   C. Security and Data Integrity
IV. Internet
   A. History
   B. World Wide Web Structure
   C. Browsers
   D. Search Engines
   E. E-mail
   F. e-Commerce
   G. Hypertext Markup Language (HTML)
   H. Security
   I. Intranet
   J. Websites
V. Visual Basic Application (VBA)
   A. Visual Basic Editor
      1. Procedures
      2. Variables
   B. Macros
      1. Excel
      2. Access
VI. Planning and Implementing Technology Solutions
   A. Information Systems Role in Business
   B. Purchasing and Upgrading Microcomputers
VII. Social and Ethical Issues
   A. Ethics
   B. Viruses
   C. Security
   D. Ergonomics
   E. Intellectual Property Rights
   F. Privacy
   G. Green Computing
VIII. Uses of Technology
   A. Business
   B. Career Paths
IX. Business Application Tools
   A. Word
      1. Editing and formatting
      2. Creating and modifying
         a. Styles
         b. Table of Contents
         c. Index
   B. PowerPoint
      1. Create and modify
         a. Slideshows
         b. Templates
         c. Outlines
   C. Excel
      1. Create, edit, and format spreadsheets
      2. Create and modify formulas
      3. Use Excel functions
      4. Create and modify charts
      5. Table Management
         a. Sort
         b. Filter
         c. Import data
         d. Database functions
         e. Create, refresh, and delete
            (1) Pivot tables
            (2) Pivot charts
   D. Access
      1. File management
         a. Design data
         b. Create tables
      2. Manage data
         a. Filter
         b. Sort
         c. Query
         d. Report
         e. Pivot table
            (1) View
            (2) Chart
         f. Structured Query Language (SQL)



 
Last MCCCD Governing Board Approval Date:  5/25/2010

All information published is subject to change without notice. Every effort has been made to ensure the accuracy of information presented, but based on the dynamic nature of the curricular process, course and program information is subject to change in order to reflect the most current information available.