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

Learning Suite Schedule Importer

Executive Summary

As a student at BYU you keep track of all of your class assignments, quizzes and exams through Learning Suite.  Learning Suite is a great website, however when you have 5 different classes, getting a grip on everything that you have to get done over the course of a week or a day can get frustrating.  Learning Suite does offer an iCalendar Feed so that you can easily upload your schedule into your Gmail account calendar however, this functionality still left me frustrated because when you upload your iCalendar Feeds it is very difficult to see everything that you have to do because each date box is so small that only about two or three schedule items can be seen at once.  So in order to make this process easier, I created a macro that enables the user to import their schedule for a given date range that they set via a user-form for all of their classes.  Then if the user wants to, they can easily manually create to do lists complete with due dates and assignment names extremely easily because all of their class schedules are in a format that can easily be edited and manipulated in one excel spreadsheet.

No comments:

Post a Comment

Blog Archive