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,
subject
FROM
stats_v31
WHERE
stats_v31.data_level = 'DISTRICT'
AND stats_v31.student_group = 'ALL_STUDENTS'
AND state = 'Ohio'
AND subject IN ('ELA', 'MATH', 'SCIENCE', 'SOCIAL_STUDIES')
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,
subjectMath vs Social Studies Performance in Michigan (2015)
"Math vs social studies in Michigan for 2015"
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"
ELA vs Social Studies Performance in Michigan for 2021 by Ethnicity
"ELA vs social studies in Michigan for 2021 by ethnicity"
Math vs Social Studies Performance in Wisconsin by Grade Level (2016)
"Math vs social studies in Wisconsin for 2016 by grade level"
ELA vs Social Studies Performance in Georgia for 2019 by English Proficiency Status
"ELA vs social studies in Georgia for 2019 by english proficiency status"
Notable Events
ScienceIn 2021, Ohio administered a new science assessment aligned to the 2018 state science standards. However, cut scores remained unchanged. Results should be interpreted with caution
ELAIn 2019, the state administered a new ELA assessment aligned to the 2017 state ELA standards. However, cut scores remained unchanged, so results are comparable to prior years.
MathIn 2019, the state administered a new math assessment aligned to the 2017 state math standards. However, cut scores remained unchanged, so results are comparable to prior years.