Understanding Solubility through Excel Spreadsheets

Pamela Brown
Chemical Technology Program, New York City Technical College, 300 Jay Street, Brooklyn, NY 11201
J. Chem. Educ., 2001, 78 (2), p 268
DOI: 10.1021/ed078p268
Publication Date (Web): February 1, 2001

Abstract

This article describes assignments related to the solubility of inorganic salts that can be given in an introductory general chemistry course. Le Châtelier's principle, solubility, unit conversion, and thermodynamics are tied together to calculate heats of solution by two methods: heats of formation and an application of the van't Hoff equation. These assignments address the need for math, graphing, and computer skills in the chemical technology program by developing skill in the use of Microsoft Excel to prepare spreadsheets and graphs and to perform linear and nonlinear curve-fitting. Background information on the value of understanding and predicting solubility is provided.

Keywords (Audience):

First-Year Undergraduate / General

Keywords (Domain):

Inorganic Chemistry

Keywords (Feature):

Computer Bulletin Board

Keywords (Pedagogy):

Computer-Based Learning

Keywords (Subject):

Aqueous Solution Chemistry

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).

  • Cover Image

    “Gone” into Solution: Assessing the Effect of Hands-On Activity on Students’ Comprehension of Solubility

    Laura B. Bruck and Aaron D. Bruck, Amy J. Phelps
    Journal of Chemical Education2010 87 (1), 107-112
    • “Gone” into Solution: Assessing the Effect of Hands-On Activity on Students’ Comprehension of Solubility

      Laura B. Bruck and Aaron D. Bruck, Amy J. Phelps
      Journal of Chemical Education2010 87 (1), 107-112

      Solubility is challenging for many general chemistry students, and the interactions of aqueous species are difficult to conceptualize. Derived from the pedagogies of Johnstone, Bloom, and Piaget, our primary research questions probe whether students’ ...

  • Cover Image

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

  • Cover Image

    An Aquatic Chemistry Spreadsheet for General Chemistry Classes

    Chulsung Kim
    Journal of Chemical Education2003 80 (11), 1351
    • An Aquatic Chemistry Spreadsheet for General Chemistry Classes

      Chulsung Kim
      Journal of Chemical Education2003 80 (11), 1351

      The Aquatic Chemistry Spreadsheet was produced to help students work through the activities of producing a graph of a titration curve, a distribution diagram, and buffer intensity as a function of pH. These activities help students better understand acid–...

Tools

SciFinder Links

SciFinder subscribers:  Click to sign in | Not a SciFinder subscriber? Learn more at www.cas.org

Explore by:


History

  • Received: August 03, 2009

Recommend & Share

  • Share on ACS NetworkACS Network
  • Add to FacebookFacebook
  • Tweet ThisTweet This
  • Add to CiteULikeCiteULike
  • Add to NewsvineNewsvine
  • Digg ThisDigg This
  • Add to DeliciousDelicious

Related Content