Transcript From the Data Pipeline to Date Use

“Measuring High School
Graduation and Dropout Rates”
Community Service
Council
John Kraman and
Duane Brown
December 12, 2013
The Mission of the Office of
Student Information
1. 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.
2. To support local data use by teachers,
school leaders and school partners in
order to improve student outcomes.
2
Student Information System
Framework
Data
Pipeline
Data
Quality
Data
Use
Data
Support
CSC Discussion Topics
1. Wave Student Information System
2. Dropout Rate
3. Cohort Graduation Rate
4. Data Use Tools
5. Support and Intervention
6. Community Partnerships
4
Progress over Time
• Past
• Present
• Future
–Plans
–Challenges
5
Putting the Pieces Together
Data
Pipeline
The “Wave”
and How It Works
7
The Wave and How It Works
`
District Application
(e.g., Local Student
Information System)
District
Staff
<0999>
<0999>
<Asian> = <0999>
<0999> = <04>
<04>
<Asian>
<Asian>
`
jfidosanfidoanfido
anioafnidoanfidoa
nfodianfoidanfodia
nfodianfoasinfoain
foidnaoifndosaifnd
oaifndoaifndoasifn
doaifndasoif
Zone
Integration
Server
Vendor SIF
Agent
x
<04>
`
jfidosanfidoanfido
anioafnidoanfidoa
nfodianfoidanfodia
nfodianfoasinfoain
foidnaoifndosaifnd
oaifndoaifndoasifn
doaifndasoif
8
The Wave Collection
1. Address
2. Attendance Code Info
3. Calendar Date
4. Calendar Summary
5. Demographics
6. Discipline Incident
7. LEA Info
8. Room Info
9. School Course Info
10. School Info
11. Section Info
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
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
9
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
10
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
11
“Health” of the Data Pipeline
Districts Reporting Early Warning System Data Objects
(June 2013)
4.5% 0.2%
12.4%
All 14 EWIS Objects
Missing 1 Object
Missing 2-5 Objects
Missing All Objects
83.0%
12
Data
Quality
Addressing Data Quality
13
Addressing Data Quality
Data Entry
Data Transmission
Data Validation
Data Certification
14
“Wizards” and Validation
STN
Data
Validation
Validation
Wizards
Ownership
XSD
15
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
16
Data
Quality
Addressing Data Quality:
Drop Out Rate and
Cohort Graduation Rate
17
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
18
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
19
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
20
Dropout Rate
School District
Reporting Site
The Wave’s
Portal
• Prepopulated – Less Data Entry/Cleaner Data
• Assistance in finding Dropouts
21
Dropout Rate
22
Dropout Rate
23
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).
24
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
25
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:
26
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:
27
Cohort Graduation Rate
FY2013 October
1 Consolidated
Report
+
FY2013 SMART
Report
Comprehensive
Exit Report
+
Dropout Report
28
Cohort Graduation Rate
Graduation
Cohort
29
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
30
Cohort Graduation Rate
FY2012 – 8th
Grade
FY2012 – 8th
Grade
FY2011
8th Grade
+
+
FY2013 – 9th
Grade
+
FY2013 – 8th
Grade
FY2012
9th Grade
+
FY2013
9th Grade
=
FY2016
=
Not Yet
Determined
=
FY2015
31
Data
Use
Providing teachers, school leaders and
school partners with timely, high
quality, relevant and actionable data
32
Data Use Projects
FUTURE:
PRESENT:
PAST:
MyDATA,
EWI, Direct
Certification
ACE
Cumulative,
Ed-Fi Pilot,
Dropout
Report, Direct
Certification
ACE
Cumulative
Expanded,
Ed-Fi
Statewide,
Dropout
Report
expanded,
Direct
Certification
expansion
33
Data Use Tools - MyDATA
34
Data Use Tools - MyDATA
35
Data Use Tools - EWI
36
Data Use Tools - EWI
37
Data Use Tools:
ACE Cumulative
1. HS Course Grades and Credits
2. State EOI Assessment Results
3. Alternative Assessment Results
(ACT, SAT, Out of State, etc.)
4. EOI Alternative Projects
5. Financial Literacy
38
Ed-Fi Pilot Districts
1.
2.
3.
4.
5.
6.
7.
8.
Durant PS
El Reno PS
Norman PS
Oklahoma City PS
Prague PS
Putnam City PS
Tulsa PS
Union PS (TBD)
39
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
40
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
41
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
42
Comprehensive snapshots:
Districts, Schools and Students
Comprehensive snapshots:
Districts, Schools and Students
Data Use Tools
45
Data Use Tools
46
Data Use Tools
47
48
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
49
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
50
Data
Support
Support and Intervention
51
Oklahoma Tiered Intervention
System of Support (OTISS)
• OTISS, the Oklahoma Tiered Intervention System of
Support, is Oklahoma’s intervention model for
identifying and addressing academic and behavioral
difficulties that interfere with Pre-K-12 student
success.
• Karie Crews-St.Yves, Tiered Intervention Specialist,
Christa Knight, SPDG Project Director, and LaDonna
Shirley, Administrative Assistant. For more
information about OTISS, please contact LaDonna
Shirley by telephone at (405) 522-1461.
52
Putting the Pieces Together
Training
Roadmap
Data
Resources
53
Community Partnerships
Data
Pipeline
Data
Quality
Data
Use
Data
Support
Community Partnerships – School
Partner Data Tool
55
Ed-Fi Pilot Districts with
Local Partner Organizations
• Durant PS
• The Choctaw Nation
• Oklahoma City PS
• Community Partners (TBD)
• Putnam City PS
• Francis Tuttle Tech Center
• Tulsa PS & Union PS (TBD)
• CSC and the Schusterman Foundation
56
SDE Office of Student Information
John Kraman
Executive Director
[email protected]
Duane Brown
Data Coordinator
[email protected]