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…

The purpose of this study is to examine the effect of randomized versus nonrandomized data using an Excel case study project to measure students' academic performance. Specifically, the study examines whether randomized data strengthens students' analytical, problem-solving, and Excel skills while manipulating and analyzing accounting data. The…

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…

Colorimetry allows every color to be defined as a combination of three values, known as "color coordinates." Color coordinates allow researchers to universalize and standardize their color measurements, and nowadays, determining the color coordinates of samples is a routine method applied by organic and analytical chemists, students, and…

Quantitative decision making (management science, business statistics) textbooks rarely address data cleansing issues, rather, these textbooks come with neat, clean, well-formatted data sets for the student to perform analysis on. However, with a majority of the data analyst's time spent on gathering, cleaning, and pre-conditioning data, students…

This paper develops the ideas of "The Pedagogical Power of Context: Iterative Calculus Methods and the Epidemiology of Eyam" (French "et al." 2018 "J. Phys. Educ."), where we considered the application of the Euler method to solve epidemiological problems. Our purpose was to convey some examples of school level work…

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…

Teachers' technological experiences are constrained by limitations in reflective decision-making and theoretical frameworks. Challenges with the technological pedagogical content knowledge framework (TPACK) are often associated with deficits in self-regulation. To effectively develop TPACK, it is recommended that educators focus on enhancing…

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…

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…

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…

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…

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…