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

Abstract: 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.

Key words: Excel, University physics experiment, Data processing, Automatic review of experimental data, Excel function, Conditional format