One Way to Force Students to Save a Copy of Google Spreadsheet

I just came across this method of forcing a student to save a copy of a spreadsheet to their Google Drive. I tried it out today, and it works nicely and is very easy to do.  Here are some quick instructions, but visit Tammy Worcester’s site for a detailed explanation. Thanks to Tammy and follow her @TammyWorcester on Twitter. 

  1. Create a spreadsheet.
  2. Share the spreadsheet with “anyone with the link.”
  3. Go to http://goo.gl and paste in the URL of the shared document.
  4. Add &newcopy at the end of the URL.

When you give the shortened URL to your students and they visit the page they see a message asking them, “Make a new copy of this document?”

The photo below makes Step 3 and Step 4 a bit clearer. Notice the &newcopy.

spreadsheet force copy

This is what the student sees:

make a copy

Advertisements
This entry was posted in Web 2.0. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s