#Teachers report assistant excel how to#
#Teachers report assistant excel download#

In this sheet, we will allot class-wise subjects to teachers as we decided in the previous sheet. Insert the name of the teacher in the cell containing Teacher 1, Teacher 2 and so on. It consists of 30 tables of weekly period load i.e one for each teacher. Teacher’s period load sheet is made to record the period load of 30 teachers. You can decide this depending on the respective teacher’s qualification and caliber. As a supervisor or principal, you are the best judge. Insert the name of the teacher wish or find suitable against the respective class subject. Hence, it will directly fetch the subjects from the previous sheet. This sheet is linked with Class-wise Period Allotment sheet. Similarly, prepare the same type of allotment for Class 2 to 10. The row/column which bears number other then 0 needs your attention. In case it does not match then there is some error. of periods to be taken each day for that particular subject.įor successful allotment, you need to ensure that both column and row with the name ‘Difference’ must be 0 at last. For Accuracy Check, all the 4 green cells of the table must match. Ensure the total in the green cell below it matches no. Insert names of respective subjects of each class in the respective class’s table.Īllot the number of periods for a particular subject you wish to assign to a class. Green cell indicates the sum total of periods per week. We have taken it as 9 periods on regular days and 7 periods on a weekend. Insert no of period load allocated to each working day of the week mentioned in the table. You can make the time table for 10 classes in this sheet.

Class-wise Time Table With Teacher’s Name.

#Teachers report assistant excel how to#

How to use the Academic Period Allotment System Excel Template?Īcademic Period Allotment System Excel Template consists of the following 8 sheets: Let us understand the working of this template in detail.

#Teachers report assistant excel download#

You can also download other educational templates like Yearly School Attendance Sheet and School Report Card and Mark Sheet Template, and Multiple Choice Question – MCQ Test Checking Sheet from our website. Click here to Download All School Management Excel Templates for ₹299. We have created the Academic Period Allotment System after understanding the basic working of the process of allotment in detail.Ĭlick here to download the Academic Period Allotment System Excel Template. Academic Period Allotment System Excel Template Working with this allotment system you will find it as a cakewalk. Using it you can do this task very swiftly and with 100% accuracy.įurthermore, making of this template involves input from teachers, supervisors and school management.

You can use this system to help you prevent errors and make proper allotment for your school’s time table. Many times it happens that we tend not to do the proper allotment or miss some of the important allotments to subjects. This process involves class-wise period allotment, class-wise subject teacher allotment, proper period load to teachers, etc. It is a very tedious and time-consuming task. Usually, we have seen principals, school supervisors setting a school time table. In addition to that, a proper period load is given to teachers. What is the Academic Period Allotment System?Īt the beginning of every academic year, the school has to design a viable time table where each class and subject is covered. It is loaded with various conditional formatting and formulas which will help you to prepare your school’s time table with least efforts.