← All proof trees · ETHAN ALLEN SCHOOL

1. 1
   What you see4th grade MATH proficiency (PSSA)

   11.8%

   the share of tested grade-4 students scoring proficient or advanced on the PSSA math test. Based on 51 students.

   vs. peers

   22th percentile

   vs. citywide

   25th percentile

   unit

   percent

   direction

   higher is better

2. 2
   How it was computedvalue = published '% proficient or advanced' (accountability cohort by default)

   1. Unzip the district's PSSA/Keystone archive and read the accountability-cohort ('Acct') and all-tested ('Actual') school CSVs.
   2. Keep rows for the test, subject, grade, and subgroup this metric represents.
   3. Store the published '% proficient or advanced' as the value and the published number tested as the denominator; suppressed cells (asterisks/blanks) are stored as suppressed, not zero.
   4. Store the accountability-cohort cut as the default (population_cut = 'acct') and the all-tested cut alongside it ('actual').

   Citywide percentile, reconstructed right now

   Among 68 default-included schools with a value for this metric, year, and subgroup, this school has a higher value than 17. Midrank rule: (17 + 0/2) / (68 − 1) = 0.254.Stored: 0.254. ✓ matches

   How percentiles are computed · How peer groups are chosen

   Peer percentile, reconstructed right now

   Peer group: up to 40 of the demographically nearest schools among Elementary-Middle / catchment / district schools; 23 of 40 peers have a value this year. This school is above 5 of them. Midrank: (5 + 0/2) / (24 − 1) = 0.217; stored 0.217. ✓ matches

   The peers and their values (23)

   Peer school	Value
   COPPIN, FANNY JACKSON SCHOOL	75.0%
   HANCOCK DEMONSTRATION SCHOOL	59.1%
   HENRY C. LEA SCHOOL	45.5%
   STEPHEN DECATUR SCHOOL	41.9%
   ROBERT B. POLLOCK SCHOOL	41.5%
   SOUTHWARK SCHOOL	38.3%
   GEORGE W CHILDS SCHOOL	34.8%
   JOHN H. TAGGART SCHOOL	30.4%
   MAYFAIR SCHOOL	29.8%
   THOMAS HOLME SCHOOL	29.2%
   ELIZA B. KIRKBRIDE SCHOOL	29.0%
   LOUIS H. FARRELL SCHOOL	26.3%
   GILBERT SPRUANCE SCHOOL	25.8%
   NORTHEAST COMMUNITY PROPEL ACADEMY	23.9%
   A.L. FITZPATRICK SCHOOL	18.5%
   BENJAMIN FRANKLIN ELEM. SCHOOL	16.7%
   HON. LUIS MUNOZ-MARIN SCHOOL	15.4%
   OLNEY ELEMENTARY SCHOOL	15.2%
   JUNIATA PARK ACADEMY	10.9%
   JULIA DE BURGOS ELEMENTARY	8.0%
   HAMILTON DISSTON SCHOOL	7.9%
   FRANCIS HOPKINSON SCHOOL	6.5%
   ANDREW J. MORRISON SCHOOL	4.8%

   Note: stored percentiles are computed by a batch script after loads; a difference from the live reconstruction means a newer load changed the comparison set and the batch has not been re-run.

   Evidence: metric tree: 4th grade MATH proficiency (PSSA)

3. 3
   The stored cellThe stored cell

   table

   philly_school_year_metrics

   value

   11.76

   denominator

   51

   suppressed

   false

   citywide_percentile

   0.2537

   comparison_group_percentile

   0.2174

   source_load_id

   bba25088-d2c0-415a-b47e-c47d1dcb2edc

   Evidence: data model overview

4. 4
   The load that wrote itWritten on 2026-06-03 by sdp_pssa_keystone.ts

   source id

   sdp_pssa_keystone_2024-25

   file URL

   https://cdn.philasd.org/offices/performance/Open_Data/School_Performance/PSSA_Keystone/2024_2025_PSSA_Keystone_All_Data.zip

   SHA-256 of the file read

   d040e16c1b88f33dd481efbdb1a3924951ab7cc81869c8dee52458280574c13aCopy hash

   bytes

   705,262

   year covered

   2024-25

   code commit

   63ddc08c2a63170cecb6e78b991559cef9aa3926

   To confirm you have the same file: download it from the URL above, then run shasum -a 256 <downloaded file> Copy command — the output should equal the hash above. If the publisher has since replaced the file, the hashes will differ, which is itself useful to know.

   Evidence: loader script · first-fetch findings for this file · source registry

5. 5
   The publisher's filePSSA & Keystone results, 2024-25

   School District of Philadelphia (Performance Office). State test results by school, test, subject, grade, and subgroup: counts and shares at each performance level, in two population cuts — the accountability cohort (students enrolled for the full year) and all tested students.

   format

   ZIP of CSVs (accountability-cohort and all-tested cuts)

   join key

   id_eos (= ULCS Code)

   landing page

   https://opendataphilly.org/datasets/sdp-pssa-keystone-performance/

   • Two cuts of the same results; the accountability cohort is the canonical one served by default.
   • District-run and alternative schools only; charter results come from the state's Future Ready file.
6. 6
   How it was checkedChecks: 0 passed, 2 flagged, 1 not run

   • ○ not runBase case not run for this grade/subject specifically (run for the all-grades aggregates and grade 3 ELA; same loader and file)
   • ⚠ flaggedAccountability-cohort vs all-tested files are byte-identical after sorting in SDP's 2024-25 archive — a publisher defect, so this check cannot distinguish the two populations
   • ⚠ flaggedCross-publisher sanity check vs the state's Keystone results

   Evidence: Accountability-cohort vs all-tested files are byte-identical after sorting in SDP's 2024-25 archive — a publisher defect, so this check cannot distinguish the two populations · Cross-publisher sanity check vs the state's Keystone results

7. 7
   Assumptions & caveatsAssumptions and caveats

   • The accountability cohort (students enrolled for the full year) is the intended canonical population. However, the two files SDP publishes for 2024-25 ('Acct' and 'Actual') are identical once sorted — 28,525 rows with no differing value or denominator — so the served 'acct' and 'actual' cuts carry the same numbers. We treat this as a publisher defect (one file published under two names) and cannot say which population the numbers describe.

   • District-run and alternative schools only from this file; charter schools' Keystone results come from the state's Future Ready file.

   Algorithms involved: Citywide and peer-group percentiles, Peer groups: 40 nearest neighbors on demographics