Improving the Effectiveness of SQL Learning Practice: A Data-Driven Approach
Improving the Effectiveness of SQL Learning Practice: A Data-Driven Approach
复制标题
提高 SQL 学习实践的有效性：数据驱动的方法
DOI：
10.1109/compsac.2018.00174
复制
发表时间：
2018
期刊：
影响因子：
--
通讯作者：
Teodoro Montanaro
中科院分区：
文献类型：
--
作者：
Luca Cagliero;Luigi De Russis;L. Farinetti;Teodoro Montanaro
大多数工程课程包括学生在计算机实验室中进行的基本实践活动。在实验室课程中，学生在助教的帮助下解决练习，助教通常很难保证向每个人提供及时、优化和“民主”的支持。本文提供了一个学习环境，以改善实验课程参与者的体验，无论是学生还是助教。特别是，该环境是在数据库课程的环境中设计、实现和实验的。旨在支持学习环境的应用程序存储了在SQL实践实验室期间发生的所有事件，即任务进度、查询提交、错误反馈、帮助请求和干预，并且它提供了对即时使用和以后分析有用的信息。由于对这些数据的分析，该应用程序通过考虑不同的因素，如进步率、正确解决方案的百分比和解决当前练习的困难，动态地为教学助理提供图形界面，突出显示哪里最需要帮助。此外，存储的数据使教师能够在以后分析和解释学生在实验室中的行为，并对他们的主要错误和误解有深入的了解。在描述了环境、界面和确定需要及时帮助的学生团队的方法后，本文介绍了利用收集的数据进行不同分析的结果，以帮助教师更好地了解学生的教育需求。
Most engineering courses include fundamental practice activities to be performed by students in computer labs. During lab sessions, students work on solving exercises with the help of teaching assistants, who often have a hard time for guaranteeing a timely, optimized, and "democratic" support to everybody. This paper presents a learning environment to improve the experience of the lab sessions participants, both the students and the teaching assistants. In particular, the environment was designed, implemented, and experimented in the context of a database course. The application designed to support the learning environment stores all the events occurring during a SQL practice lab, i.e., task progression, query submissions, error feedback, assistance requests and interventions, and it provides information useful both for use on-the-fly and for later analysis. Thanks to the analysis of these data, the application dynamically provides teaching assistants with a graphical interface highlighting where assistance is most needed, by considering different factors such as the progression rate, the percentage of correct solutions, and the difficulties in solving the current exercise. Furthermore, the stored data allow teachers later on to analyze and to interpret the behavior of the students during the lab, and to have insights on their main mistakes and misconceptions. After describing the environment, the interfaces, and the approaches used to identify the students' teams that need timely assistance, the paper presents the results of different analyses performed using the collected data, to help the teacher better understand students' educational needs.