As the use of data in courses that incorporate statistical methods has become more prevalent, so has the need for tools for working with such data, including those for data creation and adjustment. While numerous tools exist that support faculty who teach statistical methods, many are focused on data analysis or theoretical concepts, and there…

We present a complete, soup to nuts, modeling activity of a falling column of water. Many colleagues have used this material in teaching applications of first order separable differential equations. We describe how the material can be presented with students collecting their own data from online videos. One can then either offer the differential…

Solution equilibria diagrams are excellent tools for understanding chemical speciation in multireaction chemical systems. They are usually plotted using software packages that efficiently perform advanced calculations, giving the possibility to graphically visualize thermodynamic and composition information. However, this approach frequently…

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 drive in computational methods and more intuitive software has seen a rise in the number of publications in this area in recent years. Computational simulations can be found in many areas of science from computational biology and chemistry to fundamental physics. These may help synthetic chemists in their drug discovery endeavors and…

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…

As educational systems move from onsite to online due to the COVID-19 pandemic, teachers face the difficulty of designing online examination formats which minimize opportunities for dishonesty. In this paper, we expose our design of such a format: a protected Microsoft Excel spreadsheet containing short-answer questions, which was implemented in a…

It has become increasingly important for future business professionals to understand statistical computing methods as data science has gained widespread use in contemporary organizational decision processes in recent years. Used by scores of academics and practitioners in a variety of fields, Monte Carlo simulation is one of the most broadly…

This contribution shows a simple implementation of Monte Carlo simulation method when presenting Bayes' rule. The implementation is carried out in the environment of Microsoft Excel spreadsheets by means of a generator of random numbers. The empiric results gained by simulation serve to confirm the correctness of the chosen procedures in…

This article uses dynamic software in Excel to demonstrate several ways in which graphical and numerical approaches can be introduced both to enhance student understanding of l'Hopital's Rule and to explain why the Rule actually works to give the "right" answers. One of the approaches used is to visualize what is happening by examining…

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…

In this work we discuss the intricacies of a simulation using the MS Excel spreadsheet that allows to study in detail the process of heat transfer between two reservoirs at different temperatures through a conducting rod when heat losses are neglected. The proposed physical model computes the time dependence of the reservoir temperatures and…

This article illustrates ways that dynamic software using some sophisticated techniques in Excel can be used to demonstrate fundamental ideas related to sampling distributions and their properties to increase student understanding of the concepts and methods in elementary statistics courses. The article considers such sampling distributions as the…

Harmonics arise naturally from the resonances in strings and pipes. A video demonstration (Ruiz 2016 "YouTube: Tuba Harmonics" (https://youtu.be/souhEzOP9c4)) is provided where a tubist (coauthor Holmes) produces a phenomenal 24 harmonics using a single tuba pipe length by controlling the buzz of his lips. The frequencies of the…

This article illustrates ways that dynamic software using some sophisticated techniques in Excel can be used to demonstrate fundamental ideas related to regression and correlation analysis to increase student understanding of the concepts and methods in elementary statistics courses and in courses at the college algebra/precalculus level that…