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
unit 1: Introduction to r and data frames
R-1 Notebook: Link to ADRF
Homework: .html, .rmd (Tiffany Answer Key, Corey Answer Key)
Feedback / Homework Submission
Unit 2: Joins, Aggregations, and Visualizations
R-2 Notebook: Link to ADRF
Homework: .html, .rmd (Answer Key: .HTML, .rmd)
Feedback / Homework Submission
unit 3: Introduction to sql
SQL-1 Notebook: Link to ADRF
Feedback / Homework Submission
unit 4: Joins; Using SQL in R
SQL-2 Notebook: Link to ADRF