**
Chemical Excelets: Interactive Excel Spreadsheets
for General Chemistry**

These interactive spreadsheets (aka -
simulations) are
used in-class and as out-of-class projects. Through the use of numerical
experimentation and "what if" scenarios, we have a powerful discovery learning
tool for students using readily available off-the-shelf software. For a
discussion on using Excelets, see __
C__hemical
__S__preadsheet __I__nvestigations: Empowering Student Learning of
Concepts via Camouflaged Mathematical Exploration.

How do I interact with the spreadsheet?

The interactivity on the spreadsheets
occurs as cells with a yellow background, where the number can be entered by
typing in a value, or
sliders, where one can drag the center bar or click on the terminal arrows, are
changed.
Likewise, the spinner works by clicking on the arrows. You may also see check boxes
or option buttons which perform the indicated task. A response
will occur on the graph and/or data by adjusting any of these items. List
boxes are also used to select information. Comment
cells (red triangle in upper right corner) are used to deliver information as well.

The
Collection

Here are a variety of Excelets
(hold the cursor over the link for a brief description) and
some pdf handouts for topics in General Chemistry, including the
laboratory. Some of these are simple calculation aids, while others
explore concepts by bringing the mathematics alive. A number of the more recent Excelets, marked with an *
consider the influence of random and/or systematic error. (Note
- In Excel, you may need to resize these spreadsheets to fit your screen
by going to View on the menu bar and selecting Zoom.)

For information on designing Excelets and links to mathematical modeling of data support materials, see Developer's Guide to Excelets. For more Excelets in materials science espeically for materials, measurement and error plus further exploration of the periodic table and solid state stuff, see the MatSci Excelets page.

Other good sites for chemists:

Interactive Spreadsheets in *JCE* WebWare

Please e-mail any corrections, modifications, suggestions, or questions.

Rate and comment on this collection in Merlot.

Scott A. Sinex Prince George’s Community College 1/2015

View statistics