Mentorship Program-Student Progress Update | At-a-Glance Information Sheet by David White
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.
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.
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.
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.