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 = 'SCHOOL'
AND stats_v31.student_group = 'ALL_STUDENTS'
AND subject = 'MATH'
AND state = 'New York'
AND school_name IN (
'PS 307 DANIEL HALE WILLIAMS',
'P.S. 307 DANIEL HALE WILLIAMS SCHOOL',
'PS 307 DANIEL HALE WILLIAMS SCHOOL'
)
AND nces_school_id = 360009102811
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
MathIn 2023, the state administered a new math assessment based on the New York State Next Generation Learning Standards. Results are not comparable to prior years.
MathIn New York, math participation rates in 2021 were 39.90%, which is lower than a typical year. Results should be interpreted with caution.
Math vs Science Performance in New York (2007)
"Math vs science in New York for 2007"
Math Scores in Alaska by Grade Over Time
"math scores in alaska by grade over time"
Math vs Social Studies Performance in Georgia for 2011
"Math vs social studies in Georgia for 2011"
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"