ERIC Number: EJ1361333
Record Type: Journal
Publication Date: 2022
Pages: 22
Abstractor: As Provided
ISBN: N/A
ISSN: ISSN-1055-3096
EISSN: EISSN-2574-3872
Available Date: N/A
Teaching Tip: Using SQL to Create and Mine Large, Customizable Datasets
Siggard, Reagan; Dupin-Bryant, Pamela A.; Mills, Robert J.; Olsen, David H.
Journal of Information Systems Education, v33 n3 p209-228 Sum 2022
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.
Descriptors: Programming Languages, Databases, Coding, Tables (Data), Learning Activities, Constructivism (Learning), Teaching Models, Data Analysis, Statistics, Instructional Design
Journal of Information Systems Education. e-mail: editor@jise.org; Web site: http://www.jise.org
Publication Type: Journal Articles; Reports - Descriptive; Tests/Questionnaires
Education Level: N/A
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A
Author Affiliations: N/A