Crowdsourcing Content Creation for SQL Practice
By Juho Leinonen, Nea Pirttinen, Arto Hellas. 2020
20 citations recorded by the source corpus.
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.
Subfields: Computer Science Applications, Information Systems, Evaluation & Benchmarks, Human-Computer Interaction
How researchers see this paper
The researchers whose trusted networks rank it highest, strongest advocate first. Every researcher gets a different order.
In Computer Science Applications
- Juho Leinonen
- Paul Denny
- Sami Sarsa
- Arto Hellas
- Stephen MacNeil
- Seth Bernstein
- Andrew Tran
- Joanne Kim
In Information Systems
- Juho Leinonen
- Paul Denny
- Sami Sarsa
- Arto Hellas
- Stephen MacNeil
- Seth Bernstein
- Andrew Tran
- Joanne Kim
In Evaluation & Benchmarks
In Human-Computer Interaction
- Sami Sarsa
- Juho Leinonen
- Arto Hellas
- Paul Denny
- Seth Bernstein
- Andrew Tran
- Stephen MacNeil
- Joanne Kim
Citations in the corpus
- Comparing Code Explanations Created by Students and Large Language Models (2023, background): “While learn-ersourcing techniques could be used to generate code explanations efficiently by directly involving students in their creation [21, 32], there are known issues relating to quality when learning content is sourced from students [1, 9].”
- Can Students Review Their Peers?: Comparison of Peer and Instructor Reviews (2022, background): “In computer science education, learnersourcing appears in many forms, such as student-created multiple-choice questions [1, 13], programming exercises [3, 21], SQL exercises [17], and open-ended questions [18, 26].”
- Experiences from Using Code Explanations Generated by Large Language Models in a Web Software Development E-Book (2022, methodology): “Learnersourcing has been used successfully in computing education to create multiple choice questions [8], programming exercises [9, 33], and SQL exercises [21].”