Google Sheets & Google Forms for Libraries

Helena Marvin

Google Sheets & Google Forms for Libraries

University of Missouri-St. Louis

Research output: Contribution to conference › Presentation

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).

Original language	American English
State	Published - Mar 1 2017
Event	St. Louis Regional Library Network Tech Expo - Logan University Purser Center Duration: Mar 1 2017 → …

Conference

Conference	St. Louis Regional Library Network Tech Expo
Period	3/1/17 → …

Keywords

array formulas
google forms
google sheets
pivot tables
selection
statistics

Disciplines

Library and Information Science

Cite this

@conference{cfb3c7c06447452aa8c49aa76656e43f,

title = "Google Sheets & Google Forms for Libraries",

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 = "array formulas, google forms, google sheets, pivot tables, selection, statistics",

author = "Helena Marvin",

note = "Google Sheets & Google Forms for Libraries By Helena Marvin [email protected] University of Missouri-St. Louis Reference / Institutional Repository Librarian Session 3A March 1st, 2017; St. Louis Regional Library Network Tech Expo ; Conference date: 01-03-2017",

year = "2017",

month = mar,

day = "1",

language = "American English",

}

TY - CONF

T1 - Google Sheets & Google Forms for Libraries

AU - Marvin, Helena

N1 - Google Sheets & Google Forms for Libraries By Helena Marvin [email protected] University of Missouri-St. Louis Reference / Institutional Repository Librarian Session 3A March 1st, 2017

PY - 2017/3/1

Y1 - 2017/3/1

N2 - 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).

AB - 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).

KW - array formulas

KW - google forms

KW - google sheets

KW - pivot tables

KW - selection

KW - statistics

UR - https://docs.google.com/presentation/d/1h5JHLchzry05sLEuvHZOtfSnyhfXQGFbaFqelf7Uxvk/edit?usp=sharing

M3 - Presentation

T2 - St. Louis Regional Library Network Tech Expo

Y2 - 1 March 2017

ER -

Google Sheets & Google Forms for Libraries

Abstract

Conference

Keywords

Disciplines

Other files and links

Cite this