Standards Site

 
 
Schemes of Work
QCA

ICT at key stages 1 and 2    (Year 6)

Unit 6B: Spreadsheet modelling

QCA
About this unit

In this unit children learn to use a spreadsheet to explore a mathematical model.

Children will be taught to use formulae in spreadsheets to answer 'what if ...?' questions. They will explore how changes in a spreadsheet affect results and identify simple rules.

Children will apply what they have learnt in this unit when exploring mathematical and scientific models.


Sections in this unit

This unit is divided into sections. Each section contains a sequence of activities with related objectives and outcomes. You can view this unit by moving through the sections or print/download the whole unit.
1. SETTING THE SCENE
2. SHORT FOCUSED TASKS
3. SHORT FOCUSED TASKS
4. SHORT FOCUSED TASKS
5. INTEGRATED TASK