11 | P a g e
b. If student has multiple enrollments, calculate enrollment length for each student/home school
(e.g. if student exists in multiple home schools, calculate as separate enrollment lengths)
i. If a student has multiple overlapping enrollments (e.g. enrollment date from one
enrollment record falls between the enrollment data and enrollment exit date of a
separate enrollment record) at the same home school, calculate using the ‘gaps’ method.
Functionally, this uses the earliest enrollment date and the latest enrollment exit date to
calculate enrollment length.
c. Sum enrollment length after processing multiples, grouping by student and home school. Single
records sum correctly because there is only one record. Multiple records, then sum together
correctly as well because overlapping enrollments do not double count overlap days and
segmented enrollments are added correctly as the discrete sums of the individual segments.
d. Once the enrollment length has been calculated select the longest length record for each student
4. Compare the final accountable list with the adjusted cohort graduation table. Add any students that show
up as ‘graduated’ in the cohort table that do not already exist in the accountable list. Note: Students that
are pulled in via the adjusted cohort graduation table may, if they have an exit code of graduated, also
have a graduating entity ID that is a 3000 code school. These are students who were graduated while in
an IDJJ school.
5. Apply the following codes for the final accountable list
a. 01 – students that meet the length requirement (≥ 134 days). Students with this code are included
in all indicator calculations for which they have applicable data, unless otherwise excluded for
reasons specific to the indicator and defined below.
b. 02 – students that are added through the adjusted graduation cohort table. Students with this
code are included in the graduation rate indicator calculation only. They are excluded from all
other indicator calculations.
c. 03 – students that are in ‘Kindergarten.’ Students with this code are excluded from all indicator
calculations (but remain in the data set in case of future indicator modifications).
d. 04 – students that do not meet the length requirement (< 134 days). Students with this code are
excluded from all indicator calculations (but remain in the data set so that schools can see which
students failed the “half a school” rule).
6. Associate applicable student demographic data according to the procedures outlined in the Report Card
Grouping: Student Groups Requirements and Business Rules. The relevant unit of aggregation is the
school.
a. Each SSID will have associated with it (1) a race code, (2) grade (as taken from the enrollment that
was used to determine the accountable school, (except as defined in step 2.a.), and will have
either a yes, no, or null (which is interpreted as a no) for (3) CWD, (4) EL, (5) Former EL, and (7)
Low Income.
i. Logical check: No student can have a Yes for both EL and Former EL. If a student does
calculate as a Former EL, the Former EL “yes” supersedes the EL “yes.”
Applicable student groups are those listed in the definitions section of this document and are
limited to, All Students, White, Black, Hispanic, Two or More Races, Asian, Hawaiian/Pacific
Islander, Native American, English Learners, Students who are currently classified as English
Learners, who have not yet reached proficiency, Former English Learners, Children With
Disabilities, and Low Income.
b. Not applicable student groups include Gender, Homeless, Migrant, Youth In Care, and Military.