We present an interactive spreadsheet that supports teaching essential concepts in classification using the logistic regression (LoR) model for binary classification. The interactive spreadsheet demonstrates the capabilities of LoR by integrating computation with visualization. Students will reinforce concepts like probabilities, maximum…

Computational thinking (CT) is gaining attention in education as a part of digital literacy and can be addressed in several disciplines, including mathematics. Through the lens of Brennan and Resnick's framework, we investigated how computational concepts, practices, and perspectives can be addressed in upper-secondary statistics lessons using…

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…

Examples of applications of equilibrium-based methods for multicomponent separations usually require the use of simulation packages, which do not allow students to follow the involved algorithms step by step. Excel spreadsheets with examples of six such rigorous methods have been used with MSc students of Chemical Engineering of the University of…

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.

A spreadsheet-based project is presented that is designed to enhance and expand student understanding of phase transition properties of pure water and ideal and nonideal (electrolyte) aqueous solutions. Using fundamental principles of classical and statistical thermodynamics, students calculate the melting and boiling points, the enthalpies and…

The present article demonstrates a way of programming using an Excel spreadsheet to teach Fourier series expansion in school/colleges without the knowledge of any typical programming language. By using this, a student learns to approximate partial sum of the n terms of Fourier series for some periodic signals such as square wave, saw tooth wave,…

This document presents a literature review that analyzes the articulation of modeling and digital technologies in the field of Mathematics Education. The review aims to find evidence of the use of digital technologies in modeling processes and how these practices can change some ways of working with students in the classroom. The results show, on…

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…

It is a question in many countries whether ICT and application usage should be taught. There are some problems with IT literacy: users do not understand the concepts of a software, they cannot solve problems, and moreover, using applications gives them more problems. Consequently, using ICT seems to slow work down. Experts suggest learning…

Early education has classically introduced reading, writing, and mathematics. Recent literature discusses the importance of adding "computational thinking" as a core ability that every child must learn. The goal is to develop students by making them equally comfortable with computational thinking as they are with other core areas of…

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…

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…

Financial analysts generally create static formulas for the computation of NPV. When they do so, however, it is not readily apparent how sensitive the value of NPV is to changes in multiple interdependent and interrelated variables. It is the aim of this paper to analyze this variability by employing a dynamic, visually graphic presentation using…

This teaching brief describes a method for finding an approximately optimal combination of order quantity and reorder point in a continuous review inventory model using a discrete expected shortage calculation. The technique is an alternative to a model where expected shortage is calculated by integration, and can allow students who have not had a…