Finding Things Out 
In order to solve a problem use ICT to collect and process data and present their findings. Be able to create a database and compare graphical data.
Year Group  some children will not have made so much progress and will  most children will  some children will have progressed further and will 
Y5  Be able to develop a database, or create a yes/no branching database to identify something. Will need help interpreting data presented graphically.  In order to solve a problem use ICT to collect and process data and present their findings. Be able to create a database and compare graphical data. E.g. Children investigate the difference between the life expectancy of children in Victorian and modern times. 
Generate, process, interpret and store and present data, understanding the need for accuracy. 



Year Group  some children will not have made so much progress and will  most children will  some children will have progressed further and will 
Y5  Use a preprepared spreadsheet model to explore the effects of changes. Use a provided graphical model to test spatial theories.  Use ICT based models to explore variables to solve problems. Some will understand the principles behind spreadsheet formulae and start to create their own. e.g. Use a preprepared spreadsheet to calculate costs of ingredients for biscuits, or supplying an event. Pupils answer questions about price or quality changes 
Create their own spreadsheet model with formulae, which they can explain and adjust if necessary. Be able to review rules and variables and make predictions about the consequences of decisions. 



Introduction to Spreadsheets 
MAPE Greenfield Road The 19th Century database  
Formulae  
Click here to download the planning seen below
Week 
Area of study (From NC PoS) 
Learning Objectives 
Activities 
Key Vocabulary 
Resources 
Assessment Outcomes 
1 
Enter and store information …. think about what might happen if there were any errors … 
To enter information into a spreadsheet. 
Demonstrate how to enter the results of a science investigation into a spreadsheet. Pupils create their own table. 
Spreadsheet 
Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet 
Level 4: Level 5: I can check it is accurate and organise this information so that it is ready for processing. 
2 
Interpret information, to check it is relevant and reasonable. 
To create charts and graphs using a spreadsheet. 
Pupils use the spreadsheet to create a line graph, pie chart & bar chart. Which type is most helpful? Interpret the chart / graph. 
Spreadsheet 
Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet 

3 
Interpret information …. think about what might happen if there were any errors … 
To create charts and graphs using a spreadsheet. 
Pupils enter a list of the ingredients to make bread & their costs into a spreadsheet. Pupils create a chart to show the costs of each item. 
Spreadsheet 
Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet 

4 
Interpret information …. think about what might happen if there were any errors … 
To use formula within a spreadsheet. 
Pupils enter formula into a spreadsheet to find out the total cost. Pupils explore changing the costs and using other formula. 
Spreadsheet 
Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet 

5 
Interpret information …. think about what might happen if there were any errors … 
To use a spreadsheet to record the costs of planning an event. 
Pupils are given a budget & create a spreadsheet to record the costings for a party. Pupils create charts to show these costs and use formula to calculate total. 
Spreadsheet 
Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet 