Flubaroo for dummies

How to automatically grade forms using “Flubaroo” (as Add-on in Sheets)
*UPDATED with auto-grading option*


(Click here for the official Flubaroo User’s Guide.)
(Click here to see this tutorial in a Google document)

Click here to take a short quiz and experience the awesomeness of Flubaroo’s NEW Auto-grading option. After you click "Submit" check your email after a couple of minutes (you might need to refresh it).

If you haven’t experienced automatic grading with Flubaroo yet, you’re in for a treat. Just imagine marking a class set of tests with the press of a button! And then sending the results to your students within seconds, showing their grade with correct answers and wrong answers OR (NEW), setting it up so that students get their mark within minutes of completing the assignment. Yes, it can be done with Google forms, Google Sheets, and Flubaroo. And while it takes some time to set up, it will save you hours of marking in the long run.

How would I use this as a language teacher? I use multiple choice types of questions for reading comprehension. Here is a form I created to go with the AIM Reader: Prince Veut-Tout and here is one for the AIM play "Boucles Violettes et les trois ours." I also use them for listening comprehension evaluations for the plays we study in the AIM methodology. Click here for a form for Vrai/Faux questions and here for A/B questions. Click here (V/F) and here (A/B) for the voice recordings that go with these forms. Marking these evaluations on paper first of all, is wasteful, and secondly, deadly-dull. (Caution: don’t make your tests too long because students need to finish their form within class time to submit. You cannot save a form part-way. If you have a long test, best to divide into two parts.)

NOTE: if your students have devices with a QR code scanning app like I-nigma, the easiest way for them to access the form you created is for you to make a QR code of the form for them to scan. You can use a QR code creator like the Chrome extension ShortenMe. If your students are on laptops, you can use the ShortenMe Chrome extension to give them a shortened Google link (you can write the shortened link on the blackboard).

Part 1: Creating the form:

  1. In the new Google Drive, click on “New > More > Google Forms”.

Screen Shot 2014-09-21 at 8.01.14 PM.png

2. You should now see this:
Screen Shot 2014-09-21 at 8.03.26 PM.png
  1. Give your form a name. Call it  “Sample form for Flubaroo”.

4. Now you need to change the first question from the default Multiple Choice, to the “Text” option. Click on “Multiple Choice”:
Screen Shot 2014-05-16 at 9.55.18 AM.png
Then click on “Text”:
Screen Shot 2014-05-16 at 9.56.07 AM.png
5. Question Title: type “First name”: (NOTE: You could just have “Name” here, but I prefer separating first and last names because it’s easier to arrange the data alphabetically after)
Screen Shot 2014-05-16 at 9.58.51 AM.png
Help Text, keep blank. Check off “Required question, then “Done”.

6. You want the next three questions using the same “Text” Question type option. So, click on “Add item”. “Add item” will always add the same type of question you used last.
Screen Shot 2014-09-21 at 9.55.40 PM.png
7. The second question should be “Last name”. Follow instructions as above.
8. Continue like this with two more questions: “Class”, and “Email address”, for a total of 4 questions.
9. Now you can continue adding questions to your form for your quiz. They need to be “Multiple choice”, “Choose from a List” in order for Flubaroo to work. If you want to change the type of question, you need to click on the little arrow:
Screen Shot 2014-09-21 at 9.38.41 PM.png
Then click on the type of question you want (NOTE: Flubaroo works only with Multiple Choice and Choose from a list questions). NEW! Can do text answers too!
Screen Shot 2014-09-21 at 9.38.47 PM.png
NOTE 1: If you want to duplicate a question, click on the “Duplicate” icon:
Screen Shot 2014-05-16 at 8.25.14 AM.png
10. Make sure that all questions in the form have been checked off to “Required”. Click “Done”:
Screen Shot 2014-05-16 at 6.10.31 AM.png

11. When you are finished the form, take a look at the bottom:
Screen Shot 2014-05-16 at 10.52.29 AM.png
Decide what option you want your students to have. You do not need to click “Send form”. It will save automatically. “Send form” is only if you want to send it to someone, either to collaborate on, or to fill out. You would also click this button to get the imbed code.

Part 2: Using Flubaroo to grade forms:

1. If you have some experience with Google forms, you will already know that once responses to a form are submitted, an associated spreadsheet is automatically created. So once you have created the form, go to "View live form" and do the quiz twice: Once correctly, using your own name, and a second time answer some questions incorrectly. You can put any name on the second one, but use your email address so that you can see what the corrected quiz results look like in your email inbox. Click “Submit” at the bottom after each quiz. You need to do these steps before using Flubaroo.

2. Once you click “Submit”, notice that the tab above will say “Thanks!” Click on the X to close it.
Screen Shot 2014-10-10 at 5.55.43 PM.png
  1. Click on the tab “Sample form for Flubaroo”:
Screen Shot 2014-10-10 at 6.03.48 PM.png
  1. Click on “View responses”:
  1. Now you are on the spreadsheet that is linked to your form.

