【摘要】 数值计算已经成为研究复杂系统物理规律时不可缺少的手段,但基于各个方面的困难,它很难在大学物理课程中有所体现。本文介绍了借助Excel软件将数值计算嵌入大学物理课程的方法,给出了利用Excel软件实现可视化、数值积分和求微分方程数值解的方法。文中所述的方法简捷易行,可操作性强,且不必耗费大量学时,非常适用于面向低年级理工科学生的大学物理课程。采用此方法,可以使低年级学生较早地熟悉数值计算,更好地掌握物理知识和应用物理知识解决问题,是大学物理课程教学改革的一种有益尝试。更多还原

【Abstract】 Numerical calculation is an indispensable means to study complex physics systems,but it is difficult to be reflected in the course of introductory physics due to various reasons.This paper introduces the method of embedding numerical calculation into introductory physics curriculum by using Excel software.It shows how to do visualization,numerical integration and solve numerical differential equations by Excel.The method described in this paper is simple,easy to operate,and does not need to spend a great deal of teaching hours.It is very suitable for introductory physics courses designed for junior college students.This method is aimed at helping the lower grade students know the numerical calculation earlier and learn physics more effectively,it also helps students relate what they are learning to real-world problems.It is a useful attempt on the teaching reform of the introductory physics courses.更多还原