Downloadable WKCE / WAA Data

1997-98 thru Present

State, district and school proficiency summary are available for downloading from this Web page. These are the most complete versions of the WKCE proficiency data available to the public. WKCE local proficiency data file/display options provided at the DPI Website were created using the the data contained in these tab-delimited files. Writing scores and percentile ranks are also available in the proficiency data files for 2001-02 and earlier.

The tab-delimited files are included in one zipped self-extracting file for each year. Each self-extracting file is approximately 2 MB.

*Download 2006-07 data. See layout.
*Download 2005-06 data. See layout.
*Download 2004-05 data. See layout.
*Download 2003-04 data. See layout.
*Download 2002-03 data. See layout.
Download 2001-02 data. See layout.
Download 2000-01 data. See layout.
Download 1999-00 data. See layout.
Download 1998-99 data. See layout.
Download 1997-98 data. See layout.

* Caution: Proficiency data for 2001-02 and earlier years are NOT comparable to proficiency data for 2002-03 and later years. See related question and answer document.

After downloading, double-click on the file. The zipped file will automatically unzip creating a separate file(s) for the tested grades: grade 4, grade 8, and grade 10. Each grade level file or files is very large because there are over 2,000 public schools and over 400 school districts in Wisconsin. Results by race/ethnicity and other student groups within each school and district are included. Unzipped file sizes range from 2 MB to 10 MB. The more recent files are larger than earlier files because they contain more fields (i.e., more data about each school/district and student group). Grade 4 files tend to be the larger than grade 10 files because there are more elementary schools than high schools.

Due to the number of rows in each file, you will need to select software that can handle up 40,000 rows of data. More recent versions of Excel and Access, for example, can handle files of this size, but older versions cannot.


Other Useful Information

Preformatted Excel files for 1997-98, 1998-99, 1999-2000 and 2000-2001 may also be downloaded. These Excel files may be easier to use because they have column headings that are relatively self-explanatory and are formatted so that they may be printed or viewed on the screen. Extensive formatting causes these grade-level files to be much larger than the tab-delimited files so they may be divided by student group into separate files.

Do you want more user friendly column headings? An Excel 97 file is available that includes these headings for the 2001-02 data files and for earlier years. You can copy the data rows from the tab delimited files into the rows below column headings in the Excel file.

Do you want to join two files using district or school codes but there are numeric codes without leading 0's in one file and alpha codes with leading 0's in another? Follow these steps

To protect student privacy, results are not reported in every row of these files.

Percentages for the nationwide sample are based on the number of students tested. Percent "Not Tested" is unavailable for this group. Beginning in 2002-03, Wisconsin has used a combination of off-the-shelf national test items and customized test items to improve alignment between the Wisconsin Knowledge and Concepts Examinations (WKCE) and Wisconsin's Model Academic Standards. This change was required by the No Child Left Behind Act. Since customized items are not nationally normed, beginning in 2002-03 national sample proficiency data are not available.

Demographic data contained in these files are the data reported by school districts and were not audited by the testing contractor or the Department of Public Instruction. In order to reduce the data collection burden, default demographic codes were used when student data were hand-gridded if the vast majority of students statewide were in a specific demographic category. For example, districts were only required to hand-grid data for "students with disabilities." All students not marked as students with disabilities were automatically coded "nondisabled." No default codes were used for race/ethnicity. Missing race/ethnicity codes were reported as "missing."

For questions about this information, contact oeamail@dpi.wi.gov