Kent ICT | Kent Trust Web provided by Kent County Council

Search Kent ICT

Uses

link to Kent County Council public website opens in a new window

Back to the Smulation and Modelling page

Year 6

Modelling and Simulations

Spreadsheet modelling

See also Year 5

Year Group

some children will not have made so much progress and will

most children will

some children will have progressed further and will

Year 6

Use a spreadsheet model with some understanding of the formulae needed, and be able to explain the results of different choices.

Add and amend a given ICT model to solve a problem through a review of the rules and variables. Be able to ask "What if?" and consider if the results are realistic.

E.g. Children explore the relationship between area and perimeter using a spreadsheet.

Be able to predict and test using the model, as part of some research.

E.g comparing costs and value of providers for an event.

Show elements of Level 4 - combine and refine information from various sources…interpret and question plausibility of information

Linked Planning

Linked Resources

Modelling and simulation

6B Spreadsheet modelling

Pocket Money

Area and perimeter - teacher

Area and perimeter - pupil

Shopping list

Maximum area -teacher

Maximum area -pupil

Spreadsheet modelling

Click here to download the planning seen below

Week	Area of study (From NC PoS)	Learning Objectives	Activities	Key Vocabulary	Resources	Assessment Outcomes
1	Explore models to answer 'What if ... ?'	To use a spreadsheet model to find answers to questions.	Use a pre-prepared spreadsheet (including formula) to calculate costs e.g. pocket money.	Spreadsheet Cell Columns & rows Formulae	Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet	Level 3: I can use ICT based models or simulations to help find things out and I am aware of the consequences of my choices. Level 4: I use a computer to investigate changes in patterns and relationships. I make changes to find out what happens. I can usually predict what might happen. Level 5: I can use an ICT model to test out an idea. I change values in the model to see if my idea is right or wrong.
2	Explore models to answer 'What if ... ?'	To enter formulae within a spreadsheet.	Enter formula within a pre-prepared spreadsheet to calculate costs e.g. shopping list.	Spreadsheet Cell Columns & rows Formulae	Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet
3	Explore models to answer 'What if ... ?'	To enter data and formulae within a spreadsheet.	Create a spreadsheet to calculate costs e.g. tuck shop.	Spreadsheet Cell Columns & rows Formulae	Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet
4	Explore models to answer 'What if ... ?'	To use a spreadsheet to perform calculations.	Create a spreadsheet to calculate the area of different rectangles.	Spreadsheet Cell Columns & rows Formulae	Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet
5	Identify patterns and relationships.	To use a spreadsheet to model to find patterns and relationships.	Create a spreadsheet to find the maximum area of a rectangle with a perimeter of 20cms.	Spreadsheet Cell Columns & rows Formulae	Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet
6	Identify patterns and relationships.	To create charts / graphs to find patterns and relationships.	Create charts / graphs using e.g. area & perimeter spreadsheet model.	Cell Columns & rows Formulae Graphs & charts	Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet
7	Investigate and evaluate the effect of changing values.	To investigate the effects of changing variables within a spreadsheet.	Create a spreadsheet model to provide costing for a party within a particular budget.	Cell Columns & rows Formulae Variables	Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet

| Published: 9-2-09 | TOP