Aug. 12, 2015
2Calculate packs in the power of a spreadsheet program using familiar language and icons that are more child friendly. Choose from a range of pre-made lessons or create your own from scratch. Here are some we made earlier to get you ready for the start of term:
KS1 – Counting Fish
This is a fun sea-themed activity for KS1 to encourage children to count up to 20 and use problem solving skills. They could be asked questions like ‘how many starfish are there’ or ‘how many crabs do you see?’ And they can hear and see the answer in the red box.
KS1 – Animal Values
Children in Year 2 can use commutativity and inverse relations to develop reasoning and work out the value of each animal. If the cow is equal to 1 the rest is straightforward.
Lower KS2 – Even Numbers
Why not get your class to investigate which even numbers can be made by totalling the numbers on 3 dice or more?
Get pupils to roll the dice by clicking on the images and ask them to record their findings in the columns provided. Remember, we're only interested in outcomes with even numbers!
Lower KS2 – Sequencing
See interesting patterns emerge by recolouring the squares on each multiple up to the 12 times table and use the spin tool thereafter to predict the rest.
Children can make new and interesting patterns by putting a twist on a times table with sums like 8x12+1=97.
Upper KS2 – Common Letters and Hypothesis
Which is the most popular letter in the English language or in this case the spreadsheet?
Pupils can test out a hypothesis by splitting the variables into vowels and consonants. And using the how many tool (i.e. the hand) will count the number of letters.
Upper KS2 – Statistics and Graphs
A really good activity could be to ask children to time each other running or to measure each other’s height. This can then be recorded in a spreadsheet to interpret information and the mean as an average. A line graph, bar chart or pie chart can be used to present the findings.