The Euler's Graphical User Interface Spreadsheet Calculator for Solving Ordinary Differential Equations by Visual Basic for Application Programming

International Research and Innovation Summit 2017

Tay, Kim Gaik^1 ; Cheong, Tau Han^2 ; Lee, Ming Foong^1 ; Kek, Sie Long^1 ; Abdul-Kahar, Rosmila^1

Universiti Tun Hussein Onn Malaysia, Parit Raja, Johor, Batu Pahat

86400, Malaysia^1

Universiti Teknologi Mara, Selangor, Shah Alam, Malaysia^2

关键词: Derivative functions;    Error messages;    Input and outputs;    Interactive graphical user interface;    Life long learning;    Numerical scheme;    Self-learning;    Visual basic for applications;   

Others  :  https://iopscience.iop.org/article/10.1088/1757-899X/226/1/012186/pdf
DOI  :  10.1088/1757-899X/226/1/012186

来源: IOP

【 摘 要 】

In the previous work on Euler's spreadsheet calculator for solving an ordinary differential equation, the Visual Basic for Application (VBA) programming was used, however, a graphical user interface was not developed to capture users input. This weakness may make users confuse on the input and output since those input and output are displayed in the same worksheet. Besides, the existing Euler's spreadsheet calculator is not interactive as there is no prompt message if there is a mistake in inputting the parameters. On top of that, there are no users' instructions to guide users to input the derivative function. Hence, in this paper, we improved previous limitations by developing a user-friendly and interactive graphical user interface. This improvement is aimed to capture users' input with users' instructions and interactive prompt error messages by using VBA programming. This Euler's graphical user interface spreadsheet calculator is not acted as a black box as users can click on any cells in the worksheet to see the formula used to implement the numerical scheme. In this way, it could enhance self-learning and life-long learning in implementing the numerical scheme in a spreadsheet and later in any programming language.