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