• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Whenever you search in PBworks or on the Web, Dokkio Sidebar (from the makers of PBworks) will run the same search in your Drive, Dropbox, OneDrive, Gmail, Slack, and browsed web pages. Now you can find what you're looking for wherever it lives. Try Dokkio Sidebar for free.



Page history last edited by John Pearce 9 years, 7 months ago
Analysing - Science And ICT
Observing rat behaviour by jepoirrier

Science investigation by its very nature generates lots of data, often more than children can make sense of in its raw form. Spreadsheet programs such as Excel and/or Google Spreadsheets can be used to generate graphical representation of this data in order to identify trends and make suggestions as to the reasons for these trends.



  • These can be embellished with images, different fonts and colours to enhance them such that the student doesn't even notice that they are working on a spreadsheet. An Excel XP tutorial demonstrating how to make these templates is included.


  • Once the data has been collected, (or even as it is being collected), children can then analyse and comment on trends as in this Case Study.



Similar types of spreadsheets can be made with Google Spreadsheets and Google Forms are another great way to gather data for analysis.


Comments (0)

You don't have permission to comment on this page.