Excel在数值分析实验教学中的应用

The Application of Excel in the Experimental Teaching of Numerical Analysis

回顾了数值分析实验教学中经常采用的软件,分析了实验教学的特点,并将Excel作为实验软件,以数值分析中典型题目的软件求解过程为例,与采用高级程序设计语言或专用数学软件的教学过程进行对比分析,指出Excel在数值分析实验教学中具有的独特优势.得到了利用Excel进行数值分析实验教学,将使教学更加方便、灵活、直观,并能取得更好效果的结论.

If you select an inappropriate experimental software on the experimental teaching of numerical analysis,the experimental teaching may be less effective.With some software commonly used in the experimental teaching of numerical analysis reviewed,the characteristics of the experimental teaching analyzed and an Excel as experimental software employed,this paper takes some typical topic solution of numerical analysis processed by software as examples,and indicates that Excel has unique advantages in the experimental teaching of numerical analysis based on contrastive analysis of the teaching procedure using high-evel programming language or special mathematical software.Using Excel on the experimental teaching of numerical analysis,we can make the experimental teaching more convenient,flexible,intuitive,and achieve better teaching results.