cmd-016. a data report that provides insight into the results of a recent survey.

case studiesdata visualization
Written By David White

PROJECT COMPLETED: December 2019

Harlem Link Data Suite: Social-Emotional Learning | Data Analysis & Dashboard by David White

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:

Featured
Case Study 016. Harlem Link Data Suite - Social Emotional Learning: Step 1
CSY-016., Harlem Link Charter School
CSY-016., Harlem Link Charter School

Step 1 - Discovery

To begin the process of creating the data report, I met with the school’s teachers and administrators. I listened to the concerns they had and the challenges they were facing. I began to form an idea of what information needed to be included in the final report and what raw data needed to be gathered.

CSY-016., Harlem Link Charter School
Case Study 016. Harlem Link Data Suite - Social Emotional Learning: Step 2
CSY-016., Harlem Link Charter School
CSY-016., Harlem Link Charter School

Step 2 - Sketch

Next, I made a rough sketch of what the reports would look like and what information would go where on the screen.

CSY-016., Harlem Link Charter School
Case Study 016. Harlem Link Data Suite - Social Emotional Learning: Step 3
CSY-016., Harlem Link Charter School
CSY-016., Harlem Link Charter School

Step 3 - Prep Data

To complete this step, I took the following actions:

  1. I identified exactly what data needed to be displayed.

  2. I identified sources for each of those data points.

  3. I exported that data from school information systems (or requested a data export from an outside source).

  4. I cleaned up and organized the data exports.

  5. I compiled the data into Google Sheets.

CSY-016., Harlem Link Charter School
Case Study 016. Harlem Link Data Suite - Social Emotional Learning: Step 4
CSY-016., Harlem Link Charter School
CSY-016., Harlem Link Charter School

Step 4 - Build

Next, I took the Google Sheets datasources I’d just compiled and I connected them to Google Data Studio. I began to build out the report inside of Data Studio.

CSY-016., Harlem Link Charter School
Case Study 016. Harlem Link Data Suite - Social Emotional Learning: Step 5
CSY-016., Harlem Link Charter School
CSY-016., Harlem Link Charter School

Step 5 - Publish

I published the finished report to the cloud using Google Data Studio and I shared them with all stakeholders. Since the document was based online, all members of the team could review the data prior to the data meeting and arrive prepared to contribute to the group discussion.

CSY-016., Harlem Link Charter School

Final Results:

David White
Previous

cmd-017. a suite of online dashboards that give all members of an organization access to actionable information.
Next

cmd-015. cloud-based data reports that put timely information at your fingertips.