Data Carpentry

Schusterman Library at OU-Tulsa

Online

September 2, September 9, September 16, September 23, 2020

Each session is from 10:00 am - 12:00 pm

Instructors: Krista Kezbers, Toni Hoberecht

Helpers: Alyssa Migdalski, Emrys Moreau, Claire Curry

General Information

Data Carpentry develops and teaches workshops on the fundamental data skills needed to conduct research. Its target audience is researchers who have little to no prior computational experience, and its lessons are domain specific, building on learners' existing knowledge to enable them to quickly apply skills learned to their own research. Participants will be encouraged to help one another and to apply what they have learned to their own research problems.

For more information on what we teach and why, please see the paper "Good Enough Practices for Scientific Computing".

Who: The course is aimed at faculty, graduate students, residents, and research staff. 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: September 2, September 9, September 16, September 23, 2020. Add to your Google Calendar.

Requirements: Participants must have a laptop or 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 krista-kezbers@ouhsc.edu or toni-hoberecht@ouhsc.edu for more information.


Register Here

The sessions all build on each other and we recommend attending all. However, you can choose to attend only one or two of the workshops; attendance at all four workshops is not mandatory.

Register for Wednesday, September 2, 10am-12pm: Data organization in spreadsheets

Register for Wednesday, September 9, 10am-12pm: OpenRefine for data cleaning

Register for Wednesday, September 16 and Wednesday, September 23, 10am-12pm: Data management in SQL

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

September 2

10:00am - 12:00pm Pre-workshop survey
Confirming software installations
Data Organization in Spreadsheets

September 9

10:00am - 12:00pm Pre-workshop survey
Confirming software installations
OpenRefine for Data Cleaning

September 16

10:00am - 12:00pm Pre-workshop survey
Confirming software installations
Data Management with SQL - Part 1

September 23

10:00am - 12:00pm Pre-workshop survey
Confirming software installations
Data Management with SQL - Part 2
Post-workshop survey

Syllabus

Data Management with SQL


Setup

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

Please note that we will be using the Ecology curriculum and software for the Data Management with SQL lesson. Please download DB Browser for SQL as instructed in the setup. However, you should download the ecology dataset, available here, rather than the social sciences dataset indicated on the setup page.

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.

Software Downloads

The software downloads and data sets used in the Data Carpentry Social Sciences workshops (with R) can be found at the workshop overview site. Please consult this page well before the workshop begins, and follow all instructions. You won't be able to participate in the workshop without having the software installed and the data sets ready to go.