AZDash We’ve only just begun

1. AZDashWe’ve only just begun Mark Masterson Amit Soman Dr. Debbie Stirling Arizona Department of Education

2. Agenda • Background on AZDash • The AELAS vision • Technology landscape • State support • Demo • Q&A

3. ADE’s AELAS plan • Save LEAs and ADE time and money by offering statewide procurement of integrated systems • Improve student achievement by providing educators with tools to support instruction and professional development • Link data between systems to create tools to intervene in real time (Education Intelligence)

4. A grim start to a long journey… • Disparate data systems and data sources • Data warehouse built by IT • Limited to only handful of IT users for research and internal reporting • Lack of federated identity management for LEAs • Challenges with data and tech literacy • LEAs not involved in or consulted on state initiatives • No technology standards for reporting and business intelligence • Well deserved lack of legislative support for ADE • Past ADE SLDS 2007 grant prompted scrutiny from Federal government

6. Unified Data Collection

7. ADE IT Core Capabilities DOE Jane 7 Female 1234MAINSTreet AZ 8000 JANE DOE 7 F 1234 E. MAIN STREET AZ 85000 Jane DOE 7 Female 1234 MAIN ST. AZ 00000 Creating a common framework for all applications and systems deployed and developed by the ADE benefits LEAs by ensuring that

8. Data Management Data used at the ADE is currently spread across hundreds of database tables and tens of thousands of columns.

9. Our jump start • Data warehouse built in 2007 had useful data but needed updates • Pilot for single sign-on was already underway • Partnered with Georgia for first 5 dashboards and ‘Georgia tunnel’ • 10-12 LEAs (small, medium, large, charters) willing to pilot • Student-Teacher-Course Connection critical to quick dashboard deployment • Available data to populate dashboards • First time Arizona had standardized data

10. Vision for AZDash • Availability of actionable information for teachers, principals and superintendents from LEAs • Federated identity management • FERPA and secured data availability • Near real-time data • Continuous professional development for users • Availability of information for parents, policy makers, workforce and postsecondary • Data governance

11. Actionable Data Actionable data is one of the most important tools that educators need

12. Actionable Data

13. Shifting focus to student outcomes • Decision to build dashboards for educators • NO statistical tools/representations (scattered plots) used for dashboards • Educator focus groups identified needs and prioritized future dashboards • Decide visualization and priority of release • Professional development became priority

14. Support from the state • Governor and Arizona legislature provided million of dollars for various initiatives • Single sign-on rollout - ADEConnect • AZDash rollout to other districts (not covered under federal grant) • ADE internal data governance • AzEDS student data collections to get near real-time student information from districts • Enterprise architecture

15. Our growth story Stakeholders / Users Domains Data Product AIMS Attendance Student Assessment Superin-tendent Enrollment Attendance Principal Teachers 8 years of data 5 initial dashboard - now 30 10 initial LEAs - Now 297 Enrollment Withdrawal Withdrawal Parents Legislators Data Coaches Account-ability Post Secondary PD growth from 10 to 150 LEAs Multiple Browsers/ Versions Internal and External Dashboards ELL Explore Post Secondary Stanford 10 170K hits/month on external facing site 500+ Concurrent users ELL Demo-graphic PostSecondary Arizona Commerce Authority Teacher Account-ability • 25% of LEAs trained, representing 30% of student population statewide • 50% of trained districts use Beginning of Year (BOY) process to use dashboards for incoming students • 300 LEAs use ADEConnect for role and access management • We implemented Dynamics CRM to manage the rollout • AzEDSStudent and AzEDSAssessment for near real-time data • Growth in hardware (server sizing) to support increasing user population

16. Technology landscape • .NET • SQL Server 2012 • SSIS • Redundancy built into hardware • Performance testing to handle load (Jmeter) • Monitoring • Automation testing (Selenium – in progress) • Threat and penetration testing • Google Analytics • Multiple browser/tablets compatibility

17. Stakeholders are key • Focus groups on monthly basis • Teachers • Principals • Superintendents • Data Governance Conference • Cooperation from regional centers • Arizona Board of Regents to provide post secondary data • Various oversight mechanisms from State • Outreach efforts and meetings with various LEAs

18. The road ahead • Additional dashboards • 40 dashboards on backlog • P20W • BI tools for end users – cube (super user dashboards) • AzEDS • Near real-time data about students and assessment (benchmark/formative) • Better support for data governance at LEA • Single source of educational data with operational data stores • Stakeholder engagement • Webinars and training on data literacy • Course as part of college of education in universities and colleges in the state • Additional focus groups

19. Thank You Mark T Masterson Chief Information Officer (602) 542-3542Mark.Masterson@AZED.gov Follow ADE IT on Facebook and Twitter