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…

The oxidation of iron is an important reaction due to its high economic impact. In this laboratory exploration, the total order of this reaction was determined using commercially available handwarmer packets that rely on the iron-oxygen reaction to generate heat. The active ingredient in the handwarmer packet is iron, which interacts with…

Access to online data sets and free, data-visualization software programs that don't require coding skills has given journalism students the ability to produce charts, maps, and graphs quickly. Maps that used to require weeks of software training and expensive programs to create can now be produced in less than an hour. However, students must…

Equilibrator is a Microsoft Excel program for learning about chemical equilibria through modeling, similar in function to EQS4WIN, which is no longer supported and does not work well with newer Windows operating systems. Similar to EQS4WIN, Equilibrator allows the user to define a system with temperature, initial moles, and then either total…

The aim of this study is to scrutinize the characteristics of conceptual meaning making when students engage with virtual worlds in combination with a spreadsheet with the aim to develop graphs. We study how these tools and the representations they contain or enable students to construct serve to influence their understanding of energy resource…

Two methods of data analysis are compared: spreadsheet software and a statistics software suite. Their use is compared analysing data collected in three selected experiments taken from an introductory physics laboratory, which include a linear dependence, a nonlinear dependence and a histogram. The merits of each method are compared. (Contains 7…

Over 10 years have passed since the publication of Carr and Burkholder's (1998) technical article on how to construct single-subject graphs using Microsoft Excel. Over the course of the past decade, the Excel program has undergone a series of revisions that make the Carr and Burkholder paper somewhat difficult to follow with newer versions. The…

Descriptive statistics and appropriate visual representations of scores are important for all test developers, whether they are experienced testers working on large-scale projects, or novices working on small-scale local tests. Many teachers put in charge of testing projects do not know "why" they are important, however, and are utterly convinced…

In this article, our main objective is to present the use of Microsoft Software Excel 2007/2003 for teaching college and university level curriculum in science and engineering. In particular, we discuss two interesting and fascinating examples of interactive applications of Microsoft Excel targeted for undergraduate students in: 1) computational…

The teaching of scientific subjects usually require laboratories where students can put the theory they have learned into practice. Traditionally, electronic programmable calculators, dedicated software, or expensive software simulation packages, such as MATLAB have been used to simulate scientific experiments. Recently, spreadsheet programs have…

The authors describe a collection of dynamic interactive simulations for teaching and learning most of the important ideas and techniques of introductory statistics and probability. The modules cover such topics as randomness, simulations of probability experiments such as coin flipping, dice rolling and general binomial experiments, a simulation…

Creating single-subject (SS) graphs is challenging for many researchers and practitioners because it is a complex task with many steps. Although several authors have introduced guidelines for creating SS graphs, many users continue to experience frustration. The purpose of this article is to minimize these frustrations by providing a field-tested…

We discuss the introduction and teaching of partial differential equations (heat and wave equations) via modeling physical phenomena, using a new approach that encompasses constructing difference equations and implementing these in a spreadsheet, numerically solving the partial differential equations using the numerical differential equation…

In this exercise the US Standard Atmosphere is used as "data" that a student is asked to model by deriving equations to reproduce it with the help of spreadsheet and graphing software. The exercise can be used as a laboratory or an independent study for a student of introductory physics to provide an introduction to scientific research…

This case study investigated the impact of a spreadsheet (EXCEL) exploration on the understanding of statistical graphs among twenty Singapore secondary school students of average ability. Four EXCEL templates were constructed to allow students to explore four aspects of statistical graphs: zero in scale, effect of different scales, size…