Algebra for a purpose: using spreadsheets in KS2 and 3

The book consists of 6 tasks which may involve solving an intriguing problem, finding a strategy for winning a game or writing an explanation for someone else of how or why something works. By working on tasks which have a clear purpose pupils have the opportunity to understand why algebra is useful. The six tasks are designed to introduce key ideas in the early stages of learning about algebra through working with spreadsheets. They have been designed to relate to specific aspects of the existing curriculum, and require only a small amount of expertise in using spreadsheets.

Each of the 6 tasks has a pupil activity sheet, teacher's notes and a case study describing work in the classroom. The accompanying CD has prepared spreadsheets, whiteboard resources and copies of the pupil activity sheets. Suitable for KS2/3

Show health and safety information

Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.

Author(s)Janet Ainley, Liz Bills, Kirsty Wilson
Age7-11, 11-14
Published by

Shelf referenceA 510 ATM
Direct URL

This is a physical resource. Come and visit the National STEM Learning Centre library to see it.

Find out more about the Centre