
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.

Dec 28, 2018 at 7:43 pm
Like. Happy New Year to you.
LikeLiked by 1 person
Dec 30, 2018 at 2:51 pm
Utterly useful! Thanks for making it and for sharing!
LikeLiked by 1 person
Dec 31, 2018 at 4:31 pm
Thank you so much. Great resource
LikeLike
Jan 3, 2019 at 6:45 pm
Thank you very much – really helpful, and easy instructions to follow! Thanks.
LikeLiked by 1 person
Jan 3, 2019 at 7:44 pm
No problem. Glad to hear it’s of use. Best wishes.
LikeLike
Feb 6, 2019 at 12:55 pm
Hi
I cant seem to see the button below to download the template for this? Thank tou!
LikeLike
Feb 6, 2019 at 1:14 pm
Just click on the download here button. Takes you to a google drive.
LikeLike
Feb 6, 2019 at 1:28 pm
Hi-
Sorry am I being really blind but I cant see the usual download here arrow button on this page? I can see it on your other pages and resources but not this one? Thank you!
LikeLike
Pingback: Resource – IB Geog your Memory Revision Resource | Mrs Humanities