Lake Tahoe Community College - Spring 2008
CAO 121 Spreadsheet Applications in Business
|
INSTRUCTOR: |
Jackie Lou | |
|
DEPARTMENT: |
Computer Applications/Office Technology (CAO) Lake Tahoe Community College One College Drive South Lake Tahoe, CA 96150 |
|
| OFFICE: | Room D-124 | |
|
PHONE: |
(530) 541-4660 ext. 259 | |
| EMAIL: |
cao@ltcc.edu (please include CAO 121 in the title of any messages you send) |
|
|
OFFICE HOURS: |
Mon Tue Wed Thu |
5:00-6:00 pm
(online) 4:00-6:00 pm (online) 5:00-6:00 pm (Room D-124) 5:00-6:00 pm (Room D-124) |
|
CLASS DATES: |
4/9 – 6/25/08 | |
|
CLASS TIME: |
Wed |
6:00-8:50 pm plus two hours of online instruction per week |
|
CLASSROOM: |
Room D-123 | |
|
COURSE WEB SITE: |
http://etudes-ng.fhda.edu/portal | |
|
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
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
OUTLINE OF TOPICS
TUTORIAL 1 - USING EXCEL TO MANAGE FINANCIAL DATAintroduction 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 WORKSHEETformatting cells Format Painter bold, italics, underline aligning cell contents wrapping text borders AutoFormat print options TUTORIAL 4 – WORKING WITH CHARTS AND GRAPHICScreating and formatting column, bar, line, and pie charts exploding and rotating pie charts TUTORIAL 5 - WORKING WITH EXCEL LISTScreating, 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 WORKBOOKSmultiple sheet workbooks consolidating data from multiple workbooks linking workbooks lookup tables and functions creating a workspace TUTORIAL 8 - DEVELOPING AN EXCEL APPLICATIONvalidating data cell and workbook protection range names recording and running macros creating macro buttons
IMPORTANT DATES
|