To see all of the work I do for TES Maths, including Resource of the Week, **Inspect the Spec**, Pedagogy Place, Maths Newsletters and Topic Collections, please visit the **TES Maths Blog here**

**What is it?**

You know sometimes you are looking for something very specific, to suit a certain need, and then you find it, and life is good? Well, that happened with this resource, and so I could not resist making it my Resource of the Week. I was planning a lesson on calculating an estimation of the mean from a frequency table for my Year 9 class, and I simply wanted some examples that they could do – lots of them. And this resource does just that. It is an Excel mean from a frequency table generator. Every time you hit “new question” you get a brand new table to complete, and best of all you can reveal the necessary steps to the solution step-by-step.

**How can it be used?**

I used this resource four ways:

1. I used it when going through a worked example. I took a screenshot of the incomplete table, pasted it onto a PowerPoint, and used this to talk students through the necessary steps. I was then free to flick back to the Excel version to check my calculations.

2. I next used it to generate examples for the students to practice. Again, the facility to check solutions at the click of a button was brilliant. And as a top-tip, I would recommend saving 4 versions of the resource, and then you can project 4 questions on the board at any one time. I show you what I mean in the video.

3. I used this resource to create practice questions and answers for my students’ homework

4. Finally, I have this resource saved on my desktop so I can quickly project a question at any stage to ensure students have never gone more than a month without practising this key skill

Thanks so much for sharing

Craig Barton

Download: **Mean from a Frequency Table Generator**

View the **author’s other resources**