Flubawho? Flubaroo!

I love when I find AWESOME tools while surfing the web.  Have you heard of Flubaroo?  Well let me tell you how to get a little Flub in your Roo!  Flubaroo is a free tool that helps you quickly grade multiple-choice or fill-in-blank assignments.

Flubaroo also:

  • Computes average assignment score.
  • Computes average score per question, and flags low-scoring questions.
  • Shows you a grade distribution graph.
  • Gives you the option to email each student their grade, and an answer key.

But the best part is that it works inside of Google Docs with Google Forms. Check this out:

Step 1: Create an Assignment

Sign into your Google docs account, and create a new “Form”. Forms are multiple-choice style surveys that you can share with anyone (e.g. via email). Every time someone fills out the form, their responses are placed as a new row in an accompanying spreadsheet.

Once you’ve created a new form, just add in the questions for your assignment. It will look like the photo below.  Be sure to include a couple questions that will allow you to identify the student (such as first name, last name, and student id). If you want to email each student their grade, be sure to also include a field for their email address.

Once done entering questions, save and close the form.

Once saved, your form will have a new, empty spreadsheet associated with it. For more on using forms, read Tips on Using Forms.

Step 2: Create an Answer Key

Open up the form, fill it out with the correct answers and submit it. Be sure to enter your name too, so you can identify this entry later on as the answer key. Not sure how to find or open the form you just created? Click here for help.

Step 3: Assign It!

Email the form to your class using the “Email this form” button at the top. Alternately, just email out a link to the form, or put the link on your class website. Click here for instructions on how to get a link to the form.
All student submissions will automatically be entered into a spreadsheet, which will look something like this:

Step 4: Grade It!

Open the spreadsheet associated with the form.  From the “Insert” menu, click “Script” (see photo below, on left).  You’ll be presented with a “Script Gallery” (see photo below, on right), from which you can install a multitude of useful “scripts”.

To install Flubaroo, type “Flubaroo” in the box at the top, and click the Search button. Alternately, you can click on “Education” in the left pane, and then scroll down to find “Flubaroo”. Once you’ve found it, click the “Install” button.




After installation, you’ll see a new menu in the spreadsheet called “Flubaroo” (it may take a few seconds to appear). Once you’re ready to grade, just select “Grade Assignment” in this menu.

Flubaroo will ask you a few questions, such as:

    • If any questions should not be graded.
    • Which questions are for the purpose of student identification (e.g. name, student id, email).

Which submission should be used as the answer key.

Once answered, Flubaroo will grade your assignment. This process should take less than a minute.

Note: While Flubaroo will work in any web browser, it doesn’t look too nice in Firefox. This is a known issue, being worked on.

Step 5: Review the Grades

The grades created by Flubaroo will be located in an adjacent worksheet called “Grades”, as shown:

For each submission, Flubaroo will show which questions were answered correctly (“1″ point”), which incorrectly (“0” points), and which were not graded. If less than 60% of students got a question correct, the question will be highlighted in orangeto alert you:

The Flubaroo menu will now offer you the ability to email each student their grades, view a summary report, or regrade the assignment. You might want to regrade the assignment if more students submitted answers, or if you want to throw out a question that most students got wrong.

If you choose to email each student their grade, you’ll be given the option to include an answer key in the email. You can also include a short message to your students. The email sent to each student will include their total score, and their score for each question (with incorrect answers highlighted in red). Note: You will only be able to email students their grades if the original assignment had a question asking them for their email address.

Choosing “View Report” shows you a summary report of the grading. The report includes the distribution of grades (a histogram), and a button to email yourself a copy of the report.

AND REMEMBER IT IS FREE!   Go and install it now, I just did 😉

Flubarooly Yours,

The Cre8tiv Mind

Retrieved directly from: Flubaroo Overview – Welcome to Flubaroo

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s