INSTRUCTOR:

DEPARTMENT:

Computer Applications/Office Technology (CAO)

Lake Tahoe Community College

One College Drive

South Lake Tahoe, CA 96150

PHONE:

OFFICE HOURS:

CLASS DATES:

CLASS TIME:

CLASSROOM:

COURSE WEB SITE:

COURSE DESCRIPTION:

This course provides a comprehensive introduction to spreadsheet applications using Microsoft Excel 2002. Students will learn how to design, develop, and format electronic spreadsheets and how to present data through the creation of charts. Intermediate topics include lists, pivot tables, macros, and multiple sheet workbooks. Emphasis will be placed on practical business applications.

UNITS: 4

ADVISORY:

CAO 110 Microcomputer Applications or equivalent

Students must be proficient in the Windows environment

STUDENT OUTCOMES:

The successful student will:

Learn electronic spreadsheet concepts and terminology

Learn principles of What-If Analysis

Design and develop spreadsheets for business applications

Design appropriate charts for representing data

Develop and manage data lists and pivot tables

Develop spreadsheet macros

TEXTBOOK:

New Perspectives on Microsoft Excel 2002 - Comprehensive
by Parsons, Oja, Ageloff, and Carey

published by Course Technology ©2002

ISBN 0-619-02092-X

SOFTWARE:    Microsoft Excel 2002 (or Excel 2003)

REQUIRED MATERIALS: USB Flash drive

ATTENDANCE

Students are expected to attend all class meetings. There will be no make up exams except in the event of an emergency or illness, in which case the student must contact the instructor before the exam is held.

SPECIAL ACCOMMODATIONS

Students with disabilities who may need 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 in Room A205 or by phoning 541-4660 x249 (voice) or 542-1870 (TTY for deaf students). All information will remain confidential.

HOMEWORK ASSIGNMENTS

Homework assignments are designed to reinforce the learning that takes place in the classroom. Students are expected to spend several hours per week outside of class working on hands-on homework assignments. These assignments should be completed in the college computer labs or off-campus if students have their own access to computers and software. Homework assignments must be turned in to the instructor at the beginning of class on the due date. Late assignments will not be accepted, except in the event of emergency or illness.

EXAMS

The midterm and final will be written, computer hands-on, open book exams that will test the student's understanding (not memorization) of important concepts and skills learned in the classroom.

GRADING

Final grades will be determined by points earned on homework assignments and exams. Course points will be distributed as follows:

NOTE: This course can be taken with the Credit/No Credit (CR/NC) option.

            The deadline for applying for CR/NC status is noon on Friday 5/2.

DISHONESTY POLICY
Homework and exams must be completed by each individual student. Joint work, sharing assignments, or cheating will result in a grade of F for the course.
 

OUTLINE OF TOPICS

TUTORIAL 1 - USING EXCEL TO MANAGE FINANCIAL DATA 

introduction to spreadsheets

navigating workbooks and worksheets

text, values, formulas, and functions

saving and printing

What-If Analysis

TUTORIAL 2 – WORKING WITH FORMULAS AND FUNCTIONS

entering formulas

using built-in functions

copying formulas

relative and absolute referencing

TUTORIAL 3 - DEVELOPING A PROFESSIONAL-LOOKING WORKSHEET

formatting cells

Format Painter

bold, italics, underline

aligning cell contents

wrapping text

borders

AutoFormat

print options

TUTORIAL 4 – WORKING WITH  CHARTS AND GRAPHICS

creating and formatting column, bar, line, and pie charts

exploding and rotating pie charts

TUTORIAL 5 - WORKING WITH EXCEL LISTS

creating, sorting, and managing lists

using a data form

filtering data

conditional formatting

creating pivot tables and pivot charts

TUTORIAL 6 - WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS

multiple sheet workbooks

consolidating data from multiple workbooks

linking workbooks

lookup tables and functions

creating a workspace

TUTORIAL 8 - DEVELOPING AN EXCEL APPLICATION

validating data

cell and workbook protection

range names

recording and running macros

creating macro buttons

IMPORTANT DATES

back to top