← All proof trees · ADD B. ANDERSON SCHOOL
PSES teacher — school climate — ADD B. ANDERSON SCHOOL, 2020-21
The teacher score for the 'School Climate' topic of the Philly School Experience Survey — the average of the topic's subtopic scores, on the survey's 0–100 scale.
Identifiers
school code 1460 · metric key survey_teacher_school_climate · year 2020-21 · subgroup ALL · population cut n/a
- 1What you seePSES teacher — school climate
7.1%
the teacher score for the 'School Climate' topic of the Philly School Experience Survey — the average of the topic's subtopic scores, on the survey's 0–100 scale.
- vs. peers
- 97th percentile
- vs. citywide
- 78th percentile
- unit
- percent
- direction
- higher is better
- 2How it was computedvalue = mean of the subtopic scores within (school, year, topic, respondent)
- Unzip the survey archive and read the school-level subtopic-scores workbook.
- Keep rows for this respondent type; roll subtopics up to the topic by averaging their scores.
- 'n.a.' and 'i.s.' are stored as suppressed.
Citywide percentile, reconstructed right now
Among 254 default-included schools with a value for this metric, year, and subgroup, this school has a higher value than 197. Midrank rule: (197 + 0/2) / (254 − 1) = 0.779.Stored: 0.779. ✓ matches
Peer percentile, reconstructed right now
Peer group: up to 40 of the demographically nearest schools among Elementary-Middle / catchment / district schools; 36 of 40 peers have a value this year. This school is above 35 of them. Midrank: (35 + 0/2) / (37 − 1) = 0.972; stored 0.972. ✓ matches
The peers and their values (36)
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.
- 3The stored cellThe stored cell
- table
- philly_school_year_metrics
- value
- 7.1
- denominator
- null (not published)
- suppressed
- false
- citywide_percentile
- 0.7787
- comparison_group_percentile
- 0.9722
- source_load_id
- 13f571c5-ae32-4d4a-bbdd-f97125f6d6d1
Evidence: data model overview
- 4The load that wrote itWritten on 2026-06-04 by pses.ts
- source id
- pses_topic_subtopic_scores_all_years
- SHA-256 of the file read
- 142800f6ae8170b0feeb8f70bfd77e1254a2c54476d2731e11d6830d010e9648
- bytes
- 2,517,284
- year covered
- 2019-20..2024-25
- year of this cell
- 2020-21 — 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>— 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 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
- 'n.a.' (no data) and 'i.s.' (insufficient sample) are both stored as suppressed.
- 6How it was checkedChecks: 1 passed
- ✓ passedComputed-value check: our rollup reproduces the district's published values
Evidence: Computed-value check
- 7Assumptions & 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