在每学期体育测试过程中,我们把学生的成绩认真地记录在测试表中,然后按照评价标准给予每位学生评价,评出优、良、合格、不合格四个等级。以往教师只是按照标准一个一个学生地在表上写上等级,然后数出优、不合格的个数,最后通过笔算出优秀率、合格率。这种方法比较繁琐,要花费很多的时间。我经过多年的尝试,利用Excel表中的If函数和count if函数在体育测试中对学生进行评价, In each semester of sports testing, we record the student’s achievements carefully in the test table, and then give each student evaluation in accordance with the evaluation criteria. The four grades are excellent, good, qualified and unqualified. In the past, teachers just according to the standard one by one to write a grade on the table, and then count the number of excellent, unqualified, and finally calculated by pen excellent rate, pass rate. This method is more complicated, it takes a lot of time. After years of experimentation, I used the If function and the count if function in an Excel table to evaluate students in sports tests,