Tech 4 Teach 2018 has ended
Back To Schedule
Friday, February 16 • 2:35pm - 3:00pm
#9 - Using “Publish to the Web” to Share Individual Tabs in Google Sheets

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Technology: Sheets within Google Apps is a powerful and useful program that is commonly used. However, sometimes it is ideal to have multiple ‘tabs’ within a Google Sheet file. For example, when compiling records for multiple students within a single file each student might have their own tab. Unfortunately, the typical Google Share function does not allow for the sharing of a single tab, and makes it impossible to share information with individual students without giving them access to other students’ information. Likewise, creating individual files for each student with individual sharing settings can be cumbersome and time consuming.
Evidence: A simple solution to this is the “Publish to the Web” function which can be used to create a unique web-page for each tab within the Sheet File. The link to this page can be restricted to App State Users and can be set to continually update as the Sheet is updated. The link can then be shared with the individual student to provide them with accurate, up-to-date information, without violating the privacy of other students.
Broader Impacts: This function can be useful for activities such as student advising, when it may be convenient to keep all students in a cohort in a single sheet with separate tabs for each student, but necessary to provide students with individual access to their own plans of study. The created links can then be distributed to students using Add-On Mail Merge Applications.

avatar for Jennifer Howard

Jennifer Howard

Assistant Professor, Appalachian State University
Health & Exercise Science, Athletic Training

Friday February 16, 2018 2:35pm - 3:00pm PST
E-Poster Session 2 Plemmons Student Union

Attendees (2)