Flubaroo is For You!

via Technology Tidbits by Twyla Felty

 Flubaroo is For You!

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!

Step 1: Create a Google Form with your test questions
If you have created forms before, the only critical thing to remember here is to check the top, two boxes in the settings if you are sending within your school domain. This will allow you to email responses to students using their username.
Also, checking “only allow one response…” will limit students to taking the quiz just one time

If using outside of your school domain, you absolutely must collect names and emails as the first questions in your Google Form!
Step 2: Customize the look of your Google Form
Make it cute by selecting “Change Theme” on the top of the form. Select one of the themes on the right, or click “customize” to see even more options. There are so many ways to personalize your forms. Just get in there and play!
Step 3: Take your own test! 
This is an important step since this will be the KEY to your quiz. To easily do this, just select “View Live Form” at the top of the form you just created. Once you finish taking your quiz, go back to the tab with the form you were editing.

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.

Step 5: View Responses in Google Sheets and add Flubaroo!
We now select “View Responses” from the top of the form. Every Google form magically creates a corresponding spreadsheet to collect information. You may need to select “create new spreadsheet” the first time you view responses. Now you should see all of your student responses. 
Here’s where the Flubaroo part comes in:
  1. In the spreadsheet with student responses, click “Add-Ons” 
  2. Select “Get add-ons”
  3. Search for Flubaroo–it usually is the first one there–and click the +Add
  4. You must agree to the access it requires–it will include email since it sends from your email

Step 6: Select your new Flubaroo Add-on and Grade!
  1. Click “Add-Ons” again
  2. Select Flubaroo (it may ask to enable Flubaroo on that spreadsheet)
  3. Select “Grade assignment” in the drop down menu
  4. There will be two pop-up windows to set-up the grading:
Step 1:Determine which information is a question or student information 
  • 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”

Step 2: Pick the Key–it should be your own name/user account –(the test you took first)
Hint: if you forgot to take your own quiz. exit the grading and take it! Then go back to grade again. Your name will be at the bottom of that list.
  1. Now Grade! (click “continue”)
  2. Once grading is complete, “X” out of the pop-up window to view the grades.
  3. The spreadsheet will have two “tabs”: the one with everyone’s answers, and the one with the grades.
Step 7: Email results to your students
  1. Go back to “add-ons” on your sheet with the grades
  2. choose Flubaroo
  3. Choose “Email Grades”
  4. From the pop-up window, select the cells which contain the email for your students–in our district, this is “username”
  5. Check the items you wish to include: scores, questions and answer, personal message      
  6. Hint: if your quiz is a review, including the correct answers creates a study sheet for students 
  7. Click “continue”and grades are emailed!
Now do you need more visuals to walk through this process? Try the “Flubaroo is For You” Tech Trick and a Treat training doc!

Visit the Flubaroo Help Center for additional information such as using numerical ranges and auto-grading!
Enjoy your tech trick!

Leave a Reply