Instructions for Filling in the Excel Sheet/Form for Faculty Appraisal
1. Download the Excel sheet attached below
2. One Excel sheet per faculty member
Create a copy for each faculty member and rename it to the faculty member's name (e.g., 'Dr. Ali Khan'). Repeat for each faculty member being appraised.
3. 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.
4. Section A (50%) — automatic scoring
For each of the 32 criteria, select the appropriate cell; a dropdown arrow 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.
5. 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 drop-down arrow will show up to the right of that cell — select the tick mark from it.
6. Inserting Signature Images
Both the Employee Signature and the Chairperson Signature fields must contain an image of the actual signature (a typed name is not sufficient). To insert a signature image into the yellow signature cell:
a) Scan or photograph the signature and save it as an image file (JPG or PNG).
b) Click the yellow signature cell to select it.
c) Go to the Insert tab ? Pictures ? This Device, and select the signature image
d) Drag the corner handles to resize the image so it fits neatly within the yellow cell without covering neighboring cells.
Do this for both the Employee Signature cell (Section B3) and the Chairperson Signature cell (after the Section B score).
7. Submission
Once the sections belong to you in all the forms/sheets are completely and correctly filled, email them to:
managerhr@kgmc.edu.pk
along with all necessary supporting documents, including the mandatory Personal Development Plan where indicated.
Attachments
| Faculty Performance Appraisal Form | Download | |
| Instructions for filling in the Excel sheet for faculty appraisal | Download |
Application Forms (Download if you are applying for a Post)
| Application Form (BPS-17/Above, Teaching/Non-Teaching) | Save |
| Article Verification Proforma | Save |
| Application Form (Non-Teaching Staff, BPS-16/Below) | Save |