基于VBA的Excel格式大学物理实验报告批阅系统的设计与实现  

Design and implementation of a VBA-based auto-assessment system for college laboratory reports in Excel format

作　　者：曲典[1] 严华刚[1] 郭学谦[1] 许莉莉[1] 张智河[1] 师玮 张海霞[1] 熊华晖[1] 黄菊英[1] 黄晓清[1] 郭江贵[1] 刘志翔[1] QU Dian;YAN Huagang;GUO Xueqian;XU Lili;ZHANG Zhihe;SHI Wei;ZHANG Haixia;XIONG Huahui;HUANG Juying;HUANG Xiaoqing;GUO Jianggui;LIU Zhixiang(School of Biomedical Engineering,Capital Medical University,Beijing 100069,China)

机构地区：[1]首都医科大学生物医学工程学院,北京100069

出　　处：《中国医学物理学杂志》2018年第9期1112-1116,共5页Chinese Journal of Medical Physics

基　　金：高等学校教学研究项目医药类专业物理学在线开放课程资源建设子课题(DWJZW201501zx-13)

摘　　要：为提高大学物理实验报告批阅的准确性和一致性,解决传统物理实验报告手工批阅工作量大、难以检验数据处理正确性等问题,设计了一套实验报告模板及基于此模板的可实现自动批阅的分析程序系统。实验报告分析程序采用微软公司的Visual Basic for Applications(VBA)编写,可自动读取Excel格式的实验报告,并对数据格式和正确性进行分析。此外,本系统还可反馈实验报告批阅中发现的问题,并将这些问题进行小结和汇总。A set of laboratory report(lab report)modules are designed,and based on that,an analyzing system for automatically assess lab reports is developed to improve the accuracy and consistency in the assessment of college physics lab reports and solve the problems of heavy workload and difficulties to verify the correctness of data processing in traditional grading method.The analyzing programs were written based on Microsoft Visual Basic for Applications.The proposed system can automatically read the lab reports in Excel format,and analyze the format and correctness of the data from lab reports.Furthermore,the system can be used to feedback the issues discovered in the batch-assessment of lab reports and summarize them in a report.

关 键 词：实验报告 自动批阅 EXCEL VBA编程 大学物理 

分 类 号：O4-4[理学—物理] TP311.52[自动化与计算机技术—计算机软件与理论]