Thing 5 – Google Forms… and Flubaroo?

Google forms is an easy way to give online quizzes, polls, or feedback forms to your students, colleagues, or parents. In my class I do “Warm Ups” (Some might call it bell work, bell ringers, etc.) each day to either awaken prior knowledge on new material we are learning or to retrieve the previous day’s learning. At the end of each week I post to this site a simple google form that the students complete based on the warm ups. This way I don’t have to check, collect, or grade any papers! Instead, I have the google form. It collects the data, it can grade the quizzes, AND can email the students their results so they get immediate feedback too!

Here’s an example of one of my Warm Up Quizzes: Warm Up Quiz 9/27

Screen Shot 2013-10-11 at 1.53.31 PM

Fig. 1 – My Google Drive

Now, here’s how you do it:

1. Log into your google drive and find the red button that says “create”. Click it an a drop down menu appears, choose “form”.

2. Give your form a title and start writing in questions. You can choose from different styles of questions like multiple choice, list, checkboxes, or just written text (although those become harder to grade in the next sections). I usually make the first question just “First Name” and leave as a short text question. At Cathedral, our forms can automatically collect our students’ email/log in. in order to send them their results you will need this info so make sure you check the box at the top marked, “Automatically collect respondent’s Cathedral High School username” (or you could make a question that asked respondents for their email address).

3. To add new questions you can either:

  • Duplicate the previous question my pressing the button to the right of your first question that looks like one paper lying over another.
  • Create a new question by pressing the button at the bottom of the page that says “Add Item”
form1

Fig 2 – Google Form Tool Bar

4. This is important, if you plan on using this as a Quiz DO NOT MARK ANY CORRECT ANSWERS ON YOUR FORM. All that marking them does is place the mark on that answer so that when the student looks at it they see the correct answer marked for them.

5. When you’re finished, you can view your completed quiz by clicking “View live form” near the top of the page. But more importantly you want to be sure that the button to its left says “Accepting Responses”. This means your form can be viewed and filled out. If this is meant to be an actual quiz that you do not want students able to see at all times, simply click that button and it will change to “Not accepting responses”. (You can easily switch it back by pressing it again)

Screen Shot 2013-10-11 at 2.34.26 PM

Fig. 3 – Send form options

6. When you are ready to share your quiz and make it like click the large blue button that says “Send form”. You can send the form (make it viewable) three different ways:

  1. Copy and paste the URL into your own blog or website
  2. Email your students (or whomever) using the window on the screen
  3. (What I use) You can choose to get the “Embed code” so that you can embed the quiz directly into your website.

Flubaroo

Screen Shot 2013-10-11 at 2.12.39 PM

Fig. 4 – Google Spreadsheet

Now  here’s where it gets fun. The other button in that bar says “View Responses” clicking this will take you to a new Google Spreadsheet that WILL AUTOMATICALLY COLLECT YOUR RESPONSES! (I know, right!?).

As you can see in this picture, Google automatically makes your questions the header on each column and places the students answers in them.

Grading

To have google automatically grade your assignment, click the tab titled “Tools”.

When the dropdown menu appears, the first item listed is “Script gallery”. Click that!

Screen Shot 2013-10-11 at 2.15.33 PM

Fig. 5 – The Script Gallery

A box will appear with a list of scripts that google can run for you to analyze your data. The script you want is called FLUBAROO, so type that into the search bar. When it pulls up the result. Click “Install”.

It’s going to ask to be able to view some of your Google information, do not freak out! Its okay, it just needs permission to read the google spreadsheet so that it can grade it.

Once you have installed Flubaroo, there will be a new tab at the top titled “Flubaroo” (See Fig. 3 for proof). Click the tab and choose “Grade Assignment”. Now before you can grade your assignment, you will have had to have taken your own quiz to make a key. You will then use your response as your Key and compare your students answers to it.

Grade your assignment and Flubaroo will create a new ‘page’ to your spread sheet with data on student results.

Screen Shot 2013-10-11 at 2.26.17 PM

Fig. 6 – The results of a recent assessment

Finally, to send your students their results, click the “Flubaroo” tab again and choose “Email grades”. You’ll have to identify which column of the responses is the email addresses before it can work its magic.

Finally, you can see a report on how your students did by clicking “View Report” in the Flubaroo tab. The report is simply a histogram of the grades, but it’s still pretty helpful.

Other Uses

Recently, I had my students create their own google quizzes, post them and then take other students quizzes. It was a fun way to 1. get them to review and 2. teach them a valuable skill.

Scroll to the bottom of this post and you can see their quizzes: Agenda 9/25

Now, there are more advanced techniques and tricks available if you’re interested. Please contact me if you would like more information. Otherwise, please complete my newest google form below!

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s