Degree Name

BS in Industrial Engineering


Industrial and Manufacturing Engineering Department


Tao Yang


At the end of each quarter the students of Cal Poly prepare to sign up for their classes for next quarter. This process is more difficult for seniors who must meet very specific requirements in order to graduate on time. Students can spend hours trying to find the “perfect schedule”, that one schedule that fits their personal schedule and their graduation requirements, while not over taxing themselves during that quarter by having too much class work. This Cal Poly explores the creation and implementation of an extra scheduling tool to address the weaknesses of the current scheduling system, PASS, and help students reduce the amount of time spent looking for that one “perfect schedule”.

The companion program makes use of MS Access and MS Excel, both common Office Programs, to create a system that offers more optimization options in choosing what classes a student would like to take for the next quarter. Working with several queries in Access and then changing those queries into constraints for Excel solver this Senior Project was able to create an ‘alpha’ level companion program that is function, but not fully tested or edited for ease of use by senior level industrial engineering students at Cal Poly.

Title Page.docx (12 kB)

Abstract.docx (13 kB)