State Fiscal Stabilization Fund Phase I Post Secondary

1. State Fiscal Stabilization FundPhase I Post Secondary Project Manager: Arthur Kenjora IT Programs and Projects Dept.  Arizona Department of Education 1535 West Jefferson Street, Phoenix, AZ 85007 Office: 602.542.3012 E-Mail: Arthur.Kenjora@azed.gov ADE Information Technology Division

2. Overview • Scope • Purpose • SFSF Grant Requirements • Milestones • Implementation Options • Data Elements Supporting Requirements • Business Rule Discussion • Next Steps ADE Information Technology Division

3. Scope: Community Colleges & Universities Maricopa Community Colleges Yavapai College Northland Pioneer College Pima Community College Mohave Community College Arizona Western College  Cochise College Coconino Community College Arizona Western College Central Arizona College               Eastern Arizona College Diné College       ADE Information Technology Division

4. Purpose Results Data …Get the right data, the right way, right away …increased student learning and improved outcomes Continuous Improvement Cycle Action Plan …improve systems, programs, and classroom instruction …use research and shared experience to apply data to real world problems ADE Information Technology Division

5. AZ-SLDS & SFSF Post Secondary ADE Information Technology Division

6. SFSF PS Grant Requirements • Receive & store the following data: • B1-4: The capacity to communicate with higher education data systems  is included in the State's statewide longitudinal system • B1-10: Student -level college readiness test scores are included in the State's statewide longitudinal system • B1-11: Information regarding the extent to which student transition successfully from secondary school to post secondary education, including whether students enroll in remedial coursework are included in the State's statewide longitudinal system • B1-12:Other information determined necessary by business rules to address alignment and adequate preparation for post secondary education  are included in the State's statewide longitudinal system • C11: Of the student who graduate from high school consistent with 34 CFR 200.19(b)(1)(i),the number and percentages who enroll in an Institution of Higher Education (IHE) (as defined in section 101(a) of the Higher Education Act of 1965, as amended (HEA)) within 16 months of receiving a regular high school diploma • C12: Of the student who graduate from high school consistent with 34 CFR 200.19(b)(1)(i), who enroll in the State within 16 months of receiving a regular high school diploma, the number and percentage who complete at least one year's worth of college credit (applicable to a degree) within two years of enrollment in the IHE • D1-1: Enrollment & graduation data from the National Student Clearinghouse (NSC), covering 22 Community Colleges and 3 Arizona State Universities. • D1-2: ACT scores from ACT. Milestones ADE Information Technology Division

7. Data Requirements Breakdown B1-10 B1-11 C11 C12 D1-1 D1-2 ADE Information Technology Division

8. How? Customer Service LevelAgreement Data, Source, and Business Rules Integration Data Transfer Process Data Security and Privacy (i.e. FERPA) ADE Information Technology Division

9. Data Source? OPTION #2 OPTION #1 Option #1:  Each Community College will provide data independently based on system capabilities. Option #2:  ADE will utilize ASSIST (http://www.asu.edu/assist/) system to extract SFSF required data elements.  • Current review shows us 100% of data elements required are available.  11 Community Colleges 10 Maricopa County Community Colleges 3 Universities Maricopa County & Regional Community Colleges Arizona State Universities Data Warehouse ADE Information Technology Division

10. ADE Data Warehouse Student Data Elements for Linkage • Last Name • First Name • Middle Name (optional) • Birth Date • Gender • Ethnicity (optional) • SSN (optional, but obtaining as hidden field will help identify ‘uniqueness’ of students) ADE Information Technology Division

11. ASSIST Data Elements Supporting SFSF Requirements – Decision? Community Colleges • Student Data • Enrollment • Degree • Open Enrollment Universities • Student Data • Enrollment • Degree Workshop Activity: Review ASSIST Data Relevant to SFSF spreadsheet ADE Information Technology Division

12. Data Source! OPTION #2 OPTION #1 Option #1:  Each Community College will provide data independently based on system capabilities. Option #2:  ADE will utilize ASSIST (http://www.asu.edu/assist/) system to extract SFSF required data elements.  • Current review shows us 100% of data elements required are available.  11 Community Colleges 10 Maricopa County Community Colleges 3 Universities Maricopa County & Regional Community Colleges Arizona State Universities Preferred Data Warehouse ADE Information Technology Division

13. Business Rules & Data Definition Exercise ADE Information Technology Division

14. Collaboration Activities High-Level ADE Activities For each of the Sources of Data Elements Define Data Architecture and Technical Architecture to ensure customer adherence Define and Implement Identity Management System Define templates and/or interface requirements for data extract/Transform to support load process Define Requirements necessary to land extracted data in the Data Warehouse Define and Implement method of delivery to customers Build ADE specific Reporting Requirements for each institution Test and Deploy Reporting and Extract Programs Train Users (Reporting/Extract) High-Level Collaboration Activities For each of the 22 Community Colleges & 3 Universities: Data Definition with Community Colleges, Universities and Data Architect, Technical Architect (ADE) Work with ASSIST, Community Colleges and Universities to build (automated) extract scripts based on pre-defined/agreed data elements Manage Districts Extracts Build Customer Reporting Requirements Test and Deploy Reporting and Extract Programs Train Users (Reporting/Extract ,if necessary) ADE Information Technology Division

15. SFSF Post SecondaryShort Term Next Steps • ADE complete Requirements definition by May 20th based on Workshop results and follow-up. • Requirements acceptance by May 25th. • Identify and confirm source data architect & developers availability. • Define Statement of Work • Document assumptions and risks • Baseline project plan prior to Design ADE Information Technology Division

16. Questions ADE Information Technology Division

17. Thank You! Project Manager: Arthur Kenjora IT Programs and Projects Dept.  Arizona Department of Education 1535 West Jefferson Street, Phoenix, AZ 85007 Office: 602.542.3012 E-Mail: Arthur.Kenjora@azed.gov ADE Information Technology Division