About
Terms
SQL
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 '%Durham%' THEN 'Durham'
ELSE 'Rest of State'
END AS county_comparison
FROM
stats_v31
WHERE
stats_v31.data_level = 'DISTRICT'
AND stats_v31.student_group = 'ALL_STUDENTS'
AND state = 'North Carolina'
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,
county_comparisonNotable Events
MathIn North Carolina, the assessment participation rate across subjects in 2021 was 93%, which is lower than a typical year. Results should be interpreted with caution.
MathIn 2019, the state administered a new math assessment, the End-of-Grade (EOG) Tests - Edition 5. Results are not comparable to prior years.
Math vs Social Studies Performance in Georgia for 2011
"Math vs social studies in Georgia for 2011"
Math vs Reading Performance in Virginia by Grade Level (2012)
"Math vs reading in Virginia for 2012 by grade level"
Math vs Social Studies Performance in Texas for 2016 by English Proficiency Status
"Math vs social studies in Texas for 2016 by english proficiency status"
Math vs Social Studies Performance in Michigan (2015)
"Math vs social studies in Michigan for 2015"
Math vs Science Performance in Pennsylvania for 2018 by Economic Status
"Math vs science in Pennsylvania for 2018 by economic status"