|
DUE |
LESSON/STEP-BY-STEP |
PROJECT |
ACTIVITY |
|
2/17/08 |
Lesson 1
Bird Survey (1.2-1.9) |
Home Owner (1-2)
Developments (1-3)
Surname (1-4)
1st Pages
only |
|
|
Lesson
2
3Q
Budget (2.1-2.9)
4Q Budget (2.10)
Basketball
Standings (2.11) |
Bird Census (2-2)
Pager Shop (2-3)
Phone Bill (2-4)
Microsoft (2-5)
Mileage
(2-6)
|
|
|
2/24/08
|
Lesson
3
Utility (3.1-3.8)
Currency Conversion (3.9) |
Pelican Stores (3-2)
Import(3-3)
Supply Inventory (3-4)
Time Record (3-5)
Class Grades (3-6)
Booster Club (3-7)
Swimming Pool (3-8) |
Activity
3-1 (Save as Zoo) Send the worksheet |
|
3/2/08 |
Lesson
4
Calculate
(4.1-4.4)
Drinks (4.5-4.8) |
Formulas
(4-2) one email with values and one email with formulas
Zoo (4-3)
Investments (4-4)
Home
Price (4-5) |
Job Offer (4-1)
|
|
3/9/08
|
Lesson
5
Functions
(5.1-5.3)
Budget for 2006 (5.4)
Optics (5.5) |
Course Grades (5-2)
Bank (5-3)
Game Stats (5-4)
Golf Tryouts (5-5)
Xanthan
(5-6) SEND BOTH |
Car Purchase (5-1)
If Function (5-3)
Save 5-3 as If Function and send it with the values
and send with formulas. |
|
3/16/08 |
Lesson 6
NCAA (6.1-6.2)
Combustion
(6.3-6.5)
Botany (6.6-6.7)
Timecard1(6.8)
Tax Estimate (6.9)
Excel Expense Report(6.10)
On-Line Investments (6.11)
|
Impact (6-1)
Movies, Part 1 (6-2)
Movies, Part 2 (6-2)
Large Cities (6-3) Send results for A,
B, C, and D
Paper (6-4)
Sales Invoice1 (6-5)
School Bus Activity (6-6)
Compact Cubicle (6-7)
|
Activity 6-1
(DON'T SEND)
Activity 6-2
(SAVE THE FILE AS
CLIPART) (DON'T SEND)
|
|
3/30/08
|
Lesson
7
Corporate Sales (7.1-7.4)
Income Statement for
Year/January
Income Statement for
Year/February
|
Rainfall/Annual
(7-1)
Voting/District 5 (7-2)
Alamo Amalgamated /Consolidated (7-3)
Alamo Amalgamated /Alamogordo (7-3)
Alamo Amalgamated /Artesia (7-3)
United
Circuitry/Year (7-4)
|
|
|
4/6/08 |
Lesson
8
Education
Pays/ Income Chart (8.1-8.4)
Segment Sales (8.5)
Segment Sales 3D (8.6)
Scrap Report (8.7)
Red Cross (8.8-8.9)
|
Population/Column
Chart (8-1)
Training
(8-2)
McDonalds/Pie Chart (8-3)
Family Expense/3-D Pie Chart(8-4)
Study Time/Scatter Chart (8-5)
Concession
Sales /Column Chart (8-6)
Radiation/Revenue Chart (8-7)
Temperature/Line Chart (8-8)
|
SAM
MIDTERM
PRACTICE EXAM
LESSONS 1-7
WILL BE OPEN ON
March 26, 2008
AND
CLOSED ON
April 2, 2008 |
|
4/13/08 |
|
|
Midterm Exam
Wednesday, April 2, 2008
6p.m--8p.m. |
|
Lesson 9
Personnel (9-1)
Formats (9-2)
Style (9-3)
Transpose (9-4)
Values (9-5)
Bauer Pizza Chart (9-7)
Bauer Pizza Chart 2
(9-8)
Bauer Pizza Chart 3
(9-9) |
Class Scores (9-1)
Pizza (9-2)
Sales Chart (9-3) |
Trendy
Resort Projected Sales
(9-1) |
|
4/20/08
|
Lesson
10
CTI Training (10-1)
CTI Training – Revised (10-2)
CTI Payroll (10-3)
CTI Mailing List(10-4)
CTI Revised List (10-5 thru 10-6)
Arts and Crafts
Data List (10-7)
|
NL Corporation (10-1)
Mailing List (10-2) |
Lincoln
FF Inventory (10-1)
|
|
4/27/08 |
Lesson
11
Stock Quantity (11-1 thru 11-2)
Custom Filters (11-3 thru 11-4)
Custom Filters2 (11-5)
Wildcards (11-6)
Advanced Filter (11-7)
Filter6 (11-8)
Filter7 (11-9) |
Pet Store Inventory (11-1)
Sports Store Sales—Small Size (11-2)
Sports Store Sales—Large Size (11-2)
|
|
|
5/4/08 |
Lesson
12
Complete All Steps
Scenario Summary Worksheet
(12-3)
Projected Sales (12-5)
Solver (12-6) |
International Sales (12-1) |
Data Validation Review (12-1) |
|
5/11/08 |
Lesson
13
Complete All Steps
Cellular Sales PivotTable Sheet 4 (13-1)
Cellular Sales PivotChart 1 (13-3) |
P&K Industries (13-1)
Student List (13-2) |
P&K
Chart (13-1) |
|
5/21/08 |
SAM
FINAL
PRACTICE EXAM LESSON
8-13 WILL BE OPEN
May 14, 2008--CLOSED ON
May 21, 2008. |
|
FINAL EXAM
Wednesday, May 21, 2008 ---6p.m.--8p.m. |
