S tudent T eacher A ccountability R eporting S ystem 10/27/08

1. Student Teacher Accountability Reporting System 10/27/08

2. Data Terms • ADS • UniqID • eDM – eScholar Data Manager • eScholar • Cognos • AYP – • SOAP – Student Online Assessment Prep • CSPR – Consolidated State Performance Report • SEB • OSEP Indicators – Office of Special Education Programs • IDEA – Individuals with Disabilities Education Improvement Act (2004) • HQT – Highly Qualified Teachers • EDEN/EdFacts • ECS – Education Commission of the States • OLAP – On-Line Analytical Processing

3. WHY STARS . . . • ADS (Accountability Data System) was State’s education data and reporting system • ADS designed in 1995, piloted in 1997 • ADS addressed educational data reporting requirements circa 1995 • Federal and State requirements significantly evolved • 2001 No Child Left Behind (NCLB) Act • A series of independent audits were conducted on ADS: • 2001: LFC, Audit of Data Used in Accountability Program • 2003: LFC, Audit of Special Education • 2004: LFC, Audit of Bilingual Education Program • 2003-04: ECS, Study on Federal Requirements Compliance • 2004: CCSSO, Accountability & Indicators Report • These audit findings prompted several detailed evaluations: • 2004: CCSSO/DSAC, Case Study of New Mexico • 2004: LFC/LESC/OEA/PED, Joint Needs Assessment

4. What the Audits and Reports found . . . • The system was “broken”, data was suspect • PED needed new system for State & Federal reporting req’ts • Address LFC data audit requirements • PED needed to change how it did business: One-Way Data Flow School Budget controlled IT system “Accounting” system was for SEG Program bureaus did not focus on data District data was not certified System could not address NCLB reporting req’ts Internal Business Processes required Reengineering

5. What is STARS • STARS is New Mexico’s Statewide Longitudinal Data System (SLDS) – we collect, review, correct, and report required education data • Districts and PED Program Bureaus review & use data • Data Warehouse: > 4.2 M student records > 5.8M program enrollments > 1M student assessment records > 5.8M special education records > 9.8 course enrollments > 440K staff assignment records • NMSBA Data – 3 Years • STARS & ECS

6. Key Elements of the STARS Include: Key Elements of theApplication Model Include: • Complete K-12 Data Model • Unique Student, Staff, Course, and Location IDs • Extract, Transform, and Load Tools • Data Load Programs for Specific Data Elements • Data Validation Tools • Decision Support Tools for K-12 Reporting • Education Interface Portal for User Access

7. Today, New Mexico can, and other states cannot . . . • Calculate and Report HQT • Determine and Report OSEP Indicators • Develop and Report the State’s CSPR • Submit all federally required data through EDEN / EDFacts Districts can now: • Review their data prior, during, and after submissions • Submit state and federal required data into a single data warehouse • Tie student to staff to financial data to begin using the data to improve student and staff performance

8. STARS achievements are . . . Reporting • Over 1,000 reports • 12 OLAP Cubes (ad-hoc reporting) have been developed • Trend analysis reports on NMSBA data • Over 1600 users have accessed STARS reporting since 1/06 • EDEN/EDFacts reports are automated through warehouse Training • Over 1000 educators have registered for past three data conferences • Over 100 Principals have been trained • PED staff currently develop > 80% of new STARS reports • Centralized and Geographically-placed trainings

9. Most importantly . . . Data Quality Has Improved: • 50,000 errors identified during the Assessment bio-grid review in 2007 resulting in 5,000 errors that could not be reconciled. • In 2008, 2000 errors were identified; all were fixed. • Over 45,000 students receive Special Ed Services in New Mexico with 131 data elements per student - or - a total of 7.8 million potential errors. Only 332 errors were found last school year, translating to a data accuracy rate of 99.996% for Special Ed data. • Similar statistics are being developed for other data sets. Improved Business Rules & Processes: • School Budget, Special Education, Teacher Quality, Bilingual & Title 1 Bureaus review data weekly at each reporting period of 40th, 12/1, 80th, 120th, and EOY data. • Validation reports have been developed for bureaus • Special Ed data is now being fully reported to USDE through STARS

10. So now we have STARS to help us . . . • Follow Students’ academic progress from grade to grade • Determine effectiveness of specific schools’ and programs • Identify consistently higher-performing schools to learn from best practices • Evaluate the effect of teacher preparation & training programs on student achievement • Focus school systems on preparing more students for success in rigorous high school courses, college & challenging jobs

11. What do you need to know about STARS. • You must report district/school data at 40, 80, Dec 1, NMSBA,EOY dates • You must report your initial data no later than 5 business days after each districts’ related calendar date • State / Federal statutes/laws/rules • Funding implications / Audit implications • Compliance

12. What Data is Required? • We uses 23 templates to submit data. • A template is the electronic means to submit data from your Source System (SIS) into STARS • You must extract your data into template format and submit data into STARS