A program to help with scheduling substitutions in schools
- Real time updates based on what options you selected.
- Customizable theme and scaling.
- All data saved in excel format
- Set unavailable classes / Teachers.
- number of free period display with information on where teacher is busy / is free
- click on teacher to check time table
- filter needed teachers by department
- very user-friendly
- Universal search including (name / class / number of free periods /is Free?/is Unavailable?)
- sql support for local and remote databases
When you start the program for the first time It will ask where to read the data from (Excel Or a SQL server):
Here you can select the excel file with the containing all the teacher data by either clicking the 'browse' button or entering a path. The excel file should be in in a proper format to be read by the software.
You can olso Export the exel data to the sql server (this will overwrite the previous data in SQL) :
Reading from a SQL server :
After Selecting a valid data file the main window will open up :
This window consists of many things:
(6) : Search Bar : Search for teachers by name / class / number of free periods /is Free?/is Unavailable?
To find Teacher By name : Enter Name
To find Teacher By Class : Enter Class
To find Teacher By number of free periods : Enter Number
To find Teacher By is Free? : Enter "Free"
To find Teacher By is Unavailable? : Enter the exclamation Mark('!'
)
(7) : Set unavailable : to make selected teacher not show up in free list (On selected days & Even If the Teacher has a free prd).
This Is the Time-Table window where when you click a teachers name in the main window, the time table gets displayed. The cells with ('-
') means the teacher has not been assigned a period / Is free.
Crossed out classes mean the class is unavailable.
To copy the time table for a day click the respective name of the day.
To copy time table by period click on the respected row.
these are all the things that you see when you open up the window. When do some interaction, there are some more sub-windows that show up :
Obsolete option -- use the child window to look at time-table of teachers
Opens up the excel file in any installed office software to edit
Using this feature you can select a number of classes and give them the status of 'unavailable' - teachers teaching these classes will show up as free and when viewing the time table(1.1) these classes will be crossed out these classes will also count in the free period that are shown in the status bar(5)
Here you can scaling of the program and choose from 150+themes available
these icon have information regarding the window they are on because most people are not gonna read this documentation lol
You can skip this part if the data has already been entered for you
The data for the program is read using a file in the directory of the program named 'Teacher_data.xlsx' If the file is not found program will ask for the file (img 1) If a valid file is provided it will be copied to directory of the program with name 'Teacher_data.xlsx'
What you see here is a map of what gets read by the program the elements in green are read by the program and elements with a white/not shown background are ignored
one sheet of the excel file only contains the time table for one teacher
The department can contain any numbers,charecters excluing ':'
the value is read after the chracter ':'(i.e.. program ignores everything before it)
extra spaces at the ends of the string is removed
The whole cell is read for the teacher name can contain any numbers,charecters
extra spaces at the ends of the string is removed
any spaces are removed
any lowercase charecter is converted to uppercase
empty cells are treated as free periods for the teacher
as there is a uniqe sheet for each teacher. in the final data file there will be alot of
sheets so,it is suggested to name the sheet as <teacher_name,teacher_deparment>. This is not
read but helps in organising the sheets
the sql server is simple 2 table database. in the server a database is created named ssa_db inside the database there are 2 tables : teacher_data and time_table
The teacher_data sheet stores the subject that teacher teaches and other related info (can be added in the future). The time_table sheet stores the name of the teacher along with the day number (0,1,2,3,4) and the time table of the teacher for that day
Made with ❤ by Parth Sahni