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,
subject
FROM
stats_v31
WHERE
stats_v31.data_level = 'STATE'
AND stats_v31.student_group = 'ALL_STUDENTS'
AND state = 'Texas'
AND subject IN ('ELA', '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,
subjectNotable Events
ELAMathIn 2023, the state re-designed the State of Texas Assessments of Academic Readiness (STAAR). Results are not comparable to prior years.
ELAMathIn 2017, Texas changed from three to four proficiency levels on the state assessment. Results may not be comparable to prior years.
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"
Reading vs Writing Performance in Texas for 2015
"Reading vs writing in Texas for 2015"
Math Scores in Alaska by Grade Over Time
"math scores in alaska by grade over time"
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"