General Connection Information-
CEDS elements are shown in bold/italicized font. This metric is part of the Education-to-Workforce (E-W) Indicator Framework, specifically "Outcomes and milestones" which pertain to key outcomes and milestones along the E-W continuum that are strongly associated with individuals achieving economic mobility and security. This metric is a measurement for a key indicator, "6th Grade On Track," and measures whether students in grade 6 are on track to graduate high school on time. Calculating a Response-
Use the following CEDS elements to determine the school years for which the data will be measured: School Year = most recent school year,representing July 1 through June 30
Use the following CEDS elements to determine the universe of students: Pull all unique students which is determined by using a unique Student Identifier where Student Identification System = State Where the student: is associated with a State Education Agency through the State Agency Identifier where State Agency Identification System = SEA is associated with a Local Education Agency through the Local Education Agency Identifier where Local Education Agency Identification System = SEA is associated with a K12 school through the School Identifier where School Identification System = SEA
From the universe of students, narrow the list to 6th graders using the following CEDS elements. Entry Grade Level = 06, and Enrollment Entry Date is = July 1 of the school being reported, and Enrollment Exit Date is = June 30 of the school year being reported.
Identify which students have passing grades in Math: Filter records where School Courses for the Exchange of Data Course Subject Area = 02 (Mathematics) and Student Course Section Grade Earned is not null Grade Value Qualifier can be A, B, C, or D (Depending on state criteria for pass or fail.)
Identify which students have passing grades in reading/English language arts: Filter records where School Courses for the Exchange of Data Course Code = 01 (English Language and Literature) Student Course Section Grade Earned is not null Grade Value Qualifier can be A, B, C, or D (Depending on state criteria for pass or fail.)
Identify which students have an attendance rate of 90% or higher: Student Attendance Rate = .9 or higher Chronic Student Absenteeism Indicator = No
Identify which students have no records of either in/out of school suspensions or expulsions: Filter records where Disciplinary Action Taken is not = Expulsion with services Filter records where DisciplinaryAction Taken is not = Expulsion without services Filter records where Disciplinary Action Taken is not = Suspension after school Filter records where Disciplinary Action Taken is not = Suspension, in-school Filter records where Disciplinary Action Taken is not = Suspension, out of school, greater than 10 consecutive school days Filter records where Disciplinary Action Taken is not = Suspension, out of school, separate days culminating to more than 10 school days Filter records where Disciplinary Action Taken is not = Suspension, out-of-school, without services - Filter records where Disciplinary Action Taken is not = Suspension, out-of-school, with services
Divide the number of students on track by the total number of students in grade 6. Multiply by 100. Disaggregate by Home Language -
Use the following CEDS element(s) to Disaggregate the final set of students by Home Language: Language Type = Home Language; and ISO 639-3 Language Code ? Eng; and/or - English Learner Status = Yes
Disaggregate by Homelessness-
Use the following CEDS element(s) to Disaggregate the final set of students by Homelessness: Homelessness Status = Yes Status Start Date>the school year being reported Status End Date< the school year being reported
Disaggregate by Race and Ethnicity-
Use the following CEDS element(s) to disaggregate the final set of students by Race: Filter records where Hispanic or Latino Ethnicity = No. Count, by race, where any of the following are true:
Race =American Indian or Alaska Native Race = Asian Race =Black or African American Race =Native Hawaiian or Other Pacific Islander Race =White Race =Demographic Race Two or More Races Race =Race and Ethnicity Unknown
Use the following CEDS element(s) to disaggregate the final set of students by Hispanic or Latino Ethnicity: Filter records where Hispanic or Latino Ethnicity = Yes
Disaggregate by Sex-
*Note: CEDS does not have a Gender element. While Sex is not a proxy for Gender it is the closest approximation currently available. *Note: Male + Female will not always equal 100% for states that have more choices beyond male and female. Use the following CEDS element(s) to disaggregate the final set of students by Sex: - Sex = Male, Female, or Not Selected
Disaggregate by Disability Status-
Use the following CEDS element(s) to disaggregate the final set of students by Disability Status: Students with a Disability Disability Status = Yes; and/or Status Start Date Status End Date
IDEA Indicator = Yes; and/or Section 504 Status = Yes. Count, by disability type, where any of the following are true: IDEA Disability Type = Autism IDEA Disability Type = Deaf-blindness IDEA Disability Type = Deafness IDEA Disability Type = Developmental delay IDEA Disability Type = Emotional disturbance IDEA Disability Type = Hearing impairment IDEA Disability Type = Intellectual disability IDEA Disability Type = Multiple disabilities IDEA Disability Type = Orthopedic impairment IDEA Disability Type = Other health impairment IDEA Disability Type = Specific learning disability IDEA Disability Type = Traumatic brain injury IDEA Disability Type = Visual impairment
Filter records based on Primary Disability Type when IDEA Indicator = Yes Program Participation Start Date Program Participation Exit Date
Students without a Disability Disability Status = No; and Primary Disability Type is null; and IDEA Indicator = No; and - Section 504 Status = No
Disaggregate by Urbanicity-
Use the following CEDS element to disaggregate the final set of students by Urbancity. - Rural Residency Status = Yes (indicating Rural) or No (indicating Urban)
Disaggregate by Parental Education Level-
Use the following CEDS element(s) to disaggregate the final set of students by Parental Education Level: - Highest Level of Education Completed = Determine what the highest level of education completed is for the parents/guardians of the student
Disaggregate by Migrant Family Household-
Use the following CEDS element(s) to disaggregate the final set of students by migrant family household status: Migrant Status = Yes, No Program Participation Start Date< the school year being reported - Program Participation Exit Date >the school year being reported
Disaggregate by English Learner-
Use the following CEDS element(s) to disaggregate the final set of students by English learner: English Learner Status = Yes, No Program Participation Start Date< the school year being reported - Program Participation Exit Date >the school year being reported
Disaggregate by School Type-
Use the following CEDS element(s) to determine the school type for which the data are being measured: Charter School Type = School Charter or College University or NA; and School Type = Regular, Special, Career and Technical, Alternative or Reportable Administrative Funding Control = Public School, Private School, or Other - Organization Type = K12 School, Education Institution
Disaggregate by Age Group-
Use the following CEDS element(s) to determine the age group for which the data are being measured: - Birthdate = Age as of October 1 of the school year being reported
Disaggregate by Individuals or Family Military Status-
Use the following CEDS element(s) to determine the individuals or family military status for which the data are being measured: - Military Connected Student Indicator = Not Military, Active Duty, National Guard or Reserve, or Unknown
Disaggregate by Income Leve-
Use the following CEDS element(s) to determine the income level for which the data are being measured: Eligibility Status for School Food Service Programs = Free, Full price, Reduced price, Other - Low-income status = Yes, or No
Disaggregate by Justice Involvement-
Use the following CEDS element(s) to determine the justice involvement for which the data are being measured: Disciplinary Action Taken = Juvenile Justice Referral, Law enforcement referral, or Placed in juvenile detention center Disciplinary Action Start Date< the school year being reported Disciplinary Action End Date >the school year being reported
Disaggregate by Individual with Current or Past Child Welfare Involvement -
Use the following CEDS element(s) to determine the individual with current or past child welfare involvement for which the data are being measured: Program Type = 75000 (Foster Care) Student Support Service Type = 00295 (Children's protective services) Program Participation Start Date < the school year being reported Program Participation Exit Date >the school year being reported
|