ALTW 211: INTRODUCTION TO EXCEL

Foothill College Course Outline of Record

Foothill College Course Outline of Record
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
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

Introduction to spreadsheet computer application. Beginning level of spreadsheet database tool, emphasis on spreadsheets, charts and tables.

Course Objectives

The student will be able to:
A. Describe and apply simple Excel functions
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
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

Not applicable.

Special Facilities and/or Equipment

Accessible classroom with computers, monitors, printer and Excel software.

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.