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…

In rural contexts, schools experience many challenges such as lack of electricity, unstable WIFI, not enough classrooms and inadequate classroom technology. These challenges resulted in many teachers shying away from the use of technology in the classrooms. As with other subject fields, IsiNdebele language teachers want to prepare their learners…

Item analysis is an integral part of operational test development and is typically conducted within two popular statistical frameworks: classical test theory (CTT) and item response theory (IRT). In this digital ITEMS module, Hanwook Yoo and Ronald K. Hambleton provide an accessible overview of operational item analysis approaches within these…

Digital competence is undoubtedly one of the key skills that teaching staff should possess. Currently, there are many theoretical frameworks and ways to measure skills and knowledge related to the use of information and communication technologies (ICT). This article is an attempt to show the real and declared level of digital skills among future…

We present a simple activity based on the liquid-drop model which allows secondary school students to explore the uses of mathematical models and gain an intuitive understanding of the concept of binding energy, and in particular the significance of positive binding energy. Using spreadsheets provided as supplementary material, students can…

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…

Teaching quantitative methods at the undergraduate level is a difficult yet rewarding endeavor due to the challenges instructors face in presenting the material. One way to bolster student learning is through the use of statistical software packages. Google Sheets is a cloud-based spreadsheet program capable of many basic statistical procedures,…

This article describes a modeling project the author did with his algebra, geometry, and applications students in grades 9, 10, and 11 as an enrichment and exploration of an extremely relevant real-world phenomenon and introduction to the adult profession of epidemiologist. With discussion and exploration, this project consumed two periods of 88…

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…

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

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 hypothesis testing to increase student understanding of the concepts and methods in elementary statistics courses. The article considers hypothesis tests for the population mean with large or…

Despite the importance of artificial intelligence in our daily lives, it has yet to be integrated into K-12 classrooms in a meaningful way. This article explores a lesson in which geometry students use Euclidean distance to implement a functional machine learning algorithm in Google Sheets™. The assignment requires students to apply the distance…