PROJECT-BASED TRAINING IN STATISTICS USING MS EXCEL IN SECONDARY EDUCATION

Assoc. Prof. Desislava Georgieva, PhD

Department of Mathematics Faculty of Mathematics and Informatics St. Cyril and St. Methodius University of Veliko Tarnovo, Bulgaria

E-mail: d.georgieva@ts.uni-vt.bg

Abstract

A study of mathematics education of 12th grade students of a secondary general education school was conducted on the topic of Statistics. The problems in studying this section were outlined. A review of the scientific literature abroad and in our country was conducted. A model for project-based learning using MS Excel was proposed and tested. Mathematical and digital competence were integrated skilfully. The conducted survey reported increased motivation of the students.

Keywords

Statistics training, secondary education, general education, project-based learning, MS Excel

REFERENCES

American Statistical Association (2005). Guidelines for Assessment and Instruction in Statistics Education in Statistics Education (GAISE): College Report 2005.
Alismail, H., & McGuire, P. (2015). 21st Century Standards and Curriculum: Current Research and Practice. Journal of Education and Practice, 6(6), 150-154.
Arkadiev, D. (2015). Between tradition, modernity and practice: some views on teaching statistics to economists. Statistics. 2, 71-94. Sofia: National Statistical Institute. (Оригинално заглавие: Аркадиев, Д. (2015). Между традицията, модерността и практиката: някои виждания за преподаване на статистика на и кономисти. Статистика. 2, 71-94. София: Национален статистически институт.)
URL: https://www.nsi.bg/en/file/16552/sp_STATISTIKA_2_2015.pdf
Basturk, R. (2005). The Effectiveness of Computer-Assisted Instruction in Teaching Introductory Statistics. Educational Technology & Society, 8(2), 170-178.
Borkulo, S., Chytas, C., Drijvers, P. et al. (2023). Spreadsheets in Secondary School Statistics Education: Using Authentic Data for Computational Thinking. Digital Experiences in Mathematics Education 9, 420-443. https://doi.org/10.1007/s40751-023-00126-5
Burckhardt, P., Nugent, R., & Genovese, C. (2021). Teaching Statistical Concepts and Modern Data Analysis with a Computing-Integrated Learning Environment. Journal of Statistics and Data Science Education, 29(sup1), S61-S73.
GAISE College Report ASA Revision Committee. (2016). Guidelines for Assessment and Instruction in Statistics Education College Report 2016.
Harits, M., Sujadi, I., & Slamet, I. (2019). Technological, pedagogical, and content knowledge math teachers: to develop 21st century skills students. Journal of Physics: Conference Series, 2-7. doi:10.1088/1742-6596/1321/3/032011.
Karakoleva, S., Dimitrova, D. (2021). Use of cloud technologies for training and test control on the topic "Statistics and data processing" in tenth grade. Proceedings of University of Ruse. 60 (6.4) 79-84. ISSN 2603-4123 (on-line).
Karakoleva, S., Koleva, M. (2024). Application of cloud technologies in education on the 113-121. ISSN 2603-4123 (on-line).
Kazika, G., Malambo, P. (2025). Effectiveness of Excel-Assisted Instruction in Teaching Statistics for Learners' Acquisition of 21st Century Skills. Journal of research, innovation and implications in education, 9(1), 254-264 ISSN 2520-7504 (Online).
Legacy, C. Le, L., Zieffler, A., Fry, E., Vivas Corrales, P. (2024). The Teaching of Introductory Statistics: Results of a National Survey. Journal of Statistics and Data Science Education. 32:3, 232-240, DOI: 10.1080/26939169.2024.2333732
Moore, D. (1997), New Pedagogy and New Content: The Case of Statistics. International Statistical Review, 65, 123-137.
Sugareva, M. & Murgova, M. (2021). On the need to increase statistical literacy and culture. Statistics. 2, 41-54. Sofia: National Statistical Institute. (Оригинално заглавие: Сугарева, М., Мургова, М. (2021). За нуждата от повишаване на статистическата грамотност и култура. Статистика. 2, 41-54. София: Национален статистически институт.)
Sugareva, M., Borisova-Marinova, K., Moraliyska-Nikolova, S. (2025). Statistics at school. To help mathematics teachers. Varna: Slavena. 120 p. (Оригинално заглавие: Сугарева, М., Борисова-Маринова, К., Моралийска-Николова, С. (2025). Статистика в училище. В помощ на учителите по математика. Варна: Славена.120 с. ISBN 9786191902705.)
Tintle, N., Chance, B., Cobb, G., Rossman, A., Roy, S., Swanson, T., VanderStoep, J. (2016). Introduction to Statistical Investigations. John Wiley & Sons: Hoboken, NJ, USA, ISBN 1119683459.
Zapryanov Z., Marinkova M. (2008). Collection of problems and tests in combinatorics, probability and statistics. Sofia: Trud, 356 p. (Оригинално заглавие: Запрянов З., Маринкова М. (2008). Сборник от задачи и тестове по комбинаторика, вероятности и статистика. София: Труд, 356 с. ISBN 9789545288159.)
Zapryanov Z., Marinov M. (2018). Fun Mathematics for 10th, 11th and 12th Grades. Practical Course in Probability Theory, Combinatorics and Statistics. Sofia: Scorpio, 240 p. (Оригинално заглавие: Запрянов З., Маринов М. (2018). Забавна математика за 10., 11. и 12. клас. Практикум по теория на вероятностите, комбинаторика и статистика. София: Скорпио, 240 с. ISBN 9789547928046.)