基于VBA与Excel的高校成绩统计分析模板设计

该文应用VBA(Visual Basic for Application)对Excel二次开发的功能,编程设计了成绩统计与分析模板,实现了学生考试成绩的自动统计和填写、自动完成了各分数段人数和重点观测指标的统计、自动生成了分析图表等。应用该模板,可以大大减轻教师进行学生考试成绩统计与分析工作带来的负担,对教学管理中的学生成绩统计与分析具有一定的推广使用价值。

The Template Design of Result Statistics and Analysis Based on VBA and Excel

This article applied VBA (Visual Basic for Application) to the Excel re-development functions, the programming has designed the result statistics and the analysis template, realized the student to take a test the result automatic statistics and filling in, has completed various scores section population and the key observation target statistics automatically, has produced the analysis graphics automatically and so on. Using this template, may reduce the teacher to carry on the student greatly to take a test the burden which the result statistics and the analysis work bring, has certain promotion use value to in the teaching management student result statistics and the analysis.