Created By: Ben Geilman
EXECUTIVE SUMMARY
My department in the Business Career Center administers both the Field Study and On-Campus Internship programs for the Marriott School of Management. These are mirror programs that provide real-world experience for students working on teams to solve business problems for contracted companies. The projects have combined participation of roughly 150-200 students per semester.
Student grades are determined primarily by two elements: the feedback of their host company and the feedback of their teammates. This feedback is gathered using Qualtrics surveys that are sent out twice per semester. After the survey is administered, student employees in my office menially separate each student’s survey feedback into individual documents and email them to the students for their review.
Splitting and emailing the feedback to the students is extremely time consuming and does not produce attractive reports. Both of these challenges can be solved through VBA automation.
My final product is a macro-enabled spreadsheet template that effectively solves both of the issues in the preceding paragraph. The spreadsheet both performs a complex splitting procedure to produce attractive, individualized reports for each student and emails this custom report to each student.
This new process will eliminate roughly 15 hours of labor time in my role each semester, totaling around $300 of savings per year.
- Project Writeup http://files.gove.net/shares/
files/10f/bgeilman/360_ Feedback_Splitter_Project_ Writeup.pdf - Project Spreadsheet http://files.gove.net/shares/
files/10f/bgeilman/360_ Feedback_Splitter.xltm - Sample Input http://files.gove.net/shares/
files/10f/bgeilman/Sample_ Input.zip - Project Test How-To http://files.gove.net/shares/
files/10f/bgeilman/How_To_ Test_My_Project.txt
No comments:
Post a Comment