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

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...

Celý popis

Uloženo v:
Podrobná bibliografie
Vydáno v:Journal of information systems education Ročník 33; číslo 3; s. 209 - 228
Hlavní autoři: Siggard, Reagan, Dupin-Bryant, Pamela A, Mills, Robert J, Olsen, David H
Médium: Journal Article
Jazyk:angličtina
Vydáno: West Lafayette Journal of Information Systems Education 22.06.2022
EDSIG
Témata:
Anomalies
Business analytics
Coding
Constructivism (Learning)
Data Analysis
Datasets
Educational Needs
Feedback
Instructional Design
Learning
Learning Activities
Programming Languages
Queries
Query languages
Servers
Source code
Statistics
Structured Query Language-SQL
Students
Tables (Data)
Teaching
Teaching Methods
Teaching Models
Trends
ISSN:1055-3096, 2574-3872
On-line přístup:Získat plný text
Tagy: Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
Popis
Shrnutí: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.
Bibliografie:ObjectType-Article-1
SourceType-Scholarly Journals-1
ObjectType-Feature-2
content type line 14
ISSN:1055-3096
2574-3872