JCE Online Journal of Chemical EducationDivision of Chemical Education, American Chemical SocietyAmerican Chemical Society
 | Subscriptions  | Software Orders  | Support  | Contributors  | Advertisers  | 

JCE Print
   Current Issue
 Previous Issues
 Supplements
 Search JCE Index

JCE Digital Library
   ChemInfo
 DigiDemos
 Featured Molecules
 LivTexts
 LrnCom
 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 > 2006  > December  >
Information • Textbooks • Media • Resources
Computer Bulletin Board
Design of an Excel Spreadsheet To Estimate Rate Constants, Determine Associated Errors, and Choose Curve's Extent
Luís Moreira and Filomena Martins
Department of Chemistry and Biochemistry, Faculty of Sciences, University of Lisbon, Lisboa, Portugal

Ruben Elvas-Leitão
Department of Chemical Engineering, Engineering Institute (ISEL), Polytechnic Institute of Lisbon, Lisboa, Portugal

Cover
December 2006
Vol. 83 No. 12
p. 1879
Abstract
In this article we wish to present a new Microsoft Excel spreadsheet design that enables a prompt calculation of rate constant values (k) and associated errors and also addresses less common features such as the choice of experimental curve's extent. The step-by-step description of the design provides the opportunity to deal with other, less used, Excel tools. The performed direct calculation of uncertainties, via established formulas, offers the possibility of acquiring an insightful knowledge of statistical and numerical analysis theory and its practical application on spreadsheet designs. Selected examples, given as Supplemental Material, provide the chance to directly interact with the devised spreadsheet before the user starts to construct his or her own spreadsheet.
Supplement
Spreadsheet examples are available .
*
 Download
Contents
  JCE2006p1879W.pdf
 
JCE2006p1879W.zip
Folder JCE2006p1879W containing JCE2006p1879W.doc (Microsoft Word) and nine spreadsheet files (Microsoft Excel)
More Information
*
Citation
Moreira, Luís; Martins, Filomena; Elvas-Leitão, Ruben. J. Chem. Educ. 2006 83 1879.
*
Keywords
Chemometrics; Computer-Based Learning; Graduate Education / Research; Kinetics; Laboratory Computing / Interfacing; Physical Chemistry; Problem Solving / Decision Making; Reactions; Solutions / Solvents; Student-Centered Learning; Upper-Division Undergraduate
*
History
Created:
Last Updated:
10/30/2006
11/7/2006
<< Previous Article Table of Contents Next Article >>
  Home > JCE Print > Journal of Chemical Education > Issues > 2006  > December  > Page 1879


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.