School Performance Grades

State's description: accountability - School Performance Grades - Second Version

Listed in the state's table index as rcd_acc_spg2 (active, 2018)

79,747 rows loaded, covering 2,825 schools and agencies, 2017–18 to 2023–24.

1. The state publishes an Excel data dictionary. This demo reads it: 66 table definitions, 525 column definitions, and 181 code definitions — the same ones behind the Decoded view above.
2. From those definitions it writes a Django database model for each table, so nobody has to type the columns in by hand. This table's model came out like this:

class RcdAccSpg2(SRCBaseModel):
    aaa_score = models.DecimalField(max_digits=38, decimal_places=0, null=True, blank=True)
    aaa_score_masking = models.CharField(max_length=1, null=True, blank=True)
    ach_score = models.DecimalField(max_digits=4, decimal_places=1, null=True, blank=True)
    agency_code = models.CharField(max_length=6)
    asm_option = models.CharField(max_length=1, null=True, blank=True)
    awa_score = models.DecimalField(max_digits=38, decimal_places=0, null=True, blank=True)
    awa_score_masking = models.CharField(max_length=1, null=True, blank=True)
    bi_score = models.DecimalField(max_digits=38, decimal_places=0, null=True, blank=True)
    bi_score_masking = models.CharField(max_length=1, null=True, blank=True)
    cgrs_score = models.DecimalField(max_digits=38, decimal_places=0, null=True, blank=True)
    cgrs_score_masking = models.CharField(max_length=1, null=True, blank=True)
    eg_score = models.DecimalField(max_digits=4, decimal_places=1, null=True, blank=True)
    eg_status = models.CharField(max_length=8, null=True, blank=True)
    elp_score = models.DecimalField(max_digits=38, decimal_places=0, null=True, blank=True)
    elp_score_masking = models.CharField(max_length=1, null=True, blank=True)
    k2_feeder = models.CharField(max_length=1, null=True, blank=True)
    ma_eg_score = models.DecimalField(max_digits=4, decimal_places=1, null=True, blank=True)
    ma_eg_status = models.CharField(max_length=8, null=True, blank=True)
    ma_spg_grade = models.CharField(max_length=1, null=True, blank=True)
    ma_spg_score = models.DecimalField(max_digits=38, decimal_places=0, null=True, blank=True)
    mags_score = models.DecimalField(max_digits=4, decimal_places=1, null=True, blank=True)
    mags_score_masking = models.CharField(max_length=1, null=True, blank=True)
    mcr_score = models.DecimalField(max_digits=38, decimal_places=0, null=True, blank=True)
    mcr_score_masking = models.CharField(max_length=1, null=True, blank=True)
    rd_eg_score = models.DecimalField(max_digits=4, decimal_places=1, null=True, blank=True)
    rd_eg_status = models.CharField(max_length=8, null=True, blank=True)
    rd_spg_grade = models.CharField(max_length=1, null=True, blank=True)
    rd_spg_score = models.DecimalField(max_digits=38, decimal_places=0, null=True, blank=True)
    rdgs_score = models.DecimalField(max_digits=4, decimal_places=1, null=True, blank=True)
    rdgs_score_masking = models.CharField(max_length=1, null=True, blank=True)
    scgs_score = models.DecimalField(max_digits=38, decimal_places=0, null=True, blank=True)
    scgs_score_masking = models.CharField(max_length=1, null=True, blank=True)
    spg_grade = models.CharField(max_length=1, null=True, blank=True)
    spg_grade_masking = models.CharField(max_length=1, null=True, blank=True)
    spg_score = models.DecimalField(max_digits=38, decimal_places=0, null=True, blank=True)
    spg_score_masking = models.CharField(max_length=1, null=True, blank=True)
    subgroup = models.CharField(
        max_length=40,
        choices=[
            ("EDS", "Economically Disadvantaged"),
            ("NEDS", "Not Economically Disadvantaged"),
            ("NOT_EDS", "Not Economically Disadvantaged"),
            ("ELS", "English Learners"),
            ("NELS", "Not English Learners"),
            ("SWD", "Students With Disabilities"),
            ("NSWD", "Not Students With Disabilities"),
            ("WH7", "White"),
            ("BL7", "Black"),
            ("HI7", "Hispanic"),
            ("AM7", "American Indian"),
            ("AS7", "Asian"),
            ("MU7", "Two or More Races"),
            ("MALE", "Male"),
            ("FEM", "Female"),
            ("ALL", "All Students"),
            ("AIG", "Academically / Intellectually Gifted"),
            ("NAIG", "Not Academically / Intellectually Gifted"),
            ("PI7", "Pacific Islander"),
            ("HMS", "Homeless"),
            ("FCS", "Foster Care"),
            ("MIL", "Military Connected"),
            ("MIG", "Migrant"),
            ("AIAN", "American Indian / Alaskan Native"),
            ("ASPI", "Pacific Islander / Asian"),
            ("Other", "Other"),
        ],
    )
    year = models.CharField(max_length=4)

    class Meta:
        db_table = "rcd_acc_spg2"
        managed = True
        unique_together = ("year", "agency_code", "subgroup")

3. 79,747 rows were then loaded from the state's raw data files into RcdAccSpg2.
4. It also takes a fingerprint (SHA-256) of the dictionary's general-rules sheet. If the state quietly rewrites its rules document, the next rebuild flags the change instead of absorbing it silently.