← All proof trees · FRANCIS HOPKINSON SCHOOL

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

   16.2%

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

   vs. peers

   28th percentile

   vs. citywide

   33th 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 24. Midrank rule: (24 + 0/2) / (74 − 1) = 0.329.Stored: 0.329. ✓ 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; 25 of 40 peers have a value this year. This school is above 7 of them. Midrank: (7 + 0/2) / (26 − 1) = 0.280; stored 0.280. ✓ matches

   The peers and their values (25)

   Peer school	Value
   GEORGE W. NEBINGER SCHOOL	50.0%
   COPPIN, FANNY JACKSON SCHOOL	48.6%
   LOUIS H. FARRELL SCHOOL	40.7%
   JOHN H. TAGGART SCHOOL	40.0%
   HANCOCK DEMONSTRATION SCHOOL	40.0%
   THOMAS HOLME SCHOOL	39.5%
   MAYFAIR SCHOOL	38.7%
   A.L. FITZPATRICK SCHOOL	36.6%
   STEPHEN DECATUR SCHOOL	30.8%
   D. NEWLIN FELL SCHOOL	29.2%
   GILBERT SPRUANCE SCHOOL	29.1%
   ROBERT B. POLLOCK SCHOOL	28.1%
   JUNIATA PARK ACADEMY	27.8%
   NORTHEAST COMMUNITY PROPEL ACADEMY	25.4%
   WILLIAM H. HUNTER SCHOOL	24.1%
   SOUTHWARK SCHOOL	23.8%
   ETHAN ALLEN SCHOOL	18.4%
   VARE-WASHINGTON ELEMENTARY	18.2%
   THURGOOD MARSHALL SCHOOL	13.3%
   HAMILTON DISSTON SCHOOL	12.5%
   OLNEY ELEMENTARY SCHOOL	11.1%
   JULIA DE BURGOS ELEMENTARY	10.7%
   HON. LUIS MUNOZ-MARIN SCHOOL	5.0%
   THOMAS K. FINLETTER SCHOOL	3.9%
   BENJAMIN FRANKLIN ELEM. 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

   16.22

   denominator

   37

   suppressed

   false

   citywide_percentile

   0.3288

   comparison_group_percentile

   0.2800

   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