Excel应用于膳食调查和评价教学的方法探讨

Discussion on the Methods of Applying Excel to Dietary Survey and Evaluation Teaching

目的:探索在膳食调查和评价教学中融合Excel应用的综合教学模式,提高学生对专业知识的理解和应用现代信息技术处理专业问题的能力。方法:以《中国食物成分表(第2版)》和膳食调查数据为数据源,引导学生用Excel201 3建立食物营养素计算模板;采用函数或公式方法进行数据处理。结论:通过使用Excel 2013快速有效完成食物营养成分的计算,有助于学生理解营养素的计算原理并更牢固掌握营养素的计算方法,为学习个体和群体营养状况评价奠定基础。

Objective:To explore the teaching method of simplifyingnutrients calculation in dietary survey,help students to understandspecialized knowledge well and improve students'abilityof using effective tools.Method:"China Food Composition(2ndEdition)"and a?set?of?dietary survey data were used as datasource,and Excel2013was used to create a template of nutrients'calculation by the students;functions or formulas were usedto processing data.Conclusion:Excel2013can complete nutrients'calculation quickly and efficiently,and it can help studentsto understand nutritional survey well.