Help Yourself to 30 Minutes of GAFE Professional Development

30 Minutes of GAFE PD

I recorded a Google Hangout on Air for the North Carolina Google Educator Group. Here are the video and the slides. Additionally, there are direct links to when I cover specific topics in the video.

 

 

Google Classroom

Assignments and Content

Feedback

Miscellaneous

Advertisements

Make Paperless Assessment with Google Forms – Part 2 of 2: Grading with Flubaroo

In part 1 of this post, I showed you how to create a Google Form, import questions from a Google Doc or Word Doc and collect answers. Now it is time to grade your Google Form and give students quick, helpful feedback.

Start by going to the Google Form assessment you shared with your students:

Screenshot 2015-05-13 at 9.19.58 AM

Then return to the Google Form’s answers spreadsheet:

Screenshot 2015-05-13 at 9.21.48 AM

Now it is time to install the Flubaroo add-on for Google Sheets. This is what makes grading the Google Form so easy:

Screenshot 2015-05-13 at 9.23.20 AM

Screenshot 2015-05-13 at 9.25.03 AM

Screenshot 2015-05-13 at 9.26.20 AM

Now that it is installed, use it to grade the answers by taking these steps:

Screenshot 2015-05-13 at 9.27.36 AM

Screenshot 2015-05-13 at 9.29.07 AM

Screenshot 2015-05-13 at 9.29.59 AM

Screenshot 2015-05-13 at 9.32.24 AM

Flubaroo is very valuable to teachers. It highlights students who struggled and questions many students answered incorrectly. It has one other great feature: the ability to quickly give students detailed feedback. To e-mail students their results:

Screenshot 2015-05-13 at 9.33.10 AM

Screenshot 2015-05-13 at 9.37.39 AM

Some teachers might not be comfortable e-mailing the answer key. I prefer total transparency when assessing students. The nice thing about Flubaroo is that it gives you options for how much you share with students.

If you would like to know more about creating assessments in Google Forms, take a loot at part 1 of this post. If you would like to ask me any questions about making paperless assessment in Google Forms, comment below or send me a tweet at @edtechtom.

Make Paperless Assessment with Google Forms – Part 1 of 2

Are you teaching in a school that recently went 1:1 or is about to go 1:1? Do you hate stacks of paper burying your desk after you give students a test? Do you want students to take tests on their devices? Do you hate it when your school’s photocopier jams? Do you want to reduce cheating on assessments?

If you answered “yes” to any of the above, read on. This is a visual tutorial for making an assessment with Google Forms. By the end of this post, you should be able to create an assessment and add questions from assessments you have in Microsoft Word and Google Doc formats. In part 2, I show you how to automatically grade paperless assessments in Google Forms.

To get started creating a Google Form, go to the Google Drive folder where you want to store the form and:

Screenshot 2015-05-08 at 12.25.33 PM

Screenshot 2015-05-08 at 12.26.49 PM

Checking “Shuffle question order” means the questions will appear in a different order for each student taking the test. This makes cheating during the test very difficult.

Screenshot 2015-05-08 at 12.29.43 PM

Screenshot 2015-05-08 at 12.30.38 PM

My students use HP Chromebooks. The touchpads are sensitive. This causes students to accidentally submit forms before they have answered all questions. Making each question required prevents forms from being submitted until all questions have been answered.

Screenshot 2015-05-08 at 1.16.55 PM

Screenshot 2015-05-08 at 1.18.30 PM

Screenshot 2015-05-08 at 1.20.26 PM

Screenshot 2015-05-08 at 1.21.07 PM

Screenshot 2015-05-08 at 1.22.04 PM

Screenshot 2015-05-08 at 1.22.55 PM

Screenshot 2015-05-08 at 1.23.57 PM

Now that you have started entering questions into your form, here’s a suggestion: get rid of all numbers for the questions and letters for the answer choices. Those are relics of the Scantron era. In part 2, I will show you how to automatically grade your assessment. You won’t need numbers or letters. The absence of letters and numbers makes cheating harder. Additionally, to tell another student an answer, a cheater would have to state the question and the answer. Instead of saying “2 is b,” a cheating student is re-teaching content!

Once you have entered your questions, get your form ready for students’ eyes:

Screenshot 2015-05-08 at 1.33.23 PM

Screenshot 2015-05-08 at 1.34.14 PM

Screenshot 2015-05-08 at 1.35.05 PM

Screenshot 2015-05-08 at 1.38.00 PM

Your form will open in a new tab.

Screenshot 2015-05-08 at 1.39.03 PM

After students have taken the assessment:

Screenshot 2015-05-08 at 1.40.42 PM

The answers, on a Google Sheet, appear in a new tab:

Screenshot 2015-05-08 at 1.42.54 PM

This is where I will end this post. Now you should be able to create a form and view answers. In the second post, I demonstrate how to use Flubaroo to easily grade the assessment and give students fast feedback. If you have any questions about Google Forms for assessment, please comment below or send me a tweet at @tmullaney23.