Excel在大学物理实验教学中的应用  

Application of Excel in College Physics Experiment Teaching

作　　者：赵彩敏[1] 董新平[1] 闫润瑛[1] ZHAO Caimin;DONG Xinping;YAN Runying(School of Science,Xuchang University,Xuchang Henan,461000,China)

机构地区：[1]许昌学院数理学院,河南许昌461000

出　　处：《创新创业理论研究与实践》2024年第12期161-164,共4页The Theory and Practice of Innovation and Enterpreneurship

基　　金：2022年度许昌学院教育教学改革研究与实践项目“基于‘三位一体’模式的大学物理实验教学考核方式的创新研究”(XCU2022-YB-18)

摘　　要：该文针对传统纸质实验报告的弊端,提出了Excel在大学物理实验教学中的应用。利用Excel数据处理和数据统计分析查阅功能,对大学物理实验所测得实验数据进行数据处理和Excel自动批阅实验数据。学生利用Excel快捷﹑准确地处理实验数据,有助于重视实验数据的处理,提高科学素养;教师利用Excel自动批阅实验数据,减少了烦琐的批改工作量。Excel在理工科大学物理实验中的应用,消除了传统实验报告存在的弊端,为不断提高教学效果奠定基础。Aiming at the disadvantages of traditional paper experiment report,the application of Excel in college physics experiment teaching was put forward.By using Excel data processing and data statistical analysis and consulting functions,the experimental data measured in the university physics experiment were processed and calculated,and the experimental data were automatically reviewed by Excel.Students use excel to process experimental data quickly and accurately,which helps students pay attention to the processing of experimental data and improve their scientific literacy;teachers use excel to automatically review experimental data,reducing the tedious workload of correction.The application of Excel in physics experiments in universities of science and technology has abandoned the shortcomings and drawbacks of traditional experimental reports,and laid the necessary foundation for continuously improving teaching effects.

关 键 词：EXCEL 大学物理实验 数据处理 自动批阅实验数据 EXCEL函数 条件格式 

分 类 号：G663.7[文化科学—教育学]