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_v31
WHERE
stats_v31.data_level = 'DISTRICT'
AND stats_v31.student_group = 'EL_STATUS'
AND state = 'California'
AND subject IN ('ELA', '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_subgroupMath Scores in Alaska by Grade Over Time
"math scores in alaska by grade over time"
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"
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"
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 Math Performance in Pennsylvania for 2018 by Gender
"ELA vs math in Pennsylvania for 2018 by gender"
Notable Events
Each subject is measured using a different assessment. Results should not be aggregated.
ELAIn California, assessment participation rates overall (including ELA) in 2021 were 24%, which is lower than a typical year. Results should be interpreted with caution.
MathIn California, assessment participation rates overall (including math) in 2021 were 24%, which is lower than a typical year. Results should be interpreted with caution.
ELAIn 2015, the state administered a new ELA assessment, the Smarter Balanced Assessment. Results are not comparable to prior years.
MathIn 2015, the state administered a new math assessment, the Smarter Balanced Assessment. Results are not comparable to prior years.