Prev. Article Next Article Table of Contents

Article

Analysis with Microelectrodes Using Microsoft Excel Solver

Citing Articles

Your current credentials do not allow retrieval of the full text.

Purchase the full-text

PDF/HTML,
figures/images,
references and tables,
(where available)

Enda Howard and John Cassidy

Department of Chemistry, Dublin Institute of Technology, Kevin Street, Dublin 8, Ireland

J. Chem. Educ., 2000, 77 (3), p 409

DOI: 10.1021/ed077p409

Publication Date (Web): March 1, 2000

Section:

History, Education, and Documentation

Abstract

The use of curve fitting for the analysis and interpretation of voltammetric data obtained while working with microelectrodes is discussed as a useful exercise for introducing students to the principle of problem solving using least-squares curve-fitting techniques. The advantages associated with this approach to data processing over the approach where the limiting current (i, _L) alone is used are discussed and its limitations are highlighted.

This technique was applied to the determination of unknown concentrations of ferrocyanide and the most satisfactory recovery of concentrations was found when both the values of the formal potential (E ^0Â¢ ) and concentration (C) were varied to match the experimental results with an equation characterizing the current potential curve for a reversible couple. In this case recoveries of 100% Â± 5% were obtained for the concentration range 5 x 10^-4 to 1 x 10^-2 M. It was also found that Solver was unable to fit the equation when the sum of squared residuals was <2 x 10^-9. This technique can be generalized for use with a number of other electrochemical experiments such as polarography, rotating disk electrochemistry, and normal pulse polarography.

Keywords (Audience):

Second-Year Undergraduate

Keywords (Domain):

Analytical Chemistry

Keywords (Feature):

Computer Bulletin Board

Keywords (Pedagogy):

Computer-Based Learning

Keywords (Subject):

Electrochemistry

View: Hi-Res PDF | PDF w/ Links

Citing Articles

Citation data is made available by participants in CrossRef's Cited-by Linking service. For a more comprehensive list of citations to this article, users are encouraged to perform a search in SciFinder.

This article has been cited by 3 ACS Journal articles (3 most recent appear below).

Improving Chemistry Education by Offering Salient Technology Training to Preservice Teachers. A Graduate-Level Course on Using Software To Teach Chemistry
Daniel C. Tofan
Journal of Chemical Education2009 86 (9), 1060
- Improving Chemistry Education by Offering Salient Technology Training to Preservice Teachers. A Graduate-Level Course on Using Software To Teach Chemistry
  Daniel C. Tofan
  Journal of Chemical Education2009 86 (9), 1060
  This paper describes an upper-level undergraduate and graduate-level course on computers in chemical education that was developed and offered for the first time in Fall 2007. The course provides future chemistry teachers with exposure to current software ...
  Abstract | Hi-Res PDF | PDF w/ Links
Design of an Excel Spreadsheet To Estimate Rate Constants, Determine Associated Errors, and Choose Curve's Extent
Ruben Elvas-Leitão , Luís Moreira and Filomena Martins
Journal of Chemical Education2006 83 (12), 1879
- Design of an Excel Spreadsheet To Estimate Rate Constants, Determine Associated Errors, and Choose Curve's Extent
  Ruben Elvas-Leitão , Luís Moreira and Filomena Martins
  Journal of Chemical Education2006 83 (12), 1879
  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 ...
  Abstract | Hi-Res PDF | PDF w/ Links
C-SNARF-1 as a Fluorescent Probe for pH Measurements in Living Cells: Two-Wavelength-Ratio Method versus Whole-Spectral-Resolution Method
A-C. Ribou , J. Vigo and J-M. Salmon
Journal of Chemical Education2002 79 (12), 1471
- C-SNARF-1 as a Fluorescent Probe for pH Measurements in Living Cells: Two-Wavelength-Ratio Method versus Whole-Spectral-Resolution Method
  A-C. Ribou , J. Vigo and J-M. Salmon
  Journal of Chemical Education2002 79 (12), 1471
  Measuring intracellular concentrations of ions (H+, Ca2+, Mg2+) is one of the challenges of modern cell biology. Fluorescence techniques can be used for this purpose since they are noninvasive, specific, and in general sensitive enough to require only low ...
  Abstract | Hi-Res PDF | PDF w/ Links