The Save As Doc Add-On is for Google Sheets. Use it on the responses sheet of a Form to display your responses as a document rather than cells on a spreadsheet. This Add-On has been saving lives for a while now, but with more and more people using Google Forms, it helps to spread the word. Grading responses inside of little cells is a job for Flubaroo, but when autograding isn't necessary, or when answers are largely open-ended, Save As Doc is the winner. Tuen those cells into paragraphs in a nice, easy to read and understand document.
Cells with unwrapped text can be too small for responses:
Cells with wrapped text can be too large:
So, go up to Add-Ons. If you don't see Save as Doc, go to Get add-ons:
Search for Save as Doc and click on the blue "Free" button:
Agree and Accept all of the terms and services.
Now you can go back to Add-ons, choose Save as Doc, then Start:
A Sidebar will pop-up on the right, you can quickly choose your settings:
 |
| 1) Title your Doc, 2) Check to Include Headings, 3) Add a pagebreak after each row if you want each student (or row of responses) to show up on their own page, 4) VERY IMPORTANT - Select all data, 5) Click Save as Doc and wait a few seconds, or more, depending on the size of the spreadsheet, 6) Open the Doc will appear after the Doc generates |
View your responses in an easy to read AND understand document:
Comments
Post a Comment