Tab Delimited Data Layout 1997-2002

Wisconsin Knowledge and Concepts Examinations (WKCE)

Proficiency Summary Data File Layout

Tab-Delimited Format
1997-98, 1998-99, 1999-2000, 2000-2001, 2001-2002

---

Note each tab-delimited file is organized in the same way for each grade and year. Not all columns (fields) are available for each year.

Column Order	Field Names	Field Descriptions	1997-98 (Oct)	1998-99 (Feb)	1999-00 (Feb)	2000-01 (Feb)	2001-02 (Feb)
1	Agncy_Tp	Type of Organization, e.g. ,CESA, District, County, Public School, Private School, etc.				x	x
2	Agncy_Ky	A value that uniquely identifies an organization for a given year.				x	x
3	Year	Academic Year				x	x
4	CESA	Cooperative Educational Service Agencies (codes 1-12)	x	x	x	x	x
5	OrgLevel	Organizational Level: 1=State, 2=District, or 3=School	x	x	x	x	x
6	Grade	4, 8, or 10	x	x	x	x	x
7	DistNumb	District Number Assigned by DPI	x	x	x	x	x
8	SchlNumb	School Number Assigned by DPI	x	x	x	x	x
9	StudGrp#	Student Group Codes 1 through 28 (see column 12)	x	x	x	x	x
10	DistName	District Name	x	x	x	x	x
11	SchlName	School Name	x	x	x	x	x
12	StudGrp	Student Group in Words	x	x	x	x	x
13	Blank	[StudGrp 11-28 in District and School Reports include only students enrolled for a FAY]				x	x
14	Enrolled	Number of Students Enrolled in Group	x	x	x	x	x
15	#Incl%s	Number of Students Included in Calculating Percents [Partial district-level reporting by student group may be necessary to prevent indirect disclosure of confidential data.]	x	x	x	x	x
16	Excl_Rdg	Number of S/DIS or S/LEP Excluded from WKCE Reading Test. [Counted in this field are (a) students with disabilities who are excluded from the WKCE Reading Test because they are not able to demonstrate at least some of the knowledge and skills on the test with allowable accommodations(Pre-Requisite Skill) and (b) students whose first language is not English and whose academic English skills are not sufficient to take the WKCE Reading Test with allowable language accommodations (Pre-Requisite English). Beginning in 1999-00, these excluded students were required to take locally-adopted WSAS Alternate Assessments in Reading.]		x	x	x	x
17	ExcusRdg	Number of Students Excused from WKCE by Parent		x	x	x	x
18	Elig_Rdg	Number of Students Eligible to be Tested in Reading (Not Excluded or Excused)		x	x	x	x
19	%NT_Rdg	For 1997-98 and 1998-99: % of Students Enrolled Not Tested on the WKCE Reading Test. For 1999-00 and beyond: % of Students Enrolled Not Tested on the WKCE Reading Test and Not Taking WSAS Alternate Assessments in Lieu of WKCE.	x	x	x	x	x
20	%NT_RdgE	% of Eligible Students Enrolled Not Tested on the Reading Test		x	x	x	x
21	%Alt_Rdg	For 1999-00 and beyond: % of Students Taking Locally-Adopted Alternate Assessments in Reading in Lieu of WKCE Reading Test. This is the same as the % of students in the Pre-Req Skill/Eng category. [See Excl_Rdg.]			x	x	x
22	%Min_Rdg	% of Enrolled Who Scored in the Min Category on the WKCE Reading Test	x	x	x	x	x
23	%Min_RdE	% of Eligibles Who Scored in the Min Category on the WKCE Reading Test		x	x	x	x
24	%Bas_Rdg	% of Enrolled Who Scored in the Bas Category on the WKCE Reading Test	x	x	x	x	x
25	%Bas_RdE	% of Eligibles Who Scored in the Bas Category on the WKCE Reading Test		x	x	x	x
26	%Prf_Rdg	% of Enrolled Who Scored in the Prf Category on the WKCE Reading Test	x	x	x	x	x
27	%Prf_RdE	% of Eligibles Who Scored in the Prf Category on the WKCE Reading Test		x	x	x	x
28	%Adv_Rdg	% of Enrolled Who Scored in the Adv Category on the WKCE Reading Test	x	x	x	x	x
29	%Adv_RdE	% of Eligibles Who Scored in the Adv Category on the WKCE Reading Test		x	x	x	x
30	Excl_Lng			x	x	x	x
31	ExcusLng			x	x	x	x
32	Elig_Lng			x	x	x	x
33	%NT_Lng			x	x	x	x
34	%NT_LngE			x	x	x	x
35	%Alt_Lng				x	x	x
36	%Min_Lng		x	x	x	x	x
37	%Min_LnE			x	x	x	x
38	%Bas_Lng		x	x	x	x	x
39	%Bas_LnE			x	x	x	x
40	%Prf_Lng		x	x	x	x	x
41	%Prf_LnE			x	x	x	x
42	%Adv_Lng		x	x	x	x	x
43	%Adv_LnE			x	x	x	x
44	Excl_Mth			x	x	x	x
45	ExcusMth			x	x	x	x
46	Elig_Mth			x	x	x	x
47	%NT_Math		x	x	x	x	x
48	%NT_MthE			x	x	x	x
49	%Alt_Mth				x	x	x
50	%Min_Math		x	x	x	x	x
51	%Min_MtE			x	x	x	x
52	%Bas_Math		x	x	x	x	x
53	%Bas_MtE			x	x	x	x
54	%Prf_Mth		x	x	x	x	x
55	%Prf_MthE			x	x	x	x
56	%Adv_Mth		x	x	x	x	x
57	%Adv_MtE			x	x	x	x
58	Excl_Scn			x	x	x	x
59	ExcusScn			x	x	x	x
60	Elig_Scn			x	x	x	x
61	%NT_Scn		x	x	x	x	x
62	%NT_ScnE			x	x	x	x
63	%Alt_Scn				x	x	x
64	%Min_Scn		x	x	x	x	x
65	%Min_SnE			x	x	x	x
66	%Bas_Scn		x	x	x	x	x
67	%Bas_SnE			x	x	x	x
68	%Prf_Scnc		x	x	x	x	x
69	%Prf_SnE			x	x	x	x
70	%Adv_Scn		x	x	x	x	x
71	%Adv_SnE			x	x	x	x
72	Excl_Soc			x	x	x	x
73	ExcusSoc			x	x	x	x
74	Elig_Soc			x	x	x	x
75	%NT_Soc		x	x	x	x	x
76	%NT_SocE			x	x	x	x
77	%Alt_Soc				x	x	x
78	%Min_Soc		x	x	x	x	x
79	%Min_SoE			x	x	x	x
80	%Bas_Soc		x	x	x	x	x
81	%Bas_SoE			x	x	x	x
82	%Prf_Soc		x	x	x	x	x
83	%Prf_SoE			x	x	x	x
84	%Adv_Soc		x	x	x	x	x
85	%Adv_SoE			x	x	x	x
86	WrtgHol	Mean Holistic Writing Score (not available by student group)		x	x	x	x
87	NPR_Rdg	National Percentile Rank of the Mean NCE Score for Students Tested in Reading	x	x	x	x	x
88	NPR_Lng	. . . and so on for each subject (not available by student group)	x	x	x	x	x
89	NPR_Math		x	x	x	x	x
90	NPR_Scn		x	x	x	x	x
91	NPR_Soc		x	x	x	x	x

<

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

Last updated on 9/19/2007 8:39:20 AM