District Administrative Records

Appendix I

District Administrative Records

Table 1. Summary of plans for school district administrative records collection

Data element	Description
Demographic and background information
School year	School year to which the record pertains
Student ID	ID used by the district or state to uniquely identify students
First name	First name of student
Middle name	Middle name of student
Last name	Last name of student
Date of birth	Month, day, and year of birth (for example, MM/DD/YYYY)
Gender	Gender of student
Race	Race of student
Ethnicity	Hispanic or Latino indicator for student
Grade level	Grade level of students at the beginning of the school year
Free and reduced-price meal (FRPM) status	Student’s eligibility for free or reduced-price meals as of the beginning of the school year
English learner status	English learner status of student as of the beginning of the school year
Special education status	Special education status of student, such as having an Individualized Education Program, as of the beginning of the school year
School ID: beginning of the school year	ID used by the district or state to uniquely identify the school in which the student was enrolled at the beginning of the school year
School name: beginning of the school year	Name of school corresponding to School ID for the beginning of the school year
School level: beginning of the school year	Indicator whether the school is a middle school or a high school for the beginning of the school year
School ID: end of the school year	ID used by the district or state to uniquely identify the school in which the student was enrolled at the end of the school year
School name: end of the school year	Name of school corresponding to School ID for end of the school year
School level: end of the school year	Indicator whether the school is a middle school or a high school for the end of the school year
Assessmentsa
Math scores on the Algebra I semester and end-of-course assessments, as available	Score on the Algebra I assessment, including all available scores (for example, scale score, normal curve equivalents, and number correct)
Description of the Algebra I semester and end-of-course assessments	Name of Algebra I assessment test, including any modifications
Algebra I semester and end-of-course assessments language indicator (if other than English)	Indicator for whether the assessment was taken in a language other than English, such as Spanish
Algebra I semester and end-of-course assessment dates	Dates of Algebra I assessments taken by the student
Algebra I semester and end-of-course assessments mode	Indicator for whether the Algebra I assessment was administered by computer, paper, or other mode
Algebra I semester and end-of-course assessments exemption or invalidation code, as applicable	Code or indicator if a student received an exemption from taking the Algebra I assessment (such as a medical exemption) or the test was found to be invalid
Course data
Math course passage status	Whether students passed their math course
Algebra I course passage status	Whether students passed their Algebra I course
Algebra I course grades	The course grade attained in Algebra I

Notes: The study will request data for both the 2023-2024 and 2024-2025 school years. Depending on the availability of data in the district, some variables may only be requested for one of the two years or may only be requested at the school level.

^a The study team may also request the same data for state math assessments, depending on the availability of the data.