基于“宏”的大学物理实验数据处理方法  

Data Processing Method of College Physics Experiments Based on Macros

作　　者：于红 郭梓骞 宫礼坤 黄军威 聂士忠 田咏桃 YU Hong;GUO Ziqian;GONG Likun;HUANG Junwei;NIE Shizhong;TIAN Yongtao(College of Science,China University of Petroleum(East China),Qingdao 266580,Shandong,China;College of Oceanography and Space Informatics,China University of Petroleum(East China),Qingdao 266580,Shandong,China)

机构地区：[1]中国石油大学(华东)理学院,山东青岛266580 [2]中国石油大学(华东)海洋与空间信息学院,山东青岛266580

出　　处：《实验室研究与探索》2020年第9期142-147,共6页Research and Exploration In Laboratory

基　　金：中国石油大学(华东)2019年研究生教育教学改革课程建设研究类项目(YKC2019004);山东省研究生教育优质课程(SD YKC19028)。

摘　　要：为加快学生的实验进程,减少教师快速检验实验结果正确性的难度和工作量,针对大学物理实验,提出一种"一键"处理实验数据的新方法—基于Excel中的"宏"编写算法。以测量数据较多的直流电桥测电阻和金属电子逸出功测量两个实验为例,给出程序编写流程、代码和演示界面等。该方法将大学物理实验与编程相结合,简便易行,可供多人、多个实验同时一次性处理大量测试数据。既能保证计算结果的准确性,又节约了师生的时间。在当今大数据时代,具有较广的应用范围和较强的推广价值。A new experimental data processing method based on the macro algorithm in Excel was proposed in China.One-key pressing could dramatically speed up lots of experimental data processing for students and unimaginably reduce the difficulty and workload of teachers in checking results.The programming process,code and demonstration interface were given by sampling two experiments data processing.They were measuring resistance by direct current bridge and measuring escape power of the metal electron.This method is a great outcome of the knowledge combination between the college physics experiment and programming.It is simple and easy to be used simultaneously by many students to process vast amount of data on different experiments.Not only the accurate calculation results can be output extremely fast,but also huge time can be saved for students and teachers.This method is very potential for wide applications in the current big data era.

关 键 词：宏 电子表格 数据处理 直流电桥 逸出功 

分 类 号：G642[文化科学—高等教育学] O433[文化科学—教育学]