Chatbot-Based Learning Platform for SQL Training

  1. Antonio Balderas 1
  2. Rubén Baena-Pérez 1
  3. Tatiana Person 1
  4. José Miguel Mota 1
  5. Iván Ruiz-Rube 1
  1. 1 Universidad de Cádiz
    info

    Universidad de Cádiz

    Cádiz, España

    ROR https://ror.org/04mxxkb11

Journal:
IJIMAI

ISSN: 1989-1660

Year of publication: 2024

Volume: 8

Issue: 6

Pages: 135-145

Type: Article

DOI: 10.9781/IJIMAI.2022.05.003 DIALNET GOOGLE SCHOLAR lock_openOpen access editor

More publications in: IJIMAI

Abstract

Learning the SQL language for working with relational databases is a fundamental subject for future computer engineers. However, in distance learning contexts or unexpected situations like the COVID-19 pandemic, where students had to follow lectures remotely, they may find it hard to learn. Chatbots are software applications that aim to have conversations with people to help them solve problems or provide support in a specific domain. This paper proposes a chatbot-based learning platform to assist students in learning SQL. A case study has been conducted to evaluate the proposal, with undergraduate computer engineering students using the learning platform to perform SQL queries while being assisted by the chatbot. The results show evidence that students who used the chatbot performed better on the final SQL exam than those who did not. In addition, the research shows positive evidence of the benefits of using such learning platforms to support SQL teaching and learning for both students and lecturers: students use a platform that helps them self-regulate their learning process, while lecturers get interesting metrics on student performance.

