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,
state
FROM
stats_v2
WHERE
stats_v2.data_level = 'STATE'
AND stats_v2.student_group = 'ALL_STUDENTS'
AND (
state = 'Indiana'
OR state = 'Minnesota'
)
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,
stateELA 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 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"
Math Scores in Alaska by Grade Over Time
"math scores in alaska by grade over time"
Notable Events
Indiana (2014-15): In 2015, the state administered a new ELA assessment based on updated college- and career-ready 2014 Indiana Academic Standards. Although the assessment name did not change, results are not comparable to prior years.
Indiana (2018-19): In 2019, the state administered a new ELA assessment, the ILEARN. Results are not comparable to prior years.
Minnesota (1997-98): In 1998, the state administered a new ELA assessment, the Minnesota Comprehensive Assessment (MCA). Results are not comparable to prior years.
Minnesota (2005-06): In 2006, the state administered a new ELA assessment aligned to the 2003 Minnesota Academic Standards, Minnesota Comprehensive Assessment II (MCA-II). Results are not comparable to prior years.
Minnesota (2012-13): In 2013, the state administered a new ELA assessment aligned to the 2010 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.