For this project the three input excel files need to be turned into data that can be accessed by the model. The way this is done can be seen in this notebook.

https://github.com/edwardb05/Timetabling-UROP/blob/main/Data_handling.ipynb

Data_handling.ipynb found in the Timetabling-Urop-main folder

What is needed from the excel file:

• List of exams named ‘exams’
• Integer of the number of days for exam period named ‘num_days’
• Dictionary which has students CID and then a list of there exams

student_exams ={
	001 : ["Maths","Physics"]
	002 : ["Chemistry","Maths"]
	}

• List of core modules/exams named “Core_modules”
• Dictionary of fixed exams and their days called “fixed_modules” this will have the day it is on and the slot, morning or afternoon
• Dictionary of rooms and their uses ( AEA, SEQ or computer) and capacity in the format {room: [List of uses],[Capacity]} called rooms this can be updated to reflect changes
• List of days and times that can’t have exams such as weekends or bank holidys called “no_exam_dates”
• List called No_exam_dates_soft for dates that shouldn't have an exam on such as Tuesday and Wednesday morning of week 3
• Dictionary of Module leaders and their modules called “leader_courses”
• List of students with 25% Extra time called “extra_time_students_25”
• List of students with 50% Extra time called “extra_time_students_50”
• List of the exam dates called days
• List of any student with AEA called AEA
• Dictionary called exam _counts in the format {exam:[AEA students taking it,SEQ students taking it]}
• Dictionary called exam_types in the format {exam : type} where type can be Standard (flat floor) or PC requiring a computer room