Teaching Tip: Using SQL to Create and Mine Large, Customizable Datasets

Autor/inn/en	Siggard, Reagan; Dupin-Bryant, Pamela A.; Mills, Robert J.; Olsen, David H.
Titel	Teaching Tip: Using SQL to Create and Mine Large, Customizable Datasets
Quelle	In: Journal of Information Systems Education, 33 (2022) 3, S.209-228 (22 Seiten) PDF als Volltext Verfügbarkeit
Sprache	englisch
Dokumenttyp	gedruckt; online; Zeitschriftenaufsatz
ISSN	1055-3096
Schlagwörter	Programming Languages; Databases; Coding; Tables (Data); Learning Activities; Constructivism (Learning); Teaching Models; Data Analysis; Statistics; Instructional Design + Suchen Sie Ihr Suchwort? Datenbank; Codierung; Programmierung; Tabelle; Lernaktivität; Lehrmodell; Auswertung; Statistik; Lesson concept; Lessonplan; Unterrichtsentwurf
Abstract	The SQL-Explore Learning Module detailed in this teaching tip provides an opportunity for students to apply database course knowledge beyond solving traditional pre-determined Structured Query Language (SQL) coding questions. In this unique constructivist activity using the apropos 5E Instructional Model, students explore tables to locate data anomalies, trends, and other key findings in a 100,000-invoice dataset. Detailed instructions and the source code needed to facilitate this innovative learning experience are included. Based on student feedback, 100% of study participants strongly agree or somewhat agree that exploring datasets through the SQL-Explore Activity enhances their knowledge of SQL. (As Provided).
Anmerkungen	Journal of Information Systems Education. e-mail: editor@jise.org; Web site: http://www.jise.org
Erfasst von	ERIC (Education Resources Information Center), Washington, DC
Update	2024/1/01