When using a Google Spreadsheet, it is likely you will want to share your spreadsheet either for viewers or collaborators.

By default the spreadsheet is private, looking at the blue share button in the upper right hand corner you will notice a pad lock.

Clicking on this blue share button you will be able to change the viewing options to anyone with the link can view or public on the web.  Sharing a spreadsheet URL with someone who does not have viewing permissions will result in them seeing an error screen.

With students typically I want them to have viewing but not editing rights so that they can not change the information so I will set the viewing rights to anyone with the link can view.

On this screen is the URL that you can use to post to your website for students to click on to access the spreadsheet.  You may want to use a URL shortener such as http://goo.gl to create a short URL and/or QR code to help students locate the spreadsheet if they are not first visiting your classroom website.

Sharing the link from the share button will take the student to the first tab.  You can move the tabs around so that “Form Responses” or “Sheet 1” is not the first tab.  Whatever tab you drag to the first position will be seen first by using the URL from the share button.

However, you may want to direct the students to a tab other than the first tab.

Go to the desired tab.  Notice the URL at the top changes based on the tab you are on.  By default the first sheet ends in #gid=0.  Subsequent tabs end in #gid=1, #gid=2, etc…  Copying the URL from the desired tab and sharing that URL will direct the user to that particular tab, even if you move the location of the tab.  Dragging the tabs around does not rename the #gid number.  Thus, if you move “Form Responses” from being the first tab to being the 5th tab, it will still have the #gid=0 in the URL.

Thus if you share the URL ending in #gid=8 your students will be directed to the 9th tab created.  (Remember counting starts at zero)

Subscribe to the Alice Keeler Newsletter



WP Twitter Auto Publish Powered By : XYZScripts.com
%d bloggers like this: