Curve Fitting, Linear Algebra, and Solver in an Analytical Chemistry Course: A Facile and Safe Activity Suitable for the Classroom Setting,Journal of Chemical Education

当前位置： X-MOL 学术 › J. Chem. Educ. › 论文详情

Our official English website, www.x-mol.net, welcomes your feedback! (Note: you will need to create a separate account there.)

Curve Fitting, Linear Algebra, and Solver in an Analytical Chemistry Course: A Facile and Safe Activity Suitable for the Classroom Setting
Journal of Chemical Education ( IF 2.5 ) Pub Date : 2020-03-11 , DOI: 10.1021/acs.jchemed.9b00421
Jesse Maccione ₁ , Joseph Welch ₁ , Emily C. Heider ₂

Affiliation

Undergraduate analytical chemistry courses emphasize fundamental stoichiometric and physicochemical analytical techniques with statistical analysis and linear calibrations. Higher-level data analysis techniques may not be included in the college junior-level curriculum, but widely available software enables more complex analysis to be accessible. In this work, activities to train students in multicomponent spectral curve fitting (using Microsoft Excel’s Solver) and utilizing matrix algebra were incorporated within a large-enrollment undergraduate analytical chemistry lecture setting. When analyzing multiple compounds in solutions without separation pretreatment, both curve-fitting and classical matrix approaches are valuable techniques for students to understand and execute using commercially available software. When hands-on activities, multimedia screencasts, and in-class data collection and analysis were implemented, students were trained to employ these advanced analysis methods. The efficacy of the in-class practical activities was assessed with pre- and post-test instruments that quantified gains in learning outcomes. Inclusion of such activities will empower students with an expanded repertoire of these important analytical methods and their applications with a real world, portable, active-learning approach that can be completed in a lecture setting with nonhazardous samples.

中文翻译：

分析化学课程中的曲线拟合，线性代数和求解器：适合课堂设置的灵活且安全的活动

本科分析化学课程着重于基本的化学计量和物理化学分析技术以及统计分析和线性校准。较高级的数据分析技术可能未包含在大学初中课程中，但是广泛使用的软件使更复杂的分析变得可访问。在这项工作中，针对学生进行多组分光谱曲线拟合（使用Microsoft Excel的Solver）和矩阵代数训练的活动已纳入大批本科生分析化学讲义中。在不进行分离预处理的情况下分析溶液中的多种化合物时，曲线拟合和经典矩阵方法都是学生使用商业软件了解和执行的有价值的技术。当动手活动时，实施了多媒体截屏，并进行了课堂数据收集和分析，并训练了学生使用这些高级分析方法。课前实践活动的有效性通过测试前和测试后的工具进行了评估，这些工具可以量化学习成果的收益。包含此类活动将使学生能够利用现实世界中的便携式，主动学习方法扩展这些重要的分析方法及其应用的范围，这些方法可以在无害样品的授课环境中完成。

更新日期：2020-04-24

点击分享查看原文

点击收藏

阅读更多本刊最新论文本刊介绍/投稿指南11