MS Excel templates for modeling problems on integration of rational functions

Астаф'єва, Марія Миколаївна and Радченко, Сергій Петрович and Мазур, Анатолій Валерійович (2026) MS Excel templates for modeling problems on integration of rational functions Фізико-математична освіта, 41 (1). pp. 21-25. ISSN 2413-1571, 2413-158X

Text M_Astafieva_S_Radchenko_FMO_41_1_FITM.pdf Download (599kB)

Abstract

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.

Item Type:	Article
Uncontrolled Keywords:	templates for modeling mathematical tasks; MSExcel environment; LaTeX; mathematical analysis; integration of rational functions
Subjects:	Статті у періодичних виданнях > Фахові (входять до переліку фахових, затверджений МОН)
Divisions:	Факультет інформаційних технологій та математики > Кафедра математики і фізики
Depositing User:	Доцент Марія Миколаївна Астаф'єва
Date Deposited:	25 Mar 2026 12:16
Last Modified:	25 Mar 2026 12:16
URI:	https://elibrary.kubg.edu.ua/id/eprint/56720

Actions (login required)

View Item