OVCMT

Scheduling Application

Client Problem:

  • Scheduling done manually utilizing an large Excel spreadsheet with a lot of complicated formulas
  • Schedule was only done by one person with intricate knowledge of the Excel spreadsheet
  • Spreadsheet was over 30 MB in size, and was basically unusable by anyone other than the maintainer

Solution - Create a Scheduling App:

  • Uses variety of forms to populate term, instructors, courses
  • Uses a drag-and-drop interface to set a weekly schedule
  • Uses propagation system leveraging number of sessions for a class to propagate the schedule until a class is out of sessions
  • Repeats drag-and-drop interface from the week in which sessions are exhausted
  • Accounts for one-off holidays and days off by placing them in the drag-and-drop weekly schedule

Technology Used

  • Javascript
  • HTML5
  • CSS3
  • PHP7 using Laravel Framework
View Source Code