IDEAS home Printed from https://ideas.repec.org/a/eee/joaced/v64y2023ics0748575123000301.html
   My bibliography  Save this article

A mental model approach to teaching database querying skills with SQL and Alteryx

Author

Listed:
  • Lee, Lorraine
  • Casterella, Gretchen

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.

Suggested Citation

  • Lee, Lorraine & Casterella, Gretchen, 2023. "A mental model approach to teaching database querying skills with SQL and Alteryx," Journal of Accounting Education, Elsevier, vol. 64(C).
    • Handle: RePEc:eee:joaced:v:64:y:2023:i:c:s0748575123000301
    DOI: 10.1016/j.jaccedu.2023.100858
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0748575123000301
    Download Restriction: Full text for ScienceDirect subscribers only
    File URL: https://libkey.io/10.1016/j.jaccedu.2023.100858?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Knechel, W. Robert & Salterio, Steven E. & Kochetova-Kozloski, Natalia, 2010. "The effect of benchmarked performance measures and strategic analysis on auditors' risk assessments and mental models," Accounting, Organizations and Society, Elsevier, vol. 35(3), pages 316-333, April.
    2. Hall, Matthew, 2011. "Do comprehensive performance measurement systems help or hinder managers' mental model development?," LSE Research Online Documents on Economics 36703, London School of Economics and Political Science, LSE Library.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Cheng, Mandy M. & Humphreys, Kerry A. & Zhang, Yichelle Y., 2018. "The interplay between strategic risk profiles and presentation format on managers' strategic judgments using the balanced scorecard," Accounting, Organizations and Society, Elsevier, vol. 70(C), pages 92-105.
    2. Luippold, Benjamin L. & Kida, Thomas & Piercey, M. David & Smith, James F., 2015. "Managing audits to manage earnings: The impact of diversions on an auditor’s detection of earnings management," Accounting, Organizations and Society, Elsevier, vol. 41(C), pages 39-54.
    3. Michael E. Cummings & Hans Rawhouser & Silvio Vismara & Erin L. Hamilton, 2020. "An equity crowdfunding research agenda: evidence from stakeholder participation in the rulemaking process," Small Business Economics, Springer, vol. 54(4), pages 907-932, April.
    4. Sophie Hoozée & Falconer Mitchell, 2018. "Who Influences the Design of Management Accounting Systems? An Exploratory Study," Australian Accounting Review, CPA Australia, vol. 28(3), pages 374-390, September.
    5. Wright, William F., 2016. "Client business models, process business risks and the risk of material misstatement of revenue," Accounting, Organizations and Society, Elsevier, vol. 48(C), pages 43-55.
    6. Nitzl, Christian, 2016. "The use of partial least squares structural equation modelling (PLS-SEM) in management accounting research: Directions for future theory development," Journal of Accounting Literature, Elsevier, vol. 37(C), pages 19-35.
    7. Hadid, Wael & Hamdan, Mohammed, 2022. "Firm size and cost system sophistication: The role of firm age," The British Accounting Review, Elsevier, vol. 54(2).
    8. Huikku, Jari & Karjalainen, Jouko & Seppälä, Tomi, 2018. "The dynamism of pre-decision controls in the appraisal of strategic investments," The British Accounting Review, Elsevier, vol. 50(5), pages 516-538.
    9. Macinati, Manuela S. & Bozzi, Stefano & Rizzo, Marco Giovanni, 2016. "Budgetary participation and performance: The mediating effects of medical managers’ job engagement and self-efficacy," Health Policy, Elsevier, vol. 120(9), pages 1017-1028.
    10. Maurizio Massaro & Filippo Zanin & Roland Bardy, 2014. "Levers of control and knowledge sharing in alliances among Large Firms and Small Firms in the pharmaceutical industry," MANAGEMENT CONTROL, FrancoAngeli Editore, vol. 2014(2), pages 121-142.
    11. Green, Wendy J. & Cheng, Mandy M., 2019. "Materiality judgments in an integrated reporting setting: The effect of strategic relevance and strategy map," Accounting, Organizations and Society, Elsevier, vol. 73(C), pages 1-14.
    12. Trotman, Ken T. & Bauer, Tim D. & Humphreys, Kerry A., 2015. "Group judgment and decision making in auditing: Past and future research," Accounting, Organizations and Society, Elsevier, vol. 47(C), pages 56-72.
    13. Macinati, Manuela S. & Rizzo, Marco G., 2014. "Budget goal commitment, clinical managers’ use of budget information and performance," Health Policy, Elsevier, vol. 117(2), pages 228-238.
    14. Sebastian Goebel & Barbara E. Weißenberger, 2017. "Effects of management control mechanisms: towards a more comprehensive analysis," Journal of Business Economics, Springer, vol. 87(2), pages 185-219, February.
    15. Samson, Kelly & Bhanugopan, Ramudu, 2022. "Strategic human capital analytics and organisation performance: The mediating effects of managerial decision-making," Journal of Business Research, Elsevier, vol. 144(C), pages 637-649.
    16. O’Neil, Glenn & Bauer, Martin W., 2018. "Pathways to use of communication campaigns’ evaluation findings within international organizations," Evaluation and Program Planning, Elsevier, vol. 69(C), pages 82-91.
    17. Anja Heinicke, 2018. "Performance measurement systems in small and medium-sized enterprises and family firms: a systematic literature review," Journal of Management Control: Zeitschrift für Planung und Unternehmenssteuerung, Springer, vol. 28(4), pages 457-502, February.
    18. Cäker, Mikael & Siverbo, Sven, 2018. "Effects of performance measurement system inconsistency on managers’ role clarity and well-being," Scandinavian Journal of Management, Elsevier, vol. 34(3), pages 256-266.
    19. Lisa-Marie Wibbeke & Maik Lachmann, 2020. "Psychology in management accounting and control research: an overview of the recent literature," Journal of Management Control: Zeitschrift für Planung und Unternehmenssteuerung, Springer, vol. 31(3), pages 275-328, September.
    20. Patrizia Di Tullio & Matteo La Torre & Diego Valentinetti & Michele A. Rea, 2021. "Toward performance measurement systems based on business models," MANAGEMENT CONTROL, FrancoAngeli Editore, vol. 2021(suppl. 1), pages 97-122.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:eee:joaced:v:64:y:2023:i:c:s0748575123000301. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Catherine Liu (email available below). General contact details of provider: https://www.journals.elsevier.com/journal-of-accounting-education .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.