This preconference workshop will be held online using Zoom.
Thursday, October 22, 2020
1:00 – 4:00 pm Eastern
PivotTables are easier than you think! Simple Yet Powerful Data Visualizations for Librarians with Excel
Librarians and library staff work with data collected from a variety of sources however data collection doesn’t always translate to data analysis or reporting. Lack of time, budgetary constraints prohibiting the purchase of data visualization software, and potentially steep learning curves regarding using advanced features of existing software to create meaningful data visualizations can all impact individuals’ ability and/or willingness to analyze collected data using data visualizations. In this session, we will walk all workshop attendees through the process of turning their library data (no matter how disorganized) into meaningful data visualizations using PivotTables in Excel. We will start off the workshop by discussing types of data that are best visualized with PivotTables, using examples of PivotTable visualizations created with our library’s data. We’ll discuss basic data cleaning, and specific concerns to consider when prepping your data for visualizing with Pivot Tables. We’ll share potential limitations of pivot tables and issues that you can encounter when building PivotTables. BYOD (Bring Your Own Device) is encouraged and time will be provided for workshop attendees to create their own data visualizations with the assistance of the workshop presenters.
Russell Michalak, Director of Library, Goldey-Beacom College
Russell Michalak, MLIS, joined Goldey-Beacom College (GBC) in 2010. As Director of Library & Learning Center/Assistant Professor, he oversees all operations of the library including the annual budget. In addition, he supervises and hires librarians, tutors, paraprofessionals, as well as manages the delivery of research, information, and instructional services as well as the operations of the tutoring center. His research agenda focuses on information literacy-related topics, with an emphasis on utilizing online training modules to increase international information literacy skills.
Monica Rysavy, Director of the Office of Institutional Research & Training, Goldey-Beacom College
Monica D.T. Rysavy, Ph.D. is the Director of Institutional Research and Training for Goldey-Beacom College in Wilmington, Delaware. In this role she leads all institutional research and data analysis projects for the College. Her office provides faculty and staff training support by developing new training offerings (asynchronous and synchronous face-to-face and online programs) on a variety of instructional technology, survey research, and data management/interpretation topics.
Monica earned her PhD. from The Pennsylvania State University’s College of Education in Learning, Design, and Technology. Her current research agenda focuses on information literacy-related topics, with an emphasis on utilizing online training modules to increase students’ information literacy skills. Similarly, she has focused on implementing and assessing online onboarding training modules to train and retain employees across many departments across the college.