Improving Students’ Retention in Mathematics Using Excel Spreadsheet Software Package in Port Harcourt, Nigeria

Authors

  • Onyekachi Uchechukwu Ahumaraeze University of Port-Harcourt
  • Chinyere Elizabeth Nlewedim University of Port-Harcourt

DOI:

https://doi.org/10.37640/jim.v5i2.2147

Keywords:

Deductive Teaching Method, Excel Spreadsheet Software Package, Measures of Central Tendency, Retentions

Abstract

This study investigated the use of Excel spreadsheet software to improve students' retention in Mathematics in Port Harcourt. It aimed to compare the retention of students taught measures of central tendency using Excel with those taught using the deductive method and to determine if retention differed between male and female students taught with Excel. A quasi-experimental research design was employed. A sample of 133 students was selected from a population of 4,584 public junior secondary school students in Port Harcourt Local Government Area, Rivers State, using purposive sampling. Data were collected using a validated Measures of Central Tendency Retention Test. The experimental group used the Excel spreadsheet software package, while the control group used the deductive method. Analysis was conducted using mean, standard deviation, and analysis of covariance at a 0.05 significance level. The findings of the study revealed that the Excel spreadsheet package significantly enhances students' retention. Additionally, male students taught with the Excel spreadsheet package demonstrated higher retention than their female counterparts, though the difference was not statistically significant. It was recommended, among other suggestions, that Excel spreadsheets be used to teach measures of central tendency to improve students' retention.

References

Agala, U. C., Malae, D., & Idemudia, J. F. (2020). Effects of use of spreadsheet on the performance and retention of senior secondary school students on the graphing of mathematical functions. International Journal of Mathematical Innovation, 8, 41–58.

Agwo, F. C. F. (2020). Spreadsheet usage and acceptance by senior secondary school teachers and teachers for computation. Journal of Science Educatio, 6(2), 118–125.

Ajah, C. N. (2017). Computer-based instruction and senior secondary school students’ retention in Mathematics. Meridian Journal of Social Sciences, 5(2), 143–149.

Computer Hope. (2021). What is Excel? Computer Hope. https://www.computerhope.com/jargon/e/excel.htm

Dania, B., & Anakwe, G. C. (2019). Spreadsheet usage in professions and careers. Halland Printers.

Dennis, A. A. (2015). Paper and pencil vs digital problem-solving: A plus or a minus? International Journal of Social Sciences, 1(3), 12–19.

DuBose, A., Williams, Y., & Clayton, J. (2023). Central Tendency | Overview, Measures & Examples. study.com. https://study.com/academy/lesson/central-tendency-measures-definition-examples.html

Ekpet, T. T. (2017). Effect of spreadsheet on students’ achievement in senior secondary school Mathematics concepts in Aba North local government area of Abia State. Abayi Journal of Education Principles and Practice, 2, 37–44.

Ekpeyong, Z., Garuba, O. D., & Philemon, H. (2017). Computer assisted instruction on junior secondary students’ performance in Mathematics. Journal of Humanities and Societal Development, 9(8), 77–84.

Federal Ministry of Education. (2012). 9-year basic education curriculum: JSS 1-3 Mathematics. NERDC Printing Press.

George, N. R., & Kumah, M. S. (2021). Enhancing senior secondary students’ performance in statistical charts using microsoft excel spreadsheet software package in Rivers State Nigeria. International Journal of Scientific and Research Publications, 11(12), 427–432.

Gopalan, K. F. (2020). Research methods and statistics. Gallant Chike Press.

Haruna, G. S. (2020). Impact of spreadsheet on students’ academic retention in Mathematics. Journal of Educational Learning and Growth, 5(1), 68–79.

Hopskin, D. K. (2019). Rudiments of spreadsheets for accounting. Hellens Publishers.

Iji, C. O., Abakpa, B. O., Agbo-Egwu, A. O., & Takor, D. I. (2022). Utilizing microsoft excel spreadsheet technology to improve senior secondary school students’ achievement and retention in quadratic function in Nigeria education. International Journal on Teaching and Learning Mathematics, 5(1), 1–14. https://doi.org/10.18860/ijtlm.v5i1.18292

Jotform. (2021). 12 Best Spreadsheet Software Options to Try. YouTube. https://www.youtube.com/watch?v=xPOKA8mfMYQ

Macrotrends LLC. (2024). Port Harcourt, Nigeria Metro Area Population 1950-2024. Macrotrends. https://www.macrotrends.net/global-metrics/cities/22018/port-harcourt/population

Massekela, P., & Bongasella, U. (2020). Effects of Microsoft excel spreadsheet on tertiary students’ performance and retention in data coding. Journal of Mathematics and Statistics Education, 5(3), 34–41.

Nwachukwu, O. W. (2019). Rudiments of educational venture. Presslink Books Ltd.

Nwankwo, O. C. (2013). A practical guide to research writing for students of research entreprise (5th ed.). University of Port Harcourt Press Ltd.

Obiajunwah, E. F. (2019). Effects of use of spreadsheet software package on senior secondary school students’ retention in algebra. Journal of Mathematics and Statistics Education, 4(3), 60–72.

Ogale, H. F. E. (2019). Effects of microsoft excel spreadsheet on the performance and retention of students in geometrical visualization. International Journal of Scientific Research, 6(12), 67–74.

Olaniya, K., & Enbeli, C. A. (2020). Enhancing junior secondary school students’ performance and retention in the construction of pie charts in Ondo State. Ekuadalor Journal of Teaching and Learning, 9, 62–74.

Pemberton, J. D., & Robson, A. J. (2000). Spreadsheets in business. Industrial Management & Data Systems, 100(8), 379–388. https://doi.org/10.1108/02635570010353938

Sadiku, M. N. O., Shadare, A. E., & Musa, S. M. (2017). Digital natives. International Journal of Advanced Research in Computer Science and Software Engineering, 7(7), 125–126. https://doi.org/10.23956/ijarcsse/v716/01620

Scharaldi, K. (2020). What are the benefits of teaching math using technology? Texthelp. https://www.texthelp.com/resources/blog/what-are-the-benefits-of-using-technology-for-math/

Spataro, J. (2021). New pricing for Microsoft 365. Microsoft. https://www.microsoft.com/en-us/microsoft-365/blog/2021/08/19/new-pricing-for-microsoft-365/

Tellu, G. L. (2019). Software packages for mathematics teaching and learning. Quims and Brims Books.

The West African Examinations Council. (2020). General Mathematics Paper 2, WASSCE (PC). Waeconline. https://www.waeconline.org.ng/e-learning/Mathematics/maths230jc.html

Uchendu, A., Ibrahim, U. R., & Sadiq, Q. I. (2021). Effect of using computer spreadsheet package on students’ performance in teaching and learning Mathematics. Journal of Computer Education, 1(1), 18–25.

Ucheson, K. S. (2018). Efficacy of use of digital spreadsheet on students’ performance in graphing of quadratic equations. Journal of Mathematics & Education, 1(4), 102–111.

Yerta, H. H. (2020). Teaching in the digital era. Holmes Printers.

Downloads

Published

2025-01-03