Office of Institutional Effectiveness
Welcome!
🗓️ Thursdays
⏰ 3:00 - 4:50
🏫 SET 524
As automation, reproducibility, collaboration, and frequent reporting become increasingly expected in work around campus, R is a good option for staff looking to expand their toolchain. Integrating R into your workflow can increase productivity by automating repetitive tasks and eliminating error-prone copying and pasting. R enables staff to combine spreadsheet data with SQL queries from multiple servers. This colloquium will focus on data import and export, basic wrangling, visualization, and reporting with RMarkdown. We will emphasize conventions and best practices for working reproducibly and collaboratively with data, including naming conventions, documentation, and organization, all while “keeping the raw data raw”. Whether you are new to programming and want to get started in R, already working in R, and want tools for working more seamlessly with collaborators across campus, or have extensive reporting experience, this is the course for you!
Attendees will learn tools for integrating R into their existing data analysis workflow. Upon completing the workshop, participants will have learned the basics of working with data in R/RStudio, and will have experience generating automated reporting from multiple data sources.
This colloquium will be appropriate for attendees who answer yes to these questions:
Have you ever used Excel and wished you could automate all the clicking and checking? Have you ever wished you could pull from multiple databases and join the results? Are you new to data analysis, and looking for a good place to get started?
Before the training, please do the following (20 minutes). All software is free.
- Download and install R and RStudio:
- R: https://cloud.r-project.org/
- RStudio: http://www.rstudio.com/download
- Follow your operating system's normal installation process
- Create a GitHub account:
- GitHub: https://github.com
- Follow optional advice on choosing your username
- Remember your username, email and password; we will need them for the workshop!
- Download and install Git
- Git: https://git-scm.com/downloads
- Follow your operating system's normal installation process. Note: you will not see an application called Git listed but if the installation process completed it was likely successful, and we will confirm together
All course material are available in this repo.
| Week | Day | Topic |
|---|---|---|
| Week 1 | April 6 | Install help |
| Week 2 | April 13 | Overview of basic tidyverse verbs; Intro to markdown |
| Week 3 | April 20 | Intro to Git and Github; pulling data from the database |
| Week 4 | April 27 | Intro to GitHub |
| Week 5 | May 4 | Pivot Tables & dplyr |
| Week 6 | May 11 | |
| Week 7 | May 18 | |
| Week 8 | May 25 | |
| Week 9 | June 1 | |
| Week 10 | June 8 |