About
Terms
SQL
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, school_name FROM stats_v31 WHERE stats_v31.data_level = 'DISTRICT' AND stats_v31.student_group = 'ALL_STUDENTS' AND district_name ILIKE '%norwalk%' AND state = 'Connecticut' AND subject = '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, school_name
Math Scores in Alaska by Grade Over Time
"math scores in alaska by grade over time"
Math vs Science Performance in New York (2007)
"Math vs science in New York for 2007"
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"
Math vs Reading Performance in Virginia by Grade Level (2012)
"Math vs reading in Virginia for 2012 by grade level"
Notable Events
Connecticut (2005-06): In 2006, the state administered a new math assessment, the CMT4. Results are not comparable to prior years.
Connecticut (2012-13): In 2013, no tested counts are available at the state level, which may affect visualizations.
Connecticut (2013-14): In 2014, no math assessment data are available due to field testing.
Connecticut (2014-15): In 2015, the state administered a new math assessment, the Smarter Balanced Assessment. Results are not comparable to prior years.
Connecticut (2020-21): In Connecticut, the assessment participation rate across ELA and math in 2021 was 93.5%, which is lower than a typical year. Results should be interpreted with caution.