# Level 2 Data handling

##
**A risky business **

**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.**

S [2]lides (1.3 MB) [2]

S [3]tudent sheets Word [3]

S [4]tudent sheets pdf [4]

T [5]eacher notes Word [5]

T [6]eacher notes pdf [6]

##
**Sports injuries **

**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.**

Slides (3 MB) [7]

Student data [8]

Student sheets Word [9]

Student sheets pdf [10]

Teacher notes Word [11]

Teacher notes pdf [12]

##
**Larks and owls **

**A very open investigation in which students may set their own statistical tasks based on sleep requirements. **

Slides (1.5 MB) [13]

Student sheets Word (248 KB) [14]

Student sheets pdf (482 KB) [15]

Teacher notes Word (172 KB) [16]

Teacher notes pdf (447 KB) [17]

##
**Music Festival**

**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) [18]

Spreadsheet with data for teachers (275 KB) [19]

[20]Teacher notes word (75 KB) [20] [21]Teacher notes pdf (453 KB) [21]

**A Calculator activity:**

[22]Slides (2.3 MB) [22]

Student sheets Word (84 KB) [23] [24]Student sheets pdf (446 KB) [24]

**B Spreadsheet activity:**

Slides (2.2 MB) [25]

Student sheets Word (83 KB) [26] Student sheets pdf (446 KB) [27] [28]

##
**Currency conversion**

**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.**

Slides (1.4 MB) [29]

S [30]tudent sheets Word 2007 (74 KB) [30]

S [31]tudent sheets pdf (444 KB) [31]

T [32]eacher notes Word (78 KB) [32] T [33]eacher notes pdf (457 KB) [33]

##
**Pay rates for men and women - Excel activity**

**Students are shown how to draw and format cumulative frequency graphs in Excel.**

Spreadsheet (720 KB) [34]

Student sheets for Excel 2007 Word (2.3 MB) [35]

[36]Student sheets for Excel 2007 pdf (1.0 MB) [37]

[38]Teacher notes Word (93 KB) [39]

[40]Teacher notes pdf (404 KB) [41]

##
**Part-time work survey**

**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. **

S [42]lides (1.5 MB) [42]

S [43]tudent sheets Word (243 KB) [43]

[44]S [45]tudent sheets pdf (505 KB) [45]

[46]T [47]eacher notes Word (438 KB) [47] T [48]eacher notes pdf (76 KB) [48] [49]

##
**Plumber's call-out**

**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.**

[50] [51]Slides (1.3 MB) [51]

[46] [52]Student sheets Word (169 KB) [52]

[53]Student sheets pdf (547 KB) [53]

[46] [54]Teacher notes Word (75 KB) [54] [55]Teacher notes pdf (485 KB) [55]

##
**Shorter by helicopter**

**Students plot graphs of real data to compare the straight-line distances between towns with the distance by road. **

Slides (1.5 MB) [56]

Student sheets Word (220 KB) [57] Student sheets pdf (410 KB) [58]

Teacher notes Word (70 KB) [59] Teacher notes pdf (474 KB) [60]

##
**Five a day**

**Students collect data and then use statistical methods to analyse the results.**

Slides (3.0 MB) [61]

Student sheets Word (3.2 MB) [62]

Student sheets pdf (343 KB) [63]

Teacher notes Word (163 KB) [64]

Teacher notes pdf (511 KB) [65]

##
**Heart rate**

**Students are shown how to measure their pulse rate. They then investigate the effect that other things like exercise and relaxation have on it.**

Slides (1.1 MB) [66]

Student sheets Word [67](159 KB) [68]

Student sheets pdf (319 KB) [69]

[69] Teacher notes Word (140 KB)

[70] Teacher notes pdf (357 KB) [71]