cmd-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.
cmd-018. a cloud-based spreadsheet that helps stakeholders conduct collaborative data meetings.
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 take grade-wide math exams roughly every six weeks. Teachers and school leaders then meet to review the results of the exams and discuss ways to improve. The exams 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 applied conditional formatting to make the spreadsheet more understandable at a glance.
I calculated summary statistics by using pivot tables.
I used the pivot tables I’d created to produce data visualizations for the final data presentation.
The result was a spreadsheet and accompanying set of data graphics (which I named the “Consolidated Tracker”). The Consolidated Tracker was then used to present data to teachers and school leaders. 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.
cmd-017. a suite of online dashboards that give all members of an organization access to actionable information.
PROJECT COMPLETED: February 2020
THE STORY OF THIS PROJECT
Stakeholder’s Problem: “We need a way to quickly compile, analyze and report on our school’s data.”
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 all children in its community (Harlem and Washington Heights).
At Harlem Link, students take a series of assessments throughout the school year to monitor their academic progress. The assessments 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:
Final Results:
—HARLEM LINK DATA SUITE: ACADEMICS—
cmd-016. a data report that provides insight into the results of a recent survey.
PROJECT COMPLETED: December 2019
THE STORY OF THIS PROJECT
Stakeholder’s Problem: “We need a way to understand the results of our survey and communicate the insights we’ve gained.”
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 all children in its community (Harlem and Washington Heights).
At Harlem Link, teachers fill out a detailed survey twice a year that assesses each of their students on several measures of their social and emotional learning. The surveys 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:
Final Results:
cmd-015. cloud-based data reports that put timely information at your fingertips.
PROJECT COMPLETED: October 2019
THE STORY OF THIS PROJECT
Stakeholder’s Problem: “We need a way to connect the data we have stored in various locations and assemble all of it into a usable form.”
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 all children in its community (Harlem and Washington Heights).
The school’s normal daily operations produce a large volume of data that needs to be collected, crunched and reported on in real time. In order to meet that challenge, I took the following steps:
