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 = 'RACE_ETH' AND state = 'California' AND subject = 'ELA' 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
California (2013-14): In 2014, no ELA assessment data are available due to field testing.
California (2014-15): In 2015, the state administered a new ELA assessment, the Smarter Balanced Assessment. Results are not comparable to prior years.
California (2020-21): In California, assessment participation rates overall (including ELA) in 2021 were 24%, which is lower than a typical year. Results should be interpreted with caution.
ELA vs Social Studies Performance in Michigan for 2021 by Ethnicity
"ELA vs social studies in Michigan for 2021 by ethnicity"
Math Scores in Alaska by Grade Over Time
"math scores in alaska by grade over time"
Bottom 5 School Districts in California in ELA for 2019
"Bottom 5 school districts in California in ELA for 2019"
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"
ELA vs Science Performance in Rhode Island for 2019
"ELA vs science in Rhode Island for 2019"