This is a live demo, built on made-up or public data. All demos

School Performance Grades

The state's A-F school performance grades, which combine achievement and academic growth.

rcd_acc_spg2

Raw Decoded

Download as CSV

Rows

79,747

Schools & agencies

2,825

Years covered

2017–18 to 2023–24

missing 2019–20, 2020–21

Values suppressed

1.3%

by the state's privacy rules

School name Year Student Group

Clear

suppressed means the state deliberately hid that value. When a student group is small enough that a published number could identify individual students — fewer than 10 students measured, or a rate above 95% or below 5% — states suppress it. Hover a suppressed cell to see which rule applied. This site keeps every suppression intact.

Aaa score	Achievement Score	School	Asm option	Awa score	Bi score	Cgrs score	Growth Score	Growth Status	Elp score	K2 feeder	Math Growth Score	Math Growth Status	Math Grade	Math Score	Mags score	Mcr score	Reading Growth Score	Reading Growth Status	Reading Grade	Reading Score	Rdgs score	Scgs score	Performance Grade	Performance Score	Student Group	School Year
44	50.8	North Carolina Cyber Academy `00A000`	N	46	49	60	63.3	NotMet		N	58.5	NotMet	D	40	35.6	89	69.5	NotMet	D	53	48.9	63	D	53	All Students	2023–24
87	87.2	North Carolina Cyber Academy `00A000`	N							N													A	87	Asian	2023–24
35	41.1	North Carolina Cyber Academy `00A000`	N	32	38	59	70.9	Met		N						88						49	D	47	Black	2023–24
37	44.5	North Carolina Cyber Academy `00A000`	N	46	44	62	63.5	NotMet		N						86						55	D	48	Economically Disadvantaged	2023–24
30	29.8	North Carolina Cyber Academy `00A000`	N							N													F	30	English Learners	2023–24
45	53	North Carolina Cyber Academy `00A000`	N		53	64	77.4	Met		N						90						71	C	58	Hispanic	2023–24
45	45.2	North Carolina Cyber Academy `00A000`	N				77.9	Met		N													D	52	Two or More Races	2023–24
24	31.7	North Carolina Cyber Academy `00A000`	N		22	50	67	NotMet		N						71						44	F	39	Students With Disabilities	2023–24
47	54.8	North Carolina Cyber Academy `00A000`	N	50	56	62	60.2	NotMet		N						90						67	C	56	White	2023–24
43	47.5	NC Virtual Academy `00B000`	N	37	43	72	56.9	NotMet	10	N	68.6	NotMet	D	42	35.5	95 suppressed	56.5	NotMet	D	50	48.2	63	D	49	All Students	2023–24
60	59.6	NC Virtual Academy `00B000`	N							N													C	60	Asian	2023–24
37	41.4	NC Virtual Academy `00B000`	N	23	38	75	66.7	NotMet		N						94						53	D	46	Black	2023–24
37	41.3	NC Virtual Academy `00B000`	N	23	33	73	58.1	NotMet		N						94						59	D	45	Economically Disadvantaged	2023–24
21	17.8	NC Virtual Academy `00B000`	N						10	N													F	18	English Learners	2023–24
42	43.9	NC Virtual Academy `00B000`	N				65.5	NotMet		N												55	D	48	Hispanic	2023–24
39	41.8	NC Virtual Academy `00B000`	N				73.5	Met		N												59	D	48	Two or More Races	2023–24
15	22.6	NC Virtual Academy `00B000`	N			58	75.3	Met		N												49	F	33	Students With Disabilities	2023–24
47	53.1	NC Virtual Academy `00B000`	N	45	51	71	59.5	NotMet		N						95 suppressed						74	D	54	White	2023–24
95 suppressed	94.8	ABSS Early College at ACC `010303`	N	70	95 suppressed	95 suppressed	92.4	Exceeded		N						95 suppressed							A	94	All Students	2023–24
95 suppressed	100	ABSS Early College at ACC `010303`	N				87.7	Exceeded		N													A	98	Economically Disadvantaged	2023–24
95 suppressed	100	ABSS Early College at ACC `010303`	N				88.8	Exceeded		N													A	98	Hispanic	2023–24
95 suppressed	100	ABSS Early College at ACC `010303`	N		95 suppressed		84.7	Met		N													A	97	White	2023–24
55	57.5	Alexander Wilson Elementary `010304`	N				90.7	Exceeded	58	N	93.1	Exceeded	C	67	60.3		82.6	Met	C	57	50	72	C	64	All Students	2023–24
31	30.6	Alexander Wilson Elementary `010304`	N				81.2	Met		N													D	41	Black	2023–24
43	47.2	Alexander Wilson Elementary `010304`	N				87.3	Exceeded		N												70	C	55	Economically Disadvantaged	2023–24
47	50	Alexander Wilson Elementary `010304`	N				83.2	Met	58	N													C	57	English Learners	2023–24
50	52.6	Alexander Wilson Elementary `010304`	N				82.7	Met		N												65	C	59	Hispanic	2023–24
23	22.5	Alexander Wilson Elementary `010304`	N				83.8	Met		N													F	35	Students With Disabilities	2023–24
63	65.8	Alexander Wilson Elementary `010304`	N				91	Exceeded		N												83	B	71	White	2023–24
64	65.1	Altamahaw-Ossipee Elementary `010308`	N				84.7	Met		N	84	Met	B	72	69		83.1	Met	C	64	59.6	71	C	69	All Students	2023–24
50	50	Altamahaw-Ossipee Elementary `010308`	N				83	Met		N													C	57	Black	2023–24
56	57	Altamahaw-Ossipee Elementary `010308`	N				82.9	Met		N												67	C	62	Economically Disadvantaged	2023–24
56	55.6	Altamahaw-Ossipee Elementary `010308`	N				82.4	Met		N													C	61	Hispanic	2023–24
27	27	Altamahaw-Ossipee Elementary `010308`	N				84.5	Met		N													F	39	Students With Disabilities	2023–24
72	72.8	Altamahaw-Ossipee Elementary `010308`	N				83.1	Met		N												80	B	75	White	2023–24
30	30.8	Broadview Middle `010310`	N				91.4	Exceeded	7	N	94.5	Exceeded	D	44	30.8		82	Met	F	39	28.7	56	D	43	All Students	2023–24
24	27.4	Broadview Middle `010310`	N				88.9	Exceeded		N												45	D	40	Black	2023–24
26	27.9	Broadview Middle `010310`	N				90.6	Exceeded	5 suppressed	N												55	D	40	Economically Disadvantaged	2023–24
24	23.3	Broadview Middle `010310`	N				84.4	Met	7	N												52	F	36	English Learners	2023–24
31	30.6	Broadview Middle `010310`	N				87.8	Exceeded	7	N												58	D	42	Hispanic	2023–24
9	9.3	Broadview Middle `010310`	N				80.1	Met		N													F	23	Students With Disabilities	2023–24
		Career and Technical Education Center `010311`	N							N													— suppressed	— suppressed	All Students	2023–24
