DATA-WAREHOUSING MODEL A Do-It-Yourself Guide Alex Kolker, Quad - PowerPoint PPT Presentation

DATA-WAREHOUSING MODEL A Do-It-Yourself Guide Alex Kolker, Quad Cities Campaign for Grade-Level Reading

Data Warehouse Model Quad Cities Data Warehouse Model 1. Research Framework and Methodology 2. Partnership Structure 3. Data-Sharing Agreements 4. Software Configuration 5. Data Warehouse Capabilities 2 2 February 25, 2019

Data Warehouse Model Quad Cities Data Warehouse Model 1. Research Framework and Methodology 3 3 February 25, 2019

Research Framework and Methodology “Results of a longitudinal study of nearly 4,000 students find that those who do not read proficiently by third grade are four times more likely to leave school without a diploma than proficient readers.” -- Double Jeopardy, 2012 4 4 February 25, 2019

Research Framework and Methodology 60% Reading by 3 rd Grade 90% High School Graduation 5 5 February 25, 2019

Research Framework and Methodology 60% Reading by 3 rd Grade Billy Billy 90% High School Graduation 6 6 February 25, 2019

Research Framework and Methodology The Family Educational Rights and Privacy Act “FERPA allows schools to disclose those records, without consent, to the following parties…. • Organizations conducting certain studies for or on behalf of the school.” 7 7 February 25, 2019

Research Framework and Methodology 8 8 February 25, 2019

Research Framework and Methodology Research Framework 1. Predictive models 2. Comparison of subpopulations a. Demographic b. Geographic c. Socioeconomic 9 9 February 25, 2019

Research Framework and Methodology Research Framework 1. Predictive models 2. Comparison of subpopulations a. Demographic b. Geographic 3. Testing of interventions 10 10 February 25, 2019

Data Warehouse Model Quad Cities Data Warehouse Model 1. Research Framework and Methodology 2. Partnership Structure 3. Data-Sharing Agreements 4. Software Configuration 5. Data Warehouse Capabilities 11 11 February 25, 2019

Data Warehouse Model Quad Cities Data Warehouse Model 1. Research Framework and Methodology 2. Partnership Structure 12 12 February 25, 2019

Partnership Structure 13 13 February 25, 2019

Partnership Structure  Community Service  In-Kind Donation  Neutral Party  Academic Expertise • Professor of Education • Data Analyst • Professor of Statistics 14 14 February 25, 2019

Any Questions? 15

Data Warehouse Model Quad Cities Data Warehouse Model 1. Research Framework and Methodology 2. Partnership Structure 3. Data-Sharing Agreements 4. Software Configuration 5. Data Warehouse Capabilities 16 16 February 25, 2019

Data Warehouse Model Quad Cities Data Warehouse Model 1. Research Framework and Methodology 2. Partnership Structure 3. Data-Sharing Agreements 17 17 February 25, 2019

Data-Sharing Agreements 18 18 February 25, 2019

Data-Sharing Agreements SOPO Districts Partners Partners HHS 19 19 February 25, 2019

Data-Sharing Agreements SOPO BBBS Partners Districts Partners 20 20 February 25, 2019

Data-Sharing Agreements Standards of Practice and Operation Provision 8: “Procedures for Data Uploads” Provision 9: “Provisions for Data Storage” Provision 10: “Procedures for Data Draw - Downs” Provision 11: “Provisions and Procedures for Release of Data Findings” 21 21 February 25, 2019

Data Warehouse Model Quad Cities Data Warehouse Model 1. Research Framework and Methodology 2. Partnership Structure 3. Data-Sharing Agreements 4. Software Configuration 5. Data Warehouse Capabilities 22 22 February 25, 2019

Data Warehouse Model Quad Cities Data Warehouse Model 1. Research Framework and Methodology 2. Partnership Structure 3. Data-Sharing Agreements 4. Software Configuration 23 23 February 25, 2019

