Learning Spreadsheet Tools: The Case of Temperature Dependent Molar Heat Capacity and Change in Molar Enthalpy
This paper presents a simple spread sheet tool to calculate a temperature dependent molar heat capacity and change in molar enthalpy from one temperature to another. It assumes a polynomial relationship between temperature and molar heat capacity and tabulates necessary data for seventy compounds. W...
Main Author: | |
---|---|
Format: | Article |
Language: | English |
Published: |
Bond University
|
Series: | Spreadsheets in Education |
Online Access: | http://sie.scholasticahq.com/article/4670-learning-spreadsheet-tools-the-case-of-temperature-dependent-molar-heat-capacity-and-change-in-molar-enthalpy.pdf |
id |
doaj-bcd0da4ef32a4b9d8afcf90c59a9c25c |
---|---|
record_format |
Article |
spelling |
doaj-bcd0da4ef32a4b9d8afcf90c59a9c25c2020-11-25T00:31:16ZengBond UniversitySpreadsheets in Education1448-6156Learning Spreadsheet Tools: The Case of Temperature Dependent Molar Heat Capacity and Change in Molar EnthalpyJeremy LewisThis paper presents a simple spread sheet tool to calculate a temperature dependent molar heat capacity and change in molar enthalpy from one temperature to another. It assumes a polynomial relationship between temperature and molar heat capacity and tabulates necessary data for seventy compounds. While being a great tool for simple energy balances, the paper provides a detailed step by step account of how the spreadsheet was made using Microsoft Excel®. It pays special attention to features utilized in the creation, including, FREEZE PANE, creating a list from tabulated data, VLOOKUP, IF and AND statements, conditional formatting, and locking cells.http://sie.scholasticahq.com/article/4670-learning-spreadsheet-tools-the-case-of-temperature-dependent-molar-heat-capacity-and-change-in-molar-enthalpy.pdf |
collection |
DOAJ |
language |
English |
format |
Article |
sources |
DOAJ |
author |
Jeremy Lewis |
spellingShingle |
Jeremy Lewis Learning Spreadsheet Tools: The Case of Temperature Dependent Molar Heat Capacity and Change in Molar Enthalpy Spreadsheets in Education |
author_facet |
Jeremy Lewis |
author_sort |
Jeremy Lewis |
title |
Learning Spreadsheet Tools: The Case of Temperature Dependent Molar Heat Capacity and Change in Molar Enthalpy |
title_short |
Learning Spreadsheet Tools: The Case of Temperature Dependent Molar Heat Capacity and Change in Molar Enthalpy |
title_full |
Learning Spreadsheet Tools: The Case of Temperature Dependent Molar Heat Capacity and Change in Molar Enthalpy |
title_fullStr |
Learning Spreadsheet Tools: The Case of Temperature Dependent Molar Heat Capacity and Change in Molar Enthalpy |
title_full_unstemmed |
Learning Spreadsheet Tools: The Case of Temperature Dependent Molar Heat Capacity and Change in Molar Enthalpy |
title_sort |
learning spreadsheet tools: the case of temperature dependent molar heat capacity and change in molar enthalpy |
publisher |
Bond University |
series |
Spreadsheets in Education |
issn |
1448-6156 |
description |
This paper presents a simple spread sheet tool to calculate a temperature dependent molar heat capacity and change in molar enthalpy from one temperature to another. It assumes a polynomial relationship between temperature and molar heat capacity and tabulates necessary data for seventy compounds. While being a great tool for simple energy balances, the paper provides a detailed step by step account of how the spreadsheet was made using Microsoft Excel®. It pays special attention to features utilized in the creation, including, FREEZE PANE, creating a list from tabulated data, VLOOKUP, IF and AND statements, conditional formatting, and locking cells. |
url |
http://sie.scholasticahq.com/article/4670-learning-spreadsheet-tools-the-case-of-temperature-dependent-molar-heat-capacity-and-change-in-molar-enthalpy.pdf |
work_keys_str_mv |
AT jeremylewis learningspreadsheettoolsthecaseoftemperaturedependentmolarheatcapacityandchangeinmolarenthalpy |
_version_ |
1725322768310861824 |