Principal Reduction Dashboards

Projects Home

Problem: The annual DCPS school-based budget and staff reduction process has a lot of moving parts, and historically principals have had trouble easily seeing the implications of budget changes, or determining what effects their rubrics would have.

Solution: In spring 2016, we redesigned principals’ staff validation and reduction tool using Angular.js and Bootstrap to build a snappy and responsive set of principal pages, with QuickBase as a back-end.

Results: The redesign helped principals more easily see what staffing implications their budgets held, and adjust accordingly. In the event that principals needed to reduce positions, the implications of their reductions were clear.

(Click on the pictures with play buttons to see a GIF of the tools in action. Please Note: All of the data points shown below are for illustrative purposes. Neither the schools or individuals are real!)

Validation Pages

The first step in the process is validating our HR list of staff. Though our HR system is relatively accurate, our position titles don’t always match to the competitive levels used in the budgeting and reduction processes. (For example, a teacher’s position might be ‘Teacher, General Secondary,’ but it’s relevant here to determine whether those teachers are assigned to particular subjects.)

Principals review their staff, make any necessary changes, and then confirm their choices. With Angular, the page loads only once, and we don’t need to worry about principals losing their work halfway through validating a large school, since they are able to save incrementally.

validation dashboard

Staff Changes Dashboard

After a school’s budget is set, principals return to this application to review their current staff (as validated above) versus their allocation for next year. They’re able to see which positions are increasing, staying the same, and decreasing, and to review once again which staff members are in each category.

reduction dashboard

Reduction Rubrics

In the unfortunate circumstances where there are more current staff members than positions next year, principals must complete a rubric for each of the staff members. The reduction rubrics guide principals through the process, and ensure that school leaders know how staff members will be ranked.

reduction rubrics

Reduction Summary

Finally, we’ve provided principals with a summary of any staff reductions likely to happen at their schools. This page looks at the net loss of positions at each school, and displays the lowest-scoring staff members. By showing the implications in real time, the application prepares principals for any tough conversations and helps them flag any possible mistakes.

reduction rubrics

Technology Stack

The site and controllers for the reduction rubrics are created using Angular.js, with Bootstrap as a CSS framework. The back-end database used is QuickBase, and the application communicates with QuickBase using its Javascript API.