FTT - 2 Add Ons to Make Google Sheets Easier to Read

Image from New Visions Cloud Lab

They Completed Your Google Form. Now, How Do You Read Their Answers?

@joe_edtech/@LisaBerghoff

This year, your students will sit for HOURS completing the PSAT, SAT and ACT assessments. One of the reasons the State and Federal Governments have adopted such tests is that they are incredibly easy to grade - objective tests with a lot of selecting the right answers. All you have to do is run the answer sheet through a simple computer program and you have mountains of "achievement data" to turn into color-coded graphs.

In the real world, and in the classroom, answers are not always objective. And most teachers want their students writing critically and creatively. Ask any Google Apps for Education teacher and they'll tell you that forms are the most efficient way to incorporate assessment for learning into the classroom. But, have you ever tried to read a free response answer or an essay on a Google Spreadsheet? If you have, you just winced. If you haven't - DON'T DO IT!

Save as Doc Add On

The Google Add On Store offers two great solutions for taking the written information in Google Form Response Spreadsheets and turning it into something useful. The first, and easiest tool is called "Save as Doc." This Add -On takes a column from a spreadsheet and saves the data in a very readable Google Doc. (See below for a demonstration of the "Save as Doc" Add On.) "Save as Doc" is probably best used if you want to generate a discussion with a group or quickly glance through answers to check for understanding. At a recent workshop, I had teachers fill out a form on which they wrote down some ideas they have about student grades. Rather than opening the results spreadsheet, I used "Save as Doc" and displayed the anonymous answers to the group to generate a full discussion.

The other Add On worth discussing is a little more complicated, but is perhaps my favorite Google Tool, and will prove worth your time to learn and utilize. autoCrat, by New Visions Cloud Lab, is a tool for merging data from a spreadsheet into a Doc or into another spreadsheet. Imagine giving your students an online quiz using Google Forms and having a Google Doc generated for each student with their answers displayed in an easy to grade, easy to comment, and easy to share way. You can also use autoCrat to create certificates or mail merge letters. Written directions for autoCrat can be found on the New Visions Cloud Lab page, or you can watch the video, created by Brent Coley, embedded below for step-by-step instructions:

--------------------------------------------------------------------------------------------------------------------------

One of the benefits of being a part of the Google Apps for Education Community is that all GAFE Teachers and Trainers create "how to" materials for using Google products. While the first video is mine, the second video is posted by a fellow Google Education Trainer. If you find another good video tutorial for a Google Add On, please share it with us in the comment box below.