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 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 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.

In Hungary, K-12 informatics/computer science education focuses on mostly surface-based methods. This approach can be observed in the teaching of several topics in the subject, of which we focus on spreadsheet management. This is further emphasized by regulatory documents -- the Hungarian National Core Curriculum and Hungarian Curriculum…

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…

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…

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…

This work aims to demonstrate the use of Excel spreadsheets for solving L-L extraction problems. The key to solving the problems successfully is to be able to determine a tie line on the ternary diagram where the calculation must be carried out. This enables the reader to analyze the extraction process starting with a simple operation, the…

This paper presents issues related to the use of technology by secondary school pre-service mathematics teachers engaged in open mathematical modelling projects. Pre-service teachers developed these projects within a regular mathematics education course during the teacher education program at the university concerned. This environment, called a…

The paper argues that mathematical modeling is the essence of computational thinking. Learning a computer language is a valuable assistance in learning logical thinking but of less assistance when learning problem-solving skills. The paper is third in a series and presents some examples of mathematical modeling using spreadsheets at an advanced…

Information and communication technology (ICT) is an integral aspect of the current Australian Curriculum: Mathematics. The language, strategies and resources required in mathematics education today can be very different to the mathematics lessons experienced by current teachers when they themselves were at school (Sousa, 2015). Learning…

The development of a student's ability to make data-driven decisions has become a focus in higher education (Schield 1999; Stephenson and Caravello 2007). Data literacy, the ability to understand and use data to effectively inform decisions, is a fundamental component of information competence (Mandinach and Gummer 2013; Stephenson and Caravello,…

This paper provides the formula for the elevation angle at which a projectile has to be fired in a vacuum from a general position to hit a target at a given distance. A spreadsheet application that models the trajectory is presented, and the problem of finding the points of shot and impact of a projectile moving in a vacuum if three points of the…

This paper presents a simplified approach for the application of material efficiency metrics to linear and convergent synthesis plans encountered in organic synthesis courses. Computations are facilitated and automated using intuitively designed Microsoft Excel spreadsheets without invoking abstract mathematical formulas. The merits of this…