Catalog Course Search Details

 Department:    CIS

 Course #:    146

 Credits:    5

 Variable:     No

 IUs:    5

 CIP:    110301

 EPC:    514

 REV:    2024

 Course Description  

Introduction to the use of Microsoft Excel spreadsheet software for home and office. Provides an understanding of spreadsheet software and a spreadsheet as a productive and useful tool.

 Prerequisite  

Prerequisite: computer literacy and file management skills are strongly recommended.

Contact Hours (based on 11 week quarter)

Lecture: 55

Lab: 0

Other: 0

Systems: 0

Clinical: 0

Intent: Distribution Requirement(s) Status:  

Vocational Preparatory Required for ATA degree  

Equivalencies At Other Institutions

Learning Outcomes

After completing this course, the student will be able to:

1. Create worksheets and charts that effectively organize, analyze, evaluate, and display numeric data.
2. Use different methods to write formulas and functions, including absolute and mixed cell references, named ranges, and apply appropriate formats.
3. Use Excel�s mathematical, logical, and financial functions to present data according to precise specifications.
4. Analyze numeric data using data tables and amortization schedules.
5. Work with multiple worksheets and workbooks to demonstrate 3-D data entry and formulas, and consolidation.
6. Use database tools that include auto and advanced filtering and subtotals, and lookup functions to display data that meet certain criteria.

General Education Learning Values & Outcomes

Revised August 2008 and affects outlines for 2008 year 1 and later.

Course Contents

1. Worksheet Creation.
2. Formula and Function Writing.
3. Analysis: What If and Charting.
4. Financial Function Writing.
5. Data List Management.
6. Multiple Worksheet / Workbook Development.