Excel Spreadsheets for Chemical and Biochemical Education

These spreadsheets include material created for general chemistry and biochemistry courses. They are graphical demonstrations of chemical and biochemical concepts. The spreadsheets have been tested with Excel 2011, Mac OS X El Capitan, but I think they should work with most versions of Excel. For University of Maryland students, Microsoft software can be downloaded via Terpware. Making this material widely available was supported and inspired by the Elevate Fellows program run through the Teaching and Learning Transformation Center here at the University of Maryland College Park.

Comments welcome. If you have suggestions for improvement, or better yet improved code, please let me know.

See also the companion page of Matlab programs.

Back to Jason Kahn's home page and listing of other teaching resources

• Strong Acid-Strong Base Titration Curves.
• van der Waals equation of state for gases.
• Chemical Kinetics. Progress curves for different reaction orders, compared.
• DNA melting curve. The spreadsheet allows fiddling with ΔH° and ΔS°.
• Delta Cp. Example drawn from Nash of using heat capacity to predict the temeprature dependence of Keq for the Haber process.
• Hemoglobin Allostery. Simple binding curves based on MWC model.