U.S. DEPARTMENT OF EDUCATION X159 - Average Scale Scores
XML Specifications v7.1
U.S. DEPARTMENT OF EDUCATION
Education Data Exchange Network (EDEN)
X159 – Average Scale Scores
File Specifications
Version 7.1
SY 2010-11
November 2011
This technical guide was produced under U.S. Department of Education Contract No. ED-PEP-09-O-0044 with 2020 Company, LLC. 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
November 2011
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, X159 – Average Scale Scores XML Specifications, Washington, D.C., 2011.
This technical guide is also available on the Department’s Web site at: http://www.ed.gov/edfacts
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 Alternate Format Center at (202) 260-0852 or (202) 260-0818.
DOCUMENT CONTROL
DOCUMENT INFORMATION
Title: / X159 - Average Scale Scores XML SpecificationsRevision: / Version 7.1
Issue Date: / November 2011
Security Level: / Unclassified – For Official Use Only
Filename: / x159-7-1.doc
DOCUMENT HISTORY
Version Number / Date / Summary of Change /7.0 / August 2011 / Initial version (The N version was distributed for state review. Several changes were made based on state comments.)
7.1 / November 2011 / 2.2 – Under the section on “assessment administered (scale score), revised the response to the question “what permitted values are used” to remove the permitted value English language proficiency assessment. The list of permitted values in the record layout in section 4.2 was correct.
RELEASE AUTHORIZATION
Name / Signature / DateAuthor
QA
Release Authority
PREFACE
This document provides technical instructions for building files that are submitted through the Education Data Exchange Network (EDEN) Submission System (ESS). 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.
This document is to be used in coordination with other documentation including the EDEN Submission System User Guide and the Business Rules Guide.
Data submitted through the ESS is authorized by an Annual Mandatory Collection of Elementary and Secondary Education Data Through EDFacts (OMB 1875-0240, expires 9/30/2013). EDFacts is a U.S. Department of Education (ED) initiative to govern, acquire, validate, and use high-quality, kindergarten through grade 12 (K–12) performance data for education planning, policymaking, and management and budget decisionmaking to improve outcomes for students. EDFacts centralizes data provided by SEAs, LEAs and schools, and provides users with the ability to easily analyze and report data. This initiative has significantly reduced the reporting burden for state and local data producers, and has streamlined data collection, analysis and reporting functions at the federal, state and local levels.
November 2011 / 12 / SY 2010-11
U.S. DEPARTMENT OF EDUCATION X159 - Average Scale Scores
XML Specifications v7.1
Contents
DOCUMENT CONTROL iii
PREFACE iv
1.0 PURPOSE 1
1.1 Changes from the SY 2009-10 File Specifications 1
1.2 Requirements for Submitting this File 1
2.0 GUIDANCE FOR SUBMITTING THIS FILE 4
2.1 Academic Subject 5
2.2 Assessment Administered (Scale score) 5
2.3 Grade Level 5
2.4 Major racial and ethnic groups 6
2.5 Sex (Membership) 7
2.6 Disability status (only) 7
2.7 LEP Status (only) 7
2.8 Economically disadvantaged status 8
2.9 Migrant status 8
3.0 FILE NAMING CONVENTION 9
3.1 XML Specification Headings 9
4.0 SCHOOL AVERAGE SCALE SCORE OBJECTS 10
4.1 Category XML Object 10
4.2 Table Type XML Object 13
4.3 Agency XML Object 14
4.4 File Transmit XML Object 15
5.0 Revised! APPENDIX: Submitting SY 2009-10 Baseline Data 16
November 2011 / 12 / SY 2010-11
U.S. DEPARTMENT OF EDUCATION X159 - Average Scale Scores
XML Specifications v7.1
1.0 PURPOSE
This document contains instructions for building fixed and delimited files to submit the EDFacts data groups:
· Average scale scores table, DG730
· Achievement percentile table, DG751
The data collected using this file specification are used to monitor and report performance on the School Improvement Grant (SIG) program, authorized under section 1003(g) of the Elementary and Secondary Education Act (ESEA) of 1965 as amended.
A separate document contains the non-XML file formats. General guidance for constructing all file types may be found in the EDFacts Workbook.
The appendix contains instructions on how this file specification can be used to submit baseline data from SY 2009-10
1.1 Changes from the SY 2009-10 File Specifications
Not applicable - This is a new file specification.
1.2 Requirements for Submitting this File
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 Average Scale Scores/Achievement Percentile Tables, Core Reporting Requirements
/ SEA / LEA / School /Reporting Period / State-specific assessment testing window
Education units reported / File not submitted at the SEA level / File not submitted at LEA level / Tier I and Tier II schools that implemented the restart, transformation, or turnaround school intervention models and were served with SIG funds
Education units not reported / · Closed, inactive, or future schools
· Schools that were not Tier I or Tier II schools
· Tier I or Tier II schools that were not served with SIG funds
· Tier I or Tier II schools that implemented the closure model
· Tier III schools that are served with SIG funds
Count / See guidance “What data are reported in the field ’scale score’”
Zero counts / 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–2: Average Scale Scores/Achievement Percentiles Tables, Required Categories, and Applicable Totals
Category Set / Table Name / Academic Subject(Assessment) / Assessment Administered
(Scale score) / Achievement Percentile / Grade Level (Assessment) / Major Racial and Ethnic Group / Sex (Membership) / Disability Status (Only) / LEP Status (Only) / Economically Disadvantaged Status / Migrant Status / Total Indicator / Comments /
DG730
Category Set A / AVESCASCO / X / X / X / X / N / Scale scores by Academic Subject, Assessment Administered (Scale score), Grade Level, and Major Racial and Ethnic Group
DG730
Category Set B / AVESCASCO / X / X / X / X / N / Scale scores by Academic Subject, Assessment Administered (Scale score), Grade Level, and Sex
DG730
Category Set C / AVESCASCO / X / X / X / X / N / Scale scores by Academic Subject, Assessment Administered (Scale score), Grade Level, and Disability Status (Only)
DG730
Category Set D / AVESCASCO / X / X / X / X / N / Scale scores by Academic Subject, Assessment Administered (Scale score), Grade Level, and LEP Status (Only)
DG730
Category Set E / AVESCASCO / X / X / X / X / N / Scale scores by Academic Subject, Assessment Administered (Scale score), Grade Level, and Economically Disadvantaged Status
DG730
Category Set F / AVESCASCO / X / X / X / X / N / Scale scores by Academic Subject, Assess Administered (Scale score), Grade Level, and Migrant Status
DG730
Subtotal 1 / AVESCASCO / X / X / X / Y / Scale scores for all students by Academic Subject, Assessment Administered (Scale score), and Grade Level
DG751
Category Set A / ACHPERCEN / X / X / X / X / N / Scale scores (cut offs) by Academic Subject, Assessment Administered (Scale score), Achievement Percentile, and Grade Level
2.0 GUIDANCE FOR SUBMITTING THIS FILE
The guidance is organized by data group collected through this file.
This file specification is used to collect the scale scores.
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.
What are Tier I and Tier II schools and what are school intervention models?
The final requirements define Tier I and Tier II schools and school intervention models. They were published in the Federal Register (75 FR 66363) on October 28, 2010, and are available at: http://www.gpo.gov/fdsys/pkg/FR-2010-10-28/pdf/2010-27313.pdf.
What data are reported in the field “scale scores”?
For DG730 Average scale scores, report the mean for all students and each student subgroup in the school by grade level for each assessment and academic subject.
For DG751 Achievement percentile table, report the scale score at the 25th percentile (SS25), 50th percentile (SS50), and 75th percentile (SS75) for all students in the school by grade level for each assessment and academic subject.
What if the number of students in a subgroup is under the N size for the state?
The average scale scores should be reported unless there are no students in a subgroup.
2.1 Academic Subject
What permitted values are used?
The permitted values are:
· RLA – Reading/Language Arts
· M – Mathematics
· S – Science (Optional)
Scale scores and achievement percentiles for science are not required.
2.2 Assessment Administered (Scale score)
Revised! What permitted values are used?
The permitted values are:
· REGASSMENT – Regular assessments based on grade-level achievement
· ALTASSGRADELVL – Alternate assessments based on grade-level achievement standards
· ALTASSMODACH – Alternate assessments based on modified achievement standards
· ALTASSALTACH – Alternate assessments based on alternate achievement standards
What if the state does not use scale scores for alternate assessments?
If the state does not assign scale scores to alternate assessments, leave the alternate assessments out of the file.
What if the state has multiple assessments with different scale scores for mathematics or reading/language arts? For example, student proficiency in reading/language arts is determined using an assessment for reading with a scale score range of 0 to 1000 and an assessment for language arts with a scale score range of 0 to 600.
If a state has multiple scale scores for mathematics or for reading/language arts, the state should combine the scale scores for reporting.
2.3 Grade Level
What grade levels should be reported for mathematics and reading?
A school record should include all required grade levels that are present in the school. Reading/language arts and mathematics assessments are required in grade three through eight and once in high school. For example, a K-6 school would report grades 3 through 6, but not grades 7 through 8 and High School.
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) or high school will be used for reporting results of statewide assessments in high school. Do not report data using both specific grade level and the permitted value for high school (HS).
How are scale scores of students in grade 9 reported?
ESEA as amended requires assessments for mathematics and reading/language arts 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.4 Major 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.
What if my state has a major racial and ethnic group labeled as “other?”
A few states included a group entitled “other” in their accountability plans. These states should determine if one of the permitted values above adequately describes the group entitled “other.” If one of the permitted values does not adequately describe the group entitled “other,” the SEA should inform ED through PSC.
What if my state has a major racial and ethnic group that is not listed above?
SEAs should inform ED though PSC if the list above does not include all the major racial and ethnic groups used by the state.
What if some students are not assigned to a major racial and ethnic group?
SEAs are required to report academic achievement data by the major racial and ethnic groups, as defined by the State. Some students in the State may not be included in a major racial and ethnic group. Therefore, the data by major racial and ethnic groups in the assessment file will not necessarily equal the total number of students. For this reason, ESS will not include edit checks comparing the total to the aggregation of the number of students reported by the major racial and ethnic groups.
2.5 Sex (Membership)
There are no questions and answers specifically related to the category “sex (membership).”
2.6 Disability status (only)
How are scale scores reported by disability status (only)?