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 strongly associated with people achieving economic mobility and security. 

This metric is a measurement for a key indicator "SAT and ACT participation and performance" and measures the percentage of grade 11-12 students who earn a college ready score, based on the benchmarks set by the SAT and ACT.

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
• where Enrollment Entry Date and Enrollment Exit Date are within the school year being reported.

 From the universe of students, narrow the list to students in grades 11 and 12 using the following CEDS element:

•  Entry Grade Level =11 or 12

College Ready Score on the SAT

Using the following CEDS elements, pull the students in grades 11 and 12 who take the SAT:

• Assessment Type = Achievement Test
• Assessment Score Metric Type = 03481 (SAT Score)
• Assessment Result Score Value is not null  
• Assessment Result Date Created = Session End Date 

Narrow the list to students who earned a college ready score based on the benchmark set by the SAT (see link in Related References)

Pull students where:

• Assessment Academic Subject = 01166 (Mathematics), and
• Assessment Score Metric Type = 03481 (SAT score), and 
• Assessment Result Score Value ≥ 530

Pull students where: 

• Assessment Academic Subject = 13373 (Reading/Language Arts), and
• Assessment Score Metric Type = 00494 (SAT score), and 
• Assessment Result Score Value ≥ 480

To calculate the percentage of students in grades 11 and 12 who earned a college ready score in Mathematics based on the benchmarks set by the SAT:

• Count the number of students in grades 11 and 12 who earned a college ready score in Mathematics and Reading/Language Arts based on the benchmark set by the SAT
• Count the total number of students
• Divide the number of students in grades 11 and 12 who earned a college ready score in Mathematics based on the benchmark set by the SAT and multiply by 100. 

To calculate the percentage of students in grades 11 and 12 who earned a college ready score in Reading/Language Arts based on the benchmark set by the SAT: 

• Count the number of students in grades 11 and 12 who earned a college ready score in Reading/Language Arts based on the benchmark set by the SAT: 
• Count the total number of students
• Divide the number of students in grades 11 and 12 who earned a college ready score in Reading/Language Arts based on the benchmark set by the SAT by the total number of students and multiply by 100.  

To calculate the percentage of students in grades 11 and 12 who earned college ready scores on the benchmarks set by the SAT: 

• Count the number of students in grades 11 and 12 who earned a college ready score in Mathematics and Reading/Language Arts based on the benchmark set by the SAT
• Count the total number of students
• Divide the number of students in grades 11 and 12 who earned college ready scores in Mathematics and Reading/Language Arts based on the benchmarks set by the SAT by the total number of students and multiply by 100.

College Ready Score on ACT

Using the following CEDS elements, pull the students in grades 11 and 12 who took the ACT: 

• Assessment Type = Achievement Test 
• Assessment Score Metric Type = 00494 (ACT Score)
• Assessment Result Score Value is not null
• Assessment Score Result Date Created = Session End Date

 Narrow the list to students who earned a college ready score based on the benchmark set by the ACT (see link in Related References)

 Pull students where: 

•  Assessment Academic Subject = 13372 (English), and
• Assessment Score Metric Type = ACT score
• Assessment Result Score Value ≥ 18 

Pull students where:

• Assessment Academic Subject = 01166 (Mathematics), and 
• Assessment Score Metric Type = ACT score
• Assessment Result Score Value ≥ 22

Pull students where:

• Assessment Academic Subject = 00560 (Reading), and 
  
• Assessment Score Metric Type = ACT score
• Assessment Result Score Value ≥ 22

Pull students where:

• Assessment Academic Subject = 00562 (Science), and 
• Assessment Score Metric Type = ACT Score
• Assessment Result Score Value ≥ 23 

To calculate the percentage of students in grades 11 and 12 who earned a college ready score in Mathematics based on the benchmark set by the ACT: 

• Count the number of students in grades 11 and 12 who earned a college ready score in Mathematics based on the benchmark set by the ACT. 
• Count the total number of students
• Divide the number of students in grades 11 and 12 who earned a college ready score in Mathematics based on the benchmark set by the ACT by the total number of students and multiply by 100. 

To calculate the percentage of students in grades 11 and 12 who earned a college ready score in Reading based on the benchmark set by the ACT: 

• Count the number of students in grades 11 and 12 who earned a college ready score in Reading based on the benchmark set by the ACT. 
• Count the total number of students
• Divide the number of students in grades 11 and 12 who earned a college ready score in Reading based on the benchmark set by the ACT by the total number of students and multiply by 100. 

To calculate the percentage of students in grades 11 and 12 who earned a college ready score in Science based on the benchmark set by the ACT: 

• Count the number of students in grades 11 and 12 who earned a college ready score in Science based on the benchmark set by the ACT. 
• Count the total number of students
• Divide the number of students in grades 11 and 12 who earned a college ready score in Science based on the benchmark set by the ACT by the total number of students and multiply by 100. 

To calculate the percentage of students in grades 11 and 12 who earned college ready scores based on the benchmarks set by the ACT: 

• Count the number of students in grades 11 and 12 who earned college ready scores in Mathematics, Reading, and Science based on the benchmarks set by the ACT. 
• Count the total number of students
• Divide the number of students in grades 11 and 12 who earned college ready scores in Mathematics, Reading and Science based on the benchmarks set by the ACT 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:

• Language Type = Home Language; and
• ISO 639-3 Language Code ≠ Eng; and/or
• English Learner Status = Yes

Disaggregate by Homelessness

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

• Homelessness Status = Yes
• Homeless Serviced Indicator = 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 elements 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 elements 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 elements to disaggregate the final set of students by Sex: 

• Sex = Male, Female, or Not Selected

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

• 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 elements 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 elements to disaggregate the final set of students by K12 School Type:

• 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 Individuals or Family Military Status

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

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

Disaggregate by Individual with Current or Past Child Welfare Involvement

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

• 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

Disaggregate by Justice Involvement

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

• 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 Income Level

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

• Eligibility Status for School Food Service Programs = Free, Full price, Reduced price, Other
• Low-income Status = Yes, or No

Disaggregate by Disability Status

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

Students with a Disability

• Disability Status = Yes; and/or
• Status Start Date ≤ the school year being reported
• Status End Date ≥ the school year being reported
• 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 ≤ the school year being reported
• Program Participation Exit Date ≥ the school year being reported

Students without a Disability

• Disability Status = No; and
• Primary Disability Type is null; and
• IDEA Indicator = No; and
• Section 504 Status = No

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