CILIP MDG Library Carpentry Workshop: Practical Skills for Working with Data
-
2 February 2027 9:30am to 9 February 2027 5:00am
-
LSE Library
-
Community
-
EVT-10227
-
Active
A Two-Day Library Carpentry Workshop: Practical Skills for Working with Data
Tuesday 2 February and Tuesday 9 February 2027
9.30am – 5pm
Where: LSE Library
Presenter: Fran Frenzel, LSE Library
Contact: Victoria Webb
events.mdg@cilip.org.uk
online registration available until 25 January 2027
Please note: Both sessions must be attended
This hands-on, two-day Library Carpentry workshop is designed specifically for library metadata professionals who want to build confidence and practical skills in working with data. It is ideal for those who are new to data wrangling, as well as for anyone with limited prior experience or knowledge.
The workshop focuses on working with data outside a MARC environment, with particular attention to formats commonly encountered in metadata work, such as delimited files, XML, and JSON. While the emphasis is on non-MARC data, the concepts, strategies, and tools covered are widely transferable and highly relevant across a range of library systems and workflows.
As with all Carpentries workshops, the goal is not to teach everything, but to significantly lower the barrier to entry and give participants the practical skills, foundational knowledge, and confidence to apply what they learn in their own work—and to continue developing their expertise independently. The workshop is practical and interactive throughout, rather than lecture-style teaching.
Participants will need to bring their own laptops. There are no loan machines available at the venue.
Day 1: Data basics, computational thinking and working with spreadsheet data
Day 1 begins by demystifying the jargon around common data types and character encoding, and an introduction to data formats frequently encountered in library metadata work. Understanding how data is structured, stored, and encoded is essential when working outside an LMS – and very useful when working in one.
The second half of the day focuses on data organisation, cleaning, and quality control, using a spreadsheet application. Participants will learn practical techniques for working with metadata in spreadsheets and identifying and fixing common data issues.
Prerequisites for day 1:
- a working installation of Microsoft Excel or LibreOffice (installation instructions will be provided after registration)
- the training data file(s) (supplied after registration)
Day 2: Regular expressions and working in OpenRefine
Day 2 introduces participants to regular expressions, a powerful tool for matching, extracting, and transforming text. Regular expressions are widely used in contexts ranging from text editors and MARCEdit to Library Management Systems, and mastering them can take data work to the next level.
The second half of the day focuses on OpenRefine, a powerful open-source tool for cleaning messy datasets, reconciling values, and exploring data at scale. Participants will learn the basics of OpenRefine, including transforming and exporting data
Prerequisites for day 2:
- a working installation of OpenRefine (installed locally or run from a USB drive) (installation instructions will be provided after registration)
- a modern web browser (Chrome, Firefox, Microsoft Edge, or Safari)- the training data file(s) (supplied after registration)
Event Presenter
Price (two-day course, including refreshments and lunch)
*MDG Committee is pleased to subsidise this training to make it affordable across all sectors and is grateful for the generosity of LSE Library for providing the venue and giving staff time to facilitate the training. See below for details of fully-funded MDG Bursary places.
CILIP members: £230 +VAT
Non-members: £350 +VAT
Employer Partners: £280 +VAT - please contact your rep or email employerpartners@cilip.org.uk for the discount code. Please select the Non-Member ticket and apply the code at checkout.
There are 15 seats available, book now to reserve your place.
Online registration available until 25 January 2027
MDG Bursary places
MDG Committee is pleased to sponsor 2 places to attend the Library Carpentry workshop; the sponsorship covers the registration fee and reimbursement for travel costs (up to £200).
How to apply
Applicants must be currently studying for, or have recently completed a Library and Information Studies/Science, Archives or Knowledge Management qualification, or be new to the Information Profession (less than 5 years' experience), and/or be without the financial means to cover the cost of attendance.
Please submit a brief application (200 words approx.) to demonstrate why you would like to attend, how you would use your attendance to highlight or promote MDG's areas of interest, and why you would not be able to attend without MDG sponsorship.
We would like the sponsored delegates to write a report or summary to be published in the MDG Bulletin or in our open access journal, Catalogue & Index, but are equally happy for you to suggest an alternative output.
When to submit
Please submit your application to secretary.mdg@cilip.org.uk and copy in (cc) chair.mdg@cilip.org.uk by 5pm on 8th January 2027.
If you have any questions, do not hesitate to get in touch by email (to either of the above email addresses)
When you'll know
Applicants will be notified whether they have been successful on 15th January 2026.