基于Excel的药物动力学求解程序在药物动力学教学中的应用

Application of a pharmacokinetics solving program based on Excel in pharmacokinetics teaching

为解决药物代谢动力学课程教学中的困境,本研究编制了基于Excel的药物动力学求解程序。该程序以使用最为广泛的数据处理软件Excel为平台,利用Excel的数据处理和画图功能,通过Excel-VBA封装成为程序,专用于药物动力学课程教学。该程序包括按照人民卫生出版社的《生物药剂学与药物动力学》第5版教材内药物动力学部分的教学内容编排的25个求解模板,每个求解模板都包含操作设置区、数据输入区、数据关系展示区、回归参数输出区、药物动力学参数输出区和图表区共6个功能区。在课程教学中重新组织教学内容,从一个案例出发,通过讲解如何应用该求解程序解决案例问题来教授药物动力学相关理念和知识。经过实践,教学效果得到了明显的提升。

To solve the problems in the course teaching of Pharmacokinetics and change the current situation of the course,a pharmacokinetic solution program based on Excel has been developed.The program,based on Excel,is the most widely used data processing software.The data processing and drawing functions of Excel are used and encapsulated as a program by Excel-VBA.The program is specially used in pharmacokinetic teaching,which includes 25 solution templates arranged according to the 5th edition of Biopharmaceutics and Pharmacokinetics,a textbook published by the People's Medical Publishing House Co.,LTD.Each solution template includes six functional areas:operation setting area,data input area,data relationship display area,return parameter output area,pharmacokinetic parameter output area and chart area.In this course,the teaching content is reorganized.Starting from a case,the concept and knowledge of pharmacokinetics are taught by explaining how to apply the program to solve case problems.After years of practice,the teaching effect has been significantly improved.