课程名 所属学 Analytical Chemistry 称 科 药学 教材名 Fundamentals of Analytical Chemistry,by Douglas Skoog Stanley Crouch,International Edition, 授课年 第三学 称 2013 级 期 授课章 授课时 CH3 Using Spreadsheets in Analytical Chemistry 100分钟 节 间 一、教学目标：含知识目标、技能（能力）目标 1.知识目标： (1)Grasp the basic unit in Microsoft spreadsheet (2)Grasp the basic calculation in spreadsheet 2.技能（能力）目标： (1)Learn interfaces of Microsoft spreadsheet (2)Improve the skills in listening and speaking English in Pharmaceutical Sciences (3)Be able to use spreadsheet for calculation 二、 授课内容（依据教学大纲）及时间分配
课程名 称 Analytical Chemistry 所属学 科 药学 教材名 称 Fundamentals of Analytical Chemistry, by Douglas Skoog Stanley Crouch, International Edition, 2013 授课年 级 第三学 期 授课章 节 CH3 Using Spreadsheets in Analytical Chemistry 授课时 间 100 分钟 一、教学目标：含知识目标、技能（能力）目标 1．知识目标： (1) Grasp the basic unit in Microsoft spreadsheet (2) Grasp the basic calculation in spreadsheet 2.技能（能力）目标： (1) Learn interfaces of Microsoft spreadsheet (2) Improve the skills in listening and speaking English in Pharmaceutical Sciences (3) Be able to use spreadsheet for calculation 二、授课内容（依据教学大纲）及时间分配
3A Keeping Records and Making Calculations 50 min 3B More Complex Examples 三、教学重点与难点 1.教学重点 (1)The calculations in complex examples (2)Data recording in spreadsheet 2.教学难点 Practice using spreadsheet 四、教学方法选择 1.理论课堂教学 A.多媒体教学：（简要列出本章节多媒体教学设计特点及优势） (1)The basic theory and analysis principle are taught by teaching method and practice (2)Review the major concepts and materials covering the chapters (3)Test could push students usually
3A Keeping Records and Making Calculations 50 min 3B More Complex Examples 三、教学重点与难点 1．教学重点 (1) The calculations in complex examples (2) Data recording in spreadsheet 2.教学难点 Practice using spreadsheet 四、教学方法选择 1.理论课堂教学 A.多媒体教学：（简要列出本章节多媒体教学设计特点及优势） (1) The basic theory and analysis principle are taught by teaching method and practice (2) Review the major concepts and materials covering the chapters (3) Test could push students usually
B.互动教学：（根据实际情况列出案例/实例时论、分析讨论、分组讨论、翻转课堂等互动教学内容标题） (1)Ask questions during case studies before and after introducing basic concepts (2)Students must take a PC and practice the calculation on it (3)Solve problems together with students 2.实验课教学 No applicable. 五、更新或补充内容提要 课后总结：按照实际进度对知识点分详略进行讲解 Emphasize the key concept and adjust the amount of materials in each section 六、复习思考题 1.Describe the use of the following Excel functions after reading about them in the Excel help facility. (a)SQRT:(b)AVERAGE;(c)PI:(d)FACT:(e)EXP;(f)LOG
B.互动教学：（根据实际情况列出案例/实例讨论、分析讨论、分组讨论、翻转课堂等互动教学内容标题） (1) Ask questions during case studies before and after introducing basic concepts (2) Students must take a PC and practice the calculation on it (3) Solve problems together with students 2.实验课教学 No applicable. 五、更新或补充内容提要 课后总结：按照实际进度对知识点分详略进行讲解 Emphasize the key concept and adjust the amount of materials in each section 六、复习思考题 1. Describe the use of the following Excel functions after reading about them in the Excel help facility. (a) SQRT; (b) AVERAGE; (c) PI; (d) FACT; (e) EXP; (f) LOG
2.There are many ways to document the worksheet entries and calculations.Use a search engine to find some of these methods, and describe them in detail using a worksheet example. 七、学习资源、课外自主学习参考 (可以列出供学生进一步学习、拓展本章节内容的网站、著作、期刊的名称及内容等) 1.Analytical Chemistry,by Jessica Carol,NY Research Press,2016 2.Analytical Chemistry (7th Edition),by Gary D.Christian,Purnendu K.Dasgupta,and Kevin A.Schug,Wiley,2013 3.Analytical Chemistry,by Frederic P Miller,Agnes F Vandome,John McBrewster,Alphascript Publishing,2009 4.Analytical Chemistry,by Seamus P J Higson,OUP Oxford,2003 苏州大学医学部药学院授课教案 授课教师：李笃信授课日期：2020年09月14日 课程名 所属学 Analytical Chemistry 称 科 药学 教材名 Fundamentals of Analytical Chemistry,by Douglas Skoog Stanley Crouch,International Edition, 授课年 第三学 称 2013 级 期 授课章 授课时 CH4 Calculations Used in Analytical Chemistry 100分钟 节 间
2. There are many ways to document the worksheet entries and calculations. Use a search engine to find some of these methods, and describe them in detail using a worksheet example. 七、学习资源、课外自主学习参考 (可以列出供学生进一步学习、拓展本章节内容的网站、著作、期刊的名称及内容等) 1. Analytical Chemistry, by Jessica Carol, NY Research Press, 2016 2. Analytical Chemistry (7th Edition), by Gary D. Christian, Purnendu K. Dasgupta, and Kevin A. Schug, Wiley, 2013 3. Analytical Chemistry, by Frederic P Miller, Agnes F Vandome, John McBrewster, Alphascript Publishing, 2009 4. Analytical Chemistry, by Séamus P J Higson, OUP Oxford, 2003 苏州大学医学部药学院授课教案 授课教师：李笃信授课日期：2020 年 09 月 14 日 课程名 称 Analytical Chemistry 所属学 科 药学 教材名 称 Fundamentals of Analytical Chemistry, by Douglas Skoog Stanley Crouch, International Edition, 2013 授课年 级 第三学 期 授课章 节 CH4 Calculations Used in Analytical Chemistry 授课时 间 100 分钟
一、教学目标：含知识目标、技能（能力）目标 1.知识目标： (1)Grasp the basic unit of measurement (2)Understand the solution preparation and their concentration 2.技能（能力）目标： (1)Learn basic English terms in calculations used in analytical chemistry (2)Improve the skills in listening and speaking English in Pharmaceutical Sciences (3)Be able to prepare required solutions 二、授课内容（依据教学大纲）及时间分配 4A Some Important Units of Measurement 20min 4B Solutions and Their Concentrations 30min 4CChemical Stoichiometry 50min 三、教学重点与难点
一、教学目标：含知识目标、技能（能力）目标 1．知识目标： (1) Grasp the basic unit of measurement (2) Understand the solution preparation and their concentration 2.技能（能力）目标： (1) Learn basic English terms in calculations used in analytical chemistry (2) Improve the skills in listening and speaking English in Pharmaceutical Sciences (3) Be able to prepare required solutions 二、授课内容（依据教学大纲）及时间分配 4A Some Important Units of Measurement 20min 4B Solutions and Their Concentrations 30min 4CChemical Stoichiometry 50min 三、教学重点与难点