De Anza logo
Credit - Degree Applicable
Effective Quarter: Fall 2020

I. Catalog Information


CIS 4
Computer Literacy
4 1/2 Unit(s)
 

Advisory: EWRT 1A or EWRT 1AH or (EWRT 1AS and EWRT 1AT) or ESL 5.

Lec Hrs: 48.00
Lab Hrs: 18.00
Out of Class Hrs: 96.00
Total Student Learning Hrs: 162.00

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.


Student Learning Outcome Statements (SLO)

 

Manipulate data in a spreadsheet


 

Manage file and folder properties in the operating system.


 

Extract information from a database program.


II. Course Objectives

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

III. Essential Student Materials

 None

IV. Essential College Facilities

 None

V. Expanded Description: Content and Form

A.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
B.Demonstrate knowledge of computer hardware/software components
1.Computer concept fundamentals
a.Hardware
b.Software
2.System components
3.Connectors and ports
a.CPU
b.Memory
c.Storage devices
1.Primary storage
2.Secondary storage
3.Optical disks
4.Online storage
d.Motherboards
4.Input/output
a.Scanning
b.Alpha/Numeric inputting
c.Printing
C.Apply security settings and recognize basic privacy issues
1.Security issues
a.Malware
b.Phishing
c.Pharming
d.Computer protection
e.Anti-virus software
2.Privacy issues
a.Cookies
b.Opting out
c.Online privacy policies
d.Privacy settings
3.Computer crime
4.Data Encryption
a.Encrypting File System (EFS)
b.Encryption benefits
c.Encryption drawbacks
D.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
E.Explore network connectivity
1.Network Types
a.Local area networks
b.Wide area networks
2.Setup home/small office network
a.Peer-to-peer networks
b.Server Connectivity
F.Explore the Internet to confidently and competently use its features
1.History of Internet
2.E-learning
3.E-commerce
a.Online Storefronts
b.Auctions
c.Electronic payment services
4.Search engines
5.Instant messaging
6.File sharing
7.Connect to Internet
a.Routers
b.DSL
c.Cable
d.Fiber
e.Streaming
8.HTML coding
a.Simple HTML programming
b.Web Pages
c.Web hosting
G.Explore communication and social media tools
1.Social media and networking tools
a.Twitter
b.Linkedin
c.Myspace
d.Facebook
e.Blogs
f.Newsgroups
2.Cultural impact of social media
a.User demographic changes
1.Gender
2.Class
3.Generational
b.Political impact
1.National elections
2.Local Elections
3.Cloud computing
a.Cloud drives
b.Shared cloud applications
c.Cloud collaboration
d.Smartphones
H.Utilize and apply introductory operating system concepts
1.Operating System features
a.Display settings
b.Password protection
c.Operating system updates
2.File management
a.Libraries
b.Folders
c.Filtering
3.System management utilities
a.Firewalls
b.Remote management

VI. Assignments

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

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

VIII. Methods of Evaluating Objectives

A.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.
B.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.
C.Writing project(s) to evaluate ability to analyze critically and synthesize course materials related to appropriate computer usage in a modern society.

IX. Texts and Supporting References

A.Examples of Primary Texts and References
1.O'Leary, Timothy J., O'leary, Linda “Computing Essentials”, Making It Work for You, Arizona State Univ-Tempe, McGraw Hill Publishing, 2017 (26th Edition).
2.SIMnet interactive software (access code). McGraw Hill Publishing, 2016.
B.Examples of Supporting Texts and References
1.None

X. Lab Topics

A.Use an operating system such as Windows, to manage files, interact with peripherals, and adhere to computer security guidelines.
B.Use word processing software to create and edit a document
C.Use spreadsheet software to create a spreadsheet with formulas
D.Use database software to extract information
E.Use presentation software to create a presentation
F.Explore the Internet using a search engine
G.Explore social media tools
H.Apply simple HTML coding to web pages