WINSS DOWNLOAD OPTIONS
You can download all data on WINSS for any specific WINSS data question. Options 1 and 2 provide the most complete sources of both current and historical WINSS raw data. When graphs and tables are updated on WINSS, the download files available under Options 1 and 2 are also updated.
Option 1. Download raw data on this page. A link to the file for this download option is provided near the bottom of all WINSS data pages. All data shown on the page are included in the download file plus additional related data (e.g. counts and codes) that might be useful for analysis purposes but are not provided on-screen due to space limitations. Option 1 is the most customizable download option because rows in the download file are determined by choices you make above the WINSS graph/table. See CSV file layout below.
Option 2. Download data for all schools and districts statewide. A link to the file for this download option is provided near the bottom of most WINSS data pages. Option 2 was added in late 2011 and is similar to Option 1 except that rows are provided for every district and school statewide and more complete topic data are included in each download file. See "CSV file layout" and "Option 2" below.
Options 3 and 4 (described below) are two alternative sources of historical WINSS raw data. Files provided under Options 3 and 4 will not be updated. Option 2 will eventually replace Options 3 and 4 since it is a more complete source of both current and historical WINSS raw data.
Option 3. Direct links to selected statewide downloads. See below.
Option 4. Legacy download options. WINSS data downloads for all districts and schools in any user-selected CESA(s), previously available on the WINSS Download Options webpage, will continue to be available until 2012. Go to Legacy Download Options. For more information about accessing these legacy files see http://winss.dpi.wi.gov/data_readme.
These statewide files are designed for users wanting a single file containing all the WINSS data about a particular topic or question.
To get started follow these steps:
Step 1. Go to any WINSS data page or, on the "Tips for First-Time Users" webpage, click on a topic of interest to the right of the four main questions.
Step 2. Select the school year of interest from the "Year" options row above the graph. If you do not see the "Year" options, then select any "Compare To" option other than "Prior Years", and the "Year" options row should appear.
Step 3. Scroll to the bottom of the WINSS data page and click on the link labeled "Download all school and district data statewide."
Step 4. Click on "Open" to view the CSV file. You can open and view the download file in spreadsheet, data base, or other programs. You can also "Save" the file.
- Big Files. These files are large and may be slow to download. An effort was made to minimize the number of downloads required to obtain all data for any given topic or question. You should expect thousands if not tens of thousands of rows in each statewide download file. Some files have more than 50 columns. Do not refresh your browser while waiting for the download.
- Over 400 Districts and Over 2000 Schools. Expect rows for every district and, if school level data are reported, every public school in the state. See Data Analysis Section - Frequently Asked Questions for more information about schools included on WINSS.
- School Types. District data are disaggregated in separate rows by school type (elementary, middle/junior high, etc.) when school data are available for this purpose. Data are disaggregated by school type because data often vary substantially by school type. Users interested in district summary data for all schools combined (regardless of school type) should focus on rows with "summary" in the school_type column of the download file. District data by grade by school type combinations are not included due to the relationship between grade and school type. When district data are disaggregated by grade, only the school type "summary" is available in district rows of the download files.
- Topics with an Unusually Wide Range of User Options. When feasible, statewide files include topic data columns as if you were able to select multiple options on any given option row. This is to reduce the potential need for multiple downloads. Note that, to obtain all WINSS data for certain questions/topics, multiple downloads may still be required:
- All Topics with View By Options. For WINSS questions with "View By" options above the graph or table, the statewide file will reflect the student group variable you select (e.g. Race/Ethnicity, Economic Status, etc). Users wanting all student group variables in a single file can download a file for each view by option then combine the files by copying and pasting rows into a single file. This combining task usually takes only minutes since most statewide files for a topic have the same CSV layout.
- WSAS. Statewide files require selection of a specific "Subject" option. The statewide download link is not available for the "Subject: All Tested Subjects" option (timeout issues). Users wanting all tested subjects in a single file can download a file for each subject option then combine the files by copying and pasting rows into a single file.
- Discipline, School-Supported Activities, Money. Statewide files reflect the selected "Show" option above the graph or table: Suspension or Expulsion for discipline data, Extra/Co-curricular Activites or Community Activities for activities data, and Revenue per Member or Cost per Member for money data.
Each row/record of each WINSS download file includes fields or columns of data about a specific education agency, student group, and topic. All files about the same topic have the same layout so they can be combined using spreadsheet software by copying and pasting rows/records.
Education Agency. All files have a fixed set of education agency information: year, agency_key, agency_type, CESA, county, (athletic) conference_code, district_number, school_number, school_type, charter, district_name, and school_name. Agency_key, district_number, and school_number are assigned by DPI and are available in WINSS files to facilitate joining records across files. CESA, county, and athletic conference codes facilitate aggregation of WINSS data by WINSS users interested in data for a specific CESA, county, or athletic conference. In most files you will see the following agency_types: 03 = Districts, 04 = Public schools within district (includes charter schools other than 4C and 49), 4C = multi-district charter school (s. 118.40(3)(c), Wis. Stats., not chartering authority), and 49 = Nondistrict charter schools (s. 118.40(2r), Wis. Stats). These agency_types are subject to a wide range of state- and federally-mandated data collection requirements. Some data collections are only at the district level For these collections only district level data are available. Few data collection requirements apply to other types of educational agencies including private schools. Because WINSS combines data across collections, private school data are not reported on WINSS.
Student Group. Student group information varies by topic because its relevance and availability varies by topic. When disaggregated student data are available, the download file reflects the option you select on the "View By" row above WINSS graphs/tables. Grade_label is the grade range of the relevant data collection or a specific grade within that range. All data about students included in each row are limited to students enrolled in the grade or grade range identified by the grade_label regardless of school_type or agency_type.
Topic. Topic information varies by WINSS question or topic within a question. For example, "What percent of students attend school each day?" includes total_fall_enrollment_pk-12, actual_days_of_attendance, possible_days_of_attendance, and attendance_rate. "What percent of students did not advance to the next grade level? " includes total_fall_enrollment_k-12, completed_school_term, number_of_retentions, and retention_rate. All the data included in WINSS graphs and on-screen tables are available in these download files. In addition, counts used in calculation of averages, rates, or percents will be included in these files if left off WINSS graphs/on-screen tables due to lack of space (not for privacy reasons). These are public files so some topic data are suppressed to protect student privacy.
- Some spreadsheet software will remove leading zeroes used in joining files. If you want to maintain leading zeros in the agency_key, district_number, school_number, and/or agency_type fields, then refer to instructions.
- To download fully disaggregated data for any topic, users will need to download a separate file for each View By option. View By options appear above the graph/table whenever disaggregated data are available.
- Does the file contain more rows/records than you want? You can use Excel to highlight the row containing fieldnames then select Data->Filter-> to view or copy rows of interest.
Note: This option will be phased out in 2012. All current and historical district and school data for the topics listed below are downloadable under Option 2.
Download a single file for all districts and schools in the state (all CESAs combined) by clicking on one of the links below:
- ACT Results 2008-09, 2009-10, 2010-11 (2.5 MB).
- Advanced Placement Program ® Exams 2009-10
- High School Graduation / Completion 2007-08, 2008-09, 2009-10 (10 MB).
- Attendance 2007-08, 2008-09, 2009-10** (2 MB).
- Truancy 2009-10** (1 MB).
- Dropouts 2008-09, 2009-10** (2 MB).
- Fall Enrollment* by Gender and Race/Ethnicity 2008-09, 2009-10, 2010-11 (gender only), 2010-11 (race/ethnicity only) (1 MB)
- Fall Enrollment* by Primary Disability 2008-09, 2009-10, 2010-11 (1 MB)
- Fall Enrollment* by Economic Status 2008-09, 2009-10, 2010-11(1 MB).
- Fall Enrollment* by English Proficiency Status 2008-09, 2009-10, 2010-11 (1 MB).
*Fall enrollment is as of the 3rd Friday of September. Counts may differ from those taken on different dates.
**Attendance, dropout, and truancy data files for 2009-10 include only district level data.
Attendance, dropouts, and graduation/completion data in statewide files for 2008-09 and earlier years are fully disaggregated by gender, race/ethnicity, disability status, economic status, and English proficiency for each school and district in the state.
Legacy download options
Data Analysis Section - frequently asked questions
Tips for first-time users of the Data Analysis Section
Tips for using WINSS to find test results for your school
More download options from the DPI
We welcome your questions, comments, and suggestions about WINSS.