Academic Catalog

ITSC 115: COMPUTER LITERACY 1 (MICROSOFT WORD & EXCEL)

Foothill College Course Outline of Record

Foothill College Course Outline of Record
Heading Value
Units: 0.5
Hours: 6 lecture, 6 laboratory per quarter (12 total per quarter)
Prerequisite: Completion of recognized sound and communication apprenticeship or equivalent and recent employment as an installer/technician in the sound and communication industry.
Degree & Credit Status: Degree-Applicable Credit Course
Foothill GE: Non-GE
Transferable: None
Grade Type: Letter Grade (Request for Pass/No Pass)
Repeatability: Not Repeatable

Description

Covers the fundamentals of Microsoft Word and Excel; how to navigate the software, write, edit, format, create spreadsheets and use formulas.

Course Objectives

The student will be able to:
A. Navigate the ribbon
B. Describe how to change the font
C. Demonstrate how to insert a picture
D. Explain how to insert a shape
E. Demonstrate using a number format
F. Insert a table
G. Demonstrate how to save and print a document

Course Content

A. Word
1. Introduction (Lec)
2. Saving (Lec and Lab)
a. Desktop/local file vs. network drive
b. Folder vs. file
c. Creating folders
d. Renaming folders
e. Save/Save As
3. Edit text (Lec and Lab)
a. Undo/Redo
b. Cut
c. Copy
d. Paste
e. Find/Replace
4. Format Text (Lec and Lab)
a. Font
b. Color
c. Size
d. Style
5. Creating bulleted lists (Lec and Lab)
6. Creating numbered lists (Lec and Lab)
7. Layout (Lec and Lab)
a. Portrait vs. landscape
8. Printing (Lec and Lab)
B. Excel
1. Introduction (Lec)
a. Similarities to Word
2. Data entry (Lec and Lab)
a. Auto fill
3. Formulas (Lec and Lab)
a. Sum
b. Product
c. Etc.
4. Formatting (Lec and Lab)
a. Cell height
b. Cell width
c. Merged cells
5. Views (Lec and Lab)
a. Normal
b. Page break
c. Page layout
d. Freeze panes
6. Worksheets (Lec and Lab)
a. New worksheet
b. Renaming worksheet
7. Printing (Lec and Lab)

Lab Content

A. Work individually and in teams with Microsoft Word and Excel.
B. Students will create Word documents and Excel spreadsheets.
C. Students will demonstrate their skills completing Microsoft Word and Excel lab exercises.

Special Facilities and/or Equipment

A. Computer lab.
B. When taught via Foothill Global Access, on-going access to email software and hardware; email address.

Method(s) of Evaluation

A. Results of assessments
B. Results of quizzes and tests
C. Discussion participation

Method(s) of Instruction

A. Lecture
B. Group discussion
C. Demonstration
D. Computer lab

Representative Text(s) and Other Materials

Handouts and/or worksheets provided by course instructor.

 

Types and/or Examples of Required Reading, Writing, and Outside of Class Assignments

A. Reading assignments:

1. Read Microsoft Word lab exercise worksheet; follow directions

2. Read Microsoft Excel lab exercise worksheet; follow directions

B. Writing assignments:

1. Create a Word document that could be used to convey instructions for a specific task on a jobsite

2. Create an Excel spreadsheet that would be useful to track a work-related item, such as jobsite hours, individual hours, task completions, or materials

 

Discipline(s)

Telecommunication Technology