Excel在高校数学教学中的应用

Application of Excel in college mathematics teaching

为了提高高校数学教学效果,阐述了在数学教学中如何利用Excel的内置函数、数学公式和散点图功能绘制同一坐标系中的复杂函数曲线,给出利用Power函数和图表功能求复杂高次方程近似解的具体过程,探索出一种有利于学生学习数学课程的教学方式,为数学教学创新提供了一种新思路.

In order to improve the teaching effect of mathematics in colleges,this paper not only expounded how to draw the complex function curve in the same coordinate system by using Excel′s built-in function,mathematical formulas and scatter diagram function,but also offered the specific process to find the approximate solutions of complex higher order equation with the Power function and chart function.It explores a new teaching mode which is beneficial to students′mathematics learning and provides a new way of thinking for mathematics teaching innovation.