USOE Data Warehouse Information

Click for home

"Creating assessment networks for schools"

Charters use a variety of SIS software. The majority use the USOE SIS2000+ software; the others use PowerSchool, RenWeb, and Compass.

Regardless of which SIS you use to manage the daily student information of attendance, course scheduling, grades, etc, a subset of the data is collected by USOE for longitudinal data analysis and reporting. As of 2005, student information is connected by the State Student Identifier (SSID).

Three times per year SIS data is verified via the Clearinghouse process. After it is clean, it is loaded into the USOE Data Warehouse. Standardized test data is also loaded into the warehouse at different times of the year. Until August 2009, a subset of the warehouse data was given to schools on what was called the Enhanced Research Disk.

I have the Enhanced Research Disks (Access files) since the 2003-04 school year for all charters that signed a permission slip. I use this data to generate reports for charters.

In August 2008, school data was also released in a new format known as SERF. By August 2009 it is the only format of data released. I have SERF data for all charters that signed a permission slip for me to access their Move-IT folder where this data is released.

I created an Excel document for each LEA (charter) from their SERF data. The file contains all the CRT scores for students from Spring 2009. Click here for documentation on the columns of data and how to auto-filter to quickly analyze the data for different teachers at your school. (New 09/14/09)

  Data Warehouse
  • Warehouse Dictionary - Description of data items in the warehouse
  • Business Rules - Click on "Warehouse Specifications" and then on "Business Rules" to open the most recent set of rules.
  • Enhance Research Disk (ERD) - This Access file was distributed via the secure Move-IT webpage (instructions and a permission request form are in this documentation) in the "Warehouse" subfolder. Each time a new version is released, a description of the version is found on the USOE Enhanced Research Disk webpage. This webpage also contains a data dictionary and a diagram of the tables and data items contained in the Access file.
  • How to Analyze the Research Disk with Excel.pdf (Rev 02/13/08)

    Please note the revision at the end of the file; it has a recommendation for dealing with the 2006 data that is included in the 2007 research disk.

  • State Education Research File (SERF) - This Access 2007 file is a super-set of data from the Warehouse. It was released for the first time in August 2008 via the secure Move-IT webpage. It is in ACCDB file format that can only be opened with Access 2007 and is not part of the standard Office suite . Contact USOE if you cannot open your file; they can "save as" Access 2003 format which you can open with Excel.