The presentation will begin at approximately 1 :00 p.m. ET

1. Linking K12 Education Data to Workforce The presentation will begin at approximately 1:00 p.m. ET Information on joining the teleconference can be found on the “Info” tab in the upper left of this screen. Be sure to use the “Attendee ID” number on the Info tab when dialing in to associate your name with your phone. In order to cut down on background noise, please mute your phone by dialing *6 upon entry into the meeting. During the question and answer portion of this presentation: • You can re-enter *6 to un-mute your phone and ask a question; or • Type your question into the Q&A panel below the participant list and clicking “Send”. A copy of this presentation and a link to the recording will be shared with the IES Grantees and EIMAC listservs. SLDS Webinar 8-28-14

2. Linking K12 Education Data to Workforce Panelists Kate Akers, Acting Executive Director, Kentucky Center for Education and Workforce Statistics Karen Jarboe Singletary, Senior Research Analyst, Communications & Research, Idaho Department of Labor Agenda What has been linked and how Best practices and lessons learned Questions from participants SLDS Webinar 8-28-14

3. Linking K12 Education Data to Workforce Kentucky Center for Education and Workforce Statistics (KCEWS) SLDS Webinar 8-28-14

4. What Is the Center? Board • Independent state agency charged with maintaining the P-20 SLDS and measuring and evaluating education and workforce at all levels • Legislatively authorized to collect data from all education and workforce programs • Created in December 2012 by Executive Order and ratified into law in 2013 legislative session • Builds upon the work of the P-20 Data Collaborative (since 2009) SLDS Webinar 8-28-14

5. What Is the Center Tasked to Do? Evaluate education and workforce programs statewide Develop state-level metrics Monitor privacy, confidentiality, and data quality Better inform policy makers and stakeholders Kentucky Longitudinal Data System (KLDS) SLDS Webinar 8-28-14

6. The Kentucky Longitudinal Data System • Policy Eval’s Identity Resolution/ Assignment And Cleaning • What If’s • CPE • UI • KDE • Data Requests • Reports • WIA • EPSB • Analyses • EC De-Identified Warehouse

7. Why Link K12 and Workforce Data? By linking individual pieces together, we can see a more complete picture of public policy. The state does not think of itself as individual pieces but as a whole. COLLEGE K-12 WORK ECONOMY

8. How Did We Link? As data come in from all the various sources, they are matched through multiple levels, including fuzzy logic on agency IDs, SSNs, names, and birth dates, depending on the demographics each agency provides The “best” and/or latest cumulative data for each person is housed in a master person table Workforce provides only SSNs and partial names, so SSNs are used exclusively to link back to the master person table SLDS Webinar 8-28-14

9. Challenges and Caveats Employment data are available from the UI wage reports made by employers which includes about 90 percent of all people employed in Kentucky Limitations of the data: • Only includes people employed in-state (adding out-of-state Fall ‘13) • Does not include federal or military employees (adding federal Fall ’13) • Only provides quarterly wage data by industry and employer location – not occupations and not *where* they work but where their employer’s central office exists More detailed employment data are available from K-12 teachers and staff and adult education staff and those who are making unemployment insurance claims SLDS Webinar 8-28-14

10. Stakeholder Engagement:Why Link Data? Use employment data as outcomes for education and training programs Inform educators about program need, demand, and what students should expect about employment location and potential wages Indicator of the need for new academic programs Indicator of out-of-state migration Work toward understanding the alignment between education production and workforce needs Provide return on investment Federal reporting SLDS Webinar 8-28-14

11. Stakeholder Engagement:Early Findings Grads not attending college earned: • $7,567 one year out • $11,511 three years out Two out of three graduates were earning less than full-time minimum wages Females earned 70 percent of males, three years after high school African Americans earned 30 percent less than white students, three years after high school Grads with 20 or more unexcused absences in their senior year earned up to 55 percent less than those with 5 or fewer 60 percent of grads work in the four lowest paying industries SLDS Webinar 8-28-14

