TDC Module 1

Home Module 1 Module 2 Pre-Module 3 Work Module 3

Presentation/Report Resources Contacts

Module 1 Zoom MEETINGS

Day 1: April 22 Day 2: April 29 Day 3: May 6 Day 4: May 13

Day 5: May 18 Day 6: May 19

The Introduction to SQL and R module is self-paced, delivered online and through the ADRF, and has weekly discussion sessions. You will not need to install any specific software. However, you do need to create an ADRF account as all notebooks needed for this course are located in the ADRF. We expect the content to take no more than 4 hours per week.

The data documentation pertaining to the public data used in this module contains an in-depth description of the variables and tables you will analyze. The documentation is also available for you inside the ADRF.

PRE-WORK

Introduction to Programming

Introduction Videos

DAY 1 (12:00pm-1:00pm et)

UNIT 1: INTRODUCTION TO R AND DATA FRAMES

• R-1 Notebook: Link to ADRF

• R-1 Accompanying Videos

day 2 (12:00pm-1:00pm et)

UNIT 2: JOINS, AGGREGATIONS, AND VISUALIZATIONS

• R-2 Notebook: Link to ADRF

• R-2 Accompanying Videos

day 3 (12:00pm-1:00pm et)

UNIT 3: INTRODUCTION TO SQL

• SQL-1 Notebook: Link to ADRF

• SQL-1 Accompanying Videos

day 4 (12:00pm-1:00pm et)

LectureS and team work will begin

day 5 (12:00pm-2:00pm et)

May 18: OVERVIEW, PROJECT SCOPING, AND Privacy and confidentiality

• 50 mins: Overview, Project Scoping, and Privacy and Confidentiality

• 5 mins: Break

• 50 min: Group work

• 5 mins: Preview of Day 6

day 6 (12:00pm-2:00pm et)

May 19: dataset introduction and Exploratory data analysis 

• 55 mins: Dataset Introduction and Exploratory Data Analysis

• 5 mins: Break

• 55 mins: Group work

• 5 mins: Preview for Module 2