How Performance Ratings Using the Sum and Band Methods Are Calculated

The application can calculate ratings for each section and the overall rating using the sum method. You can use the sum method to calculate ratings using any rating model.

You can also use it to calculate the overall rating when at least one of the Profile Content, Performance Goals, or Development Goals sections uses the average method, and the others use the sum method.

Settings That Affect Sum and Band Rating Calculations

The factors that determine sum and band rating calculations are the:

  • Rating models that are selected for each section and content item

  • Numeric ratings and points ranges assigned to each rating level

Items without ratings aren't counted when calculating the ratings. For the band method, the numeric ratings must be associated with a points range. The rounding rules, mapping metric, and mapping methods must also be set in the performance template sections.

How Performance Ratings Are Calculated

In the sum method, the section rating is the sum of the numeric rating from the rating level for each content item. The overall rating is the sum of the numeric ratings for the section ratings.

For the band method, as in the sum method, the application calculates the sum of the section rating. For the overall rating, the application converts the numeric rating total from the sections to the points range associated with a rating level.

Example 1: Sum Method with Sum Sections

ABC Company uses the same rating model for the Competencies, and Performance Goals content items. The performance document contains no Development Goals section. The following table shows the rating levels and the numeric ratings assigned to each level.

Rating Level

Numeric Rating

1-Weak

1

2-Poor

2

3-Average

3

4-Good

4

5-Excellent

5

The following table shows the rating model used for the Competencies and Performance Goals sections, and the rating levels and numeric ratings assigned to each level.

Rating Level

Numeric Rating

1-Weak

5

2-Poor

10

3-Average

15

4-Good

20

5-Excellent

25

The following table shows the rating model for the Overall Summary section and the rating levels and numeric ratings assigned to each level.

Rating Level

Numeric Rating

1-Weak

10

2-Poor

20

3-Average

30

4-Good

40

5-Excellent

50

The following table shows the ratings for the Competencies section.

Competency

Item Numeric Rating

Teamwork

4

Leadership

3

Communication

2

Analytical Skills

4

Ethics

5

Conceptual Thinking

4

The score for the Competencies section is: 4 + 3 + 2 + 4 + 5 + 4 = 22, which maps to the section numeric rating 4-Good.

The following table shows the ratings for the Performance Goals section.

Goal

Item Numeric Rating

Increase sales revenue

5

Cut expenses

3

Grow business in Asia

4

Participate in mentoring

4

The score for the Performance Goals section is: 5 + 3 + 4 + 4 = 16, which maps to the section numeric rating 3-Average.

To determine the overall rating, the application adds the Competencies and Performance Goals sections: 22 + 16 = 38, which maps to the section numeric rating 4-Good.

Example 2: Sum Method with Average and Sum Sections

For a performance evaluation for a specific project, ABC Company sets up a performance template that uses the sum method for the Overall Summary and Competencies sections, but the Performance Goals section uses the average method. In the Competencies section, the content items use a rating model different than that of the section itself. The section uses the same rating as the Overall Summary section. The Performance Goals section uses the same rating model for content items as the Performance Goals section itself.

The following table shows the rating levels and the numeric ratings assigned to each level for the individual content items in the Competencies section.

Rating Level

Numeric Rating

1-Weak

1

2-Poor

2

3-Average

3

4-Good

4

5-Excellent

5

The following table shows the rating levels and the numeric rating assigned to each level for the Competencies section itself.

Rating Level

Numeric Rating

1-Weak

10

2-Poor

20

3-Average

30

4-Good

40

5-Excellent

50

The following table shows the worker ratings for the Competencies section.

Competency

Item Numeric Rating

Teamwork

4

Leadership

3

Communication

2

Analytical Skills

4

Ethics

5

Conceptual Thinking

4

The application calculates the sum of the item rating scores: 4 + 3 + 2 + 4 + 5 + 4 = 22. To determine the section rating, the application uses the mapping rules for the rating model assigned in the performance template. In this example, the mapping rule is Nearest, which assigns the section a rating level of 2.

The following table shows the ratings for the Performance Goals section, which uses the average method.

Goal

Item Numeric Rating

Maximum Rating from Rating Model

Decimal Score (Item Rating / Maximum Rating

Increase sales revenue

5

5

1.0

Cut expenses

3

5

0.6

Grow business in Asia

2

5

0.4

Participate in mentoring

4

5

0.8

The sum of the decimal scores is 2.8, from a possible maximum of 4.0. The 2.8 must be converted to a value on the rating model for the section. The section maximum numeric rating is 5, so the Performance Goals section calculated rating is: (2.8 / 4) x 5 = 3.5.

To determine the Performance Goals final section rating, the application uses the mapping rules for the rating model assigned in the performance template. In this example, the mapping rule is Nearest and the calculated section rating for goals is 3.5 out of 5, which maps to a numeric rating of 4.

To determine the overall rating, the application calculates the sum of the numeric ratings for the Competencies and Performance Goals sections: 20 + 4 = 24, which maps to the section numeric rating 20.

Example 3: Band Method

ABC Company sets up a performance template in which the section ratings are calculated using exactly the same parameters as in the previous example, but the band method is used for the Overall Summary section to calculate the overall rating.

The following table shows the review point ranges set up for the Overall Section rating model to assign the rating level for the overall rating.

Rating Level

From Points

To Points

1-Weak

0

5

2-Poor

6

10

3-Average

11

25

4-Good

26

40

5-Excellent

41

50

To determine the overall rating, add the section numeric ratings from the previous example. The Competencies numeric rating is 20; the Performance Goals section numeric rating is 4. The total is: 20 + 4 = 24. Using the total numeric rating and applying the point ranges shown in the table, the total score of 24 for the sections lies in the range of 11 to 25. The worker's overall rating is 3-Average.