Uso de Microsoft Excel en la enseñanza de la multiplicación de matrices y su incidencia en los resultados académicos

Abstract

Abstract: This study conducts an investigation on the use of Microsoft Excel in the teaching of matrix multiplication and the incidence on academic results, through computational mathematics or applied mathematics. For this purpose, a didactic sequential method is developed through basic programming to obtain the solution of the matrix resulting from matrix multiplication. The development, implementation and use of the tool for the construction of the explanatory method is detailed step by step, which was implemented in an Experimental Group and the comparative analysis with a Control Group for its subsequent observation of the result in the SPSS software. Likewise, the incidence of the academic results of this method is demonstrated with the U-MANN WHITNEY statistical test, since the samples are independent and do not pass the normality test, this non-parametric test was applied to accept the Null Hypothesis (Ho), or the Alternative Hypothesis (Ha). Allowing the comparison between the two study populations, it was possible to contrast the results, accepting the hypothesis of the research hypothesis (Ha)