Year 6
	Multimedia Presentation		Spreadsheet Modelling
	Control and Monitoring		Internet

In this unit pupils learn to use a spreadsheet to explore a mathematical model. They 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. Pupils will apply what they have learnt in this unit when exploring mathematical and scientific models.

6B Lite (ICT Lites are concise sheets showing the objectives, key skills and techniques to be taught, without the suggested teaching activities.)

Assessment: Pupil Self Review Statements

Teaching Activities l Resources

Teaching Activities

Textease and Excel Resources
www.learn-ict.org.uk

Spreadsheets in Numeracy

Spreadsheets in Science

Problem Solving - Are small bananas better value than big bananas?
The Banana lesson is an alternative integrated task for unit 6B, with links to Science.
Download Banana Lesson

See also ICT 5D Spreadsheets

Teaching Resources

Ideas and Examples of Spreadsheets by Devon ICT
A good site for resources
www.devon.gov.uk/dcs/ict/models

ICT Scheme of work by Greenwich ICT
A complete set of resources linked to the QCA scheme of work with lesson plans, activities, downloadable resources and more.
www.lgfl.net/lgfl/leas/greenwich

Newham ICT Scheme of Work
Featuring active flip chart resources and tutorial videos. Importantly every unit contains a challenge lesson which gives the children an opportunity to develop their independent ICT capability. www.itass.newham.gov.uk/curriculum/sow.aspx

Year 6
	Multimedia Presentation		Spreadsheet Modelling
	Control and Monitoring		Internet

Back to QCA ICT index page