Solving the problem of performance scoring with Excel

Project background:

CND Company is a well-known brand of car dealers, its 30 4S stores, employs nearly 1000 people. At the end of the year, according to the company performance test method, to more than 100 middle-level cadres to perform performance scoring, based on the results of the annual award awards.

Challenges to face:

1, the quantity is too many.

According to the performance appraisal method, each employee should evaluate all the managers in line and the manager of the relevant department. With a simple estimate, there are at least 7,000 more scoring tables, which are too numerous to be handled by manual labor alone.

2, the score table logic relationship is complex.

The company has designed different grading tables for managers of different positions, which manager corresponds to which rating table, which staff needs to grade, and the corresponding logical relationship is more complicated.

3, Privacy protection issues

In the past, the use of artificial release paper scoring table method, although anonymous survey, but because of the fear of being recognized handwriting, there are still many employees do not put the real idea expressed.

4. Data specification Issues

As a result of the use of paper grading table, the staff fill out the problem of illegible handwriting, and worse, some company policies can not be implemented. For example, need to fill in, not each is a full mark. The random degree of filling is too large.

5, the progress of control issues

The whole process is either too hasty or too lengthy because of the need to hand out questionnaires, fill them up and recycle them. Unable to control the entire investigation score process. I can't even figure out which questionnaires have been sent or not.

6, Data aggregation problem

Finally put all the scoring table collected back, for each grading table sorting sorting is not a simple thing, let alone quickly make statements, analysis of the problems inside.

Solution:

Gosta Microsoft Advanced Technology Education Center of the instructors team, based on years of teaching experience and professional Excel knowledge, the use of "Gao da Excel Data Management platform", quickly and efficiently solve the problem of customers, won the high evaluation of customers.

We have taken the following steps to solve the above problems for our customers:

1, according to the existing data, respectively, the establishment of "staff table" and "middle-level cadre table"

2, let all levels of managers into the Excel Data management platform, the definition of the subordinate manager which rating table, which staff need to score.

3, the personnel department through the mail merge, automatically sends an e-mail to each employee, the message contains needs to access the rating table address and an "identification number". "Identification number" is a random system generated by the unique code, only the system understand the "identification number" behind the information represented.

4, staff access to the address of the rating table, fill in the "Identification number", in Excel to display all of his own should be filled in the list of rating lists. Double-click a cell to open the rating sheet for a rating.

5, the Grading table after the scientific design, can include multiple-choice questions (radio, multiple-choice), scoring questions, fill in the blanks. And according to the company policy, made the corresponding restrictions.

6, the personnel department through the "Progress tracking Table" automatically tracking which forms are filled out, which tables have not been filled out.

7, all the grading form completed, automatically by departments, posts, personnel summary, and some projects produced Excel charts for quick analysis.