Spreadsheet Activities


These pages, aimed at students and teachers at Key Stages 1/2 of the UK National Curriculum, take you through a series of ICT activities using spreadsheets. The activities will be useful in classroom and professional contexts. All the activities use MS Excel, but could be adapted for other appropriate software packages. The activities are:
Analysing data from an investigation into frictional forces: Comparing the distances travelled by toy cars from a ramp
Investigating data from a survey of a group of pupils, including height, weight, shoe size, etc.
Creating a spreadsheet model to explore the costs of a children's party
Formatting a record of pupils' achievements
Standardising a set of test scores
Creating a spreadsheet model to help in planning educational visits
Do reaction times improve with practice? A spreadsheet template.

The activities assume a basic knowledge of spreadsheet conventions and terms. To see a MS PowerPoint slide showing the terms used - click here.

MS Excel example files can be downloaded from the relevant pages.