Transcript Slide 1

Carpenters, plumbers, &
electricians
Legalities, tips, and
strategies for sharing
data across state
databases
Florida Department of Education
Dr. Eric Smith, Commissioner
Florida’s Integrated, Longitudinal PK20
Education Data Systems
 The “System”
 Public pre-kindergarten through graduate school with student level data for public
schools, community colleges, career and technical education, adult education, and
the state university system
 Staff, facilities, finance, and financial aid
 Post school employment and non education system program data
 Primary means of support is state general revenue

Dependencies





State level imperatives, funding
System of common course numbers and directories
Statewide articulation agreements and oversight committee
A state level culture of data management and interagency sharing
A means to follow the records of individual students across geographic areas,
education sectors, and related programmatic areas.
 67 School Districts, 28 community colleges, 11 state universities
 Very open public records laws
Primary K-20 Data Resources
Florida
Comprehensive
Assessment Test
(FCAT)
Pre Kindergarten
Students
K12 Student & Staff
Data Base
Community College
Student & Staff
Data Base
PK12 Finance &
Facilities
Adult Education/
Career & Technical
Student & Staff
Data Bases
Teacher &
Professional
Certification Exams
College Placement
Tests
College-Level
Academic Skills Test
State University
System Student
& Staff Data
Base
College Board:
Advanced Placement
SAT
Student Financial
Aid Data Bases
ACT
ACT & Work Keys
(Fingers Crossed)
National Student
Clearinghouse
Unemployment
Insurance
(Archives)
Department Children
FamiliesTANF, Food Stamps.
Foster Children
(Archives)
Department of
Defense; U.S.
Postal Service,
Ofc Personnel Mgt
Non Public
Postsecondary
Institutions
The PK-20 Pipeline Model
Credential Outputs
Major Pipeline Outputs
Students Exiting/Entering
Additional Pipeline Inputs
Doctoral Degrees
Professional Degrees
Master’s Degrees
Bachelor’s Degrees
Associate Degrees
One-year PS Cert.
HS Diplomas
“Traditional
Students”
18-24
Age Group
Part time
traditional
students, stop
in/stop outs,
students
entering from
out of state,
students >24
years old.
The Pipeline Schematic
Bachelor’s Degree
Working Adult Students 24+
Universities
Full-time Work
Colleges
Community College
Voc Tech
Schools
Part-time Work
Working Students 17-24
Traditional Students
High School Exits
Florida’s Primary K-20 Data
Resources
SUS
Division of Accountability
Research & Measurement
Source
Information
Systems
Assessment &
School
Performance
PK-12
Student &
Staff
Integrated
Data
Systems
Comm Coll
Tech Center
Student/Staff
Data collected from testing
vendors, school districts,
community colleges
PK20 EDW
Finance &
Facilities
Fin Aid
Tch Cert
Other
FETPIP
Data collected from
source systems, agency
administrative data bases
PK20 EDW = PK-20 Education Data Warehouse
FETPIP = Florida Education and Training Placement Information Program
Florida’s PK20 Education Data Warehouse
•
•
•
•
•
Longitudinally Integrates “source data” from PK-12,
Workforce, Adult Education, Community Colleges,
Universities student and staff data bases.
Additionally integrates financial aid, facilities, and finance
data sources.
Includes demographic, course-level enrollment,
attendance, statewide assessment results, and awards
for students.
Includes demographic, payroll, and facilities information
for all staff; certification, course data, preparation
information for instructional staff.
Links to follow-up information and external agency data.
Florida’s PK20 Education Data Warehouse
PK-12
data
PK-20
Assessments
Technical
Center
data
Community
College
data
State
University
data
EDW Central Repository
(1995 forward)
Pre-defined & Ad Hoc
Reports/Requests
Data Marts
Research
Extracts
Matching Individuals in Florida’s Education
Data Warehouse: Sophisticating the
Matches, Anonymizing Data
ble
tifia
Data warehouse
internal identifier
en
l Id a
a
n
t
rso Da
Pe
Matching Process
Mainframe Systems
Data for load in the warehouse
Other Systems
Transform & Load
processes
Data warehouse
Florida Education and Training Placement
Information Program
•
•
•
•
Helps to answer the question: What happens to
students after they graduate from or leave programs
Designed & developed to follow-up all participants and
students from Florida’s education and training programs
at all levels
Integrated interagency data collection and reporting
system, administered through the Florida Department of
Education
Relies administrative data resources of state and
federal agencies, including archival repositories
Florida Education and Training Placement
Information Program
Uses of the Data
 Classrooms & Local Administration: Assessment analysis,
contextual information, transcript exchange, Individual Education
Plans, high school/community college feedback
 Federal Performance Accountability: NCLB; IDEA; WIA
(Wagner-Peyser, Voc Rehab, Blind Services, Adult Education);
Perkins; the Chafee Act; HEA
 State Performance Accountability: School attendance; classsize; FRL Eligibility; Foster Child Outcomes; Prison education
Programs; performance-based funding; public education funding
 State and federal Performance reviews: Welfare reform; state
financial aid; articulation; financial audits
 Customer Information: Career Guidance, career planning
 Others:





