RESUMO
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.