Automated Reports - Cleveland Metropolitan School District

Automate the production of over 400 reports embedded with customized text, tables, and visualizations.

Background

Each Fall and Spring the Cleveland Metropolitan School District disseminates a summary report detailing results from a survey assessing four social-emotional learning constructs within elementary, middle and high schools. The report uses a standard template populated with customized text, data values, and data visualizations. Previous productions of these reports were created by a separate contractor; one such example is linked here.

Development

The goal for this project was to automate the production of each school’s customized report. I acted as the lead graphic designer and data specialist on a team of developers to produce these summary results. This involved recreating and improving upon the design of the previous CMSD report. The typesetting was coded in LaTeX and embedded with the Open Sans family to provide an free-to-use font for clarity and emphasis. The figures were generated using the ggplot2 and base R graphics packages. Finally, an Rmarkdown file was used to seamlessly integrate each school’s pdf visualizations into the school level summary report pdf.

Check out the improved report here.

Comparison of Previous and New Report

Software

• R: Data cleaning and data visualization production
• LaTeX: Document preparation and typesetting