{"main_topic":"education","sub_topic":"georgiainsights","topic":"georgia_student_growth_model_end_of_course","key":"education/georgiainsights/georgia_student_growth_model_end_of_course","version":"1.0.0","year_min":2015,"year_max":2023,"year_gaps":[2020,2021,2022],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/georgia_student_growth_model_end_of_course/year={year}/{detail}.parquet","grain":["year","district_code","school_code","subject"],"title":"Student Growth Model (SGM) End-of-Course Results","summary":"Student growth percentiles on Georgia Milestones end-of-course tests by school, district, and subject, 2015-2023.","description":"Georgia Student Growth Model (GSGM / Student Growth Percentile) results on Georgia Milestones End-of-Course assessments, at the state, district/system, and school level per subject. Core metrics are the median Student Growth Percentile (1-99), the count of students receiving an SGP, and growth-share metrics. 2015-2019 publish the count and share of tested students with an SGP, two achievement-level cumulative shares (Proficient / Developing Learner or above), and the share with Typical-or-High growth (SGP >= 35). The Full-Year 2022-2023 report (year 2023) redesigns the metric set: a three-band SGP split (Low < 35, Typical 35-65, High > 65) replaces the single typical-or-high share, and the tested counts, received-SGP share, and achievement shares are no longer reported. No GSGM was published for 2020-2022 (COVID). Subject coverage narrows from 8-10 subjects (2015-2016) to six (2017-2019) to two algebra courses (2023).","source":"Georgia Insights (GaDOE) — Georgia Student Growth Model on End-of-Course assessments","source_url":"https://georgiainsights.gadoe.org/data-downloads/","endpoint":"/api/v1/education/georgia_student_growth_model_end_of_course","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Ending calendar year of the school year (e.g., 2017 = school year 2016-2017). Published years: 2015-2019 and 2023 (the Full-Year 2022-2023 report). No 2020-2022 data exists.","valid_values":null,"example":2017,"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":true,"label":"District Code","short_description":"","description":"3-digit GOSA district/system code (FK to districts dimension). School-level rows for State/Commission Charter campuses use the 7-digit campus code (system 782/783 + school code) — the 2015-2017 School files published those rows under the bare system code inside the compound Key and they are promoted here. NULL for state-level rows.","valid_values":null,"example":"601","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":"4-digit GOSA school code (FK to schools dimension, composite with district_code). NULL for district- and state-level rows.","valid_values":null,"example":"0103","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"subject","type":"string","role":"categorical","nullable":false,"label":"Subject","short_description":"The end-of-course subject (e.g. algebra_i, biology, american_literature_and_composition).","description":"Snake-case EOC subject. 2015 reports eight subjects (9th_grade_literature_and_composition, american_literature_and_composition, coordinate_algebra, analytic_geometry, biology, physical_science, us_history, economics_business_free_enterprise); 2016 adds algebra_i and geometry (ten); 2017-2019 report the six literature/math subjects; 2023 reports only coordinate_algebra and algebra_i.","valid_values":["9th_grade_literature_and_composition","algebra_i","american_literature_and_composition","analytic_geometry","biology","coordinate_algebra","economics_business_free_enterprise","geometry","physical_science","us_history"],"example":"algebra_i","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"num_tested","type":"integer","role":"metric","nullable":true,"label":"Number Tested","short_description":"","description":"Number of students who took the EOC assessment. Never suppressed where published. NULL in 2023 (the Full-Year 2022-2023 report does not publish tested counts).","valid_values":null,"example":255,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_sgp_received","type":"integer","role":"metric","nullable":true,"label":"Number SGP Received","short_description":"","description":"Number of students with enough prior-year scores to receive a Student Growth Percentile (a subset of num_tested). Suppressed (NULL) for small cohorts in the 2019 files only.","valid_values":null,"example":245,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"sgp_received_rate","type":"number","role":"metric","nullable":true,"label":"SGP Received Rate","short_description":"","description":"Share of tested students who received an SGP (num_sgp_received / num_tested), 0-1 scale (bronze 0-100 divided by 100). NULL in 2023 (not reported).","valid_values":null,"example":0.96,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"sgp_median","type":"number","role":"metric","nullable":true,"label":"SGP Median","short_description":"Median student growth percentile (1-99); 50 is average growth, higher means faster growth than similar peers.","description":"Median Student Growth Percentile on the 1-99 percentile-rank scale (preserved verbatim — not a share; there is no SGP of 0 or 100, so the range guard is tightened from the percentile default [0, 100] to [1, 99]). Float64 because bronze publishes half-point medians (e.g., 43.5). The 2016 System Physical Science sheet stored an undocumented 9999 suppression sentinel in 11 rows — impossible on this scale, NULLed per §4b.","valid_values":null,"example":52.0,"unit":"percentile","value_min":1,"value_max":99,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_proficient_learner_or_above","type":"number","role":"metric","nullable":true,"label":"Percent Proficient Learner or Above","short_description":"","description":"Share of tested students at the Proficient Learner achievement level or higher on the EOC assessment itself (0-1 scale). Published 2015-2019 only; NULL in 2023. The 9999 sentinel note on sgp_median also applies (11 NULLed values in 2016 Physical Science system rows).","valid_values":null,"example":0.42,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_developing_learner_or_above","type":"number","role":"metric","nullable":true,"label":"Percent Developing Learner or Above","short_description":"","description":"Share of tested students at the Developing Learner achievement level or higher on the EOC assessment (0-1 scale). Published 2015-2019 only; NULL in 2023.","valid_values":null,"example":0.8,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_sgp_typical_or_high_growth","type":"number","role":"metric","nullable":true,"label":"Percent SGP Typical or High Growth","short_description":"","description":"Share of SGP-scored students with SGP >= 35 (Typical or High growth), 0-1 scale. Published 2015-2019 only — 2023 replaces it with the three-band split. NOT equal to pct_sgp_typical_growth, which excludes High.","valid_values":null,"example":0.68,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_sgp_low_growth","type":"number","role":"metric","nullable":true,"label":"Percent SGP Low Growth","short_description":"","description":"Share of SGP-scored students in the Low Growth band (SGP < 35), 0-1 scale. 2023 only; NULL for 2015-2019.","valid_values":null,"example":0.22,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_sgp_typical_growth","type":"number","role":"metric","nullable":true,"label":"Percent SGP Typical Growth","short_description":"","description":"Share of SGP-scored students in the Typical Growth band (35 <= SGP <= 65), 0-1 scale. 2023 only; NULL for 2015-2019. Excludes High growth — not comparable to pct_sgp_typical_or_high_growth.","valid_values":null,"example":0.35,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_sgp_high_growth","type":"number","role":"metric","nullable":true,"label":"Percent SGP High Growth","short_description":"","description":"Share of SGP-scored students in the High Growth band (SGP > 65), 0-1 scale. 2023 only; NULL for 2015-2019.","valid_values":null,"example":0.43,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"sgp_median","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). State rows have NULL district_code and school_code. District rows have NULL school_code.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2015,2016,2017,2018,2019,2023],"schema_hash":"b61cbc13276d29f15eb1165e51a0bae4fe514b4bb6dd4989f5be02a6433e4db1","tags":["education","georgia insights","georgia_student_growth_model_end_of_course"],"granularity_description":"One row per year, district_code, school_code, subject (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2023), schools detail","query":"SELECT * FROM georgia_student_growth_model_end_of_course WHERE year = 2023 LIMIT 100"},{"description":"District 601 in 2023","query":"SELECT * FROM georgia_student_growth_model_end_of_course WHERE district_code = '601' AND year = 2023 LIMIT 100"},{"description":"Filter by subject = algebra_i","query":"SELECT * FROM georgia_student_growth_model_end_of_course WHERE subject = 'algebra_i' AND year = 2023 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","schools","states"],"default":"schools"},{"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":"subject","kind":"categorical","column":"subject","type":"string","multi_value":true,"enum_enforced":true,"values":["9th_grade_literature_and_composition","algebra_i","american_literature_and_composition","analytic_geometry","biology","coordinate_algebra","economics_business_free_enterprise","geometry","physical_science","us_history"],"has_total":false,"total_value":null,"requires_single_value":true},{"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"]}],"filter_hints":[]}