As a follow up to my post on not posting PDF’s of worksheets for students to annotate, here are directions for providing students feedback via a Google Form.
Create a Google Form
Instead of asking students to annotate a PDF, type the short answer questions into a Google Form. This should be quicker for students to fill out than annotating a PDF. The turn in process for students is much easier as well. When the student is done answering the questions they simply click on submit.
What is wonderful about Google Forms is they connect to Google Sheets. Each students response is organized into a single document. This eliminates having to open and mark 30-200 different documents. The teacher only needs to view the spreadsheet for all student responses.
There are several tricks to quickly assess student work. If you have a multiple choice question you can use conditional formatting to highlight the right answer for each column. Click on the column indicator to highlight the column of the question. Choose “Conditional formatting…” from the Format menu.
Click Here for my other formative assessment tricks.
For short answer questions use “Text contains” for your conditional responses. Type in the keyword you are hoping students used in their response. This will highlight the questions that might be correct.
Summary of Responses
Flubaroo is an add-on that will grade multiple choice questions for you. Go to the Add-On menu and choose “get add-ons.” Find the Flubaroo add-on and enable it. Running Flubaroo from the Add-On menu will give you the option to grade your worksheet. Skip grading any free response questions, Flubaroo does not grade these well. Flubaroo allows you to choose “Edit student feedback” from the Flubaroo menu. This creates a column to give students specific and individualized feedback. Return to the Flubaroo menu to email the students their grades.
For each short answer question right click on the column indicator to insert a column. Choose “Insert 1 right.” This is grading bliss since I simply need to press enter to start giving the next student feedback. Write a note to each student based on their response. You can also insert a column for their overall grade or overall feedback.
For short response the answer is probably clipped, meaning you can not see the full student response. Click on the column indicator to highlight the entire column. Choose the word wrapping icon in the toolbar. Choose the middle icon to wrap the text.
Go to Add-On’s and install the “Yet Another Mail Merger” Add-On.
Using the Add-On menu run the “Yet Another Mail Merger” to send an email with the students feedback.
If students do not have email, merging the answers to a Google Doc and sharing it in the students Google Drive would be a good alternative. Autocrat is also an Add-On that can be added to the spreadsheet. Create a Google Doc with the merge tags instead of an email. Run the Autocrat Add-On to merge the students information with the Google Doc template you created. If you collected student Google Apps usernames (email address) the merged Google Doc will be shared with student. Note that a document is created per student so that students can not see the responses of other students.