Icon for Socrata external plugin
Open repository in Console
Updated over 4 years ago
Indexed 29 minutes ago

Teacher Experience

The measurement is percent of teachers who were paid on salary steps 1-5 at OUSD schools (data from charters and private schools were not available). Salary steps are a proxy for teaching experience, as teachers move one step up the salary schedule for each year of teaching. In theory, teachers on salary steps 1-5 have between 1-5 years of teaching experience (not just in OUSD, but anywhere). However, it is important to note that salary steps are just a proxy and not always exactly equal to years of teaching experience.

Percents are then calculated at the school level by dividing the number of teachers on salary steps 1-5 by the total number of teachers at that school. Schools are placed into groups based on the racial and ethnic breakdown of their student population (see note below data table for full explanation of grouping). Average percent of teachers on salary steps 1-5 is then calculated for each group of schools.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"oaklandca-gov/teacher-experience-3rkp-5mtg\".\"teacher_experience\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • teacher_experience