摘要
针对利用EXCEL对不同专业学员的不同学科成绩进行诸如累计分数段人数、计算标准差等的分类统计操作时的重复性和繁杂性,本文设计了基于VBA图形界面的解决方案,并给出了实现其主要功能的部分VBA程序。
In view of the repeatability and complexity in use of EXCEL to operate category statistics in different disciplines results of Students, such as the number of cumulative scores of paragraph and calculation of standard deviation, this article finds one solution of VBA-based graphical interface, and gives the part of VBA procedures to achieve the primary function.
关键词
VBA分类
统计
学员成绩
VBA category
Statistics
Students' Records