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…

Students often struggle with the concept of dependence of events or random variables. We present a simple coin flipping game that yields surprising results due to the dependencies within the game. The game is simple enough for young children to understand and play, yet complex enough to yield results that are counterintuitive to even most graduate…

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…

Logistic regression is one of the most fundamental tools in predictive analytics. Graduate business analytics students are often familiarized with implementation of logistic regression using Python, R, SPSS, or other software packages. However, an understanding of the underlying maximum likelihood model and the mechanics of estimation are often…

This study aims to investigate the behavioural dimensions that influence college students' intention to implement computational thinking in compiling financial statements using spreadsheets. This study used a non-experimental type of quantitative research with a cross-sectional research design. The sample of this study was 148 college students who…

Over the past few years, academics have undertaken initiatives to bridge the gap between theory and practice in the ever-growing field of business analytics, including implementing real-life student projects in all shapes and forms. Every year since 2015, Manhattan College has invited student teams from across North America and elsewhere in the…

This paper presents the results of an exploratory case study that examined a veteran secondary teacher's knowledge for teaching non-routine mathematical problem-solving with digital technologies. Data was collected through the observation of a veteran mathematics teacher, in real time, solving a mathematical problem with the digital tools of his…

Data literacy has become a much sought after skill by organizations as the importance of data driven decision making continues to rise in importance. This study explores the teaching of Tableau as a supplement to Excel to enhance the data literacy skills of students. Twenty-eight students taking an introductory course in Business Analytics and…

The article uses dynamic visualizations in Excel to examine a variety of ways in which students can attain a much greater depth of understanding of optimization problems in introductory calculus. The topics discussed include a variety of common optimization problems that appear in virtually every calculus textbook that can all be enhanced…

The recent works of oscillators are mainly focused on underdamped oscillation. Therefore, the writer proposes an experimental apparatus to demonstrate all types of damped harmonic oscillation. The apparatus utilizes an Arduino for data acquisition and an Excel spreadsheet for data analysis. By using this apparatus, the type of damped harmonic…

As educational systems move from onsite to online due to the COVID-19 pandemic, teachers face the difficulty of designing online examination formats which minimize opportunities for dishonesty. In this paper, we expose our design of such a format: a protected Microsoft Excel spreadsheet containing short-answer questions, which was implemented in a…

It's not surprising that rainbows have received a great deal of attention: in textbooks, in magazines, and on the web. They are, after all, beautiful, fascinating, occasionally awe-inspiring, even a little mysterious. They are an almost perfect blend of natural beauty and simple physics. Has everything that can be said about rainbows already been…

A spreadsheet plotting assignment of real-life data from a racecar is employed to help students master the relationships among speed, acceleration, and distance. The racecar application will capture the imagination and interest of the student. The data is obtained by reading speedometer values from a YouTube video for 40 s as a racecar accelerates…

The benefits of using Microsoft Excel built-in functions in an undergraduate Multistage Separations course are analyzed based on 15 years of experience teaching mass transfer in Chemical Engineering programs at both the Bachelor's and Master's levels. Eight reasons for using spreadsheets in a Mass Transfer virtual course are given. Through the…

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…