EXCEL 2007 TENTATIVE SCHEDULE
Fall 2010, Round Rock Campus
Roni Cook, vcook@austincc.edu,
223-0166
Mondays and Wednesdays, 10:05 a.m. – 12:15 p.m.
Standard
Assignment: Read and complete tutorial, Concepts Review,
Independent Challenge (turn in) and practice Visual Workshop
Makeup Assignment or optional for new users—Skills Review
See Printing Instructions for Headers, Centering, Font Size, etc.
|
Date |
Unit |
Description and/or Date |
Independent Challenge (turn in and/or demo) |
|
|
8/23 |
Introduction
|
Cover Syllabus, Schedule, Website |
*check against grade sheet, assignments will be changed |
|
|
8/25 |
WIN A –B & Office 2007
|
Getting Started with Windows & Understanding File Management |
Office 2007 IC-1 Highlights |
|
|
Excel 2007 |
||||
|
8/30-9/1 |
A
|
Getting Started with Excel 2007 Optional: Skills Review |
IC 1 and Real Life Complete Visual Workshop to Review for Test |
|
|
9/6 |
Labor Day Break |
|||
|
9/8-9/13 |
B
|
Working w/ Formulas & Functions |
IC 2 and 3 Complete Visual Workshop to Review for Test |
|
|
9/15-9/20 |
C
|
Formatting a Worksheet |
IC 1 and 2 Complete Visual Workshop to Review for Test |
|
|
9/22 |
TEST ABC |
|
No Late Work Accepted |
|
|
9/27-9/29 |
D
|
Working with Charts |
IC 1 and 2 (omit sketches) Complete IC 3 and Visual Workshop to Review for Test |
|
|
10/4-10/6 |
E
|
Analyzing Data Using Formulas |
IC 1 and 2 Complete IC 3 and Visual Workshop to Review for Test |
|
|
10/11 |
F
|
Managing Workbooks |
IC 2 Timesheets (update) Visual Workshop (update) Review |
|
|
Date |
Unit |
Description |
Independent Challenge |
|
10/13 |
TEST DEF |
|
No Late Work Accepted |
|
10/18-10/20 |
G
|
Using Tables |
IC 1 and 2 Complete IC 3 and Visual Workshop to Review for Test |
|
10/25-10/27 |
H
|
Analyzing Table Data |
IC 1 and IC 3 (no visual workshop) |
|
11/1-11/3 |
J
|
Enhancing Charts |
IC 1 and 2 Complete Visual Workshop to Review for Test |
|
11/8 |
TEST GHJ |
|
No Late Work Accepted |
|
11/10 |
K |
Using What If Analysis |
IC 1 and 2 Complete Real Life to Review for Test |
|
11/17-22 |
M
|
Exchanging Data With Other Programs |
IC 1 and 2 Complete Visual Workshop (update) to Review for Test |
|
Nov. 18 |
Last Day to Withdraw with grade of “W” |
||
|
11/24 |
N
|
Sharing Excel Files and Incorporating Web Information |
IC 1 Review for KMN test TEST BEFORE THANKSGIVING |
|
11/29 |
TEST KMN |
DAILY DEADLINE--No Late Work Accepted |
|
|
Discussion of Semester Grades and Take Home Final Project Deadlines |
|||
|
12/1 |
*TAKE HOME FINAL PROJECT
|
Final Project Questions, Lab Time |
|
|
12/6 |
Final Project due during class (printout/DVD) NO LATE WORK ACCEPTED—Semester Exam grade -- Blackboard |
||
|
12/8 |
Conferences available upon request (optional) |
||