Library Carpentry
SUB Göttingen
Online
Feb 28- Mar 4, 2022
09:00 am - 14:00 pm (appr.)
Instructors: José Calvo Tello, Britta Timmermann, Najko Jahn, Anne Hobert, Julika Mimkes, Péter Király, Felix Mackebrandt
Helpers: Harald Kusch, Hanna Varachkina, Felix Mackebrandt
General Information
Library Carpentry is made by people working in library- and information-related roles to help you:
- automate repetitive, boring, error-prone tasks
- create, maintain and analyze sustainable and reusable data
- work effectively with IT and systems colleagues
- better understand the use of software in research
- and much more...
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".
Kurssprache: Deutsch
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 information you will need to connect to this meeting.
When: Feb 28- Mar 4, 2022. Add to your Google Calendar.
Requirements: Participants must have access to a computer 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 varachkina@sub.uni-goettingen.de or mimkes@sub.uni-goettingen.de for more information.
Roles: To learn more about the roles at the workshop (who will be doing what), refer to our Workshop FAQ.
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.
Surveys
Please be sure to complete these surveys before and after the workshop.
Schedule
28.02.2022.
| 09:00 | Help desk |
| 09:30 | Data Intro for Archivists |
| 13:00 | END |
01.03.2022
| 09:00 | Tidy data for librarians |
| 11:30 | OpenRefine |
| 12:30 | END |
02.03.2022
| 09:00 | The Unix Shell |
| 10:30 | Introduction to Git |
| 13:00 | END |
03.03.2022
| 09:00 | SQL |
| 12:30 | END |
04.03.2022
| 09:00 | Python Intro for Libraries |
| 13:30 | END |
Setup
To participate in a Library Carpentry workshop, you will need access to software as 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.
Install the videoconferencing client
If you haven't used Zoom before, go to the official website to download and install the Zoom client for your computer.
Set up your workspace
Like other Carpentries workshops, you will be learning by "coding along" with the Instructors. To do this, you will need to have both the window for the tool you will be learning about (a terminal, RStudio, your web browser, etc..) and the window for the Zoom video conference client open. In order to see both at once, we recommend using one of the following set up options:
- Two monitors: If you have two monitors, plan to have the tool you are learning up on one monitor and the video conferencing software on the other.
- Two devices: If you don't have two monitors, do you have another device (tablet, smartphone) with a medium to large sized screen? If so, try using the smaller device as your video conference connection and your larger device (laptop or desktop) to follow along with the tool you will be learning about.
- Divide your screen: If you only have one device and one screen, practice having two windows (the video conference program and one of the tools you will be using at the workshop) open together. How can you best fit both on your screen? Will it work better for you to toggle between them using a keyboard shortcut? Try it out in advance to decide what will work best for you.
Notepad++
For "Data Intro for Archivists" you will have to install Notepad++. You can download the latest version from this website.
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.
Git
Git is a version control system that lets you track who made changes to what when and has options for easily updating a shared or public version of your code on https://github.com.
Follow the instructions on the lesson to install Git on your system.
You will need an account at github.com for parts of the Git lesson. Basic GitHub accounts are free. We encourage you to create a GitHub account if you don't have one already. Please consider what personal information you'd like to reveal. For example, you may want to review these instructions for keeping your email address private provided at GitHub. You will need a supported web browser.
SQL
DB Browser for SQLite
You will need to install DB Browser for SQLite to complete these lessons. DB Browser for SQLite provides a graphical user interface for connecting to and interacting with a SQLite database. This application bundles SQLite, so you won’t need to install SQLite separately. Note: on Windows, the PortableApp download is recommended as the regular version may take a long time to install on certain systems. Download the data
To import data, you’ll need to open DB Browser for SQLite and download a zip file containing the data files for this tutorial.
Download the data files doaj-article-sample.zip from Zenodo. Open the zip file with the zip utlity on your machine and save the folder and files to a location where you can easily find them. For example, your Desktop. Contained in the zip file are two files, doaj-article-sample.db and doaj-article-sample.db.sql. You can either open the database file (less steps) or import the SQL file (more steps).
Open the database file
Open DB Browser for SQLite. Choose “File” > “Open Database” from the menu bar at the top of your screen. Navigate to where you saved the doaj-article-sample folder and/or files. For example, your Desktop. Select “doaj-article-sample.db”.
Import the SQL file
Open DB Browser for SQLite. Choose “File” > “Import” > “Database” from SQL file from the menu bar at the top of your screen. Navigate to where you saved the doaj-article-sample folder and/or files. For example, your Desktop. Select “doaj-article-sample.db.sql”. You will be prompted to “Save As” (i.e. this is the name of the database). Type “doaj-article-sample” in the “Save as” box. Make sure that “SQLite database files” is selected in the drop down and that you save the database to a location where you can easily find it, again, like your Desktop. Click “Save”. You should see an “Executing SQL…” prompt and an “Import completed.” prompt when finished. Click “OK”. You will see one more prompt which says, “Do you want to save the changes made to the database file…”. Click “Save”.
Python
In order to make it easier for the participants, we are going to use Jupyter Notebooks hosted by the GWDG. That means, you do NOT have to download or install anything.
In stead, please, log in at the GWDG Jupyter Cloud service.
If you are able to see this dashboard, you are ready for the Python workshop:
