Echelon: An AI Tool for Clustering Student-Written SQL Queries

As part of teaching SQL, instructors often rely on auto-grading systems for marking students' assignments. However, such systems lack essential insights into the approaches students use to solve these assignments, allowing subtle flaws in student intuition to go unseen. Further, manual analysis...

Full description

Saved in:
Bibliographic Details
Main Authors: Weston, Matthew, Sun, Haorong, Herman, Geoffrey L, Benotman, Hisham, Alawini, Abdussalam
Format: Conference Proceeding
Language:English
Subjects:
Conferences
Education
Feature extraction
Manuals
Real-time systems
Visualization
Online Access:Request full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:As part of teaching SQL, instructors often rely on auto-grading systems for marking students' assignments. However, such systems lack essential insights into the approaches students use to solve these assignments, allowing subtle flaws in student intuition to go unseen. Further, manual analysis of students' code submissions ranges from costly to impossible, depending on the assessments' frequency. In this paper, we present a system capable of extracting features that instructors deem significant from students' SQL queries and using them to generate clusters that capture the key approaches taken. To supplement this, we project the extracted information to an interactive dashboard and demonstrate its usefulness in allowing database systems professors and teaching staff to quickly identify trends in students' solutions.
ISSN:2377-634X
DOI:10.1109/FIE49875.2021.9637203