About
Terms
SQL
Notable Events
Minnesota (2005-06): In 2006, the state administered a new math assessment aligned to the 2003 Minnesota Academic Standards, Minnesota Comprehensive Assessment II (MCA-II). Results are not comparable to prior years.
Minnesota (2010-11): In 2011, the state administered a new math assessment aligned to the 2007 Minnesota Academic Standards, Minnesota Comprehensive Assessment III (MCA-III). Results are not comparable to prior years.
Minnesota (2018-19): In 2019, the state began to report outcomes that aggregate results for the regular and alternate assessments. Comparisons to prior years should be made with caution.
SELECT
school_year,
(SUM(merged_proficient_or_above_count) * 100.0) / CAST(SUM(student_subgroup_total_tested) AS NUMERIC) AS proficiency_rate,
CASE
WHEN student_subgroup = 'ENGLISH_LEARNER' THEN 'English Learners'
ELSE 'Non-English Learners'
END AS english_learner_status
FROM
stats_v3
WHERE
stats_v3.data_level = 'STATE'
AND stats_v3.student_group = 'EL_STATUS'
AND state = 'Minnesota'
AND subject = 'MATH'
AND (
student_subgroup = 'ENGLISH_LEARNER'
OR student_subgroup = 'ENGLISH_PROFICIENT'
)
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,
english_learner_statusMath 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"
Math vs Social Studies Performance in Michigan (2015)
"Math vs social studies in Michigan for 2015"
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"
Math vs Social Studies Performance in Wisconsin by Grade Level (2016)
"Math vs social studies in Wisconsin for 2016 by grade level"