Excel在化工分离工程教学中的应用——以流率加和法为例  

The Application of Excel in the Teaching of Chemical Separation Engineering——Take Sum-rates Method as an Example

作　　者：贺楚华[1] 侯三英 姚陈 史浪 杜可杰[1] He Chuhua;Hou Sanying;Yao Chen;Shi Lang;Du Kejie(School of Chemistry and Chemical Engineering,University of South China,Hengyang 421001,China)

机构地区：[1]南华大学化学化工学院,湖南衡阳421001

出　　处：《广东化工》2021年第11期187-188,共2页Guangdong Chemical Industry

基　　金：湖南省普通高等学校教学改革研究项目(湘教通[2018]436-325);教高厅函[2019]46号省级一流本科专业建设点(南华大学化学工程与工艺)。

摘　　要：在化工分离工程教学中,应用Excel软件采用流率加和法对多组分吸收过程进行严格计算,快捷、简便,计算结果准确,学生无需编程就能进行复杂的多组份多级分离严格计算,激发了学生的学习兴趣,提高了学生解决复杂工程问题的能力。In the teaching of chemical separation engineering, Excel software was used to calculate the multi-component absorption process strictly by using sum-rates method, which was fast, simple and accurate. Students could carry out complex multi-component and multistage separation calculation without programming, which could stimulate students’ interest in learning and improve their ability to solve complex engineering problems.

关 键 词：化工分离工程 EXCEL 多组分吸收 流率加和法 

分 类 号：G642.0[文化科学—高等教育学] TQ028.31[文化科学—教育学]