via Technology Tidbits by Twyla Felty
Last week our “Tech Trick and a Treat” training covered the use of Flubaroo. Flubaroo is a free add-on in Google sheets that allows you to quickly grade quizzes and tests created in Google forms. So, we create in forms and grade in sheets!
Now don’t tune me out because you think this is just for the big kids! Flubaroo is a perfect tools for teachers throughout all grade levels. Since Google Forms can contain pictures followed by questions, even little ones can easily take a quiz in forms.
Today I am posting the basic steps we covered. If you are familiar with forms, sheets and add-ons in Google, then this quick list is all the information you will need. If you need this step-by-step guide with lots of pictures, then I have a document for that too: Tech Trick and a Treat: Flubaroo is For You!
Warning: if you are creating as your walk through these steps, Flubaroo will not grade a spreadsheet until it has two or more responses–the key (which is your response) plus another response. Find a friend to take your quiz!
If using outside of your school domain, you absolutely must collect names and emails as the first questions in your Google Form!
Step 4: Share your form with students so they can take your test!
Go to “Share” in top right corner of the form you created, and copy the link. Use the URL shortener in the pop-up window, and just paste this link where students can access. In Google Classroom, a Google form can be added as a link or directly from your Google drive.
Here’s where the Flubaroo part comes in:
- In the spreadsheet with student responses, click “Add-Ons”
- Select “Get add-ons”
- Search for Flubaroo–it usually is the first one there–and click the +Add
- You must agree to the access it requires–it will include email since it sends from your email
Click “Add-Ons” again
Select Flubaroo (it may ask to enable Flubaroo on that spreadsheet)
Select “Grade assignment” in the drop down menu
There will be two pop-up windows to set-up the grading:
- if it is username, name, period etc…choose “student information”
- If it is a question, set to “grade” and weight the question (1,2,….10)
- You can also “skip grading” for questions
- or use the new feature: grade by hand (For info: http://ift.tt/1D4q8jM )
- then “continue”
Now Grade! (click “continue”)
Once grading is complete, “X” out of the pop-up window to view the grades.
The spreadsheet will have two “tabs”: the one with everyone’s answers, and the one with the grades.
- Go back to “add-ons” on your sheet with the grades
- choose Flubaroo
- Choose “Email Grades”
- From the pop-up window, select the cells which contain the email for your students–in our district, this is “username”
- Check the items you wish to include: scores, questions and answer, personal message
- Hint: if your quiz is a review, including the correct answers creates a study sheet for students
- Click “continue”and grades are emailed!