ESE Data Warehouse Initiative

1
ESE Data Warehouse Initiative

• Technology Directors Workshop
• Presented by
• Jen Goree and Jeff Comenitz
• 10/29/08

2
Why an Education Data Warehouse?

• Enable all students to meet the high standards
  necessary for success by
• Enabling the Department and Districts to make
  full use of the information at our disposal
• Supporting data-driven decision-making

3
How Does It Enable Data-driven Decisions?

• Consolidates the Departments data into a single
  system for analysis and reporting
• Student, Educator, Assessment
• Provides a standardized, low-cost data
  warehousing system to all Districts
• Addresses the pervasive and increasing need for
  data analysis and reporting

4
Who Is Participating?

• All districts currently have access to the
  warehouse
• Up until this fall 100 districts have been
  trained and provided access to the Education Data
  Warehouse. Many were past or current grant
  recipients.
• Two levels of district participation
• Level 1 - Available to all districts now
• State-loaded data (seven years of SIMS, MCAS)
• Ability to claim current students and see MCAS
  history
• Level 2
• State-loaded data, plus optional upload of
  district local data (Grades, Schedules,
  Assessments)

5
(No Transcript)
6
District Costs

• Districts wont have to pay for
• Data Warehouse access licenses
• Servers / hosting
• Districts may have costs for
• Assistance with data extracts
• Custom report development
• Training

7
What Is In The Data Warehouse?
8
What Questions Can We Answer With State-loaded
Data?

• Of my current 10th graders, who scored Warning on
  7th Grade Math, and what were their major areas
  of weakness?
• Which students have the lowest attendance rates,
  and what is their demographic/subgroup makeup?
  Does their attendance tend to improve as they
  advance in grade level?
• Over the past four years, which schools in my
  district had students who performed best on
  Geometry?
• Did my 8th grade Hispanic students perform better
  or worse overall on the 2008 MCAS, compared to
  similar students from 2002-2007?

9
With Local Data Added

• Does there appear to be any correlation between
  ITBS/DIBELS/SAT/other assessments and MCAS?
• Do my highest-GPA students tend to perform better
  on the MCAS than lower-GPA students?
• What is the subgroup makeup and test performance
  history of my students who enroll in AP courses?

10
Current Capabilities

• Run predefined reports of state and local data
• Dynamically compare, group, and categorize to
  examine cubes of student and assessment data
• Build new reports based on common questions
• Export query results into PDF, Excel
• Schedule and distribute regularly used reports

11
Data Warehouse Demonstration
12
District-loaded Common Formative Assessments

• Nationally-normed Assessments
• ITBS
• GRADE
• DIBELS
• Local Assessments
• Generic Template for locally-created assessments

13
How Will Data Be Protected?

• Controls to protect confidential data built into
  reports and cubes according to access level
• Access levels
• District level
• School level
• Classroom level (coming soon, under development)

14
Student Claiming

• Districts may claim their registered students
• By uploading a small file into the dropbox
  (similar process to the MCAS lookup tool)
• Claiming students will provide access to
• Historic MCAS data
• Historic SIMS data

15
(No Transcript)
16
What District Training Is Available?

• Courses developed by
• Public Consulting Group / Center for Resource
  Management
• Target audiences
• Administrators, District/School Data Teams,
  Technologists
• Topics include
• Education data use
• Data analysis and reporting using Cognos tools in
  the Data Warehouse

17
Training Initiative

• Courses in curriculum
• DW101 - Data Warehouse 101
• DW102 - Accessing MCAS Results
• DW201 - Informing Instruction with Data
• DW202 - Multi-Dimensional Analysis
• DW301 - Report Builder I
• DW302 - Report Builder II

• Tested in six different locations across the
  state during September
• ESE will own the Curriculum
• Final version to be posted late-October
• Training Partner RFR released in mid Oct.

18
Training Example Informing Instruction with
Data
19
Getting Started

• Determine how the data warehouse fits into your
  districts data use strategy
• Schedule training for your staff
• Using PD vendors or in-house staff
• Register data warehouse users
• Add them to your district and schools in
  Directory Administration (DA)
• Assign them one of the Data Warehouse roles
• DW District User (210)
• DW School User (211)
• Wait overnight for their roles to propagate from
  DA into the data warehouse.
•  

20
Education Data Warehouse

• For More information
• Email
• datawarehouse_at_doe.mass.edu
• Website
• http//www.doe.mass.edu/infoservices/dw/