Want More Help with This? Become a Premium Member
When using Google Forms for formative assessment you probably want to provide students feedback on their answers. Particularly if the question is a short answer question. If you add feedback to additional columns you run into the problem that for you the students answer is not next to the feedback you are giving them. This might require scrolling back and forth to read the students answer and then to enter the feedback several columns away. Google Forms are dynamic, when a student submit a Form a row is INSERTED. This means information added to the spreadsheet is shifted down. This can cause your Google Forms answers to be disconnected from the feedback, particularly if you sort the student responses.
[expand title=”Click Here to see example”]
In the image below you will see I typed something in row 20, which is below the Google Form entries.
After submitting an additional entry to the Google Form what I typed in row 20 is now shifted down to row 21.
Add Feedback Questions
One solution for this is to ask a question in the Google Form and then immediately create a question for the teachers feedback. Inserting a question inserts a column for the teachers feedback right next to the question that the student answered.
The problem with this solution is that it allows the student to enter their own feedback from the teacher. It is probably also confusing to the student to see a question prompting for teacher feedback.
Hide the Question
It is possible to hide questions in Google Forms so the student never sees it.
Create a Page
This places the teacher feedback question on it’s own page. Note that you can drag page breaks around. If you insert 2 page breaks below the teacher feedback question you can click on the page break and drag it up into position.
Skip a Page
By default each page continues to the next page. At the bottom of each page is a box to indicate which page the Form will go to next. Instead of “Continue to next page” instead skip a page and go to the next page that contains student questions. In my example “After page 1” I had it “Go to page 3.” Skipping page 2 which contains the teacher feedback question.
In the spreadsheet view of the Google Form responses the hidden questions should show as blank columns. This allows the teacher to insert feedback in response to the student answers. Using mail merge the teacher can return the feedback answers to the student.
Click Here to view a sample Form that skips the teacher feedback questions.
Click Here to view the spreadsheet that shows blank columns to allow for teacher feedback.