MathCAD Worksheets for Teaching Chemistry

David N. Blauch

Unless otherwise indicated, worksheets are written for MathCAD 11 or 12.

Reference Worksheets

• Physical Constants
  This worksheet, which is referenced in several other worksheets, provides commonly used physical constants, units, and physical constants. For some of the worksheets on this page, it may be necessary to change the path to the constants.mcd file.
• Linear Regression Functions
  This worksheet defines functions for returning the standard deviation of the regression, standard deviation of the slope, standard deviation of the intercept, and other useful properties associated with linear regression.

Chemical Equilibria

• Activity Coefficients
• Solubility of Calcium Carbonate in CO₂-saturated Water
• Solubility of Calcium Fluoride as a Function of pH
• Solubility of AgCl in Aqueous Ammonia
• Distribution Diagrams for Acid-Base Equilibria (Tutorial) (Graphics Image for equilibrium arrows)
• Distribution Diagrams for Acid-Base Equilibria (General Equation)
• Titration of Perchloric Acid with Ethylenediamine (en.prn data file)
• Titration of Perchloric Acid and Nickel(II) Ion with Ethylenediamine (Men.prn data file)
• Titration of a Strong Acid with a Strong Base
• Titration of a Weak Monoprotic Acid with a Strong Base
• Titration of a Weak Polyprotic Acid with a Strong Base
• Ethylenediamine-Co(II) Complexation Equilibria (Graphics Image for equilibrium arrows)
• EDTA Titrations (Graphics Image for equilibrium arrows)

Electrochemistry

• Chronoamperometry (Concentration_Profile.avi animation)
• Voltammetry
• Equivalent Circuit for AC Impedance Voltammetry

Mass Spectrometry

• Quadrupole and Ion Trap Mass Spectrometry (MathCAD 12) (MathCAD 14)

NMR Spectrometry

• Bloch equations
• Effect of Chemical Kinetics upon NMR Spectrum

Phase Equilibria

• Vapor Pressure of Water (WaterVaporPressure.txt data file)
• Vapor-Liquid Phase Diagrams (Raoult's Law, Distillations)
• Azeotropes (Nonideal Solutions)
• Henry's Law
• Colligative Properties

Quantum Mechanics

• Variational Principle applied to the Simple Harmonic Oscillator

Statistics and Numerical Analysis

• Statistical Analysis of Data (MathCAD 14)
• Fourier Filtering

Spectroscopy

• Extended X-Ray Absorption Fine Structure
• Vibrational Analysis

Statistical Mechanics

• Calculation of the Second Virial Coefficient
• Rotational Partition Function
• Vibrational Partition Function

Thermodynamics (misc. topics)

• Partial Molar Volumes for aqueous NaCl solutions. (NaCl.txt data file)