Resumen

FLORES RAMIREZ, Yolanda. Proposal of an automated Excel template to assess self-esteem, self-concept, and motivation. RIDE. Rev. Iberoam. Investig. Desarro. Educ [online]. 2023, vol.14, n.27, e510.  Epub 27-Oct-2023. ISSN 2007-7467.  https://doi.org/10.23913/ride.v14i27.1546.

Failure and desertion in higher education institutions has become a widespread problem, especially in the initial semesters, affecting terminal efficiency. The objective of this study was to create a unique template, automated in Excel with macros for the assessment of psychological factors and, with the results, generate intervention strategies to help reduce these rates. The template was designed with items from the scales of the González Arratia Instrument (IGA 2001), Academic Motivation Scale (EMA) and Tennessee Self Concept Scale. The methodology was of an applied nature, with a quantitative approach, descriptive, experimental, and analytical scope. The variables were: automated template, failure, and dropout. The methodology was: the design of the template according to the basic Excel programming with macros, through piloting the Cronbach's alpha coefficient determined with a reliability of 0.79, the template was applied to a sample of 31 students of the first semester of the Public Accountant Program of the Instituto Tecnológico Superior de Nuevo Casas Grandes; 9 men and 22 women with an age range of 17 to 18 years old. The results of this study were: automated instrument for individual assessment, report of the scores obtained by the students in each of the factors and the design and implementation of an intervention strategy. It is concluded that the automated instrument and the timely assessment are key to detect risk situations and to intervene with targeted and specific strategies to promote the permanence and retention of students.

Palabras llave : automation; dropout; psychological factors; staffing; failure.

        · resumen en Español | Portugués     · texto en Español     · Español ( pdf )