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.
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
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.
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
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.
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.
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.
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.