 A mental model approach to teaching database querying skills with SQL and AlteryxLorraine Lee and Gretchen Casterella Journal of Accounting Education, 2023, vol. 64, issue C Abstract: This paper describes an instructional approach and exercises to introduce a data analytics tool into an existing course that covers relational databases and structured query language (SQL). SQL and relational databases are traditional topics in many AIS classes and are frequently taught with established technologies such as Microsoft Access. With the onset of newer data analytics tools, educators are faced with the challenge of incorporating emerging technologies while still covering basic foundational concepts. In this paper, we position SQL as the mental model for learning the data preparation and data blending features of a popular analytics tool, Alteryx. We split the traditional SQL content from our course into four increments that increase in complexity. For each increment, we use a multi-step approach to first develop students’ mental model of the SQL query code and then apply the mental model to the new environment of Alteryx. For each increment, students solve the same set of problems in SQL and Alteryx, so that the understanding of SQL eases the transition to Alteryx, and the practice in Alteryx reinforces the understanding of SQL. Keywords: SQL; Data analytics; Mental models (search for similar items in EconPapers) Downloads: (external link) Related works: Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text Persistent link: https://EconPapers.repec.org/RePEc:eee:joaced:v:64:y:2023:i:c:s0748575123000301 DOI: 10.1016/j.jaccedu.2023.100858 Access Statistics for this article Journal of Accounting Education is currently edited by Natalie Tatiana Churyk More articles in Journal of Accounting Education from Elsevier |
Is your work missing from RePEc? Here is how to contribute.
Questions or problems? Check the EconPapers FAQ or send mail to .
EconPapers is hosted by the
School of Business at Örebro University.