Interactive Spreadsheets

I began producing these spreadsheets in 1995 and gave them the name "Interactive Spreadsheets". This is a somewhat silly name as by its very nature a spreadsheet is interactive, but I have stuck with it. What the name means is a spreadsheet that a student can interact with without having to enter a great deal of new data. Using primarily the tools in the Forms menu in Excel, arrows, sliders and radio buttons allow students to vary parameters of a calculation and see the results immediately and graphically. If they wish, they may change variables continuously.

 

How to make an interactive spreadsheet - a brief video describing how to make these spreadsheets

ABC kinetics - interactively plot concentration versus reaction extent for A, B and C in A -> B -> C by varying k values

angular overlap model - explore the angular overlap model for d-orbital splitting in complexes by designing various geometries of complexes and varying the parameters es and ep

blackbody radiation - expanded version of application found in general demonstrations example - show blackbody distribution at three temperatures

complexation of silver ion - explore the concentration of various silver species in ammonia as a function of ammonia concentration - can be generalized by varying the Ksp and formation constants interactively

distribution diagrams - calculate distribution diagrams of acid/base species for monoprotic through hexaprotic acids - can vary pKa values interactively

distribution of gas velocities - show distribution of velocities from Maxwell-Boltzmann equation for three different molecular weights at a constant temperature or one molecular weight at three temperatures - vary molecular weights and temperatures interactively

general complexation - explore the distribution of complex species as a function of the concentration of ligand X for MXn with n = 1 - 6 by varying the formation constants

general demonstrations - includes a simpler gas velocity distribution example, the free energy versus reaction progress diagram at variable temperatures for the N204 <=> 2 NO2 equilibrium - blackbody radiation distribution at variable temperatures

integrating the Gaussian distribution - use interactive sliders to perform one- and two-sided integrations of the Gaussian distribution - explore the origin of the statement that x % of results, in a large data set that is randomly distributed and obeys Gaussian statistics, should lie within +/- z standard deviations from the mean

photoelectric effect - expanded version of application found in general demonstrations example

reducing irreducible representations - interactive spreadsheet for reducing reducible representations of 12 common point groups

reversible kinetics - explore concentrations of A and B for A <=> B as a function of time by varying k values - also shows the reaction quotient, Q, and the ratio of Q/K

titration curves - calculates titration curves for monoprotic through tetraprotic acids - compare titration curves to distribution diagrams - interactively vary pKa values and watch titration curve change - vary initial volume of acid and concentrations of acid and strong base

tossing pennys - toss up to 100 pennies 100 times and explore the distribution of heads and tails, calculate the mean and standard deviation and compare to a theoretical Gaussian distribution for the same experiment

This Page Is Always Under Construction