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 10, 2015

Recruitment tool for the Romney Institute



EXECUTIVE SUMMARY

The Romney Institute of Public Management was named in 1998 after the three-term Michigan governor George W. Romney who, through his life of service, exemplifies the virtues and attributes the institute has embraced. The Romney Institute is under the Marriott School of Management at BYU and prides itself in having “a long tradition of preparing (through the MPA program) young people for careers in public service and is dedicated to educating men and women of faith, character, and professional ability who will become outstanding managers and leaders in public and nonprofit institutions worldwide.”       

As the MPA family grows and more students show interest in the program, it becomes more difficult to follow up with individuals who have shown interest in the program. Therefore, there is a need for organizing the data regarding potential candidates in a way that allows the institute to keep track of those who have been contacted by staff, those who applied to the program, and those who are accepted. As a result I have been asked to create a user form that will make storing information and contacting individuals easier.

The user form contains two pages, one that allows the user to see, modify, and save current contact information as well as make new entries, and another one through which the user can compose and send emails to either one email address or to several email addresses at once. After sending the emails and saving the changes in the workbook, the program transfer the information to either the updated, applied, or accepted sheet, depending on the changes that were made.



No comments:

Post a Comment

Blog Archive