[1]曲典,严华刚,郭学谦,等.基于VBA的Excel格式大学物理实验报告批阅系统的设计与实现[J].中国医学物理学杂志,2018,35(9):1112-1116.[doi:10.3969/j.issn.1005-202X.2018.09.022]
 QU Dian,YAN Huagang,GUO Xueqian,et al.Design and implementation of a VBA-based auto-assessment system for college laboratory reportsin Excel format[J].Chinese Journal of Medical Physics,2018,35(9):1112-1116.[doi:10.3969/j.issn.1005-202X.2018.09.022]
点击复制

基于VBA的Excel格式大学物理实验报告批阅系统的设计与实现()
分享到:

《中国医学物理学杂志》[ISSN:1005-202X/CN:44-1351/R]

卷:
35卷
期数:
2018年第9期
页码:
1112-1116
栏目:
其他(激光医学等)
出版日期:
2018-09-27

文章信息/Info

Title:
Design and implementation of a VBA-based auto-assessment system for college laboratory reports in Excel format
文章编号:
1005-202X(2018)09-1112-05
作者:
曲典严华刚郭学谦许莉莉张智河师玮张海霞熊华晖黄菊英黄晓清郭江贵刘志翔
首都医科大学生物医学工程学院,北京100069,
Author(s):
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
关键词:
实验报告自动批阅ExcelVBA编程大学物理
Keywords:
laboratory report auto-assessment Excel Visual Basic for Applications-based programming college physics
分类号:
O4-4;TP311.52
DOI:
10.3969/j.issn.1005-202X.2018.09.022
文献标志码:
A
摘要:
为提高大学物理实验报告批阅的准确性和一致性,解决传统物理实验报告手工批阅工作量大、难以检验数据处 理正确性等问题,设计了一套实验报告模板及基于此模板的可实现自动批阅的分析程序系统。实验报告分析程序采用微 软公司的Visual Basic for Applications(VBA)编写,可自动读取Excel 格式的实验报告,并对数据格式和正确性进行分 析。此外,本系统还可反馈实验报告批阅中发现的问题,并将这些问题进行小结和汇总。
Abstract:
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.

备注/Memo

备注/Memo:
【收稿日期】2018-06-10 【基金项目】高等学校教学研究项目医药类专业物理学在线开放课程 资源建设子课题(DWJZW201501zx-13) 【作者简介】曲典,硕士,主管技师,主要研究方向:医学物理,E-mail: qudian0101@163.com;严华刚,博士,副教授,主要研究方 向:医学物理,E-mail: yanhg@ccmu.edu.cn(曲典与严华刚 为共同第一作者) 【通信作者】刘志翔,硕士,副教授,主要研究方向:医学物理,E-mail: ml_001163@sina.com
更新日期/Last Update: 2018-09-28