利用“宏”技术实现成绩自动统计

Automatic Statistics of Students' Scores with Macro

针对教师在期末成绩统计中操作比较繁琐的问题,介绍了在Excel中如何使用“宏”技术实现对学生成绩报告单中各分数段人数及所占百分比的自动统计处理,提高了教师统计成绩的效率。

In order to reduce the students＇ scores statistical work in the end of term,this paper introduces a method using ＂Macro＂ technology in EXCEL to implement the students＇ scores automatic statistics in all kinds of grades.It can improve the efficiency of statistics work for teachers.