Making sense of 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.

Acid Rain.
Worksheet explains how acid rain is produced and requires students to analyse the data given in the accompanying spreadsheet.

Student Information: (application/msword, 48 KB) (application/pdf, 24 KB)
Spreadsheet: (application/vnd.ms-excel, 41 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)

College Trip
Includes a distance-time graph for interpretation. Contributed by Margaret Pickersgill, Bradford College. Updated April 2010.

Student Information: (application/ms-word, 57 KB) (application/pdf, 13 KB)

Crushed Calcium Carbonate
Includes data and line graph of a chemical reaction for interpretation. Contributed by Margaret Pickersgill, Bradford College. Updated May 2010.

Student Information: (application/ms-word, 71 KB) (application/pdf, 20 KB)

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

Student Information: (application/msword, 426 KB) (application/pdf, 228 KB)

Eclipse
Data sheets about eclipses. Discussion sheet and exercise involving interpretation of statistical diagrams. Teacher Notes included.

Student Information: (application/msword, 334 KB) (application/pdf, 190 KB)

Line Graphs (Revised version)
Examples and exercises on conversion graphs (for direct proportionality) and other linear graphs. One question in each exercise requires use of a spreadsheet. Contributed by Alison Brittle from Hopwood Hall College.

Student Information: (application/msword, 80 KB) (application/pdf, 33 KB)

On Average
Examples and exercises on mean, mode and median. Contributed by Alison Brittle from Hopwood Hall College.

Student Information: (application/msword, 63 KB) (application/pdf, 49 KB)

Reaction rates
Drawing and interpreting graphs using data provided from chemical reactions. Requires graphs to be drawn using a spreadsheet as well as by hand. Teacher notes included.

Student Information: (application/msword, 120 KB) (application/pdf, 62 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 Making sense of Data
Spreadsheet containing the 2005 and 2010 UK General Election results. Select data for your students to use to practise drawing charts, finding percentages, and so on.

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

Graphs
12 pairs of cards for students to match. One card in each pair shows a graph and the other gives a description of the real situation that the graph represents. Powerpoint presentation to aid discussion (shows the same graphs with titles and labels added). Teacher Notes included.

Students information and teacher notes (application/msword, 95 KB) (application/pdf, 21 KB)
PowerPoint presentation (application/vnd.ms-powerpoint, 93 KB)

Ratio Bingo & Matching Cards
Activities that give learners practice in simplifying ratios. Teacher notes included.

Ratio Bingo & Matching Cards (application/pdf, 28 KB) (application/msword, 127 KB)

Fractions, decimals and %
A series of worksheets for practice in converting between fractions, decimals and percentages. Includes Teacher Notes with weblinks to useful internet resources.

Fractions, decimals and % work sheets (application/msword, 518 KB) (application/pdf, 426 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)

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)

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

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

% Crossnumber
Can be used at the end of work on percentages or for revision.

% Crossnumber activity (application/pdf, 24 KB) (application/msword, 96 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)