Teaching Tools Made With Excel Spreadsheets to Study the Isothermal Process in an Ideal Gas  

作　　者：Ionel Grigore Gheorghe Dumitrescu Daniela Stoica Ionel Grigore;Gheorghe Dumitrescu;Daniela Stoica(High School Nichita Stanescu, Ploiesti, Romania;High School Toma N. Socolescu, Ploiesti, Romania;High School Ion Luca Caragiale, Ploiesti, Romania)

机构地区：[1]High School Nichita Stanescu, Ploiesti, Romania [2]High School Toma N. Socolescu, Ploiesti, Romania [3]High School Ion Luca Caragiale, Ploiesti, Romania

出　　处：《US-China Education Review(A)》2016年第7期423-432,共10页美中教育评论（A）

摘　　要：This paper demonstrates how Excel spreadsheets can be explored in order to analyze the isothermal process in an ideal gas. It describes three tools made with spreadsheets to facilitate students＇ understanding of the model of the ideal gas and the isothermal transformation. With the help of the first tool we can draw a comparison between the theoretical model which describes the isothermal process for an ideal gas and the experimental data in order to verify the Boyle-Mariotte law. With the help of the second tool we can analyze the isothermal process in an ideal gas by the graphic representation of the isotherm curve in the pressure-volume coordinates. This tool can also calculate, both analytically and numerically, the work exchanged by the gas with the external environment. The numerical calculation of the work is based on the geometrical interpretation of this measure in the pressure-volume coordinates. The third tool provides the comparison between the isothermal process and the adiabatic process in an ideal gas when both processes are characterized by the same initial state. The classroom utilization of these three tools develops students＇ skills in Excel for data manipulation to calculate certain thermodynamic measures and leads to the clarification of certain fundamentals concepts of thermodynamics, such as the isothermal transformation and the work. The numerical calculation of the work with the help of the facilities offered by the spreadsheet contributes to students＇ understanding of a key concept of definite integral calculus.

关 键 词：spreadsheets isothermal transformation Boyle-Mariotte law work in thermodynamics educational physics 

分 类 号：O414.1[理学—理论物理] G434[理学—物理]