Excel在稀土萃取分离静态平衡教学中的应用——以单级萃取平衡为例  

The Application of Excel in the Teaching of Static Equilibrium of Rare Earth Extraction and Separation-Take Single-Stage Extraction Equilibrium as an Example

作　　者：黄金堤[1] 李静[1] 李明周[1] Huang Jindi;Li Jing;Li Mingzhou(Faculty of Materials Metallurgy and Chemistry,Jiangxi University of Science and Technology,Ganzhou 341000,China)

机构地区：[1]江西理工大学材料冶金化学学部,江西赣州341000

出　　处：《广东化工》2021年第20期288-289,284,共3页Guangdong Chemical Industry

基　　金：江西理工大学研究生“课程思政”建设项目(YKCSZ-2021-17);江西理工大学本科教学质量与教学改革工程建设项目(XZG-20-14-76,XJG-2020-39,XZG-18-14-86);江西省教学改革项目(JXJG-17-7-1)。

摘　　要：将信息化教学手段融入冶金工程专业的专业课程教学中,应用Excel软件并基于萃取平衡理论构建稀土萃取分离静态平衡关系,实现单级萃取槽的组分含量的准确计算,整个计算过程具有较好的操作性,给学生带来直观、简易的学习感官,帮助学生更深刻理解萃取平衡理论,并进一步引导学生构建问题到代码的逻辑思维体系,提高了学生自主学习能力,激发了学生解决复杂工程问题的应用创新意识。The information-based teaching method is integrated into the teaching of the professional courses of metallurgical engineering.The static equilibrium relationship of rare earth extraction and separation is constructed by using Excel software and based on the extraction equilibrium theory,so as to realize the accurate calculation of component content of extraction tank,and the whole calculation process has good operability.It brings students intuitive and simple learning senses,helps students more deeply understand and master the extraction balance theory,and further guide students to construct a logical thinking system from problem to code,improves students'autonomous learning ability and stimulates students'awareness of application innovation in solving complex engineering problems.

关 键 词：冶金工程 EXCEL 规划求解 萃取平衡 教学手段 

分 类 号：TF845[冶金工程—有色金属冶金]