Let Flubaroo Do Your Grading!
Google forms can be used to create quizzes that you can administer online to your students. And with a neat (free) tool called Flubaroo, these quizzes can be graded automatically! This process will work for questions formatted as multiple choice, select from a list, short text responses (like a vocabulary or spelling test, for example), or math short answer questions.
Let's get started!
Create a form containing your quiz questions. Here are two videos that will pick you up in the process at this point and walk you through the remainder. Once your form is set, you will actually take your own quiz to create the answer key! Your students may take your quiz. Go to your response sheet and install Flubaroo. Let Flubaroo do its work!
- Here's a brief introductory video about Flubaroo: http://www.flubaroo.com/instructional-videos
- And just for your information, here's a link to an overview of the process. I'll walk you through each step below, however.
Let's get started!
- First step is to understand how to use Google forms to create your quiz questions.
- Watch the videos on this page for details on creating a form.
- As you think about your quiz, know that Flubaroo won't be able to grade all types of questions, like extended text responses. These kinds of questions CAN be a part of your quiz, however, because you can tell Flubaroo to skip them in its grading process.
- Make sure your response destination sheet is created as described in the process. (When you see the View Responses button, you're good to go!)
- *** IMPORTANT: Remember to always ask for the student's name as the first question (or some other identifying question) in order to differentiate responses. Flubaroo won't be able to distinguish among responses without this.
- Flubaroo: Part 1 - Setting up your quiz questions and creating your answer sheet (7:40)
- Flubaroo: Part 2 - Installing and using Flubaroo (6:34)
- Click View live form button on your toolbar.
- Answer all questions correctly and submit your answers noting the following:
- For the question that asks you fill in your name, some recommend putting your name as Answer Key. This helps later on to identify the responses that Flubaroo will match the student answers against.
- For text questions that may have two or more correct answers, enter in your key the answers with %or between them (e.g., blue %or bleu); see example
- For mathematical questions where a range of answers is acceptable, enter your range using %to (e.g., 3.5 %to 3.6)
- See details in the forms videos (see #7 specifically) for directions on how to determine the link to use for student access.
- Navigate back to your form (not the live version, but the form in edit mode.)
- Click the View responses button
- With your spreadsheet in front of you, go to Add-ons > Get Add-ons
- In the Script window that appears, enter the name Flubaroo in the search field and click the Search button.
- Click the Install button beside the Flubaroo description.
- Click Close to return back to your response spreadsheet.
- Note that you must enable Flubaroo for each new sheet.
- In your response sheet, Add-ons > Flubaroo > Grade Assignment
- For each question, use the pull-down menu beside each question to assign a point value (1-5, can weight questions differently), identify a question as one that identifies the student (name, for example - be sure to label this as an "Identifying Question"), or tell Flubaroo to skip grading a question (short answer or rubric question, for example.)
- Next, identify which submission is your answer key. This is where it can be helpful to use the name "Answer Key" for quick identification of the proper response file.
- Click View grades.
- Note that a new Grades tab has been created at the bottom of your spreadsheet.
- You will see assigned point values for correct questions and 0 for any missed question.
- Student names who score less than 70% are in a red font.
- Questions where fewer than 60% get correct are highlighted in orange.
- You can still see your original student responses in the Student Responses tab.
- Use Flubaroo > View Report for a visual representation of the results.
- You can accept more student responses then select Flubaroo > Regrade Assignment and select OK when prompted that this will replace your existing grades.