These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, December 9, 2010

360 Feedback Splitter

Created By: Ben Geilman


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.

No comments:

Post a Comment

Blog Archive