For this project the two input excel files need to be turned into data that can be accessed by the model.

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

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 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 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 days and times that can’t have exams such as weekends or bank holidys called “no_exam_dates”
• List of the exam dates called days
• Dictionary of rooms and their uses ( AEA SEQ or computer) and capacity in the format {room: [List of uses],[Capacity]} called rooms
• 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
• List called No_exam_dates_soft for dates that shouldn't have an exam on such as Tuesday and Wednesday morning of week 3