Skip to main content
Presentation
Google Sheets & Google Forms for Libraries
St. Louis Regional Library Network Tech Expo (2017)
  • Helena Marvin, University of Missouri-Saint Louis
Abstract
During this session, learn about two Google Forms / Sheet projects that were recently implemented for use at the UMSL library. The first is being used in an ongoing manner to gather statistics about the UMSL public service desk. The second is a one-time use Sheet and Form to aid the reference librarians in reviewing over 300 databases for potential deselection (this Form has nearly 800 votes complied, and using the magic of pivot tables, the comments, prices, and titles are easily compared). 
Keywords
  • google forms,
  • google sheets,
  • pivot tables,
  • statistics,
  • selection,
  • array formulas
Publication Date
March 1, 2017
Location
Logan University Purser Center
Citation Information
Helena Marvin. "Google Sheets & Google Forms for Libraries" St. Louis Regional Library Network Tech Expo (2017)
Available at: http://works.bepress.com/LenaMarvin/5/