Proposal of an automated Excel template to assess self-esteem, self-concept, and motivation
Abstract
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.
Downloads
This work is licensed under a Creative Commons Attribution 4.0 International License.
In order to promote the development and dissemination of research in education in Latin America, the Ibero-American Journal for Educational Research and Development (RIDE) adhered to the Budapest Open Access Initiative, which is why it is identified as a Open access publication. This means that any user can read the complete text of the articles, print them, download them, copy them, link them, distribute them and use the contents for other purposes. Creative Cummons licenses allow users to specify the rights to use an open access journal available on the Internet in such a way that users know the rules of publication. Authors who publish in this journal accept the following conditions: Authors they keep the author's rights and give the magazine the right of the first publication, with the work registered with the attribution license of Creative Commons, which allows third parties to use the published material whenever they mention the authorship of the work and the first publication in this The authors can make other independent and additional contractual agreements for the non-exclusive distribution of the version of the article published in this journal (eg, include it in an institutional repository or publish it in a book) as long as they clearly indicate that The work was published for the first time in this magazine. Authors are allowed and recommended to publish their work. low on the Internet (for example on institutional or personal pages) before and during the review and publication process, as it can lead to productive exchanges and to a greater and faster dissemination of the published work
