Active Outline

General Information

Course ID (CB01A and CB01B)
CISD004.
Course Title (CB02)
Computer Literacy
Course Credit Status
Credit - Degree Applicable
Effective Term
Fall 2023
Course Description
An introduction to basic computer literacy concepts. History of the computer, hardware, software, operating system mechanics, system management utilities, basics of networking, Internet and explore HTML web pages. The social impact and future of computers for communication systems are discussed along with an overview of basic security and privacy concerns. An integrated software package for word processing, spreadsheets, databases, e-mail, Internet and presentations are introduced.
Faculty Requirements
Course Family
Not Applicable

Course Justification

This course is a major preparation requirement in the discipline of Computer Science for CSU and UC and belongs on the Medical Records Clerk Certificate of Achievement. This course provides the foundation skills for technology workers employed in the Silicon Valley.

Foothill Equivalency

Does the course have a Foothill equivalent?
No
Foothill Course ID

Course Philosophy

Formerly Statement

Formerly Statement
(Formerly CIS D093.)

Course Development Options

Basic Skill Status (CB08)
Course is not a basic skills course.
Grade Options
  • Letter Grade
  • Pass/No Pass
Repeat Limit
0

Transferability & Gen. Ed. Options

Transferability
Transferable to both UC and CSU

Units and Hours

Summary

Minimum Credit Units
4.5
Maximum Credit Units
4.5

Weekly Student Hours

TypeIn ClassOut of Class
Lecture Hours4.08.0
Laboratory Hours1.50.0

Course Student Hours

Course Duration (Weeks)
12.0
Hours per unit divisor
36.0
Course In-Class (Contact) Hours
Lecture
48.0
Laboratory
18.0
Total
66.0
Course Out-of-Class Hours
Lecture
96.0
Laboratory
0.0
NA
0.0
Total
96.0

Prerequisite(s)

Corequisite(s)

Advisory(ies)

EWRT D001A or EWRT D01AH or ESL D005.

Limitation(s) on Enrollment

Entrance Skill(s)

General Course Statement(s)

Methods of Instruction

Discussion and problem solving

Quiz and examination review

Laboratory experience which involve students in formal problem solving activities

Interactive software

Lecture and visuals

Assignments

  1. Reading from texts and handouts
  2. Written homework questions from assigned readings
  3. Problem-solving documents and project activities using various software applications such as using a spreadsheet and database program to create and format business documents.

Methods of Evaluation

  1. Final exam along with midterm or quizzes based on comprehension and mastery of key terms and concepts as well as application skills related to analysis and synthesis of computer concepts. These are evaluated on correctness.
  2. Participation in lab skills exercises that demonstrate ability to critically evaluate the proper use of appropriate computer hardware/software and computer concepts to complete a given set of computer-related tasks.
  3. Writing project(s) to evaluate ability to analyze critically and synthesize course materials related to appropriate computer usage in a modern society.

Essential Student Materials/Essential College Facilities

Essential Student Materials: 
  • None.
Essential College Facilities:
  • None.

Examples of Primary Texts and References

AuthorTitlePublisherDate/EditionISBN
O'Leary, Timothy J., O'leary, Linda "Computing Essentials", Making It Work for You, Arizona State Univ-Tempe, McGraw Hill Publishing, 2017 (26th Edition).
SIMnet interactive software (access code). McGraw Hill Publishing, 2016.

Examples of Supporting Texts and References

AuthorTitlePublisher
None.

Learning Outcomes and Objectives

Course Objectives

  • Demonstrate knowledge of the history of computer development within the discipline of computer science.
  • Demonstrate knowledge of computer hardware/software components
  • Apply security settings and recognize basic privacy issues
  • Identify terminology and use basic functions of application software
  • Explore network connectivity
  • Explore the Internet to confidently and competently use its features
  • Explore communication and social media tools
  • Utilize and apply introductory operating system concepts

CSLOs

  • Manipulate data in a spreadsheet.

  • Manage file and folder properties in the operating system.

  • Extract information from a database program.

Outline

  1. Demonstrate knowledge of the history of computer development within the discipline of computer science.
    1. First Generation computers 1830-1940’s
    2. Early commercial computers
    3. Home computer evolution
    4. Unix based computers
    5. Early processors
    6. Programming language evolution
    7. Mass storage
    8. Microprocessor
    9. Early Apple computers
    10. Operating system evolution
    11. Computer virus
    12. Printer evolution
    13. Software applications
    14. World Wide Web creation
    15. Wireless networking
    16. Social media evolution
    17. Smart mobile devices
  2. Demonstrate knowledge of computer hardware/software components
    1. Computer concept fundamentals
      1. Hardware
      2. Software
    2. System components
    3. Connectors and ports
      1. CPU
      2. Memory
      3. Storage devices
        1. Primary storage
        2. Secondary storage
        3. Optical disks
        4. Online storage
      4. Motherboards
    4. Input/output
      1. Scanning
      2. Alpha/Numeric inputting
      3. Printing
  3. Apply security settings and recognize basic privacy issues
    1. Security issues
      1. Malware
      2. Phishing
      3. Pharming
      4. Computer protection
      5. Anti-virus software
    2. Privacy issues
      1. Cookies
      2. Opting out
      3. Online privacy policies
      4. Privacy settings
    3. Computer crime
    4. Data Encryption
      1. Encrypting File System (EFS)
      2. Encryption benefits
      3. Encryption drawbacks
  4. Identify terminology and use basic functions of application software
    1. Word processing
    2. Spreadsheet
    3. Database
    4. Presentation
    5. Email
    6. Backup and data integrity
  5. Explore network connectivity
    1. Network Types
      1. Local area networks
      2. Wide area networks
    2. Setup home/small office network
      1. Peer-to-peer networks
      2. Server Connectivity
  6. Explore the Internet to confidently and competently use its features
    1. History of Internet
    2. E-learning
    3. E-commerce
      1. Online Storefronts
      2. Auctions
      3. Electronic payment services
    4. Search engines
    5. Instant messaging
    6. File sharing
    7. Connect to Internet
      1. Routers
      2. DSL
      3. Cable
      4. Fiber
      5. Streaming
    8. HTML coding
      1. Simple HTML programming
      2. Web Pages
      3. Web hosting
  7. Explore communication and social media tools
    1. Social media and networking tools
      1. Twitter
      2. Linkedin
      3. Myspace
      4. Facebook
      5. Blogs
      6. Newsgroups
    2. Cultural impact of social media
      1. User demographic changes
        1. Gender
        2. Class
        3. Generational
      2. Political impact
        1. National elections
        2. Local Elections
    3. Cloud computing
      1. Cloud drives
      2. Shared cloud applications
      3. Cloud collaboration
      4. Smartphones
  8. Utilize and apply introductory operating system concepts
    1. Operating System features
      1. Display settings
      2. Password protection
      3. Operating system updates
    2. File management
      1. Libraries
      2. Folders
      3. Filtering
    3. System management utilities
      1. Firewalls
      2. Remote management

Lab Topics

  1. Use an operating system such as Windows, to manage files, interact with peripherals, and adhere to computer security guidelines.
  2. Use word processing software to create and edit a document
  3. Use spreadsheet software to create a spreadsheet with formulas
  4. Use database software to extract information
  5. Use presentation software to create a presentation
  6. Explore the Internet using a search engine
  7. Explore social media tools
  8. Apply simple HTML coding to web pages
Back to Top