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,
CASE
WHEN subject = 'ELA' THEN 'ELA'
ELSE 'Other Subjects'
END AS subject
FROM
stats_v21
WHERE
stats_v21.data_level = 'STATE'
AND stats_v21.student_group = 'ALL_STUDENTS'
AND state = 'Massachusetts'
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,
subjectNotable Events
Massachusetts (2014-15): In 2015, the state administered a new ELA assessment, PARCC. However, districts were allowed to choose whether to administer the Legacy MCAS or the PARCC assessment in [2015] and results reflect both assessments. Results are not comparable to prior years.
Massachusetts (2015-16): In 2016, districts were allowed to choose whether to administer the Legacy MCAS or the PARCC assessment and results reflect both assessments. Results are not comparable to prior years.
Massachusetts (2016-17): In 2017, the state administered a new ELA assessment aligned to the 2011 Massachusetts curriculum frameworks, the Next-Gen MCAS. Results are not comparable to prior years.
Massachusetts (2017-18): In 2018, the state administered a new ELA assessment aligned to the 2017 Massachusetts curriculum frameworks. However, results are comparable to prior years.
Math Scores in Alaska by Grade Over Time
"math scores in alaska by grade over time"
ELA vs Social Studies Performance in Michigan for 2021 by Ethnicity
"ELA vs social studies in Michigan for 2021 by ethnicity"
ELA vs Science Performance in Rhode Island for 2019
"ELA vs science in Rhode Island for 2019"
ELA vs Math Performance in Pennsylvania for 2018 by Gender
"ELA vs math in Pennsylvania for 2018 by gender"
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"