Mentorship Program-Student Progress Update | At-a-Glance Information Sheet by David White


The Client

South Asian Youth Action (SAYA!) is a Community-Based Organization (CBO) headquartered in Queens, NY. SAYA! offers programming for students at (9) school locations in Brooklyn and Queens, NY.

In 2018-19, SAYA! worked in partnership with Richmond Hill High School to conduct interventions aimed at reducing the number of chronically absent students at the school.

The Problem

At Richmond Hill High School, SAYA! oversees the Lion’s Pride Attendance Intervention mentorship program. A tool was needed to help mentors identify the needs and track the progress of their mentees.

The Solution

I created the following data presentation to address the school’s needs:

Key Features & Benefits:

  • Critical information from several different sources is gathered in one place and presented here clearly and succinctly.

  • Mentors can use the information sheets to facilitate 1-on-1 conversations with their students.

The Process


In order to prepare the materials needed for this project, I completed the following steps:

☑ Talked to mentors and program administrators in order to gain a clear understanding of their needs and concerns

☑ Gathered raw data in.csv format from the school information system (SIS) and other sources

☑ Checked the raw data for errors and inconsistencies; wrangled the data into a consistent and uniform tidy data format

☑ Drew insights and initial conclusions from the raw data in order to inform and shape the design of the final data handouts


Having gathered and edited all needed materials, I then used Tableau software to format and print handouts for each mentor in the intervention program. These handouts are updated with the most recent data on a weekly basis. They are used by mentors to inform their practice and to facilitate 1-on-1 conversations with their students.

↤ back to main page