A Decision Tree Approach for the Classification of Mistakes of Students Learning SQL, a case study about SELECT statements
Abstract
TH Köln provides a web-based e-learning platform edb4, where novices can do their first steps in SQL. The goal of this paper is to build a decision tree (manually) that classifies the novice's errors. To do so we logged data containing tasks, solutions, and wrong statements over seven months and got a table with 7533 rows as a training set. Each leaf node of the decision tree is a class of errors of similar type and generates an error message with feedback to help the user to solve the task. Interesting and surprising are the mistakes that SQL novices make. The result improves the first steps of learning SQL in a simple and personalized way and gives the teachers hints to improve their learning outputs.
- Citation
- BibTeX
Faeskorn-Woyke, H., Bertelsmeier, B. & Strohschein, J.,
(2020).
A Decision Tree Approach for the Classification of Mistakes of Students Learning SQL, a case study about SELECT statements.
In:
Zender, R., Ifenthaler, D., Leonhardt, T. & Schumacher, C.
(Hrsg.),
DELFI 2020 – Die 18. Fachtagung Bildungstechnologien der Gesellschaft für Informatik e.V..
Bonn:
Gesellschaft für Informatik e.V..
(S. 211-216).
@inproceedings{mci/Faeskorn-Woyke2020,
author = {Faeskorn-Woyke, Heide AND Bertelsmeier, Birgit AND Strohschein, Jan},
title = {A Decision Tree Approach for the Classification of Mistakes of Students Learning SQL, a case study about SELECT statements},
booktitle = {DELFI 2020 – Die 18. Fachtagung Bildungstechnologien der Gesellschaft für Informatik e.V.},
year = {2020},
editor = {Zender, Raphael AND Ifenthaler, Dirk AND Leonhardt, Thiemo AND Schumacher, Clara} ,
pages = { 211-216 },
publisher = {Gesellschaft für Informatik e.V.},
address = {Bonn}
}
author = {Faeskorn-Woyke, Heide AND Bertelsmeier, Birgit AND Strohschein, Jan},
title = {A Decision Tree Approach for the Classification of Mistakes of Students Learning SQL, a case study about SELECT statements},
booktitle = {DELFI 2020 – Die 18. Fachtagung Bildungstechnologien der Gesellschaft für Informatik e.V.},
year = {2020},
editor = {Zender, Raphael AND Ifenthaler, Dirk AND Leonhardt, Thiemo AND Schumacher, Clara} ,
pages = { 211-216 },
publisher = {Gesellschaft für Informatik e.V.},
address = {Bonn}
}
Dateien | Groesse | Format | Anzeige | |
---|---|---|---|---|
211 DELFI2020_paper_24.pdf | 236.8Kb | View/ |
Haben Sie fehlerhafte Angaben entdeckt? Sagen Sie uns Bescheid: Send Feedback
More Info
ISBN: 978-3-88579-702-9
ISSN: 1617-5468
xmlui.MetaDataDisplay.field.date: 2020
Language:
(en)

Content Type: Text/Conference Paper