GCSE and IGCSE History Revision

Random Quiz Generator

Mini Quiz 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

Application.Calculate

ActiveSheet.PrintOut

Next i

End Sub

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

Viking raid on Lindisfarne

The Norse raid on Lindisfarne in 793: the beginning of the ‘Viking’ age in Britain?

Norse raiders attacked the holy island of Lindisfarne off the Northumbrian coast in an event that is generally accepted as the start of the ‘Viking’ period of British history.

How did Æthelstan become the first Anglo-Saxon ‘king of all Britain’?

July 12th 927 is the closest we have to a foundation date for England, when all the kings of Britain met at Eamont Bridge, near Penrith in Cumbria, to swear an oath of peace under the overlordship of Æthelstan. Having previously been king of the Anglo-Saxons, Æthelstan’s key success in 927 was conquering Viking York which placed the kingdom of Northumbria under his control and secured the submission of the northern kings.

Why did Æthelred the Unready order the St Brice’s Day Massacre in 1002?

On the 13th November 1002, the St Brice’s Day Massacre took place when king Æthelred the Unready “ordered slain all the Danish men who were in England”. Although it is believed that there was considerable loss of life, actual numbers of Danes who were killed following the order are unknown. However, recent archaeological excavations including two mass graves have begun to shed some light on the mystery.

Death of Edward the Confessor

Why did the death of Edward the Confessor spark a succession crisis?

A succession crisis was sparked following the death of Edward the Confessor, the last Anglo-Saxon king of England.

Coronation of Harold II, the last Anglo-Saxon king of England

On the 6th January 1066, Harold Godwinson was crowned king of England. Harold II was the last Anglo-Saxon king of England, but reigned for barely nine months before being killed at the Battle of Hastings on the 14th October by Norman invaders led by William of Normandy.

Harald Hardrada and the Battle of Fulford: the start of the end of Anglo-Saxon England?

On the 20th September 1066, Harald Hardrada – the Viking king – defeated his northern English enemies at the Battle of Fulford. The defeat of Harold Godwinson’s northern earls was disastrous for the new English king who was forced to rush north and defeat Hardrada himself, which in turn contributed to Godwinson’s later defeat at Hastings to William of Normandy.

The Norman Conquest – video extract from History File

From the BBC’s History File series on Medieval Realms.

A brief audio overview of the Battle of Hastings

On the 14th October 1066, the Battle of Hastings was fought between Duke William II of Normandy and the Anglo-Saxon king Harold Godwinson. Harold’s defeat triggered the Norman conquest of England and the beginning of a new age in England’s rich monarchical history.

Chaos in Westminster as William of Normandy crowned king of England

On the 25th December 1066, William of Normandy was crowned King of England at Westminster Abbey. The event ended in chaos as Norman guards outside mistook the sounds of the cheering crowd inside for the start of a riot.

Privacy Preference Center


  • Warning: reset() expects parameter 1 to be array, string given in /home/mrallsop/public_html/revision/wp-content/plugins/gdpr/public/partials/privacy-preferences-modal.php on line 32

Warning: Invalid argument supplied for foreach() in /home/mrallsop/public_html/revision/wp-content/plugins/gdpr/public/partials/privacy-preferences-modal.php on line 74

Close your account?

Your account will be closed and all data will be permanently deleted and cannot be recovered. Are you sure?