← All proof trees · HACKETT SCHOOL

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

   64.5%

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

   vs. peers

   97th percentile

   vs. citywide

   93th 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 74 default-included schools with a value for this metric, year, and subgroup, this school has a higher value than 68. Midrank rule: (68 + 0/2) / (74 − 1) = 0.932.Stored: 0.932. ✓ 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 / catchment / district schools; 32 of 40 peers have a value this year. This school is above 31 of them. Midrank: (31 + 0/2) / (33 − 1) = 0.969; stored 0.969. ✓ matches

   The peers and their values (32)

   Peer school	Value
   SAMUEL POWEL SCHOOL	79.2%
   ANNE FRANK SCHOOL	61.3%
   WILLIAM H. LOESCHE SCHOOL	56.5%
   WATSON COMLY SCHOOL	52.2%
   RHAWNHURST SCHOOL	44.2%
   J. HAMPTON MOORE SCHOOL	41.5%
   FOX CHASE SCHOOL	39.4%
   EDWIN FORREST SCHOOL	33.9%
   KENNEDY C. CROSSAN SCHOOL	33.3%
   JOSEPH W. CATHARINE SCHOOL	30.0%
   ELLWOOD SCHOOL	29.6%
   RICHMOND SCHOOL	26.9%
   FRANCIS SCOTT KEY SCHOOL	26.7%
   STEPHEN GIRARD SCHOOL	26.5%
   JAMES LOGAN SCHOOL	26.1%
   HENRY W. LAWTON SCHOOL	23.7%
   SOLOMON SOLIS-COHEN SCHOOL	22.9%
   FELTONVILLE INTERMEDIATE	20.8%
   THOMAS G. MORTON SCHOOL	19.4%
   JOHN H. WEBSTER SCHOOL	14.3%
   JOHN B. KELLY SCHOOL	13.8%
   FRANCES E. WILLARD SCHOOL	12.8%
   ALEXANDER MCCLURE SCHOOL	11.5%
   LAURA H. CARNELL SCHOOL	11.1%
   JAMES R. LOWELL SCHOOL	11.1%
   JOHN M. PATTERSON SCHOOL	11.1%
   JAMES J. SULLIVAN SCHOOL	10.3%
   GLORIA CASAREZ ELEMENTARY SCHOOL	8.7%
   WILLIAM CRAMP SCHOOL	8.6%
   BAYARD TAYLOR SCHOOL	6.5%
   LEWIS ELKIN SCHOOL	1.7%
   CAYUGA SCHOOL	0.0%

   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

   64.52

   denominator

   31

   suppressed

   false

   citywide_percentile

   0.9315

   comparison_group_percentile

   0.9688

   source_load_id

   96e07ea5-c26b-4f50-acf8-e159bd17d2e0

   Evidence: data model overview

4. 4
   The load that wrote itWritten on 2026-06-04 by sdp_pssa_keystone_2023-24.ts

   source id

   sdp_pssa_keystone_2023-24

   file URL

   https://cdn.philasd.org/offices/performance/Open_Data/School_Performance/PSSA_Keystone/2023_2024_PSSA_Keystone_All_Data.zip

   SHA-256 of the file read

   d89570e75caa9d30bd32f41de7a654b1df298e1a27a8bf6538f6dc4a6cfa9261Copy hash

   bytes

   802,929

   year covered

   2023-24

   code commit

   de835926d57d5e04d34ef3f4666df5b66fa57672

   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, 2023-24

   School District of Philadelphia (Performance Office). Same structure as the 2024-25 file, one year earlier.

   format

   ZIP of CSVs

   join key

   id_eos (= ULCS Code)

   landing page

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

   • Same as the 2024-25 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