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

Tuesday, April 12, 2016

Sherpa Tracking Sheet

Introduction:

BYU’S MBA program is designed to help aspiring young professionals of capability and faith to accomplish their career goals. In this vein, the graduate school developed a mentoring program in which second year students mentor first year students to search for an internship and otherwise navigate MBA life. This spreadsheet is a new spreadsheet designed to track statistics and progress for this mentoring program.

Executive Summary:

There were several tasks that needed to be accomplished in order to complete this spreadsheet:

1. Weekly data created in a CSV file though learning suite needed to be imported and placed in the appropriate “Weekly” and “Cumulative” sections. This import process needed to be robust enough to handle common glitches such as students who do not report every week, and students who report twice. An algorithm was developed to accomplish these tasks.

2. A simple, ready to use, entry method to input data needed development for first year mentees, “climbers” and second year mentors, “sherpas”. Several userforms were developed in order to input this data easily.

3. A reporting system needed to be developed in which sherpas were notified of their climbers’ progress and could meet to discuss areas of emphasis. An email message notification system was developed in order to meet this need, and a userform was created in order to select which MBA group would receive the email messages.

4. A clear contents option was needed in order to reset the sheet after every year. A sub- procedure as developed in order delete the entered data and resent other items to their null values.

5. A custom ribbon needed to be added so that users could easily access the functionality of the .xlsm spreadsheet. The ribbon was titled “macros” and contained buttons for the five key functionality areas.