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

- Flehantov, Leonid (orcid.org/0000-0002-4689-1457) and Ovsiienko, Yuliia (orcid.org/0000-0002-4873-9061) (2019) The Simultaneous Use of Excel and GeoGebra to Training the Basics of Mathematical Modeling Proceedings of the 15th International Conference on ICT in Education, Research and Industrial Applications. Integration, Harmonization and Knowledge Transfer, 2 (2393). pp. 864-879. ISSN 1613-0073

Text paper_288.pdf Download (771kB)

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.

Item Type:	Article
Keywords:	Basics of mathematical modeling, computer simulation of mechanical movement, software used in learning of modeling, computer simulation and visualization, simultaneous use Excel and GeoGebra
Subjects:	Science and knowledge. Organization. Computer science. Information. Documentation. Librarianship. Institutions. Publications > 00 Prolegomena. Fundamentals of knowledge and culture. Propaedeutics > 004 Computer science and technology. Computing. Data processing > 004.9 ІКТ ( Application-oriented computer-based techniques ) > 004.94 Simulation Science and knowledge. Organization. Computer science. Information. Documentation. Librarianship. Institutions. Publications > 3 Social Sciences > 37 Education > 378 Higher education. Universities. Academic study
Divisions:	Institute for Digitalisation of Education > Joint laboratory with SIHE “Kryvyi Rih National University”
Depositing User:	Сергій Олексійович Семеріков
Date Deposited:	01 Jul 2019 14:20
Last Modified:	10 Oct 2019 18:55
URI:	https://lib.iitta.gov.ua/id/eprint/716610

Downloads

Actions (login required)

View Item