UNCF/Excelencia Module 1: Introduction to SQL & R



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 UNCF/Excelencia training 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.

Note: The file path to access the coding review materials is slightly different than what is indicated in the videos. To access the materials, please use the following file path: P: > tr-uncf-excelencia> Module 1 Materials. This is the only folder you are permitted to access within tr-uncf-excelencia.

Pre-work

Introduction to Programming

Introduction Videos

unit 1: Introduction to r and data frames

R-1 Notebook: Link to ADRF

R-1 Accompanying Videos

Homework: .html, .rmd (Tiffany Answer Key, Corey Answer Key)

Feedback / Homework Submission

Unit 2: Joins, Aggregations, and Visualizations

R-2 Notebook: Link to ADRF

R-2 Accompanying Videos

Homework: .html, .rmd (Answer Key: .HTML, .rmd)

Feedback / Homework Submission

unit 3: Introduction to sql

SQL-1 Notebook: Link to ADRF

SQL-1 Accompanying Videos

Homework (Answer Key)

Feedback / Homework Submission

unit 4: Joins; Using SQL in R

SQL-2 Notebook: Link to ADRF

SQL-2 Accompanying Videos

Homework: .html, .rmd

Feedback / Homework Submission