About cookies

The NCETM site uses cookies. Read more about our privacy policy

Please agree to accept our cookies. If you continue to use the site, we'll assume you're happy to accept them.


Personal Learning Login

Sign Up | Forgotten password?
Register with the NCETM

Spreadsheets – Data Handling

This page has been archived. The content was correct at the time of original publication, but is no longer updated.
Created on 31 March 2011 by ncetm_administrator
Updated on 01 March 2012 by ncetm_administrator


Spreadsheets – Data Handling

A staff development workshop on using digital technologies for a group of teachers

Given that Excel is widely available in schools, this workshop aimed to revisit the potential of Excel to support statistical investigations. By using Excel to perform calculations and to create charts and graphs the focus can be shifted from the mechanics of the calculations and creation of charts with pencil and paper to the use and interpretation of them.

This workshop aims to enable delegates to undertake a statistical investigation based on a large data set by:

  • Learning to use a spreadsheet to sort and filter large data sets;
  • Using the spreadsheets’ statistical functions including: SUM; AVERAGE; MODE; MEDIAN to generate averages and measures of spread quickly and accurately for large data sets so that these values can be compared and interpreted;
  • Using a spreadsheet to create relevant and appropriate charts and diagrams in order to answer questions posed about large data sets;
  • Learning to use graphs and charts produced by a spreadsheet in word processing document.

Workshop Outline

Workshop Files

Download as a zip file Download as a zip file

* To download these files to your computer right click and press "save as".




Comment on this item  
Add to your NCETM favourites
Remove from your NCETM favourites
Add a note on this item
Recommend to a friend
Comment on this item
Send to printer
Request a reminder of this item
Cancel a reminder of this item



There are no comments for this item yet...
Only registered users may comment. Log in to comment