Downloads the combined GraduationCohortProfile sheet from the
redesigned 2024-25 School Performance Reports. For each entity, cohort length
(cohort_type in "4-Year", "5-Year", "6-Year"), and
student group it reports the cohort's outcome distribution: the percentage who
graduated, are continuing (still enrolled), are
non_continuing (left without graduating), and the high-school
persisting rate (graduated plus continuing; published for the 6-Year
cohort, NA for shorter cohorts).
Value
Data frame with entity identifiers, cohort_type, subgroup, graduated, continuing, non_continuing, persisting, and the aggregation flags.
school_year is filtered to the requested year and then removed; end_year identifies the year.
Details
Each outcome rate is repeated as a _school / _district /
_state triple in the source; this function returns the
entity-appropriate value (the statewide value is available from the
is_state row of district-level output). Rates are percentages on a
0-100 scale; suppressed cells (fewer than 10 students) become NA.
In SY2024-25 (end_year 2025) this reads the single combined
GraduationCohortProfile sheet. For end_year 2020-2024 it stacks
the separate 4YrGraduationCohortProfile /
5YrGraduationCohortProfile / 6YrGraduationCohortProfile sheets
(the pre-redesign predecessors, identical columns) into the same
cohort_type long shape. The 4- and 6-year cohort rates are also
available through fetch_grad_rate and
fetch_6yr_grad_rate; this function additionally exposes the
5-year cohort and presents all available cohort lengths in one tidy frame.
Supported years: end_year >= 2020. The 6-year cohort first
appears in SY2020-21 (end_year 2021), so end_year 2020 returns
only the 4- and 5-year cohorts. Earlier databases (2017-2019) do not carry
cohort-profile sheets and error. The redundant source school year is
filtered to the requested year and removed.
persisting is published only for the 6-year cohort (and only from
end_year 2024 in the pre-redesign sheets); it is NA otherwise.
Examples
if (FALSE) { # \dontrun{
# School-level cohort profile (all available cohort lengths)
gc <- fetch_spr_grad_cohort(2025)
# The same shape from a pre-redesign year
gc_2022 <- fetch_spr_grad_cohort(2022)
# Statewide 4-year cohort outcomes
library(dplyr)
fetch_spr_grad_cohort(2025, level = "district") %>%
filter(is_state, cohort_type == "4-Year", subgroup == "total population") %>%
select(graduated, continuing, non_continuing)
# How much does the graduation rate rise from the 4- to the 6-year cohort?
fetch_spr_grad_cohort(2025, level = "district") %>%
filter(is_state, subgroup == "total population") %>%
select(cohort_type, graduated)
} # }