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 = 'GENDER'
AND state = 'Massachusetts'
AND district_name = 'Springfield'
AND nces_district_id = 2511130
AND subject IN ('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_subgroupNotable Events
MathIn 2018, the state administered a new math assessment aligned to the 2017 Massachusetts curriculum frameworks. However, results are comparable to prior years.
MathIn 2017, the state administered a new math assessment aligned to the 2011 Massachusetts curriculum frameworks, the Next-Gen MCAS. 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"
Science vs Social Studies Performance in Virginia for 2008 by Gender
"Science vs social studies in Virginia for 2008 by gender"
ELA vs Math Performance in Pennsylvania for 2018 by Gender
"ELA vs math in Pennsylvania for 2018 by gender"
Math Scores in Alaska by Grade Over Time
"math scores in alaska by grade over time"
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"