The oscillations of one mass "m" suspended between two different springs, assuming a friction force proportional to the velocity [minuscule], have been studied. For this purpose, an assembly for this system has been made. The movement of the mass is recorded with a smartphone and analysed with "Tracker." It is obtained that the…

A laboratory experiment characterized by a whole-class data-pooling approach to generate a data set that can be used to test a model of the influence of ionic strength on electrolyte solubility is described and discussed. The design of the experiment makes efficient use of the laboratory period and releases time for instructional and dialogic…

Powder diffraction is one of the most widely used analytical techniques for characterizing solid state materials. It can be used for phase or polymorph identification, quantitative analysis, cell parameter determination, or even full crystal structure analysis using the powerful Rietveld refinement method. As with much of modern crystallography,…

A spreadsheet-based exercise for students is described in which they are challenged to explain and reproduce the disparate temperature dependencies of the heat capacities of gaseous F[subscript 2] and N[subscript 2]. For F[subscript 2], C[subscript p,m] increases from 300 K, reaches a maximum at 2200 K, and then decreases to 74% of the maximum…

EXCEL spreadsheet algorithms were developed at Villanova University to efficiently and consistently retrieve information from ASPEN® flowsheets and used for grading work in senior design. The challenge is to take a large volume of data that is in the stream and unit operations reports and quickly and consistently calculate a list of key grading…

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…

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…

In the field of physics teaching, the simple pendulum provides a very simple way to study the harmonic oscillator, the source of some fundamental concepts such as periodicity, relaxation time and anharmonicity. As such, its experimental study is frequently integrated into high school or first year university programs. With this in mind, in this…

This article describes the use of a spreadsheet to reinforce basic calculus that is expected of all university-level chemistry majors. The example provided shows a calculation using Excel to estimate, using a Riemann summation, the radiant exitance of a hot object using Planck's Law of Blackbody Radiation. The approach reinforces the elementary…

Here we present an inexpensive proposal to experimentally study Faraday's law of induction. The experiment uses low-cost materials, a computer with a sound card and a smartphone, both running free software. A value proportional to the induced electromotive force is measured with the computer's sound card and the data related to the magnetic field…

The scale-invariant way to analyze two-dimensional experimental and theoretical data with statistical errors in both the independent and dependent variables is revisited by using what we call the triangular linear regression method. This is compared to the standard least-squares fit approach by applying it to typical simple sets of example data…

GRANTISM (GReenland and ANTarctic Ice Sheet Model) is an educational Excel™ model introduced by Pattyn (2006). Here, GRANTISM is amended to simulate the Svalbard-Barents-Sea Ice Sheet during the Last Glacial Maximum, an analogue for the contemporary West Antarctic Ice Sheet. A new name, "GRANTSISM," is suggested; the added S represents…

Through the experiments described in this article, students become acquainted with the principles behind ternary liquid-liquid systems and/or Aqueous Two-Phase Systems (ATPS), and their characterization by the determination of the binodal curve, tie-lines, tie-line lengths and critical point, as well as in applying the non-random two-liquid model…

A series of Microsoft Excel spreadsheets were developed to simulate the process of separation optimization under isocratic and simple gradient conditions. The optimization procedure is performed in a stepwise fashion using simple macros for an automatic application of this approach. The proposed optimization approach involves modeling of the peak…

In this study, a pendulum experimental tool with a light-based timer has been developed to measure the period of a simple pendulum. The obtained data was automatically recorded in an Excel spreadsheet. The intensity of monochromatic light, sensed by a 3DU5C phototransistor, dynamically changes as the pendulum swings. The changed intensity varies…