Arizona Education Data Warehouse Transforming Longitudinal Data Into Information and Insight

1. Arizona Education Data WarehouseTransforming Longitudinal Data Into Information and Insight November 18th, 2009 AASBO Arizona Association of School Business Officials Donald J. Houde Chief Information Officer Deputy Associate Superintendent Arizona Department of Education

2. AEDW Primary Objectives 1 Assurance Support 2 Critical Components 3 Key Near Term Milestones 4 Key Stakeholders & SLDS Grant 5

3. Primary Objectives Track critical aspects of public education longitudinally. Provide data and tools for exploration and analysis of Arizona public education. Standardize and unify source of reported information.

4. Equity of Effective Teachers Standards & Assessments Struggling Schools Data Systems Assurance Support • Agility • Include varied localized and statewide assessments. • ECAP includes RTI support • SLDS Platform • Enhancement and expansion of AEDW • Monitoring & Improvement Planning • Integrates monitoring and school improvement planning, measuring and planning tools. ASIP, ALEAT, OELAS • EduAccess & EduID • EduAccess and AEDW statewide AP course availability. • Statewide teacher student connection. • College of Ed Coordination • RTI Inclusion

5. Critical Components Data Quality Audit System (Completeness, Accuracy, Consistency, Validity, Integrity, Security, Timeliness, Accessibility) Data & IT Governance Policies, Procedures and Best Practices (Leadership, Data Quality, Controlled Usage/Accessibility & Analysis, Security & Confidentiality, Resource Management) Formalized Business Requirements Generation Processes Quality Assurance Organization (Process and systems quality assurance) Usage & Event Auditing/Logging Management Subsystem Robust Architectures (Physical & Logical, Extensible, Dynamic & Agile, Scalable, Sustainable, Data Descriptors (metadata)) Security Subsystems & Processes (Assure Privacy, Confidentiality & Authorized Access, Logical, Physical, Infrastructure) Operations Organization (ITIL focused, Hardened Data Center, Sustainable, High Availability, Adaptable & Agile) Credible Authoritative Data Sources (Bi-Directional Data Balancing Processes, Define/Audit/Update Linkages and Processes) Data Archival & Retention Requirements, Architectures, & Methods Management and Oversight Organization (Stakeholder Outreach & Inclusion, Change Review Board, Audit Review Team, Configuration Management Board)

6. Key Stakeholders

7. Key Stakeholders

8. School Student Other Teacher Milestones • Segment 3 • Certification • Employment • Qualifications • Student • Connection • College of Ed • Workforce • Etc. • Segment 1 • Membership • Needs • Program Participation • AIMS & ELL Assessments • Attendance • Absence • FTE • DOR/DOA • Special Enrollment • Post Sec Readiness Test Scores • Course Completion • Etc. • Segment 2 • School • District • County • Hierarchical • Relationships • LEA types • Geocoded Data • Calendars • Finance • Performance • Measures & • Indicators • EDEN/EDFACT • Etc. • Segment 4 • Adult Ed • School Safety • Disciplinary • Career Tech Ed • ECAP • RTI • AYP/AZLEARN • ESS • Free Reduced • Lunch • Etc.

9. Next Steps B-20 Linkages Expanded Interoperability with Inter and Intra-State LEAs Critical Components Teacher Student Link Educator Preparation and Certification Data Data Informed Decision Making Capabilities (Students, Parents, Teachers, Administration, Policy Makers, etc.) Data Quality Audits Student Level Post Secondary Readiness Test Scores Student Level Transcript Information Student Level Post Secondary Remediation Post Secondary Success Measures (Career, University, Community Colleges, etc.) Education Career Action Plan (ECAP)

10. Next Steps Student Environmental Attribute Data Collection (School Safety & Disciplinary Data, Home Broadband, Home Language Spoken.) Native American Education Data Interoperability Critical Components EduAccess Expansion Secure Care Data Collection

11. SLDS Grant Additional Elements • Enhancement of Data Collection Systems including the Rewrite of SAIS and The Implementation of A Voluntary Subscription Based LEA Level Student Information System. • Statewide Automation of the ECAP System • Enhanced Statewide School Safety and Discipline System • Continued Addition of AEDW Data Delivery Tools • Statewide Data Quality Certification System • Expand EduAccess to Make Services Available to LEA • Statewide Student Assessment Delivery Tools • Due December 4th, 2009 • $250 Million Available with $10 Million Average Award for 3 Years • Application Requires Completion of Eleven Sections • Reviewers Will Access: • Substantial Need For the Project • Clarity of Goals, Appropriate/Measurable Objectives • High-Quality, Logical and Feasible Activities & Timeline • Effective Management and Governance Plan • Personnel and Financial Resources • Additionally, Performance and Use of Funds Under Previous $6M Grant will be a consideration.

12. Thank You! Donald J. Houde Chief Information Officer Deputy Associate Superintendent Arizona Department of Education Donald.Houde@AZED.gov 602.364.1368