The Anderson School scores at the ceiling — and proves nothing

Summary

Profile of The Anderson School (M.S. 334), one of New York City's two K-8 city-wide G&T programs, illustrating a school whose outcome distribution is at the test ceiling because its admissions screen selects from the 90+ percentile of the kindergarten G&T assessment.

Data sources

• Database tableschools

  One row per New York City public school (DBN, name, district, borough, school_type, grade_band, latest_enrollment, proclivity_decile, proclivity_score, closed_at, admission_category).

• Database tableschool_year_metrics

  Long-format per-school per-year metric facts (school_dbn, year, metric_key, subgroup, value, suppressed). Loaded from DOE/NYSED public files via scripts/loaders/*.

• External datasetNYC DOE Gifted & Talented program documentation

Steps

1. Pull all-grade ELA + math proficiency at M.S. 334 (DBN 03M334), 2018-19 through 2024-25.

   SELECT year, metric_key, value
     FROM school_year_metrics
    WHERE school_dbn='03M334'
      AND metric_key IN ('ela_all_proficiency','math_all_proficiency')
      AND subgroup='ALL' AND suppressed=false
    ORDER BY year, metric_key;

2. Compare with peer K-8 G&T programs (NEST+m, TAG Young Scholars) for the same window.

Reproduce

Clone the repo, set DATABASE_URL to a Postgres with the project schema loaded, run `npx tsx scripts/loaders/<source>.ts` for any not-yet-loaded data, then issue the queries in the Steps section. The story page also lists the exact `metric_key`/`subgroup`/`year` filters used. Searchable by the answer's headline number — every figure is recomputable from the queries shown.