D CSPR EdFacts Crosswalk

SY 2007-08 CSPR & EDFacts Data Crosswalk (based on SY 2006-07 EDFacts utilization) (8/20/08)
CSPR		EDFacts					Comment
#	Question	File Spec	Data Group	Category Set	Reporting Level	Populate
1.2.1	Participation of Students in Math Assessment	N/X081	588	Subtotal 1, A - F	SEA	Mandatory
1.2.3	Participation of Students in Reading/Language Arts Assessment	N/X081	589	Subtotal 1, A - F	SEA	Mandatory
1.3.1	Student Achievement - Math	N/X075	583	Subtotal 1, A - F	SEA	Initial
1.3.2	Student Achievement – Reading/LA	N/X078	584	Subtotal 1, A - F	SEA	Initial
1.4.1	All Schools & Districts Accountability	N/X103	32		School & District	Mandatory
1.4.2	Title I School Accountability	N/X129 N/X103	22 32		School	Mandatory
1.4.3	Districts that Received Title I Funds	N/X103	32 & 582		District	Mandatory
1.4.9.1.2	Public School Choice - Students	N/X010	574 & 544		SEA	Initial (rows 2 & 3)	Row 1 is manual entry
1.4.9.1.3	Funds Spent on Public School Choice	N/X131	652		District	Initial
1.4.9.2.2	Supplemental Educational Services – Students	N/X128	578, 575, 546		SEA	Initial
1.4.9.2.3	Funds Spent on Supplemental Educational Services	N/X131	651		District	Initial
1.6.2.2	LEP Students who Received Title III LIEP Services	N/X116	648	A	SEA	Initial	Subtotal of A
1.6.5.1	Immigrant Students	N/X045	519	Grand Total	SEA	Initial	1st column
1.8.1	Graduation Rates (SY 2006-07)	N/X041	563	Grand Total, A - F	SEA	Initial
1.9.2.1	Homeless Children & Youths Served by McKinney-Vento Subgrants	N/X043	560	A	SEA	Initial
1.9.2.2	Subpopulations of Homeless Students Served	N/X043	560	B - E	SEA	Initial
1.9.2.5.1	Reading Assessment (Homeless)	N/X078	584	G	SEA	Initial
1.9.2.5.2	Math Assessment (Homeless)	N/X075	583	G	SEA	Initial
1.10.1	Category 1 Child Count (Migrant)	N/X121	634	Subtotal 1 minus (under 3yr olds)	SEA	Initial
1.10.2	Category 2 Child Count (Migrant)	N/X122	635	A	SEA	Initial
2.1.1.1	Student Achievement in Math in SWP	N/X075 N/X129	583 22		School	Initial
2.1.1.2	Student Achievement in Reading/LA in SWP	N/X078 N/X129	584 22		School	Initial
		2.1.1.3	Student Achievement in Math in TAS	N/X075 N/X129	583 22		School	Initial
				2.1.1.4	Student Achievement in Reading/LA in TAS	N/X078 N/X129	584 22		School	Initial
2.1.2.1	Student Participation in Public Title I, Part A by Special Services or Programs	N/X037	548			B – D	SEA	Mandatory
2.1.2.2	Student Participation in Public Title I, Part A by Racial/Ethnic Group	N/X037	548			A	SEA	Mandatory
2.1.2.3	Student Participation in Public Title I, Part A by Grade Level	N/X134	670	A	SEA	Mandatory
2.1.2.4.1	Student Participation in Public Title I, Part A TAS by Instructional Services	N/X036	549	A	SEA	Mandatory
2.1.2.4.2	Student Participation in Public Title I, Part A TAS by Support Services	N/X036	549	B	SEA	Mandatory
2.3.1.1	Eligible Migrant Children	N/X121	634	Subtotal 1 (ages birth - 2)	SEA	Initial	Remainder of data are populated from 1.10.1.
2.3.1.2	Priority for Services – all eligible migrant children	N/X121	634	B	SEA	Initial
2.3.1.3	Limited English Proficient – all eligible migrant children	N/X121	634	C	SEA	Initial
2.3.1.4	Children with Disabilities (IDEA) – all eligible migrant children	N/X121	634	D	SEA	Initial
2.3.2.1	Dropouts (Migrants) – all eligible migrant children	N/X032	326	E	SEA	Initial
2.3.2.3.1	Reading/LA Participation – all eligible migrant children	N/X081	589	F	SEA	Initial	Subject = reading
2.3.2.3.2	Math Participation – all eligible migrant children	N/X081	588	F	SEA	Initial	Subject = math
2.3.3.1.1	Served – Regular SY (Migrant)	N/X123	636	A	SEA	Initial
2.3.3.1.2	Priority for Services – Regular SY (Migrant)	N/X123	636	B	SEA	Initial
2.3.3.2.1	Served – Summer/intersession (Migrant)	N/X124	637	A = Summer/ Intersession	SEA	Initial
2.3.3.2.2	Priority for Services – Summer/intersession (Migrant)	N/X124	637	B	SEA	Initial
2.3.3.3	MEP Participation - Program Year	N/X054	102	A	SEA	Initial
2.3.4.1	Schools and Enrollment	N/X132	110		School	Initial
2.3.4.2	Schools Where MEP Funds were Consolidated in SWP	N/X132	110 & 514		School	Initial	If yes
			2.3.6.1.2		MEP Staff	N/X065	515 & 625	A	SEA	Initial
2.4.1.2	Students Served – Subpart 1	N/X119	656	Subtotal 1	SEA	Initial	Chart 1; row 1
2.4.1.2	Students Served – Subpart 1	N/X135	672	A	SEA	Initial	Chart 1;row 2
2.4.1.2	Students Served – Subpart 1	N/X119	656	A	SEA	Initial	Chart 2
2.4.1.2	Students Served – Subpart 1	N/X119	656	B	SEA	Initial	Chart 3
2.4.1.2	Students Served – Subpart 1	N/X119	656	C	SEA	Initial	Chart 4
2.4.1.6.1	Academic Performance in Reading – Subpart 1	N/X135 N/X135 N/X113	672 672 628	B = below A = both A	SEA	Initial	Chart 1, row 1; Chart 1, row 2; Chart 2 Subj = reading
2.4.1.6.2	Academic Performance in Math – Subpart 1	N/X135 N/X135 N/X113	672 672 628	B = below A = both A	SEA	Initial	Chart 1, row 1; Chart 1, row 2; Chart 2 Subj = math
2.4.2.6.1	Academic Performance in Reading – Subpart 2	N/X135 N/X135 N/X125	671 671 629	B = below A = both A	District	Initial	Chart 1, row 1; Chart 1, row 2; Chart 2 Subj = reading
2.4.2.6.2	Academic Performance in Math – Subpart 2	N/X135 N/X135 N/X125	671 671 629	B = below A = both A	District	Initial	Chart 1, row 1; Chart 1, row 2; Chart 2 Subj = math