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

titration curves

distribution of gas velocities

distribution diagrams

general demonstrations

complexation of silver ion

general complexation

ABC kinetics

reversible kinetics

blackbody radiation

the photoelectric effect

tossing pennys

reducing irreducible representations

integrating the Gaussian distribution

 

 

 

Flick Coleman
Chemistry Department
Date Created: January 15, 2008
Last Modified: January 15, 2008
Expires: September 15, 2014
Copyright by William F Coleman 2006