Mrs Humanities

Because I'm married to the job.

Resource – GCSE Revision G.Y.M

9 Comments

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.

Author: MrsHumanities

Teacher. Blogger. Friend.

9 thoughts on “Resource – GCSE Revision G.Y.M

  1. Like. Happy New Year to you.

    Liked by 1 person

  2. Utterly useful! Thanks for making it and for sharing!

    Liked by 1 person

  3. Thank you so much. Great resource

    Like

  4. Thank you very much – really helpful, and easy instructions to follow! Thanks.

    Liked by 1 person

  5. Hi
    I cant seem to see the button below to download the template for this? Thank tou!

    Like

  6. Pingback: Resource – IB Geog your Memory Revision Resource | Mrs Humanities

Leave a Reply to MrsHumanities Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.