A Decision Tree Approach for the Classification of Mistakes of Students Learning SQL, a case study about SELECT statements
dc.contributor.author | Faeskorn-Woyke, Heide | |
dc.contributor.author | Bertelsmeier, Birgit | |
dc.contributor.author | Strohschein, Jan | |
dc.contributor.editor | Zender, Raphael | |
dc.contributor.editor | Ifenthaler, Dirk | |
dc.contributor.editor | Leonhardt, Thiemo | |
dc.contributor.editor | Schumacher, Clara | |
dc.date.accessioned | 2020-09-08T09:46:20Z | |
dc.date.available | 2020-09-08T09:46:20Z | |
dc.date.issued | 2020 | |
dc.description.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. | en |
dc.identifier.isbn | 978-3-88579-702-9 | |
dc.identifier.pissn | 1617-5468 | |
dc.identifier.uri | https://dl.gi.de/handle/20.500.12116/34162 | |
dc.language.iso | en | |
dc.publisher | Gesellschaft für Informatik e.V. | |
dc.relation.ispartof | DELFI 2020 – Die 18. Fachtagung Bildungstechnologien der Gesellschaft für Informatik e.V. | |
dc.relation.ispartofseries | Lecture Notes in Informatics (LNI) - Proceedings, Volume P-308 | |
dc.subject | Databases | |
dc.subject | SQL | |
dc.subject | web-based learning | |
dc.subject | e-learning | |
dc.subject | educational data mining | |
dc.subject | learning analytics | |
dc.subject | decision trees | |
dc.title | A Decision Tree Approach for the Classification of Mistakes of Students Learning SQL, a case study about SELECT statements | en |
dc.type | Text/Conference Paper | |
gi.citation.endPage | 216 | |
gi.citation.publisherPlace | Bonn | |
gi.citation.startPage | 211 | |
gi.conference.date | 14.-18. September 2020 | |
gi.conference.location | Online |
Dateien
Originalbündel
1 - 1 von 1
Lade...
- Name:
- 211 DELFI2020_paper_24.pdf
- Größe:
- 236.89 KB
- Format:
- Adobe Portable Document Format