MS EXCEL TEMPLATES FOR MODELING PROBLEMS ON INTEGRATION OF RATIONAL FUNCTIONS
DOI:
https://doi.org/10.31110/fmo2026.v41i1-03Keywords:
templates for modeling mathematical tasks, MS Excel environment, MS Excel, LaTeX, mathematical analysis, integration of rational functionsAbstract
Formulation of the Problem. In teaching mathematical analysis, regardless of the educational organization, training exercises play an essential role in developing and improving students’ practical skills and abilities. In particular, when studying the integration of rational functions, there is a need for a large number of similar tasks that are methodologically correct, computationally moderate, and focused on the formation of appropriate algorithmic skills. Practice shows that an arbitrary choice of numerical parameters in such tasks often leads to cumbersome calculations involving fractional or irrational expressions, which does not correspond to the didactic purpose of training exercises. This determines the relevance of developing formalized approaches to task modeling that meet predefined didactic requirements.
Materials and Methods. To address the stated problem, an analysis of theoretical and practical results of Ukrainian and international researchers and practitioners concerning the design of mathematical tasks was conducted. MS Excel was used to create task templates, followed by formatting the problem statements and solutions using the LaTeX typesetting system.
Results. A set of templates for the automated generation of collections of training tasks with controlled complexity and predefined methodological characteristics has been developed. It is shown that the use of such templates enables the avoidance of incorrect or didactically undesirable variants, increases the effectiveness of students’ independent work, and significantly simplifies the preparation of instructional materials.
Conclusion. The development of templates in the MS Excel environment for modeling tasks on the integration of rational functions is an effective tool for creating educational content aimed at students’ independent practice. The proposed approach combines mathematical correctness, methodological appropriateness, and technological accessibility, making it suitable for teaching mathematical analysis.
Downloads
References
Kruglova, N., & Dykhovychnyi, O. (2025). Application of ICT in creating template programs for generating test tasks in higher mathematics. Information Technologies and Learning Tools, 108(4). 175–192. https://doi.org/10.33407/itlt.v108i4.6130 (in Ukrainian)
Mykhalevych, V.M., Krupsky, Ya.V. & Shevchuk, O.I. (2008). Mathematical models for generating tasks on integration by parts of indefinite integrals. Bulletin of Vinnytsia Polytechnic Institute, 1. 116–122. (in Ukrainian)
Radchenko, S.P. (2021). Algorithms for generating mathematical tasks using the template method. In Theoretical and practical aspects of the use of mathematical methods and information technologies in education and science: collective monograph (ed. by O. Lytvyn). (92–114). Kyiv. B. Grinchenko University. https://doi.org/10.28925/9720213284km (in Ukrainian)
Alamri, H. A., Watson, S., & Watson, W. (2021). Learning Technology Models that Support Personalization within Blended Learning Environments in Higher Education. TechTrends, 65. 62–78. https://doi.org/10. 1007/s11528-020-00530-3
Astafieva, М., Hlushak, О., & Lytvyn, О. (2024). Using STACK to support adaptive mathematics learning in LMS Moodle. IX International Workshop on Professional Retraining and Life-Long Learning using ICT (ICTERI 2024). 30–41. https://ceur-ws.org/Vol-3781/
Bodnenko, D., Lytvyn, O., Radchenko, S., & Proshkin, V. (2021). The templates methods in e-learning of higher mathematics. In E-learning in the Time of COVID-19: monograph. (199–209). Katowice-Cieszyn, University of Silesia in Katowice.
Bokhove, C. (2017). Supporting Variation in Task Design Through the Use of Technology. In Digital Technologies in Designing Mathematics Education Tasks, 239–257. https://doi.org/10.1007/978-3-319-43423-0_12
Gierl, M., & Lai, H. (2016). A process for reviewing and evaluating generated test items. Educational Measurement:Issues and Practice, 35(4), 6–20. https://doi.org/10.1111/emip.12129
Joubert, M. (2016). Revisiting Theory for the Design of Tasks: Special Considerations for Digital Environments. In Digital Technologies in Designing Mathematics Education Tasks (A. Leung, A. Baccaglini-Frank (Eds.)). 17–40. https://doi.org/10.1007/978-3-319-43423-0_2
Kieran, C., Doorman, M., & Ohtani, M. (2021). Frameworks and Principles for Task Design. In Task Design In Mathematics Education (A. Watson, M. Ohtani (eds.)). New ICMI Study Series, 19–81. https://doi.org/10.1007/978-3-319-09629-2_2
Leung, A., & Baccaglini-Frank, A. (Eds.). (2017). Digital Technologies in Designing Mathematics Education Tasks. Potential and Pitfalls. https://doi.org/10.1007/978-3-319-43423-0
Sangwin, C., & Grove, M. (2006). STACK: addressing the needs of the neglected learners. / Proceedings of the Web Advanced Learning Conference and Exhibition, WebALT, 81-96.
Watson, A., & Ohtani, M. (Ed.) (2015). Task design in mathematics education an ICMI Study 22. Springer. https://doi.org/10.1007/978-3-319-09629-2
Zaika, O., Vakaliuk, T., Riabko, A., Kukharchuk, R., Mintii, I., & Semerikov, S. (2021). Selection of online tools for creating math tests. AREdu 2021: 4th International Workshop on Augmented Reality in Education, at Kryvyi Rih, Ukraine, 82–106. https://doi.org/10.31812/123456789/4594
Zaslavsky, O., & Sullivan, P. (Eds.). (2011). Constructing knowledge for teaching: Secondary mathematics tasks to enhance prospective and practicing teacher learning. New York: Springer. https://doi.org/10.1007/978-0-387-09812-8
Downloads
Published
Issue
Section
Categories
How to Cite
License
Copyright (c) 2026 Сергій Радченко, Марія Астаф'єва, Анатолій Мазур
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
- Authors grant the journal a right of the first publication of the work under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License (CC BY-NC-SA 4.0)that allows others freely to use (read, copy and print) submissions, search content and link to published articles, disseminate their full text and use them for any legitimate non-commercial purposes (i.e. educational or scientific) with the mandatory reference to the article’s authors and initial publication in this journal.
- Original published articles cannot be used by users (exept authors) for commercial purposes or distributed by third-party intermediary organizations for a fee.
