Great advice from Jamie Nutter!!!
Use the following “trick” to easily share the spreadsheets, Docs, and Slides
Overview of Trick:
- Create a Google Doc, Sheets, or Slides document.
- Share the document.
- Get the “shareable” link (URL).
- Within the link, change the word “edit” to “copy”.
- When you share the “new” URL, it “forces” students to make a copy!
Google Spreadsheet Trick
Google forms are fabulous for gathering information, but sometimes, the data in the spreadsheet can be difficult to view. In this post, I’ll share a simple-to-implement formula that will make it much easier to deal with (and even print) form-fed data!
The Original Data:
When you collect data into a Google spreadsheet from a form, it will look something like this:
If you have a large amount of questions (and especially if some of them are essay questions), it requires a lot of side-to-side scrolling to view the data.
Transpose Formula to the Rescue!
By using the “Transpose” formula, you can easily make the data look like this:
Notice that the information is now vertical instead of horizontal, making it much easier to view individual responses.
How to do it:
Transpose FormulaChanges data from rows to columns
- Create a new sheet.
- Enter the following formula in cell A1 of Sheet2:
Note: Adjust A:H to the desired range of columns. If you don’t want the timestamp to show, enter B:H.
- Press the enter key and watch the data fill the sheet!