Managing money

Assignments

We welcome feedback and contributions. If you have any comments, ideas or resources to offer please contact June Haighton.

Please note that resources added most recently are at the bottom of the page.

Bank Statement
Students create a spreadsheet to show income and expenditure over two months then analyse the information using graphs, charts and statistical measures. Contributed by Jenny Robinson from Highlands College.

Student Information (application/msword, 121 KB) (application/pdf, 72 KB)

Bills
Simulated water, electricity and gas bills, exercise and sample examination questions based on these bills and an assignment. Exercise involves checking calculations and using the Excel spreadsheet.

Student Information: (application/msword, 268 KB) (application/pdf, 89 KB)
Teacher Notes: (application/msword, 187 KB) (application/pdf, 30 KB)
Spreadsheet: (application/vnd.ms-excel, 20 KB)

Car costs
Assignment and sample examination questions supported by three data sheets. Assignment requires students to use a spreadsheet to keep an account of the cost of running a car.

Student Information: (application/msword, 174 KB) (application/pdf, 192 KB)
Teacher Notes: (application/msword, 92 KB) (application/pdf, 26 KB)

Earning Interest
Students use information from the internet to investigate the interest earned on an inheritance in different savings accounts. Optional use of spreadsheet. Contributed by Jenny Robinson from Highlands College.

Student Information (application/msword, 56 KB) (application/pdf, 54 KB)

Have a Holiday
Data sheet giving information about holiday costs, an assignment and sample examination questions based on this sheet. Optional use of Excel spreadsheet.

Student Information: (application/msword, 213 KB) (application/pdf, 253 KB)
Teacher Notes: (application/msword, 69 KB) (application/pdf, 25 KB)
Spreadsheet (application/vnd.ms-excel, 17 KB)

Invoice Assignment
Students use the Excel spreadsheet and explain and check calculations on bills or invoices. Contributed by Alison Brittle from Hopwood Hall College.

Student Information: (application/msword, 91 KB) (application/pdf, 26 KB)
Spreadsheet: (application/vnd.ms-excel, 25 KB)

Party Time
Students use on-line shopping to find best buys and cost a party. Optional use of spreadsheet. Contributed by Jenny Robinson from Highlands College.

Student Information (application/msword, 81 KB) (application/pdf, 86 KB)

Best buy
Assignment with structured section on best buys followed by an extension that gives students the opportunity of working independently. Contributed by Joseph Chamberlain Sixth Form College.

Student Information: (application/msword, 113 KB) (application/pdf, 36 KB)

Ordering from a catalogue
Students choose furniture for a bedroom and complete an order form. Also includes use of a scale diagram to cover some of the other portfolio requirements for Application of Number at Level 1. Contributed by Joseph Chamberlain Sixth Form College.

Student information: (application/msword, 103 KB) (application/pdf, 45 KB)
Student information (application/msword, 293 KB) (application/pdf, 510 KB)