University of Toronto Scarborough

Jan 8-9, 2020

9:30 am - 4:30pm both days

Instructors: Deena Yanofsky, Jordan Pedersen, Lise Doucette, Angel Su, Kathy Chung, Bryan Hong, Mariana Jardim, Sarah Forbes

Helpers: Kirsta Stapelfeldt, David Kwasny, Julia Borie

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: UTSC Catalyst Centre (Ground Floor RM. EV-151), 1065 Military Trail, Scarborough, Ontario, Canada. Get directions with OpenStreetMap or Google Maps.

When: Jan 8-9, 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).

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.

Accessibility: We are committed to making this workshop accessible to everybody. The workshop organizers have checked that:

Materials will be provided in advance of the workshop and large-print handouts are available if needed by notifying the organizers in advance. If we can help making learning easier for you (e.g. sign-language interpreters, lactation facilities) please get in touch (using contact details below) and we will attempt to provide them.

Contact: Please email deena.yanofsky@utoronto.ca or jordan.pedersen@utoronto.ca for more information.


Surveys

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

Pre-workshop Survey

Post-workshop Survey


Schedule

Day 1

Before Starting Pre-workshop survey
09:30 Data Intro and Regex
10:30 Morning break
12:00 Lunch break
13:00 Shell Lesson
14:30 Afternoon break
16:00 Wrap-up
16:30 END

Day 2

09:30 SQL
10:30 Morning break
12:00 Lunch break
13:30 OpenRefine
14:30 Afternoon break
16:15 Wrap-up
16:30 Post-workshop survey

We will use this collaborative document for chatting, taking notes, and sharing URLs and bits of code. ***UPDATE: Because of issues with our first collaborative etherpad, we have opened a second etherpad which will be used for the remainder of the workshop and pasted all the text from the first one in it: https://pad.carpentries.org/2020-01-09-utsc . The original pad still exists, and you can reference it if you wish to look back on it and see what you contributed, as the new document is not colour-coded by contribution.


Syllabus

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

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

The Unix Shell

  • Files and Directories
  • History and Tab Completion
  • Counting and Sorting Contents in Files
  • Pipes and Redirection
  • Mining or Searching in Files
  • Reference...

SQL

  • Introduction to SQL
  • Selecting and Sorting Data
  • Filtering
  • Aggregating and 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...

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.

The Bash Shell

Bash is a commonly-used shell that gives you the power to do simple tasks more quickly. Please find setup instructions in the lesson.

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.

SQL

You will need to install DB Browser for SQLite to complete these lessons. If this does not work for you for whatever reason, you may optionally use SQLite or SqliteOnline. Setup instructions can be found in lesson.