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

Friday, December 12, 2014

Dive Meet System

Business Description

During
my time at BYU I have been a part of the diving team. We would hold
competitions regularly throughout the season against schools across the
country. In order to run a diving meet, we would usually need three people to
help with announcing, recording judges’ scores, and summing up divers’ scores.
In order to find the number of points achieved by a dive, each dive has a
specific degree of difficulty that gets multiplied by the sum of the middle
three judges’ scores. Divers perform six dives during a meet, so these six dive
scores get added up to get a final score for a diver that is compared against
the other divers to see who wins.

Business Issue

At BYU,
diving meets have been run on pencil and paper with calculators as the most sophisticated
piece of technology. Because of this, divers and spectators would have to wait
about 20 minutes before knowing the results of a meet. There would also sometimes
be errors in the manual calculations. In the past this has caused the need for
adjustments after results have already been announced.

Solution

My
system is able to effortlessly run a diving meet without having to worry about
miscalculations or waiting for the results. The system uses user forms to easily
input divers’ lists and judges’ scores once the meet has started. The results
are then automatically calculated accurately. This saves the pain out of
running a dives meet, and makes it extremely easy. The system accomplishes the
four main tasks of running a diving meet: