TES Maths ROTW: Test maker

Craig Barton
31st May 2016

TES Maths Resource of the Week

Every fourth Resource of the Week highlights a top quality premium resource published by a teacher on TES.

Resource title: Test maker £10

Resource author: RUN DMC

What is it?

This resource lets you create assessment material quickly and easily, covering a range of topics from number to data handling. Using Excel’s random number generator, you can not only generate an infinite number of questions, but also very easily customise the test so that you get the exact questions you want, in the order you want them.

The answers are provided too, which makes marking much quicker. 

How can it be used?

With the added bonus that the questions print neatly into worksheets, I have been using it to generate weekly homework questions for my Year 7 class.

As a classroom tool, it is ideal for quickly building questions based on what we have done in the lesson, which can be projected onto the whiteboard. As the answers are included, students are able to mark their own work, making it perfect for last-minute Year 11 revision classes, where one resource can help you cover a whole range of topics.


Craig Barton

Craig is a secondary maths teacher in the North of England.


A word from the author, RUN DMC

I am currently head of mathematics in an international school in Spain and this is something we use in our department for Years 7, 8 and 9, and sometimes for GCSE core level revision.

Originally I created the question bank with 'static' questions but 3 or 4 years ago I thought I would test my Excel skills. I wanted to see if I could make all of the questions contain a random element which would allow them to be recalculated, ensuring our assessments will not always have the same answers. With some questions this was quick and easy, with others it was more complicated.

The macros and functions were added in afterwards, with the aim of making the resource more user friendly. All of my resources tend to get modified from time to time and I am always looking for feedback to try and make them better. 


Did you know you can keep up with the latest blog posts in our dedicated maths area?

Contact us

Visit our forums

Latest education news

New to TES Resources ? Find out more about becoming an author on TES, or dive straight in and start downloading.