An employee evaluation table is a structured tool that sets out the agreed performance criteria for a role, the weight of each criterion and the score the employee achieved, then adds the scores into a final result that translates into a clear rating such as “Excellent” or “Very good”. It helps managers assess their teams in one shared language with consistent criteria, and gives employees a transparent picture of their strengths and of what they need to develop. In this guide we explain the components of the table, how to build one, and give you a ready template you can copy and adapt to your organisation.
What is an employee evaluation table and why does your organisation need one?
In many Saudi organisations, whether a government body serving the public through multiple branches, a retail chain or a private hospital, employee evaluation sometimes rests on the general impression a manager formed in the last few weeks before the review. The result is a set of near-identical ratings that fail to separate strong performers from those who are struggling, and employees who do not know on what basis they were assessed.
An evaluation table solves this by turning the review from a general opinion into a set of written criteria announced in advance, each with its own weight and a clear rating scale. When the same table is used across every department and branch, results become comparable and decisions become fairer.
The main benefits of a standard evaluation table:
- Consistent criteria across departments, branches and cities, so “Excellent” means the same thing whichever manager is rating.
- Less room for personal impressions, because every score must rest on a specific behaviour or result.
- Performance documented throughout the year, instead of relying on a manager’s memory at the end of the cycle.
- A link between evaluation and decisions such as bonuses, training, promotion and transfers.
- Easier conversations between manager and employee, because the discussion focuses on specific items rather than impressions.
The core components of an evaluation table
Whatever its layout, an effective evaluation table has six main elements:
1. Employee details and review period
Name, employee number, job title, department or branch, line manager, and the start and end dates of the review period. These details look obvious, but they are essential for archiving reviews and comparing them from one cycle to the next.
2. Evaluation criteria
These are the items performance is measured against, and they usually fall into two groups: results criteria (what did the employee achieve? for example meeting targets and quality of work) and behaviour and competency criteria (how did they achieve it? for example teamwork, commitment and initiative). A good table balances both.
3. Relative weights
Not every criterion matters equally. A salesperson’s table gives more weight to hitting target, while a customer service employee’s gives more weight to visitor satisfaction. The weights must add up to 100%.
4. Rating scale
A shared scale that defines what each score means. The five-point scale is the most common, and each point should carry a short behavioural description so the number is not read in different ways:
| Score | Rating | Short description |
|---|---|---|
| 5 | Excellent | Consistently exceeds target and is a reference point for colleagues |
| 4 | Very good | Fully meets target and sometimes exceeds it |
| 3 | Good | Meets target most of the time |
| 2 | Acceptable | Meets part of the target and needs follow-up |
| 1 | Needs improvement | Does not meet target and needs a clear improvement plan |
5. Weighted score and final result
Multiply each criterion’s score by its weight, then add the weighted scores to get a final result out of 5, which can be converted into a percentage or a verbal rating.
6. Comments, employee feedback and development plan
A field for the evaluator’s comments explaining the scores, a field for the employee’s comments on the review, and another for the development plan for the next period. These fields are what turn the table from a tool for judging into a tool for improving.
Types of employee evaluation table by type of work
No single evaluation table suits every job. The better approach is to keep one standard structure (the six components above) and change the criteria and weights to fit the role:
| Type of role | Suggested higher-weight criteria |
|---|---|
| Administrative and office roles | Accuracy, meeting deadlines, organisation and follow-through |
| Customer service and branches | Customer or beneficiary satisfaction, speed of service, courtesy |
| Sales | Hitting sales target, customer retention, quality of follow-up |
| Technical and field roles | Quality of execution, compliance with safety requirements, problem-solving |
| Leadership roles | Delivering department goals, developing the team, decision-making |
In front-line roles in particular, such as hospital reception staff or customer-hall staff in government branches and banks, the beneficiary’s view becomes an important source for the “service quality” criterion, provided it is collected in an organised and regular way rather than from scattered complaints.
How to build an employee evaluation table step by step
Follow these steps to build an evaluation table that is actually used and does not become a box-ticking exercise:
- Define the purpose of the review: Is it to set annual bonuses, identify training needs or support promotion decisions? The purpose determines how much detail you need.
- Derive the criteria from the job description and department goals: Choose only five to eight criteria; too many criteria distract the evaluator and blur the differences between employees.
- Assign the weights: Give the criteria that matter most for the role the highest weight, and make sure the total is 100%.
- Describe every score: Define what “Excellent” and “Acceptable” mean for each criterion, using observable behavioural examples.
- Name a data source for each criterion: system reports, attendance records, manager notes and customer feedback. A criterion with no source turns into an impression.
- Pilot the table on a small sample: Use it in one department for one cycle, and gather feedback from managers and employees before rolling it out.
- Train your evaluators: Show managers how to use the scale and the common mistakes, and run a calibration session where they compare their ratings of hypothetical cases.
- Discuss the result with the employee and record their comments: A review handed over without a conversation loses most of its value.
If your organisation is a government body, check the official performance management guides and forms issued by the Ministry of Human Resources and Social Development, and make your internal table a complement to them, not a replacement.
Ready template: employee evaluation table (copy and adapt)
Below is a general template that suits most administrative and customer service roles. Adjust the criteria and weights to fit the nature of your work.
Part 1: Employee details
- Employee name: ……………………..
- Employee number: ……………………..
- Job title: ……………………..
- Department / branch: ……………………..
- Line manager: ……………………..
- Review period: from ………… to …………
Part 2: Evaluation table
| # | Criterion | Weight | Score (1–5) | Weighted score | Evaluator’s comments |
|---|---|---|---|---|---|
| 1 | Achievement of agreed objectives | 30% | |||
| 2 | Quality and accuracy of work | 20% | |||
| 3 | Service to customers or beneficiaries | 15% | |||
| 4 | Compliance with policies and deadlines | 10% | |||
| 5 | Teamwork and collaboration | 10% | |||
| 6 | Initiative and problem-solving | 10% | |||
| 7 | Learning and self-development | 5% | |||
| Total | 100% |
Part 3: How to calculate
- Weighted score = score × weight.
- Final result = sum of weighted scores (out of 5).
- Percentage = final result ÷ 5 × 100.
Part 4: Converting the result into a rating (suggested bands you can adjust)
- 4.50 to 5.00: Excellent
- 3.50 to 4.49: Very good
- 2.50 to 3.49: Good
- 1.50 to 2.49: Acceptable
- Below 1.50: Needs improvement
Part 5: Comments and signatures
- Key strengths: ……………………..
- Key areas for improvement: ……………………..
- Development plan for the next period: ……………………..
- Employee’s comments on the review: ……………………..
- Employee signature: ………… Line manager signature: ………… Date: …………
Illustrative example of the calculation
An employee in a customer service branch received the following scores (hypothetical figures, for illustration only):
| Criterion | Weight | Score | Weighted score |
|---|---|---|---|
| Achieving objectives | 30% | 4 | 1.20 |
| Quality of work | 20% | 5 | 1.00 |
| Customer service | 15% | 4 | 0.60 |
| Compliance | 10% | 3 | 0.30 |
| Teamwork | 10% | 4 | 0.40 |
| Initiative | 10% | 3 | 0.30 |
| Learning and development | 5% | 4 | 0.20 |
| Total | 100% | 4.00 |
The final result is 4.00 out of 5, or 80%, which is rated “Very good”. The table also shows clearly that the two areas for improvement are compliance and initiative, which is exactly where the development plan for the next period should focus.
Common mistakes when using an evaluation table
Even the best table loses its value if evaluators fall into these traps:
- Too many criteria: a twenty-item table pushes managers to give similar scores just to finish the task.
- Criteria that cannot be measured: terms such as “loyalty” or “personality” with no behavioural description open the door to bias.
- The halo effect: an employee who excels in one area receives high scores in every area.
- Across-the-board leniency or severity: one manager rates everyone “Excellent” and another never does, so comparison becomes meaningless.
- Recency bias: rating a whole year on the basis of the last month.
- No link between the result and a decision: if nothing changes after the review, employees treat it as a formality.
From a paper evaluation table to data-driven digital evaluation
Many organisations start with an evaluation table in an Excel file, which works well for small teams. But as branches and headcount grow, clear problems appear: multiple copies of the file, difficulty collecting the data, and no objective source for a criterion such as “customer service”.
This is where linking the evaluation table to live data sources matters. With RateHex, for example, you can collect customer feedback on the service of each employee or branch through touch screens, five-button feedback devices and QR codes, follow the results on real-time dashboards, and generate scheduled PDF and Excel reports that feed the “customer service” criterion with actual figures instead of impressions. The survey designer also lets you build internal evaluation forms in Arabic and English, with role-based permissions so that each manager sees only their own team’s data. You can find the details on the RateHex features page.
To complete the picture, read our guide to the annual employee review to see how the review meeting itself should be run, and our guide to promotion points calculation to see how the table’s results become fair promotion decisions.
Frequently asked questions about the employee evaluation table
How often is the evaluation table used each year?
Formally, it is usually used once or twice a year, but a short quarterly check-in is recommended so that no employee is surprised by the result at year end.
Can one evaluation table be used for all employees?
You can standardise the structure and the rating scale, but the criteria and weights should change with the nature of the role, as in the suggested table above.
Can an employee challenge the result?
Your evaluation policy should include a clear appeal or review procedure, explained to employees before the review cycle begins. Government bodies follow the procedures set out in the official regulations, so refer to them and to your HR department.
Start evaluating more fairly
If you would like to see how customer feedback across your branches can become accurate performance data that supports your employee evaluation table, book a demo with the RateHex team and we will show you how the dashboards and reports look on a case close to your own organisation.
