← All proof trees · EDWARD T. STEEL SCHOOL
PSSA MATH proficiency (all tested grades) — EDWARD T. STEEL SCHOOL, 2023-24
The share of tested students in grades 3–8 scoring proficient or advanced on the PSSA math test. This figure is for female students. Population: all tested students.
Identifiers
school code 6390 · metric key pssa_all_math_proficiency · year 2023-24 · subgroup FEMALE · population cut actual
- 1What you seePSSA MATH proficiency (all tested grades)
1.8%
the share of tested students in grades 3–8 scoring proficient or advanced on the PSSA math test. Based on 114 students.
- vs. peers
- 18th percentile
- vs. citywide
- 8th percentile
- unit
- percent
- direction
- higher is better
- 2How it was computedvalue = published '% proficient or advanced' (accountability cohort by default)
- Unzip the district's PSSA/Keystone archive and read the accountability-cohort ('Acct') and all-tested ('Actual') school CSVs.
- Keep rows for the test, subject, grade, and subgroup this metric represents.
- 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.
- 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 169 default-included schools with a value for this metric, year, and subgroup, this school has a higher value than 13. Midrank rule: (13 + 0/2) / (169 − 1) = 0.077.Stored: 0.077. ✓ matches
Peer percentile, reconstructed right now
Peer group: up to 40 of the demographically nearest schools among Elementary-Middle / catchment / district schools; 40 of 40 peers have a value this year. This school is above 7 of them. Midrank: (7 + 0/2) / (41 − 1) = 0.175; stored 0.175. ✓ matches
The peers and their values (40)
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: PSSA MATH proficiency (all tested grades)
- 3The stored cellThe stored cell
- table
- philly_school_year_metrics
- value
- 1.75
- denominator
- 114
- suppressed
- false
- citywide_percentile
- 0.0774
- comparison_group_percentile
- 0.1750
- source_load_id
- 96e07ea5-c26b-4f50-acf8-e159bd17d2e0
Evidence: data model overview
- 4The load that wrote itWritten on 2026-06-04 by sdp_pssa_keystone_2023-24.ts
- source id
- sdp_pssa_keystone_2023-24
- SHA-256 of the file read
- d89570e75caa9d30bd32f41de7a654b1df298e1a27a8bf6538f6dc4a6cfa9261
- 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>— 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
- 5The 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)
- Same as the 2024-25 file.
- 6How it was checkedChecks: 2 passed, 2 flagged
- ✓ passedBase case: served cells vs an independent re-read of the ingested file
- ✓ passedCompleteness: every source cell is served
- ⚠ 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
Checked at ±1: 0 mismatches, 0 cells served but absent from the file, 0 in the file but not served (ALL, acct, latest year).
Evidence: Base case · Completeness · 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
- 7Assumptions & 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
The same metric for this school, every year and cut
| Year | Subgroup | Cut | Value |
|---|---|---|---|
| 2023-24 | All students | accountability cohort (students enrolled the full year) | 3.9% |
| 2023-24 | All students | all tested students | 3.9% |
| 2023-24 | Female students | accountability cohort (students enrolled the full year) | 1.8% |
| 2023-24 | Female students | all tested students | 1.8% |
| 2023-24 | Male students | accountability cohort (students enrolled the full year) | 6.6% |
| 2023-24 | Male students | all tested students | 6.6% |
| 2024-25 | All students | accountability cohort (students enrolled the full year) | 7.2% |
| 2024-25 | All students | all tested students | 7.2% |
| 2024-25 | Female students | accountability cohort (students enrolled the full year) | 8.3% |
| 2024-25 | Female students | all tested students | 8.3% |
| 2024-25 | Male students | accountability cohort (students enrolled the full year) | 5.8% |
| 2024-25 | Male students | all tested students | 5.8% |