Excel for Librarians
Instructor: Greer Martin
Dates: January 6th to February 2nd, 2020
Credits: 1.5 CEUs or 15 PDHs
At some point in your library career you will interact with a spreadsheet, be it one that contains data you have entered, someone else has entered, or data you have exported from a system. With Excel, you can easily manage and wrangle structured data, even if it is not in an Excel format. This class will teach the basics of working in Excel, including entering, structuring, manipulating, importing and exporting data. It will also cover some Excel functions and tools for basic data analysis. The class assignments will incorporate practical data tasks that you would encounter in a library or information management setting.
By the end of the class, students will:
- Learn good practices for data entry, spreadsheet structure, and data organization
- Understand data formats and how to troubleshoot common formatting errors (such as dates)
- Be able to sort and filter data and write basic Excel functions
- Learn how to perform cleanup, quality control, and data validation using Excel's data tools
- Learn to import and export data to CSV and tab separated files
This course can be taken as one of eight courses needed to earn our Certificate in Cataloging and Technical Services, but can be taken as a stand-alone course as well.
Greer Martin is the Metadata Technologies Librarian at Loyola University Chicago, where she coordinates metadata interoperability across library platforms. She has written and presented on using OpenRefine for metadata cleanup and authority reconciliation, and has managed metadata migration projects. Greer previously held metadata librarian positions at the Illinois Institute of Technology and the University of Georgia where she created and enhanced metadata for aggregation by Digital Public Library of America. She received an MLIS from the University of Illinois at Urbana-Champaign.
This is an online class that is taught asynchronously, meaning that participants do the work on their own time as their schedules allow. The class does not meet together at any particular times, although the instructor may set up optional sychronous chat sessions. Instruction includes readings and assignments in one-week segments. Class participation is in an online forum environment.
Please contact us to arrange a special session of this class for a group of seven or more, with a negotiable discount, or to be notified when it is next scheduled.