|Home | Math | Genetics | Bridge | Spreadsheets | Workshops | Feedback|
Scheduling of Classes
Scheduling classes for a large school is a complicated problem. You try to get the right combination of classes taught by the right teachers, at the best times, in the available classrooms, on the correct days. Then the teachers change their minds, classrooms become unavailable, classes are cancelled, there are room or time conflicts, etc.
This spreadsheet has been very successfully used by the School of Mathematics, Science, and Engineering at Southwestern College. It is very flexible and with some care is updated by the Dean, her assistant, and each of the Department Chairs. There is a provision for logging updates and many filtering and sorting options. This spreadsheet can be adapted for a large division at a community college. Mr. Idea Hamster can assist you with the adoption.
(file size: 286KB; This file contains macros for sorting.)