Modified 07 October 2008
Theme 4 : Making
it payData for the Theme as a zipped file
| Pages covered and dates | Activity | What learner must do | Focus of exercise |
| Processing
numbers in a spreadsheet Chapter 3 Pages 247-272 Complete by 5 Sept |
1-Budget_January | Print and put in portfolio | Alignment, introduction |
| 2-Cans | Print and put in portfolio | Sum | |
| 3-Temperature | Print and put in portfolio | Max, min, average | |
| 4-Marklist | Print and put in portfolio | Max, min, average | |
| 5-Marklist | Print and put in portfolio | Print, grid lines | |
| 6-Netball matches | Print and put in portfolio | Total, highest, lowest, average | |
| 7-Best athletic achievers | Print and put in portfolio | Orientation of cells | |
| 8-Class | Print and put in portfolio | Orientation, Formatting | |
| 9-Valentine's Day | Print and put in portfolio | Symbols, art | |
| 10-1-Matching columns | Print and put in portfolio | Testing | |
| 10-2-Squash | Print and put in portfolio | Alignment | |
| 10-3-Funds_CAT | Print and put in portfolio | Sum, format | |
| 11-Population | Print and put in portfolio | Data format | |
| 12-Golf_3 | Print and put in portfolio | Data format | |
| 13-Donations | Print and put in portfolio | Currency, sum | |
| Processing
numbers in a spreadsheet Chapter 3 Pages 247-272 Complete by 12 Sep |
14-Budget_Own | Print and put in portfolio | Currency, labels |
| 15-Sewing | Print and put in portfolio | Numbers as text | |
| 16-Dates | Print and put in portfolio | Play with dates | |
| 17-Courses | Print and put in portfolio | Max, min, average, dates, currency | |
| 18-Autofill | Print and put in portfolio | Autofill | |
| 19-Holiday | Print and put in portfolio | Max, min, average, sum | |
| 20-Stationery | Print and put in portfolio | Multiplication | |
| 21-Mathematics | Print and put in portfolio | Calculations including division | |
| 22-Music_Concert | Print and put in portfolio | Calculations including division | |
| 23-Exercises_Formulas | Print and put in portfolio | Calculations including division, Tools, Options | |
| 24-Expenses | Print and put in portfolio | Calculations | |
| 25-Invoice | Print and put in portfolio | Calculations including VAT | |
| 26-Quotation | Print and put in portfolio | Calculations including VAT | |
| 27-1-Matching | Print and put in portfolio | Testing knowledge of formulas | |
| 27-2-Functions | Print and put in portfolio | Testing knowledge of formulas | |
| 27-3-Functions | Print and put in portfolio | Testing knowledge of formulas | |
| 28-Class_Party | Print and put in portfolio | Calculations | |
| 29-CounterStrikeE | Print and put in portfolio | Calculations and formatting | |
| 30-Checklist | Complete Checklist and put in portfolio | Answer checklist truthfully | |
| 31-1-EntrepreneurE | Print and put in portfolio | Calculate own profit | |
| 31-2-Home_Bakes | Print and put in portfolio | Calculations for baking firm | |
| 22 Sept | Spreadsheet test - Assessing basic formatting, functions and formulae | Test - Pug Dog Club Question paper, Memo, Membership fees and Products | Counts for end of year |
|
Electronic business communication
|
1-Letterheads | Print and put in portfolio | Letterhead |
| 2-Dr M.A. Click | Print and put in portfolio | Layout of a letter | |
| 3-Letterheads | Print and put in portfolio | Printing on pre printed letterheads | |
| 4-Templates | Print 3 different templates, e.g. Professional, Contemporary, Elegant | Templates | |
| 5-LH_Social | Print and put in portfolio | Save as a template | |
| 6-Template | Print and put in portfolio Make a screendump of the New dialogue box with your template |
Use a template | |
| 7-Own templates | Print and put in portfolio | Create a memo | |
| 8-Activity 2 Based onActivity 2, Mr Click | Print and put in portfolio | Try to print an envelope AT HOME | |
| 9-Own template | Print and put in portfolio | Adapt a fax template | |
| 11-Sponsorship | Print and put in portfolio | Revision of adapting a letter, envelope, memo and fax coversheet | |
|
PAT 10 Oct |
Step 1.1 and 1.2 | Counts for end of year | |
|
PAT 17 Oct |
Step 2 | Counts for end of year | |
| PAT 31 Oct |
Step 3 | Counts for end of year | |
|
Computers in everyday life
Communication modes Chapter 1.1 Pages 44-47 Completed by 7 Nov |
5-Helping a business | Print and put in portfolio | |
| 6-Impact of technology | Print and put in portfolio |
Return to Computer Applications Technology index. This work may be freely copied for non-commercial use only. Copyright © Pam Miller.