Tech 4 Teach 2018 has ended

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

E-Poster [clear filter]
Friday, February 16

2:35pm PST

#9 - Using “Publish to the Web” to Share Individual Tabs in Google Sheets
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

3:50pm PST

#9 - WeVideo - Online video editor
Technology: WeVideo allows students to edit digital projects from the convenience of their personal computers or any computer with access to the web. The online editor makes it easy to learn editing and to share projects among group members.
Evidence: UDFS has purchased 50 WeVideo licenses (although a limited free version is available). We are testing the product this semester. So far the students seem to like the program. They like the intuitive nature of the program and the convenience of working at home. A great tool for classes that have media project assignments.
Broader Impacts: WeVideo is an editing software that is easy to learn and accessible for the campus community. A great alternative to Adobe Premiere Pro that is not readily available to students.


Beth Davison

Appalachian State University

Friday February 16, 2018 3:50pm - 4:25pm PST
E-Poster Session 3 Plemmons Student Union