Chatbot-Based Learning Platform for SQL Training

• Antonio Balderas ^[1] ; Rubén Baena-Pérez ^[1] ; Tatiana Person ^[1] ; José Miguel Mota ^[1] ; Iván Ruiz-Rube ^[1]
  1. [1] Universidad de Cádiz

     Universidad de Cádiz

     Cádiz, España

     
• Localización: IJIMAI, ISSN-e 1989-1660, Vol. 8, Nº. 6, 2024, págs. 135-145
• Idioma: inglés
• DOI: 10.9781/ijimai.2022.05.003
• Enlaces
  • Texto completo
• Resumen

  • 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.

• Referencias bibliográficas
  • J. Cárdenas-Cobo, A. Puris, P. Novoa-Hernández, Á. Parra-Jimnez, J. Moreno-Len, D. Benavides, “Using scratch to improve learning programming...
  • 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...
  • A. Balderas, J. A. Caballero-Hernández, “Analysis of Learning Records to Detect Student Cheating on Online Exams: Case Study during COVID-19...
  • 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...
  • G. D’Aniello, A. Gaeta, M. Gaeta, S. Tomasiello, “Self-regulated learning with approximate reasoning and situation awareness,” Journal of...
  • B. A. Shawar, E. Atwell, “Using dialogue corpora to train a chatbot,” in Proceedings of the Corpus Linguistics 2003 conference, 2003, pp....
  • 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...
  • J. Yin, T.-T. Goh, B. Yang, Y. Xiaobin, “Conversation technology with micro-learning: the impact of chatbot-based learning on students’ learning...
  • 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,...
  • F. Carrillo Chaves, “Informe asignaturas de bases de datos en estudios de grado en ingeniería informática en universidades españolas, 2018.”...
  • C. R. Jaimez-González, A. Palma-Hernández, “An interactive online training course for sql beginnersbeginners,” International Journal on Integrating...
  • 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...
  • H. Bansal, R. Khan, “A review paper on human computer interaction,” International Journal of Advanced Research in Computer Science and Software...
  • G. Garcia Brustenga, M. Fuertes Alpiste, N. Molas Castells, Briefing paper: chatbots in education. Barcelona: eLearn Center. Universitat Oberta...
  • S.-W. Hsieh, “Effects of cognitive styles on an msn virtual learning companion system as an adjunct to classroom instructions,” Educational Technology...
  • J. Weizenbaum, “Eliza—a computer program for the study of natural language communication between man and machine,” Communications of the ACM,...
  • 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...
  • 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,”...
  • A. De Angeli, G. I. Johnson, L. Coventry, “The unfriendly user: exploring social reactions to chatterbots,” in Proceedings of the international...
  • Q. Zhi, R. Metoyer, “Gamebot: a visualization-augmented chatbot for sports game,” in Extended Abstracts of the 2020 CHI Conference on Human Factors...
  • D. Calvaresi, J.-P. Calbimonte, E. Siboni, S. Eggenschwiler, G. Manzo, R. Hilfiker, M. Schumacher, “Erebots: privacy-compliant agent-based platform...
  • 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...
  • R. Scheepers, M. Lacity, L. Willcocks, “Cognitive automation as part of deakin university’s digital strategy,” MIS Quarterly Executive, vol....
  • A. K. Goel, L. Polepeddi, “Jill watson: A virtual teaching assistant for online education,” in Learning Engineering for Online Educationn,...
  • P. Yeves-Martínez, D. Prez-Marín, “Prof. watson: A pedagogic conversational agent to teach programming in primary education,” in Multidisciplinary...
  • P. Munday, “The case for using duolingo as part of the language classroom experience,” RIED: revista iberoamericana de educación a distancia,...
  • S. Brown, The art of visualising software architecture: communicating software architecture with sketches, diagrams and the C4 model. Lean Publishing,...
  • 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...
  • S. Tilkov, S. Vinoski, “Node. js: Using javascript to build high-performance network programs,” IEEE Internet Computing, vol. 14, no. 6, pp....
  • C. Müller, M. Stahl, M. Alder, M. Müller, “Learning effectiveness and students’ perceptions in a flexible learning course,” European Journal...
  • E. Kim, L. Rothrock, A. Freivalds, “The impact of gamification on the motivation and performance of engineering students through the lens of...
  • H. Afzal, I. Ali, M. Aslam Khan, K. Hamid, “A study of university students’ motivation and its relationship with their academic performance,” International...
  • X. Fu, A. Shimada, H. Ogata, Y. Taniguchi, D. Suehiro, “Real-time learning analytics for c programming language courses,” in Proceedings of...