Find What Works: Schools

← All proof trees

PhiladelphiaAlgorithm

Survey topic scores per respondent type

The district publishes survey subtopic scores per respondent type but topic scores only aggregated across respondents. The site's teacher and student topic scores are the average of that respondent's subtopic scores within the topic.

  1. 1
    How it was computedSteps
    1. Group subtopic rows by (school, year, topic, respondent).
    2. Average the subtopic scores.
    3. 'n.a.' and 'i.s.' subtopics are excluded and the topic is suppressed if nothing remains.

    Inputs: pses_topic_subtopic_scores_all_years

    Evidence: pses.ts — search "TOPIC_MAP"

  2. 2
    Assumptions & caveatsAssumptions
    • Subtopics are equally weighted within a topic.
  3. 3
    How it was checkedHow it was checked

    Computed-value check against the district's published aggregate topic scores (docs/qa_reports/philly/__computed_value.md).