A New Methodology to Teach Numerical Methods With MS Excel
A New Methodology to Teach Numerical Methods With MS Excel
复制标题
使用 MS Excel 教授数值方法的新方法
DOI：
--
复制
发表时间：
2012
期刊：
影响因子：
--
通讯作者：
J. Galán
中科院分区：
文献类型：
--
作者：
S. Fernández;J. Orosa;J. Galán
数值方法是工程师解决工作中常见的典型问题的主要工具之一。这些方法通常只有在用计算机编程语言实现时才有用。尽管如此，用于数值分析的典型数学资源提供了一个不友好的环境，使学生无法获得用于求解每个方程的理论的更深层次知识，并在参数(如时间和迭代次数)上区分每种数值方法。为了应对这一点，阿科鲁纳大学在其IV合同计划中建议海洋工程教授定义一种新的教育方法来实施数值方法的学习。结果表明，利用Microsoft Excel可以很好地解决主要数值方法的求解问题，提高了学生的理解水平，尤其是采用图形表示的方法。最后，需要使用Visual Basic for Applications等编程语言来分析实施这种教学方法的可行性，当在Microsoft Excel中引入这种语言时，将允许在未来更好地开发这种方法。
Numerical methods are one of the principal tools employed by engineers to solve typical problems that commonly arise at work. These methods are generally only useful when implemented with a computer programming language. Despite this, typical mathematical resources for numerical analysis present an unfriendly environment that prevents a student from acquiring a deeper knowledge of the theory employed to solve each equation and to distinguish between each of the numerical methods in parameters like time and number of iterations. To counter this, the University of A Coruna, in its IV contract program proposed that marine engineering professors define a new educational methodology to implement the learning of numerical methods. Results showed that the principal numerical methods resolution could be solved with Microsoft Excel, where students can attain a higher level of understanding, especially when implemented with graphical representation. Finally, the feasibility of implementing this teaching methodology needs to be analyzed with programming languages like Visual Basic for Applications that when introduced in Microsoft Excel, will allow for better developing the methodology in the future.