Bibliographic References

  • J. Cárdenas-Cobo, A. Puris, P. Novoa-Hernández, Á. Parra-Jimnez, J. Moreno-Len, D. Benavides, “Using scratch to improve learning programming in college students: A positive experience from a nonweird country,” Electronics, vol. 10, no. 10, p. 1180, 2021.
  • F. J. García-Peñalvo, V. Abella-García, A. Corell, M. Grande, “La evaluacin online en la educacin superior en tiempos de la covid-19,” Education in the Knowledge Society, vol. 21, no. 12, 2020.
  • A. Balderas, J. A. Caballero-Hernández, “Analysis of Learning Records to Detect Student Cheating on Online Exams: Case Study during COVID-19 Pandemic,” in Proceedings of the Eighth International Conference on Technological Ecosystems for Enhancing Multiculturality (TEEM’20), 2020, ACM
  • S. Tamayo, D. Prez-Marín, “¿Qu esperan los docentes de los agentes conversacionales pedaggicos?,” Teoría de la Educación. Educación y Cultura en la Sociedad de la Información, vol. 18, no. 3, pp. 59–85, 2017.
  • G. D’Aniello, A. Gaeta, M. Gaeta, S. Tomasiello, “Self-regulated learning with approximate reasoning and situation awareness,” Journal of Ambient Intelligence and Humanized Computing, vol. 9, no. 1, pp. 151–164, 2018.
  • B. A. Shawar, E. Atwell, “Using dialogue corpora to train a chatbot,” in Proceedings of the Corpus Linguistics 2003 conference, 2003, pp. 681–690.
  • E. K. Morales-Urrutia, J. M. Ocaña, D. Prez-Marín, “How to integrate emotions in dialogues with pedagogic conversational agents to teach programming to children,” in Innovative Perspectives on Interactive Communication Systems and Technologies, IGI Global, 2020, pp. 66–91.
  • J. Yin, T.-T. Goh, B. Yang, Y. Xiaobin, “Conversation technology with micro-learning: the impact of chatbot-based learning on students’ learning motivation and performance,” Journal of Educational Computing Research, vol. 59, no. 1, pp. 154–177, 2021.
  • A. Beaulieu, Learning SQL: master SQL fundamentals. ” O’Reilly Media, Inc.”, 2009.
  • J. V. Murillo, S. B. Chavarría, S. M. Rivera, “Herramienta asistida por computadora para la enseñanza del álgebra relacional en bases de datos,” Uniciencia, vol. 26, no. 1-2, pp. 179–195, 2012.
  • F. Carrillo Chaves, “Informe asignaturas de bases de datos en estudios de grado en ingeniería informática en universidades españolas, 2018.” http://hdl.handle.net/10498/ 20657, 2018.
  • C. R. Jaimez-González, A. Palma-Hernández, “An interactive online training course for sql beginnersbeginners,” International Journal on Integrating Technology in Education (IJITE), vol. 6, no. 4, pp. 1–9, 2017.
  • A. Cumming, sqlcourse.com Interactive Online SQL Training, 2009 (accessed July 8, 2020).
  • R. Baggetun, B. Wasson, “Self-regulated learning and open writing,” European Journal of Education, vol. 41, no. 3-4, pp. 453–472, 2006.
  • P. Brusilovsky, S. Sosnovsky, M. V. Yudelson, D. H. Lee, V. Zadorozhny, X. Zhou, “Learning sql programming with interactive tools: From integration to personalization,” ACM Transactions on Computing Education (TOCE), vol. 9, no. 4, pp. 1–15, 2010.
  • H. Bansal, R. Khan, “A review paper on human computer interaction,” International Journal of Advanced Research in Computer Science and Software Engineering, vol. 8, no. 4, pp. 53–56, 2018.
  • G. Garcia Brustenga, M. Fuertes Alpiste, N. Molas Castells, Briefing paper: chatbots in education. Barcelona: eLearn Center. Universitat Oberta de Catalunya (UOC), 2018.
  • S.-W. Hsieh, “Effects of cognitive styles on an msn virtual learning companion system as an adjunct to classroom instructions,” Educational Technology & Society, vol. 14, no. 2, pp. 161–174, 2011.
  • J. Weizenbaum, “Eliza—a computer program for the study of natural language communication between man and machine,” Communications of the ACM, vol. 9, no. 1, p. 36–45, 1966.
  • P. B. Brandtzaeg, A. Følstad, “Why people use chatbots,” in Internet Science, Cham, 2017, pp. 377–392, Springer International Publishing.
  • V. Di Lecce, M. Calabrese, D. Soldo, A. Giove, “Semantic management systems for the material support of e-learning platforms,” Journal of e-Learning and Knowledge Society, vol. 6, no. 3, pp. 61–70, 2010.
  • Apple Computer, “Siri.” https://www.apple.com/siri, 2010. Last accessed 1 April 2022.
  • IBM, “Ibm watson.” https://www.ibm.com/cloud/ watson-assistant, 2011. Last accessed 1 April 2022.
  • Google, “Google assistant.” https://assistant.google.com/, 2016. Last accessed 1 April 2022.
  • X. Luo, S. Tong, Z. Fang, Z. Qu, “Frontiers: Machines vs. humans: The impact of artificial intelligence chatbot disclosure on customer purchases,” Marketing Science, vol. 38, no. 6, pp. 937–947, 2019.
  • A. De Angeli, G. I. Johnson, L. Coventry, “The unfriendly user: exploring social reactions to chatterbots,” in Proceedings of the international conference on affective human factors design, london, 2001, pp. 467–474, Citeseer.
  • Q. Zhi, R. Metoyer, “Gamebot: a visualization-augmented chatbot for sports game,” in Extended Abstracts of the 2020 CHI Conference on Human Factors in Computing Systems, 2020, pp. 1–7.
  • D. Calvaresi, J.-P. Calbimonte, E. Siboni, S. Eggenschwiler, G. Manzo, R. Hilfiker, M. Schumacher, “Erebots: privacy-compliant agent-based platform for multi-scenario personalized health-assistant chatbots,” Electronics, vol. 10, no. 6, p. 666, 2021.
  • W. Ham, N. Plainstow, “New deal for communities.“splodge” new deal for communities chatbot assistant,” 2005.
  • F. Colace, M. De Santo, M. Lombardi, F. Pascale, A. Pietrosanto, S. Lemma, “Chatbot for e-learning: A case of study,” International Journal of Mechanical Engineering and Robotics Research, vol. 7, no. 5, pp. 528–533, 2018.
  • R. Scheepers, M. Lacity, L. Willcocks, “Cognitive automation as part of deakin university’s digital strategy,” MIS Quarterly Executive, vol. 17, no. 2, pp. 89–107, 2018.
  • A. K. Goel, L. Polepeddi, “Jill watson: A virtual teaching assistant for online education,” in Learning Engineering for Online Educationn, C. Dede, J. Richards, B. Saxberg Eds., Routledge: Taylor & Francis, 2016, ch. 7, pp. 120–143.
  • P. Yeves-Martínez, D. Prez-Marín, “Prof. watson: A pedagogic conversational agent to teach programming in primary education,” in Multidisciplinary Digital Publishing Institute Proceedings, vol. 31, 2019, p. 84.
  • P. Munday, “The case for using duolingo as part of the language classroom experience,” RIED: revista iberoamericana de educación a distancia, vol. 19, no. 1, pp. 83–101, 2016.
  • S. Brown, The art of visualising software architecture: communicating software architecture with sketches, diagrams and the C4 model. Lean Publishing, 2016.
  • M. Stauffer, Laravel: Up & Running: A Framework for Building Modern PHP Apps. O’Reilly Media, 2019.
  • F. Bracci, A. Corradi, L. Foschini, “Database security management for healthcare saas in the amazon aws cloud,” in 2012 IEEE Symposium on Computers and Communications (ISCC), 2012, pp. 812–819, IEEE.
  • S. Tilkov, S. Vinoski, “Node. js: Using javascript to build high-performance network programs,” IEEE Internet Computing, vol. 14, no. 6, pp. 80–83, 2010.
  • C. Müller, M. Stahl, M. Alder, M. Müller, “Learning effectiveness and students’ perceptions in a flexible learning course,” European Journal of Open, Distance and E-learning, vol. 21, no. 2, pp. 44–52, 2018.
  • E. Kim, L. Rothrock, A. Freivalds, “The impact of gamification on the motivation and performance of engineering students through the lens of self-determination theory,” International Journal of Engineering Education, vol. 36, no. 3, pp. 1117–1131, 2020.
  • H. Afzal, I. Ali, M. Aslam Khan, K. Hamid, “A study of university students’ motivation and its relationship with their academic performance,” International Journal of Business and Management, vol. 5, no. 4, pp. 80–88, 2010.
  • X. Fu, A. Shimada, H. Ogata, Y. Taniguchi, D. Suehiro, “Real-time learning analytics for c programming language courses,” in Proceedings of the Seventh International Learning Analytics & Knowledge Conference, 2017, pp. 280–288.