6. Now click on “Add-ons” on the top, then “Get Add-ons”. Search “Flubaroo”, then click on the “+Free” button:
Screen Shot 2014-05-15 at 11.37.53 PM.png
NOTE: You only have to do this once. From now on, it will always be in your sheets Add-ons.
7. Next window “This app would like to…”, scroll to the bottom and click “Accept”.
8. Just “X” out of the next window but don’t exit the spreadsheet.
Screen Shot 2014-05-16 at 6.41.20 AM.png

Screen Shot 2014-12-09 at 9.22.55 PM.png

NOTE: The icons for the form and spreadsheet look similar but are different:
Screen Shot 2014-10-10 at 6.17.18 PM.png

9. Make sure you are on the spreadsheet. You should see two rows of answers. (NOTE: If you don’t see them, make sure that you are on the tab at the bottom called “Form responses 1”.)
Screen Shot 2014-05-16 at 10.57.54 AM.png

Now, still in your spreadsheet, at the top, click on “Add-ons > Flubaroo > Grade assignment”:
Screen Shot 2014-05-15 at 10.55.20 PM.png
You should now see this window:
Screen Shot 2014-12-09 at 9.32.47 PM.png
Make sure that the first four questions are “Identifies student”.
13. Click “Continue”.
14. On the next window, check off your name (with the correct answers), then “Continue”:
Screen Shot 2014-05-15 at 11.05.07 PM.png

15. On the next window click on “View grades”, or just X out.
16. Voila!

NOTE: If you see this at any point:
Screen Shot 2014-05-16 at 3.09.08 PM.png
Just click on the Xs. At the bottom of your spreadsheet, click on “Grades”, and you will see the results (it might take a while to load, be patient):
Screen Shot 2014-05-16 at 3.02.27 PM.png

(If necessary, refresh your browser, then click on “Grades”.)

17. There are other things you can do now. Click again on “Add-ons”:
Screen Shot 2014-05-16 at 5.27.06 PM.png

You can Regrade Assignment if you have students who take the test later; you can email grades to the students, and you can view a report of the test. Try them out. Simply amazing!

  1. If you want to set up the quiz for autograding, click on “Add-ons > Flubaroo > Advanced > Enable Autograde

Screen Shot 2014-12-09 at 9.38.58 PM.png
  1. Next Window: “Okay”.
  2. Next Window: “Continue”
  3. Next Window: Click on correct answers, then “Continue”.
  4. Next Window, I would check off “Include Answer Key”, then add a message

Screen Shot 2014-12-09 at 9.45.45 PM.png
  1. Click “Continue”.
  2. You should see this notification:
Screen Shot 2014-12-09 at 9.47.17 PM.png
  1. Now trying doing the quiz again, as a student. Click on the form tab at the top:
Screen Shot 2014-12-09 at 9.49.16 PM.png
Then click on “View live form”. Fill out the form and intentionally make mistakes.
Screen Shot 2014-12-09 at 9.48.34 PM.png
  1. After you click “Submit”, you should receive an email with your quiz results in less than a minute.

Bonus: How to get class average of test results

  • Go to your test results spreadsheet (the “Grades” tab)
  • Click on the column with the grades to highlight it, then click on the Functions icon and click on “Average”:
Screen Shot 2014-11-18 at 9.51.07 PM.png

  • This should show up at the top of the marks column:
Screen Shot 2014-11-18 at 9.50.39 PM.png
  • Next to the letters “G”, type in the row number of your first mark, and the row number of your last mark:
Screen Shot 2014-11-18 at 9.52.28 PM.png
  • Click “Enter”
  • A class average should now appear:
Screen Shot 2014-11-18 at 9.53.49 PM.png

NOTE: If you use the form again for another class (or maybe a subsequent year), you may notice that you can't see any answers in the spreadsheet, this is what you do:

- Click on "Responses"
- Change response destination

- Click on "New spreadsheet", then "Create". You should see the answers now. Before you grade the new answers, delete the ones previously. You cannot delete anything from the marks spreadsheet one the test is graded. This will disable Flubaroo. 


  1. This is been more easy after following those guidelines to instruct everything with some due respect and hopefully this would indeed bring something good to our own interest.

  2. Taban puan derdi olmayan üniversiteler arasında yer alan Avrupa Üniversiteleri yaşam standartları bakımından da öğrencilere kolaylık sağlamaktadır. Ukrayna Üniversiteleri taban puanları olmadan üniversite kabulünü gerçekleştirip sizlerin akademik hayatınızda başarılı bir yolda ilerlemenize destek olmaktadırlar. Sadece lise diploması veya meslek yüksek okulu bitirdiğinize dair belge ile sizlerin kabulünüzü sağlayacak olan üniversite sizlere öğrencilik hayatınızda ekonomik olarak da kolaylıklar sağlamaktadır. Pek çok Avrupa ülkesinde üniversite okuma imkanına göre uygun bir bütçe ile yıllık giderlerinizi karşılayabilme olanağınız Ukrayna’da mevcut olacaktır.

    iç mimarlık puanları devlet üniversiteleri

  3. Wow, amazing blog layout! How lengthy have you been running
    a blog for? you make running a blog glance easy. The full glance of your website is great, as neatly as the content material! 온라인경마