I saw this tweet about Jennifer Serravallo’s Reading Goals Self Reflection form from her book. My first thought is of course that this would be better as a Google Form. My biggest beef with PDF’s is they do not collect data. Switching to a Google Form allows the teacher to view all student responses in one place and to view charts about the responses to make faster and better decisions.
A3: A great self-reflection tool for finding reading goals from Jennifer Serravallo, author of The Reading Strategies Book. #HackLearning pic.twitter.com/DQusypiJld
— Debby Call ☀️ (@DebbyCall6) December 11, 2016
Google Form Template
To utilize the template you will need to make a copy of the Google Sheets spreadsheet template. This spreadsheet will be the spreadsheet that collects student responses but has some added features over the traditional spreadsheet created from Google Forms.
I coded some additional features. After submitting the Google Form students will receive an email with a link to go back to their responses later and update them. The teacher of course has a single list of all the student responses. A column has been added to count the number of “Yes/Always” responses.
There is an additional tab that provides the teacher with the students’ link to their responses if the student lost their email with the link to return to the Form.
Google Apps Script
The template does use Google Apps Script. You will need to use the Add-on menu and authorize the script.
The Add-on will generate a Google Form with the reflection questions and link to it in the spreadsheet.
How to Update Student Spreadsheets
You make a copy of a spreadsheet per student, but what if you have a typo or want to add to the spreadsheet? sheetPusher by Alice Keeler and Heather Lyon helps you update student spreadsheets. Here is…
Google Docs Google Play App Store Install
If you use Google Docs you want to be sure to have the mobile version as well. Use google play app store install
Navigate Google Forms Sections
If you use Google Forms you want to be using SECTIONS in Google Forms and controlling how students navigate the Form.. Navigate Google Forms Sections
BETTER – Print Google Form Quiz
Have more control over how your Google Form™ Quiz prints. Sometimes you need your Google Form on paper and this solution will help you to do it better! Print Google Form Quiz to a Google Doc and custo…
Something Fun for the End of the Year
What is something fun for students to do at the end of the year? While there are many choices, a fun word search can give students something to do while other students are finishing a task. Try my tem…
I cannot tell you how happy I am about this form! I tried to follow the directions and I am not getting the link to the form. Any ideas?
It should link in the spreadsheet but also the Form is in your Google Drive. Go to “Recent” in Google Drive and see if it’s there.
Alice,
I made a copy of the spreadsheet and used the add ons to add self-reflecting reading. It isn’t working. Any thoughts? I love this!
It doesn’t make a Google Form for you?
I have followed the instruction but the add-on wants access to my documents, emails, contacts etc. I do not want that to happen but there are no other options for using without allowing access. Seems rather odd?
It’s not odd. I used Google Apps Script and it can’t add a file to your Google Drive unless you give it permission to.
I’m struggling to gain access too. I’m getting a message that the app hasn’t been approved by Google?
It hasn’t. I coded it. You have to trust me. Click on Advanced and approve it.
I’m trying this add-on now, too. I did not get a link to the form and don’t see anything in my Recent folder. Was this fixed? It looks awesome!
Not sure what you’re missing, but you’re missing something. This does work.