Wednesday, January 21, 2015

Save As Doc: Create easy-to-read pages from Google Spreadsheets responses

If you've ever administered a test using a Google Form, you may have been frustrated by the results when students complete extended response essays. Student responses are recorded in a spreadsheet. Each answer is placed in a cell. The extended response cells are very difficult to read because the sentences are squeezed into a very small area.  Save As Doc to the rescue!  Save As Doc is a Chrome extension that converts the spreadsheet into an easy-to-read document.  Those extended response essays can now be read clearly online with the click of a button.

Here's how to use Save As Doc:

1.  Sign into Chrome.
2.  Open the results spreadsheet for the online test.
3.  Pull down the Add-ons menu.
4.  Select Get add-ons.


5.  Search for Save As Doc.
6.  Click on the Save As Doc add-on and install it.  Authorize and accept all permissions.
7.  Select the Add-ons menu again.  Select Save As Doc.  Select Start.



8  Select all the cells in your spreadsheet (including the Row 1 header) that you wish to grade.  [I recommend selecting all of the completed cells in the spreadsheet, even the non-extended response answers.  This will ensure that you include the students' names and class periods.]


9.  Type a name for your document in the Save Doc file as section.
10.  Check the boxes for First row of selection contains headings and Add a pagebreak after each row.
11.  Press the blue Save as Doc button.
12.  Once it finishes working its magic, click the link to Open the Doc.  (This document has been saved in your Drive.)
13.  Voila!  You can now scroll through the results and easily read your students' extended responses.  :-)