U.S. DEPARTMENT OF EDUCATION
Education Data Exchange Network (EDEN)
N075 - Academic Achievement in Mathematics File Specifications
Version 5.1
SY 2008-09
October 2009
U.S. DEPARTMENT OF EDUCATIONN075 – Academic Achievement in Mathematics
File Specifications v5.1
This technical guide was produced under U.S. Department of Education Contract No. GS00F0049M-ED05P01299 with Perot Systems Government Services, Inc. Brandon Scott served as the contracting officer’s representative. No official endorsement by the U.S. Department of Education of any product, commodity, service or enterprise mentioned in this publication is intended or should be inferred.
U.S. Department of Education
Arne Duncan
Secretary
Office of Planning, Evaluation and Policy Development
Carmel Martin
Assistant Secretary
October 2009
This technical guide is in the public domain. Authorization to reproduce it in whole or in part is granted. While permission to reprint this publication is not necessary, the citation should be: U.S. Department of Education, Office of Planning, Evaluation and Policy Development, N075 - Academic Achievement in Mathematics File Specifications, Washington, D.C., 2009.
This technical guide is also available on the Department’s Web site at:
On request, this publication is available in alternate formats, such as Braille, large print, or computer diskette. For more information, please contact the Department’s AlternateFormatCenter at (202) 260-0852 or (202) 260-0818.
DOCUMENT CONTROL
DOCUMENT INFORMATION
Title: / N075 - Academic Achievement in Mathematics File SpecificationsRevision: / Version 5.1
Issue Date: / October 2009
Security Level: / Unclassified – For Official Use Only
Filename: / N075 - Academic Achievement in Math v5.1.doc
DOCUMENT HISTORY
Version Number / Date / Summary of Change1.0 / Version 1.0 or subsequent updates (i.e., 1.1, 1.2, etc.) of this file specification is used to build files for SYs 2003-04 and 2004-05.
2.0 / Version 2.0 or subsequent updates (i.e., 2.1, 2.2, etc.) of this file specification is used to build files for SY 2005-06.
3.0 / Version 3.0 or subsequent updates (i.e., 3.1, 3.2, etc.) of this file specification is used to build files for SY 2006-07.
4.0 / Version 4.0 or subsequent updates (i.e., 4.1, 4.2, etc.) of this file specification is used to build files for SY 2007-08.
5.0
State Review Version / June 2009 /
- To accurately describe the data, changed name of file and data group from “student performance” to “academic achievement”
- Updated for SY 2008-09.
- Replaced category Race/Ethnicity with new category Major Racial Ethnic group.
- Renamed category Economic Disadvantaged Status to Economically Disadvantaged Status.
- Definition of category Full Year Academic Status has been modified.
- Replaced "grand total" with "total of the education unit" throughout document.
- 1.0 – Revised language in paragraph on information requirement in file
- 1.2 and 2.0 – Updated and reorganized guidance
5.0
Final / July 2009 /
- 7.0 – Added Appendix EDFacts – CSPR Crosswalk
5.1 / October 2009 /
- 7.0 – Updated Appendix – EDFacts – CSPR Crosswalk
RELEASE AUTHORIZATION
Name / Signature / DateAuthor
QA
Release Authority
PREFACE
This document provides technical instructions for building files that can be submitted through the Education Data Exchange Network (EDEN). This document is used in coordination with the EDFacts Workbook, EDFactsBusiness Rules Guide and the EDEN Submission System User Guide.
EDEN is a centralized, coordinated repository of state reported, K through 12, educational data residing at the U.S. Department of Education. The EDEN Submission System is an electronic system that facilitates the efficient and timely transmission of data from SEAs to the U.S. Department of Education.
Contents
DOCUMENT CONTROL
PREFACE
1.0PURPOSE
1.1Changes from the SY 2007-08 File Specifications
1.2Requirements for Submitting this Data Group
2.0GUIDANCE FOR SUBMITTING THIS FILE
2.1Grade Level
2.2Performance Level
2.3Full Academic Year Status
2.4Major racial and Ethnic Groups
2.5Sex (Membership)
2.6Disability status (only)
2.7LEP Status (Only)
2.8Economically Disadvantaged Status
2.9Migrant Status
2.10Homeless Served Status
3.0FILE NAMING CONVENTION
3.1Population Status
4.0SEA ACADEMIC ACHIEVEMENT IN MATHEMATICS FILE
4.1Header Record Definition
4.2Data Record Definition
4.3SEA Academic Achievement in Mathematics File Examples
4.3.1Partial Record Sample for Fixed Format SEA Academic Achievement in Mathematics File
4.3.2Partial Record Sample for Comma-Delimited File Format SEA Academic Achievement in Mathematics File
4.3.3Partial Record Sample for Tab-Delimited File Format SEA Academic Achievement in Mathematics File
5.0LEA ACADEMIC ACHIEVEMENT IN MATHEMATICS FILE
5.1Header Record Definition
5.2Data Record Definition
5.3LEA Academic Achievement in Mathematics File Examples
5.3.1Partial Record Sample for Fixed Format LEA Academic Achievement in Mathematics File
5.3.2Partial Record Sample for Comma-Delimited File Format LEA Academic Achievement in Mathematics File
5.3.3Partial Record Sample for Tab-Delimited File Format LEA Academic Achievement in Mathematics File
6.0SCHOOL ACADEMIC ACHIEVEMENT IN MATHEMATICS FILE
6.1Header Record Definition
6.2Data Record Definition
6.3School Academic Achievement in Mathematics File Examples
6.3.1Partial Record Sample for Fixed Format School Academic Achievement in Mathematics File
6.3.2Partial Record Sample for Comma-Delimited File Format School Academic Achievement in Mathematics File
6.3.3Partial Record Sample for Tab-Delimited File Format School Academic Achievement in Mathematics File
7.0APPENDIX - EDFACTS – CSPR CROSSWALK
October 2009 / 1 / SY 2008-09U.S. DEPARTMENT OF EDUCATIONN075 – Academic Achievement in Mathematics
File Specifications v5.1
1.0PURPOSE
This document contains instructions for building fixed and delimited files to submit EDFacts Data Group: Academic Achievement in Mathematics Table, DG583. The definition for this data group is in the row “Table Name” in Table 4.2-1.
The data collected using this file specification are used to monitor and report performance on programs and activities supported by the Elementary and Secondary Education Act, as amended. These data will be used as responses in the Consolidated State Performance Report (CSPR).
A separate document contains the XML file formats. General guidance for constructing all file types may be found in the EDFacts Workbook.
1.1Changes from the SY 2007-08 File Specifications
The guidance has been updated and other editorial changes have been made.
- Updated for SY 2008-09.
- Replaced category Race/Ethnicity with new category Major Racial Ethnic group.
- Renamed category Economic Disadvantaged Status to Economically Disadvantaged Status.
- Definition of category Full Year Academic Status has been modified.
- Replaced "grand total" with "total of the education unit" throughout document.
1.2Requirements for Submitting this Data Group
This section contains two tables that summarize the reporting requirements. The first table contains the reporting period, the education units included or excluded, the type of count, and zero count reporting. The second table contains the required categories and applicable totals.
Table 1.2-1 Academic Achievement in Mathematics, Core Reporting Requirements
SEA / LEA / SchoolReporting Period / State-specific assessment testing window
Education units reported / Include SEA / Operational LEAs that had students during the assessment testing window / Operational schools that had students during the assessment testing window
Education units not reported / Closed, inactive, or future LEAs / Closed, inactive, or future schools
Count / Once / Onceat LEAwhere student was assessed / Only atschool where student was assessed
Zero counts / Required / Not required[*] / Not required*
The following table indicates the valid combinations of categories and the subtotals and/or totals needed for this file. An “X” in the column indicates that the column must be populated when reporting that particular category. The total indicator must be either “Y” (Yes) or “N” (No). If the record is for a detail count, specify an “N” (No). If the record is for a subtotal or education unit total, specify a “Y” (Yes).
Table 1.2-1: Academic Achievement in Mathematics Table, Required Categories, and Applicable Totals
Category Set / Table Name / Grade Level (Assessment) / Performance Level / Full Academic Year Status / Major Racial Ethnic Group / Sex (Membership) / Disability Status (Only) / LEP Status (Only) / Economically Disadvantaged Status / Migrant Status / Homeless Served Status / Total Indicator / CommentsCategory Set A / STUDPERFM / X / X / X / X / N / Student Count by Grade Level (Assessment), Performance Level, Full Academic Year Status andMajor Racial Ethnic Group
Category Set B / STUDPERFM / X / X / X / X / N / Student Count by Grade Level (Assessment), Performance Level, Full Academic Year Status and Sex (Membership)
Category Set C / STUDPERFM / X / X / X / X / N / Student Count by Grade Level (Assessment), Performance Level, Full Academic Year Status and Disability Status (Only)
Category Set D / STUDPERFM / X / X / X / X / N / Student Count by Grade Level (Assessment), Performance Level, Full Academic Year Status and (LEP Status Only)
Category Set E / STUDPERFM / X / X / X / X / N / Student Count by Grade Level (Assessment), Performance Level, Full Academic Year Status andEconomically Disadvantaged Status
Category Set F / STUDPERFM / X / X / X / X / N / Student Count by Grade Level (Assessment), Performance Level, Full Academic Year Status and Migrant Status
Category Set G / STUDPERFM / X / X / X / X / N / Student Count by Grade Level (Assessment), Performance Level, Full Academic Year Status and Homeless Served Status
Subtotal 1 / STUDPERFM / X / X / X / Y / Student Count by Grade Level (Assessment), Performance Level and Full Academic Year Status
2.0GUIDANCE FOR SUBMITTING THIS FILE
This file specification is used to collect the results of state assessments for all students who received a valid score and were assigned a proficiency level in mathematicsthat were administeredduring the testing window.
The guidance below is in question and answer format. The initial questions cover the scope of the data included in the file. After the initial questions, the questions are arranged by the categories used in the file.
Which students should be reported in this file?
Include all students who received a valid score and were assigned a proficiency level. This includes students who participated in regular assessments with or without accommodations; or alternate assessments including those based on grade level, modified, and alternate academic standards. Both students who were there for a full academic year and those not there for full academic year are also included in this file.
Are all students reported in all category sets?
No. All students should be reported in category set A (by racial ethnic) and B (by sex (membership)) and in the subtotal. For the other category sets, only include the students that meet the category being collected. For example, category set C collects information on children with disabilities (IDEA). Do not include students who do not meet that definition in category set C.
Do any other file specifications collect related data?
Yes. The matrix below illustrates the relationship between the data on the assessments and EDFacts data groups and files. This file collects data on academic achievement in mathematics.
Student ParticipationReading/Language Arts / Mathematics / Science
N/X081, DG589 / N/X081, DG588 / N/X081, DG590
Academic Achievement
Reading/Language Arts / Mathematics / Science
N/X078, DG584 / N/X075,IDG583 / N/X079, DG585
In addition, for Section 618 of the Individual with Disabilities Education Act (IDEA), EDFacts collects additional data on children with disabilities (IDEA). The table below describes the relationship between this file and the files that collect related data for Section 618 of IDEA.
Students reported in category set C in this file / N/X003 – These students are reported by the type of assessmentNote that SY 2008-09 assessment data are reported at different times. Assessment data for all students, including students with disabilities (IDEA), are submitted in December 2009 for the CSPR. The IDEA assessment data are submitted by February 1, 2010. If your state’s assessment data for students with disabilities (IDEA) differ, be prepared to substantiate the differences. This may require the resubmission of data for students with disabilities (IDEA) during the CSPR Part I correction period in February 2010.
2.1Grade Level
What grade levels should be reported?
Records for the LEAs and schools need only include those grade levels offered at the LEA or school. For example, if the highest grade at a school is 6th, the record for that school does not need to include grades 7th through 12th. Records should only include the grades assessed; that is, grades three through eight and one high school grade.
Why do the permitted values include both grades 9 through 12 as well as a value for “High School?”
The permitted values are provided so SEAs have more flexibility. For high school grades, assessment results can be reported by specific grade levels or by using the permitted value for high school. Data reported by specific grade levels (9, 10, 11, and 12) and high school will be used for reporting results of statewide assessments in high school.
How are assessment of students in grade 9 reported?
ESEA, as amended, requires assessments in grades 3 through 8 and high school. In ESEA, high school is explained as grades 10, 11, and 12. Students who took assessments in grade 9 should be reported either under grade 9 or as high school.
2.2Performance Level
What performance levels should be reported?
The performance levels used must be the same as the performance levels reported to ED in the crosswalk of state performance levels to federal proficiency. If you need to verify what performance levels were reported to ED in the crosswalk, contact the PartnerSupportCenter.
States will annually provide information about the name and number of performance levels and level of proficiency by assessment administered through EMAPS.
Level 1 must be the lowest level of performance. Use the other numbers (i.e., 2, 3, 4, 5, and 6) sequentially. Use only the numbers needed. For example, if a state has 4 performance levels, the state will use numbers 1, 2, 3, and 4. Number 1 will be the lowest level of performance and number 4 will be the highest level.
How do I get rid of the error: “Student Performance Level Numbers are not contiguous”?
This error message indicates that the file includes educational units that have some performance level counts, (L1, L2, L3…etc.) but not all. EDFacts expects that for each category included in the file, the list of performance levels will be contiguous, beginning with L1. Typically, this error message occurs when counts of zero are left out of the file. SEA submitters should make sure that each reported category has all levels used by the state represented, regardless of the total, to prevent this error from occurring.
For example, the state has 4 performance levels. A school in that state had no economically disadvantaged students scoring at levels 1, 2 and 4. The 55 economically disadvantaged students scored at level 3.
If the records are submitted as follows, the file will receive an error because levels 1 and 2 are missing.
100,06,01,123456,98765,STUDPERFM,05,,,,,,ECODIS,,,,L3,FULLYR,,N,,55
To avoid the error, the file must be submitted as follows:
100,06,01,123456,98765,STUDPERFM,05,,,,,,ECODIS,,,,L1,FULLYR,,N,,0
101,06,01,123456,98765,STUDPERFM,05,,,,,,ECODIS,,,,L2,FULLYR,,N,,0
102,06,01,123456,98765,STUDPERFM,05,,,,,,ECODIS,,,,L3,FULLYR,,N,,55
2.3Full Academic Year Status
Are students who were not present for the full academic year included?
Yes. Include both students who were present for the full academic year and those who were not present for the full academic year in this file. These data are used by a variety of sources, many of which do not differentiate on full year academic status.
2.4Major racial and Ethnic Groups
What are the permitted values for major racial and ethnic groups?
The permitted values are:
White (not Hispanic) / CaucasianBlack (not Hispanic) / African American
Hispanic / Latino
Hispanic (not Puerto Rican)
Puerto Rican
Asian
Asian / Pacific Islander
American Indian / Alaska Native / Native American
Multicultural / Multiethnic / Multiracial / Other
Filipino
Native Hawaiian / Other Pacific Islander / Pacific Islander
Which permitted values should be used?
States should use whichever permitted values best align with the major racial ethnic subgroups used to determine adequate yearly progress (AYP) as outlined in their State Accountability Plan.
2.5Sex (Membership)
There are no questions and answers specifically related to the category “sex (membership).”
2.6Disability status (only)
How are student counts reported by disability status (only)?
Report students who meet the definition of children with disabilities (IDEA) in section 4.2 of the EDFacts Workbook.
Do not include former children with disabilities (IDEA) in this category.
Do not include children with disabilities (IDEA) who were parentally-placed in private schools.
2.7LEP Status (Only)
How arestudent counts by LEP status (only) reported?
Include students who meet the definition of limited English proficient (LEP) students in section 4.3 of the EDFacts Workbook. Include recently arrived students who are LEP and who have attended schools in the U.S less than 12 months.
Do not include former LEP students in this category.
2.8EconomicallyDisadvantaged Status
There are no questions and answers specifically related to the category “economically disadvantaged status.”
2.9Migrant Status
How are student counts reported by migrant status?
Include students who meet the definition of eligible migrant students in section 4.4.1 of the EDFacts Workbook.
Do not include in this category students who are not eligible migrant children but participate in the Migrant Education Program under other provisions.
2.10Homeless Served Status
How are student counts reported by homeless served status?
Include students who received services under programs funded by the McKinney-Vento Program. Students receive services under that program because they have been identified as homeless.
Does homeless served status include all homeless students?
No. Report only homeless children and youths who received services under subgrants funded bythe McKinney-VentoProgram.
3.0FILE NAMING CONVENTION
Being able to readily identify any particular file transmission is an important consideration for users of the EDEN Data Submission System. Being able to identify a particular file can greatly facilitate any technical assistance that may be requested by the state. A maximum of 25 characters (including the file extension) is allowed for the file name. The following is the naming convention for Academic Achievement in Mathematics file submissions:
sslevSTUPERFMAvvvvvvv.ext
Where:
ss= Two-characterUSPSState Abbreviation for the submitting SEA.
lev= Three-character abbreviation for the level submitted. Use:
SEA for a State Education Agency Academic Achievementin Mathematics submission
LEA for a Local Education Agency Academic Achievementin Mathematics submission
SCH for a School Academic Achievementin Mathematics submission