A simple CAD system for faculty timetabling design

Abstract

A computer-aided design (CAD) system is proposed in order to help in designing the timetabling of courses in a faculty. It is based on already used technologies such as Google Spreadsheets and Microsoft Excel and tools built-in in them: Server JavaScript, Visual Basic for Applications (VBA). The idea is to use a single sheet ”Collision” in a spreadsheet in Microsoft Excel to deal with all information related to the timetable, and then, by parsing its cells, to generate all needed timetables for students, teachers, rooms, etc.