The development and application of VBA macros in the teaching of science and mathematics

Бодненко, Дмитро Миколайович та Локазюк, Олександра Вікторівна та Прошкін, Володимир Вадимович та Радченко, Сергій Петрович (2026) The development and application of VBA macros in the teaching of science and mathematics CEUR Workshop Proceedings (4260). с. 92-107. ISSN 1613-0073

Текст D_Bodnenko_CEUR_4260_FITM.pdf - Опублікована версія Download (1MB)

Анотація

The article examines the use of Visual Basic for Applications (VBA) macros in teaching sciences and mathematics, highlighting their potential for didactic visualization and automating computational processes. It outlines methodological approaches for integrating VBA into educational materials, which include transitioning from basic models of phenomena to creating interactive interfaces for conducting controlled educational experiments. Practical applications of VBA are provided to emphasise key elements of academic content, facilitate virtual experiments, and enhance the management of MS Office documents that were created using earlier software versions. The article also presents the results of a teacher training program that confirms the effectiveness of using VBA, even for individuals with no prior programming experience. In conclusion, VBA can serve as an effective tool for modernising traditional teaching materials, fostering the development of interactive educational resources, and improving the quality of the learning process. The article suggests areas for further research, particularly in evaluating the impact of VBA-enhanced content on the development of students’ critical and algorithmic thinking skills, the development of mathematical modelling abilities, and the interpretation of results using valid mathematical methods.

Тип елементу :	Стаття
Ключові слова:	VBA macros; computational models; digital visualisation tools; automation of education; science education; mathematics education
Типологія:	Статті у базах даних > Scopus (без квартилю)
Підрозділи:	Факультет інформаційних технологій та математики > Кафедра математики і фізики
Користувач, що депонує:	доцент Дмитро Бодненко
Дата внесення:	29 Вер 2026 09:28
Останні зміни:	29 Вер 2026 09:28
URI:	https://elibrary.kubg.edu.ua/id/eprint/59645

Actions (login required)

Перегляд елементу