Web application to support SQL language learning
External reference persons Lorenzo Canale
Research Groups GR-10 - Intelligent and Interactive Systems - e-LITE
Thesis type EXPERIMENTAL, RESEARCH
Description The thesis aims at designing, implementing and evaluating a web application to support SQL language learning, targeted to students.
In particular, the web application should propose SQL exercises to students with progressive difficulty level, should interface a DBMS to send the proposed queries, and should get the DBMS response to translate it in a more significant feedback for the user that goes beyond the eventual error message by trying to understand the educational implications of the error. The management of the feedback and the overall interaction with the students could also be thought in a "conversational" manner, for instance by exploiting the natural language interpretation.
Besides, the application should record in a data base all the users’ actions, and from these data it should create a user dashboard to visualize the most important information (e.g., number of correctly solved exercises, number of attempts, average time to solve an exercise, most frequent errors, reached competence level, …) to increase user’s awareness of their learning progress. Administrators (i.e., teachers) could also vision such a dashboard.
The evaluation will involve the experimentation of the web application with some students, to evaluate the efficacy and utility of the adopted approach.
Required skills Sono richieste conoscenze di sviluppo di applicazioni web (lato front-end e back-end) e di SQL, nonché un impegno (quasi) full time.
Deadline 11/04/2019 PROPONI LA TUA CANDIDATURA