{"main_topic":"education","sub_topic":"scsc","topic":"state_charter_academic_comparison","key":"education/scsc/state_charter_academic_comparison","version":"1.0.0","year_min":2021,"year_max":2025,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts"],"default_detail":"districts","path_template":"education/state_charter_academic_comparison/year={year}/{detail}.parquet","grain":["year","district_code","school_code","grade_cluster","measure"],"title":"State Charter Academic Comparison","summary":"How each Georgia state charter school scored against the local schools its students would otherwise attend, by measure and grade band, 2021-2025 (SCSC).","description":"State Charter Schools Commission of Georgia (SCSC) academic comparison for each state charter school, from SCSC's Comprehensive Performance Framework (CPF) results. Each row gives the charter's score on one academic measure in one grade band (elementary, middle, high, or the whole school) beside two comparison-zone scores, and the charter's margin over each. The school comparison score is the CCRPI score of the local schools the charter's students are zoned to attend, weighted by the share of the charter's students zoned to each; the district comparison score is the same weighting at district level. SCSC computes both from student addresses in GaDOE's Student Record, so they cannot be rebuilt from public data. A positive margin means the charter scored above its comparison zone. Every score is on the 0-100 CCRPI point scale. School years 2020-21 to 2024-25 (gold years 2021-2025); 2019-20 has no academic data because Georgia Milestones were not given (COVID). The measures change by year: 2021 used three stopgap measures (CCRPI was waived) and only a school comparison; 2022 has content mastery and progress, where progress is SCSC's own Student Growth Percentile replication of CCRPI Progress (calculated by Georgia Southern University), not GaDOE's CCRPI Progress; 2023-2025 have CCRPI content mastery, progress and the grade band score. Whole-school rows exist for 2022-2024 only. Each state charter school is its own single-school charter district, so rows are keyed by that district's 7-digit district_code with school_code NULL. SCSC's Value-Add measure, a statistical effect size on a different scale, is not included.","explorer":true,"search_aliases":{"en":["charter vs traditional","charter school performance","charter versus local","comparison zone","charter academic results","CPF scores","do charters outperform","SCSC"],"es":["escuelas chárter","chárter frente a tradicionales","desempeño de chárter","comparación académica","resultados de chárter","zona de comparación","escuelas autónomas","rendimiento académico"]},"source":"State Charter Schools Commission of Georgia (SCSC), via the Georgia Data Analytics Center","source_url":"https://scsc.georgia.gov/state-charter-school-accountability-renewal/scsc-comprehensive-performance-framework","endpoint":"/api/v1/education/state_charter_academic_comparison","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Ending calendar year of the school year (2025 = 2024-25), from the bronze school_year. Years 2021-2025; 2020 (2019-20) has no rows because testing was cancelled (COVID).","valid_values":null,"example":2025,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"district_code","type":"string","role":"fk_district","nullable":false,"label":"District Code","short_description":"","description":"7-digit GOSA code of the state charter school's single-school charter district (FK to the districts dimension): 782xxxx for a state charter school, 783xxxx for a commission charter school. Each district has exactly one school, so the code identifies the school.","valid_values":null,"example":"7830623","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"school_code","type":"string","role":"fk_school","nullable":true,"label":"School Code","short_description":"","description":"Always NULL: rows are keyed by the charter's single-school district code, and the column is kept for the shared education key shape (year, district_code, school_code).","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"grade_cluster","type":"string","role":"categorical","nullable":false,"label":"Grade Cluster","short_description":"Grade band: elementary, middle, high, or all (SCSC's enrollment-weighted whole-school score, 2022-2024 only).","description":"Grade band the scores describe: elementary, middle, high (SCSC's E/M/H), or all, SCSC's Whole School Score, which SCSC's framework defines as an enrollment-weighted average of the school's band scores (for example 60% elementary plus 40% middle), compared with the same weighting of the comparison-zone scores. It is never a sum, and cannot be rebuilt from the band rows because SCSC does not publish the weights. Whole-school rows exist for 2022 (content mastery only) through 2024; SCSC dropped them for 2025. Two kinds of whole-school value in SCSC's file cannot be that weighted average and are set to NULL here (17 cells), so their margins are NULL too. (1) When a band has no charter score (too few students, or not available), SCSC's whole-school charter score counts that band's enrollment share as 0, while the whole-school comparison scores still include that band's zone, which understates the charter. The whole-school charter score is NULL on those 15 rows (2022: 2, 2023: 11, 2024: 2); their comparison scores are kept. For example Atlanta Unbound Academy (7830632) 2024 progress was published as 27 against 82 (margin -55), while its only scored band, middle, is 79 against 80. (2) Georgia Fugees Academy (7830634) 2022 whole-school content mastery was published as charter 40.14 and school comparison 47.74, outside the range of its band values (charter 16.7-22.1, comparison 39.2-42.6) and consistent with a column shift in SCSC's file; both are NULL here. SCSC's own schoolwide designations used the published values (see the state_charter_accountability_designations topic).","valid_values":["all","elementary","high","middle"],"example":"elementary","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"measure","type":"string","role":"categorical","nullable":false,"label":"Measure","short_description":"Academic measure compared: content mastery, progress or grade band score (2022 on), or one of three 2021 stopgap measures.","description":"SCSC academic measure. content_mastery: CCRPI Content Mastery (2022-2025). progress: CCRPI Progress (2023-2025); in 2022 it is SCSC's own Student Growth Percentile replication of CCRPI Progress (calculated by Georgia Southern University), because GaDOE published no CCRPI Progress that year. grade_band_score: SCSC's combination of the CCRPI components with the 2019 CCRPI Calculation Guide weights (2023-2025). 2021 only, when CCRPI was waived and SCSC built stopgap measures from Georgia Milestones files: content_mastery_adjusted (SCSC-calculated content mastery adjusted for participation), content_mastery_non_adjusted (the same without the participation adjustment) and gadoe_achievement (GaDOE achievement scores for full-academic-year students). Measures are different scales of achievement and are never combined.","valid_values":["content_mastery","content_mastery_adjusted","content_mastery_non_adjusted","gadoe_achievement","grade_band_score","progress"],"example":"content_mastery","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"charter_score","type":"number","role":"metric","nullable":true,"label":"Charter Score","short_description":"The charter school's own score on the measure and grade band (0-100 CCRPI points).","description":"The charter school's own score on the measure, as SCSC reports it. On the 0-100 CCRPI point scale, as SCSC published it (never rounded here): full decimals through 2023, whole numbers from 2024, when SCSC began calculating every score to the nearest whole number. A value within 1e-9 outside 0-100 (floating-point noise in SCSC's file) is set to the bound. It is the school's CCRPI score: content mastery matches the ccrpi_scoring_by_component topic within 0.5 points on 337 of 339 comparable rows (2022-2025), and progress on all 256 comparable rows (2023-2025). The two exceptions are International Charter School of Atlanta (7820614) 2022 elementary (84.7 here, 89.7 there) and middle (78.7 vs 94.2): SCSC's figures, published as given. One value is set to its bound: Yi Hwang Academy of Language Excellence (7830625) 2023 whole-school (all) progress, published as 100.00000000000007, is 100 here. The school has only elementary rows and its elementary progress is exactly 100, so the excess is floating-point noise in SCSC's weighted average. Apart from the 16 whole-school values set to NULL (see null_meaning), every other value is published as given.","valid_values":null,"example":93.0,"unit":"score","value_min":0,"value_max":100,"null_meaning":"SCSC published no score: TFS (too few students), NA (not available) or an empty cell. Some school-years have no score for any measure (e.g. DeKalb Brilliance Academy 2023, Sankofa Montessori 2024); their rows are kept. On 16 whole-school (all) rows SCSC's published score is set to NULL here because it cannot be SCSC's weighted average of the bands: 15 that count a band with no charter score as 0, and Georgia Fugees Academy 2022 content mastery (see grade_cluster).","key_metric_grain_contributor":false,"metric_component":null},{"name":"school_comparison_score","type":"number","role":"metric","nullable":true,"label":"School Comparison Score","short_description":"Score of the local schools the charter's students are zoned to, weighted by where they are zoned (0-100).","description":"SCSC's school comparison zone score: the scores of the traditional public schools the charter's students are zoned to attend, weighted by the share of the charter's students zoned to each (zoning from student addresses in GaDOE's Student Record; not reproducible from public data). It is the comparison SCSC published for every year and grade band (the only one in 2021; the district comparison covers only part of 2022). In 2022-2024 SCSC credited a charter for outperforming either this or the district comparison. On the 0-100 CCRPI point scale, as SCSC published it (never rounded here): full decimals through 2023, whole numbers from 2024, when SCSC began calculating every score to the nearest whole number. A value within 1e-9 outside 0-100 (floating-point noise in SCSC's file) is set to the bound.","valid_values":null,"example":75.0,"unit":"score","value_min":0,"value_max":100,"null_meaning":"SCSC published no comparison score (an empty cell); through 2024 this happens only on rows where the charter itself has no score. One published value is set to NULL: Georgia Fugees Academy (7830634) 2022 whole-school content mastery, 47.74, outside its band values' range (see grade_cluster).","key_metric_grain_contributor":false,"metric_component":null},{"name":"district_comparison_score","type":"number","role":"metric","nullable":true,"label":"District Comparison Score","short_description":"Score of the districts the charter's students are zoned to, weighted by where they are zoned (0-100).","description":"SCSC's district comparison zone score: the same weighting as the school comparison, at district level. On the 0-100 CCRPI point scale, as SCSC published it (never rounded here): full decimals through 2023, whole numbers from 2024, when SCSC began calculating every score to the nearest whole number. A value within 1e-9 outside 0-100 (floating-point noise in SCSC's file) is set to the bound. In 2022-2024 SCSC credited a charter for outperforming either the school or the district comparison, in every grade band. The 2024-25 framework (gold 2025) uses the district comparison only for the middle and high grade bands, so the 2025 elementary district comparison scores in SCSC's file were not used in its 2025 designations; they are published as given.","valid_values":null,"example":77.0,"unit":"score","value_min":0,"value_max":100,"null_meaning":"SCSC published no district comparison: none at all in 2021, none for 115 of 189 rows in 2022 (progress and part of content mastery), and otherwise an empty cell on rows where the charter has no score.","key_metric_grain_contributor":false,"metric_component":null},{"name":"margin_over_school_comparison","type":"number","role":"metric","nullable":true,"label":"Margin Over School Comparison","short_description":"Charter score minus its school comparison score, in CCRPI points; positive means the charter scored higher.","description":"charter_score minus school_comparison_score, derived here and never rounded: how many 0-100 CCRPI points the charter scored above (positive) or below (negative) the schools its students would otherwise attend. The key metric because the school comparison is the one SCSC published for every year and grade band; in 2022-2024 SCSC also credited a charter for beating the district comparison (see margin_over_district_comparison). See grade_cluster for the whole-school values set to NULL.","valid_values":null,"example":18.0,"unit":"score","value_min":-100,"value_max":100,"null_meaning":"NULL when charter_score or school_comparison_score is NULL.","key_metric_grain_contributor":false,"metric_component":null},{"name":"margin_over_district_comparison","type":"number","role":"metric","nullable":true,"label":"Margin Over District Comparison","short_description":"","description":"charter_score minus district_comparison_score, derived here and never rounded: the charter's margin in 0-100 CCRPI points over the districts its students are zoned to. See district_comparison_score for its coverage.","valid_values":null,"example":16.0,"unit":"score","value_min":-100,"value_max":100,"null_meaning":"NULL when charter_score or district_comparison_score is NULL (always in 2021).","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"margin_over_school_comparison","numeric_filter_columns":["charter_score","school_comparison_score","district_comparison_score","margin_over_school_comparison","margin_over_district_comparison"],"usage":"Star-schema fact table. Join the districts dimension on district_code; the schools dimension on district_code + school_code. Read directly with DuckDB over Parquet.","limitations":"Suppressed cells are NULL (not zero). District rows have NULL school_code. Scores and margins never add up: not across measures, grade bands, schools or years. The whole-school (grade_cluster all) row is an enrollment-weighted average of the band rows, with weights SCSC does not publish, and an average across schools is unweighted. Whole-school values that cannot be that weighted average are NULL here (17 cells: charter scores that count a band with no charter score as 0, and Georgia Fugees Academy 2022 content mastery; see grade_cluster), although SCSC's schoolwide designations used them. The measures change by year (2021 stopgap measures; 2022 progress is SCSC's own growth replication, not CCRPI Progress), so a trend in one measure is only meaningful within the years it covers. The comparison scores are SCSC's own and cannot be rebuilt from public data. SCSC's per-row determination letters are not carried: they could not be confirmed as one consistent designation across years. SCSC's Value-Add measure is not included.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2021,2022,2023,2024,2025],"schema_hash":"ed84b41638ed60888b432b9bed3761f78126c9d7e7d6493cbe27c9edeae5086f","tags":["education","state charter schools commission of georgia","state_charter_academic_comparison","scsc","cpf"],"granularity_description":"One row per year, district_code, school_code, grade_cluster, measure.","example_queries":[{"description":"Latest year (2025), districts detail","query":"SELECT * FROM state_charter_academic_comparison WHERE year = 2025 LIMIT 100"},{"description":"District 7830623 in 2025","query":"SELECT * FROM state_charter_academic_comparison WHERE district_code = '7830623' AND year = 2025 LIMIT 100"},{"description":"Filter by grade_cluster = elementary","query":"SELECT * FROM state_charter_academic_comparison WHERE grade_cluster = 'elementary' AND year = 2025 LIMIT 100"}],"foreign_keys":[{"column":"district_code","target_object":"districts","target_columns":["district_code"],"attribute_columns_added":["district_name","district_census_id","district_type"],"scope":"domain"},{"column":"school_code","target_object":"schools","target_columns":["district_code","school_code"],"attribute_columns_added":["school_name"],"scope":"domain"}],"filters":[{"param":"year","kind":"year_exact","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_min","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_max","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"detail","kind":"detail","type":"string","multi_value":false,"enum_enforced":true,"values":["districts"],"default":"districts"},{"param":"district_code","kind":"foreign_key","column":"district_code","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"school_code","kind":"foreign_key","column":"school_code","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"grade_cluster","kind":"categorical","column":"grade_cluster","type":"string","multi_value":true,"enum_enforced":true,"values":["all","elementary","high","middle"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"measure","kind":"categorical","column":"measure","type":"string","multi_value":true,"enum_enforced":true,"values":["content_mastery","content_mastery_adjusted","content_mastery_non_adjusted","gadoe_achievement","grade_band_score","progress"],"has_total":false,"total_value":null,"requires_single_value":true,"nullable":false,"null_filter_token":null},{"param":"district_type","kind":"dimension_attribute","dimension":"districts","column":"district_type","type":"string","multi_value":true,"enum_enforced":true,"values":["commission_charter","resa","standard","state_agency","state_charter","state_school","state_special"]},{"param":"school_level","kind":"dimension_attribute","dimension":"schools","column":"school_level","type":"string","multi_value":true,"enum_enforced":true,"values":["elementary","middle","high","k12","other"]},{"param":"locale","kind":"dimension_attribute","dimension":"schools","column":"locale","type":"string","multi_value":true,"enum_enforced":true,"values":["city","suburb","town","rural"]}],"filter_hints":[],"non_additive":[],"partitions":[],"value_implications":[],"year_meaning":null,"pooled_rates":[],"series_breaks":[],"year_window":null,"pooled_min_count":null,"values_endpoint":"/api/v1/education/state_charter_academic_comparison/values"}