Repository for the Summer/Fall 2020 KY training program focused on Transitions in Education and Workforce, which was taught in SQL and R.
Participants in this program were grouped into teams of 5 or fewer and created projects in hopes of understanding the labor market outcomes of individuals who acquired postsecondary degrees and credentials in Kentucky. Some project questions teams addressed were:
- Do STEM degree earners from Kentucky institutions tend to leave the state for employment more often than other Kentucky graduates?
- Are college students who earn a bachelor’s degree in education in Kentucky staying in Kentucky to teach, or are they often leaving to teach in another state?
- What are common characteristics of STEM and health degree earners from Kentucky institutions that find employment in a bordering state?
- How do the earning distributions and employment characteristics who earn their bachelor’s degree from a Kentucky university vary for those who have high-paying, stable employment patterns?
- What is the relationship between the level of credential earned by program graduates in transportation, skilled trades, and manufacturing training programs and their earnings following graduation?
June 22 - Program Introduction, Database Management, and Project Scoping
June 23 - Data Exploration
June 25 - Applications of Data Exploration
June 26 - Basics of Data Visualization
June 29 - Applications of Data Visualization
June 30 - Record Linkage
July 1 - Applications of Record Linkage
July 2 - Interim Presentations
July 29 - Introduction to Machine Learning
Sep 16 - Interim Presentations and Machine Learning, continued
Sep 17 - Inference
Sep 18 - Privacy, Confidentiality, and Ethics
The primary datasets used in the program are all stored in the PostgreSQL database appliedda on the ADRF. These datasets are:
- Kentucky Postsecondary Education Data System (KPEDS) and wage records
- Ohio Longitudinal Data Archive (wage records and education data)
- Indiana wage records and education data
- Illinois wage records
- Missouri wage records and education data
- Tennessee wage records