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

Full description

Bibliographic Details
Main Author: Jeremy Lewis
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