Application of a pharmacokinetics solving program based on Excel in pharmacokinetics teaching
10.3760/cma.j.cn116021-20210123-01268
- VernacularTitle:基于Excel的药物动力学求解程序在药物动力学教学中的应用
- Author:
Huali CHEN
1
;
Liangke ZHANG
;
Jingqing ZHANG
;
Yan BAI
Author Information
1. 重庆医科大学药学院，重庆 400016
- Keywords:
Pharmacokinetics;
Excel;
Pharmacokinetic solution program;
New teaching method
- From:
Chinese Journal of Medical Education Research
2023;22(5):660-664
- CountryChina
- Language:Chinese
-
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.
