ICT at key stages 1 and 2 (Year 6)

Unit 6B: Spreadsheet modelling

Outcomes

Section 1: SETTING THE SCENE
Children:

understand that spreadsheets can be used to explore mathematical models

View related objectives and activities

Section 2: SHORT FOCUSED TASKS
Children:

identify and enter the correct formulae into cells, modify the data, make predictions of changes and check them

View related objectives and activities

Section 3: SHORT FOCUSED TASKS
Children:

copy formulae to create tables of results

View related objectives and activities

Section 4: SHORT FOCUSED TASKS
Children:

create graphs

View related objectives and activities

Section 5: INTEGRATED TASK
Children:

create and use a spreadsheet to identify an optimum shape

View related objectives and activities

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