Question

On the next page, you will find sample performance appraisal data for 10 employees at a bank. A rating of 1 is considered poor, 3 is satisfactory, and 5 is excellent. Due to budget constraints, we want to train any employee whose performance is less than satisfactory. Look at the data and determine: a) What types of training are needed for all employees? _____________________________________________________________________________________________ _____________________________________________________________________________________________ _____________________________________________________________________________________________ _____________________________________________________________________________________________ _____________________________________________________________________________________________ b) What training is needed by each employee? Dawson ____________________________________________________________________ Coombs ____________________________________________________________________ Anderson ____________________________________________________________________ Trebek ____________________________________________________________________ Sajak ____________________________________________________________________ Karn ____________________________________________________________________ Eubanks ____________________________________________________________________ O’Hurley ____________________________________________________________________ Harvey ____________________________________________________________________ Ludden ____________________________________________________________________

Performance Dimension ______________________________________________

Employee ABCDEFG

Dawson 5 2 3 5 5 2 5

Coombs 4 5 1 5 5 4 1

Anderson 5 4 4 5 5 5 3

Trebek 5 5 2 4 5 4 5

Sajak 5 4 2 5 5 1 4

Karn 5 2 2 5 5 5 5

Eubanks 4 5 4 5 5 2 4

O’Hurley 4 5 1 3 5 3 4

Harvey 4 1 1 2 1 3 2

Ludden 5 4 3 5 5 1 2 _____________________________________________________________ Note: A rating of 5 indicates excellent performance. A = Accuracy of Data Input B = Accuracy of Teller Drawer C = Cross-Selling D = Friendliness E = Attendance F = Knowledge of Bank Services G = Knowledge of Customer Names

Answer 1

The above data was tabulated in excel and conditional formatting was applied to it giving the below result:-

Steps to perform conditional formatting:-

Select the data:-

From the home tab select conditional formatting followed by the steps given below:-

Answer a) FRom the generated table we get that there is no activity for which all the employees need training.

Answer b) The individual training for the employees are :-

Where , A = Accuracy of Data Input , B = Accuracy of Teller Drawer , C = Cross-Selling , D = Friendliness , E = Attendance, F = Knowledge of Bank Services, G = Knowledge of Customer Names