General Connection Information

CEDS elements are shown in bold/italicized font and CEDS options are shown in italics.

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 strongly associated with people achieving economic mobility and security.¹  Using CEDS elements, this Connection will measure the percentage of first-time grade 9 students who complete Algebra I or an equivalent course by the end of their 9th-grade year.

This metric is a measurement for a key indicator, "Successful completion of Algebra 1 by 9th grade," and measures whether students successfully complete Algebra I or an equivalent course before or during grade 9.

Calculating a Response

Use the following CEDS elements to determine the school years for which the data will be measured:

1. School Year = most recent school year,representing July 1 through June 30

Use the following CEDS elements to determine the universe of students: 

1. Pull all unique students which is determined by using a unique Student Identifier where Student Identification System = State

2. Where the student:

1. is associated with a State Education Agency through the State Agency Identifier where State Agency Identification System = SEA

2. is associated with a Local Education Agency through the Local Education Agency Identifier where Local Education Agency Identification System = SEA

3. is associated with a K12 school through the School Identifier where School Identification System = SEA

From the universe of students, narrow the list to first time 9th graders using the following CEDS elements. 

1. Cohort Year = the school year being reported, and 

2. Entry Grade Level = 09, and  

3. Enrollment Entry Date is ≥ July 1 of the school being reported, and  

4. Enrollment Exit Date is ≤ June 30 of the school year being reported. 

Using the following CEDS elements, narrow the list of 9th grade students to those that completed Algebra I or an equivalent course during the 9th grade:  

1. Pull the unique Course Section Identifier where 

2. School Courses for the Exchange of Data Course Code = 02052 (Algebra I), and/or 02053 (Algebra I – Part 1) and 02054 (Algebra I – Part 2)

3. School Courses for the Exchange of Data Course Subject Area = 02 (Mathematics)

4. Course Begin Date and Course End Date are within the school year being reported 

5. Course Section Exit Type = Completed for Credit or Completed No Credit

To calculate the percentage of first time 9th grade students who complete Algebra I or an equivalent course by the end of their 9th grade year, 

1. Count the number of first time 9th grade students that completed Algebra I or an equivalent course. 

2. Count the total number of students. 

3. Divide the number of students that completed Algebra I or an equivalent course by the total number of students and multiply by 100.

Disaggregate by Home Language

Use the following CEDS elements to disaggregate the final set of students by home language:

1. Language Type = Home Language, and
2. ISO 639-3 Language Code ≠ Eng (English)
3. English Learner Status = Yes

Disaggregate by Homelessness

Use the following CEDS elements to disaggregate the final set of students by homelessness: 

1. Homelessness Status = Yes 

2. Status Start Date < July 1 of the school year being reported

3. Status End Date ≥ June 30 of the school year being reported

Disaggregate by Race and Ethnicity

Use the following CEDS elements to disaggregate the final set of students by race and ethnicity:

1. Filter records where Hispanic or Latino Ethnicity = No

2. 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 elements to disaggregate the final set of students by Hispanic or Latino Ethnicity

1. 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 to disaggregate the final set of students by sex: 

1. Sex = Male, Female, Not Selected 

Disaggregate by Disability Status

Use the following CEDS elements to disaggregate the final set of students by Disability Status: 

A.  Determine if there is a disability

Student with a Disability: A student has a disability if any of the following are true: 

1. Disability Status = Yes, and/or
   
   

• Status Start Date ≤ the school year being reported, and

• Status End Date ≥ the school year being reported or null

2. IDEA Indicator = Yes, and/or

• Program Participation Start Date ≤ the school year being reported, and

• Program Participation End Date ≥ the school year being reported or is Null

Student without a Disability: A student does not have a disability if all of the following are true: 

1. Disability Status= No; and 

2. Primary Disability Type is null; and 

3. IDEA Indicator = No; and 

4. Section 504 Status = No

B. Count the number of students with a disability and the number of students without a disability. 

C. For further analysis, disaggregate the students with a disability. 

1. Filter records where IDEA Indicator = Yes

• Program Participation Start Date ≤ July 1 of the school year being reported, and

• Program Participation Exit Date ≥ June 30 the school year being reported

2. Count, by Primary Disability Type, where any of the following are true: 

• Primary Disability Type = Autism

• Primary Disability Type = Deaf blindness

• Primary Disability Type = Deafness

• Primary Disability Type = Developmental delay

• Primary Disability Type = Emotional disturbance

• Primary Disability Type = Hearing impairment

• Primary Disability Type= Intellectual disability

• Primary Disability Type = Multiple disabilities

• Primary Disability Type = Orthopedic impairment

• Primary Disability Type = Other health impairment

• Primary Disability Type = Specific learning disability

• Primary Disability Type = Traumatic brain injury
• Primary Disability Type = Visual impairment

Disaggregate by Urbanicity

Use the following CEDS elements to disaggregate the final set of students by Urbanicity:

1. Rural Residency Status = Yes (indicating Rural) or No (indicating Urban)

Disaggregate by Parental Education Level

Use the following CEDS element to disaggregate the final set of students by Parental Education Level:

1. 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 elements to disaggregate the final set of students by Migrant Family Household:

1. Migrant Status = Yes or No
2. Program Participation Start Date ≤ July 1 of the school year being reported
3. Program Participation Exit Date ≥ June 30 of the school year being reported or null

Disaggregate by English Learner

Use the following CEDS elements to disaggregate the final set of students by English Learner: 

1. English Learner Status = Yes or No

2. Program Participation Start Date ≤ July 1 of the school year being reported
   

3. Program Participation Exit Date ≥ June 30 of the school year being reported or null

Disaggregate by K12 School Type

Use the following CEDS element to disaggregate the final set of students by School Type: 

1. Charter School Type= School, College University, NA
2. School Type= Regular, Special, Career and Technical Education School, Alternative Education School, or Reportable Program
3. Administrative Funding Control = Public School, Private School, or Other
4. Organization Type = K12 School, Education Institution

Disaggregate by Individuals or Family Military Status

Use the following CEDS element to disaggregate the final set of students by Individuals or Family Military Status: 

1. Military Connected Student Indicator = Not Military, Active Duty, National Guard or Reserve, Unknown

Disaggregate by Income Level

Use the following CEDS element to disaggregate the final set of students by Income Level:  

1. Eligibility Status for School Food Service Programs = Free, Full Price, Reduced Price, Other

2. Low-income status = Yes, or No

Disaggregate by Justice Involvement

Use the following CEDS element to disaggregate the final set of students by Justice Involvement:  

1. Disciplinary Action Taken = Juvenile justice referral, Law enforcement referral, Placed in juvenile detention center

2. Disciplinary Action Taken Start Date ≤ July 1 of the school year being reported

3. Disciplinary Action Taken End Date ≥ June 30 of the school year being reported or null

Disaggregate by Individual With Current or Past Child Welfare Involvement

Use the following CEDS element to disaggregate the final set of students by Individual with Current or Past Child Welfare Involvement:

1. Program Type = Foster Care

2. Student Support Service Type = Children’s protective services

3. Program Participation Start Date ≤ July 1 of the school year being reported

4. Program Participation Exit Date ≥ June 30 of the school year being reported or null