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
DATA-WAREHOUSING MODEL A Do-It-Yourself Guide
Alex Kolker, Quad Cities Campaign for Grade-Level Reading
2
February 25, 2019
2
Data Warehouse Model
Quad Cities Data Warehouse Model
3
February 25, 2019
3
Data Warehouse Model
Quad Cities Data Warehouse Model
4
February 25, 2019
4
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.”
5
February 25, 2019
5
High School Graduation Reading by 3rd Grade
60% 90%
Research Framework and Methodology
6
February 25, 2019
6
High School Graduation Reading by 3rd Grade
60% 90%
Research Framework and Methodology
Billy Billy
7
February 25, 2019
7
The Family Educational Rights and Privacy Act
“FERPA allows schools to disclose those records, without consent, to the following parties….
Research Framework and Methodology
8
February 25, 2019
8
Research Framework and Methodology
9
February 25, 2019
9
Research Framework
Research Framework and Methodology
10
February 25, 2019
10
Research Framework
Research Framework and Methodology
11
February 25, 2019
11
Data Warehouse Model
Quad Cities Data Warehouse Model
12
February 25, 2019
12
Data Warehouse Model
Quad Cities Data Warehouse Model
13
February 25, 2019
13
Partnership Structure
14
February 25, 2019
14
Partnership Structure Community Service In-Kind Donation Neutral Party Academic Expertise
15
Any Questions?
16
February 25, 2019
16
Data Warehouse Model
Quad Cities Data Warehouse Model
17
February 25, 2019
17
Data Warehouse Model
Quad Cities Data Warehouse Model
18
February 25, 2019
18
Data-Sharing Agreements
19
February 25, 2019
19
Data-Sharing Agreements
Districts Partners HHS Partners
20
February 25, 2019
20
Data-Sharing Agreements
Districts Partners BBBS Partners
21
February 25, 2019
21
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”
22
February 25, 2019
22
Data Warehouse Model
Quad Cities Data Warehouse Model
23
February 25, 2019
23
Data Warehouse Model
Quad Cities Data Warehouse Model
24
February 25, 2019
24
Software Configuration
Upload Data Standardize Data Store and Secure Data Process 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”
25
February 25, 2019
25
Software Configuration
Upload Data Standardize Data Store and Secure Data Process Data
26
February 25, 2019
26
Software Configuration
27
February 25, 2019
27
Software Configuration
Data A Data B Data C YEAR 1 Data A Data B Data C YEAR 2 Data A Data B Data C YEAR 3 Data A Data B Data C YEAR 4
28
February 25, 2019
28
Software Configuration
Data A Data B Data C
YEAR 1 Data A Data B Data C YEAR 2 Data A Data B Data C YEAR 3
29
February 25, 2019
29
Software Configuration
Upload Data Standardize Data Store and Secure Data Process Data
30
February 25, 2019
30
Software Configuration
31
February 25, 2019
31
Software Configuration
COSTS
Year One Annual Costs
SQL Mapping $1,330 $630 Software Subscription $630 $0
32
Any Questions?
33
February 25, 2019
33
Data Warehouse Model
Quad Cities Data Warehouse Model
34
February 25, 2019
34
Data Warehouse Model
Quad Cities Data Warehouse Model
35
February 25, 2019
35
Data Warehouse Capabilities
High School Graduation High School Credit Accrual Middle School Attendance Reading by 3rd Grade Ready for Kindergarten
36
February 25, 2019
36
Data Warehouse Capabilities
37
February 25, 2019
37
Data Warehouse Capabilities
38
February 25, 2019
38
Data Warehouse Capabilities
0% 10% 20% 30% 40% 50% 60% 70% 80%
Ready Not Ready Non-Proficient Proficient
70% 35% Students who were not ready when entering kindergarten are twice as likely to be reading below proficient in 3rd grade.
39
February 25, 2019
39
The Big Picture
MATHEMATICS AHEAD
40
February 25, 2019
40
Data Warehouse Capabilities
Correlationsa (Class of 2017) Absences 6th Grade Absences 7th Grade Absences 8th Grade Absences 6th Grade Pearson Correlation 1 .653** .577**
.000 .000 Absences 7th Grade Pearson Correlation 1 .647**
.000 Absences 8th Grade Pearson Correlation 1
**. Correlation is significant at the 0.01 level (2-tailed).
1
No Correlation 100% Positive Correlation 100% Negative Correlation
41
February 25, 2019
41
Data Warehouse Capabilities
High School Graduation High School Credit Accrual Middle School Attendance Reading by 3rd Grade Ready for Kindergarten
0.424 0.210 0.756
42
February 25, 2019
42
Data Warehouse Capabilities
Reading by 3rd Grade
Control
0.756
0.791
Prog A
0.302
Prog B
0.707 High School Graduation
43
February 25, 2019
43
Data Warehouse Capabilities
Reading by 3rd Grade
Females
0.756
0.083
Prog A
0.302
Males
0.514 High School Graduation
44
February 25, 2019
44
The Big Picture
45
February 25, 2019
45
The Big Picture
* Source: Hernandez, Donald J, 2011
Non-proficient Hispanic readers are nearly 3x more likely to drop out of school.
46
February 25, 2019
46
The Big Picture Non-proficient Hispanic readers are nearly 3x more likely to drop out of school.
78%
22%
NATIVE BORN FOREIGN BORN
47
February 25, 2019
47
The Big Picture
48
Any Questions?
49
February 25, 2019
49
To Learn More: Alex Kolker
United Way of the Quad Cities akolker@unitedwayqc.org (563) 344 - 0339