5th January 2007 at 00:00
Ages 11 to 14

Teaching probability can be a nightmare. So much of the vocabulary is used in everyday life that it can be difficult for pupils to make the connection between theoretical and practical probabilities.

I didn't want a difficult Year 10 set throwing dice around all lesson, so I devised a way to get the spreadsheet program Excel to show how, on a fair die, the relative frequency of a six being thrown is 1 in 6.

The spreadsheet (which can be downloaded from "rolls a die" 1,000 times, then calculates the relative frequency of the sixes. A graph shows the tendency towards 0.166 recurring. The number of rolls or the die face number can be altered if you want to convince them a six is just as likely to come up as any other number. Press F9 to get a new selection of random rolls

Rob Percival teaches at Haberdashers' Aske's Boys' School in Hertfordshire

Log-in as an existing print or digital subscriber

Forgotten your subscriber ID?


To access this content and the full TES archive, subscribe now.

View subscriber offers


Get TES online and delivered to your door – for less than the price of a coffee

Save 33% off the cover price with this great subscription offer. Every copy delivered to your door by first-class post, plus full access to TES online and the TES app for just £1.90 per week.
Subscribers also enjoy a range of fantastic offers and benefits worth over £270:

  • Discounts off TES Institute courses
  • Access over 200,000 articles in the TES online archive
  • Free Tastecard membership worth £79.99
  • Discounts with Zipcar,, Virgin Wines and other partners
Order your low-cost subscription today