{"title":"简单方便的方法,让学生在Excel表格上开发动态模型","authors":"M. Kamata, Asuka Kamata","doi":"10.1515/cti-2020-0035","DOIUrl":null,"url":null,"abstract":"Abstract Radioactive decay is not only important in the field of radiochemistry but also useful as a teaching material for chemical kinetics. Although differential equations are often used to explain how decay rate changes over time, there are many students even in college or university who are not very good at mathematics and have difficulty in solving differential equations. Those students are expected to appreciate institutive and schematic illustrations using Excel sheets. In this paper, a water and tank model to demonstrate how radionuclides decay and decrease over time is presented as an example of the model that the students can develop or rearrange by themselves. Therefore, only four arithmetical operations were used in the sheet, so that the students can easily grasp the basic concept of a decay curve or radioactive equilibrium even if they do not have great knowledge of differential equations. In addition, only “Record Macro” and built in “Charts” were used on the sheet, and therefore, no knowledge or skill in graphic programming, such as Visual Basic, is needed to make and use the sheet. A brief online survey indicated the model was interesting to high school students. Since Excel is widely used all over the world, the sheets we have developed can be used in many countries without additional expense.","PeriodicalId":93272,"journal":{"name":"Chemistry Teacher International : best practices in chemistry education","volume":"4 1","pages":"61 - 70"},"PeriodicalIF":2.2000,"publicationDate":"2022-01-27","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Simple and easy way for students to develop a dynamic model on Excel sheet\",\"authors\":\"M. Kamata, Asuka Kamata\",\"doi\":\"10.1515/cti-2020-0035\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Abstract Radioactive decay is not only important in the field of radiochemistry but also useful as a teaching material for chemical kinetics. Although differential equations are often used to explain how decay rate changes over time, there are many students even in college or university who are not very good at mathematics and have difficulty in solving differential equations. Those students are expected to appreciate institutive and schematic illustrations using Excel sheets. In this paper, a water and tank model to demonstrate how radionuclides decay and decrease over time is presented as an example of the model that the students can develop or rearrange by themselves. Therefore, only four arithmetical operations were used in the sheet, so that the students can easily grasp the basic concept of a decay curve or radioactive equilibrium even if they do not have great knowledge of differential equations. In addition, only “Record Macro” and built in “Charts” were used on the sheet, and therefore, no knowledge or skill in graphic programming, such as Visual Basic, is needed to make and use the sheet. A brief online survey indicated the model was interesting to high school students. Since Excel is widely used all over the world, the sheets we have developed can be used in many countries without additional expense.\",\"PeriodicalId\":93272,\"journal\":{\"name\":\"Chemistry Teacher International : best practices in chemistry education\",\"volume\":\"4 1\",\"pages\":\"61 - 70\"},\"PeriodicalIF\":2.2000,\"publicationDate\":\"2022-01-27\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Chemistry Teacher International : best practices in chemistry education\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1515/cti-2020-0035\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"Q2\",\"JCRName\":\"EDUCATION, SCIENTIFIC DISCIPLINES\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Chemistry Teacher International : best practices in chemistry education","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1515/cti-2020-0035","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q2","JCRName":"EDUCATION, SCIENTIFIC DISCIPLINES","Score":null,"Total":0}
Simple and easy way for students to develop a dynamic model on Excel sheet
Abstract Radioactive decay is not only important in the field of radiochemistry but also useful as a teaching material for chemical kinetics. Although differential equations are often used to explain how decay rate changes over time, there are many students even in college or university who are not very good at mathematics and have difficulty in solving differential equations. Those students are expected to appreciate institutive and schematic illustrations using Excel sheets. In this paper, a water and tank model to demonstrate how radionuclides decay and decrease over time is presented as an example of the model that the students can develop or rearrange by themselves. Therefore, only four arithmetical operations were used in the sheet, so that the students can easily grasp the basic concept of a decay curve or radioactive equilibrium even if they do not have great knowledge of differential equations. In addition, only “Record Macro” and built in “Charts” were used on the sheet, and therefore, no knowledge or skill in graphic programming, such as Visual Basic, is needed to make and use the sheet. A brief online survey indicated the model was interesting to high school students. Since Excel is widely used all over the world, the sheets we have developed can be used in many countries without additional expense.