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

Science Fair (CUSF) Judging Tool

Executive Summary:

My project was for the Central Utah Stem Fair (CUSF). The fair season beings with students competing at their individual schools and district in various categories, depending on the fair level (Elementary, Junior, or Senior). A select number of winners from each of the local fairs are invited to the annual-regional fair is hosted at BYU. CUSF is the BYU organization that is in charge of organizing, judging, and processing all data for the fairs. 
One of their major pain points is keeping track of all their judges and the judge requirements for each fair. My system allows for easy tracking of judges through add/delete tools and calculates judge requirements for each fair based on the number of projects. The calculations for judge requirements are essential as, they not only affect staffing logistics, but also, a certain number of judges are needed in order to statistically normalize all project scores.

http://files.gove.net/shares/files/15f/allredj8/FINALPROJ2.xlsm


http://files.gove.net/shares/files/15f/allredj8/VBA_FINAL_WriteUp.pdf

No comments:

Post a Comment

Blog Archive