Developing ideas and making things happen 
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. Spreadsheet modelling
.
Year Group  some children will not have made so much progress and will  most children will  some children will have progressed further and will 
Y6  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. 
I know how to enter formulae, change data and predict the results. 
I know how to format cells to fix the number of decimal places. 
I know how to adapt, or create a new model to answer new questions 
Spreadsheet modelling 
Area and perimeter  pupil  
Maximum area pupil 
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 preprepared spreadsheet (including formula) to calculate costs e.g. pocket money. 
Spreadsheet 
Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet 
Level 3: Level 4: Level 5: 
2 
Explore models to answer 'What if ... ?' 
To enter formulae within a spreadsheet. 
Enter formula within a preprepared spreadsheet to calculate costs e.g. shopping list. 
Spreadsheet 
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 
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 
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 
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 
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 
Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet 