Excelia with applicationsautomated calculation of probabilities

Abstract

Automated calculation refers to the numerical operations carried out on the topics of probabilities, by the design, construction and programming of the new Excelia digital resource of the technological didactic type with values ​​added to Excel. It is undeniable, from popular knowledge, the level of difficulty that students show when learning numerical subjects, particularly the topic of probabilities. New strategies have always been sought in the hope of transforming this reality. The problem is supported by the works of Barroso, Jerez (2013); Bologna, E. (2011); Fontanelli, Mansilla y Miramontes (2020); Gómez, Contreras and Batanero (2015); López and Gómez (2022) and Serrano-Díaz (2022). Its objective was to: Design techno-didactic resources, such as Excelia, with applications on various topics related to probabilities and their distributions. The methodology used was documentary, descriptive and applied. The Excelia construction was carried out based on some Excel functions, with the support of logical functions and some mathematical devices (Carrasquero 2023). As a product of this research, there are applications that can be combined and customized according to the interest of teachers and students, grouped into a statistical calculator and an instructional resource. Finally, this product is considered of great interest due to its multiple benefits, especially time savings and low level of difficulty in its use, since only the data must be entered and it is up to the user to interpret the results in light of their theoretical context