NASIG 2021 has ended
  • Zoom details will be shared with registered attendees via email before the conference.
  • On-demand (pre-recorded) sessions will be available to stream the week of the conference. 
  • With the exception of Thursday’s Equity and Inclusion panel, all sessions are being recorded, and access details will be shared with registered attendees following the conference.
  • All virtual conference activity is subject to the NASIG code of conduct
  • Join us for conversations on the NASIG Discord server at https://discord.gg/uSyNkmxt
  • Leave feedback on the conference survey (deadline: June 11).
  • Presentation slides are available on our repository, provided by FigShare.

Back To Schedule
Friday, May 21 • 7:00pm - 8:00pm
Loving Statistics and Excel Fuzzy Lookup in the time of COVID-19

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

In spring 2020, many academic libraries closed their buildings mid-semester due to the COVID-19 pandemic, making their physical collections abruptly unavailable. Even after reopening, much of the education at North American colleges and universities took place online, depopulating campuses. How did this situation affect the use of libraries’ electronic collections? What differences can we observe in how students and faculty discovered, accessed and used electronic resources in 2020 due to the pandemic? Which resources, if any, received the biggest increase in use as a result of the change in availability of library materials? Which changes in use patterns persisted even after the reopening of library buildings? How did we pull these information together? We used Excel’s Fuzzy Lookup to create unique reports from information spread across multiple platforms’ statistics. This presentation will explore Eresources usage during the COVID-19 pandemic as well as how to use the easy Fuzzy Lookup function to merge data.

avatar for Amy Fry

Amy Fry

Electronic Resources Management Librarian, University of Illinois at Urbana-Champaign
Ebooks, usage statistics
avatar for Jamie Gieseck-Ashworth

Jamie Gieseck-Ashworth

Account Services Manager, EBSCO Information Services
Jamie Gieseck-Ashworth has been an Account Services Manager (a.k.a. EBSCO traveling librarian) since 2012. She received her MLS from Kent State University in 2000. Jamie worked for 5 different OhioLINK libraries, both academic and medical, for over 14 years. Her duties covered... Read More →
avatar for Carol Seiler

Carol Seiler

Account Services Manager, EBSCO Information Services
Carol Seiler started her career in libraries as a cataloger and has worked in almost all areas of the library. She has primarily worked as an academic/medical librarian but has also served at a public library and as a technical services trainer with a consortium. Carol has been with... Read More →

Friday May 21, 2021 7:00pm - 8:00pm EDT
On Demand (pre-recorded)