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 dorbital 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 MaxwellBoltzmann 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 twosided 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
