Gustav Brock
gustav at cactus.dk
Wed Aug 18 09:24:16 CDT 2004
Hi Jim Oh, it was just an example; I didn't know 4.7 was a magic number. If so, adjust to: FinalGrading = Int(AverageGrading + 0.3) Further, the word "probably" is difficult to handle - you will need exact boundaries to set up formulas. /gustav > Interesting thought but I'm not sure that that's the answer either Gustav for a couple of reasons. > This would mean that every person with a 4.5 or greater would be in the "O" category when they probably belong in "V". I've also got a person whose old average was 89.9 with a 1-5 average of 4.7 > (although maybe that 1/10 of a point is moot in this case I've got to lower one of the 13 grades by over 6 points to see a change in grouping level). > I can always send you my test numbers if you feel like playing with them. > Thanks, > Jim D. --- > Isn't this a normal rounding issue? > If you calculate the final grading as: > FinalGrading = Int(AverageGrading + 0.5) > you will get an "O" for an average grading of 4.7. > /gustav >> We have an automated employee evaluation form that allows supervisors/managers to grade their staff in 13 categories on the following scale: >> O 100 - 90 >> V 89 - 80 >> G 79- 70 >> I 69 - 60 >> U Below 60 >> There's been much discussion among management to change this scale to a 1 to 5 rating but given a sample of 10 evaluations changing each grade above to a 1-5 value does not end up with the same >> average over the 13 categories (in other words, on certain employees who averaged in the "O" or outstanding group the 1-5 average was 4.7 where I need it to be 5 to get them in the Outstanding >> rating). >> Is there a way for us to change our grading system without dropping certain grades from the (previously) correct bucket?