Angular Overlap Model Spreadsheet

This spreadsheet allows students to build complexes of a variety of geometries and to then use the angular overlap model to explore d-orbital energies when interacting with ligands whose esigma and epi energies can be varied.

http://academics.wellesley.edu/Chemistry/Flick/Excel/angoverlap.xls

Learning Goals

To explore a highly parameterized model and to deepen student understanding of metal-ligand interactions.

Implementation Notes

I gave one of my 10-minute quizzes (these are due electronically by midnight on the day they are given) based on this spreadsheet early last week and all 20 of my inorganic students did it perfectly. Either the spreadsheet was helpful, or the quiz was meaningless.

Web Resources

Flick's interactive spreadsheets

Creative Commons License

Attribution CC BY

Donald Linn / Indiana U Purdue U Fort Wayne

I had no luck accessing this resource.

Don Linn

Tue, 05/04/2010 - 13:58 Permalink

Maggie Geselbracht / Reed College

Thanks for the alert to this broken link, Don. It should be fixed now so that you can access the file.

Tue, 05/11/2010 - 02:29 Permalink

Nancy Williams / Scripps College, Pitzer College, Claremont McKenna College

The sliders and such didn't show up on my spreadsheet until I highlighted the whole area and put the text in a color other than white-on-white

Mon, 05/24/2010 - 14:43 Permalink

Tim Herzog / Weber State University

The link appears to be broken.

Mon, 03/20/2017 - 11:11 Permalink

Barbara Reisner / James Madison University

Flick has a lot of great stuff on the Wellesley website. You can find this particular activity at http://academics.wellesley.edu/Chemistry/Flick/Excel/angoverlap.xls

Check out http://academics.wellesley.edu/Chemistry/wfc/wfcspreadsheets.html and http://academics.wellesley.edu/Chemistry/wfc/wfcflash.html for his other materials.

I'll go ahead and change the links in this learning object to reflect where things have moved.

Mon, 03/20/2017 - 11:45 Permalink