This is a project I’ve been meaning to do for a while now to support revision and recall inspired by Jen Monk’s ‘Geog your memory’ resource.

The idea is that through the use of a mail merge you create a variety of ‘geog your memory’ resources which can be used at the end or throughout the course.

It’s nothing fancy but super easy to do.

First create your template in word.

Next create your spreadsheet and collate your questions in whatever order suits you and your needs. I’ve done it mixed to support revision with my year 11 class. I’ve used the sample paper questions and created some of my own to test student knowledge and recall.

Next is the mail merge. These are super easy once you get the hang of it.

Here’s a step by step guide.

Step 1 – Data Source

Open up your template in word. Go to the ‘Mailings’ tab and click on the ‘Start Mail Merge’ icon. Select ‘Normal Word Document’. Then go to ‘Select Recipients’ as shown below. Select the option ‘Use an Existing List’. This will open up a the ‘Select data source’ window. Just find your excel spreadsheet in your files and select OK.

Step 2 – Inserting your data

Next you want to add the data to your mail merge. Place your cursor where you want to insert information. You can see I’ve clicked in the first definition box. Once your cursor is placed, click on the ‘Insert Merge Field’. Then from the dropdown list select the data option you want to insert.

Insert the fields into the remainder of your document.

Step 3 – Finish and Merge

Once your data fields are inserted into the template document you’ll want to merge the data into the file. Click on the ‘Finish & Merge’ icon. From the drop down menu select ‘Edit Individual Documents’.

When the pop-up opens, select ‘All’ and press OK.

This will open up a new document with all of your data inserted into several versions of the original template.

And there you have it, a whole selection of ‘Geog your memory’ sheets for students.

If you don’t want to make your own, guess what I made some for you to download and amend. Download the Word Template, the Excel Spreadsheet of questions for AQA Geography and the document with 30+ GYM sheets ready-to-go by clicking the button below.

Hope you find the resources and tutorial useful.