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

Thursday, December 12, 2013

Automated WorkScheduler - Shawn Hallam

Executive Summary

There are approximately 800 teachers employed at the Missionary Training Center (MTC). Teachers work in training areas of approximately 50 employees, supervised by a training coordinator. Each semester, training coordinators spend a significant amount of time coordinating with teachers in order to assign them to training schedules (work schedules) that are compatible with their school schedules. Additionally, once assigned to a training schedule, training coordinators must then assign teachers to teaching companionships based on complimentary schedules. My program automates this process, significantly reducing the time required to set work schedules.


The program I created gathers school schedule information from teachers and assigns each teacher to a training schedule by identifying which of the available schedules has the fewest conflicts with the teacher’s schedule. Once teachers have been assigned to training schedules, the program then compares teachers assigned to a given training schedule and suggests potential companions by minimizing conflicts.

No comments:

Post a Comment

Blog Archive