FROM SPREADSHEETS TO PROGRAMMING: A PRACTICAL LEARNING APPROACH
Authors
Aysel Fataliyeva
Share
Annotation
As digital literacy becomes increasingly essential, understanding programming concepts is crucial for students in various disciplines. However, many students perceive programming as complex and challenging. This paper explores an indirect teaching approach using spreadsheet applications to introduce programming concepts in higher education. By leveraging familiar spreadsheet tools, students can develop computational thinking, logical reasoning, and problem-solving skills without directly engaging with complex programming syntax. This approach lowers the barrier to programming education while making learning more engaging and applicable to real-world scenarios. The study specifically examines how this method can be effectively implemented in Azerbaijani universities to enhance students’ digital and analytical competencies.
Keywords
Authors
Aysel Fataliyeva
Share
References:
Kraus, S., Durst, S., Ferreira, J. J., Veiga, P., Kailer, N., & Weinmann, A. (2022). Digital transformation in business and management research: An overview of the current status quo. International journal of information management, 63, 102466.
Ghavifekr, S. & Rosdy, W.A.W. (2015). Teaching and learning with technology: Effectiveness of ICT integration in schools. International Journal of Research in Education and Science (IJRES), 1(2), 175-191.
Thelma, C. C., Sain, Z. H., Shogbesan, Y. O., Phiri, E. V., & Akpan, W. M. (2024). Digital Literacy in Education: Preparing Students for the Future Workforce. International Journal of Research (IJIR), 11(8), 327-344.
Medeiros, R. P., Ramalho, G. L., & Falcão, T. P. (2018). A systematic literature review on teaching and learning introductory programming in higher education. IEEE Transactions on Education, 62(2), 77-90.
Uysal, M. P. (2014). Improving first computer programming experiences: The case of adapting a web-supported and well-structured problem-solving method to a traditional course. Contemporary Educational Technology, 5(3), 198-217.
Luxton-Reilly, A., Simon, Albluwi, I., Becker, B. A., Giannakos, M., Kumar, A. N., ... & Szabo, C. (2018, July). Introductory programming: a systematic literature review. In Proceedings companion of the 23rd annual ACM conference on innovation and technology in computer science education (pp. 55-106).
Xinogalos, S. (2012). An evaluation of knowledge transfer from microworld programming to conventional programming. Journal of Educational Computing Research, 47(3), 251-277.
Toti, G., Lindner, P., Gao, A., Baghban Karimi, O., Engineer, R., Hur, J., ... & Wicentowski, R. (2025). Diversity, Equity, and Inclusion in Computing Science: Culture is the Key, Curriculum Contributes. In 2024 Working Group Reports on Innovation and Technology in Computer Science Education (pp. 175-225).
Sithole, A., Chiyaka, E. T., McCarthy, P., Mupinga, D. M., Bucklein, B. K., & Kibirige, J. (2017). Student attraction, persistence and retention in STEM programs: Successes and continuing challenges. Higher Education Studies, 7(1), 46-59.
Argent, R. M. (2004). An overview of model integration for environmental applications—components, frameworks and semantics. Environmental Modelling & Software, 19(3), 219-234.
Becker, B. A., Denny, P., Finnie-Ansley, J., Luxton-Reilly, A., Prather, J., & Santos, E. A. (2023, March). Programming is hard-or at least it used to be: Educational opportunities and challenges of ai code generation. In Proceedings of the 54th ACM Technical Symposium on Computer Science Education V. 1 (pp. 500-506).
Mulle, R. (2023). Spreadsheets Application in Teaching Data Management in Mathematics of the Modern World: Effects on Students’ Performance. Sprin Journal of Arts, Humanities and Social Sciences, 2(06), 11-18.
Suthar, K. J., Mehta, A., Panda, S. R., Panchal, H., & Sinha, R. (2024). Practical exercises of computer-aided process synthesis for chemical engineering undergraduates. Education for Chemical Engineers, 48, 31-43.
Kennedy, D. B., & Stratopoulos, T. C. (2024). How to Implement a Data Analytics and Emerging Technologies-Enabled Accounting Curriculum. Journal of Emerging Technologies in Accounting, 1-19.
Suthar, K. J., Mehta, A., Panda, S. R., Panchal, H., & Sinha, R. (2024). Practical exercises of computer-aided process synthesis for chemical engineering undergraduates. Education for Chemical Engineers, 48, 31-43.
Tedre, M., & Denning, P. J. (2016, November). The long quest for computational thinking. In Proceedings of the 16th Koli Calling international conference on computing education research (pp. 120-129).
Nardi, B. A., & Miller, J. R. (1991). Twinkling lights and nested loops: distributed problem solving and spreadsheet development. International Journal of Man-Machine Studies, 34(2), 161-184.
Lohani, S. K. (2023). Excel for Finance and Accounting: Learn how to optimize Excel formulas and functions for financial analysis (English Edition). BPB Publications.
Murray, A. (2022). Advanced Lookup Functions. In Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas (pp. 541-656). Berkeley, CA: Apress.
Evans, J. R. (2000). Spreadsheets as a tool for teaching simulation. Informs transactions on education, 1(1), 27-37.
Heimlich, S. (2019). Applying automatic program verification techniques to spreadsheets (Doctoral dissertation, Macquarie University).
Törley, G., Zsakó, L., & Bernát, P. (2022). Didactic Connection between Spreadsheet and Teaching Programming. Athens Journal of Technology & Engineering, 9(2), 77-94.
Csernoch, M., Biró, P., & Máth, J. (2021). Developing computational thinking skills with algorithm-driven spreadsheeting. IEEE Access, 9, 153943-153959.
Other articles of the issue
