Google
 

Wednesday, September 3, 2014

Turn a Set of Spreadsheet Cells Into Easy to Read Documents

Save As Doc is a free Google Spreadsheets Add-on that enables you to select a series of adjacent cells and turn them into an easy to read Google Document. The Save As Doc Add-on takes just a minute to install. Once installed select the Add-on from your "Add-on's" drop-down menu and click "start." After clicking "start" you can choose a set of cells or all cells to be converted into a Google Document. The document will appear in your Google Drive dashboard (it might take a minute or two to appear if you have selected a large set of cells) where you can then view it, edit it, or download it as a PDF.

Applications for Education
I love to use Google Forms to create and deliver quizzes to students. The problem with that has always been that when I start to add-in short answer or essay questions, the spreadsheet of responses becomes unwieldy and difficult to read. Save As Doc can solve that problem for me by allowing me to select the cells containing my students' short answer responses to turn into a document that I can easily print, read, and grade.

I will be covering topics like this one and many others in my new class Getting Ready for GAFE starting in October. Graduate credit is now available for this class!