By Jenny Connelly-Bowen, CBN Graduate Research Assistant

This week, we’re sharing maps that compare data among individual schools in the St. Louis City Public School District. These were created in QGIS using data from the Missouri Department of Elementary and Secondary Education (DESE). DESE publishes various district- and building-level public school performance metrics on a yearly basis. You can review their data sets hereDESE’s Quick Facts feature allows you to easily navigate data, graphs, and tables on Missouri public schools at the district or building level.

The data on the maps below was downloaded from DESE’s District and School Information data page. They review the following DESE metrics from 2016 at an individual building level for St. Louis City’s public schools:

  • School Type: Describes whether the school is an elementary school (grades pre-K through 4, 5, or 6), middle school (grades 6 through 8), high school (grades 9 through 12), or alternative school.
  • Proportional Attendance Rate: Missouri state standard attendance targets “use the individual student’s attendance rate and set the expectation that 90% of the students are in attendance 90% of the time.” To determine the percent of students in a district or school with an attendance rate at or above this standard, the proportion of students scoring at or above the state standard in attendance is divided by the proportion of students in attendance in that district or school that year (click here to view webinar slides that cover how to calculate Missouri’s proportional attendance rate).
  • Four-Year Cohort High School Graduation Rate: This metric divides the number of students that graduate in four years with a regular high school diploma by the number of students that form an adjusted cohort for the graduating class. This adjusted cohort adds in any students that enter the class after the beginning of 9th grade, and removes any students that transfer out of the class after the beginning of 9th grade.
  • Students per Classroom Teacher: The ratio of students in grades K-12 to regular classroom teachers, which excludes special education, remedial reading, Title I, and vocational teachers. (Note that this map below excludes several schools with outlier ratios related to these exclusions.)
  • Teacher Characteristics: The two teacher characteristic metrics mapped below are average years of teacher experience and average percentage of teachers with a master’s degree.

Although the schools on the maps below comprise a single public school district, these metrics reveal a variety of differences among individual schools:



If you would like more information about how these maps were compiled, please contact us at To access maps from previous editions of the Community Builders Exchange, click here.