JCE Online Journal of Chemical Education
 | Subscriptions  | Software Orders  | Support  | Contributors  | Advertisers  | 

JCE Print
   Current Issue
 Previous Issues
 Supplements
 Search JCE Index

JCE Digital Library
   DigiDemos
 QBank
 SymMath
 WebWare

JCE Software
   Latest Releases
 Software & Video
 Downloads
 Support

Only@JCE Online
   JCE Online Store
 JCE HS CLIC
 JCE Discussion Forums
   Biographical Snapshots
 ChemEd Resource Shelf
 Featured Molecules
 Hal's Picks
 Project Chemlab
 Reviewed WWW Sites
 "Web-Ed" Articles

About JCE
   Features
 Publications
 Operations
 Outreach
 Contact Us


  Home > JCE Print > Journal of Chemical Education > Issues > 1998  > February  >
Information • Textbooks • Media • Resources
Computer Bulletin Board
Production of Numerical Chemical Problems Using a Spreadsheet
Peter G. Hall
University of Glamorgan, School of Applied Sciences, Mid Glamorgan CF 37 1DL, UNITED KINGDOM
Cover
February 1998
Vol. 75 No. 2
p. 243
Abstract
The article describes how a spreadsheet can be used together with a word-processing package (the example being based on Excel 5 and Word 6) to produce individual problems for a class of students. The data for the problems are in the spreadsheet, either input as a data base or generated by the software using its random number function. The example described in detail is the creation of "initial rates" problems. In addition to the problems, the spreadsheet is able to produce a table of answers. The Mail Merge property of the word-processing package then allows a large number of different problems to be produced - if required with students names and hand-in dates included. The method is ideally suited to numerical problems in physical chemistry but has been extended to nomenclature problems in polymer chemistry and to the preparation of non-identical practical scripts (an example from polymer chemistry being slightly different di-acid, di-ol combinations in a polymerization reaction).
More Information
*  Citation
 Hall, Peter G. J. Chem. Educ. 1998 75 243.
*  Keywords
 Physical Chemistry, Teaching/Learning Aids, and Computer Assisted Instruction
*  History
 Created:
Last Updated:		 June 28, 1999
June 24, 2005
<< Previous Article Table of Contents Next Article >>
  Home > JCE Print > Journal of Chemical Education > Issues > 1998 > February > Page 243


Subscriptions
 Subscription Info
 Order Forms

JCE HS CLIC

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.
 JCE HS CLIC

Contributions Welcome
JCE welcomes your submission
 Contributors' Corner

Advertisers
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.
 Recent Advertisers

Be An Ambassador
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.
 Outreach with JCE

Comments to
jceonline@chem.wisc.edu		 Copyright © Division of Chemical Education, Inc., American Chemical Society.
All rights reserved.