Crowdsourcing Content Creation for SQL Practice

Juho Leinonen; Nea Pirttinen; Arto Hellas

doi:10.1145/3341525.3387385

Crowdsourcing Content Creation for SQL Practice

Juho Leinonen, Nea Pirttinen, Arto Hellas

University of Helsinki

Research output: Chapter in Book/Report/Conference proceeding › Conference article in proceedings › Scientific › peer-review

17 Citations (Scopus)

153 Downloads (Pure)

Abstract

Crowdsourcing refers to the act of using the crowd to create content or to collect feedback on some particular tasks or ideas. Within computer science education, crowdsourcing has been used - for example - to create rehearsal questions and programming assignments. As a part of their computer science education, students often learn relational databases as well as working with the databases using SQL statements. In this article, we describe a system for practicing SQL statements. The system uses teacher-provided topics and assignments, augmented with crowdsourced assignments and reviews. We study how students use the system, what sort of feedback students provide to the teacher-generated and crowdsourced assignments, and how practice affects the feedback. Our results suggest that students rate assignments highly, and there are only minor differences between assignments generated by students and assignments generated by the instructor.

Original language	English
Title of host publication	ITiCSE 2020 - Proceedings of the 2020 ACM Conference on Innovation and Technology in Computer Science Education
Publisher	ACM
Pages	349-355
Number of pages	7
ISBN (Electronic)	9781450368742
DOIs	https://doi.org/10.1145/3341525.3387385
Publication status	Published - 15 Jun 2020
MoE publication type	A4 Conference publication
Event	Annual Conference on Innovation and Technology in Computer Science Education - Trondheim, Norway Duration: 15 Jun 2020 → 19 Jun 2020 Conference number: 25

Publication series

Name	Annual Conference on Innovation and Technology in Computer Science Education
ISSN (Print)	1942-647X

Conference

Conference	Annual Conference on Innovation and Technology in Computer Science Education
Abbreviated title	ITiCSE
Country/Territory	Norway
City	Trondheim
Period	15/06/2020 → 19/06/2020

Keywords

assignment creation
assignment quality
crowdsourcing
introduction to databases
SQL
student-generated content
teacher-generated content

Access to Document

10.1145/3341525.3387385

SCI_Leinonen_Crowdsourcing.ITiCSE_2020_SQL_trainerAccepted author manuscript, 439 KB

Cite this

@inproceedings{74669cf5028840fb98794bdecddc9063,

title = "Crowdsourcing Content Creation for SQL Practice",

abstract = "Crowdsourcing refers to the act of using the crowd to create content or to collect feedback on some particular tasks or ideas. Within computer science education, crowdsourcing has been used - for example - to create rehearsal questions and programming assignments. As a part of their computer science education, students often learn relational databases as well as working with the databases using SQL statements. In this article, we describe a system for practicing SQL statements. The system uses teacher-provided topics and assignments, augmented with crowdsourced assignments and reviews. We study how students use the system, what sort of feedback students provide to the teacher-generated and crowdsourced assignments, and how practice affects the feedback. Our results suggest that students rate assignments highly, and there are only minor differences between assignments generated by students and assignments generated by the instructor.",

keywords = "assignment creation, assignment quality, crowdsourcing, introduction to databases, SQL, student-generated content, teacher-generated content",

author = "Juho Leinonen and Nea Pirttinen and Arto Hellas",

year = "2020",

month = jun,

day = "15",

doi = "10.1145/3341525.3387385",

language = "English",

series = "Annual Conference on Innovation and Technology in Computer Science Education",

publisher = "ACM",

pages = "349--355",

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

address = "United States",

note = "Annual Conference on Innovation and Technology in Computer Science Education, ITiCSE ; Conference date: 15-06-2020 Through 19-06-2020",

}

Leinonen, J, Pirttinen, N & Hellas, A 2020, Crowdsourcing Content Creation for SQL Practice. in ITiCSE 2020 - Proceedings of the 2020 ACM Conference on Innovation and Technology in Computer Science Education. Annual Conference on Innovation and Technology in Computer Science Education, ACM, pp. 349-355, Annual Conference on Innovation and Technology in Computer Science Education, Trondheim, Norway, 15/06/2020. https://doi.org/10.1145/3341525.3387385

Crowdsourcing Content Creation for SQL Practice. / Leinonen, Juho; Pirttinen, Nea; Hellas, Arto.
ITiCSE 2020 - Proceedings of the 2020 ACM Conference on Innovation and Technology in Computer Science Education. ACM, 2020. p. 349-355 (Annual Conference on Innovation and Technology in Computer Science Education).

Research output: Chapter in Book/Report/Conference proceeding › Conference article in proceedings › Scientific › peer-review

TY - GEN

T1 - Crowdsourcing Content Creation for SQL Practice

AU - Leinonen, Juho

AU - Pirttinen, Nea

AU - Hellas, Arto

N1 - Conference code: 25

PY - 2020/6/15

Y1 - 2020/6/15

N2 - Crowdsourcing refers to the act of using the crowd to create content or to collect feedback on some particular tasks or ideas. Within computer science education, crowdsourcing has been used - for example - to create rehearsal questions and programming assignments. As a part of their computer science education, students often learn relational databases as well as working with the databases using SQL statements. In this article, we describe a system for practicing SQL statements. The system uses teacher-provided topics and assignments, augmented with crowdsourced assignments and reviews. We study how students use the system, what sort of feedback students provide to the teacher-generated and crowdsourced assignments, and how practice affects the feedback. Our results suggest that students rate assignments highly, and there are only minor differences between assignments generated by students and assignments generated by the instructor.

AB - Crowdsourcing refers to the act of using the crowd to create content or to collect feedback on some particular tasks or ideas. Within computer science education, crowdsourcing has been used - for example - to create rehearsal questions and programming assignments. As a part of their computer science education, students often learn relational databases as well as working with the databases using SQL statements. In this article, we describe a system for practicing SQL statements. The system uses teacher-provided topics and assignments, augmented with crowdsourced assignments and reviews. We study how students use the system, what sort of feedback students provide to the teacher-generated and crowdsourced assignments, and how practice affects the feedback. Our results suggest that students rate assignments highly, and there are only minor differences between assignments generated by students and assignments generated by the instructor.

KW - assignment creation

KW - assignment quality

KW - crowdsourcing

KW - introduction to databases

KW - SQL

KW - student-generated content

KW - teacher-generated content

UR - http://www.scopus.com/inward/record.url?scp=85086464574&partnerID=8YFLogxK

U2 - 10.1145/3341525.3387385

DO - 10.1145/3341525.3387385

M3 - Conference article in proceedings

AN - SCOPUS:85086464574

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

SP - 349

EP - 355

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

PB - ACM

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

Y2 - 15 June 2020 through 19 June 2020

ER -

Crowdsourcing Content Creation for SQL Practice

Abstract

Publication series

Conference

Keywords

Access to Document

Other files and links

Fingerprint

Cite this