A Study of Worked Examples for SQL Programming

Kamil Akhuseyinoglu; Ryan Hardt; Jordan Barria-Pineda; Peter Brusilovsky; Kerttu Pollari-Malmi; Teemu Sirkiä; Lauri Malmi

doi:10.1145/3502718.3524813

A Study of Worked Examples for SQL Programming

Kamil Akhuseyinoglu
, Ryan Hardt
, Jordan Barria-Pineda
, Peter Brusilovsky
, Kerttu Pollari-Malmi
, Teemu Sirkiä
, Lauri Malmi

Tutkimustuotos: Artikkeli kirjassa/konferenssijulkaisussa › Conference article in proceedings › Scientific › vertaisarvioitu

6 Sitaatiot (Scopus)

164 Lataukset (Pure)

Abstrakti

The paper focuses on a new type of interactive learning content for SQL programming - worked examples of SQL code. While worked examples are popular in learning programming, their application for learning SQL is limited. Using a novel tool for presenting interactive worked examples, Database Query Analyzer (DBQA), we performed a large-scale randomized controlled study assessing the value of worked examples as a new type of practice content in a database course. We report the results of the classroom study examining the usage and the impact of DBQA. Among other aspects, we explored the effect of textual step explanations provided by DBQA.

Alkuperäiskieli	Englanti
Otsikko	ITiCSE 2022 - Proceedings of the 27th ACM Conference on Innovation and Technology in Computer Science Education
Kustantaja	ACM
Sivut	82-88
Sivumäärä	7
ISBN (elektroninen)	978-1-4503-9201-3
DOI - pysyväislinkit	https://doi.org/10.1145/3502718.3524813
Tila	Julkaistu - 7 heinäk. 2022
OKM-julkaisutyyppi	A4 Artikkeli konferenssijulkaisussa
Tapahtuma	Annual Conference on Innovation and Technology in Computer Science Education - University College Dublin, Dublin, Irlanti Kesto: 8 heinäk. 2022 → 13 heinäk. 2022 Konferenssinumero: 27 https://iticse.acm.org/2022/

Conference

Conference	Annual Conference on Innovation and Technology in Computer Science Education
Lyhennettä	ITiCSE
Maa/Alue	Irlanti
Kaupunki	Dublin
Ajanjakso	08/07/2022 → 13/07/2022
www-osoite	https://iticse.acm.org/2022/

Rahoitus

This material is based upon work supported by the National Science Foundation under Grant No. 1740775.

Pääsy asiakirjaan

10.1145/3502718.3524813

A Study of Worked Examples for SQL ProgrammingAccepted author manuscript, 1,34 MB

Muut tiedostot ja linkit

Linkki julkaisuun Scopuksessa

Siteeraa tätä

@inproceedings{4a6c57f47b264b01bb92d85a5d3a3881,

title = "A Study of Worked Examples for SQL Programming",

abstract = "The paper focuses on a new type of interactive learning content for SQL programming - worked examples of SQL code. While worked examples are popular in learning programming, their application for learning SQL is limited. Using a novel tool for presenting interactive worked examples, Database Query Analyzer (DBQA), we performed a large-scale randomized controlled study assessing the value of worked examples as a new type of practice content in a database course. We report the results of the classroom study examining the usage and the impact of DBQA. Among other aspects, we explored the effect of textual step explanations provided by DBQA. ",

keywords = "classroom study, computer science education, olm, sql, textual explanations, worked examples",

author = "Kamil Akhuseyinoglu and Ryan Hardt and Jordan Barria-Pineda and Peter Brusilovsky and Kerttu Pollari-Malmi and Teemu Sirki{\"a} and Lauri Malmi",

note = "Funding Information: This material is based upon work supported by the National Science Foundation under Grant No. 1740775. Publisher Copyright: {\textcopyright} 2022 ACM.; Annual Conference on Innovation and Technology in Computer Science Education, ITiCSE ; Conference date: 08-07-2022 Through 13-07-2022",

year = "2022",

month = jul,

day = "7",

doi = "10.1145/3502718.3524813",

language = "English",

pages = "82--88",

booktitle = "ITiCSE 2022 - Proceedings of the 27th ACM Conference on Innovation and Technology in Computer Science Education",

publisher = "ACM",

address = "United States",

url = "https://iticse.acm.org/2022/",

}

Akhuseyinoglu, K, Hardt, R, Barria-Pineda, J, Brusilovsky, P, Pollari-Malmi, K , Sirkiä, T & Malmi, L 2022, A Study of Worked Examples for SQL Programming. julkaisussa ITiCSE 2022 - Proceedings of the 27th ACM Conference on Innovation and Technology in Computer Science Education. ACM, Sivut 82-88, Annual Conference on Innovation and Technology in Computer Science Education, Dublin, Irlanti, 08/07/2022. https://doi.org/10.1145/3502718.3524813

A Study of Worked Examples for SQL Programming. / Akhuseyinoglu, Kamil; Hardt, Ryan; Barria-Pineda, Jordan et al.
ITiCSE 2022 - Proceedings of the 27th ACM Conference on Innovation and Technology in Computer Science Education. ACM, 2022. s. 82-88.

Tutkimustuotos: Artikkeli kirjassa/konferenssijulkaisussa › Conference article in proceedings › Scientific › vertaisarvioitu

TY - GEN

T1 - A Study of Worked Examples for SQL Programming

AU - Akhuseyinoglu, Kamil

AU - Hardt, Ryan

AU - Barria-Pineda, Jordan

AU - Brusilovsky, Peter

AU - Pollari-Malmi, Kerttu

AU - Sirkiä, Teemu

AU - Malmi, Lauri

N1 - Conference code: 27

PY - 2022/7/7

Y1 - 2022/7/7

N2 - The paper focuses on a new type of interactive learning content for SQL programming - worked examples of SQL code. While worked examples are popular in learning programming, their application for learning SQL is limited. Using a novel tool for presenting interactive worked examples, Database Query Analyzer (DBQA), we performed a large-scale randomized controlled study assessing the value of worked examples as a new type of practice content in a database course. We report the results of the classroom study examining the usage and the impact of DBQA. Among other aspects, we explored the effect of textual step explanations provided by DBQA.

AB - The paper focuses on a new type of interactive learning content for SQL programming - worked examples of SQL code. While worked examples are popular in learning programming, their application for learning SQL is limited. Using a novel tool for presenting interactive worked examples, Database Query Analyzer (DBQA), we performed a large-scale randomized controlled study assessing the value of worked examples as a new type of practice content in a database course. We report the results of the classroom study examining the usage and the impact of DBQA. Among other aspects, we explored the effect of textual step explanations provided by DBQA.

KW - classroom study

KW - computer science education

KW - olm

KW - sql

KW - textual explanations

KW - worked examples

UR - https://www.scopus.com/pages/publications/85134434887

U2 - 10.1145/3502718.3524813

DO - 10.1145/3502718.3524813

M3 - Conference article in proceedings

AN - SCOPUS:85134434887

SP - 82

EP - 88

BT - ITiCSE 2022 - Proceedings of the 27th ACM Conference on Innovation and Technology in Computer Science Education

PB - ACM

T2 - Annual Conference on Innovation and Technology in Computer Science Education

Y2 - 8 July 2022 through 13 July 2022

ER -

A Study of Worked Examples for SQL Programming

Abstrakti

Conference

Rahoitus

Pääsy asiakirjaan

Muut tiedostot ja linkit

Sormenjälki

Siteeraa tätä