Instructions for filling in the Excel sheet/form for faculty appraisal
Download the Excel sheet attached below
One Excel sheet per faculty member
Create a copy per faculty member, and rename it to the faculty member's name (e.g. 'Dr. Ali Khan'). Repeat for each faculty member being appraised.
Fill in the yellow cells only
Cells highlighted in yellow are the only ones that should be filled/edited: employee information, Section A ratings (via dropdown), comments, and the manually calculated totals for Sections B, C, and D. Do not overwrite any other cells, as they contain formulas or fixed labels; altering them will disrupt the automatic scoring.
Section A (50%) — automatic scoring
For each of the 32 criteria, select the appropriate cell; a link for the dropdown will show up to the right of the cell. Pick a rating from the dropdown in the 'Rating' column: Not working out / Needs improvement / Good / Very Good / Outstanding.
Sections B, C and D — manual scoring/entry
These sections are assessed by the Chairperson (B), Associate Dean (C), and Dean (D).
In Section B1, click the yellow cell of any question where you wish to place a tick mark; a link for adding the tick mark shows up to the right of that cell.
Attachments
| Faculty Performance Appraisal Form | Open | |
| Instructions for filling in the Excel sheet for faculty appraisal form | Download |
Application Forms (Download if you are applying for a Post)
| Application Form (BPS-17/Above, Teaching/Non-Teaching) | Save |
| Application Form (Non-Teaching Staff, BPS-16/Below) | Save |