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.

Improving the effectiveness of SQL learning practice: a data-driven approach / Cagliero, Luca; DE RUSSIS, Luigi; Farinetti, Laura; Montanaro, Teodoro. - STAMPA. - 1:(2018), pp. 980-989. ((Intervento presentato al convegno 42nd IEEE Computer Society International Conference on Computers, Software & Applications (COMPSAC 2018), Symposium on Computer Education & Learning Technologies (CELT) tenutosi a Tokyo (Japan) nel July 23-27, 2018 [10.1109/COMPSAC.2018.00174].

Improving the effectiveness of SQL learning practice: a data-driven approach

Luca Cagliero;Luigi De Russis;Laura Farinetti;Teodoro Montanaro
2018

Abstract

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.
978-1-5386-2666-5
File in questo prodotto:
File Dimensione Formato  
PID5373909.pdf

accesso aperto

Descrizione: Articolo
Tipologia: 2. Post-print / Author's Accepted Manuscript
Licenza: PUBBLICO - Tutti i diritti riservati
Dimensione 582.38 kB
Formato Adobe PDF
582.38 kB Adobe PDF Visualizza/Apri
Pubblicazioni consigliate

Caricamento pubblicazioni consigliate

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11583/2709321
 Attenzione

Attenzione! I dati visualizzati non sono stati sottoposti a validazione da parte dell'ateneo