Find us on GitHub

A Data Carpentry Workshop

Northeastern University Marine Science Center

May 18-19, 2017

9:00 am - 4:30 pm

Instructors: Katie Lotterhos, Jarrett Byrnes, Brian Teague

Helpers: Tanya Rogers, Isaac Rosenthal

General Information

Data Carpentry workshops are for any researcher who has data they want to analyze, and no prior computational experience is required. This hands-on workshop teaches basic concepts, skills and tools for working more effectively with data.

We will cover Data organization and spreadsheets, Introduction to R and dplyr, Data Management with SQL, finish with “R and databases” from R tutorial and Introduction to the Shell. Participants should bring their laptops and plan to participate actively. By the end of the workshop learners should be able to more effectively manage and analyze data and be able to apply the tools and approaches directly to their ongoing research.

The workshop will start at 9am sharp and end at 4pm every day.

YOU CAN SIGN UP FOR THIS WORKSHOP HERE. We will offer transportation to/from Wonderland T station. Please indicate when you register if you need transportation. After you sign up, you will receive an email with information about how to pay the registration fee. Registration is $10 for NU and $15 for non-NU personnell.

Who: The course is aimed at graduate students and other researchers.

Where: 430 Nahant Road, Nahant, MA 01908. Get directions with OpenStreetMap or Google Maps.

Requirements: Participants must bring a laptop with a Mac, Linux, or Windows operating sytem (not a tablet, Chromebook, etc.) that they have administrative privileges on. They should have a few specific software packages installed (listed below). They are also required to abide by Data Carpentry's Code of Conduct.

Contact: Please mail je.bowen@northeastern.edu for more information.


Schedule

Before you come: Checklist

1) You have filled out the Pre-workshop Survey

2) You have installed all necessary software: R and R studio, SQL, and the shell. For each section, please click on the links and follow the instructions. It is helpful if you download the latest version of software, even if you already have it on your computer. PLEASE TRY TO DO ALL INSTALLATIONS AT LEAST A FEW DAYS IN ADVANCE. If you have issues, first consult the wiki page (link at the bottom of this page). If you still have issues, please show up to the workshop early (8am) so we can help you.

  1. Link to Setup (For this lesson most people already have a spreadsheet app)
  2. Link to SQL Setup
  3. Link to R Setup (Please install newest version of R and R studio)
  4. Download and Install GitBash for Windows (If you have a Mac or Linux you can use the Terminal)

3) You read and agree to Data Carpentry's Code of Conduct

After you leave: Checklist

Post-workshop Survey

Day 1

Morning 8 am Pickup at Wonderland Contact je.bowen@northeastern.edu for more information
Morning 8:30 am Introductions, Setup and Installation Issues (Katie) See links below
Morning 9:00 am Data Organization (Jarret) Link to Setup (For this lesson most people already have a spreadsheet app) Link to Lesson
Morning 10:30 am Coffee
Morning 10:45 pm Introduction to R (Katie) Link to R Setup (Please install newest version of R and R studio) Link to Lesson (Chapters 1-2)
Lunch 12:00 pm
Afternoon 1:00 pm Introduction to R (Jarrett) Link to Lesson (Chapters 3-4)
Afternoon 2:30 pm Coffee
Afternoon 2:45 pm Introduction to R: dplyr (Jarrett) Link to Lesson (Chapters 3-4)
Afternoon 4:30 pm Informal, optional networking event

Day 2

Morning 8:30 am Pickup at Wonderland Contact je.bowen@northeastern.edu for more information
Morning 9:00 am Introduction to R: ggplot2 (Jarrett) Link to Lesson (Chapter 5)
Morning 10:15 am Coffee
Morning 10:30 am SQL (Brian) Link to SQL Setup Link to Lesson
Lunch 12:00 pm
Afternoon 1:00 pm SQL (Brian) Link to Lesson
Afternoon 2:30 pm Coffee
Afternoon 2:45 pm Integrating SQL and R (Katie) install.packages(c("tidyverse", "RSQLite")) Link to Lesson
Afternoon 3:45 pm Other tools (Bash or tidyr) Download and Install GitBash for Windows (If you have a Mac or Linux you can use the Terminal) Link to Lesson //// Link to data
Afternoon 4:45 pm Workshop Wrap-Up

Etherpad: http://pad.software-carpentry.org/2017-05-18-Nahant.
We will use this Etherpad for chatting, taking notes, and sharing URLs and bits of code.


Setup

To participate in a Data Carpentry workshop, you will need working copies of the described software. Please make sure to install everything before the start of your workshop. If you are having trouble getting the software installed, please show up at the workshop early so that we can help you get up and running. Participants should bring and use their own laptops to insure the proper setup of tools for an efficient workflow once you leave the workshop.

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.