Maximizing Club Records with Data Analysis
Circle K International Club—Sac State
Spring 2024
“Ike's technical skills were a greatly valuable asset to our club. During our club's application for awards, Ike's strategic approach with code saved us critical time and energy when we were on a time crunch. Because of his skills, we could be as competitive as possible on our applications. As the club's tech chair, Ike was proactive about tackling technical challenges, serving a crucial role in the success of important club events.” — Club President
Problem and Solution
- Problem: The CKI club at Sac State needed to comb through data of their service projects for an award application that had nuanced requirements. Manual searching would produce a suboptimal result.
- Solution: Utilizing spreadsheet software proficiency and Javascript to automate the process of selecting the highest-impact service projects for the application.
Skills Demonstrated
- Technical skills: Google Sheets, Javascript, data compilation
- Soft skills: Collaboration, identifying & articulating requirements, attention to detail, time management, strategic thinking
Results
- The service events selected for the application maximized the service hours and number of members present, boosting the application's competitiveness.
Description
As the tech chair for Sac State’s CKI club, I tasked myself with combing through the data of all the year’s service projects to identify the 20 projects that involved the greatest quantity of club members and service hours, with the restriction that the same event can’t be listed more than once for each month (however, duplicate events from different months are allowed). I accomplished this by writing Javascript code to handle anything I didn’t already know how to do using built-in features in Google Sheets.