Partial Marking for Automated Grading of SQL Queries
Partial Marking for Automated Grading of SQL Queries
复制标题
SQL 查询自动分级的部分标记
DOI：
--
复制
发表时间：
2016
影响因子：
2.5
通讯作者：
S. Sudarshan
中科院分区：
文献类型：
--
作者：
B. Chandra;M. Joseph;Bharath Radhakrishnan;Shreevidhya Acharya;S. Sudarshan
XData系统目前正在孟买IIT开发，为学生的SQL查询评分以及学习SQL提供了一个自动化和交互式平台。以前在XData系统上的工作集中在生成查询特定的测试用例，以捕获查询中的常见错误。这些测试用例用于检查学生查询是否正确。对于学生作业的评分，仅仅检查查询是否正确通常是不够的：如果查询不正确，可能需要给出部分分数，这取决于查询与正确的接近程度。在本文中，我们扩展了XData系统，增加功能，使部分标记奖励不正确的学生查询。我们的系统是能够超越众多的句法功能比较学生查询时，一个正确的查询。我们的评分系统的这些功能允许SQL查询的评分完全自动化，并且可扩展到甚至像MOOC那样的大型班级。
The XData system, currently being developed at IIT Bombay, provides an automated and interactive platform for grading student SQL queries, as well as for learning SQL. Prior work on the XData system focused on generating query specific test cases to catch common errors in queries. These test cases are used to check whether the student queries are correct or not. For grading student assignments, it is usually not sufficient to just check if a query is correct: if the query is incorrect, partial marks may need to be given, depending on how close the query is to being correct. In this paper, we extend the XData system by adding features that enable awarding of partial marks to incorrect student queries. Our system is able to go beyond numerous syntactic features when comparing a student query with a correct query. These features of our grading system allow the grading of SQL queries to be fully automated, and scalable to even large class sizes such as those of MOOCs.