Monash University Malaysia

Online

21 July, 23 July, 28 July, 30 July 2020

10:00 am - 3:00 pm

Instructors: Matthias Liffers, Anton Angelo

Helpers: Dong Danping, Belinda Sta Maria

Registration

Please register your interest in the Library Carpentry workshops by 5 July 2020 by filling up this form.

General Information

Library Carpentry is made by people working in library- and information-related roles to help you:

Library Carpentry introduces you to the fundamentals of computing and provides you with a platform for further self-directed learning. For more information on what we teach and why, please see our paper "Library Carpentry: software skills training for library professionals".

Who: The course is for people working in library- and information-related roles. You don't need to have any previous knowledge of the tools that will be presented at the workshop.

Where: This training will take place online. The instructors will provide you with the infromation you will need to connect to this meeting.

When: 21 July, 23 July, 28 July, 30 July 2020. Add to your Google Calendar.

Requirements: Participants must bring a laptop with a Mac, Linux, or Windows operating system (not a tablet, Chromebook, etc.) that they have administrative privileges on. They should have a few specific software packages installed (listed below).

Accessibility: We are dedicated to providing a positive and accessible learning environment for all. Please notify the instructors in advance of the workshop if you require any accommodations or if there is anything we can do to make this workshop more accessible to you.

Contact: Please email mum-lib-contact@monash.edu , matthias.liffers@ardc.edu.au or anton.angelo@canterbury.ac.nz for more information.


Code of Conduct

Everyone who participates in Carpentries activities is required to conform to the Code of Conduct. This document also outlines how to report an incident if needed.


Collaborative Notes

We will use this collaborative document for chatting, taking notes, and sharing URLs and bits of code.


Surveys

Please be sure to complete these surveys before and after the workshop.

Pre-workshop Survey

Post-workshop Survey


Schedule

Day 2 - 23 July

10:00 SQL
12:00 Lunch break
13:00 SQL - cont
14:50 Wrap-up
15:00 END

Day 3 - 28 July

10:00 OpenRefine
12:00 Lunch break
13:00 OpenRefine - cont
14:50 Wrap-up
15:00 END

Day 4 - 30 July

10:00 Tidy Data
12:00 Lunch break
13:00 Tidy Data - cont
14:40 Wrap-up
14:50 Post-workshop survey
15:00 END

Syllabus

Jargon Busting, A Computational Approach, Introduction to Working with Data

  • Jargon Busting
  • A Computational Approach
  • Introduction to Working with Data (Regular Expressions)
  • Reference...

SQL

  • Selecting and sorting data
  • Filtering
  • Aggregating & calculating values
  • Ordering and commenting
  • Joins and aliases
  • Saving queries
  • Database design
  • Other database tools
  • Reference...

OpenRefine

  • Introduction to OpenRefine
  • Importing Data
  • Basic Functions
  • Advanced Functions
  • Reference...

Tidy Data for Librarians

  • What are good data practices?
  • How should data tables be formatted in spreadsheets?
  • What common mistakes are made when formatting spreadsheets?
  • How are dates handled by computers?
  • Can you keep data clean and sane?
  • What problems are there with Excel files?
  • What do you need to be aware of when exporting data?
  • Reference...

Setup

To participate in a Library Carpentry workshop, you will need access to the software described below. In addition, you will need an up-to-date web browser.

We maintain a list of common issues that occur during installation as a reference for instructors that may be useful on the Configuration Problems and Solutions wiki page.

Day 1: Introduction to Data

This workshop needs no special software beyond a web browser

Day 2: SQL

SQL is a specialized programming language used with databases. You will need to install DB Browser for SQLite for this workshop. Please find instructions to install it and the data used in the lesson in the lesson.

Day 3: OpenRefine

OpenRefine is a tool to clean up and organize messy data. Please find instructions to install it and the data used in the lesson in the lesson.

Day 4: Tidy Data

Tidy data introduces best practices for working with data in spreadsheets. This workshop needs a spreadsheet software (generally Microsoft Excel). If you don't have a spreadsheet program installed please follow the download instructions here. Please also download the data here.