...
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
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.
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_v11
WHERE
stats_v11.data_level = 'STATE'
AND stats_v11.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
)
) > 0Math 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"