ERIC Number: EJ1453178
Record Type: Journal
Publication Date: 2023-Dec
Pages: 11
Abstractor: As Provided
ISBN: N/A
ISSN: ISSN-0021-9584
EISSN: EISSN-1938-1328
Available Date: N/A
Spreadsheet Methodology for the Calculation of Equilibrium Diagrams Including Precipitation Reactions and Formation of Mixed Ligand and Polynuclear Hydroxo Complexes
Journal of Chemical Education, v100 n12 p4663-4673 2023
Solution equilibria diagrams are excellent tools for understanding chemical speciation in multireaction chemical systems. They are usually plotted using software packages that efficiently perform advanced calculations, giving the possibility to graphically visualize thermodynamic and composition information. However, this approach frequently leaves the students with a poor understanding of the underlying theory. In this work, a simple method that uses extended Ringbom's side reaction coefficients, named the Method of Extended Ringbom's Coefficients (MERC), is proposed for plotting distribution and predominance diagrams using Excel, such that when the formation of mixed ligand and polynuclear species is considered, the mass balance equation is solved by applying a simple numerical recipe based on Newton-Raphson's technique using circular references. If precipitation reactions are considered, then a corrected conditional solubility is used to study chemical equilibria in saturated or unsaturated solutions, by simply using the IF conditional function of Excel. The wide scope of this methodology is shown by studying the speciation and analysis of the redox properties of the Cu(II)/Cu(I)/Cu system in aqueous media in the presence of ammonia, thiosulfate ions, and EDTA under different multibuffered conditions. Also, the learning achievements of two examples of the application of MERC in the classroom are discussed.
Descriptors: Chemistry, Scientific Concepts, Visual Aids, Spreadsheets, Computer Software, Technology Uses in Education, Science Instruction, Teaching Methods, Computation
Division of Chemical Education, Inc. and ACS Publications Division of the American Chemical Society. 1155 Sixteenth Street NW, Washington, DC 20036. Tel: 800-227-5558; Tel: 202-872-4600; e-mail: eic@jce.acs.org; Web site: http://pubs.acs.org/jchemeduc
Publication Type: Journal Articles; Reports - Descriptive
Education Level: N/A
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A
Author Affiliations: N/A