NOTE: This page is out of date – please see here
A lot of people on Twitter have recently been talking about the importance of mini-quizzes and how they are carried out. I’ve been working on a little program to help me out with this and you’re more than welcome to use it.
What it is
A simple Excel program that uses a list of questions and answers to generate a random 10 question quiz. You can set it to ask 5 questions from any point in the course and 5 questions from the current topic (this is what I do).
How I use it
For each topic I write flashcards on Quizlet in question and answer form. The cards are lean and focussed to only have the material necessary and nothing extraneous (occasionally I include practice questions for improving procedural technique). I print off a PDF with all the questions and answers and give it to students at the beginning of a unit. I tell them that all my verbal questions will be based on them and they are expected to begin learning them off by heart and referring to them in their verbal and written answers.
Every three lessons, the class receives a mini quiz generated by the Roulette. I display the questions on the board, give them ten minutes to answer in the back of their books and then peer assess. Students collate their score /5 for the first five questions a score /5 for the second five. Each student receives a small piece of paper which they fold in half. On the outside they write their name, and on the inside they write the two numbers /5. I take these in and record them.
Sometimes (trying to do this more) I will ask students to raise their hands if they got Q1 right, then Q2 etc. I’ll pick a Q that many of them got wrong and then do some boardwork trying to clear up any misunderstanding.
Strengths:
- Retrieval practice
- Interleaved/spaced practice
- Easy to use
- No macros (so doesn’t crash for no reason)
- Can gather quite a bit of data on the students re their performance
- High success rate is possible: all the questions and answers are available to them
- In time I will make it available to parents who can support their children revise effectively
- Investment: can be used for many years to come (hopefully)
Weaknesses:
- No diagram questions
- No multiple choice questions
- Relies (to an extent) on effective peer-assessment
The link below has the Roulette set up for where I am up to with my current year 10’s. I will periodically update it here with new questions if people let me know that they are interested.
Retrieval roulette GCSE chem no repeats
Feel free to use it or not – let me know if you have any thoughts! I’d especially like to hear from people who are looking at something like this for a non-science subject.
UPDATE 18/5/18
Have updated the RR with a no-repeats version that a couple of different people sent to me via twitter. I am no longer 100% sure how it works but hey. We also now use a tracker sheet which goes in the front of students’ books and is transferred when they get a new one. It goes by number of questions wrong as teachers will be doing quizzes with differing numbers of questions.
Mr Allsop History has a great version of the generator here which turns it into games like battleships.
UPDATE 26/10/17
You will note that this should be difficult for procedures/calculation questions. I have written a flashcard set for quantitative chemistry where I have done the questions with algebraic letters (x, y etc.) which means that when I use them in class I just make up the numbers and the students need to solve.
UPDATE 26/05/17
Following discussions with people on Twitter and my own experimentation in class I’ve added tabs with an option for an 8 and 6 question quiz. I’ve found that a 10 question one can take 25/30 minutes which can eat away at your lesson time. It’s a very difficult balance in terms of how to spend your lesson time but this at least will give you the option.
*I don’t think Excel can give random values that don’t repeat without a macro, which I don’t want to use for ease.
NB Matthew Benyohai pointed out a couple of errors in the questions which is super embarrassing. Oh well – will sort out tomorrow. NB have now edited the questions and re-uploaded with a load more of them
May 5, 2017 at 6:59 am
Hi Adam,
I am interested in your idea and would appreciate updated questions.
Thanks for sharing.
B
LikeLike
May 6, 2017 at 6:01 pm
Great how you’ve developed such a tool! Could you please share it with me as well?
Thank you!
LikeLike
May 14, 2017 at 7:37 pm
This seems to work in Quiz!E7. Don’t ask me to explain it…
=query(sort(index(Questions!A:A,C7,1):index(Questions!A:A,D7,1),arrayFormula(randbetween(sign(row(index(Questions!A:A,C7,1):index(Questions!A:A,D7,1))),1000000)), true),”select * limit 5″ )
LikeLike
May 14, 2017 at 7:41 pm
Ha that is one funky formula. Will give it a go thanks!
LikeLike
May 24, 2017 at 5:41 pm
OMG!!!! You have literally just changed my life! This is the best thing I’ve downloaded in years! We’ve been creating quiz questions to start every lesson this year but it’s a manual activity of choosing questions. This is such a game changer. Thank you SO much for sharing, your impact will be felt here in Surrey!
LikeLike
May 24, 2017 at 5:42 pm
Happy to help! Please let me know how you get on!
LikeLike
May 24, 2017 at 5:45 pm
There’s also one on the Learning Scientists website that you might find helpful. Much fancier than my garden shed job
LikeLiked by 1 person
May 24, 2017 at 6:11 pm
Shall do! I love a good Excel spreadsheet so love the simplicity of this! I couldn’t work out what the chart was for though? Thanks for the learning scientists suggestion too, I’ll have a look 🙂
LikeLike
May 24, 2017 at 6:17 pm
Sorry which chart?
LikeLike
May 24, 2017 at 6:30 pm
Errr….ignore me….I think I pressed the wrong button and somehow got a chart tab added in. Just downloaded again, it was not from yours!
If you’re interested, I’ve adapted slightly. I’ve reduced interleaved/ random questions down to 3 each and added in a “teacher choice” question where the teacher can add in 3x question numbers of their choosing if these were identified in a prior lesson as needing a review. Can of course send back to you anything I do but used =IF(E8=””,””,VLOOKUP(E8,Questions!A:E,2,FALSE))
Thanks again!
LikeLike
May 24, 2017 at 6:31 pm
That’s a great idea. Whatever works!
LikeLike
May 24, 2017 at 6:17 pm
Sorry which chart?
LikeLike
June 17, 2017 at 7:14 pm
This is fantastic! I teach MFL and need a list of randomised Qs for students to answer in the target language. However it’d easily work for just single words of vocab too. Can’t wait to share with my colleagues. Thank you so much for the work you’ve put into this.
LikeLiked by 1 person
June 17, 2017 at 9:58 pm
No worries! Please let me know how you get on with it…I’d love it if you could send me an MFL version at some point!
LikeLiked by 1 person
February 27, 2018 at 3:05 pm
Do you have an updated version of the retrieval roulette document? Also thank you for writing a thoughtful and interesting blog.
LikeLiked by 1 person
February 27, 2018 at 4:36 pm
I do! I you email me at aboxer@jcoss.barnet.sch.uk to remind me I’ll put it up
LikeLiked by 1 person
April 14, 2018 at 7:25 am
I enjoy, cause I found exactly what I used to be having a look for. You’ve ended my four day lengthy hunt! God Bless you man. Have a great day. Bye
LikeLike
May 30, 2018 at 5:43 pm
This is really useful – we are going to trial this starting in September with all GCSE classes. Thank you! Any further updates would be much appreciated!
LikeLike
May 31, 2018 at 7:11 am
Great to hear – happy to help. If you put a Bio or Phys one together would love to see it!
LikeLike
August 16, 2018 at 2:55 pm
This has been so helpful for Chemistry that I’ve made a Physics version which I’m more than happy to share with anyone who wants it.
LikeLike
August 16, 2018 at 1:56 pm
Yes please! Can you email it to me?
aboxer@jcoss.barnet.sch.uk
LikeLike
September 18, 2018 at 10:27 pm
Ooh – could I have a copy of the physics one too please! would you mind emailing me on steph.coimbra@hotmail.co.uk
Thanks so much
LikeLike
November 1, 2018 at 9:34 pm
I’m a bit late seeing this – would it be possible for you to email me the physics version? If there’s anything I can send you in return, I will try my best to do so.
d3lyth@yahoo.co.uk
LikeLike
November 1, 2018 at 9:37 pm
Thank you so much in advance – was a bit eager pressing the ‘Post Comment’ section!!!
Thanks again!
LikeLike
November 1, 2018 at 9:38 pm
Hi Delyth – check this out https://achemicalorthodoxy.wordpress.com/2018/08/18/retrieval-roulettes/
LikeLike
November 4, 2018 at 2:06 pm
This is amazing! You have just saved me hours of work! Thank you so much. I work in a Welsh medium school, so plan on translating this – once I’ve translated, I could send you a link for other WJEC users if it would be useful? Thanks again!
LikeLike
November 4, 2018 at 2:07 pm
Please do!
LikeLike
January 5, 2019 at 8:31 am
been looking for a Physics retrieval roulette – if you wouldn’t mind emailing it would save me a mountain of time. az_2@yahoo.com
LikeLike
January 5, 2019 at 5:09 pm
Hi there can’t link now as on phone but if you go to the resources section at top of the blog you will find physics ones!
LikeLike
September 5, 2018 at 11:35 am
I’ve got something similar that runs in Google Sheets. It warns you that it’s not verified by Google at the moment but it’s safe to continue.. https://chrome.google.com/webstore/detail/knowledge-machine/eofjmbhnigegpbconellanfokplaljaj?hl=en-GB
You maintain your question list in the spreadsheet and it will squirt your desired number of questions on the topic(s) of your choice into a Google Slides presentation. (Can then be downloaded and stuck in a Powerpoint or printed, depending what floats your boat.)
LikeLike
September 5, 2018 at 12:41 pm
That’s cool! Thanks 🙂
LikeLike
December 5, 2018 at 11:08 pm
This looks fantastic. I have been using mini quizzes as a starter for a long time but I can see that once questions are set up in the programme this will be a fantastic time saver. The interleaving part is great as well. I work in Scotland so I plan to adapt some of your A-Level organic questions for the Higher Chemistry course. Wish I had time to adapt your roulettes for all my year groups. Think however I will start small and adapt some of your KS3 topics for my S2 classes. They do love a retrieval quiz and my explanations for why they are so important!
LikeLiked by 1 person
December 19, 2018 at 2:56 pm
How do you set these up to work on the classroom once downloaded
LikeLike
December 19, 2018 at 2:57 pm
Just open the Excel sheet and play with the tabs at the bottom- should be able to work out!
LikeLike
June 18, 2019 at 11:55 am
Hi Adam do you have a blank template or have I missed it? Sorry if I have. I’m in Ireland and looking to do ones for LC Physics, Chemistry and the new junior cycle. Happy to share as I get them done. Thanks Cathal
LikeLike
June 18, 2019 at 12:08 pm
Hia – this page is out of date! Check here https://achemicalorthodoxy.wordpress.com/2018/08/18/retrieval-roulettes/ and to get a blank template just delete all the questions!
LikeLike
July 28, 2019 at 5:14 am
I teach the Māori language to beginners, and this is looking seriously useful. Very appreciative of your template, with the nifty explanations for the boxes. Ngā mihi! And enjoy your summer holiday.
LikeLiked by 1 person
July 29, 2019 at 7:02 am
This might be the best comment I have ever received!! Would you be interested in sharing the Maori version?
LikeLiked by 1 person
July 29, 2019 at 11:06 am
Why, thank you! I teach adult learners, and I introduced it in class tonight. Most of the class wanted a copy, to do retrieval practice themselves. It’s a mix of vocab items and sentences to translate. It’s very much a work in progress, but I’ll share a copy once I’ve got more in it. I was delighted to realize how easy it is to use. I’m promoting it where I work, in a Māori education setting, so it could take off with other Māori language teachers. Enjoy your summer!
LikeLiked by 1 person
July 29, 2019 at 11:11 am
Awesome! Looking forward to seeing it 🙂
LikeLike
January 26, 2021 at 6:09 pm
Hi Adam, I’m an NQT and I would like to start to explore the use of the retrieval questions as a starter or homework.
Can you please forward me the link or file, please?
Regards,
Julio Ferreira
LikeLike
January 26, 2021 at 6:39 pm
Hi Julio – the link is at the top of this page!
LikeLike