NOTE: This is a two-part special event. Part 1, a prerequisite, will take place on Tuesday, July 11, and Part 2 will be a Forum on Saturday, July 29, in conjunction with the CoSA + SAA Joint Annual Meeting. Should you want to attend Part 2, you should register for the Joint Annual Meeting in advance.
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 on July 11 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 held as a hybrid event during the CoSA + SAA Joint Annual Meeting on July 29, 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.
- 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.
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