GI LogoGI Logo
  • Login
Digital Library
    • All of DSpace

      • Communities & Collections
      • Titles
      • Authors
      • By Issue Date
      • Subjects
    • This Collection

      • Titles
      • Authors
      • By Issue Date
      • Subjects
Digital Library Gesellschaft für Informatik e.V.
GI-DL
    • English
    • Deutsch
  • English 
    • English
    • Deutsch
View Item 
  •   DSpace Home
  • Lecture Notes in Informatics
  • Proceedings
  • DeLFI - e-Learning Fachtagung Informatik
  • P308 - DeLFI 2020 - Die 18. Fachtagung Bildungstechnologien
  • View Item
JavaScript is disabled for your browser. Some features of this site may not work without it.
  •   DSpace Home
  • Lecture Notes in Informatics
  • Proceedings
  • DeLFI - e-Learning Fachtagung Informatik
  • P308 - DeLFI 2020 - Die 18. Fachtagung Bildungstechnologien
  • View Item

A Decision Tree Approach for the Classification of Mistakes of Students Learning SQL, a case study about SELECT statements

Author:
Faeskorn-Woyke, Heide [DBLP] ;
Bertelsmeier, Birgit [DBLP] ;
Strohschein, Jan [DBLP]
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}
}
DateienGroesseFormatAnzeige
211 DELFI2020_paper_24.pdf236.8Kb PDF View/Open

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 (en)
Content Type: Text/Conference Paper

Keywords

  • Databases
  • SQL
  • web-based learning
  • e-learning
  • educational data mining
  • learning analytics
  • decision trees
Collections
  • DeLFI 2020 [64]
  • P308 - DeLFI 2020 - Die 18. Fachtagung Bildungstechnologien [64]

Show full item record


About uns | FAQ | Help | Imprint | Datenschutz

Gesellschaft für Informatik e.V. (GI), Kontakt: Geschäftsstelle der GI
Diese Digital Library basiert auf DSpace.

 

 


About uns | FAQ | Help | Imprint | Datenschutz

Gesellschaft für Informatik e.V. (GI), Kontakt: Geschäftsstelle der GI
Diese Digital Library basiert auf DSpace.