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