← All proof trees · WILLIAM W. BODINE HIGH SCHOOL

1. 1
   What you seePSES teacher — school leadership

   8.8%

   the teacher score for the 'School Leadership' topic of the Philly School Experience Survey — the average of the topic's subtopic scores, on the survey's 0–100 scale.

   vs. peers

   92th percentile

   vs. citywide

   91th percentile

   unit

   percent

   direction

   higher is better

2. 2
   How it was computedvalue = mean of the subtopic scores within (school, year, topic, respondent)

   1. Unzip the survey archive and read the school-level subtopic-scores workbook.
   2. Keep rows for this respondent type; roll subtopics up to the topic by averaging their scores.
   3. 'n.a.' and 'i.s.' are stored as suppressed.

   Citywide percentile, reconstructed right now

   Among 264 default-included schools with a value for this metric, year, and subgroup, this school has a higher value than 238 and ties 1. Midrank rule: (238 + 1/2) / (264 − 1) = 0.907.Stored: 0.907. ✓ 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 High / selective / district schools; 12 of 13 peers have a value this year. This school is above 11 of them. Midrank: (11 + 0/2) / (13 − 1) = 0.917; stored 0.917. ✓ matches

   The peers and their values (12)

   Peer school	Value
   SCIENCE LEADERSHIP ACADEMY	9.4%
   ARTS ACADEMY AT BENJAMIN RUSH	8.2%
   LANKENAU HIGH SCHOOL	7.8%
   PARKWAY C.C. MIDDLE COLLEGE	7.7%
   ACADEMY AT PALUMBO	7.7%
   CENTRAL HIGH SCHOOL	7.0%
   PARKWAY-NORTHWEST HIGH SCHOOL	6.7%
   PHILA HIGH SCHOOL FOR GIRLS	6.1%
   CREATIVE AND PERFORMING ARTS	5.8%
   MOTIVATION HIGH SCHOOL	5.5%
   W. B. SAUL HIGH SCHOOL	5.1%
   FRANKLIN LEARNING CENTER	3.9%

   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: PSES teacher — school leadership

3. 3
   The stored cellThe stored cell

   table

   philly_school_year_metrics

   value

   8.75

   denominator

   null (not published)

   suppressed

   false

   citywide_percentile

   0.9068

   comparison_group_percentile

   0.9167

   source_load_id

   13f571c5-ae32-4d4a-bbdd-f97125f6d6d1

   Evidence: data model overview

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

   source id

   pses_topic_subtopic_scores_all_years

   file URL

   https://cdn.philasd.org/offices/performance/Open_Data/School_Information/District_Wide_Survey/Topic_Subtopic_Scores_2019-2020_to_2024-2025.zip

   SHA-256 of the file read

   142800f6ae8170b0feeb8f70bfd77e1254a2c54476d2731e11d6830d010e9648Copy hash

   bytes

   2,517,284

   year covered

   2019-20..2024-25

   year of this cell

   2022-23 — this measure is stored under a different year than the file's report year; see the metric page

   code commit

   f75e33137e8166eec3f8b5a4b39463d306ef710c

   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 filePhilly School Experience Survey — topic and subtopic scores, 2019-20 to 2024-25

   School District of Philadelphia (Research, Evaluation & Accountability). Survey scores by school, year, topic, subtopic, and respondent type (students, teachers, parents, support staff).

   format

   ZIP of XLSX

   join key

   ULCS Code

   landing page

   https://opendataphilly.org/datasets/sdp-philly-school-experience-survey/

   • 'n.a.' (no data) and 'i.s.' (insufficient sample) are both stored as suppressed.
6. 6
   How it was checkedChecks: 1 passed

   • ✓ passedComputed-value check: our rollup reproduces the district's published values

   Evidence: Computed-value check

7. 7
   Assumptions & caveatsAssumptions and caveats

   • A topic score is the unweighted mean of its subtopics (the district publishes topic scores aggregated across respondents; per-respondent topic scores are our rollup).

   • Year coverage varies by topic and respondent — some topics were not asked every year.

   Algorithms involved: Survey topic scores per respondent type