This paper presents a dynamic Excel visual. The visual has three graphs that are all driven by the same data, so students can see how changes (via Slider controls) in data appear on a univariate graph, a bivariate graph, and a graph that shows a ratio of two variables on one axis. The visual has macros that let a statistics teacher reveal parts of…

NoSQL databases have been used in organizations for decades. Few database textbooks on the market, however, have suitable materials about NoSQL beyond general introductions for typical business students. In fact, users of the typical NoSQL systems on the software market need to have certain computer programming skills. This teaching tip introduces…

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.

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…

The foreign exchange (FX) market is an important chapter in international finance. Understanding the market microstructure is critical for learning the FX market. To assist students better understand the FX market microstructure, an instructor can use an event study with minute-by-minute quote data provided in the Excel assignment, asking students…

This article provides two activities, exploring genetic drift of small breeding populations, highlighting the black-footed ferret ("Mustela nigripes"). According to the U.S. Fish and Wildlife service, all black-footed ferrets are descended from 18 individuals, making them extremely vulnerable to genetic drift. They were thought to be…

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…

Physicists create spreadsheets customarily to carry out numerical calculations and to display their results in a meaningful, nice-looking way. Spreadsheets can also be used to display a vivid geometrical model of a physical system. This statement is illustrated with an example taken from geometrical optics: images formed by a thin lens. A careful…

The effects of substitution on reaction rates are at the heart of both physical chemistry and organic chemistry. In this paper, we present a computational laboratory module to explore the effects of group substitution and isotopic substitution on reaction rates by using a readily accessible graphical interface, a computational engine, and…

Tootsie Pops, manufactured by Tootsie Roll Industries of Chicago, Illinois, are spherical hard-candy lollipops with a chocolate-flavoured, chewy center. While Tootsie Pops have been around since 1931, it was a television commercial made in 1969 that captured the attention of many. The commercial, an amusing animated cartoon, posed the following…

Given that the usage and complexity of spreadsheets in the accounting profession are expected to increase, it is more important than ever to ensure that accounting graduates are aware of the dangers of spreadsheet errors and are equipped with design skills to minimize those errors. Although spreadsheet mechanics are prevalent in accounting…

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,…

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…

This toolkit, developed by Regional Educational Laboratory (REL) Central in collaboration with York Public Schools in Nebraska, provides a process and tools to help teachers use data from their classroom assessments to evaluate promising practices. The toolkit provides teachers with guidance on how to deliberately apply and study one classroom…

Logistic growth displays an interesting pattern: It starts fast, exhibiting the rapid growth characteristic of exponential models. As time passes, it slows in response to constraints such as limited resources or reallocation of energy. The growth continues to slow until it reaches a limit, called capacity. When the growth describes a population,…