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

Application of Excel in college mathematics teaching

作　　者：刘昕辉[1] 巩晓秋[1] LIU Xin-hui;GONG Xiao-qiu(Modern Education Technology Center,Liaoyang Vocational College of Technology,Liaoyang Liaoning 111000)

机构地区：[1]辽阳职业技术学院现代教育技术中心,辽宁辽阳111000

出　　处：《辽宁师专学报（自然科学版）》2020年第3期8-10,98,共4页Journal of Liaoning Normal College(Natural Science Edition)

基　　金：2020年度辽宁省现代远程教育学会科研课题(2020XH-39)。

摘　　要：为了提高高校数学教学效果,阐述了在数学教学中如何利用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.

关 键 词：EXCEL 数学教学 应用 

分 类 号：TP391.13[自动化与计算机技术—计算机应用技术]