AR Module 1

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

Presentation/Report Resources Contacts

Module 1 Zoom MEETINGS

Day 1: May 5 Day 2: May 12 Day 3: May 19 Day 4: May 26

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.

When logging into the Module 1 workspace, the icon will not appear automatically when you complete the onboarding process. If the icon does not appear 24 hours after completing onboarding, please email support@coleridgeinitiative.org

PRE-WORK

Introduction to Programming

Introduction Videos

JupyterLab Help Document

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)