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)