Education

1

• Education
• Decision
• Support
• Library

Jazzin Up the Data MIS Conference 2005
Michael Carver Fairfax County Public Schools Dept
of IT
2003 Governors Technology Award
2
What is EDSL?

• Electronic Library
• EDSL allows users to mine and summarize various
  volumes of data by creating customized views of
  data (Reports and Worksheets).
• EDSL has three primary components
• 1. Data repository (database) with metrics and
  student information
• 2. Web-based Graphical User Interface (GUI) for
  data cleaning, data mining and analysis
• 3. Reports and Worksheets customized based on
  user's data criteria

3
EDSL Objectives

• Deliver one-stop-shop easy access to
  institution-wide data to support decision-making
  at the strategic level and school level.
• Support operational accountability and
  educational strategy using data as the basis for
  assessing program effectiveness.
• Optimize available resources to provide
  information to educators, administrators, and
  planners.

4
Data Warehouse Structure
SASI STAR_BASE Pentamation
1. Operational data from school system is loaded
from multiple sources into EDSL Staging
Repository.
National/Virginia External Benchmarks
2. Operational data is aggregated, summarized,
and formatted to present in a multi-dimensional
view.
Datamarts
EDSL
Historical Files
3. Powerful analytical tools can then be used to
access, analyze, manipulate and print the data.
Human Resources Data
Financial Data
5
How did we do it?

• Focus on business by leveraging existing 3rd
  party tools like Business Objects, Oracle, APOS,
  Informatica
• Usability is most critical!
• Maximize data delivery options Crystal
  Enterprise environment for infrastructure
• Project Management Best Practices
• Customer Focus Groups
• Project Advisory Board
• Product Road-map and managing requirements

6
Tool features helpful for us

• Crystal
• Ability to export data to other applications and
  formats
• Modify CE environment and template for customized
  user interface look n feel
• APOS
• Dynamic parameters for the on-demand parameter
  pages cascading parameters
• View time security to implement filtering and we
  will be implementing subscription manager

7
Current EDSL Data Sets

• No Child Left Behind AYP, NCLB Data Subgroups
• Membership (enrollment/attendance by
  demographics)
• Course Enrollment Marks (Grades)
• SOL Student Standardized Test Results and
  State Accreditation
• Service Programs ESOL, Title I
• Special Education Demographics and Disability
• Academics Standardized Tests IB, AP, SAT, DRA
• HR Highly Qualified Teacher

8
Impacting Instruction NCLB example

• Review and know 3 yr demographics trends NCLB
  subgroups
• AYP status consider changing thresholds!
• Drill down into Socioeconomic look for NCLB
  subgroups
• Review Number and Percent (SOL proficiency by
  demographics)
• 5 yrs worth of data
• Ethnicity, Gender, Free/Reduced, English
  Proficiency, Educational Designation,
• Review SOL 3 Yr Comparison category level
• Review Performance by Question 3 yrs
• Review Category Results drill down
• Socioeconomic, ethnicity, LEP, by instructor
• Consider referencing Highly Qualified Teacher
  report

9
Whats Coming?

• Available Now
• School Profile Report
• An example of how EDSL evolves by listening to
  customers needs
• Coming Soon!
• Student Accountability Report
• Multiple Test History for Student
• Course/Teacher Correlation
• HR Data
• Standardized Framework

10
Advantages of a Data Warehouse

• EDSL allows for combining multiple data sets to
  see, for example, students failing a course
  (grade), but scoring advanced on the
  corresponding standardized test.
• EDSL allows for backloading of historical data to
  create student test history reports.
•  EDSL drill down into AYP subgroups to answer
  questions like who were the students that caused
  my spec ed kids not to meet AYP?
•  EDSL allows for report on any type of
  standardized test.
• Student achievement can be analyzed considering
  other factors like attendance, demographics,
  participation in programs, and teacher
  qualifications.

11
EDSL Impact on Education

• Supports student education by providing
  school-level metrics to all levels of leadership.
• Helps principals identify student groups that
  need additional resources to be successful.
• Helps principals develop school improvement
  plans.

12
EDSL Data Warehouse Architecture
Data Loading Process
Data Storage
Data Delivery Consumption
Source Database Operational Systems Student Info
Systems, etc.
Report Deployment Production DB Servers
EDSL Database Data Mart Meta Data Staging
Tables Star Schema Adhoc Table
Desktop Interfaces, Web Client Interfaces,
On-Demand Reports, Static Reports, Analytical
Reports Adhoc Reporting
The ETL Process is Iterative, Rule and Table
Driven to Process Data Record
Anomalies Transform Data Correct Data Integrate
Data Summarize Data Approve Data
Data Stewards
Application Servers
Customers
Cube Builder (Pivot Tables) Servers
Other Data Sources (internal or external files)
13
Who Are Our Partners?
APOS
14
EDSL Implementations

• Currently FCPS Business Partner, Insystech, has
  shared EDSL to 6 counties
• Rockbridge County Public School, Lexington,VA
• Alleghany County Public Schools, Covington, VA
• Salem City Public Schools, Salem, VA
• Henry County Public Schools, VA
• Fauquier County Public Schools, VA

15
EDSL Contacts

• Michael Carver, Project Manager
• mdcarver_at_fcps.edu
• 703-503-7724
• Vincent Kelso, Lead Data Architect
• 703-329-7447
• Gary Policastro, Development Team Coordinator
• 703-329-7768
• www.fcps.edu/edsl