Root Finding Methods Through GUI in Spreadsheets
Root Finding Methods Through GUI in Spreadsheets
DOI:
https://doi.org/10.53560/PPASA(59-1)644Keywords:
Teaching Mathematics, Spreadsheets, Microsoft Excel, Root Finding Methods, Bisection Method, Secant Method, False Position Method, Newton-Raphson MethodAbstract
Root finding Methods like the Bisection Method, Newton Raphson Method, Secant Method, and False Position Method have been revisited through a new approach. EACH METHOD’S user-friendly GUI computer programs have been developed on an Excel spreadsheet. A root locator graph is introduced in the spreadsheets, which helps identify the initial guess(es) required to calculate root using these methods. All real roots are now easily calculable by any of the four methods. The detailed steps to calculate roots are also shown on the spreadsheet. The spreadsheet can be made ready for the next calculation with a single click. We have developed a technique for Excel that helps accept polynomial in variable ‘x’ without directly mentioning cell location.
References
H. S. Drier, Teaching and learning mathematics with interactive spreadsheets. School science and mathematics, 2001. 101(4): p. 170-179.
J. B. Soper, J.B. and M.P. Lee, Spreadsheets in teaching statistics. Journal of the Royal Statistical Society: Series D (The Statistician), 1985. 34(3): p. 317-321.
J. C. Nash, Teaching statistics with Excel 2007 and other spreadsheets. Computational Statistics & Data Analysis, 2008. 52(10): p. 4602-4606.
K. Jones, Using spreadsheets in the teaching and learning of mathematics: A research bibliography. MicroMath, 2005. 21(1): p. 30-31.
S. A. Khan Microsoft Excel in the physics classroom. in The Third Annual Conference for Middle East Teachers of Mathematics, Science and Computing, The Petroleum Institute, Abu Dhabi. 2007.
L. Webb, Spreadsheets in physics teaching. Physics Education, 1993. 28(2): p. 77.
B.A Cooke, Some ideas for using spreadsheets in physics. Physics Education, 1997. 32(2): p. 80.
Healy, L. and R. Sutherland, The use of spreadsheets within the mathematics classroom. International Journal of Mathematical Education in Science and Technology, 1990. 21(6): p. 847-862.
K. W. Wong and J.P. Barford, Teaching Excel VBA as a problem solving tool for chemical engineering core courses. Education for Chemical Engineers, 2010. 5(4): p. e72-e77.
D. Lilley Excel/VBA for Numerical Methods Education, Calculations and Applications in Energy Engineering. in 44th AIAA Aerospace Sciences Meeting and Exhibit. 2006.
A. Uddin, M. Ahsanuddin, and D.D. Khan, Teaching physics using microsoft excel. Physics Education, 2017. 52(5): p. 053001.
Z. Uddin and M.H. Zaheer, Simulating Physics Experiments in Spreadsheets–Experimenting with Ohm’s Law. The Physics Teacher, 2019. 57(3): p. 182-183.
S. K. Gupta, Numerical methods for engineers. 1995: New Age International.
E. J. Billo, Excel for scientists and engineers: numerical methods. 2007: John Wiley & Sons.
Authors, Teaching physics online through spreadsheets in a pandemic situation. Physics Education, 2020. 55(6): p. 063006.
M. Iqbal, et al., Teaching physics online through spreadsheets in a pandemic situation. Physics Education, 2020. 55(6): p. 063006.
LearnChemE. Bisection Example/Excel. 2012 [cited 2012 May 8, 2012]; Available from: https://www.youtube.com/watch?v=q6WdsIJVl9M.
H. Arshad Bisection Method in Excel. 2017 [cited 2017 Apr 18, 2017]; Available from: https://www.youtube.com/watch?v=fmDa-1h5ONo.
Arshad, H. Newton raphson method using MS Excel. 2017 [cited 2017 Apr 17, 2017]; Available from: https://www.youtube.com/watch?v=VuAqKL2hYeE.
Mohammed, M. Excel for Chemical Engineers | 38| False Position Method. 2016 [cited 2016 Feb 29,2016]; Available from: https://www.youtube.com/watch?v=VuAqKL2hYeE.
L. F Stojanovska. Secant Method - Ex.2 (spreadsheet). 2013 [cited 2013 Feb 1, 2013]; Available from:https://www.youtube.com/watch?v=nF4xakajgvY.
Calculator, K.O., Newton method f(x),f’(x) Calculator. 2021.
Mathematics, G.i. Newton-Raphson Method. 2010 [cited 2010 Aug 1, 2010]; Available from: http://www.wolframalpha.com/widgets/view.jsp?id=7366b7a89fc9d6c90e308d633d63884f.