Private School Licensure
Problem Solving
Legislative Performance Reviews/Budgeting
Internal and External Policy Research
Government, Public, Media Requests
How are Florida’s Students doing on High-Stakes
Assessments?
60%
57%
50%
40%
30%
47%
47%
50%
52%
57%
53%
Achievement Level 1
32%
31%
29%
20%
27%
Achievement Level 3 and
Above
26%
22%
22%
2006
2007
10%
0%
2001
2002
2003
2004
2005
Source: PK-20 Education Data Warehouse
How are Florida’s Students with Disabilities doing on
High-Stakes Assessments?
70%
60%
66%
66%
62%
60%
50%
57%
52%
51%
40%
Achievement Level 3 and
Above
30%
20%
10%
Achievement Level 1
19%
19%
2001
2002
21%
23%
2003
2004
25%
28%
28%
2006
2007
0%
2005
Source: PK-20 Education Data Warehouse
How do Florida Students Leave Public High Schools?
1995-96
90,000
89,461
80,000
70,000
60,000
50,000
40,000
31,749
30,000
20,000
10,000
2,329
1,505
1,588
CERTIFICATE OF
COMPLETION
GED
0
STANDRD
DIPLOMA
SPECIAL
DIPLOMA
DROPOUTS
Source: PK-20 Education Data Warehouse
How do Florida Students Leave Public High Schools?
2006-07
140,000
132,814
120,000
100,000
80,000
60,000
31,027
40,000
20,000
6,546
9,645
Special
Diplomas
Certificate of
Completion
2,943
0
Standard High
School
Diplomas
GED
Dropouts
(Grades 9 - 12)
Source: PK-20 Education Data Warehouse
How do Florida’s Students with Disabilities Leave Public
High Schools?
1995-96
6,000
5,000
5,336
4,763
4,000
3,000
2,284
2,000
1,000
224
78
Special
Certificates
GED
0
Standard High
School
Diplomas
Special
Diplomas
Dropouts
(Grades 9 - 12)
Source: PK-20 Education Data Warehouse
How do Florida’s Students with Disabilities Leave Public
High Schools?
2006-07
12,000
10,000
9,766
8,000
6,346
5,146
6,000
4,000
2,000
75
292
Special
Certificates
GED
0
Standard High
School
Diplomas
Special
Diplomas
Dropouts
(Grades 9 - 12)
Source: PK-20 Education Data Warehouse
What Happens After They Graduated? - Standard
Diplomas to Postsecondary
1995-96
The1996-97 Academic Year*
PK-12 Adult Programs
4,735
(9%)
Community Colleges
34,343
(62%)
State University System
14,518
(26%)
Independent Universities
2,608
(5%)
89,461
Diploma
Recipients
Outta State
2,805
(5%)
*54,858 Unduplicated Students – 61%
Source: PK-20 Education Data Warehouse
What Happens After They Graduated? - Standard
Diplomas to the Florida Labor Force
1995-96
October- December, 1996
45,763
(51%)
Employed
 Employed Full Time
89,461
Diploma
Recipients
53% of Postsecondary
Enrollments also working
Av. Earnings Full Time
40% of
employed
$17,336
Military Enlistment
1,408
Public Assistance
5,518
(TANF &/or Food Stamps)
Source: PK-20 Education Data Warehouse
Florida 1995-96 High School Graduates
Highest Educational Credential Attainment as of 2007
Post BA
4%
BA
18%
AA
8%
Col Credit Voc
2%
Standard Diploma
66%
VOC
2%
89,461 Standard Diplomas
(15,478 – 17% Never Enrolled in Florida – 6.48% out
of State)
Source: PK20 Education Data Warehouse
Florida 1996 High School Graduates
Students With Disabilities
Highest Educational Credential Attainment as of 2007
Post BA
1%
Col Credit Voc
2%
VOC
2%
AA
4%
BA
5%
Standard Diploma
87%
4,763 Standard Diplomas
(1,339 Never Enrolled)
Source: PK20 Education Data Warehouse
1995-96 Florida Public High School Exiters: "Others"
Highest Credential Attainment as of 2007
93%
HS GEDs
Total 1,587
29% Never Enrolled
94%
All GEDs
Total 28,987
28% Never Enrolled
94%
Cert Cmpltn
Total 1,505 32% Never Enrolled
Source: Florida K-20 Education
Data Warehouse
99%
Spc Dip
Total 2,329
55% Never Enrolled
75%
Dropouts
Total 31,749
43% Never Enrolled
Florida Public High School Class of 1996
Annualized Earnings Based on Highest Education Credential
Attained Through 2007
$60,000
$53,632
$50,000
$45,288
$42,224
$40,000
$35,332
$34,312
$31,480
$30,000
$21,272
$20,000
$10,000
BA
Po
st
el
or
s
ac
h
De
g
A
A
re
d
du
lt
V
C
ol
le
ge
C
A
ar
y
nd
Po
st
se
co
B
l
it
Vo
c
at
io
oc
ip
l
oo
lD
Sc
h
Hi
gh
d
da
r
at
io
na
l
na
a
om
ts
ro
po
u
D
St
an
re
e
$0
Source: Florida Education and Training Placement Information Program (FETPIP)
Education and Training pay …
Unemployment Rate
Median Earnings
(Percent)
(Dollars)
1.4
1.1
1.7
2.3
3.0
3.9
4.3
6.8
$74,932
Doctoral degree
$76,648
Professional degree
$58,708
Master’s degree
$50,024
Bachelor’s degree
Associate degree
Some college, no
degree
High-school, graduate
Some high-school, no
diploma
Notes: Unemployment and earnings for workers 25 and older, by educational attainment; earnings
for full-time wage and salary workers
Sources: Unemployment rate, 2006 annual average: Bureau of Labor Statistics; 2006 Weekly Median
Earnings (multiplied by 52 weeks), Bureau of the Census.
$37,492
$35,048
$30,940
$21,788
Sunshine Connections
Demonstration
www.sunshineconnections.org
Questions?
Jeff Sellers
850.245.0437
[email protected]