Coverage of Course Topics in Learnersourced SQL Exercises

TL;DR

This paper investigates how effectively learnersourced SQL exercises cover course topics, demonstrating that learnersourcing can generate a comprehensive pool of exercises for full course content practice.

Contribution

It provides an analysis of learnersourced SQL exercises coverage, highlighting its potential to encompass most course topics for effective student practice.

Findings

Learnersourcing can produce a large, diverse set of SQL exercises.

Most course topics are well covered by learnersourced exercises.

Learnersourcing supports comprehensive practice of course content.

Abstract

Learnersourcing is a common task in modern computing classrooms, where it is used, for example, for the creation of educational resources such as multiple-choice questions and programming exercises. One less studied type of learnersourced artefact is SQL exercises. In this work, we explore how well different SQL topics are covered by learnersourced SQL exercises. Covering most course topics would allow students to practice the full content of the course by completing learnersourced exercises. Our results suggest that learnersourcing can be used to create a large pool of SQL exercises that cover most of the topics of the course.