Thursday, November 12, 2015

Sharing a Doc to Automatically Copy and Spreadsheet Formulas

Great advice from Jamie Nutter!!!

Use the following “trick” to easily share the spreadsheets, Docs, and Slides
Overview of Trick:
  1. Create a Google Doc, Sheets, or Slides document.
  2. Share the document.
  3. Get the “shareable” link (URL).
  4. Within the link, change the word “edit” to “copy”.
  5. 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
  1. Create a new sheet.
  2. Enter the following formula in cell A1 of Sheet2:
    =Transpose(Sheet1!A:H)
    Note: Adjust A:H to the desired range of columns. If you don’t want the timestamp to show, enter B:H.
  3. Press the enter key and watch the data fill the sheet!
Jamie Nutter
Hoover City Schools
Technology Integration Coach
@3littlenutters
205-439-1083

No comments:

Post a Comment