You are here

Tab-Delimited Data Files Containing State and Local WKCE Item Analysis Data

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

Grade 4 Reading Grade 8 Reading Grade 10 Reading
Grade 4 Language Grade 8 Language Grade 10 Language
Grade 4 Mathematics Grade 8 Mathematics Grade 10 Mathematics
Grade 4 Science Grade 8 Science Grade 10 Science
Grade 4 Social Studies Grade 8 Social Studies Grade 10 Social Studies
      

2003-2004

Grade 4 Reading Grade 8 Reading Grade 10 Reading
Grade 4 Language Grade 8 Language Grade 10 Language
Grade 4 Mathematics Grade 8 Mathematics Grade 10 Mathematics
Grade 4 Science Grade 8 Science Grade 10 Science
Grade 4 Social Studies Grade 8 Social Studies Grade 10 Social Studies

2002-2003

Grade 4 Reading Grade 8 Reading Grade 10 Reading
Grade 4 Language Grade 8 Language Grade 10 Language
Grade 4 Mathematics Grade 8 Mathematics Grade 10 Mathematics
Grade 4 Science Grade 8 Science Grade 10 Science
Grade 4 Social Studies Grade 8 Social Studies Grade 10 Social Studies

2001-2002

Grade 4 Reading Grade 8 Reading Grade 10 Reading
Grade 4 Language Grade 8 Language Grade 10 Language
Grade 4 Mathematics Grade 8 Mathematics Grade 10 Mathematics
Grade 4 Science Grade 8 Science Grade 10 Science
Grade 4 Social Studies Grade 8 Social Studies Grade 10 Social Studies

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.


 

COLUMN HEADINGS USED IN THE TAB-DELIMITED FILES


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 numbertested Number of Students Tested (New for 2002)

 

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