Adult Numeracy, Functional Maths, and GCSE Resources

This is an Excel file with a basic odd/even activity. I took inspiration from Jean Thomas’ “Reveal the hidden shapes!” activity from 2005.

With this activity, the tutor can design a picture (or one learner can design a picture for another learner) and it produces a printable sheet. The learner then shades all the odd numbers on the sheet in one colour, and all the even numbers in a different colour – revealing a picture or a message.

There are no macros, so cross-compatibility with Excel shouldn’t be a problem.

Functional skills maths.
Extract information from mileage and distance (network) diagrams. Complete a mileage chart.
Editor’s note
With worked solutions, pop up help and a final challenge question.
Ideal as an introduction or for revision.

An interesting meld of description, investigation, paired discussion and tasks.
Ideal introduction to L1 averages – also useful at high E3.
Adapted from one page of Nikki Gilbey’s Data Collection and Averages – functional tasks (listed below under See also).

A counting game along similar lines to Snakes and Ladders. Learners will learn turn-taking, following instruction & basic counting skills. In addition, they will pick up social and communication skills along the way.

(Print onto A3 – a dice and counters needed)

Editor’s note
A PPT version is also included to enable the game to be played on a smartboard.

The main resource has four pages. Three of the pages contain a chart and a brief to a group of students to discuss and write some sentences saying what the chart tells them. The twist is that each group of 3 students has a different chart drawn from the same data as the groups next to them. The fourth page has the table from which the charts were drawn.

The charts used are: dual/clustered bar chart comparing types of drink sold on two days. A stacked/composite bar chart and a percentage bar chart of the same data.

Simulations of email and online banking registration forms. Can be used in succession, as for the banking registration form you need an email address. When you press the “create account” button it will open the printing menu. Good luck!

This activity encourages ESOL students:
- To communicate with each other while moving around the classroom,
- To revise Past Simple (questions and answers),
- To practise basic numeracy (subtraction).

With extensive teachers’ notes

An activity to explore money management and negative numbers. Be prepared to signpost students if need be.

The activity starts with discussing who is most likely to get into debt and then by recognising that anyone can if they don’t have good money skills.

Here is another Level 1-2 variant on the classic ‘Smarties’ investigation which incorporates the use of a PC and Excel. I stopped using Smarties and Skittles because of the health and hygiene issues.

This lesson is designed to embed adding and subtracting, ratio and proportion, etc. whilst looking at the important issue of alcohol consumption and units. Students are able to look at the RDA of alcohol consumption, binge drinking, etc. in the introductory PPT. They can then complete maths worksheet which involves calculating and adding units, converting units and reading data.
It includes a video clips, visual imagery and written notes.
Fully mapped to, and ideal for, L1 Functional Maths.