2022, Number 2
Instrument in Excel for the Qualification of Exams in the Cuban Medical Education
Language: Spanish
References: 12
Page:
PDF size: 978.78 Kb.
ABSTRACT
Introduction: The evaluation of an exam of several questions generates a high number of combinations that, when adding the discount of spelling errors, makes it difficult to give the correct grade and requires a lot of time. The automation of this process was carried out by Santander Montes and collaborators with the professional statistical package PSPP of free distribution.Objective: To build an instrument in Excel for qualifications of partial and final exams, of three, five and seven questions, with spelling errors discounted according to the requirements of Cuban medical education.
Methods: The information and formula tabulation tools offered by the Microsoft Office 2013 Excel program were used.
Results: A simple interface was designed, easy to execute. A sequence was created to determine in the instrument: validity, reliability, representativeness and feasibility. With the repeated review of five professors independently (1 Pediatrics, 1 Internal Medicine and 3 Public Health) and the pilot test (final exam of Public Health of the medical career in the first semester of the 2021-2022 academic year in the Faculty " Julio Trigo López"), a very easy-to-use, valid, reliable and accessible instrument was achieved.
Conclusions: The proposed instrument in Excel speeds up the evaluation process and avoids the errors that are made in manual evaluation.
REFERENCES
Plain Pazos C, Carmona Pentón CR. Aplicación de la instrucción 3/2015 en la calificación de exámenes en la carrera de medicina. Rev Med Electron [Internet]. 2018 Jul-Ago [citado 2 Jun 2019];40(8):[aprox. 4 pantallas]. Disponible en: Disponible en: http://scielo.sld.cu/scielo.php?script=sci_arttext&pid=S168418242018000400035 5. .
Walter Sánchez V, López Hung E, Charón Díaz K, Dinza Zapata I. Automatización de datos para uso de estudiantes del Sistema de Información en Salud. MEDISAN [Internet]. 201312. [consultado:12. 16/12/202112. ];12. 1712. (2):12. 407-41412. . Disponible en: Disponible en: http://scielo.sld.cu/scielo.php?script=sci_arttext&pid=S1029-30192013000200020&lng=es&nrm=iso&tlng=es 12.