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, 2016

Piano Academy Task Streamlining: Executive Summary by Dallan Carter, IS 520

Executive Summary

This project was completed for the Brigham Larson Piano Academy Program Director. She is responsible for keeping track of their music inventory, selling books to students, ordering more books when levels get too low, and entering them back into inventory when the order arrives. She also must keep track of checked-out books and know which students’ books are over due, with the option to renew the checkout. She desires to keep track of all previously checked-out books so that students can later find favorite songs quickly. On top of her inventory and library tasks, she must also manage communication with the parents. This includes sending out general information emails (such as invitations to sign up for a recital time), reminding parents to respond to a particular email if they haven’t, and letting every parent know which recital time their children have been assigned. Once that information has been collected, she must arrange the order of the performances in each of several recitals so as to provide variety in the music and allow siblings to perform one after the other; finally, she must type up the recital programs to print off and hand out at the show. This VBA project has automated virtually every responsibility listed above.

No comments:

Post a Comment

Blog Archive