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 describes a web-based application that can be used to help teach linear programming (LP) using an active learning approach in business courses such as management science and decision analysis. The software asks 42 integrated questions that guide students in creating product mix models and performing related analysis in Excel with…

Since motivation is known to be a critical factor, approaches, methods, techniques, and materials that would affect motivation positively are utilized in learning and teaching processes. Gamification is used by including game components into teaching processes to enhance students' motivation, attract their attention to the lesson and boost…

In this research we investigate how mathematics teachers, as graduate students, estimate the value of [pi] by exploring the problem of "squaring the circle" using digital technology. Initially, we mention some aspects of teaching and learning of calculus in the literature, emphasizing studies that use the notion of humans-with-media to…

The ways teachers converse about their work in relation to information and communications technologies (ICTs) are worth studying. We analyse how a teacher converses about her local practices in relation to two spreadsheet algebra programs (SAPs) on variables. During the conversations we noticed that the teacher keeps different policy documents --…

Data-handling, processing, and analysis skills are an integral part of a chemist's skill set and, more generally, are highly sought by employers. We report a self-directed workshop to develop and advance these key skills using the popular spreadsheet program Microsoft Excel. Making use of its accessible user interface, various contextualized…

Medical physics uses physics knowledge in medicine or healthcare. The question surrounding the methods of measuring temperature is important in medicine. The aim of this article is to explore the possibilities of using Microsoft Excel to study thermometers. The physical concepts and laws related to temperature measurement have been considered. The…

This paper presents the usage of an Excel spreadsheet for studying charged particle dynamics in the presence of uniform electric and magnetic fields. The equation of motion of the charged particle is developed under different conditions and the data is obtained in an Excel spreadsheet under variation of parameters such as the velocity of charged…

Spreadsheets are a core computational tool for practicing engineers and engineering students. While Microsoft Excel, Google Sheets, and other spreadsheet tools have some differences, numerous formulas, functions, and other tasks are common across versions and platforms. Building upon learning science frameworks showing that interactive activities…

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 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 Microsoft Excel workbook has been developed to simplify the quantitative analysis of experimentally measured titration curves for diprotic and triprotic amino acids such as glycine, arginine, histidine, and glutamate. Students perform the titration, enter the data into the worksheet, and manually adjust the resulting pK[subscript a] values to…

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…

A software to calculate the net charge and to predict the isoelectric point (pI) of a polypeptide is developed in this work using the graphical programming language LabVIEW. Through this instrument the net charges of the ionizable residues of the chains of the proteins are calculated at different pH values, tabulated, pI is predicted and an Excel…

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…