GUIDELINES TO PREPARE TIME TABLE

1. GUIDELINES TO PREPARE TIME TABLE By R.PADMAVATHI PRT, K.V. ANNA NAGAR apsrp@yahoo.com

2. Teacher Individual print Class time table print Teachers names Checking sheet Class timetable allotment Subject Sheet

3. Important point to remember • Do not delete the first row and the last row in any sheet (e.g. TR1 and TR40 in class_tr_allot sheet , english and library row in subject sheet etc.

4. Steps to do in Teacher sheet • We should give the names of all the teachers in primary/secondary including miscellaneous and adhoc teachers etc. • This is prepared for five-section school. • Unnecessary lines can be deleted. • Do not delete the first and last row (i.e. TR1 & TR40). You can rename the teacher name, But you should not delete the row.

5. How to replace the name of teacher Select full row

6. How to change the names of teacher • Select one row fully (from A to FF column) • EditReplace • Select replace All to change particular row. Enter Teachers Initial Step 1 Step 2

7. Important points to remember • Do not delete the first and last row. • There are so many hidden formulas. • Do not delete any columns in this sheet. • Give the senior most teacher’s initial in the place of TR1. • Give the junior most teacher’s initial in the place of TR40. • You can delete the middle rows other than first row (TR1) and last row(TR40) • This will help us to get the initials of teachers in the time table

8. Subject Sheet- Second sheet Combination of two subject also can be given. E.g FS/ART means when there is no film show the children will have ART period by the same teacher. Comp/Bio means computer Science students will go for computer science and biology students go for biology subject. First row Names of subjects Last row

9. Points to remember • You can insert any subject in between first and last row. • Do not delete any subject after the last row. (i.e after library) • Do not create any row before first row ( i.e.before English) • Formulas are formed based on the first and last row. Software may not work properly if you delete first and last row. • You can change the name of the subject.

10. Class time-table allotment Class Time table Teachers time table

11. Class time table Click on the ▼ to get pop up menu of teachers list • From the teachers list you can select the initial of teachers to whom you want to give the class. • In the( pop menu) list you can get the names of teachers those who are available free .

12. Subject selection Click on the ▼ to get pop up menu of subject list Popup menu of subject • From the subjects list you can select the subject name. • In the( pop menu) list you will get the names of all subjects you have defined in the SUBJECT SHEET.

13. Teachers time table • Do not do any entry in the teachers time table. • Since it is child centered school, the importance is given for class time table. • The entries in the teachers time table will be made by the computer it self. • While allotting a period to a class in the class time table, the computer will automatically post that period to the concerned teacher’s time table. • So it avoids mistake in posting from class time table to teacher’s time table.

14. Teachers’ Time Table

15. Subject allotment checking This will help us to check the total number of periods allotted.

17. Class timetable printout Select the class and take the print out of it.

18. Teachers’ Time Table Print Select and take the print out of individual teacher.