Automagically create a spiral review

Create a 5 a Day with Spiral Questions

Spirling is an important technique to make learning sticky. Keep a list of questions or problems in a spreadsheet, randomly choose 5 questions, push to Google Slides and have ready for the morning warm up. I coded the ability to do this automagically.


Look for the Spiral Questions menu next to the Help menu.
Setup Spiral Questions

It may take a few seconds for the menu to load. Once it loads choose “Setup.”

Note that you will need to authorize the script. Click on the link that says “Advanced” and then underneath that click on “Spiral Questions (unsafe).” It is safe, I coded it myself. Google has not reviewed my code so they are not vouching for me.

Google Slides Created

A Google Slides presentation is automatically created when choose Setup. The link to the Slides presentation is in cell A1. Click on this to open. Notice it is blank.
Google Slides Created

Add Your Questions

Once you have setup the spreadsheet you can add your questions to column A. 5 questions are automagically added to the Google Slides, you will want to have at least 5 questions. You do not need to do anything. The 5 questions will be randomly chosen on an interval. Your blank slides will populate with your questions.
Add questions to column A

Bookmark the Spreadsheet

Since the idea is to automatically create a spiral review list of questions you will want to regularly add to the list. Suggestion to bookmark the spreadsheet to allow you to easily come back and add new questions.

Add More Questions

Spiral review involves revisiting topics/questions. You will want to keep adding new questions to the spreadsheet as you teach new content. This allows you to easily come back to those questions by presenting the Google Slides.

Link to the Google Slides Presentation

Notice the link to the Google Slides presentation in cell A1. Click on this link to bring up your warm up slides.
Questions added to Google Slides

Every Hour Refresh

To keep the spiral review fresh, it will automatically display a new 5 questions every hour. This allows you to use the exact same Google Slides over and over to share 5 questions with students. Without effort, you are ready to give a new 5 questions.

Manually Refresh

If you would like to manually push new questions to the Google Slides, use the menu and choose “New Spiral.” Note that this does not refresh the timer. It will still choose 5 new slides every hour automatically. If it changes when you did not want it to, use the version history to restore the Slides back to the previous questions.

New Spiral

Presentation Mode or Published Mode

When presenting the questions, the presented slides do not change. Pressing escape to leave presentation mode may reveal 5 new questions if it has been an hour. If you use the same presentation all day in presentation mode it will display the same questions.

Using the File menu to “Publish to the web” will allow you to embed the slides on a website. When students or parents visit the website they will see a new spiral review every hour UNLESS they do not refresh the website. Just like presentation mode of Google Slides, published mode slides do not change until refreshed. Notice the embedded Google Slides above. Leave this website up and come back in an hour. The same 5 slides will be displayed. If you refresh the page though, you will see a different 5 questions.

Push new spiral review questions

In this animation, I am using the Spiral Questions menu to manually push 5 random questions to the Google Slides. Remember though, this will automagically happen every hour.

Digiprove sealCopyright secured by Digiprove © 2018

Subscribe to the Alice Keeler Newsletter


WP Twitter Auto Publish Powered By :
%d bloggers like this: