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

Wednesday, April 13, 2011

Nick Sullivan Summary

This program was designed as a solution for the very time consuming process that previously existed for calculating grades for Isys 100/101. The Isys 100/101 classes are mandatory prerequisites for every major offered by the Marriott School. Because of that, each block there are roughly 600 students enrolled between the two classes. To handle this many students with just one professor, the class utilizes a third party software called Myitlab. Students complete assignments on this website which can be rather inconsistent with its grading (quite a few glitches exist in the software). The previous process was to download the grade book from myitlab.com then manually manipulate the data to determine which students passed based on the class criteria and which failed. Then grades must manually be entered into route y. This program allows the user to select the file downloaded from myitlab, then formats it correctly, and then creates the report along the side that Dr. McKell likes. In addition to this, it has a button that will present a login screen for the user to enter route y login information and then enters student’s grades into route y. It leaves that internet explorer screen open without submitting the grades to allow the user to do a manual audit to make sure there is nothing wrong before submitting it. All in all, this program saves the TAs for the class roughly 5 hours every single block.


No comments:

Post a Comment

Blog Archive