[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
-
- 关键词:
-
实验报告; 自动批阅; Excel; VBA编程; 大学物理
- 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