Article

The backwash effect on SQL skills grading

Authors:

Julia Coleman Prior,

Raymond ListerAuthors Info & Claims

ITiCSE '04: Proceedings of the 9th annual SIGCSE conference on Innovation and technology in computer science education

Pages 32 - 36

https://doi.org/10.1145/1007996.1008008

Published: 28 June 2004 Publication History

Get Access

Abstract

This paper examines the effect of grading approaches for SQL query formulation on students' learning strategies. The way that students are graded in a subject has a significant impact on their learning approach, and it is crucial that graded tasks are carefully designed and implemented to inculcate a deep learning experience. An online examination system is described and evaluated.

References

[1]

Biggs, J. Teaching for quality learning at University. Buckingham, Open University Press,1999.

Google Scholar

[2]

Culwin, F. Web hosted assessment - possibilities and policy. In proceedings of ITiCSE'98 Dublin, (Ireland, 1998) p55--58.

Digital Library

Google Scholar

[3]

Dietrich, S.W., Eckert, E. & Piscator, K. WinRDBI: a windows-based relational database educational tool. In proceedings of SIGCSE'97, (1997), p126--130.

Digital Library

Google Scholar

[4]

Grundy, F. Module description for COMP-207 : Databases, Department of Computer Science, Keele University, United Kingdom, 2001. Available online at: http://www.keele.ac.uk/depts/cs/modules/0102/level2/comp207.html {accessed 27/09/02}.

Google Scholar

[5]

Housego, S. and Freeman, M. Case studies: integrating the use of web-based learning systems into student learning. Australian Journal of Educational Technology, 16(3), (2000), p258--282.

Google Scholar

[6]

Joy, M. and Luck, M. Effective electronic marking for on-line assessment. In ITiCSE'98 (Dublin, 1998), p134--138.

Digital Library

Google Scholar

[7]

Maciaszek, L. Study guide for INFO603 Database Systems, School of Business and Informatics, Australian Catholic University, Sydney, Australia, 2001. Available online at: http://www.comp.mq.edu.au/ leszek/uni_courses/603_01StudyGuide.pdf {accessed 27/09/02}.

Google Scholar

[8]

Mehta, S.I. and Schlecht, N.W. Computerized assessment technique for large classes. Journal of Engineering Education, (April 1998), 167--172.

Crossref

Google Scholar

[9]

Mitrovic, A. Learning SQL with a computerized tutor. In proceedings of SIGCSE'98, (1998) p307--311.

Digital Library

Google Scholar

[10]

Paradis, F. and Barbour, R. Course outline for 0657.219B Database Practice and Experience. Department of Computer Science, University of Waikato, Hamilton, New Zealand, 2002. Available online at http://www.cs.waikato.ac.nz/Teaching/0657.219A/course_outline.html {accessed 27/09/02}.

Google Scholar

[11]

Ramsden, P. Learning to teach in higher education. London, Routledge, 1992.

Google Scholar

[12]

Schön, D. A. Educating the reflective practitioner: toward a new design for teaching and learning in the professions. San Francisco, Jossey-Bass, 1987.

Google Scholar

[13]

Toohey, S. Designing courses for Higher Education. Buckingham, Open University Press, 1999.

Google Scholar

[14]

Webster, M. Course outline for ZXX-4506 Introduction to Databases with Oracle and SQL, Dept of Information Services, University of Bangor, Wales, 2002. Available online at: http://www.bangor.ac.uk/is/teaching/postgrad/postgrad.shtml {accessed 27/09/02}.

Google Scholar

Cited By

View all

Wanjiru Bvan Bommel PHiemstra D(2024)Dynamic and Partial Grading of SQL QueriesJournal of Engineering Research and Sciences10.55708/js03080013:8(1-14)Online publication date: Aug-2024
https://doi.org/10.55708/js0308001
Wanjiru Bvan Bommel PHiemstra D(2024)Sensitivity of Automated SQL Grading in Computer Science CoursesProceedings of the Third International Conference on Innovations in Computing Research (ICR’24)10.1007/978-3-031-65522-7_26(283-299)Online publication date: 1-Aug-2024
https://doi.org/10.1007/978-3-031-65522-7_26
Mishra DInal Y(2023)What Affects the Success of Programmers in Query Validation Process? An Eye Tracking StudyHuman Interface and the Management of Information10.1007/978-3-031-35129-7_38(522-532)Online publication date: 9-Jul-2023
https://doi.org/10.1007/978-3-031-35129-7_38
Show More Cited By

Index Terms

The backwash effect on SQL skills grading
1. Information systems
  1. Data management systems
    1. Query languages

Recommendations

The backwash effect on SQL skills grading

This paper examines the effect of grading approaches for SQL query formulation on students' learning strategies. The way that students are graded in a subject has a significant impact on their learning approach, and it is crucial that graded tasks are ...
Online assessment of SQL query formulation skills
ACE '03: Proceedings of the fifth Australasian conference on Computing education - Volume 20

