ITSC 115: COMPUTER LITERACY 1 (MICROSOFT WORD & EXCEL)
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
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
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