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_v21 WHERE stats_v21.data_level = 'STATE' AND stats_v21.student_group = 'GENDER' AND state = 'Alabama' AND subject = 'SCIENCE' 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
Alabama (2017-18): In 2018, the state administered a new science assessment, the Scantron series. Results are not comparable to prior years.
Alabama (2020-21): In 2021, the state administered a new science assessment, the Alabama Comprehensive Assessment Program (ACAP). Results are not comparable to prior years.
Alabama (2020-21): Science participation rates in 2021 were 93.1%, which is lower than a typical year. Results should be interpreted with caution.
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 Science Performance in Washington for 2019 by Gender
"Math vs science in Washington for 2019 by gender"
ELA vs Math Performance in Pennsylvania for 2018 by Gender
"ELA vs math in Pennsylvania for 2018 by gender"
Reading vs Science Performance in Georgia (2014)
"Reading vs science in Georgia for 2014"