Achievement Gap Between Black and White Students in Georgia in Math Over Time

Show the achievement gap between Black and White students in Georgia in math over time

Asked 809 days ago

...

Asked ...

Result

About

This line graph represents the achievement gap in math between Black and White students in Georgia over various school years.

Terms

Achievement gap is the difference in proficiency rate between two groups of students.

Notable Events

Georgia (2014-15): In 2015, the state administered a new math assessment, the Georgia Milestones End-of-Grade (EOG) Assessment. Results are not comparable to prior years.

Georgia (2023-24): "The 2023-24 school year was the first year of implementation of Georgia’s new K-12 Mathematics Standards and associated mathematics assessments. The State Board approved new mathematics achievement standards (cut scores) for the Proficient and Distinguished Learner levels on the Georgia Milestones mathematics assessments (Levels 3 and 4).

SQL

SELECT
  school_year,
  ABS(
    (
      (
        SUM(
          CASE
            WHEN student_subgroup = 'BLACK_OR_AFRICAN_AMERICAN' THEN merged_proficient_or_above_count
            ELSE 0
          END
        ) * 100.0
      ) / (
        NULLIF(
          SUM(
            CASE
              WHEN student_subgroup = 'BLACK_OR_AFRICAN_AMERICAN' THEN student_subgroup_total_tested
              ELSE 0
            END
          ),
          0
        )
      )
    ) - (
      (
        SUM(
          CASE
            WHEN student_subgroup = 'WHITE' THEN merged_proficient_or_above_count
            ELSE 0
          END
        ) * 100.0
      ) / (
        NULLIF(
          SUM(
            CASE
              WHEN student_subgroup = 'WHITE' THEN student_subgroup_total_tested
              ELSE 0
            END
          ),
          0
        )
      )
    )
  ) AS achievement_gap
FROM
  stats_v3
WHERE
  stats_v3.data_level = 'STATE'
  AND stats_v3.student_group = 'RACE_ETH'
  AND state = 'Georgia'
  AND subject = 'MATH'
  AND merged_proficient_or_above_count IS NOT NULL
  AND student_subgroup_total_tested IS NOT NULL
  AND student_subgroup_total_tested > 0
GROUP BY
  school_year
HAVING
  (
    NULLIF(
      SUM(
        CASE
          WHEN student_subgroup = 'BLACK_OR_AFRICAN_AMERICAN' THEN student_subgroup_total_tested
          ELSE 0
        END
      ),
      0
    )
  ) > 0
  AND (
    NULLIF(
      SUM(
        CASE
          WHEN student_subgroup = 'WHITE' THEN student_subgroup_total_tested
          ELSE 0
        END
      ),
      0
    )
  ) > 0

More Like This

Math vs Social Studies Performance in Georgia for 2011

"Math vs social studies in Georgia for 2011"

Math Scores in Alaska by Grade Over Time

"math scores in alaska by grade over time"

Achievement Gap in Writing Over Time between English Proficient and English Learning Students in Virginia

"Achievement gap in Virginia in writing over time between english proficient and english learning students"

Reading vs Science Performance in Georgia (2014)

"Reading vs science in Georgia for 2014"

Math vs Social Studies Performance in Michigan (2015)

"Math vs social studies in Michigan for 2015"