Google Form-ing an Awesome Test

Originally published at by David Noller on February 24, 2016.

It’s so much easier now! What is? Taking your existing tests and turning them into Google Forms. Got an old Word doc that you traditionally print for your students for test day? I bet you think transferring the test to a Google Doc would be more time consuming than would make it worth it.

Easier Creation of Forms from Word

The bad news: you cannot simply upload a Word Doc and have it magically become a Google Form. That would be pretty magical, though. 
 The good news: it is much easier to create a Google Form if you have a multiple choice document now than it has ever been before. If you can copy and paste, you’re in luck. But it’s easier than even that sounds, because you can paste ALL OF THE OPTIONAL RESPONSES to a multiple choice question at once. Select all of the responses, paste them into the “Option 1” editing box, and Google Forms creates a new option for each alternative. The following animation is in real time.

While this will take some time for you to copy and paste from your traditional test into Google Forms, you may find that the payoff is worth it. Using Flubaroo, you can grade and return tests to students with the push of a couple (virtual) buttons. You can more easily see trends within a class and between classes regarding learning. You can use the power of spreadsheet calculations to do all that fancy math stuff that you can imagine doing with objective data. 
 If you find that your 200-Question Final Exam would take too much effort to convert using this method, try it with your exit tickets, or with your 10 question quiz. Practice on smaller evaluative pieces to get the hang of it. Use a mouse instead of a touchpad or trackpad if that’s getting in your way. Eventually try creating your quizzes in Google Forms so no conversion is necessary. 
 Several other new features have rolled out for Google Forms that make the tool even more powerful and even more teacher-friendly than it was before.

View Individual Responses in Live Form

The Responses section now includes the capacity to view individual responses in the live form, rather than just in the spreadsheet, which can allow the teacher to see each response in context, not only in terms of that question, but among all other responses on the page. For teachers less comfortable using spreadsheets, it also provides an element of familiarity and comfort to be able to view responses in the natural view.

In the Summary view, student responses are represented by line graphs and pie charts, and now also include percentages to represent the responses collected. This can be important information for analyzing trends, or to check for whole class understanding, even before looking at student grades. With the question context and all options visible, it’s easier to determine if the question was simply difficult or if it was misleading in some way, or if the students were perhaps under-prepared.

In the Individual view, you can more easily check for a student’s understanding within the context of the other questions being asked. Did she get one incorrect because she also got the one before it incorrect and the second builds on the first? Maybe that would help you with how you plan to re-teach or adjust your communication to students.

Templates to get you started

You get a template! And you get a template! And you get a template! You all get a template! 
 As GAFE users, we have access to a collection of pre-made forms that are editable for use in our own classrooms. The example I used in my earlier demo was the “Exit Ticket” template. To open the menu of Templates, go to or press the back arrow in the upper-left corner while viewing an existing Google Form.

When viewing the templates, you’ll see many that are available for you. Open the template, make your changes, assign to your students through Google Classroom, collect and analyze data with automatically generated pie charts and line graphs. What more could you ask for? If none of those templates meet your needs, you can also click on “More” to access templates for settings other than education, such as “Work,” “Personal” and more. .

Magically Submitted by: David Noller