{"main_topic":"education","sub_topic":"georgiainsights","topic":"georgia_milestones_end_of_course","key":"education/georgiainsights/georgia_milestones_end_of_course","version":"1.0.0","year_min":2015,"year_max":2025,"year_gaps":[],"update_frequency":"triannual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/georgia_milestones_end_of_course/year={year}/{detail}.parquet","grain":["year","district_code","school_code","administration","subject"],"title":"Georgia Milestones End-of-Course (EOC) Results","summary":"Georgia Milestones high-school end-of-course test results by school, district, and subject, 2015-2025.","description":"Georgia Milestones End-of-Course (EOC) assessment results for high-school core content areas, published for each of up to three administrations per school year (Winter mid-year retest, Spring primary, Full-Year aggregate) at the state, district/system, and school level. Core metrics are the count of students tested, the mean scale score, and the share of students at each of the four achievement levels (Beginning, Developing, Proficient, Distinguished Learner) plus the two cumulative shares. Literature subjects add a Reading Status split against a per-course Lexile threshold (9th Grade Literature 1050L through 2020; American Literature 1185L). Student Growth Percentile (SGP) metrics appear in the source layout from Spring 2024 but carry data only from the 2024-2025 school year (Algebra: Concepts & Connections and American Literature). Full-Year 2020-2021 uniquely includes enrolled_tested_rate, reflecting COVID-era participation drops.","source":"Georgia Insights (GaDOE) — Georgia Milestones End-of-Course Assessment","source_url":"https://georgiainsights.gadoe.org/data-downloads/","endpoint":"/api/v1/education/georgia_milestones_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., 2024 = school year 2023-2024). Winter administrations are stored under the school year they fall inside: Winter 2014 EOC is the 2014-2015 mid-year retest, stored as year=2015.","valid_values":null,"example":2024,"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) — 2015-2017 bronze published those rows under the bare system code 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":"administration","type":"string","role":"categorical","nullable":false,"label":"Administration","short_description":"Which test window the row covers: winter retest, spring primary, or the full-year aggregate.","description":"Which of the three publications a row comes from: winter = mid-year retest, spring = primary end-of-year administration, full_year = fall+winter+spring aggregate. The three slices are distinct cohorts, not duplicates.","valid_values":["winter","spring","full_year"],"example":"spring","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"subject","type":"string","role":"categorical","nullable":false,"label":"Subject","short_description":"The high-school course tested (e.g. biology, us_history, american_literature_and_composition).","description":"Snake-case EOC content area. The tested slate changed over time: 8-10 subjects through 2020 (incl. 9th Grade Literature, Physical Science, Economics, two algebra and two geometry courses), 5 from 2021, and 4 from 2024 (american_literature_and_composition, algebra_concepts_and_connections, biology, us_history). Full-Year 2020-2021's 8th-grade Physical Science administration is folded into physical_science.","valid_values":["9th_grade_literature_and_composition","algebra_concepts_and_connections","algebra_i","american_literature_and_composition","analytic_geometry","biology","coordinate_algebra","economics_business_free_enterprise","geometry","physical_science","us_history"],"example":"biology","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 tested. Never suppressed by the source — non-null on every row.","valid_values":null,"example":132,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"avg_scale_score","type":"number","role":"metric","nullable":true,"label":"Average Scale Score","short_description":"Average end-of-course scale score (about 400-650 in practice); higher means stronger performance.","description":"Mean scale score on the Georgia Milestones EOC scale. Reported scores span roughly 400-650; the contract enforces the full published EOC scale range of 140-820 (per-course bounds differ; Biology spans the full range per the GaDOE EOC Score Interpretation Guide). Preserved on its natural scale.","valid_values":null,"example":525.3,"unit":"score","value_min":140,"value_max":820,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"scale_score_std_dev","type":"number","role":"metric","nullable":true,"label":"Scale Score Std Dev","short_description":"","description":"Standard deviation of the scale scores — a dispersion measure, NOT a bounded score. Units are scale-score points; the value is always >= 0. Exempt from unit/range checks (it has no fixed upper bound). Published only by Spring 2015 system-level files, Winter 2021 files, and every file from Spring 2022 onward; NULL elsewhere.","valid_values":null,"example":57.4,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_beginning_learner","type":"number","role":"metric","nullable":true,"label":"Percent Beginning Learner","short_description":"","description":"Share of tested students at the Beginning Learner level (0-1 scale; bronze 0-100 divided by 100).","valid_values":null,"example":0.2113,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_developing_learner","type":"number","role":"metric","nullable":true,"label":"Percent Developing Learner","short_description":"","description":"Share at Developing Learner (0-1 scale).","valid_values":null,"example":0.3333,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_proficient_learner","type":"number","role":"metric","nullable":true,"label":"Percent Proficient Learner","short_description":"","description":"Share at Proficient Learner (0-1 scale).","valid_values":null,"example":0.3525,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_distinguished_learner","type":"number","role":"metric","nullable":true,"label":"Percent Distinguished Learner","short_description":"","description":"Share at Distinguished Learner (0-1 scale).","valid_values":null,"example":0.1026,"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 at Developing Learner or higher (= developing + proficient + distinguished). Published by the source and preserved verbatim rather than re-derived.","valid_values":null,"example":0.7885,"unit":"proportion","value_min":null,"value_max":null,"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 at Proficient Learner or higher (= proficient + distinguished). Published by the source and preserved verbatim.","valid_values":null,"example":0.4551,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_below_grade_level_lexile","type":"number","role":"metric","nullable":true,"label":"Percent Below Grade Level Lexile","short_description":"","description":"Reading Status: share of tested students reading below the course's Lexile threshold. Populated only for literature subjects. The threshold is per course, not per year: 9th Grade Literature uses 1050L (reported 2018-2020) and American Literature 1185L (reported 2018 onward; the 2018-2020 American Literature files label the threshold 1050L in their headers but the course moved to 1185L from 2021).","valid_values":null,"example":0.3397,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_grade_level_or_above_lexile","type":"number","role":"metric","nullable":true,"label":"Percent Grade Level or Above Lexile","short_description":"","description":"Reading Status: share reading at or above the Lexile threshold; complement of pct_below_grade_level_lexile. Populated only for literature subjects.","valid_values":null,"example":0.6603,"unit":"proportion","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 tested students who received a Student Growth Percentile. SGP columns exist in the source layout from Spring 2024, but the 2024 Algebra CC sheets are empty templates — populated data starts with the 2024-2025 school year (year=2025) for algebra_concepts_and_connections and american_literature_and_composition. NULL elsewhere.","valid_values":null,"example":143,"unit":"count","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":"","description":"Median Student Growth Percentile (1-99 percentile rank, preserved on its natural scale per data-cleaning-standards §4). Float64 because 2025 bronze publishes half-point medians (e.g. 61.5).","valid_values":null,"example":52.0,"unit":"percentile","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 (0-1 scale).","valid_values":null,"example":0.3287,"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 in the Typical Growth band (0-1 scale).","valid_values":null,"example":0.3217,"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 in the High Growth band (0-1 scale).","valid_values":null,"example":0.3497,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"enrolled_tested_rate","type":"number","role":"metric","nullable":true,"label":"Enrolled Tested Rate","short_description":"","description":"Share of enrolled students who actually tested. Published ONLY by the Full-Year 2020-2021 files (COVID participation year); NULL for every other administration.","valid_values":null,"example":0.9912,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"avg_scale_score","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,2020,2021,2022,2023,2024,2025],"schema_hash":"1b2606493498433fc1aec50e789777559ca5c3e707a30e160287239d3c18d243","tags":["education","georgia insights","georgia_milestones_end_of_course"],"granularity_description":"One row per year, district_code, school_code, administration, subject (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2025), schools detail","query":"SELECT * FROM georgia_milestones_end_of_course WHERE year = 2025 LIMIT 100"},{"description":"District 601 in 2025","query":"SELECT * FROM georgia_milestones_end_of_course WHERE district_code = '601' AND year = 2025 LIMIT 100"},{"description":"Filter by administration = spring","query":"SELECT * FROM georgia_milestones_end_of_course WHERE administration = 'spring' 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","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":"administration","kind":"categorical","column":"administration","type":"string","multi_value":true,"enum_enforced":true,"values":["winter","spring","full_year"],"has_total":false,"total_value":null,"requires_single_value":true},{"param":"subject","kind":"categorical","column":"subject","type":"string","multi_value":true,"enum_enforced":true,"values":["9th_grade_literature_and_composition","algebra_concepts_and_connections","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":[]}