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

Tuesday, April 16, 2013

Library Space Survey

I created an excel document that can be used to survey the
way students use space in the Harold B. Lee Library. The library is already
using another system that works similarly to this one, but it is inefficient.
Each screen takes many seconds to load, and selection is difficult and requires
needlessly numerous steps. My excel document is meant to resolve some of the
issues in the current space survey, by being more user friendly while still
performing basic functions such as recording all of the data onto a separate
sheet that could easily be queried into a database, and analyzing the data to
show how seating is being used. For the purposes of my data, I only included a
small section of the 2nd floor of the library on my map, and the
only data analysis tool included is a graph of seat type over time of day, but
the document could be expanded to include more area in the library as well as
edited to display more analyses.