Computer Applications/Office Technology (CAO)
Lake Tahoe Community College
One College Drive
South Lake Tahoe CA 96150

CAO 121 is a comprehensive course in spreadsheet applications in business using Excel 2007. Topics include the design, development, and formatting of spreadsheets; the presentation of data through the creation of charts; the use of data lists and pivot tables; and the management of multiple spreadsheets. Emphasis is placed on using spreadsheet software to solve practical business problems.

IMPORTANT NOTES:
This is a transfer-level course. Students with little or no computer experience should enroll in CAO 110 Microcomputer Applications before taking this course.

The successful student will be able to:
1) Design and develop spreadsheets for business applications
2) Design charts for representing data
3) Develop and manage data lists and pivot tables
4) Apply "What-If Analysis" skills

New Perspectives on Microsoft Office Excel 2007 – Introductory
by Parsons, Oja, Ageloff, Carey
published by Course Technology ©2008
ISBN 9781423905844

Microsoft Excel 2007

You must have access to Excel 2007 as older versions cannot be used for this course. You are welcome to use the D-wing computer labs and the Tutoring and Learning Center on campus where there are computers equipped with Excel 2007. Lab hours will be posted as soon as they are established for the quarter. (The LTCC library computers do not have Excel 2007installed.)

Class attendance is fulfilled by signing on to the CAO 121 course site at least two times per week to check for new postings. Failing to sign on to read announcements, modules, assignments, discussions, and private messages is equivalent to skipping class.

Students are expected to meet all posted deadlines. This is not a self-paced course.

Students with disabilities who may need special accommodations for this class are encouraged to notify the instructor and contact the Disability Resource Center (DRC) early in the quarter so that reasonable accommodations may be implemented as soon as possible.  Students may contact the DRC by visiting the Center (located in room A205) or by phoning 541-4660, ext. 249 (voice) or 542-1870 (TTY for deaf students).  All information will remain confidential.

Students are expected to spend several hours per week working on modules and homework assignments. Homework assignments must be submitted online before the posted due dates. No late assignments will be accepted.

Assignments and exams must be completed by each individual student. Joint work, sharing assignments, or any other manner of cheating will result in a grade of F for the assignment or exam.

Final grades will be determined by points earned on homework assignments and exams. There will be no extra credit assignments.

Course points will be distributed as follows:

Homework Assignments:
Exams:
Total Course Points:

Tutorial 1 Getting Started with Excel
Navigating an Excel workbook
Creating a basic worksheet

Tutorial 2 Formatting a Workbook
Formatting text and numbers
Merging cells
Using styles
Printing options

Tutorial 3 Working with Formulas and Functions
Copying formulas using relative and absolute referencing
Using built-in functions

Tutorial 4 Working with Charts and Graphics
Creating and formatting Excel charts

Tutorial 5 Working with Excel Tables, PivotTables,and PivotCharts
Maintaining and editing Excel tables
Creating pivot tables and pivot charts

Tutorial 6 Managing Multiple Worksheets and Workbooks
Formatting and editing multiple worksheets
Linking workbooks
Creating a consolidated worksheet

Tutorial 8 Developing an Excel Application
(selected topics as time permits)