hiren patel
New Member
hi
you are really doing great.
great tutorials and examples.
from few days I am planning to develop school/college time table in excel but i am facing some issues.
I want to automate whole process of developing school/college timetable. few details are as below.
i have data of
classes (say 1sem ce,3 sem ce etc)
classrooms (room numbers like room no 12 , roomno 15 etc)
laboratories (laboratory numbers like lab1,lab2 etc)
faculties (faculties who teaches in class and lab)
subjects (list of subjects offered to different semester students)
i have to follow some criterias like
-school timing is from 11 to 5.30 (two 15 min recess is there)
-lecture duration is 1 hours
-lab duration is 2 hours
-have to place 4 lectures and 1 lab per day (6 hours)
-may be 0 hours lecture during morning time from 10 am to 11 am or at evening time from 5.30 to 6.30
-during lab hours students come in batches like lab 1 , sem 1 batch a1 , lab 2 sem 1 batch a2 etc.
and the process of developing timetable is as below.
- assign teacher to class for some subject like teacher a will take subject a in class a in classrooma and also same for lab
- now start placing teacher in class like say teacher a in class a in lecture no 2
it will be for all teachers i meant assigning teacher to class
- teachers have some category like cata teacher , catb teacher
cata have to assing say 6theory ,6 lab per week
catb have to assing say 6theory , 14 lab
- from above will have class time table ready , now need to develop teacher summary , class summary to see all the data in one sheet or say one place.
during above process need to take care of some issues like no there should be no continue lecture for a faculty , there should be no collision ..... two teacher in one class
or say one teacher in two classes at the same time
we can assign extra lectures , labs to teacher and any how that extras should be come in with some marking like extra lec , lab should be with gray color .
might be i missed some details to provide here but after reading above one may have ruff idea.
awaiting for reply,
good day
you are really doing great.
great tutorials and examples.
from few days I am planning to develop school/college time table in excel but i am facing some issues.
I want to automate whole process of developing school/college timetable. few details are as below.
i have data of
classes (say 1sem ce,3 sem ce etc)
classrooms (room numbers like room no 12 , roomno 15 etc)
laboratories (laboratory numbers like lab1,lab2 etc)
faculties (faculties who teaches in class and lab)
subjects (list of subjects offered to different semester students)
i have to follow some criterias like
-school timing is from 11 to 5.30 (two 15 min recess is there)
-lecture duration is 1 hours
-lab duration is 2 hours
-have to place 4 lectures and 1 lab per day (6 hours)
-may be 0 hours lecture during morning time from 10 am to 11 am or at evening time from 5.30 to 6.30
-during lab hours students come in batches like lab 1 , sem 1 batch a1 , lab 2 sem 1 batch a2 etc.
and the process of developing timetable is as below.
- assign teacher to class for some subject like teacher a will take subject a in class a in classrooma and also same for lab
- now start placing teacher in class like say teacher a in class a in lecture no 2
it will be for all teachers i meant assigning teacher to class
- teachers have some category like cata teacher , catb teacher
cata have to assing say 6theory ,6 lab per week
catb have to assing say 6theory , 14 lab
- from above will have class time table ready , now need to develop teacher summary , class summary to see all the data in one sheet or say one place.
during above process need to take care of some issues like no there should be no continue lecture for a faculty , there should be no collision ..... two teacher in one class
or say one teacher in two classes at the same time we can assign extra lectures , labs to teacher and any how that extras should be come in with some marking like extra lec , lab should be with gray color .
might be i missed some details to provide here but after reading above one may have ruff idea.
awaiting for reply,
good day
