ICT at key stages 1 and 2 (Year 6)

Unit 6B: Spreadsheet modelling

Objectives

Section 1: SETTING THE SCENE
Children should learn:

key idea: that mathematical models can be explored using a spreadsheet

View related activities and outcomes

Section 2: SHORT FOCUSED TASKS
Children should learn:

technique: to identify formulae and enter them into a spreadsheet

View related activities and outcomes

Section 3: SHORT FOCUSED TASKS
Children should learn:

technique: to copy cells

View related activities and outcomes

Section 4: SHORT FOCUSED TASKS
Children should learn:

technique: to use a spreadsheet to draw a graph

View related activities and outcomes

Section 5: INTEGRATED TASK
Children should learn:

to change the data and formulae in a spreadsheet to answer 'what if ...?' questions and check predictions

View related activities and outcomes

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