Home Lessons Syllabus Assignments Resources Guest

 

Assignments

LECTURE, ASSIGNMENTS AND EXAMINATION SCHEDULE

CAO85 ASSIGNMENT SHEET Complete All Project assignments.  All filenames must contain your first initial and your last  name.  Print all Bold Italic documents. All printed document must contain the filename, the lesson, and the section in the header

Week

Date

Subject

Project

Points

 1

2/4/08

Lesson 1

Bird Survey (1.2-1.9) 

Home Owner (1-2)

Developments (1-3)

Surname (1-4) 1SPages only

 

 2

2/11/08 

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) 

 

 3

 2/18/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)  Print the worksheet

 

 

Lesson 4 

Calculate (4.1-4.4)

Drinks (4.5-4.8)

 

Formulas (4-2) one print out with values and one print out with formulas)

Zoo (4-3)

Investments (4-4)

Home Price (4-5 

 

 

4

 2/25/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) PRINT BOTH

Car Purchase (5-1)

If Function (5-3)

  Save 5-3 as If Function and print with values and print with formulas. 

 

 5

3/3/08

Review Test 1 Lesson 6

 NCAA (6.1-6.2)

 Combustion (6.3-6.5)

 Botany (6.6-6.7)

Timecard (6.8)

Tax Estimate (6.9)

 Excel Expense Repor(6.10)

On-Line Investments (6.11

 Review Test 1

Impact (6-1)

 Movies, Part 1 (6-2)

 Movies, Part 2 (6-2)

 Large Cities (6-3) Print 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 (NOT PRINTED)

Activity 6-2 (SAVE THE FILE AS CLIP ART) 

 

 

6

3/10/08

Lesson 7

Corporate Sales (7.1-7.4)

Income Statement for Year/January

Income Statement for Year/February

 

Unit Review 1-8

 

MAKE THE SHEET TAB PART OF YOUR IDENTIFICATION

Rainfall/Annual (7-1)

Voting/Distric5 (7-2)

Alamo Amalgamated /Consolidated (7-3)

United Circuitry/Year (7-4)

Gas Sales (1)

Dole (2)

CST Club (3)s Escape (4)  SIMULATION

 Java Café Menu (Job 1)

Java Café Menu 2 (Job 2

 

 

 

 

 

 

 7

3/17/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)

 McDonalds/Worksheet (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)

Radiation/Line Chart (8-7)

Temperature/Line Chart (8-8) Cee Dee Inventory (8-2)

Cee Dee Budget(8-2)

 

 

8

3/24/08

 

Spring Break

 Spring Break

 

9

03/31/08

 

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)

Review for  TEST Trendy Resort Projected Sales (9-1

 

 

10

 04/07/08 

Lesson 10

CTI Training (10-1)

CTI Training – Revised (10-2)

CTI Payroll (10-3)

CTI Mailing Lis(10-4)

CTI Revised List (10-5 thru 10-6)

Arts and Crafts Data

 List (10-7)

Review Test 2

NL Corporation (10-1)

Mailing List (10-2) Lincoln FF Inventory (10-1)

 

11

04/14/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)

 

 

 

12

04/21/08

 

Review

International Sales (12-1)

 

 

 

 

 

 Data Validation  Review (12-1)

  

 

13

04/29/08

 

 

 

 

14

05/05/08

 

 Lesson 12

Complete All Steps

Scenario Summary Workshee(12-3)

Projected Sales (12-5)

Solver (12-6)

TEST 3

 

  

15

05/12/08

 

 

Lesson 13

Complete All Steps

Cellular Sales Pivot Table Sheet 4 (12-1)

Cellular Sales Pivot Chart 1 (13-3)

 

P&K Industries (13-1)

Student List (13-2) 

 

P&K Chart (13-1) 

16

05/19/08

 

Lesson 14

Complete All Steps

create, record macros

Edit Macro

Create custom macro

Unit Review

 

New Western Sales Filter Review Project 1 (AE-225)

Forestry Services Scenarios Review Project 4 (AE 227)

Insert Column Macro (14-1)

Enable Macro (14-2)

 

 

5/25/08

 

Final Exam

 

 

 

 

 

 

 

 

Top

 Last updated Wednesday, April 30, 2008
Copyright © 2005 Amy Sirott  All rights reserved.

Visitor No. Hit Counter