DSpace Home
→
Електронні публікації
→
Фізико-математичний факультет
→
Кафедра інформатики та прикладної математики
→
View Item

The Simultaneous Use of Excel and GeoGebra to Training the Basics of Mathematical Modeling

Flehantov, Leonid; Ovsiienko, Yuliia

URI: http://elibrary.kdpu.edu.ua/xmlui/handle/123456789/3173
https://doi.org/10.31812/123456789/3173

Date: 2019-06-30

Abstract:

The main objective of this study is testing the hypothesis that the visualization of simulation results creates the conditions for improving students’ knowledge, taking into account the specifics of their professional training. In this article we are exploring how the simultaneous use of Excel and GeoGebra can improve the learning outcomes of engineering students in agricultural universities when learning the basics of mathematical modeling (using as example the mathematical model of mechanical movement of two bodies with their elastic collision). We worked with our students as follows. First, we build and interpret the mathematical model. Then we obtain two alternative computer models: we use Excel spreadsheets for numerical modeling as well as GeoGebra software for analytical-geometrical modeling. By this models we visualize and explore the processes closely related to topics that plays an important role in the training of agricultural production engineers, in particular, with study the movement and interaction of particles during the loading / unloading of seeds, the description of industrial processes of seed scarification, with study of the movement of particles of yeast suspension in a plate separators, modeling the processes of shot-blast cleaning of metal surfaces etc. We have tested this approach in teaching the 163 students enrolled in the specialties “Agroengineering” and “Industry Engineering” in Poltava State Agrarian Academy. According to data we collected our students demonstrated a better understanding of the conceptual issues of mathematical modeling and acquired significant abilities in using this method to solve real problems.

Description:

