Google Forms – Responses, Flubaroo, and Classroom (Part 2)
You checked out the first Google Forms Post and you created a Google Form to give to your students. That’s awesome! Now what…
Once the assessment is designed to your liking, click the “Responses” tab at the top of the Google Form. This will give you a myriad of options to collect student information. First, create a Google Spreadsheet by clicking the “sheets” button at the top.
This will give you the option to “Create A New Sheet” or attach it as a tab into an existing spreadsheet. If you are giving this as an assessment, then at this point you are ready to share it with your students!
Tip: Technically you don’t have to create the spreadsheet before giving the test, but that is just how I normally do it.
As students begin taking the assessment, their responses will appear on the Google Form Response page (but only after submitting the assessment).
What’s great is that it gives you the overview of each question! For Example, 37% of participants chose the wrong answer. Questions to consider: Bad wording of question? Insufficient teaching of the material? Etc. You can also click on “Individual” and see the participants assessment and which answer they specifically selected. This is less intuitive than the “Summary” tab, but still helpful none-the-less if you want to see how a specific student answered.
One of the great things about using Google Forms, especially for Formative Assessments, is the ability to use Flubaroo to auto-grade the participants answers. Realize though that Flubaroo is not a Google Forms add-on but a Google Sheets add-on. To access Flubaroo, go to the corresponding sheet (click on the sheet button at the top of the “Responses” tab). Once on the spreadsheet, do the following: click “add-on,” select “Get add-ons,” search “Flubaroo,” click “+ Free” to add it to your sheet.
Tip: After you “Get Flubaroo,” it will always be an option for your spreadsheets, even if you don’t create the spreadsheet through Google Forms.
Now that Flubaroo is added to your spreadsheet, you have a lot of different options. To set up the grading, you must take the assessment personally so that Flubaroo can use it as a template for grading all the student assessments. When doing “Auto-grading”, Flubaroo then gives you various options for each question type including: “Identifies Students,” “Skip Grading,” “Normal Grading,” and “Grade By Hand.”
Tip: For the name, use “Answer Key” to remind yourself when you go to create the template for Flubaroo.
Identifies Students – Used for non-grading purposes, specifically sending the results to participants after completing the assessment.
Skip Grading – As stated, will skip grading the question and won’t be given as a option for sending results to students. This is great for getting their perspective, or testing questions without any consequence to students.
Normal Grading – Will give you the option to provide various point levels for these questions. This would be for the multiple choice/matching style questions that it matches to your answer key.
Grade By Hand – A great way to do short answer questions. However, for most essay style questions, I use Google Docs and the Add-On Doctopus to grade. I will do a blog post about that later on in the year.
Personally, I love the auto-grade option, so that students can get feedback immediately on where they stand with the content. Due to the immediate response, I do not do any short answer questions (besides Identifying Student Type) so that students can know how they did.
When assigning the assessment to students, use Google Classroom! Create an assignment on Classroom, and add the Google Form Assessment from Drive. What’s great is that it will keep track for you of what students have taken/not taken the assessment. The only frustration is that the grades are not carried over to Google Classroom (but should Google Classroom really be for grades or should it just be used for feedback? Something to think about.).
Any other thoughts or suggestions would be greatly appreciated!