ALTW 211: INTRODUCTION TO EXCEL
Foothill College Course Outline of Record
Heading | Value |
---|---|
Units: | 3 |
Hours: | 3 lecture per week (36 total per quarter) |
Degree & Credit Status: | Non-Degree-Applicable Credit Course Basic Skills |
Foothill GE: | Non-GE |
Transferable: | None |
Grade Type: | Letter Grade (Request for Pass/No Pass) |
Repeatability: | Not Repeatable |
Student Learning Outcomes
- A successful student will be able to produce simple data entry tasks such as creating a spreadsheet, entering data and editing data in a spreadsheet
- A successful student will be able to use Excel to add, subtract, multiply.
- A successful student will be able to identify two or more practical applications of Excel in work or personal life.
Description
Course Objectives
The student will be able to:
A. Describe and apply simple Excel functions
B. Format and edit spreadsheets
C. Format and edit ruled and boxed tables in Excel
D. Create charts and tables
Course Content
A. Excel functions
1. Practice formatting boxed tables in Excel
2. Practice formatting ruled tables in Excel
3. Practice deleting and inserting cells, columns and rows
4. Practice printing the worksheet
B. Spreadsheet
1. Charts
a. Practice formatting charts
b. Practice creating and modifying chart
c. Practice creating combination charts
C. Use Excel for simple mathematical and accounting applications
1. Practice using Excel formulas for addition
2. Practice using Excel formulas for subtraction
3. Practice using Excel formulas for multiplication
4. Practice using simple accounting templates
D. Data entry and data collection
1. Practice collecting data using forms
2. Practice entering data into Excel
3. Practice tabulating and formatting data using Excel functions
4. Practice generating a report for data
Lab Content
Not applicable.
Special Facilities and/or Equipment
Method(s) of Evaluation
A. Participation in all class activities
B. Teamwork assignments
C. Homework
C. Quiz
C. Final exam or final project
Method(s) of Instruction
A. Lecture
B. Discussion
C. Cooperative learning exercises
D. Self-paced
E. Demonstration
F. Peer demonstration
Representative Text(s) and Other Materials
George, Nathan. Excel 2019 Basics: A Quick and Easy Guide to Boosting Your Productivity with Excel. Independently Published, 2019.
Types and/or Examples of Required Reading, Writing, and Outside of Class Assignments
Assignment Example:
A. Development of graphs with practical application to academic assignment, independent living scenarios.
B. Development of spreadsheet with practical application for home-related spreadsheets, academic assignments and work or volunteer setting spreadsheets.