About
Terms
SQL
SELECT
school_year,
(SUM(merged_proficient_or_above_count) * 100.0) / CAST(SUM(student_subgroup_total_tested) AS NUMERIC) AS proficiency_rate,
CASE
WHEN county_name ILIKE '%Walker County%' THEN 'Walker County'
ELSE 'State of Georgia'
END AS county_comparison
FROM
stats_v21
WHERE
stats_v21.data_level = 'DISTRICT'
AND stats_v21.student_group = 'ALL_STUDENTS'
AND state = 'Georgia'
AND subject = 'ELA'
AND school_year BETWEEN '2014-15' AND '2022-23'
AND county_name ILIKE '%walker%'
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,
county_comparisonELA vs Social Studies Performance in Georgia for 2019 by English Proficiency Status
"ELA vs social studies in Georgia for 2019 by english proficiency status"
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 Georgia for 2011
"Math vs social studies in Georgia for 2011"
Reading vs Writing Performance in Texas for 2015
"Reading vs writing in Texas for 2015"
Notable Events
Georgia (2014-15): In 2015, the state administered a new ELA assessment, the Georgia Milestones End-of-Grade (EOG) Assessment. Results are not comparable to prior years.