Vermonts Education Data Warehouse EDW

1
Vermonts Education Data Warehouse (EDW)

• Built by a Partnership Between
• the Vermont Data Consortium and the Vermont
  Department of Education

2
I suppose you want an immediate answer
3
Why are we here?

• In most schools we have a tremendous amount of
  data, but we lack information because we can not
  easily see the patterns that exist.
• Somewhere in the maze of state assessments, local
  assessments, standardized tests, perception
  surveys, pilot projects, and demographic
  information lie answers and important insights to
  our most important questions
• Whats working?
• Whats not working?
• How can we improve the education for all of our
  students?
• The Vermont Department of Education and the
  Vermont Data Consortium are committed to develop
  a system that supports educators and policy
  makers in data-based decision making for school
  improvement.

4
What is the Education Data Warehouse?

• It is not a Student Management System (daily
  transactional system)
• It is
• a collection of data from multiple data sources
• a place to easily view and analyze data
• a key support to data-driven decision making

5
Who is the Vermont Data Consortium (VDC)?
A consortium of 27 SUs/SDs
6
Who is the Vermont Data Consortium (VDC)?
A consortium of 27 SUs/SDs 46,339 students

• Addison Central SU
• Addison Northeast SU
• Addison Rutland SU
• Barre SU
• Bennington Rutland SU
• Caledonia North SU
• Chittenden Central SU
• Chittenden South SU
• Franklin Northeast SU
• Franklin Northwest SU
• Grand Isle SU
• Lamoille North SU
• Lamoille South SU
• North Country SU

• Orange North SU
• Orange Windsor SU
• Orleans Southwest SU
• Rutland Central SU
• Rutland City SD
• Rutland South SU
• South Burlington SD
• Washington Central SU
• Washington South SU
• Windham Northeast SU
• Windham Southeast SU
• Windsor Northwest SU
• Winooski SD

7
Where we have been

• Initial investigation of products and services by
  local schools and districts Fall 2002
• Interested schools and districts form Vermont
  Data Consortium (VDC) Fall 2003
• Commissioner Cate proposes a partnership between
  the DOE and VDC and recommends that a project
  team be formed Dec 2003
• VDC and DOE hire staff for project May 2004
  (Note All of the initial staff are still
  involved with the project.)

8
Where we have been (cont.)

• Finalize MOU with DOE May 2004
• RFP developed and issued July 2004, re-issued
  August 2004
• Detailed evaluation and selection process Sept
  to Nov 2004
• Select vendor (TetraData) and negotiate contract
  December 2004
• Begin work with contractor February 2005
• VDC moves into their first office in Montpelier
  July 2005
• VDC hires two additional part time staff July
  2005

9
Where we have been (cont.)

• Initial trainings with EDW July, August,
  September 2005
• Additional DOE, SU, and school staff trained
  Fall 2005
• Security (initial user accounts available) Oct
  2005
• Professional development focusing on data-based
  decision making for school improvement with
  nationally-recognized consultant, Dr. Victoria
  Bernhardt Nov Dec 2005

10
Where we have been (cont.)

• VDC personnel trained on TetraData Local
  Warehouse building process Winter/Spring 2006
• First SU warehouses with integrated local-state
  data April-June 2006
• VDC personnel begin supporting with SUs/SDs on
  local data extracts April 2006
• Additional VDC Members have initial local data
  integrated with state data Fall 2006

11
Where we have been (cont.)

• Summer/Fall 2007 Expansion of the local
  warehouse model (more assessments, attendance,
  discipline, program/intervention,
  extra-curricular, standards-based report card)
• Winter 2008 First annual NECAP workshops
  planned to work with NECAP summary and item level
  data
• School Year 2008-2009 DOE grant allows VDC to
  provide basic membership to all Vermont SUs/SDs

12
VDC Benefits

• Data Access Access (as appropriate) to all data
  in the system down to the individual student
  level AND access to full suite of data warehouse
  analysis tools
• Local Data Ability to add local data to the
  system and relate it to State data
• Training and Professional Development
• Collaboration Share data queries reports as
  well as local assessment info, data-based
  decision making, etc.

13
VDC Membership
14
Contact Info

• Go to Contact Us section of our website for the
  most current info
• http//www.vermontdata.org/contactus.htm