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…

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…

The Birthday Paradox problem can be investigated either with a carefully constructed spreadsheet (for greatest precision) or a calculator process (for reasonable precision). A number of ways of approaching this problem as a class activity are provided.

The simple vehicle routing problem (VRP) is a common topic of discussion in introductory operations research/management science courses. The VRP can be framed in a variety of ways, and it can be difficult to solve to optimality. For solution purposes, introductory textbooks demonstrate how Excel's Evolutionary Solver (ES) add-in produces a…

This teaching brief describes an engaging, in-class exercise that introduces genetic algorithms as well as advanced Excel functions and capabilities by modeling the familiar Sudoku puzzle. Student groups are first asked to manually solve a given puzzle and then translate that solution methodology to a spreadsheet model. This exercise can be used…

Spreadsheets provide a rich setting for first-year algebra students to solve problems. Individual spreadsheet cells play the role of variables, and creating algebraic expressions for a spreadsheet to perform a task allows students to achieve a glimpse of how mathematics is used to program a computer and solve problems. Classic optimization…

A bachelor's degree program in chemistry typically starts with basic concepts in mathematics, physics, and chemistry. Those principles are very important because they pave the ground for future advanced studies and, therefore, one needs to present them in a clear but rigorous way. One example is provided by the mathematical notion of an iterative…

This paper develops the ideas of "The Pedagogical Power of Context: Iterative Calculus Methods and the Epidemiology of Eyam" (French "et al." 2018 "J. Phys. Educ."), where we considered the application of the Euler method to solve epidemiological problems. Our purpose was to convey some examples of school level work…

For the least-squares analysis of data having multiple uncertain variables, the generally accepted best solution comes from minimizing the sum of weighted squared residuals over all uncertain variables, with, for example, weights in x[subscript i] taken as inversely proportional to the variance [delta][subscript xi][superscript 2]. A complication…

The invention of the computer has led to the establishment of a new research paradigm, computation, which has recently become more and more popular in scientific exploration. However, computation is not well represented in high school and university curricula in science and engineering, although it applies to a wide range of disciplines beyond…

The oxidation of iron is an important reaction due to its high economic impact. In this laboratory exploration, the total order of this reaction was determined using commercially available handwarmer packets that rely on the iron-oxygen reaction to generate heat. The active ingredient in the handwarmer packet is iron, which interacts with…

It is hard to imagine that, eight hundred years on, the study of Fibonacci could affect the lives of teenagers in Australia. Or is it? A mathematics class of more able Year 9 students in a regional city of Western Australia feels that it has happened to them. Thirty-two students submitted a Fibonacci task as a mathematics assessment, with many of…

The classical "brachistochrone" problem asks for the path on which a mobile point M just driven by its own gravity will travel in the shortest possible time between two given points "A" and "B." The resulting curve, the cycloid, will also be the "tautochrone" curve, i.e. the travelling time of the mobile…