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.
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.
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
Notice the link to the Google Slides presentation in cell A1. Click on this link to bring up your warm up 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.
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.
This Content is Generated from RSS Feeds, if your content is featured and you would like to be removed, please Contact Us With your website address and name of site you wish to be removed from.
You can control what content is distributed in your RSS Feed by using your Website Editor.