Activities for Introducing Spreadsheets

After lots of requests it’s finally here - a collection of 10 activities to help introduce children to entering formulae into spreadsheets. Starts at the basics of cell referencing and using simple formulae, moving onto more complex formulae (e.g. SUM, MIN, MAX, AVERAGE) and ending with some modelling problems and maths investigations for children to complete. I WOULD LOVE TO READ ANY FEEDBACK / COMMENTS YOU HAVE :-) Topics also included: Interpreting data.


Save for later
  • 1. Wizard's Challenge.xls
  • Formula Prompts.ppt
  • 2. The Gold Mine.xls
  • 3. Recap Challenge.xls
  • 4. Blank Spreadsheet.xls
  • 5. Sweets Problem.xls
  • SUM Prompt Sheet.doc
  • 6. Race Points.xls
  • 7. Shopping Bills.xls
  • 8. Game Points.xls
  • 9. Pocket Money Problem.xls
  • 10. Attendance Register Investigation.xls
  • An Introduction to Spreadsheets Detailed Planning.pdf

About this resource


Created: Mar 7, 2010

Updated: Feb 22, 2018

xls, 58 KB

1. Wizard's Challenge

ppt, 11 KB

Formula Prompts

xls, 152 KB

2. The Gold Mine

Report a problem

Tes Classic Free Licence

How can I re-use this?