This WebWare submission includes a Microsoft Excel 2000 workbook designed to facilitate group theoretical calculations, and an article explaining several examples of how the templates might be used in a typical upper-level undergraduate, or graduate-level course. The Excel workbook contains about 30 templates, including a set of the 12 character tables most commonly used for chemical applications, and a set of templates illustrating typical calculations based on the character tables. Included are examples of spreadsheet calculations to demonstrate orthogonality, to determine the symmetry of vibrational/rotational modes, and to determine the central atom orbitals appropriate for bonding in complexes of various molecular geometries. Also included is a template that demonstrates how spreadsheet matrix operations can be used to demonstrate closure of group operations. Some of the problems are keyed to those in popular texts, but all are compatible with virtually any text on group theory. The Excel templates provide projectable character tables that are useful to lecturers with classrooms equipped for computer projection. Projected Excel character tables allow teachers to graphically demonstrate group theoretical calculations in a manner that should ease and enhance student learning.
Our Secondary School editors work hard to distill all the JCE materials to produce a fraction of particular interest to high school teachers. We call it CLIC.
In recent years we have worked hard to better match our advertisers with our readers. When shopping for chemistry education materials, visit our advertisers' WWW sites first.
Take JCE along on your outreach missions. Copies of the Journal, guest access to JCE Online, our publications catalog, and more are available for your participants.