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

Chen Huali; Zhang Liangke; Zhang Jingqing; Bai Yan

doi:10.3760/cma.j.cn116021-20210123-01268

您当前的位置：

首页 >

文章列表页 >

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

Teaching Reform | 更新时间：2023-06-08

- Application of a pharmacokinetics solving program based on Excel in pharmacokinetics teaching
- Chinese Journal of Medical Education Research Vol. 22, Issue 5, Pages: 660-664(2023)
- 作者机构：
  
  重庆医科大学药学院，重庆　400016
- 作者简介：
  
  Chen Huali, Email: chenhuali@cqmu.edu.cn
- 基金信息：
  
  The "14th Five-Year" Plan Program of Chongqing Academy of Education Science in 2021(2021-GX-308);Education and Teaching Research Project of Chongqing Medical University in 2020(JY200317);Education and Teaching Research Project of College of Pharmacy, Chongqing Medical University(YXJY1903)
- DOI：10.3760/cma.j.cn116021-20210123-01268
  CLC： R-05
- Published：20 May 2023，
  
  Received：23 January 2021，
扫描看全文
陈华黎, 张良珂, 张景勍, 等. 基于Excel的药物动力学求解程序在药物动力学教学中的应用[J]. 中华医学教育探索杂志, 2023, 22(5): 660-664.

Chen Huali, Zhang Liangke, Zhang Jingqing, et al. Application of a pharmacokinetics solving program based on Excel in pharmacokinetics teaching. [J]. Chinese Journal of Medical Education Research 22(5):660-664(2023)
陈华黎, 张良珂, 张景勍, 等. 基于Excel的药物动力学求解程序在药物动力学教学中的应用[J]. 中华医学教育探索杂志, 2023, 22(5): 660-664. DOI： 10.3760/cma.j.cn116021-20210123-01268.

Chen Huali, Zhang Liangke, Zhang Jingqing, et al. Application of a pharmacokinetics solving program based on Excel in pharmacokinetics teaching. [J]. Chinese Journal of Medical Education Research 22(5):660-664(2023) DOI： 10.3760/cma.j.cn116021-20210123-01268.

摘要

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

Abstract

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.

关键词

药物代谢动力学Excel药物动力学求解程序教学新方法

Keywords

PharmacokineticsExcelPharmacokinetic solution programNew teaching method

references

刘建平. 生物药剂学与药物动力学[M]. 5版. 北京：人民卫生出版社， 2016.

郭新红，张楠，胡玉荣，等. 《生物药剂学与药物动力学》教材部分内容编写建议[J]. 药学教育， 2021， 37（1）： 81-83. DOI: 10.16243/j.cnki.32-1352/g4.2021.01.019http://dx.doi.org/10.16243/j.cnki.32-1352/g4.2021.01.019.

王聪颖，李璐璐，庞榕. “生物药剂学与药物动力学”课程教学改革初探[J]. 广东化工， 2018， 45（17）： 222-223. DOI: 10.3969/j.issn.1007-1865.2018.17.110http://dx.doi.org/10.3969/j.issn.1007-1865.2018.17.110.

何华，郑啸，刘李，等. 基于应用型人才培养的药物代谢动力学实验课程改革[J]. 海峡药学， 2021， 33（2）： 105-107. DOI: 10.3969/j.issn.1006-3765.2021.02.036http://dx.doi.org/10.3969/j.issn.1006-3765.2021.02.036.

王丹，杨帆，孙灵灵，等. 基于不同软件的生理药动学模型构建[J].中国兽医杂志， 2015， 51（5）： 58-60. DOI： 10.3969/j.issn.0529-6005.2015.05.022http://dx.doi.org/10.3969/j.issn.0529-6005.2015.05.022.

杨亚群. 两款药动学软件处理二室模型血管外给药数据对比分析[J]. 中外医学研究， 2011， 9（17）： 144-145. DOI：10.3969/j.issn.1674-6805.2011.17.116http://dx.doi.org/10.3969/j.issn.1674-6805.2011.17.116.

周静超，刘春生，侯庆香，等. 常用药代动力学软件的应用概况[J].解放军药学学报， 2017， 33（2）： 176-179. DOI: 10.3969/j.issn.1008-9926.2017.02.019http://dx.doi.org/10.3969/j.issn.1008-9926.2017.02.019.

安英，徐博，任旷，等. Excel软件在磺胺嘧啶钠药动学参数测定实验中的应用[J].中国执业药师， 2015， 12（8）： 53-56. DOI： 10.3969/j.issn.1672-5433.2015.08.014http://dx.doi.org/10.3969/j.issn.1672-5433.2015.08.014.

袁进，石磊，赵树进. 基于Excel 函数求解血管外给药二室模型的药动学及隔室模型参数[J]. 中国药房， 2008， 19（2）： 106-108.

张勇，周建平，霍美蓉. 基于Excel 的药动学数据分析程序：PKSlover 1.0的编写和验证[J]. 数理医药学杂志， 2007， 20（1）：58-61. DOI: 10.3969/j.issn.1004-4337.2007.01.027http://dx.doi.org/10.3969/j.issn.1004-4337.2007.01.027.

Views

下载量

CSCD

Alert me when the article has been cited

提交

Tools

Publicity Resources

No data

Related Author

No data

Related Institution

No data

⁰