Department of Research, Assessment & Data
OUSD Data
  • Data
  • Resources
  • Requests
  • Announcements
  • About Us
    • Staff

Community School Action Planning Dashboard

The Community School Action Planning Dashboard is a tool designed to inform decisions about OUSD's school portfolio. This interactive tool was designed to support our district’s commitment to quality community schools and is intended to increase transparency and clarity around the factors considered when making decisions about school programs. The tool includes data on our facilities, utilization, enrollment, performance, environmental stress, choice, live/go, teacher retention, programs, and student demographics and serves as a starting point for building a centralized repository of information that can help us make decisions.

The data used in the tool align in large part to those data points used in our annual Strategic Regional Analysis (SRA), however, this dashboard differs from the SRA in how the information is presented with less of a focus on aggregate results within SRA regions and more interactive information about individual campuses and school sites.  We will continue to gather feedback to make the tool more useful in the future.

What it is

A tool to inform school portfolio decisions
A continuation of our district’s mission to provide quality schools
Factual (quantitative) data about our schools
An objective look at our portfolio of schools

What it is NOT

Intended to value-rank schools
Intended to blame teachers, leaders, or communities for the information in the tool
Meant to answer every question or capture the complete picture
A conclusion to discussion

How the Tool Works

This tool is organized into three types of pages.

Exploratory Pages
Allow users to view and interact with individual datasets organized into categories such as Facilities & Enrollment or Choice & Live/go. On each of these pages, applying a filter results in updates to the data table and map.

Outcome Page
The purpose of the outcome page is to view schools that remain after the selected filters from all exploratory pages are applied. All filters applied on any of the ‘exploratory pages’ are carried through to the outcome page. These filters can be further manipulated on the outcome page itself.

School Summary Page
The purpose of the school summary page is to give users a way to view or print all of the data for a selected school on a single page.

Detailed description of each of the metrics contained within each exploratory page are given in the upper left of each page. Filters are shown on the upper right. The resulting data table and map are shown on the lower left and lower right, respectively.

Exploratory Pages

Picture

Facilities & Enrollment

Facilities master plan data including repair costs, campus utilization, and minimum enrollment for sustainability
Picture

Stress & Performance

Environmental stress factor and school performance results from the California School Dashboard/Oakland Public School Report Cards
Picture

Choice &
​Live/Go

School choice as a function of demand for seats at transition grades and live/go of students
Picture

Programs &
​Staff

Teacher retention and school programs (early childhood, dual language, pathways, special ed, health services)

Outcome Page

Picture

Outcome

Map of schools and demographic information of students enrolled at schools resulting from selected filters applied on the exploratory pages. This page shows all filter settings in one place, and all filter settings are adjustable from this page.

School Summary Page

Picture

School Summary

Use this page to view all of the data points used in the dashboard for a selected school.

Acronyms & Abbreviations used in the Tool

Demographics
AA = African American
A = Asian
F = Filipino
L = Hispanic/Latino
ME = Multiple Ethnicity
NA = Native American
PI = Pacific Islander
W = White
EL = English Learner
SWD = Students with disabilities / Special Education students
NSLP = National School Lunch Program
SED = Socioeconomically disadvantaged
HOM = Homeless
FOS = Foster
Newcomer = Student who has been in the U.S. for fewer than 3 years and who speaks a language other than English at home
Other Terms
ECE = Early Childhood Education
ELA = English Language Arts
ELP = English Learner Progress
ESP two way 50-50 = 2 way Spanish immersion (50% Spanish, 50% English)
ESP two way 90-10 = 2 way Spanish immersion (90% Spanish, 10% English)
FCI = Facilities Condition Index
Grad = Graduation Rate
Pre-K = Pre-Kindergarten
SPM = School Portfolio Management
SRA = Strategic Regional Analysis
Trans K = Transitional Kindergarten
Susp = Suspension Rate
NULL = No data available
​For comments or questions, please email Kaia Vilberg at kaia.vilberg@ousd.org or Nana Xu at nana.xu@ousd.org.