1. Arbain, N., Shukor, N.A.: The Effects of GeoGebra on Students Achievement. Procedia - Social and Behavioral Sciences. 172, 208–214 (2015). doi:10.1016/j.sbspro.2015.01.356 2. Aulakh, M., Khan, Z.M., Sana, A.: Learning styles and their impact on the nursing students’ percertion: across-sectional descriptive research. Indo American Journal Of Pharmaceutical Sciences. 05(08), 8129–8134 (2018). doi:10.5281/zenodo.1406293 3. Caligaris, M., Rodríguez, G., Laugero, L.: Learning Styles and Visualization in Numerical Analysis. Procedia - Social and Behavioral Sciences. 174, 3696–3701 (2015). doi:10.1016/j.sbspro.2015.01.1101 4. Caligaris, M.G., Schivo, M.E., Romiti, M.R.: Calculus & GeoGebra, an Interesting Partnership. Procedia - Social and Behavioral Sciences. 174, 1183–1188 (2015). doi:10.1016/j.sbspro.2015.01.735 5. Fikhtengolts, G.M.: Course of differential and integral calculus. 2. Moscow (1970) 6. Flehantov, L., Antonets, A.: Computer simulation the mechanical movement body by means of MathCAD. Information technologies in education. 1(30), 97–109 (2017). doi:10.14308/ite000622 7. Flehantov, L.O., Ovsiienko, Yu.I.: Differentiated approach in teaching the basics of mathematical modeling with MS Excel for students of agricultural universities. Information Technologies and Learning Tools. 54(4), 165–182 (2016). doi:10.33407/itlt.v54i4.1407 8. GeoGebra | Free Math Apps – used by over 100 Million Students & Teachers Worldwide. https://www.geogebra.org (2019). Accessed 21 Feb 2019 9. Horda, I.M., Flehantov, L.O.: Computer modelling of process of the mechanical motion of body with the help of MS Excel means. Information Technologies and Learning Tools. 47(3), 99–109 (2015). doi:10.33407/itlt.v47i3.1245 10. Hryb’iuk, O.O., Dem’ianenko, V.M., Zhaldak, M.I., Zaporozhchenko, Yu.H., Koval, T.I., Kravtsov, H.M., Lavrentieva, H.P., Lapinskyi, V.V., Lytvynova, S.H., Pirko, M.V., Popel, M.V., Skrypka, K.I., Spivakovskyi, O.V., Sukhikh, A.S., Tataurov, V.P., Shyshkina, M.P.: Systema psykholoho-pedahohichnykh vymoh do zasobiv informatsiino-komunikatsiinykh tekhnolohii navchalnoho pryznachennia (System of psychological and pedagogical requirements to ICT learning tools). Atika, Kyiv (2014) 11. Hall, J., Lingefjärd, T.: Mathematical Modeling: Applications with GeoGebra. John Wiley & Sons, Hoboken (2016) 12. Valdés y Medina, E.G., Valdés, L.M.: Dynamic Models as Change Enablers in Educational Mathematics. Procedia - Social and Behavioral Sciences. 176, 923–926 (2015). doi:10.1016/j.sbspro.2015.01.559 13. Ramirez-Velarde, R., Alexandrov, N., Perez-Cazares, R., Barba-Jimenez, C.: Mathematical Modelling Based Learning Strategy. Procedia Computer Science. 51, 1694–1704 (2015). doi:10.1016/j.procs.2015.05.307 14. Razali, N.M., Wah, Y.B.: Power comparisons of Shapiro-Wilk, Kolmogorov-Smirnov, Lilliefors and Anderson-Darling tests. Journal of Statistical Modeling and Analytics. 2(1), 21–33 (2011) 15. Semerikov, S.O., Teplytskyi, I.O., Yechkalo, Yu.V., Kiv, A.E.: Computer Simulation of Neural Networks Using Spreadsheets: The Dawn of the Age of Camelot. In: Kiv, A.E., Soloviev, V.N. (eds.) Proceedings of the 1st International Workshop on Augmented Reality in Education (AREdu 2018), Kryvyi Rih, Ukraine, October 2, 2018. CEUR Workshop Proceedings, vol. 2257, pp. 122–147. http://ceur-ws.org/Vol-2257/paper14.pdf. Accessed 21 Mar 2019 16. Smetackova, I.: Gender Stereotypes, Performance and Identification with Math. Procedia - Social and Behavioral Sciences. 190, 211–219 (2015). doi:10.1016/j.sbspro.2015.04.937 17. Soloviov, V.M., Semerikov, S.O., Teplytskyi, I.O.: Instrumentalne zabezpechennia kursu kompiuternoho modeliuvannia (Instrumental computer simulation courseware). Kompiuter u shkoli ta simi. 4, 28–31 (2000) 18. Spivakovsky, A., Petukhova, L., Spivakovska, E., Kotkova, V., Kravtsov, H.: ThreeSubjective Didactic Model. In: Ermolayev V., Mayr H.C., Nikitchenko M., Spivakovsky A., Zholtkevych G. (eds) Information and Communication Technologies in Education, Research, and Industrial Applications. ICTERI 2013. Communications in Computer and Information Science, vol. 412, pp. 252–273. Springer, Cham (2013). doi:10.1007/978-3-319-03998-5_13 19. Teplytskyi, I., Semerikov, S.: Kompiuterne modeliuvannia mekhanichnykh rukhiv u seredovyshchi elektronnykh tablyts (Computer modeling of mechanical movements in an spreadsheets environment). Fizyka ta astronomiia v shkoli. 5, 41–46 (2002) 20. Teplytskyi, I.O., Semerikov, S.O.: Kompiuterne modeliuvannia absoliutnykh ta vidnosnykh rukhiv planet Soniachnoi systemy (Computer simulation of absolute and relative motions of the planets the Solar system). Zbirnyk naukovykh prats Kamianets-Podilskoho natsionalnoho universytetu. Seriia pedahohichna. 13, 211–214 (2007) 21. Teplytskyi, I.O., Semerikov, S.O.: Na perekhresti ekolohii, matematyky, informatyky y fizyky (At the intersection of ecology, mathematics, computer science and physics). Zbirnyk naukovykh prats Kamianets-Podilskoho natsionalnoho universytetu. Seriia pedahohichna. 18, 34–37 (2012) 22. Teplytskyi, I.O., Teplytskyi, O.I., Humeniuk, A.P.: Seredovyshcha modeliuvannia: vid zaminy do intehratsii (Modeling environments: from replacement to integration). New computer technology. 6, 67–68 (2008) 23. Teplytskyi, I.O.: Elementy kompiuternoho modeliuvannia (Elements of computer simulation). 2nd edn. KSPU, Kryvyi Rih (2010)

Show full item record