Tag Archives: revision

Random Quiz Generator

Retrieval Roulette – Quiz and Game Generator

Last year Adam Boxer shared a simple but highly effective spreadsheet to randomly generate short quizzes (which include questions from the current topic being studied as well as questions from previous topics) from a list of pre-set questions. The link to his original ‘Retrieval Roulette’ post is here, and is well worth a read.

With his permission I’ve taken his original spreadsheet and added templates that create boards for games of Battleships, Blockbusters and Connect Four.

You can download a copy of the Quiz Creator here. The ‘Questions’ tab is currently filled with questions for the IGCSE course I teach (interwar politics, Cold War and a Germany 1918-1945 depth study) but you can replace them with your own questions in the order in which you cover them through the course.

To create quizzes:

  1. Add questions and answers to the list on the ‘Questions’ tab.
  2. Set up your question range:
    • Enter the question number you have covered up to in cell F1
    • Enter the first question number of your current topic in cell F2
    • Enter the last question number of your current topic in cell F3
  3. Click the tab name (e.g. Battleships 6×6) for the questions to be randomly populated into the template grid
  4. Press F9 on any tab to refresh with a new random set of questions. There are occasional repeats within the same grid – I’m currently trying to work out a way to stop this, but my students actually quite like it.
  5. When you go to print the template you will get two A4 sheets – one with the questions and one with the answers. The printed template will also feature a random Quiz ID so that you can match the questions and answers in case you produce numerous quizzes.


Using a macro to create and print multiple random quizzes

You can use a macro to automatically create and print a certain number of random quizzes. It only takes a couple of minutes to set up and allows you to produce unlimited random quizzes quickly and easily:

  1. Load the spreadsheet and go to the VBA editor (press alt-F11)
  2. Insert a new Module (menu Insert, select Module)
  3. Copy and paste the code below (substitute the text-like variable called number_of_desired_copies with the actual number of copies you want to produce):

Sub print_random()

For i = 1 To number_of_desired_copies



Next i

End Sub

Now just press the ‘play’ button to run the macro and hey presto 🙂

Question and answer icon

‘Question and Answer’ booklets for GCSE topics

These ‘question and answer’ booklets have been created to go alongside the revision podcasts on this website, but can be used on their own in a variety of ways:

  • Distribute them to students to act as a very rudimentary ‘knowledge organiser’
  • Students cover the answers for self-testing at home or in class
  • Teachers use them as the basis for low-stakes testing and factual recall quizzes

Booklets will gradually be added for each of the revision podcasts on MrAllsopHistory.com. Click the links below to download the booklets that are currently available.

International Relations 1919-1939

The Big Three at the Paris Peace Conference

The Treaty of Versailles

The League of Nations in the 1920s

The League of Nations in the 1930s

The Road to World War II, 1933-39

International Relations after 1945 revision

The origins of the Cold War

Weimar and Nazi Germany

Weimar Germany 1919-1929

The Rise of Hitler 1919-1929

The Rise of Hitler 1929-1934

Nazi Control of Germany 1933-1945

IGCSE and GCSE History source skills tips revision

Succeeding at Sourcework exam tips

This History revision podcast focuses on how to answer different types of source questions.  Many of the hints are good practice with for any sourcework paper, but if you would like specific advice for the CIE exams then check out my revision podcasts for IGCSE Paper 2 and IGCSE Paper 4.

This specific episode presents tips on a range source question types including:

  • Comprehension
  • Comprehension in Context
  • Reliability/Usefulness/Value
  • Source Comparisons
  • Interpretation


GCSE History source comprehension

I/GCSE History source paper revision – how to answer comprehension questions

These are often the early question on a paper, and usually have lower marks than some of the questions that require more detailed analysis. While there’s no ‘easy’ questions on a History exam, comprehension source questions are arguably the easiest that you’ll come across.

History revision comprehension in context

I/GCSE History source paper revision – comprehension in context questions

You’ve probably never called them this, but you will have seen them before. These are the types of questions that need you to understand what a source tells you about a person or situation and then link it to your own knowledge of the period.

Source reliability and usefulness revision

I/GCSE History source paper revision – reliability, usefulness and value

In these types of questions the examiner wants to see that you recognise that some sources have more value to historians than others, some are more reliable than others, and some are more useful than others.

It’s important to go into the exam knowing that sources can never be completely reliable or unreliable – but they can be more or less reliable. Every source has positive and negative aspects, and you need to consider these in your answer.


Source comparison revision

I/GCSE History source paper revision – how to compare sources

If you haven’t watched my other videos on source comprehension, comprehension in context, and usefulness, value and reliability I suggest you look at those first as the skills you use for those are very similar.

There are really two different types of question that may call for source comparison. The first are those that want you to compare the value of sources, and those that want you to compare their messages by identifying agreements and disagreements. Answering a question about the value of sources is dealt with in one of my other videos, so click here to take a look at it. To answer questions that call on you to compare source messages, watch this video for my advice.

Source interpretation questions

I/GCSE History source paper revision – answering ‘how far’ interpretations

A ‘how far’ source interpretation question is usually the last to appear on the exam, and invariably carries the most marks. Therefore you need to plan your time carefully to ensure you leave a good chunk at the end to answer this question in sufficient detail.