Download State and Local Item Analysis Summaries
Tab-Delimited Format
1998-99 through 2013-14
Item Analysis Summaries give information about state, district, and school performances on WKCE test items. State, district and school item analysis data are available for downloading in tab-delimited format at this site. The tab-delimited files are included in one zipped self-extracting file for, for each grade tested. Each self-extracting file is approximately 1-12 MB. There are also self-extracting files containing the item analysis for all subjects and grades. These files are approximately 12-50 MB.
2013-14
All Grades in a single Tab-Delimited File (45MB)
Grade 3(5MB)
Grade 4 (11MB)
Grade 5 (5MB)
Grade 6 (4MB)
Grade 7 (4MB)
Grade 8 (8MB)
Grade 10 (8MB)
2012-13
All Grades in a single Tab-Delimited File (45MB)
Grade 3(5MB)
Grade 4 (11MB)
Grade 5 (5MB)
Grade 6 (4MB)
Grade 7 (4MB)
Grade 8 (8MB)
Grade 10 (8MB)
2011-12
All Grades in a single Tab-Delimited File (45MB)
Grade 3(5MB)
Grade 4 (11MB)
Grade 5 (5MB)
Grade 6 (4MB)
Grade 7 (4MB)
Grade 8 (8MB)
Grade 10 (8MB)
2010-2011
All Grades in a single Tab-Delimited File (45MB)
Grade 3(5MB)
Grade 4 (11MB)
Grade 5 (5MB)
Grade 6 (4MB)
Grade 7 (4MB)
Grade 8 (8MB)
Grade 10 (8MB)
2009-2010
All Grades in a single Tab-Delimited File (45MB)
Grade 3(5MB)
Grade 4 (11MB)
Grade 5 (5MB)
Grade 6 (4MB)
Grade 7 (4MB)
Grade 8 (8MB)
Grade 10 (8MB)
2008-2009
All Grades in a single Tab-Delimited File (45MB)
Grade 3(5MB)
Grade 4 (11MB)
Grade 5 (5MB)
Grade 6 (4MB)
Grade 7 (4MB)
Grade 8 (8MB)
Grade 10 (8MB)
2007-2008
All Grades in a single Tab-Delimited File (45MB)
Grade 3(5MB)
Grade 4 (11MB)
Grade 5 (5MB)
Grade 6 (4MB)
Grade 7 (4MB)
Grade 8 (8MB)
Grade 10 (8MB)
All Files By Grade(44MB)
2004-2005
2003-2004
2002-2003
2001-2002
2000-2001
| Grade 4 Reading | Grade 8 Reading |
| Grade 4 Language Arts | Grade 8 Language Arts |
| Grade 4 Mathematics | Grade 8 Mathematics |
| Grade 4 Science | Grade 8 Science |
| Grade 4 Social Studies | Grade 8 Social Studies |
*Note there is no Item Analysis at grade 10 for the 2000-2001 school year.
To download, click on the file of interest to you, and save it in a directory on your computer. After downloading, navigate to the directory in which you saved the file. If you are using Windows, one way to navigate to the directory in which you saved the file is to find the file under "My Computer" (desktop icon). To unzip the file, double-click on the file name. The zipped file will automatically unzip creating two files: one for selected response and one for constructed response.
Each file is very large because there are over 2,000 public schools and over 400 school districts in Wisconsin. Unzipped file sizes range from 3 MB to 100 MB. Grade 4 files tend to be larger than grade 10 files because there are more elementary schools than high schools. The unzipped files containing all of the item analysis information are 90-300 MB.
Due to the number of rows in each file, you will need to select software that can handle up to 150,000 rows of data. More recent versions of Excel (2007) and Access , for example, can handle files of this size, but older versions cannot.
Note each zip file is organized in the same way. Each contains one constructed response (essay), and one selected response (multiple choice) tab-delimited file. Field headings for the different file types are defined in the following tables.
Constructed Response
| Column Order | Field Names | Field Descriptions |
|---|---|---|
| 1 | school_year | 1999 |
| 2 | cesa | Cooperative Educational Service Agencies (1-12) |
| 3 | organization_level | 1=State, 2=District,3=School |
| 4 | grade | 4,8 or 10 |
| 5 | district_number | District Number Assigned by DPI |
| 6 | school_number | School Number Assigned by DPI |
| 7 | district_name | District Name |
| 8 | school_name | School Name |
| 9 | item_type | SR=Selected Response CR=Constructed Response |
| 10 | objective_number | Number Corresponding to Content Area Tested |
| 11 | item_number | Number Corresponding to Specific Test Question |
| 12 | enrolled_in_grade | Number of Students Enrolled |
| 13 | subject | Reading,Language,Math,Science,Social Studies |
| 14 | objective_title | Academic Content Area Tested |
| 15 | item_descriptor | Specific Academic Content Descriptions |
| 16 | numb_responses_or_pts_possible | Number of Possible Points |
| 17 | correct_response_sr | Filler |
| 18 | percent_correct_or_avg_pts_nat | National Average Points Obtained |
| 19 | percent_correct_or_avg_pts_loc | Local Average Points Obtained |
| 20 | numb_answer_0_pts | Number Obtaining 0 Points |
| 21 | numb_answer_1_pts | Number Obtaining 1 Points |
| 22 | numb_answer_2_pts | Number Obtaining 2 Points |
| 23 | numb_answer_3_pts | Number Obtaining 3Points |
| 24 | numb_answer_4_pts | Number Obtaining 4 Points |
| 25 | numb_5_pts_cr | Number Obtaining 5 Points |
| 26 | numb_6_pts_cr | Number Obtaining 6 Points |
| 27 | numb_no_response | Number With No Response |
| 28 | numb_off_topic_cr | Number Off-Topic |
| 29 | percent_answer_0_pts | Percent Obtaining 0 Points |
| 30 | percent_answer_1_pts | Percent Obtaining 1 Points |
| 31 | percent_answer_2_pts | Percent Obtaining 2 Points |
| 32 | percent_answer_3_pts | Percent Obtaining 3 Points |
| 33 | percent_answer_4_pts | Percent Obtaining 4 Points |
| 34 | percent_5_pts_cr | Percent Obtaining 5 Points |
| 35 | percent_6_pts_cr | Percent Obtaining 6 Points |
| 36 | percent_no_response | Percent With No Response |
| 37 | percent_off_topic_cr | Percent Off-Topic |
| 38 | number tested | Number of Students Tested (New for 2002) |
Selected Response
| Column Order | Field Names | Field Descriptions |
|---|---|---|
| 1 | school_year | 1999 |
| 2 | cesa | Cooperative Educational Service Agencies (1-12) |
| 3 | organization_level | 1=State, 2=District, 3=School |
| 4 | grade | 4,8 or 10 |
| 5 | district_number | District Number Assigned by DPI |
| 6 | school_number | School Number Assigned by DPI |
| 7 | district_name | District Name |
| 8 | school_name | School Name |
| 9 | item_type | SR=Selected Response CR=Constructed Response |
| 10 | objective_number | Number Corresponding to Content Area Tested |
| 11 | item_number | Number Corresponding to Specific Test Question |
| 12 | enrolled_in_grade | Number of Students Enrolled |
| 13 | subject | Reading, Language,Math,Science,Social Studies |
| 14 | objective_title | Academic Content Area Tested |
| 15 | item_descriptor | Specific Academic Content Descriptions |
| 16 | numb_responses_or_pts_possible | Number of Possible Responses |
| 17 | correct_response_sr | Correct Response (1-5) |
| 18 | percent_correct_or_avg_pts_nat | National Percent Correct |
| 19 | percent_correct_or_avg_pts_loc | Local Percent Correct |
| 20 | number_answer_af | Number Answering A or F (1) |
| 21 | number_answer_bg | Number Answering B or G (2) |
| 22 | number_answer_ch | Number Answering C or H (3) |
| 23 | number_answer_dj | Number Answering D or J (4) |
| 24 | number_answer_ek | Number Answering E or K (5) |
| 25 | number_5_pts_cr | Filler |
| 26 | number_6_pts_cr | Filler |
| 27 | number_no_response | Number With No Response |
| 28 | number_off_topic_cr | Filler |
| 29 | percent_answer_af | Percent Answering A or F (1) |
| 30 | percent_answer_bg | Percent Answering B or G (2) |
| 31 | percent_answer_ch | Percent Answering C or H (3) |
| 32 | percent_answer_dj | Percent Answering D or J (4) |
| 33 | percent_answer_ek | Percent Answering E or K (5) |
| 34 | percent_5_pts_cr | Filler |
| 35 | percent_6_pts_cr | Filler |
| 36 | percent_no_response | Percent With No Response |
| 37 | percent_off_topic_cr | Filler |
| 38 | number tested | Number of Students Tested (New for 2002) |