Language of experiments pt II


Random prefix and suffix generator

Prefixes and suffixes

Prefixes and suffixes


258 prefixes and suffixes of words. A variety of Greek, Latin and all sorts of others. Can be used at start of lesson or as a kind of ‘word of the day’ or to shove in your lesson when someone asks about literacy. You know the deal.

Instructions for use:

  1. Download and save the two attached files, an Excel and a PowerPoint.
  2. Save to somewhere, making sure that the Excel is saved as ‘Prefixes and suffixes’ and not as ‘Copy of Prefixes…’ or the PowerPoint won’t know where to look.
  3. Open both files.
  4. On the Excel first tab, press F9 to refresh the random number. A random prefix or suffix will appear on the PowerPoint.
  5. I think I’ve caught any mistakes, but there may be one or two lurking. For example, ‘neur’ was spelt ‘meur’.
  6. Look up what ‘genu’ means as a prefix. Who knew?

Question generator for spaced recall (Biology but can be adapted)

4 question generator

6 question generator recent

6 Question generator recent

How to use:

  1. Open all three documents, the two PowerPoints and the Excel.
  2. Save the documents somewhere, making sure that the Excel is saved as “6 Question generator recent” and not as “Copy of 6…”, otherwise the PowerPoint files will not know where to look for questions.
  3. On the spreadsheet, the first tab is simply a list of questions, 6 from every page of the AQA textbook. They are numbered down the side and according to the unit and double spread number. This can be changed of course of you want.
  4. ¬†Choose a starting question number e.g. between 1 and 594. On the next tab (it says ‘4’ on the bottom) put the question number of your choice in the box at the top (it’s actually cell B1).
  5. The rows across the top will then select another 3 questions for you, using formulae that you can adjust to taste. The formulae can be changed if you like, they are all in G1,H1 and I1. The numbers in G2,H2 and I2 simply represent your question and the three that came before it, if you just want to put up recent questions.
  6. The PowerPoints should update with your questions on the first slide and answers on the second. You might want to rename the PowerPoint files, but that’s up to you.

Continue reading “Question generator for spaced recall (Biology but can be adapted)”