This is a very simple software to make $30 on and get a quick good referance on, What I require is a windows application. Monthly assignment of instuctors at a classroom for a period of the day according to some controls.
There are 2 individual class rooms. Usage of 1 or 2 rooms should be selected by the user.
The period of avalibility of the rooms are at;
Room A Room B
Hours Period Hours Period
00-04 A 00-04 A
04-08 B 04-08 B
08-12 C 08-12 C
12-16 D 12-16 D
16-20 E 16-20 E
20-00 F 20-00 F
Each period has 2 instructors and 2 students (students will be entered manually)
The type of instructors are SFI ,TRI and TRE(examiner)
So each period is assigned a (SFI or TRI) and TRE.
The conditions are:
Each period is known as a sector and an SFI can only lecture 20 sectors a month.
There are no limitations on TRI and TRE on lecture sectors
An SFI,TRI or TRE cant lecture 2 periods in a row and can max lecture 2 sectors in a day.
(TRI is used only if an SFI is unavailable) can only be used 10 times a month.( like a joker)
The program should work based on the current calendar month as the day number varies month to month.
The SFI and TRE list will be entered manuely to the DB, TRI is entered only if required.
Output conclusion to Excel.
NO INSTRUCTOR CREW PERIOD
R1/R1K ( this is the unique line number) A(SFI name) / B (TRE name) A(Student 1) / B (Student 2) A1(Room1)
R2/R2K (Only the numbers increment) C(SFI name) / D(TRE name) C(Student 3) / D (Student 4) A2(Room2)
R3/R3K (incase no sfi is available) E(TRI name) / F(TRE name) E(Student 5) / F ( Student 6) B1(Room1)
A1 is Period:A at room 1
A2 is Period: A at room 2
The SFI, TRI and TRE should have a language option on them.
T / B / E are the options selected while entering the names,
if T is selected it can only lecture with another B / T
if B is selected it can lecture with T / B / E
if E is selected it can lecture with B / E
( enter a name, select ( SFI/ TRI / TRE), select language option ( T/B/E)
*Enter a name, Select instructor type(SFI/TRI/TRE), select language of instructor( T/E/B)
*Select the month to be applied to from calender.
*Select 1 or 2 rooms available for that month.
*For a period there should be a (SFI or TRI) and a TRE.
*Assign ( SFI and TRE) according to;
*SFI can lecture 20 sectors a month and cant lecture 2 sectors in a row and can max lecture 2 sectors a day,
ex; if lectured sector A can lecture Sector C but cant lecture sector B.
*if in case there is no SFI available assign a TRI. max allowed 10 a month.
*The lecturers have to communicate there for the conditions.( T= turkish, B= Both, E = English)
(SFI or TRI) = T the TRE = B / T
(SFI or TRI) = B the TRE = T / B / E
(SFI or TRI) = E the TRE = B / T
*export to excell.
reference INSTRUCTORS PERIOD/ROOM STUDENT
R1/R1K (SFI or TRI) and TRE A1