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 our paper "Good Enough Practices for Scientific Computing".

Who: The course is aimed at graduate students and other researchers. You don't need to have any previous knowledge of the tools that will be presented at the workshop.

Where: Room 025, Fasciatelli Engineering Building, E Alumni Ave, Kingston, RI 02881. Get directions with OpenStreetMap or Google Maps.

Parking: If you are visiting URI for the workshop see the URI Parking website for visitor parking information.

When: Sep 01-02, 2022. 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 committed to making this workshop accessible to everybody. The workshop organizers have checked that:

• The room is wheelchair / scooter accessible.
• Accessible restrooms are available.

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 rsschwartz@uri.edu or brownsarahm@uri.edu 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.

Report a Code of Conduct Incident

---

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

Before starting	Pre-workshop survey
Afternoon 1: 1-3	Introduction to R: Data manipulation and analysis
Afternoon break
Afternoon 2: 3:15-4:30	Continuation of R: Data Visualization
Morning: 10:30-12:30	Data Organization in Spreadsheets
Lunch: 12:30-1
Afternoon: 1-3	Data Management with SQL
Finish	Post-workshop survey
Lunch

---

Syllabus

Material covered today

Introduction to R

• Overview of R and RStudio
• Starting with Data
• Manipulating Data Frames with dplyr
• Data Visualisation with ggplot2
• Interacting with Databases with dbplyr

Tidyverse information. Note: click through to access cheatsheets for each package.

Data Organisation in Spreadsheets

• Introduction
• Formatting Data
• Common Formatting Problems
• Dates as Data
• Quality Control
• Exporting Data

Download this data file to your computer: https://ndownloader.figshare.com/files/2252083
Download this data file to your computer: Survey Sorting Exercise
Best Practices for Using Google Sheets in Your Data Project

---

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.

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.

Please visit the setup instructions for each lesson that will be covered in your workshop:

• Spreadsheets
• SQL (get the data but ignore the software section)
• R and RStudio

Workshop Sponsorship

This workshop is made possible in part by a grant from the National Science Foundation to Rachel Schwartz.