Level 2 Data handling
Students use official data about accidents to calculate relative frequencies and probabilities of different accidents occurring. Emphasis is given to the reliability both of the data and the conclusions that can be drawn.
Students consider the difficulties in using real data to answer questions such as ‘Which is the most dangerous sport? Students discuss which types of statistical diagram are most appropriate for displaying the data before setting off to draw them. They may practise drawing statistical diagrams either using Excel or by hand.
A very open investigation in which students may set their own statistical tasks based on sleep requirements.
Students use weather data to consider which month would be the best to hold an outdoor music festival.
They practise using either a calculator in Statistics mode or a spreadsheet to calculate mean and standard deviation values.
Spreadsheet with data for students (217 KB)
Spreadsheet with data for teachers (275 KB)
Teacher notes word (75 KB) Teacher notes pdf (453 KB)
A Calculator activity:
Slides (2.3 MB)
Student sheets Word (84 KB) Student sheets pdf (446 KB)
B Spreadsheet activity:
Slides (2.2 MB)
Student sheets Word (83 KB) Student sheets pdf (446 KB)
An introduction to conversion graphs and direct proportionality in the context of currency conversion, reading and plotting graphs and calculating gradients. One question uses a spreadsheet.
Students are shown how to draw and format cumulative frequency graphs in Excel.
Spreadsheet (720 KB)
Student sheets for Excel 2003 Word (0.9 MB)
Student sheets for Excel 2003 pdf (511 KB)
Student sheets for Excel 2007 Word (2.3 MB)
Student sheets for Excel 2007 pdf (1.0 MB)
Teacher notes Word (93 KB)
Teacher notes pdf (404 KB)
A statistical investigation into students’ paid employment. Students design questionnaires, find averages and the range, and draw charts and graphs. Data analysis can be on paper or spreadsheets.
Students complete data tables, then draw, read and interpret linear graphs where the intercept on the y axis is not zero. Interpretation includes finding where two linear graphs meet. The last part requires a spreadsheet – omit if computers not available.
For level 2 the work could be refocused to introduce algebraic graphs.
Students plot graphs of real data to compare the straight-line distances between towns with the distance by road
Students collect data and then use statistical methods to analyse the results.
Students are shown how to measure their pulse rate. They then investigate the effect that other things like exercise and relaxation have on it.