Class Schedule App
Budget: $30 – $250 USD
This is for a class scheduling app. The student info is imported from another app. So there are two imports, One called IN.xls and the other called OUT.xls. The IN file contains ENROLLNO, INDATE,Trainer and other related data and the OUT file contain ENROLLNO and the OUTDATE. When they are scheduling the training section and select a specific trainer from the drop down they should see a list of students who are in the campus and are assigned to the trainer in a tabular form . Sample file in word is attached (ClassSchedule.docx) . They will fill out each session they attended during their duration in the facility. If the student ENROLLNO shows an OUTDATE, that student is out of the campus. So should be marked on the schedule as OUT on the OUTDATE
Sometimes teacher can be a substitute (or a student attend another teacher class. In that case trainer should be able to search and add a student or type in manually to the schedule.
The student GROUPNO in the scheduler can be the same from the import file or it might change. When they change the GROUPNO, it can even have a decimal value. So the scheduler should show the GROUPNO from the import file by default. But should be editable by the trainer in the schedular.
During the import of IN.xls file if ENROLLNO is already in the database skip it.
During the import of OUT.xls file if ENROLLNO is already in the database, add the OUTDATE to the existing record. If there is no entry with INDATE skip that entry.
Reports.
1) Schedule for a trainer for a date range (without weekend)
2) Schedule for a trainer for a date range (including weekend) -Some trainers might have weekend class. Normally it is only weekday class
We will be requiring the full source code as well
Sometimes teacher can be a substitute (or a student attend another teacher class. In that case trainer should be able to search and add a student or type in manually to the schedule.
The student GROUPNO in the scheduler can be the same from the import file or it might change. When they change the GROUPNO, it can even have a decimal value. So the scheduler should show the GROUPNO from the import file by default. But should be editable by the trainer in the schedular.
During the import of IN.xls file if ENROLLNO is already in the database skip it.
During the import of OUT.xls file if ENROLLNO is already in the database, add the OUTDATE to the existing record. If there is no entry with INDATE skip that entry.
Reports.
1) Schedule for a trainer for a date range (without weekend)
2) Schedule for a trainer for a date range (including weekend) -Some trainers might have weekend class. Normally it is only weekday class
We will be requiring the full source code as well