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