文章基本信息

标题：A Spreadsheet Solution of a System of Ordinary Differential Equations Using the Fourth-Order Runge-Kutta Method
本地全文：下载
作者：Tay, Kim Gaik ; Kek, Sie Long ; Abdul-Kahar, Rosmila 等
期刊名称：Spreadsheets in Education (eJSiE)
印刷版ISSN：1448-6156
出版年度：2012
卷号：5
期号：2
页码：5
出版社：Bond University
摘要：Solving systems of ordinary differential equations (ODEs) by using the fourth-order Runge-Kutta (RK4) method in classroom or in examinations is quite tedious, tiring and boring since it involves many iterative calculations. Hence, there is a need to design a suitable tool in teaching and learning the numerical methods involved, especially those for solving systems of ODEs. Here, we present a new approach to solving systems of ODEs by the RK4 method through the use of an EXCEL spreadsheet to tackle these drawbacks. In doing so, we employ the concept of relative row, relative column and fixed column in the spreadsheet to obtain the solution of systems of ODEs by the RK4 method. With the appropriate differential function given by the user, it is found that the way suggested here is faster than applying a scientific calculator and the solution obtained is significantly more accurate. Besides, the concept presented here can be extended to solve systems of ODEs up to n equations using the spreadsheet. In addition to this, the students can gain a deep understanding of the iterative procedure involved in solving the systems of ODEs. Although the spreadsheet approach is not as good as other mathematical software, it does provide a step-by-step environment for teaching and learning the numerical methods. We conclude that the spreadsheet approach increases the interest of students in learning the RK4 method.
关键词：Spreadsheet Excel; systems of ordinary differential equations; fourth-order Runge-Kutta methos