Nelson, David, McGarry, Kenneth and Proud, Mark (2023) USING ORACLE QUERY PLAN FOR AUTOMATED ASSESSMENT OF SQL. In: 17th International Technology, Education and Development Conference, 6-8 March 2023, Valencia, Spain.
Document
-
Finalised copy of paper submitted to INTED 2023
1296 Final Paper V2.docx - Accepted Version
Available under License Creative Commons Attribution Non-commercial No Derivatives.
Abstract
Abstract
In our second-year undergraduate database foundations module students are exposed to using the Oracle cloud environment for developing SQL (Structured Query Language) queries. Their first summative assessment for the module is of a problem-solving nature, whereby they are expected to repair a partially developed SQL schema for a given scenario, before subsequently developing SQL queries based on the scenario. Marking this work can be laborious, error prone and time consuming, as well as requiring multiple sample solutions for each query which cater for all potential solutions that the students could produce. The aim of this paper is therefore to describe an early-stage prototype automated assessment system for marking the SQL queries developed by the students.
| Item Type: | Conference or Workshop Item (Paper) |
|---|---|
| Additional Information: | Extended abstract was accepted and referred. Document uploaded is final submitted version. |
| Uncontrolled Keywords: | SQL, automated marking, assessment |
| Related URLs: | |
| Depositing User: | David Nelson |
| URI: | https://sure.sunderland.ac.uk/id/eprint/15882 |
Further Details
More Information
Identifiers
Users with ORCIDS
Catalogue record
Contributors
University Divisions
Subjects
Actions (login required)
Download Statistics
Downloads per month over past year

