Alongside our work on Excellent Schools Detroit's public-facing website, we also built a new data management system for all of the organization's school performance data. Using staff interviews and internally-developed tools as design references, we built a new Drupal 7 website to allow ESD and its constituents to easily view, update, and manage data.

Welcome Screen
Welcome Screen
School Scores
School Scores

We worked with ESD staff to plan a new, streamlined, and extensible system.

Collaborative database and workflow planning
Collaborative database and workflow planning
Custom module programming
Custom module programming

We completed custom module programming to allow for fine-grained access control for school data. ESD staff members have access to the information they need to work with school leaders and find specific contact information and school records.

The public data API was built using Drupal 7 Services, and can be consumed by all sorts of applications. Our first consumer was the public Scorecard website that ESD developed. School leaders were impressed with the ability to login to the portal, edit their school's contact information, and see the changes reflected in the public Scorecard immediately.

All of the code that makes up the new website is available as a Drupal install profile and feature. We look forward to developing more free software to serve Excellent Schools Detroit.

Services Provided:

  • Web Application Architecture
  • Visual Design
  • Website Development
  • Training