Marketing Library

1
Florida Education Data Warehouse
Project Overview
Feb 26th , 2001
2
Agenda
1
Background
2
Targeted Content
3
High-Level Plan
4
Technical Aspects
5
Challenges
6
For more information
3
Project Background and Goals
1
4
A normal day in the education field
What happened in previous year ?
Did we make the right/best decision?
Hi, Im a researcher looking for infomation on...
Whats happening right now ?
Where and how can we improve Education in Florida?
Whats going to happen in the future ?
How does that compare to what was expected to
happen this year (last year)?
5
Current Environment
Operational systems isolated by business functions
Users support
Lack of reliable, consistent data across delivery
systems
No Pre K-20 data integration
Various data and technical architectures
Limited data readily available
Technical barriers
6
Proposed K-20 Performance/Accountability System
How is Floridas K-20 system performing in terms
of educating its students?
How are the major delivery systems performing
(K-12, CC, SUS)?
What is the public getting for the funds invested
in Education?
How are individual higher education institutions,
school districts and schools performing their
responsibility to educate their students?
7
The objectives
Complete, timely, accurate data
Easy access and manipulation
Statewide view
Cross-functional data management and support
group
Data from multiple sources and organizations
Historical data merged with current in a
structured repository
Integrated technical environment
Comprehensive data definitions
8
Our Mission
Provide stakeholders in public education -
including, but not limitedto, administrators,
educators, parents, students, state leadership,
and professional organizations - with the
capability of receiving timely, efficient,
consistent responses to inquiries into Floridas
pre-kindergarten through university education
system by December 2002.
9
Project Unique Characteristics

• Collaborative development effort with
• Department of Education
• State Board of Community Colleges
• State University System
• DMR Consulting
• Built in increments (phases)

10
Project Unique Characteristics

• Includes all functional parts of the education
  delivery system K-20
• School districts
• Community colleges
• State universities
• Statewide picture
• Historical and current data
• Over a 2 year periodwere just beginning

11
A wide array of users
Community Colleges
State Universities
School Districts
Reporters Media
Education Community Students Teachers Parents
Legislature Politicians
Researchers
12
Targeted content of the EDW
2
13
From Pre K-12
Staff source data - 268,983 FTS (1999) - 10 years
of data - Demographic - Salary/Benefits
- Experience - Degrees - In Service -
Job Codes (4 times/ year)
Students source data
- 2,376,128 students (1999) - 10 years of
data - Demographic - Course/Program -
Funding
End of Year discipline,retention/
promotion, dropout, graduate/completer
Incidents of crime and violence
(6 times/Year)
Selection Process
EDW Central Repository and Datamarts (Current
year 5)
14
From Community Colleges
Staff source data - 56,400 empl. (1999) - 10
years of data - Demographic - Salary -
Benefits - Course Schedule - Employment
Activities - Instruction Activities -
Reassignments (3 submissions / year)
Students source data - 717,561 students (1999) -
10 years of data - Demographic -
Entry/Exit testing - Acceleration placement
- Courses/Programs - Programs - Completion
- Financial aid ( 5 submissions / Year)
Facilities - 156 Sites - 2,219 Facilities -
64,000 rooms
( 1 annual submission)
Selection Process
EDW Central Repository and Datamarts (Current
year 5)
15
From State University System
Students Source Data - 234,016 students (1999) -
25 years of data - Demographic -
Admission - Acceleration placement -
Courses/grades/credits - Discipline/ academic
history - Stipends/waivers/fellows -
Financial aid ( 5 times / Year)
Staff Source Data - 33,552 empl. (1999) - 10
years of data - Demographic -
Salary/Benefits - Classification... -
Appointm. period - Employ./ Instruc.
Activities -Rank / Tenure (26 times / year)
Facilities - Sites - Facilities - Rooms
Selection Process
EDW Central Repository and Datamarts (Current
year 5)
16
A complex integration process
Department of Education data (Pre K-12)
Community College data
State University data
Identify / Match Reconcile Clean Synchronize Integ
rate
EDW Central Repository and Datamarts (Current
year 5)
17
High level plan
3
18
High Level Schedule (work in progress)
June 2001
Dec. 2001
June 2002
Dec. 2002
Preliminary Design
Release 2
Ongoing
Target 1 release every 6 months
19
Technical aspects
4
20
Generic Infrastructure
VSAM, SAM, Sequential
Access, Dbase, Foxpro
ARDENT TOOLS (Datastage)
DB2, Oracle SQL-Server
ORACLE Tools Storage Access
Access to source data
Extract
Data movement
Transform load
Data transformation integration
Data Warehouse
Store
Specialized Data Marts
Metadata DW management tools
Web tools / portal (Web-DB)
Access
Pre-formatted
Query/reports
OLAP
21
Technical environment
Highlights Sun 10000 Unix Oracle 8i to
9 Ardent Or-WebDB Or-Discoverer Or-Express 4
terabytes
22
Challenges
4
23
Management Challenges
Communication
Manage Scope and Expectations
Budget and time boxing
Reconcile various missions and objectives
of agencies involved
Agencies involvement, collaboration, synerg
y
Data Warehouse organizational issues
24
Technical Challenges
Multiple sites/platforms
Tools Integration
Privacy and Security
Data Quality
Common-ID
Reconcile Current and Historical Data
Size of the Data Warehouse
25
Utilization Challenges
Metadata (comprehensive dictionary) gathering
User Friendliness
Data DW Mastering
User support and training
Trust the DW results
New Tools to learn
26
Who to contact.
6
27
Contact Names and E-mail Addresses

• Karen Weaver weaverk_at_mail.doe.state.fl.us
• Bernard Sévigny bernard_sevigny_at_dmr.ca
• Kim McDougal kim.mcdougal_at_laspbs.state.fl.us
• Kathy Peck Peckk_at_mail.doe.state.fl.us
• Robert McMullen robert_at_flccs.org
• Shirley Roddenbery roddens_at_borfl.org
• DOE Internet site http//www.firn.edu/doe/bin000
  50/dataweb/database.htm
• SBCC Internet site http//www.dcc.firn.edu
• SUS Internet site http//www.borfl.org/irm/defau
  lt.asp
  
  
• Transition Task Force Internet site
  
  
  
  
  
  
  
  
  
  
  
  

http//www.myflorida.com/myflorida/education/learn
/egrt_taskforce/index.html