Software Configuration Store and Standardize Process Upload Secure Data Data Data Data Provision 8: “Procedures for Data Uploads” √ √ Provision 9: “Provisions for Data Storage” √ Provision 10: “Procedures for Data Draw - Downs” Provision 11: “Provisions and Procedures for Release of Data Findings” 24 24 February 25, 2019

Software Configuration Store and Standardize Process Upload Secure Data Data Data Data 25 25 February 25, 2019

Software Configuration 26 26 February 25, 2019

Software Configuration YEAR 1 Data A Data B Data C YEAR 2 Data A Data B Data C YEAR 3 Data B Data C Data A YEAR 4 Data B Data C Data A 27 27 February 25, 2019

Software Configuration SQL YEAR 1 Data B Data C Data A YEAR 2 Data B Data C Data A YEAR 3 Data A Data B Data C 28 28 February 25, 2019

Software Configuration Store and Standardize Process Upload Secure Data Data Data Data 29 29 February 25, 2019

Software Configuration 30 30 February 25, 2019

Software Configuration COSTS Year One Annual Costs SQL Mapping $0 $1,330 Software Subscription $630 $630 31 31 February 25, 2019

Any Questions? 32

Data Warehouse Model Quad Cities Data Warehouse Model 1. Research Framework and Methodology 2. Partnership Structure 3. Data-Sharing Agreements 4. Software Configuration 5. Data Warehouse Capabilities 33 33 February 25, 2019

Data Warehouse Model Quad Cities Data Warehouse Model 1. Research Framework and Methodology 2. Partnership Structure 3. Data-Sharing Agreements 4. Software Configuration 5. Data Warehouse Capabilities 34 34 February 25, 2019

Data Warehouse Capabilities Ready for Kindergarten Reading by 3 rd Grade Middle School Attendance High School Credit Accrual High School Graduation 35 35 February 25, 2019

Data Warehouse Capabilities 36 36 February 25, 2019

Data Warehouse Capabilities 37 37 February 25, 2019

Data Warehouse Capabilities 70% Not Ready Non-Proficient Proficient 35% Ready 0% 10% 20% 30% 40% 50% 60% 70% 80% Students who were not ready when entering kindergarten are twice as likely to be reading below proficient in 3 rd grade. 38 38 February 25, 2019

The Big Picture WARNING MATHEMATICS AHEAD 39 39 February 25, 2019

Data Warehouse Capabilities Correlations a (Class of 2017) Absences 7 th Absences 8 th Absences 6th Grade Grade Grade Absences 6 th Grade .653 ** .577 ** Pearson 1 Correlation Sig. (2-tailed) .000 .000 Absences 7 th Grade .647 ** Pearson 1 Correlation Sig. (2-tailed) .000 Absences 8 th Grade Pearson 1 100% Negative 100% Positive Correlation Correlation No Correlation Correlation Sig. (2-tailed) **. Correlation is significant at the 0.01 level (2-tailed). -1 0 1 a. Listwise N=1529 40 February 25, 2019 40

Data Warehouse Capabilities Ready for Kindergarten Reading by 3 rd Grade 0.756 Middle School Attendance 0.210 High School Credit Accrual 0.424 High School Graduation 41 41 February 25, 2019

Data Warehouse Capabilities Reading by 3 rd Grade Prog A Prog B Control 0.756 0.302 0.707 0.791 High School Graduation 42 42 February 25, 2019

Data Warehouse Capabilities Reading by 3 rd Grade Prog A Males Females 0.756 0.302 0.514 0.083 High School Graduation 43 43 February 25, 2019

The Big Picture 44 44 February 25, 2019

The Big Picture Non-proficient Hispanic readers are nearly 3x more likely to drop out of school. * Source: Hernandez, Donald J, 2011 45 45 February 25, 2019

The Big Picture Non-proficient 22% Hispanic readers FOREIGN BORN are nearly 3x 78% more likely to drop out of NATIVE BORN school. 46 46 February 25, 2019

The Big Picture 47 47 February 25, 2019

Any Questions? 48

To Learn More: Alex Kolker United Way of the Quad Cities akolker@unitedwayqc.org (563) 344 - 0339 49 49 February 25, 2019

THANK YOU