基于ExcelVBA及函数的成绩上报单的制作

The Design of Transcript Based on Excel Function and Excel VBA

介绍了在Excel下利用内置函数及VBA程序制作班级学生成绩系统,实现数据的自动化处理,包括基本数据的自动导入、总评成绩的自动合成及统计数据的自动生成等。使用户能够快速完成特定任务,提高工作效率和准确性。

The paper describes the design of transcript based on Excel function and Excel VBA, and the implementation of data processing automaticity, including preparing data and inputing data, receiving the final course grades and the statistic data. It helps the user to accomplish the special tasks efficiency.