Managing money

Skill Activities

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.

Find %
Find % without a calculator and on a spreadsheet.

Student Information (application/msword, 392 KB) (application/pdf, 238 KB)
Spreadsheet (application/vnd.ms-excel, 19 KB)

Firefighters' Pay
Students compare rises of 11%, 16% and 40% in the annual pay of 4 different ranks of firefighters and the difference this might make to a fireman's savings. Answers in a separate Teacher Notes file. Contributed by Joan Ridgway from Exeter College.

Student Information (application/msword, 46 KB) (application/pdf, 11 KB)
Teacher Notes (application/vnd.ms-excel, 28 KB)

Interest Rates
Includes a table of interest rates. Students compare compound and simple interest. Contributed by Joan Ridgway from Exeter College.

Student Information (application/msword, 46 KB) (application/pdf, 15 KB)
Teacher Notes (application/msword, 42 KB) (application/pdf, 11 KB)
Table of interest rates (application/vnd.ms-excel, 43 KB)

Sale
Students use a spreadsheet to work out sale prices and check their results. Teacher Notes included.

Activity and teacher notes (application/msword, 191 KB) (application/pdf, 81 KB)
Spreadsheet (application/vnd.ms-excel, 16 KB)

Student Budget
A spreadsheet showing a student's bank balance over a term and a worksheet based on it. Answers and Teacher Notes in separate files. Contributed by Joan Ridgway from Exeter College.

Student Information (application/msword, 87 KB) (application/pdf, 37 KB)
(1) Student spreadsheet and (2) Answers (application/vnd.ms-excel, 23 KB) (application/vnd.ms-excel, 51 KB)
Teacher Notes (application/msword, 41 KB) (application/pdf, 11 KB)

VAT
Find VAT without a calculator and on a spreadsheet.

Student Information (application/msword, 581 KB) (application/pdf, 125 KB)
Spreadsheet (application/vnd.ms-excel, 14 KB)

Which mobile phone tariff?
Students enter values onto the Excel spreadsheet, explain calculations then choose the most suitable tariff. Contributed by Alison Brittle from Hopwood Hall College.

Student Information: (application/msword, 53 KB) (application/pdf, 18 KB)
Spreadsheet: (application/vnd.ms-excel, 18 KB)

Checking Methods
Bills to check using a range of methods. Contributed by Alison Brittle from Hopwood Hall College.

Student Information: (application/msword, 47 KB) (application/pdf, 17 KB)

Invoice Calculations
Calculations for students to complete & check. Contributed by Alison Brittle from Hopwood Hall College.

Student Information: (application/msword, 94 KB) (application/pdf, 20 KB)

Electricity Bill
Table giving information and a bill to check. Contributed by Alison Brittle from Hopwood Hall College.

Student Information: (application/msword, 79 KB) (application/pdf, 18 KB)

Percentages
Powerpoint presentation shows the relationship between fractions, decimals and percentages. Worksheet and spreadsheet give practice with percentages in contexts involving money. Teacher Notes included.

Student information (application/msword, 387 KB) (application/pdf, 121 KB)
Spreadsheet (application/vnd.ms-excel, 18 KB) PowerPoint (application/vnd.ms-powerpoint, 116 KB)

Overtime
For giving students practice in using a spreadsheet to work out overtime rates. Contributed by Sandra Westlake & Jackie Walker from Kingsbridge Community College.

Worksheet (application/msword, 50 KB) (application/pdf, 11 KB)

Savings and interest
Worksheet to give students practice with working out interest and amounts in accounts after 1 year. Contributed by Sandra Westlake & Jackie Walker from Kingsbridge Community College.

Worksheet (application/msword, 96 KB) (application/pdf, 16 KB)

Calculating VAT
Worksheet to give students practice with working out 5% VAT on fuel bills. Contributed by Sandra Westlake & Jackie Walker from Kingsbridge Community College.

Worksheet (application/msword, 46 KB) (application/pdf, 11 KB)

Create a bank statement
Sheet of transactions to put in order to create a bank statement. Contributed by Sandra Westlake & Jackie Walker from Kingsbridge Community College.

Students information (application/msword, 43 KB) (application/pdf, 15 KB)

Simple and Compound Interest
Spreadsheet gives examples and practice for students. Answers provided in a separate spreadsheet. Contributed by Su Nicholson from Loreto College.

Examples for students (application/vnd.ms-excel, 31 KB) Answers (application/vnd.ms-excel, 35 KB)

Bank Balance
Game in which learners enter items onto bank balance statements and calculate the resulting balances.

Students information and teacher notes (application/msword, 640 KB) (application/pdf, 328 KB)

Ratio Bingo & Matching Cards
Activities that give learners practice in simplifying ratios. Teacher notes included.

Ratio Bingo & Matching Cards (application/pdf, 28 KB) (application/msword, 127 KB)

Spot the errors
Simulated invoice, phone bill and bank statement for learners to check (several errors on each). Also provided with spaces for students to complete.

Student worksheets (application/msword, 349 KB) (application/pdf, 125 KB)

Fractions, decimals and %
A series of worksheets for practice in converting between fractions, decimals and percentages. Includes Teacher Notes with weblinks to useful internet resources.

Fractions, decimals and % work sheets (application/msword, 518 KB) (application/pdf, 426 KB)