CSY-019. A spreadsheet and a set of data graphics that track progress over time.
PROJECT COMPLETED: June 2021
THE STORY OF THIS PROJECT
Harlem Link Charter School is a tuition-free, independent charter school located in New York City. It serves 450 children in Pre-Kindergarten through Grade 5. Harlem Link is committed to equitable programming, inclusiveness and serving its entire community (Harlem and Washington Heights).
At Harlem Link, students who are enrolled in the English as a New Language program take a series of assessments throughout the school year to monitor the progress they’re making in English speaking, listening and writing. The asssmesnts produce a large volume of data that needs to be collected, crunched and reported on within a short window of time. In order to meet that challenge, I took the following steps:
I identified all of the locations where the data I needed to access was being stored.
I combined data from several different spreadsheets by using the IMPORTRANGE and VLOOKUP functions in Google Sheets.
I added context to the data I’d collected by using the IF, COUNTIFS and AVERAGE formulas to create additional columns of information.
I calculated summary statistics by using pivot tables.
I used the pivot tables I’d created to produce data visualiztions for the final data presentation.
The result was a spreadsheet and accompanying set of data graphics that were used to present data to teachers and school leaders at data meetings that were held once a semester. The document I produced gathered all relevant information and presented it in an easy-to-understand format. Also, since the document was based in the cloud, all stakeholders could review the data prior to the meeting and arrive prepared to contribute to the group discussion.