...
Asked ...
About
Loading...
Terms
Achievement gap is the difference in proficiency rate between two groups of students.
SQL
Loading...
More Like This
Loading...
About
Terms
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_v31
WHERE
stats_v31.data_level = 'STATE'
AND stats_v31.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
)
) > 0Notable Events
Math"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).
MathIn 2015, the state administered a new math assessment, the Georgia Milestones End-of-Grade (EOG) Assessment. Results are not comparable to prior years.