Log In to Register
When and Where
  • 7/11/2023 2:00 PM CDT
  • 7/11/2023 3:30 PM CDT
  • 6/19/2023 11:45 PM CDT
  • Virtual
  • Sarah Pugachev

Workshop(s) Description:

This two-part interactive workshop series will introduce the fundamentals of quantitative data analysis with Excel using the recently released A*CENSUS II data. The series will take participants through the full process from understanding and organizing data to showcasing their analysis to highlight key insights. The first workshop will focus on understanding the data, exploring Excel’s functionality, and executing common statistical analyses. In preparation for the second workshop, participants will be given exercises to cement and enhance their understanding of the material. In the second workshop participants will use their analysis to create visually appealing dashboards to showcase significant data insights. At the conclusion of the second workshop, all participants should feel confident is using Excel with their own data to discover and communicate meaningful insights to colleagues and other sponsors.

Learning Objectives

  • Identify key quantitative data types and associated common statistical techniques. 
  • Understand core features and functions available to organize and interpret data in Excel. 
  • Statistically summarize a real dataset to discover meaningful insights. 
  • Create a visually appealing dashboard to showcase major findings from the data analysis. 

Instructor Bio:

Sarah Pugachev is the Somerville Director of the Science & Engineering Libraries and Research Initiatives at the University of Rochester, where she leads a team of STEM Librarians and data experts. In her work, she regularly leverages qualitative and quantitative data analysis techniques to inform departmental and institutional decisions and set long-term strategies. She has taught academic researchers and librarians coding and data skills since 2016 as a Software and Data Carpentries instructor. Sarah has an MS in Information Science from the University of Michigan and a BA in History from Emory University.

Fees: Advance / Regular 

SAA Members: $10.00

Employees of SAA Member Institutions: $10.00

Nonmembers: $10.00