Being able to formulate useful SQL queries is a fundamental skill required by many software development professionals. Mastering this skill is a difficult process, requiring considerable practice and effort on the part of the student. In addition, ...
SQL: From Traditional Databases to Big Data
SIGCSE '16: Proceedings of the 47th ACM Technical Symposium on Computing Science Education

The Structured Query Language (SQL) is the main programing language designed to manage data stored in database systems. While SQL was initially used only with relational database management systems (RDBMS), its use has been significantly extended with ...

Comments

Information & Contributors

Information

Published In

ITiCSE '04: Proceedings of the 9th annual SIGCSE conference on Innovation and technology in computer science education

June 2004

296 pages

ISBN:1581138369

DOI:10.1145/1007996

Conference Chair:
Roger Boyle
University of Leeds, UK
,
Program Chairs:
Martyn Clark
University of Leeds, UK
,
Amruth Kumar
Ramapo College of NJ

ACM SIGCSE Bulletin Volume 36, Issue 3
September 2004
280 pages
ISSN:0097-8418
DOI:10.1145/1026487
Issue’s Table of Contents

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 28 June 2004

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Article

Conference

ITiCSE04

Sponsor:

ITiCSE04: Innovation and Technology in Computer Science Education

June 28 - 30, 2004

Leeds, United Kingdom

Acceptance Rates

Overall Acceptance Rate 552 of 1,613 submissions, 34%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

27
Total Citations
View Citations
709
Total Downloads

Downloads (Last 12 months)10
Downloads (Last 6 weeks)0

Reflects downloads up to 31 Dec 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Wanjiru Bvan Bommel PHiemstra D(2024)Dynamic and Partial Grading of SQL QueriesJournal of Engineering Research and Sciences10.55708/js03080013:8(1-14)Online publication date: Aug-2024
https://doi.org/10.55708/js0308001
Wanjiru Bvan Bommel PHiemstra D(2024)Sensitivity of Automated SQL Grading in Computer Science CoursesProceedings of the Third International Conference on Innovations in Computing Research (ICR’24)10.1007/978-3-031-65522-7_26(283-299)Online publication date: 1-Aug-2024
https://doi.org/10.1007/978-3-031-65522-7_26
Mishra DInal Y(2023)What Affects the Success of Programmers in Query Validation Process? An Eye Tracking StudyHuman Interface and the Management of Information10.1007/978-3-031-35129-7_38(522-532)Online publication date: 9-Jul-2023
https://doi.org/10.1007/978-3-031-35129-7_38
Nayak SAgarwal RKhatri S(2022)Review of Automated Assessment Tools for grading student SQL queries2022 International Conference on Computer Communication and Informatics (ICCCI)10.1109/ICCCI54379.2022.9740799(1-4)Online publication date: 25-Jan-2022
https://doi.org/10.1109/ICCCI54379.2022.9740799
Kulik ATrofymova IChukhray AStoliarenko TYevdokymov O(2022)Relevant Objectives of Developing SQL Adaptive Learning Technology2022 12th International Conference on Dependable Systems, Services and Technologies (DESSERT)10.1109/DESSERT58054.2022.10018757(1-7)Online publication date: 9-Dec-2022
https://doi.org/10.1109/DESSERT58054.2022.10018757
Tuparov GKeremedchiev D(2020)Assessing students’ SQL knowledge and skills in gamification manner2020 43rd International Convention on Information, Communication and Electronic Technology (MIPRO)10.23919/MIPRO48935.2020.9245179(1531-1536)Online publication date: 28-Sep-2020
https://doi.org/10.23919/MIPRO48935.2020.9245179
Ahadi APrior JBehbood VLister RClear ACuadros-Vargas ECarter JTupac Y(2016)Students' Semantic Mistakes in Writing Seven Different Types of SQL QueriesProceedings of the 2016 ACM Conference on Innovation and Technology in Computer Science Education10.1145/2899415.2899464(272-277)Online publication date: 11-Jul-2016
https://dl.acm.org/doi/10.1145/2899415.2899464
Ahadi ABehbood VVihavainen APrior JLister RAlphonce CTims JCaspersen MEdwards S(2016)Students' Syntactic Mistakes in Writing Seven Different Types of SQL Queries and its Application to Predicting Students' SuccessProceedings of the 47th ACM Technical Symposium on Computing Science Education10.1145/2839509.2844640(401-406)Online publication date: 17-Feb-2016
https://dl.acm.org/doi/10.1145/2839509.2844640
Siepermann M(2016)Database Engineering GameGames and Learning Alliance10.1007/978-3-319-50182-6_7(70-79)Online publication date: 23-Nov-2016
https://doi.org/10.1007/978-3-319-50182-6_7
Ahadi APrior JBehbood VLister RDagienė VSchulte CJevsikova T(2015)A Quantitative Study of the Relative Difficulty for Novices of Writing Seven Different Types of SQL QueriesProceedings of the 2015 ACM Conference on Innovation and Technology in Computer Science Education10.1145/2729094.2742620(201-206)Online publication date: 22-Jun-2015
https://dl.acm.org/doi/10.1145/2729094.2742620
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

The backwash effect on SQL skills grading

Online assessment of SQL query formulation skills

SQL: From Traditional Databases to Big Data