In response to research indicating a need for an increased emphasis on aspects of corporate accounting, including corporate taxation, in the accounting curriculum as well as employer expectations that entry-level accounting position applicants possess Excel skills, this classroom exercise uses Excel to compare the financial impacts of three…

Spreadsheets help businesses run effectively and efficiently. However, many spreadsheets contain errors. Research provides taxonomies and guidance on preventing spreadsheet errors; this information often is not incorporated into training. Training students to use Excel functions and good spreadsheet practices is critical. This instructional…

For years, researchers have recognized the expectation within the business community that business school graduates possess a working knowledge of spreadsheet applications. Academics continue to seek effective ways to teach these skills in an academic setting. This exercise uses Wordle, a five-letter word guessing game, to teach students…

The author focused on solving problems of third-degree price discrimination under a monopoly by integrating microeconomic theory and spreadsheet modeling. Price discrimination refers to a firm situation in which the same good is sold to different groups of consumers at different prices. First, the author included an introductory math background…

In this paper the authors present a unique approach to teaching introductory statistics at both the undergraduate and graduate levels. The approach uses a feature in Excel called "spinners" to dynamically adjust key variables, such as sample size, confidence levels, and probabilities, among others, to enable an expanded discussion of…

The authors' objective was to uncover the difference in competency when teaching Excel to undergraduate students on two distinct and discrete operating platforms. The authors calibrated competency by comparing scores of MOS-EXCEL Certification Test results. The authors conclude that the null hypothesis indicating no difference in mean scores of…

The authors use a capital budgeting example to show students how to incorporate price elasticity into financial analysis as an application of what students learn in their microeconomics course. They present simple as well as more advanced price-quantity relationships, and using various "what-if" scenarios; the authors show how risk…

This article describes a web-based application that can be used to help teach linear programming (LP) using an active learning approach in business courses such as management science and decision analysis. The software asks 42 integrated questions that guide students in creating product mix models and performing related analysis in Excel with…

The author's goals in this exercise were to use an Excel project to teach students about the effects of changing states of nature on critical path emergence as well as compare the impact of the PERT beta and triangular distributions on project completion times. Previous research into the PERT (program evaluation and review technique) beta…

Business analytics can be described as the statistical analysis of data to make decisions and meaningful conclusions. As the demand to advance the curriculum of undergraduate business education increases, courses in business analytics aim to provide students with fundamental skills in critical thinking. Educators have found that spreadsheet…

With 27 million users, Excel (Microsoft Corporation, Seattle, WA) is the most common business data analysis software. However, audits show that almost all complex spreadsheets have errors. The author examined textbooks to understand why responsible data analysis is taught. A purposeful sample of 10 textbooks was coded, and then compared against…

This study reports on the effect of student engagement in digital learning activities on academic performance for 120 students enrolled in an undergraduate finance course. Interactive practice and exam problem files were available to each student, and individual download activity was automatically recorded during the first 50 days of the course.…

This research determines which computer skills are important for entry-level accountants, and whether some skills are more important than others. Students participated before and after internships in public accounting. Longitudinal analysis is also provided; responses from 2001 are compared to those from 2008-2009. Responses are also compared to…

A longitudinal study of information technology (IT) managers at a Fortune 200 company in the Southwest United States was conducted to assess the effectiveness of a training program at bridging the perceived business skills gap for IT employees. A needs assessment was carried out, resulting in a 4-module training program. The program was evaluated…

Describes and gives examples of using spreadsheets for statistical resampling. Compares advantages and disadvantages of classical parametric versus spreadsheet methods of problem solving. (SK)