利用Excel函数及VBA程序实现健康素养快速测评与学习

Using EXCEL Functions and VBA Program to Accomplish Assessment and Learning for Health Literacy

目的借助Excel软件快速完成健康素养监测的数据采集、测评,提供有针对性健康教育学习资料和健康素养分析结果。方法利用Excel中的函数和VBA编写程序,并结合实例资料进行验证。结果开发的程序可实现健康素养测评与学习功能,测评结果与R软件分析结果一致。结论应用自行编制的Excel VBA程序,可方便、快速、正确地实现健康素养快速测评与学习。

Objective Using Excel to complete the data collection and evaluate health literacy monitoring, in order to offer the health education materials and the analysis results of health literacy. Methods Function in Excel and programs in VBA were used in the study and validated using actual cases data. Results This program could realize health literacy assessment and learning, and the evaluation results were the same as those obtained with R software. Conclusion The EXCEL VBA programs can realize rapid and accurate assessment and learning for health literacy