A staple of many spreadsheet-based management science courses is the use of Excel for activities such as model building, sensitivity analysis, goal seeking, and Monte-Carlo simulation. What might those things look like if carried out using Python? We describe a teaching module in which Python is used to do typical Excel-based modeling and…

This paper develops a spreadsheet simulation methodology for teaching simulation and performance analysis of priority queues with multiple servers, without resorting to macros, add-ins, or array formula. The approach is made possible by a "single overtaking" simplifying assumption under which any lower-priority customer may be passed in…

Supply chain management students are introduced to a variety of modeling concepts. Yet learning facility location and capacity allocation modeling to the level of application and mastery proves difficult for the typical undergraduate business student. Spreadsheets facilitate the teaching of optimization modeling; however, providing feedback to…

There are a variety of discrete facility location models that have practical relevance for operations management and management science courses. Integer linear programming (ILP) is the standard technique for solving such problems. An alternative approach that is often conceptually appealing to students is to pose the problem as one of finding 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…

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…

Operations and Supply Chain Management (OSCM) courses may cover supply chain strategies, supply chain classification, and supply chain performance. Familiarity with various manufacturing and logistics firms would help students to better understand such topics. Information on the Dow Jones Industrial Average indexed firms and top 50 supply chain…

Finite Mathematics has become an enormously rich and productive area of contemporary mathematical biology. Fortunately, educators have developed educational modules based upon many of the models that have used Finite Mathematics in mathematical biology research. A sufficient variety of computer modules that employ graph theory (phylogenetic trees,…

GRANTISM (GReenland and ANTarctic Ice Sheet Model) is an educational Excel™ model introduced by Pattyn (2006). Here, GRANTISM is amended to simulate the Svalbard-Barents-Sea Ice Sheet during the Last Glacial Maximum, an analogue for the contemporary West Antarctic Ice Sheet. A new name, "GRANTSISM," is suggested; the added S represents…

The traditional "leaky pipeline" plots are widely used to inform gender equality policy and practice. Herein, we demonstrate how a statistical phenomenon known as Simpson's paradox can obscure trends in gender "leaky pipeline" plots. Our approach has been to use Excel spreadsheets to generate hypothetical "leaky…

Inventory management is widely researched and the topic is taught in business programs across the spectrum of operations and supply chain management. However, the concepts are notoriously difficult for students to practice once they finish school and become managers responsible for inventory control. This article explains the structure and details…

This paper describes the implementation and testing of our concept of adaptable rubrics, defined as analytical rubrics that arrange assessment criteria at multiple levels that can be expanded on demand. Because of its adaptable nature, these rubrics cannot be implemented in paper formats, neither are they supported by current Learning Management…

In enzyme kinetic studies, linear transformations of the Michaelis-Menten equation, such as the Lineweaver-Burk double-reciprocal transformation, present some constraints. The linear transformation distorts the experimental error and the relationship between "x" and "y" axes; consequently, linear regression of transformed data…

Naturally occurring gravity currents include events such as air flowing through an open front door, a volcanic eruption's pyroclastic flow down a mountainside, and the spread of the Bhopal disaster's methyl isocyanate gas. Gravity currents typically have a small height-to-distance ratio. Plastic models were designed and constructed with a…

Business educators are struggling with how better to engage their students in the learning process. At the same time, stakeholders are reporting that business students are ill prepared in problem solving techniques and the effective use of spreadsheets. The systemic use of Excel as a teaching tool in the business curriculum may be the answer to…