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, student_subgroup FROM stats_v2 WHERE stats_v2.data_level = 'STATE' AND stats_v2.student_group = 'GENDER' AND state = 'Iowa' 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, student_subgroup
Notable Events
Iowa (2018-19): In 2019, the state administered a new math assessment, the ISASP (Iowa Statewide Assessment of Student Progress). Results are not comparable to prior years.
Math vs Science Performance in Washington for 2019 by Gender
"Math vs science in Washington for 2019 by gender"
Math Scores in Alaska by Grade Over Time
"math scores in alaska by grade over time"
ELA vs Math Performance in Pennsylvania for 2018 by Gender
"ELA vs math in Pennsylvania for 2018 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"
Math vs Social Studies Performance in Wisconsin by Grade Level (2016)
"Math vs social studies in Wisconsin for 2016 by grade level"