Many teachers have a headache, when faced with large-scale test results of the check entry is a tedious task. In this year’s exam, I encountered such a thing. His or her own way I shared with you, I hope to help you.

In order to minimize entry errors, the requirements of each Section must be recorded by three different people, if the entry one of three different results on the need to re-find papers, verification results. More than 10,000 candidates, six subjects, how to check it? Just when I knitted brows at the time, Excel function in the if out of mind, if A = B, B = C, A = C is not the same results on the three it? I am out in the A column B column C can enter the number 10, out in the D input function “= IF (A8 = B8, IF (A8 = C8, IF (B8 = C8 ,)))”, results appeared in two a value of “0 and FLASE”. Three the number of the emergence of the same value is “0″, the three have a number of different values is the emergence of “FLASE”. Data on the D list “automatic selection” can not not elected by the same value it?

Entry in the results after I use this method in less than two hours of time on more than 10,000 candidates, six subjects failed entry papers all print out the list of candidates, and the original test or No. chronological order, it is also very easy to find. Spent less than four hours to check on all completed, quick and accurate! Do not believe you try, simple and practical.