Development and Assessment of Instructional Material to Enhance Microsoft Excel Learning in a Pharmacology Laboratory

Abstract

Microsoft Excel is a widely used tool for data management, analysis, and presentation in various fields, including healthcare and education. In the PHA 352 course, Pharmacology Laboratory for Pharmacy Students, at the College of Pharmacy, Rangsit University, students use Microsoft Excel to calculate and present experimental data. However, many students encounter difficulties with Microsoft Excel's basic and advanced scientific functions, highlighting the need for targeted training to meet course demands. This study aimed to develop instructional material for Microsoft Excel via the ADDIE model for the PHA 352 course. Students’ perceptions of the material, as well as their understanding and skills in using Microsoft Excel, were evaluated. Pretest and posttest designs were used to measure competency levels, with a focus on essential Microsoft Excel functions for the course. Statistical significance between the scores was determined using a paired t-test or Wilcoxon signed-rank test at the 0.05 level. An online questionnaire was used to assess students’ satisfaction with and perceived effectiveness of the material's content, exercises, and usability. Data were analyzed via descriptive statistics. The results from 160 third year pharmacy students revealed a significant improvement in posttest scores compared with pretest scores, demonstrating the effectiveness of the instructional material in enhancing Microsoft Excel skills. The findings indicate that students were highly satisfied, valuing how the material aligned with the course objectives and its practical uses. In conclusion, the instructional material for Microsoft Excel was effective in enhancing students’ Microsoft Excel skills.