Transcript Connecting People and Place: Improving Communities through

Connecting People and Place: Improving
Communities through Integrated Data Systems
Public School Absenteeism in Pittsburgh, PA
Cross-site Project of the National Neighborhood
Indicators Partnership and Annie E. Casey Foundation
Sabina Deitrick, PhD
University Center for Social and Urban Research
University of Pittsburgh
UAA annual meeting, San Antonio, TX
20 March 2014
University Center For Social and Urban Research
This presentation:
• School Absenteeism and this project
• Integrated Data System
– Allegheny County Department of Human Services Data
Warehouse
– Pittsburgh Neighborhood and Community Information
System
• Early results
• Project going forward
University Center For Social and Urban Research
Pittsburgh Public Schools Chronic Absenteeism
School
District
Westinghouse Academy 6-12
Perry High School
Carrick High School
Brashear High School
Spring Hill K-5
Schiller 6-8
South Brook 6-8
Online Academy
Woolslair K-5
Uprep 6-12 At Milliones
Arlington K-8
South Hills 6-8
Allderdice High School
King K-8
Miller K-5
% of Students Chronically
Absent* in the First
Semester: 2012-13
27.7%
64.8%
59.3%
51.9%
49.9%
35.6%
34.3%
34.1%
33.0%
32.6%
30.9%
30.8%
29.9%
29.6%
29.6%
29.6%
% of Students
Chronically Absent* in
the First Semester:
2013-14
26.0%
60.2%
63.2%
50.5%
45.7%
24.3%
29.7%
30.0%
22.3%
20.3%
45.5%
34.1%
27.3%
25.0%
30.3%
23.5%
Change
-1.7%
-4.6%
3.8%
-1.4%
-4.2%
-11.3%
-4.6%
-4.1%
-10.7%
-12.3%
14.7%
3.4%
-2.6%
-4.6%
0.7%
-6.1%
School change in top 10
School change in bottom 10
University Center For Social and Urban Research
Policy problem: School absenteeism
• Much work done on student attendance (Chang & Romero, 2008)
• Chronic absenteeism (≥10% missed school days for any reason)
– Students miss learning opportunities
– School performance suffers as students progress through school
– Exhibit academic and other problems
• Traditional school views
– Truancy and “unlawful/unexcused” absences and policies
– “Average Daily Attendance” – doesn’t unveil individual impacts
• Awareness and “School Attendance Matters”
– Conference to build awareness and develop solutions among professionals
– October 2013 – University of Pittsburgh and Allegheny County United Way
University Center For Social and Urban Research
Results of Action Plans to work together
• Top In-School Factors
• Top Out-of-School Factors
1. Bullying
1. Lack of parent support/urgency
2. Teacher/student relations
2. Basic needs not met
3. School structure/culture
3. Home/family issues
4. Academics
4. Health issues (family included)
5. Lack of transportation
5. Violent/unsafe community
6. Lack of transportation
DATA WAREHOUSEUniversity
TIMELINE
Center For Social and Urban Research
Allegheny County Department of Human Services Data
Warehouse
Pre-1996:
Over 80
separate client
based systems
January, 2003:
April, 2001:
First
External Source
Data Warehouse built
Imported
for the purpose of
(Department of
unduplicating clients
Public Welfare)
2001
1996
eCAPS
AAA
4/2001
DPW
LIHEAP
1/2003
2002
CYF Parents
6/2001
October, 2000:
Electronic Client and
Provider System
(eCAPS) built to join
multiple systems onto
one operating platform
MATP
ALDA
9/2002
April, 2002:
DW Bridge and
Unduplicated
Clients tables built
Near Real Time
Data Warehouse
FSC
8/2003
2003
2000
January, 2007:
December ,2007:
Client matching
DW jobs
algorithm merges
December, 2004:
automated
through
January, 2006: 24,000 duplicate client
11 Data Sources
scheduling tool
records
ReportNet Goes
Imported into the
October, 2007:
into Production
DW
DHS Moves to
for Internal Users
2005
2004
CCBHO
7/2003
AAA
(SAMS)
9/2004
January, 2005:
Rematching Effort
Completed: 15,000
duplicate client
records merged
ACHA
1/2006
2006
Addition
Probation
al CYF
& Parole
HSDF Parents JPO
5/2006
8/2006 11/2006 6/2007
2007
HACP
CSBG
3/2006
7/2006
DOC
ACJ
4/2006
10/2006
JPO
Medical
Placement Examiner
5/2008
7/2008
2010
2008
CSP
CYF 6/2008
Placement
4/2008
May, 2006: April, 2007:
DW –
Cubes Move to
April 2008:
Master
ReportNet
CYF Reports
External User Client Index
in Cognos8
Integration
ReportNet
July 2008:
Access set up
November, 2007: QuickVue
Cubes built from realtime DW (Daily,
weekly and monthly)
DHS signed a MOU
with the three school districts:
• Directory information
• Educational outcomes for kids:
 DHS is legal custodian
