Data Management Tool
Team: Sarah Padrutt ’18, Scarlett Chen ’18, Sabrina Tobe ’18
Advisors: Matt Moynihan (Mathematics) and John Ramsay (Mathematics)
APEX (Center for Advising, Planning, and Experiential Learning) provides College of Wooster students with a variety of support services that aid in developing their own academic, personal and professional goals. APEX would like to understand how each demographic of the student body engages with their services. The task given to the AMRE APEX Data Team was to perform an analysis of student engagement for the 2015-2016 academic year, and create an easy to use program that automates this analysis for subsequent years. In response, the team created a Microsoft Excel-based program named WISER (Wooster Interactive Student Engagement Report). This program will combine APEX student engagement data with College student demographic information to create a student engagement Excel database and a dashboard of interactive Excel Pivot Tables that will facilitate assessment of student engagement and APEX programming.