Functions and formulas in spreadsheets provide an instructional opportunity to help students build their skills in identifying errors in their own work and identifying a path to go about correcting the errors. This paper provides examples of functions and equations used to create two approaches to calculating the solution to one problem, such as a…

The purpose of this study is to examine the effect of randomized versus nonrandomized data using an Excel case study project to measure students' academic performance. Specifically, the study examines whether randomized data strengthens students' analytical, problem-solving, and Excel skills while manipulating and analyzing accounting data. The…

Single-period inventory models with uncertain demand are very well known in the business analytics community. Typically, such models are rule-based functions, or sets of functions, of one decision variable (order quantity) and one random variable (demand). In academics, the models are taught selectively and usually not completely. Students are…

The Principles of Information Systems course taught at a medium-sized Midwest University consists of Information Systems conceptual material plus Microsoft Excel and Access skills that the Information Systems faculty feel are most important to business students from all business disciplines. These skills range from using basic mathematic functions…

Design, development and explorations of databases are popular topics covered in introductory courses taught at business schools. Microsoft Access is the most popular software used in those courses. Despite quite high complexity of Access, it is considered to be one of the most friendly database programs for beginners. A typical Access textbook…

The statistical output of interest to most elementary statistics students is the p-value, outputted in computer programs like SPSS, Minitab and SAS. Statistical decisions are sometimes made using these values without understanding the meaning or how these values are calculated. Most elementary statistics textbooks calculates p-values for z-tests…

Capstone courses in accounting programs bring students experiences integrating across the curriculum (University of Washington, 2005) and offer unique (Sanyal, 2003) and transformative experiences (Sill, Harward, & Cooper, 2009). Students take many accounting courses without preparing complete sets of financial statements. Accountants not only…

This paper uses Excel to enhance the pedagogy of capital structure theory for corporate finance instructors and students. We provide a lesson plan that utilizes Excel spreadsheets and graphs to develop understanding of the theory. The theory is introduced in three scenarios that utilize Modigliani & Miller's Propositions and…

The American Institute of Certified Public Accountants (AICPA) and the International Accounting Education Standards Board (IAESB) identify spreadsheet technology as a key information technology (IT) competency for accounting professionals. However requisite spreadsheet competencies are not specifically defined by the AICPA or IAESB nor are they…

The purpose of this study is to investigate the differences between genders on the scores of a series of spreadsheet projects in a survey computer information systems course. This study hypothesizes that there will be significance in scores in the ten assigned projects between female students and males students; with the female students scoring…

Higher education expenditures are being increasingly targeted toward distance learning, with a large portion focused specifically on web-based instruction (WBI). WBI and classroom-based instruction (CBI) tend to offer students diverse options for their education. Thus, it is imperative that colleges and universities have ample, accurate…

The purpose of this study is to explore the potential impact of support materials on student spreadsheet skill acquisition. Specifically, this study examines the use of an online spreadsheet simulation tool versus a printed book across two independent student groups. This study hypothesizes that the online spreadsheet simulation tool will have a…