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 12, 2013

Home Teaching Organizer

Executive Summary:

In the Church of Jesus Christ of Latter-day Saints, all active males are assigned to “home teach” other members of their congregation (or “wards”). Conversely, all members, unless notably hostile toward the Church, should be assigned a pair of two home teachers (“companions”). Elders Quorum Presidents and High Priest Group Leaders are responsible for making such assignments. That task is daunting, and needs frequent updating. To make matters more burdensome, the only standard way to handle the assignments is on a certain computer in the Church.

This VBA project seeks to allow those responsible for organizing Home Teaching to do it from home on Excel. Users can download their latest Ward Directory from, fill it with useful information (activity level, quorum with which they are assigned, what Priesthood is in their home, and other notes), and use that to guide their organization of home teaching assignments. The user can then assign companions and assign them to particular families, and then print convenient slips to hand out to the Priesthood holders, giving them all of the contact information of their companion, home teaching families, and the person they report to (“district leader”).

No comments:

Post a Comment

Blog Archive