Analyzing Data for Decision Making: Integrating Spreadsheet Modeling and Database Querying

Abstract

Although students begin with a spreadsheet to analyze the effect of a change in credit score cutoff on loan performance on sales, they discover that this approach becomes unwieldy as the analysis becomes more complex. As more attributes from more sheets are required, the spreadsheet solution becomes difficult to implement or audit. The case thus motivates students to develop the database skills of importing the spreadsheet data into a database manager, joining tables, and performing the analysis using database querying. The case requires students to think critically to model the business situation in spreadsheet formulas and database query expressions, structure relationships among the attributes across data tables, and manipulate attributes to achieve the business objective. The case is suitable for courses in accounting systems, managerial accounting, decision making, and database systems. Objective questions are provided for assessing students' ability to analyze transaction records using both spreadsheet and database tools.

The Perception of Teachers and Students towards Using Myaccounting to Learn Principles of Accounting in Vocational Colleges, Malaysia

“…Integrating Excel should be done strategically, alongside a strong foundation in theoretical knowledge and critical thinking skills. As Borthick et al (2017) suggest, teachers can use Excel as a tool to reinforce understanding, not replace it. This can involve designing activities that encourage students to analyze data, interpret results, and draw meaningful conclusions, rather than simply rely on the software to generate answers.…”

Preparing Students for Careers Using Business Analytics and Data-Driven Decision Making

“…Questions are inspired by a number of teaching research articles such as: 'Teaching simulation in general' (Boyce, 1999;Riley et al, 2013), 'teaching data-driven decision making' (Ballou et al, 2018), 'Teaching spreadsheet modelling (Borthick et al, 2017;Frownfelter-Lohrke, 2017); 'Using @Risk' (Schriber, 2009;Togo, 2004), and 'Teaching System Dynamics' (Bianchi, 2016;Cosenz and Noto, 2015;Warren, 2004) 20 .…”

Integrating Data Cleansing With Popular Culture: A Novel SQL Character Data Tutorial

“…Current literature underscores the importance of educating a new generation of workers in 'Information Competencies' (Aasheim, et al, 2014;Azat, et al, 2016;Borthick, et al, 2016;Cegielski & Jones-Farmer, 2016;Gorman & Klimberg, 2014). "High quality training of the specialists working in the information sphere has become an important driver in successful development of the economy and the society.…”

“…Big data scientists need a variety of skills sets and knowledge domains. Current literature underscores the importance of educating a new generation of workers in 'Information Competencies' (Aasheim, Williams, Rutner, & Gardiner, 2014;Azat, Evgenia, & Tatiana, 2016;Borthick, Schneider, & Viscelli, 2016;Cegielski & Jones-Farmer, 2016;Gorman & Klimberg, 2014). Big data professionals need a deep understanding of relational database implementation and querying.…”