This site was already designed, but the website maintainers were left with a site that was not indexed and difficult to update. I created repositories with Drupal’s Views module for all their unique categories of content that automatically updated and fed into each of the respective repositories. You can see an example of the repositories on the Job Opportunities page. Before, the page was just a host of linked PDFs that were loosely organized and needed to be removed manually if the charter school notified the DC PCSB that the position was filled. Now, the job opportunities are automatically removed after 30 days and each opportunity exists as it’s own page to host all information about the job on the site instead of on a PDF so that users can filter based on the job type and click through to apply.

From my experience at the Office of the State Superintendent of Education (OSSE), I knew that posting policies, items open for public comment, and other official documents was not only a legal requirement but a never-ending task that required constant maintenance. The Public Comment page is just one of the several pages I improved by creating automatically updating repositories that made maintenance simple. All items open for public comment and archived items flow to their respective sections automatically, no maintenance required. All the content author needs to do is set a date and the repository will take over from there. Since each item is it’s own page, attachments can be swapped out and text can be modified without affecting the other items.

Along with creating systems to organize and index content, I also created a legacy-proofed data-visualization section for the DC PCSB to present to their stakeholders. Another lesson learned from OSSE, is that education data is constantly changing in the face of the various nuances of assessments and metrics. All of the data you see on the graphs can be simply edited in a Google Spreadsheet for as many years as they would like. Built with Highcharts, I integrated Google Drive so that DC PCSB’s data team could edit data and plot new points if need be.

After all of the changes and additions, I was able to drop the monthly bounce rate below 50% (36% at it’s lowest point) and double (and then some) their goal of 25,000 monthly page views. Now DC PCSB not only has a website that they can maintain with ease, but high-performing website to boot.