57	57.7	Highland Elementary `010312`	N				65.2	NotMet		N	63.7	NotMet	C	59	58.2		74.7	Met	C	59	54.7	64	C	59	All Students	2023–24
39	39.3	Highland Elementary `010312`	N				66.4	NotMet		N													D	45	Black	2023–24
42	42.5	Highland Elementary `010312`	N				60.4	NotMet		N												47	D	46	Economically Disadvantaged	2023–24
50	50	Highland Elementary `010312`	N				79.7	Met		N													C	56	Hispanic	2023–24
50	50	Highland Elementary `010312`	N				80	Met		N													C	56	Two or More Races	2023–24
17	16.7	Highland Elementary `010312`	N							N													F	17	Students With Disabilities	2023–24
69	70.7	Highland Elementary `010312`	N				69	NotMet		N												80	B	70	White	2023–24
63	64.7	E M Yoder Elementary `010320`	N				89.2	Exceeded		N	85.4	Exceeded	B	74	70.6		86.3	Exceeded	C	62	55.9	73	B	70	All Students	2023–24

1 2 3 … 307

Column dictionary — the state's own definitions

Shown as	State's column	Data type	State's description	Codes
Aaa score	`aaa_score`	`NUMERIC(38,0)`	Reading/Math Score
Achievement Score	`ach_score`	`NUMERIC(4,1)`	Overall Achievement Score
School key	`agency_code`	`VARCHAR(6)`	010303/010LEA/NC-SEA
Asm option	`asm_option`	`VARCHAR(1)`	Y/N if Alternative School that uses ASM model and therefore has no SPG grade
Awa score	`awa_score`	`NUMERIC(38,0)`	ACT/Workkeys Assessments Score
Bi score	`bi_score`	`NUMERIC(38,0)`	Biology Score
Cgrs score	`cgrs_score`	`NUMERIC(38,0)`	Standard CGR Score
Growth Score	`eg_score`	`NUMERIC(4,1)`	EVAAS Growth Score
Growth Status	`eg_status`	`VARCHAR(8)`	EVAAS Growth Status
Elp score	`elp_score`	`NUMERIC(38,0)`	English Learner Progress Score
K2 feeder	`k2_feeder`	`VARCHAR(1)`	Y/N if school is K2 and inherited SPG data from another school
Math Growth Score	`ma_eg_score`	`NUMERIC(4,1)`	Math EVAAS Growth Score
Math Growth Status	`ma_eg_status`	`VARCHAR(8)`	Math EVAAS Growth Status
Math Grade	`ma_spg_grade`	`VARCHAR(1)`	Math SPG Letter Grade
Math Score	`ma_spg_score`	`NUMERIC(38,0)`	Math SPG Score
Mags score	`mags_score`	`NUMERIC(4,1)`	Math 3-8 Score
Mcr score	`mcr_score`	`NUMERIC(38,0)`	Math Course Rigor Score
Reading Growth Score	`rd_eg_score`	`NUMERIC(4,1)`	Reading EVAAS Growth Score
Reading Growth Status	`rd_eg_status`	`VARCHAR(8)`	Reading EVAAS Growth Status
Reading Grade	`rd_spg_grade`	`VARCHAR(1)`	Reading SPG Letter
Reading Score	`rd_spg_score`	`NUMERIC(38,0)`	Reading SPG Score
Rdgs score	`rdgs_score`	`NUMERIC(4,1)`	Reading 3-8 Score
Scgs score	`scgs_score`	`NUMERIC(38,0)`	Science 5&8 Score
Performance Grade	`spg_grade`	`VARCHAR(1)`	Final SPG Letter Grade
Performance Score	`spg_score`	`NUMERIC(38,0)`	Final SPG Score
Student Group key	`subgroup`	`VARCHAR(8)`	Subgroup code	26 codes `AIAN` → American Indian / Alaskan Native `AIG` → Academically / Intellectually Gifted `ALL` → All Students `AM7` → American Indian `AS7` → Asian `ASPI` → Pacific Islander / Asian `BL7` → Black `EDS` → Economically Disadvantaged `ELS` → English Learners `FCS` → Foster Care `FEM` → Female `HI7` → Hispanic `HMS` → Homeless `MALE` → Male `MIG` → Migrant `MIL` → Military Connected `MU7` → Two or More Races `NAIG` → Not Academically / Intellectually Gifted `NEDS` → Not Economically Disadvantaged `NELS` → Not English Learners `NOT_EDS` → Not Economically Disadvantaged `NSWD` → Not Students With Disabilities `Other` → Other `PI7` → Pacific Islander `SWD` → Students With Disabilities `WH7` → White
School Year key	`year`	`VARCHAR(4)`	YYYY (i.e. 2006 for the 2005/06 school year)

About this table

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.

How this table got here

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.
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")

79,747 rows were then loaded from the state's raw data files into RcdAccSpg2.
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.

Want something like this for your program? Schedule a conversation or email matt@mattniksch.com.