• Home
  • Library Carpentry

Library Carpentry Workshop Series

July 2018
9:00 am - 12:00 pm each day
Watson Library, Room 455, KU Campus

Library Carpentry teaches software and data skills with a goal of helping information workers work more efficiently and increase productivity. In this four-part, weekly workshop series, you will learn about data structures and regular expressions; data manipulation and cleaning with OpenRefine; relational database management systems with SQLite; and workflow enhancement tools including MacroExpress, MarcEdit, 3D Clipboard, and Notepad++.

These workshops are for you especially if you have no prior experience with one or more of the topics. You do not have to attend the entire series. Each session is capped at 20 participants. A waitlist will be available should a session reach capacity. A laptop will be provided for you unless you wish to bring your own. If you want to bring your own laptop, please pay attention to the setup instructions specific to each session. These are available on the session's Github page.

Register individually for the session or sessions that interest you.

Wednesday, July 11, 2018: Introduction to Data
This session introduces information workers to working with data. You will:

  • Define terms, phrases, and concepts in software development and data science
  • Identify and use best practices in data structures
  • Use regular expressions in searches
  • Participate in discussion about applying these concepts/tools in your own work

More details about this topic and a detailed schedule can be found on the session's GitHub page.

Register for Introduction to Data


Wednesday, July 18, 2018: OpenRefine
This workshop introduces manipulating and cleaning data using OpenRefine. You will:

  • Understand what OpenRefine does
  • Gain experience using OpenRefine to work with data files
  • Participate in discussion about applying OpenRefine in your own work

More details about this topic and a detailed schedule can be found on the session's GitHub page.

Register for OpenRefine


Wednesday, July 25, 2018: SQL
This workshop introduces relational database management systems using SQLite. You will:

  • Understand what SQLite does
  • Gain experience using SQLite to summarize and link databases
  • Participate in discussion about applying SQL queries and/or SQLite in your own work

More details about this topic and a detailed schedule can be found on the session's GitHub page.

Register for SQL


Tuesday, July 31, 2018: Workflow Enhancement Tools
This workshop introduces tools that can streamline repetitive work. You will:

  • Create a macro using MacroExpress
  • Batch edit a file of records using MarcEdit
  • Participate in demonstrations of 3D Clipboard and Notepad++
  • Participate in discussion about applying one or more of these tools in your own work

Register for Workflow Enhancement Tools


Sponsored by KU Libraries


1.5 million visits a year at 7 library locations
Top 50 nationwide for size of library collection
—American Library Association
KU ScholarWorks offers access to more than 13,000 items created by KU faculty and students
An international leader in the open access movement
Users check out nearly 300,000 items every year
Users access more than 3.3 million articles online each year
More than 111,000 scores, books, sound recordings, and other volumes in Music & Dance Library
Anschutz Library serves as KU’s 24-hour study facility for students
More than 700 Vosper Society members support the mission of KU Libraries
One of 34 U.S. public institutions in the prestigious Association of American Universities
KU Today