Handling and interpreting data

Skill Activities

We welcome feedback and contributions. If you have any comments, ideas or resources to offer please contact June Haighton.

Please note that resources added most recently are at the bottom of the page.

A Risky Business
Data Sheet involving accidents in the home, at work and at leisure, probability worksheet and Teacher Notes including answers. (Spreadsheet contains the same data)

Student Information (application/msword, 638 KB) (application/pdf, 82 KB)
Spreadsheet (application/vnd.ms-excel, 31 KB)

Athletics
Excel spreadsheet contains large datasets of track and field events. Teacher notes give suggestions for their use.

Teacher Notes: (application/msword, 47 KB) (application/pdf, 11 KB)
Spreadsheet: (application/vnd.ms-excel, 663 KB)

Box and Whisker Plots
Students can use this Excel spreadsheet to draw up to 4 box and whisker plots. Includes instructions. Contributed by Lindy McGuinness of Braintree College.

Spreadsheet (application/vnd.ms-excel, 37 KB)

Climate
Excel spreadsheet containing sunshine, rainfall and temperature data for England and Wales, Northern Ireland and Scotland for each month in every year from 1961.

Spreadsheet (application/vnd.ms-excel, 73 KB)

Datasets
Data concerning road accidents, causes of mortality, marriage, divorce and food consumption in an Excel spreadsheet.

Spreadsheet (application/vnd.ms-excel, 690 KB)

Histogram
Instructions explaining how to construct an accurate histogram and frequency polygon in Excel. Contributed by Linda McGuinness of Braintree College.

Student Information (application/msword, 97 KB) (application/pdf, 35 KB)

Interpreting Curves
Discussion sheets and exercise on interpreting and sketching line graphs. Focuses on the shape of graphs. Teacher Notes included.

Student Information: (application/msword, 455 KB) (application/pdf, 255 KB)

Safety on the Roads
Graphs and charts for interpretation. Teacher Notes included. This activity is only available as a pdf as the word file would be too big.

Student Information (application/pdf, 124 KB)

Election results for Handling and Interpretating data
Spreadsheet containing the 2001 and 2005 General Election Results. Select data for your students to use to practise drawing charts, finding % etc.

Excel spreadsheet (application/vnd.ms-excel, 279 KB)

Cumulative frequency graphs in Excel
Activity that shows students how to draw a cumulative frequency graph in Excel. Teacher notes included.

Student Information and Teacher notes: (application/msword, 621 KB) (application/pdf, 323 KB)

Applying for HE
Data Sheets and spreadsheet giving gender, age, ethnic origin and other information about HE applicants. Worksheet and Teacher Notes suggest uses.

Students information and teacher notes (application/msword, 300 KB) (application/pdf, 120 KB)
Spreadsheet (application/vnd.ms-excel, 30 KB)

Football Figures
Excel spreadsheet containing 2007-8 data for each premier league club. Teacher Notes suggest uses.

Teachers notes (application/pdf, 21 KB) (application/msword, 55 KB)
The spreadsheet (application/vnd.ms-excel, 318 KB)

Sports Injuries
Discuss the use of real data (gives age and gender, also included on spreadsheet.)

Data Sheet (application/msword, 160 KB) (application/pdf, 59 KB)
Worksheet (application/vnd.ms-excel, 16 KB)

% Cards
3 sets of cards for matching fractions, decimals and %.

Cards (application/pdf, 16 KB) (application/msword, 110 KB)

% Follow Me
Group activity to give practice in converting between fractions, decimals and %s.

% Follow Me activity (application/pdf, 32 KB) (application/msword, 396 KB)

House prices Feb10
Excel spreadsheet containing house price data from 1983 to 2009 for each country and region of the UK. Introduction suggests uses.

(application/vnd.ms-excel, 32 KB)