MBA VBA Projects: March 2015

Executive Summary

As the Advancement Chair for my Boy Scout Troop, I am responsible for tracking merit badges, rank advancements, courts of honor, leadership positions etc. I currently use three different systems to track this information: (1) etrailtoeagle.com, (2) BSA Internet Advancement, and (3) Excel. The website etrailtoeagle.com is a third-party subscription site that parents, leaders and committee members can access and edit. This is a comprehensive site that tracks almost everything that happens in the troop. Unfortunately, it only allows the user to see one scout’s information at a time unless you print a report that is not very easy to read or manipulate. The BSA Internet Advancement is the Boy Scouts of America official advancement site that only the Advancement Chair has access to. The only thing that is entered on this site is rank advancements and merit badges and their respective dates earned. This information is transmitted to the local Boy Scout Council. Finally, in order to view and track all of this information in one location in an easy to read format, I create a separate Excel file that contains a summary of all of the advancement information. Each time I receive advancement information from one of the scouts, I have to update the information in these three places. In addition, because parents and leaders can access and edit etrailtoeagle.com, sometimes merit badges and advancement has been recorded, but I am unware of the change. This problem is faced by almost every Advancement Chair that uses etrailtoeagle.com.

My VBA solution focuses on the scout merit badges and performs three basic steps:

MBA VBA Projects

Tuesday, March 31, 2015

Boy Scout Advancement Comparison

Contributors