Flubaroo
A Google Sheets add-on that helps with grading.
What is flubaroo?
More than just a grading tool, 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.
- Lets you send individualized feedback to each student.
Flubaroo: a Youtube video introduction.
Step 1:
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.
Click the "+" and create a new form.
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.
Step 2:
Open up the form as a student would, 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.
To get to the live form, you can click the "View Live Form" button in the form editor, or choose "Form > Go to live form" from within the destination spreadsheet.
Step 3:
Step 4:
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.
Step 5:
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 orange to alert you. Additionally, students who scored less than 70% on the assignment will be highlighted in red.
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.
Now you try to make your own!
Eric N. Rodrigueze M.S.Ed.
Email: eric.rodriguez@hayscisd.net
Website: http://digitalhays.wix.com/home
Phone: 512-268-2141
Twitter: @erod129