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

Download State and Local Item Analysis Summaries

Tab-Delimited Format
1998-99 thru Present

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.

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
	All Item Analysis Reports	State Level Item Analysis Reports

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
	All Item Analysis Reports	State Level Item Analysis Reports

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
	All Item Analysis Reports	State Level Item Analysis Reports

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
State Level Item Analysis	All Subjects Grades 4 and 8

*Note there is no Item Analysis at grade 10 for the 2000-2001 school year.

1999-2000

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
	All Item Analysis Reports	State Level Item Analysis Reports

1998-1999

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
	All Item Analysis Reports

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	numbertested	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 oeamail@dpi.wi.gov

Last updated on 4/26/2012 2:57:29 PM