“Measuring High School Graduation and Dropout Rates”

1. “Measuring High School Graduation and Dropout Rates” Community Service CouncilJohn Kraman and Duane Brown December 12, 2013

2. The Mission of the Office of Student Information • To strengthen the State Student Information System in order to provide teachers, school leaders and school partners with timely, high quality, relevant and actionable data. • To support local data use by teachers, school leaders and school partners in order to improve student outcomes.

3. Student Information System Framework

4. CSC Discussion Topics • Wave Student Information System • Dropout Rate • Cohort Graduation Rate • Data Use Tools • Support and Intervention • Community Partnerships

5. Progress over Time • Past • Present • Future • Plans • Challenges

6. Putting the Pieces Together Progress over Time CSC Discussion Topics OSDE SIS Framework

7. Data Pipeline The “Wave” and How It Works

8. The Wave and How It Works District Application (e.g., Local Student Information System) Zone Integration Server District Staff Vendor SIF Agent <0999> <0999> <Asian> = <0999> <0999> = <04> <04> <Asian> x <Asian> <04>

9. The Wave Collection • Staff Assignment • Staff Personal • Student Academic Record • Student Attendance Summary • Student Contact • Student Daily Attendance • Student Personal • Student School Enrollment • Student Section Enrollment • Student Section Marks • Term Info http://ok.gov/sde/wave-system Address Attendance Code Info Calendar Date Calendar Summary Demographics Discipline Incident LEA Info Room Info School Course Info School Info Section Info

10. Assessments: the Other Wave Data • State Test Results (e.g., 3-8 OCCT and EOI) • College Admissions Test Results • Other College and Career Ready Test Results • Interim/Benchmark Assessments ??? • Early Literacy / Kindergarten Assessments ??? • …more to come on the additional data

11. 2012 Data Pipeline Survey Districts need from the OSDE: • More transparency and engagement • Better communication: • Adequate advanced notice • Fewer last minute changes • Better processes and documentation • Better prioritization and better pacing • Clearer roles and responsibilities

12. “Health” of the Data Pipeline

13. Data Quality Addressing Data Quality

14. Addressing Data Quality

15. “Wizards” and Validation

16. Data Certification Projects* • Spring 2013 Data Certification Projects • 2013 A-F Report Card • Fall 2013 Data Certification Projects • October 1 Consolidated Report • Comprehensive Exit Report • Spring 2014 Data Certification Projects * …with the help of the SDE’s District Accountability Data Workgroup

17. Data Quality Addressing Data Quality:Drop Out Rate andCohort Graduation Rate

18. Drop Out Rate: The Past • Entered by school districts • The ability to locate students limited • Duplicate dropouts in the system in the same year and over multiple years

19. Drop Out Rate: The Present • Drop out pre-populated – districts able to find reentered dropouts across the state • The ability to remove duplicate dropouts in the same year across districts and only count the student once as a dropout in a four year period for the cohort • Only the last school accountable in the graduation rate

20. Drop Out Rate: The Future • Better reporting • Possible links with other states to assist in finding dropouts • Possible links with Higher Ed to see if/when how dropouts fare

21. Dropout Rate School District Reporting Site The Wave’s Portal • Prepopulated – Less Data Entry/Cleaner Data • Assistance in finding Dropouts

22. Dropout Rate

23. Dropout Rate

24. Cohort Graduation Rate • The five-year implementation plan will cover the graduation cohorts of 2012 (entering 9th graders in 2008-09) through 2016 (entering 9th graders in 2012-13).

25. Old Graduation Rate(pre-2012) 2010-11 graduates (aggregate counts) 2010-11 graduates (aggregate counts) + 12th grade dropouts (2010-11) + 11th grade dropouts (2009-10) + 10th grade dropouts (2008-09) + 9th grade dropouts (2007-08) + other completers

26. Cohort Graduation Rate: 2008-2012 Cohort • Using student-level data to calculate a Four-Year Adjusted Cohort Graduation Rate for the graduating class of 2012:

27. Cohort Graduation Rate: 2012-2016 Cohort • Using student-level data to calculate a Four-Year Adjusted Cohort Graduation Rate for the graduating class of 2016: 2016:

28. Cohort Graduation Rate FY2013 October 1 Consolidated Report + Comprehensive Exit Report FY2013 SMART Report + Dropout Report

29. Cohort Graduation Rate Graduation Cohort

30. Cohort Graduation Rate • Graduated • Exited to another Diploma Issuing School • Dropped Out • Emigrated • Died • Exited to a Non-Diploma Issuing School • Exited to Homeschooling • Exited – Received their GED • Exited – Reached the Maximum Age for Services • Exited – Suspension • Exited – Completed IEP, but did not receive a diploma • Finished Out the Year – Returned next fall (same school) • Exited – Over Compulsory Age • Permanently Incapacitated

31. Cohort Graduation Rate FY2012 – 8th Grade FY2013 – 9th Grade FY2016 + = FY2012 – 8th Grade FY2013 – 8th Grade Not Yet Determined + = FY2013 9th Grade FY2011 8th Grade FY2012 9th Grade FY2015 + + =

32. Data Use Providing teachers, school leaders and school partners with timely, high quality, relevant and actionable data

33. Data Use Projects

34. Data Use Tools - MyDATA

35. Data Use Tools - MyDATA

36. Data Use Tools - EWI

37. Data Use Tools - EWI

38. Data Use Tools:ACE Cumulative • HS Course Grades and Credits • State EOI Assessment Results • Alternative Assessment Results (ACT, SAT, Out of State, etc.) • EOI Alternative Projects • Financial Literacy

39. Ed-Fi Pilot Districts • Durant PS • El Reno PS • Norman PS • Oklahoma City PS • Prague PS • Putnam City PS • Tulsa PS • Union PS (TBD)

40. Phase 1 & 2 Dashboards Dashboards • Overview Information • Academic Overview • Attendance/Discipline • State Assessments • Local Assessments • Grades and Credits • Advanced Academics • College/Career Ready Levels/Views • District Information • Campus Information • Classroom Information • Student Information • Trend Data • District-Set Targets • Data Export • Multi-Directional Links

41. Phase 3 & 4 Dashboards • ACE Graduation Requirements Dashboard • A-F Report Dashboard • Assessment Standards Aggregate View • Early Warning System Dashboard • State Level Dashboards • P-20 Dashboards • ACT and SAT College Questionnaire • Tribe Breakout

42. Community Partner Dashboards Dashboards • Overview Information • Partner Dashboard: District Level • Partner Dashboard: Campus Level • Partner Dashboard: Student Level Additional Information • Program Eligibility • Program Participation Phase 3 & 4 • “Dosage” Information • Student Performance

43. Comprehensive snapshots: Districts, Schools and Students

44. Comprehensive snapshots: Districts, Schools and Students

45. Data Use Tools

46. Data Use Tools

47. Data Use Tools

49. Oklahoma Ed-Fi Pilot Next Steps • Statement of Work and Development • Dashboard Development • Additional Requirements Gathering • Federated Access Requirements • Implementation / Community of Practice • Governance Decision-Making • Implementation

50. Data Use Workgroup / Ed-Fi Pilot Timeline • Launched in July 2013 • Requirements Gathering through October 1st • Phase I Goal is to develop initial dashboards for the five Ed-Fi pilots by early 2014 • Phase II and beyond: additional data, new and dashboards new local pilots • Expand to other districts based on demand in 2014-15, available statewide in 2015-16