25 th Annual MIS Conference February 2012 Kathy Gosa – Information Technology Director

1. Kansas’ Efforts in DevelopingHigh School Feedback Reports Delivering College & Career Readiness Metrics to Kansas LEAs 25th Annual MIS Conference February 2012 Kathy Gosa – Information Technology Director Kelly Holder – Data Analyst Photo(s) are stock photos.

2. Kansas Educational Landscape • 286 school districts • Over 1600 schools – Private & Public • Includes large vs. small; urban vs. rural • Approximately 450,000 K-12 students • 37 Public IHEs; 28 Private & Independent IHEs Photo(s) are stock photos.

3. Background • 2005 – State Identifiers (SSID) were assigned for all PK-12 students • 2006 – Kansas Individual Data on Students (KIDS) student level data collection system was implemented • Assign and track SSIDs as students enter and move throughout the state • Collect and manage core student data (Master Data source for student demographics) Photo(s) are stock photos.

4. Background • 2007 – Kansas funded KSDE’s initial development of the Enterprise Data System (EDS) • included establishing a Data Warehouse with longitudinal, integrated, and time variant data across the PK-12 education enterprise • Through federal grants, KSDE has now expanded the EDS • incorporates postsecondary data • BI reporting solution to provide information back to education stakeholders: System for Education Enterprise in Kansas (SEEK) Photo(s) are stock photos.

5. KSDE Enterprise System Design Longitudinal - Integrated Time Variant - Cleansed Staff & Stakeholder Training & Capacity Building + Data Governance Data Collection & Integration Data Storage Data Use ABE Careers Finance Student Financial Aid NSC Data Labor Data Multi-State SLF Postsecondary Data ID Assignment Collection Private / Independent Institutions KIDS Data Mart P-20 Student IDs Engagement ACT data Collaborative Workspace for Teachers & LEA Admin Data Mart Fed Rpts Data Mart SFSF Student ODS Unified Acct/Planning Early Childhood BI Interfaces: Dashboards, Rpts, HS Feedback Rpt Authenticated & Public Discipline Assessment & Accountability ODS Enterprise Data Warehouse Behavior Extraction & Analysis Data Mart LEA Analysis Assessments Cleanse – Integrate - Transform - Load LEA Districts & Schools Data Mart State Rpts … S u b m I s s I o n a n d V e r I f I c a t I o n Special Ed Migrant Career & Tech Ed : : Budget & Finance … Educator Evaluation Educator ODS Teacher Assignment … Data Mart Research Ed Licensure Data Mart KEDUC Educator Career Pathway Performance & Planning for Teachers, IHEs, LEA Admin, Public Organizations MetaData Definitions, Business Rules, Tech Info, Data Quality Existing In Progress Planned / Grant Common Authentication – Security Architecture & Policies Tool and Process Standardization Enterprise Architecture 12-2011

6. SEEK • Business Intelligence (BI) solution for KSDE’s Enterprise Data System • Delivers district and building level data through an authenticated interface • Provides graphical representation of KPIs across time • Allows filtering for customized view • Technology infrastructure • Windows Server 2008 R2 • SQL Server 2008 R2 DBMS • MS Visual Studio 2008 • SharePoint 2010 Photo(s) are stock photos.

7. Accessing the Data Photo(s) are stock photos.

8. High School Feedback Reports Built as a “by-product” of SFSF metrics C(11) and C(12) Sourced from our PK-20 Data Mart Initial design/content based on research of what other states are doing available data Provided by KSDE and accessed via existing authenticated BI solution Not an annual published report Dynamically generated customizable view based on parameter selection Photo(s) are stock photos.

9. High School Feedback Reports • Purpose - To inform and aid school and district policy and decision makers by providing information about high school graduates, including the number who matriculated to a postsecondary institution, while noting how well they performed compared to their peers from the district and the state as a whole. Photo(s) are stock photos.

10. High School Feedback Dashboards • Parameter selections: • Student Subgroup • ACT Subject Area • Postsecondary Enrollment ACT Scores – shows the average ACT scores by building with comparative values for district, state, and national averages.

11. High School Feedback Dashboards Postsecondary Enrollment Rates – lists the percentage of high school graduates who enrolled in a postsecondary institution by building, grouped by high school graduation year with comparative values for district, state, and national averages. • Parameter selections: • Time Elapsed until Enrollment in Postsecondary • Student Subgroup • Postsecondary Institution Location • Institution Type

12. High School Feedback Dashboards Parameters selections: • High School graduation year Postsecondary Enrollment Locations – lists by relative frequency where high school graduates enroll for postsecondary education, grouped by high school graduation year.

13. High School Feedback Dashboards Postsecondary Retention Metrics – lists the percentage of high school graduates by building who enrolled in a public postsecondary institution in Kansas, grouped by high school graduation year, with comparative values for district and state averages. Parameters selections: • Student Subgroup • High School Graduation Year

14. High School Feedback Dashboards Postsecondary Remedial Coursework – lists the percentage of high school graduates who enrolled in remedial coursework at Kansas public postsecondary institutions. A subsection of this dashboard lists the passing rates for those students enrolled in remedial coursework. • Parameters selection: • Student Subgroup • Time Elapsed until Enrollment in Postsecondary • Remedial Subject Area

15. The Dataset • In Progress • SAT / AP • Potential / Planned • Dept of Labor • Dept of Defense? -KSDE SLDS -Kansas Board of Regents Current • P20 Data Mart • National Student Clearinghouse • ACT

16. To SEEK !!! • Hands on Demonstration https://svapp15586.ksde.org/authentication/login.aspx Photo(s) are stock photos.

17. Potential Enhancements • Acquisition and Inclusion of SAT/AP data • Acquisition and Inclusion of Department of Labor (DOL) data • Inclusion of High School Course data • Construction of Cross Indicator/Predictive Analytics • Inclusion of Postsecondary Completion Metrics • Acquisition and Inclusion of Advanced Placement data • Acquisition and Inclusion of Department of Defense (DOD) data 17 Photo(s) are stock photos.

18. Questions ? Photo(s) are stock photos.