The Nolan Index (NI) is a normed, quantitative measure for comparing the degree of resemblance (similarity or dissimilarity) between free listings with an Excel program for calculating it. This article enhances that effort with the addition of an R program and additional applications. Free-list resemblance measures have been used to investigate…

Logic modeling, the process that explicates how programs are constructed and theorized to bring about change, is considered to be standard evaluation practice. However, logic modeling is often experienced as a transactional, jargon-laden, discrete task undertaken to produce a document to comply with the expectations of an external entity, the…

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…

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…

We present a simple activity based on the liquid-drop model which allows secondary school students to explore the uses of mathematical models and gain an intuitive understanding of the concept of binding energy, and in particular the significance of positive binding energy. Using spreadsheets provided as supplementary material, students can…

When students of the of the physical sciences transition from school to university, they discover that knowledge of calculus is as vital as arithmetic, and that there is precious little useful information written without calculus. However, the lack of calculus in pre-university physics studies persists, especially in its application to the…

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…

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…

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…

The general aim of the article is to teach the reader how to transform conceptual models of change, development, and learning into mathematical expressions and how to use these equations to build dynamic models by means of the widely used spreadsheet program Excel. The explanation is supported by a number of Excel files, which the reader can…

Computational thinking is a component of the Science and Engineering Practices in the Next Generation Science Standards, which were adopted by some states. We describe the activities in a high school chemistry course that may develop students' computational thinking skills by primarily using Excel, a widely available spreadsheet software. These…

This paper gives an account of an experiment in which thirty-three high school students of ages 17-19 developed spreadsheet numerical models of satellite and space probe motion. The models are free to download. A survey was carried out to find out the students' opinion of the lessons.

U.S. GAAP and IFRS standards both require a cash flow statement that presents operating, investing and financing net cash flows (FASB, FAS 95; 1987; IASB, IAS 7, 1992). Although students are exposed to the cash flow statement in beginning accounting courses and then study the cash flow statement in more depth in intermediate accounting classes,…

When students are first introduced to the idea of radioactive decay, a large conceptual hurdle must be overcome. The thought that an object's age has no bearing on the chance it will "die" (decay in this case) on a particular day is completely at odds with biological notions of life and death. Through the use of a simple…