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 FROM stats_v2 WHERE stats_v2.data_level = 'STATE' AND stats_v2.student_group = 'ALL_STUDENTS' AND state = 'Virginia' 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
Notable Events
Virginia (2005-06): In 2006, the state administered a new math assessment. Results are not comparable to prior years.
Virginia (2011-12): In 2012, the state administered a new math assessment aligned to the 2009 Mathematics content standards. Results are not comparable to prior years.
Virginia (2018-19): In 2019, the state administered a new math assessment aligned to the 2016 Mathematics content standards. Results are not comparable to prior years.
Virginia (2020-21): In Virginia, math participation rates in 2021 were 78.7%, which is lower than a typical year. Results should be interpreted with caution.
Virginia (2023-24): In 2024, no math assessment data are currently available.
Math vs Reading Performance in Virginia by Grade Level (2012)
"Math vs reading in Virginia for 2012 by grade level"
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"
Math Scores in Alaska by Grade Over Time
"math scores in alaska by grade over time"
Science vs Social Studies Performance in Virginia for 2008 by Gender
"Science vs social studies in Virginia for 2008 by gender"
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"