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.


-Chloe Jensen

No comments:

Post a Comment

Blog Archive