PPS
 10/2009
All
other kids action research
agreement
• Consent
DATA WAREHOUSE DATA SOURCESUniversity Center For Social and Urban Research
Allegheny County Department of Human Services Data
Warehouse














Allegheny County Housing Authority
Allegheny County Jail
Allegheny County Medical
Examiner’s Office
Department of Public Welfare
Housing Authority City of Pittsburgh
Juvenile Probation
Pittsburgh Public Schools
Clairton Public Schools
Pre-trial Services
Adult Probation
Adult/family court
Aging
Children, Youth and Families
Community Service Block Grant
Source: Allegheny County Department of Human Services












Drug & Alcohol
Early Intervention
Family Support Centers
HeadStart
Human Services Development Fund
Homeless/Housing
Low Income House Energy Assistance
Program
Maximum Participation Project
Medical Assistance Transportation
Program
Mental Health
Mental Retardation
System of Care Initiative
University Center For Social and Urban Research
Connecting People and Place -- Data Sharing between DHS Data
Warehouse and PNCIS
University Center For Social and Urban Research
Allegheny County School
Districts in Study
Pittsburgh
Public Schools
Students: 26,292; free
or reduced lunch = 70%
Schools: 56
K-5=23; K-8=14; 68=7; high schools=4;
other=8
Woodland Hills
School District
Students: 3,992; free or
reduced lunch = 70%
Schools: 8
K-6=5; K-8=1; 7-8=1;
high school=1
Clairton City
School District
Students: 792; free or
reduced lunch = 87%
Schools: Elementary and
middle/high school)
Source: PA Department of Education 2012-13 School-Year Profiles
University Center For Social and Urban Research
Kids in Human Services
• Prior involvement with Human Services
– 53% of Pittsburgh Public Schools students
– 60% of Woodland Hills School District
– 64% of Clairton School District
• Involvement with Human Services in past year (2012)
– 36% Pittsburgh Public Schools
– 46% for both Woodland Hills and Clairton students
University Center For Social and Urban Research
Preliminary Results
• Students with DHS involvement in 2012 were 41% - 85% more likely to
have worse attendance than students who did not.
• Living in public housing was not a significant for K – 4th graders, but
students from 5th – 12th grade were 15% - 29% more likely to have
worse attendance than those who did not.
• Students in 6th – 12th grades with juvenile justice involvement were
114% - 164% more likely to have worse attendance than those not
involved in juvenile justice.
• While attendance by race of student (black/white) is significantly
different, when accounting for other predictors, black students
between 3rd – 8th grade were less likely to have worse attendance.
University Center For Social and Urban Research
Research Question Framework
Factor
Community
School
Property
Family
Student
Safety
Crime
Ex-offenders
Incidents
Bullying
Building condition
Vacant property
Property condition
Code violations
Specific incidents
Involvement with
justice system
Involvement with
justice system
Walking paths
Teacher turnover
Principal turnover
Tax delinquency
Foreclosure
Vacant property
Affordability
Home ownership
status
Financial distress
Age of housing
Housing condition
Public housing
Relocation
Homelessness
Change in
composition
Parent in prison
Finances
School change
Mode of travel
Instability
Health
Pollution
Teen births
Food availability
Building condition
School
Poverty
Race
Principal stability
Suspension policies
Teacher attendance
Student performance
Special education
Employment
Labor force
participation
Mode of travel
Participation in
school activities
Poverty
Race
Special education
Employed family
members
Transit access
Work patterns and
industry
University Center For Social and Urban Research
Human Services Data Sharing Community Stakeholders
Group
Type of Organization Organization
Clairton School District
Pittsburgh School District
Elizabeth Forward School District Steel Valley School District
Gateway School District
Sto-Rox School District
McKeesport School District
Woodland Hills School District
School District
A+ Schools
Educational
Allegheny Intermediate Unit
Intermediary
Pittsburgh Promise
Buhl Foundation
Private Foundation
Grable Foundation
Heinz Endowments
Pittsburgh Foundation
RK Mellon Foundation
Government Agency Children's Court
Allegheny County Department of Human Services
Housing Authority City of Pittsburgh
Juvenile Probation
Allies for Children
Other Nonprofit
Community Care Behavioral Health
Organizations
Homewood Children's Village
KidsVoice
United Way
Urban League
Higher Education
Institution
Duquesne University
University of Pittsburgh
University Center For Social and Urban Research
Community engagement in research
• Steps engaged in so far and to be engaged in:
– Identification of primary intended users and formation of place-based
design & advisory group
– Situational analysis
– Focusing the inquiry
• Stakeholder engagement
– Partner interests
– Additional methods
– Connecting findings into district action systems for planning, policy, design and
implementation