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