U.S. DEPARTMENT OF EDUCATION
EDFacts Submission System
C107 – High School Graduation Rate Indicator
File Specifications
Version 11.0
SY 2014-15
August 2014
U.S. DEPARTMENT OF EDUCATION C107 – High School Graduation Rate Indicator
File Specifications v11.0
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
EDFacts
Ross Santy
System Owner
August 2014
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: FILE 107 –High School Graduation Rate Indicator File Specifications – V11.0 (SY 2014-15), : U.S. Department of Education, Washington, DC: EDFacts. Retrieved [date] from http://www.ed.gov/edfacts
On request, this publication is available in alternate formats, such as Braille, large print, or CD Rom. For more information, please contact the Department’s Alternate Format Center at (202) 260–0818.
DOCUMENT CONTROL
DOCUMENT INFORMATION
Title: / C107 – High School Graduation Rate Indicator File SpecificationsRevision: / Version 11.0
Issue Date: / August 2014
Security Level: / Unclassified – For Official Use Only
Filename: / c107-11-0.doc
DOCUMENT HISTORY
Version Number / Date / Summary of Change1.0 – 10.0 / Versions 1.0 through 10.0 are used to build files for school years prior to SY 2014-15.
11.0 / August 2014 / Updated for SY 2014-15
Table 2.2-1 Clarified reporting guidance for Zeros, Not applicable, and Missing.
· See permitted values in Table 4.2 and 5.1-1.
PREFACE
This document provides technical instructions for building files that are submitted through the EDFacts Submission System (ESS). The ESS 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 posted on http://www2.ed.gov/about/inits/ed/edfacts/index.html under EDFacts System Documentation, including:
· EDFacts Workbook – a reference guide to using the EDFacts
Submission System (ESS); particularly useful to new users; contains multiple appendices, including one that explains how to use the file specifications
· ESS User Guide – provides assistance to new users of the EDFacts Submission System (ESS); it addresses the basic mechanics of system access and data submission
· EDFacts Business Rules Guide – describes each business rule includes the error number, type, message, definition, edit logic, and the file specifications where the business rules are applied
Please contact the Partner Support Center (PSC) with questions about the documents. You will find contact information for PSC and each State EDFacts Coordinator at: http://www2.ed.gov/about/inits/ed/edfacts/eden/contacts.html
Data submitted through the ESS are authorized by an Annual Mandatory Collection of Elementary and Secondary Education Data Through EDFacts (OMB 1875-0240, expires 02/29/2016). 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 decision-making 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.
August 2014 / 19 / SY 2014-15U.S. DEPARTMENT OF EDUCATION C107 – High School Graduation Rate Indicator
File Specifications v11.0
Contents
DOCUMENT CONTROL ii
PREFACE iii
1.0 PURPOSE 2
2.0 GUIDANCE FOR SUBMITTING THIS FILE 2
2.1 Changes from the SY 2013-14 File Specifications 2
2.2 Core Requirements for Submitting this File 2
2.3 Required Categories and Totals 3
2.4 Guidance 3
2.5 Guidance 6
3.0 FILE NAMING CONVENTION 7
4.0 FIXED OR DELIMITED FILES 8
4.1 Header Record Definition 8
4.2 Data Record Definition 9
5.0 XML SPECIFICATIONS 12
5.1 Category XML Object 13
5.2 Table Type XML Object 15
5.3 Agency XML Object 16
5.4 File Transmit XML Object 17
August 2014 / 19 / SY 2014-15U.S. DEPARTMENT OF EDUCATION C107 – High School Graduation Rate Indicator
File Specifications v11.0
U.S. DEPARTMENT OF EDUCATION C107 – High School Graduation Rate Indicator
File Specifications v11.0
1.0 PURPOSE
This document contains instructions for building files to submit EDFacts Data Group 557: High School Graduation Rate Indicator Status. The definition for this data group is:
An indication of whether the school or district met the High School Graduation Rate requirement in accordance with state definition.
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).
2.0 GUIDANCE FOR SUBMITTING THIS FILE
This section contains changes from the previous school year, core requirements for submitting this file, required categories and totals, and general guidance.
2.1 Changes from the SY 2013-14 File Specifications
The guidance has been updated and other editorial changes have been made. These changes are listed in the document history on page ii. There have been no changes to the record layouts.
2.2 Core Requirements for Submitting this File
The following table contains the reporting periodand the education units included or excluded.
Table 2.2-1: Core Reporting Requirements
SEA / LEA / SchoolReporting Period / School year
The high school graduation rate indicator is the indicator used for the AYP calculations for SY 2013-14
Education units reported / This file is not submitted at the SEA level. / Operational LEAs with high school grades. / Operational schools with high school grades.
Education units not reported / Closed, inactive, or future LEAs.
LEAs that do not have high school grades. / Closed, inactive, or future schools.
Schools that do not have high school grades.
Type of count
Zero counts
Zero exceptions
Not applicable / Exclude records for LEAs or schools that are not required to meet this indicator. Alternatively, include one record for the LEA or school to report the “NA” permitted value as the status for the “All Students” group. Do not report “NA” as the status for student subgroups.
Exclude records for LEAs, schools, or subgroups with no students. Missing records for subgroups will be interpreted to mean that the student group is not present in the LEA or school. Alternatively, include the subgroup records and use the “NOSTUDENTS” permitted value.
Exclude records for Major Racial and Ethnic Group permitted values not used by the state.
See Section 2.4 for further guidance.
Missing / Use the “MISSING” permitted value when a status is not available for an LEA or School that is required to meet this indicator. This includes cases where a student group is present in the LEA or school but the status is not available.
Use the “MISSING” permitted value for Major Racial Ethnic Group when data on the status by major racial ethnic group is not available.
2.3 Required Categories and Totals
The table below lists the combinations of the categories that are expected to be submitted for the state and each LEA or school that should be included in the file. An “X” in the column indicates that the column must be populated when reporting that particular category. The abbreviations in the “Table Name” column represent the technical name of the data used in the file.
Table 2.3–1: Required Categories and Totals
Aggregation / Table Name / Major Racial and Ethnic Groups / Disability Status (Only) / LEP Status(Only) / Economically Disadvantaged Status / Status / Comments /
Category Set A / HSGRDRTIND / X / X / Statuses for each major racial and ethnic groups
Category Set B / HSGRDRTIND / X / X / Status for children with disabilities (IDEA)
Category Set C / HSGRDRTIND / X / X / Status for students who are LEP
Category Set D / HSGRDRTIND / X / X / Status for students who are economically disadvantaged
Status for the education unit / HSGRDRTIND / X / All students
2.4 Guidance
This section contains guidance for submitting this file in the format of questions and answers.
What are the permitted values for status?
For any school or district, the high school graduation rate indicator has one of the following statuses for each student subgroup and for all students:
· METGOAL – The school or district met the goal for the high school graduation rate indicator for a student subgroup or for all students.
· METTARGET - The school or district met the target for the high school graduation rate indicator for a student subgroup or for all students.
· NOTMETADDIND: The school or district did not meet the high school graduation rate indicator for a student subgroup or for all students.
· TOOFEW: The number of students in the school or district or for a student subgroup was less than the minimum group size outlines in a state’s consolidated accountability workbook necessary required to reliably calculate the high school graduation rate indicator.
· NOSTUDENTS: There are no students in a student subgroup. If no students are in the school or district, the school or district should not be included in this file. However, if schools or districts with no students are included in the file, the status would be “NOSTUDENTS.”
· MISSING: The status of the high school graduation rate indicator for a specific school or district is not available at the time the file is prepared.
What is the difference between met (goal) and met (target)?
A state’s graduation rate goal represents the graduation rate that the state expects all high schools in the state to meet, ultimately. A state’s annual graduation rate target reflects continuous and substantial improvement from the prior year toward meeting or exceeding the graduation rate goal. A school can meet the goal or meet the target to make adequate yearly progress on the other academic indicator.
Why is “NA – Not applicable” a permitted value for status?
Schools or districts that are not required to meet the high school graduation rate indicator (for example, elementary schools) should not be included in the file. However, if an SEA decided to include them in the file they should be reported as “NA – not applicable.”
Are records required by subgroup for SY 2014-15?
Yes. Submission of data by subgroups is mandatory for SY 2014-15.
What records are required?
Each school or district with a 12th grade must have an “all students” record and records for each subgroup. A school or district does not have to have records for each of the permitted values of the category set A - major racial and ethnic groups.
Table 2.4-1: Number of records
Category set or all students / Number of records per school or district /Category set A – major racial and ethnic groups / One or more
Category set B – LEP status (only) / One
Category set C – disability status (only) / One
Category set D – economically disadvantaged status / One
All students / One
Each record in the file indicates the status of the High School Graduation Rate Indicator for a specific student subgroup or “all students”. For example, if a school met the High School Graduation Rate Indicator Status for economically disadvantaged students, the record would indicate “ECODIS” in the field for “Economically Disadvantaged Status” and “METADDIND” in the field for “Status.” When reporting the indicator for all students, only the field “Status” is used. The status for “All Students” is the result of the participation of all students. It is not the overall designation of the district or school.
How are statuses reported by major racial and ethnic groups?
The permitted values are:
· White (not Hispanic) / Caucasian
· Black (not Hispanic) / African American
· Hispanic / Latino – use if includes Puerto Ricans
· Hispanic (not Puerto Rican)
· Puerto Rican
· Asian – Use if doesn’t include Pacific Islanders
· 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 for the category major racial and ethnic groups?
States should use whichever permitted values best align with the major racial and ethnic subgroups used to determine adequate yearly progress (AYP) as outlined in their state Accountability Workbook.
Do any other file specifications collect related data?
Yes. Under ESEA as amended, states determine the Adequate Yearly Progress (AYP) status of each school and district. Each school and district receives one overall AYP designation, collected in C103, DG32. This determination is based on the evaluation of each subgroup within a school or district. The matrix below illustrates the relationship between AYP status and the indicators used to calculate it and EDFacts data groups and files.
Table 2.4-2: AYP Status and Indicators
AYP Status [1]C103, DG32 (C103, DG 617)
Reading/Language Arts / Mathematics / Other indicators
95% Participation / AMO Status by Subgroup / 95% Participation / AMO Status by Subgroup / Elementary/
secondary / High school graduation rate
C110, DG553 / C111, DG552 / C108, DG555 / C109, DG 554 / C106, DG556 / C107,
DG557
2.5 Guidance
See the EDFacts Workbook (http://www2.ed.gov/about/inits/ed/edfacts/index.html) for the standard definitions. This file specification has no additional definitions.
3.0 FILE NAMING CONVENTION
The following file naming convention is to help identify files to provide technical assistance.