12. Lessons Learned People (the public) think in terms of annual salaries not quarterly earnings, so we sum four consecutive quarters (FY) Matching can be complicated because UI only has SSN and parts of names Some “phantom” records showed up for people with no earnings at all—we exclude them Some employers have multiple work sites all over a state but will report all employees based on the central administration location (it can be difficult to identify work sites for state employees) Some people do have multiple employers in a quarter and we summed all wages from all sources (like the Census and IRS) MOU process SLDS Webinar 8-28-14

13. Linking K12 Education Data to Workforce Kate Shirley Akers, Ph.D. Acting Executive Director Kentucky Center for Education and Workforce Statistics Kate.akers@ky.gov http://kcews.ky.gov SLDS Webinar 8-28-14

14. Linking K12 Education Data to Workforce Idaho Department of Labor SLDS Webinar 8-28-14

15. Partners/Stakeholders State Board of Education (SBOE) • Overseeing body for all public education in Idaho • Recipient of 2012 SLDS grant State Department of Education (SDE) • K12 education in Idaho • 2009 SLDS grant Idaho Department of Labor (IDOL) • Sub-grantee for 2012 SLDS grant Idaho Department of Transportation (DOT) • Shared DMV records to facilitate matching SLDS Webinar 8-28-14

16. Common Goals Make Data Sharing Possible 60 percent goal for postsecondary credentials adopted by the state Lawmakers and public increasingly interested in outcomes data Education and workforce had pre-established common goal of evaluating educational program outcomes DOT statute expressly allows sharing data to help other state agencies SLDS Webinar 8-28-14

17. Need for Matching • Education records have: • Name • Date of birth • Gender • Unique student identifier (EDUID) • No K12 records have SSN • Labor records are all indexed to SSN SLDS Webinar 8-28-14

18. Using DMV Records Records included for all driver’s license and state ID holders DMV records have: • Social Security Number (SSN) • Name: First, Middle, Last, Suffix • Any additional AKAs (multiple names, maiden names) • Date of Birth (DOB) • Gender • Last-record update date SLDS Webinar 8-28-14

19. Issues with DMV Data May not be a good representation of some populations (e.g., urban areas, out-of-state college students) Match Rate 90 percent of wage records matched DMV records 85 percent match rate anticipated when paired with education records SLDS Webinar 8-28-14

20. Name Resolution Engine Probabilistic matching algorithm Developed by SDE with 2009 SLDS grant Score given for each matching criteria met • Set matching thresholds to minimize need for manual intervention A common identifier (LABUID) is assigned to facilitate future data retrieval SLDS Webinar 8-28-14

21. New Unique Identifiers LABXID • Temporary UID assigned for initial record matching • Minimizes transfer of PII LABUID • Permanent UID • Common identifier for P-20W system SLDS Webinar 8-28-14

22. SLDS Webinar 8-28-14

23. Security and Privacy Concerns Limit transfer of personally identifiable information (PII) between silos Partitioned UID system—spread out PII pieces Data remains in control of originating organization Data access and transfer requires pre-approval • Aggregate data used when possible SLDS Webinar 8-28-14

24. Questions We Can Answer Is employment in high school related to college and career readiness? To success in high school? What percentage of high school dropouts are employed? How long does earning a GED take if employed? Is employment status in high school related to employment (time to find a job, wages) after college? SLDS Webinar 8-28-14

25. Data Limitations Workforce data currently limited to those covered under UI tax law No information on hours worked in Idaho No information on occupations Limited information on work location SLDS Webinar 8-28-14

26. Linking K12 Education Data to Workforce Karen Jarboe Singletary Senior Research Analyst Communications & Research Idaho Department of Labor Karen.JarboeSingletary@labor.idaho.gov SLDS Webinar 8-28-14

27. Linking K12 Education Data to Workforce Questions???? SLDS Webinar 8-28-14

28. Linking K12 Education Data to Workforce Contact Info and Resources Requests from State Support Team or SLDS Team Melissa Ford, Melissa.Ford@aemcorp.com Robin Taylor, Robin.Taylor@sst-slds.org Panelists Kate Akers, Kate.akers@ky.gov Karen Jarboe Singletary, Karen.JarboeSingletary@labor.idaho.gov SLDS Webinar 8-28-14