Interactive statistics worksheets for GCSE

Read me text
About Cathy


The spreadsheets ...

Download: explanation of use

Sampling

Capture-recapture

10 mins teacher led introduction to Capture Re-capture;
10 mins student practice.

 

Stratified sampling

15 mins teacher led introduction to Stratified Sampling including adjusting the sample if needed to achieve the correct sample size. With small sample sizes, we also looked at using a random number table to select the students; 15 mins student practice.

Tabulation &
representation

Calculating pie-charts

10 mins teacher led introduction to pie charts;
15 mins student practice including time spent drawing out the pie charts

 

Comparative pie-charts

15 mins teacher led introduction to comparative pie charts. Students were encouraged to do this by looking at decimal multipliers for area as this more closely related to work done recently for their GCSE Maths exam on similar shapes and enlargements; 15 mins student practice.

 

Two way tables and probability

10 mins teacher led introduction to two-way tables and probability; 10 mins student practice - students were encouraged to work from tab 1 then tab 2 then back to tab 1 etc to get as much practice as possible.

Measure of
average

Mean and median from frequency distribution

10 mins teacher led introduction to mean from a frequency distribution [first tab] and discussion of mode; 10 mins student practice; 10 mins teacher led introduction to median from a frequency distribution [second tab]; 10 mins student practice. More able students should be encouraged to calculate the mean, mode and median on the second tab.

 

Mean from a grouped frequency distribution

15 mins teacher led introduction to mean from a grouped frequency distribution, discussion of mode and use of questions to create cumulative frequency graphs and estimate the median; 20 mins student practice – 10 mins on means and 10 mins creating cumulative frequency graphs and estimating the median.

 

Geometric mean

5 mins teacher led introduction to geometric mean; 5 mins student practice

Standard
deviation

Standard deviation

15 mins teacher led introduction to standard deviation where the mean is a whole number [first tab]; 15 mins student practice; 10 mins teacher led introduction to standard deviation where the mean is a decimal [second tab]; 10 mins student practice. More able students encouraged to use both methods on the second tab and check that they got the same answer before entering it and checking it on the computer.

Spearman's
rank

Spearman's rank

15 mins teacher led introduction to Spearman’s rank (first tab) 15 mins student practice 5 mins teacher led introduction to tied ranks (second tab) 10 mins student practice on tied ranks (third and fourth tabs)