Chapter 1 Welcome

Deprecated draft matrials: please see http://rstd.io/r-for-excel for current teaching materials

Hello! These are materials for a pilot workshop that was taught by Julie Stewart Lowndes and Allison Horst in preparation for the RStudio Conference in San Francisco January 27-28.

We are environmental scientists who use and teach R in our daily work. We both work at the University of California Santa Barbara: Julie is based at the National Center for Ecological Analysis and Synthesis as part of the Ocean Health Index team and leads Openscapes, and Allison is based at the Bren School of Environmental Science and Management as a lecturer of data science & statistics — and is also an Artist in Residence at RStudio.

1.1 Agenda: pilot workshop

Time Day 1 Day 2
9-10:30 Motivation, R & RStudio, RMarkdown Charts with ggplot2
break
11-12:30 Intro to GitHub dplyr & Pivot Tables
lunch
13:00-14:30 Importing data: readxl dplyr & VLOOKUPs

From 14:30-15:00 each day we have time for additional help and feedback.

1.2 Prerequisites

Before the training, please make sure you have done the following:

  1. Download and install up-to-date versions of:
  2. Install the Tidyverse
  3. Create a an account:
  1. Get comfortable: if you’re not in a physical workshop, be set up with two screens if possible. You will be following along in RStudio on your own computer while also watching a virtual training or following this tutorial on your own.