Employing Spreadsheets for Applying Calculus in Upper-Level Chemistry Courses,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.)

Employing Spreadsheets for Applying Calculus in Upper-Level Chemistry Courses
Journal of Chemical Education ( IF 2.5 ) Pub Date : 2018-08-14 00:00:00 , DOI: 10.1021/acs.jchemed.8b00193
Paul D. Cooper ₁

Affiliation

This article describes the use of a spreadsheet to reinforce basic calculus that is expected of all university-level chemistry majors. The example provided shows a calculation using Excel to estimate, using a Riemann summation, the radiant exitance of a hot object using Planck’s Law of Blackbody Radiation. The approach reinforces the elementary calculus topic of integrating an area under a curve in an applied chemistry setting and, additionally, requires students to understand how units propagate through integrals in order to calculate correct numerical values. This manual calculation in Excel is pedagogically more satisfying than using black-box type software to calculate areas under curves, and is widely available to almost all students through the use of Excel (or similar spreadsheets software packages).

中文翻译：

使用电子表格在高级化学课程中应用微积分

本文介绍了使用电子表格来增强所有大学级化学专业学生所期望的基本演算的方法。所提供的示例显示了使用Excel进行的计算，该计算通过Riemann求和使用普朗克黑体辐射定律估算热物体的辐射出射。该方法强化了在应用化学设置中对曲线下的区域进行积分的基本演算主题，此外，还要求学生了解单位如何通过积分传播以计算正确的数值。与使用黑匣子类型的软件计算曲线下的面积相比，Excel中的这种手动计算在教学上更加令人满意，并且通过使用Excel（或类似的电子表格软件包），几乎所有学生都可以使用它。

更新日期：2018-08-14

点击分享查看原文

点击收藏

公开下载

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