3.2.5 形成报告课堂实录及点评

幻灯片

1

Count函数语法：count(范围）Countif函数语法：countif(范围，条件）if函数语法：if（条件,条件为真输出值，为假输出值）

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

幻灯片

2

同学演示：同学1完成第9讲数据1、数据2中的数据统计；同学2完成第9讲找重复中数据统计。

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

幻灯片

3

表图表简单、直观、清晰、明了比较数据的“表”和“图表”的形式，你更喜欢哪种表达方式？

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

幻灯片

4

3.2表格数据的加工与表达3.2.4 利用图表呈现分析结果

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

幻灯片

5

确定数据来源选择图表类型数据标签格式

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

幻灯片

6

实作一：同学们完成“第10讲数据文件”中“示例”的饼形图设置。完成后抽取一名同学演示操作步骤。

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

幻灯片

7

常用图表类型及使用特点

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

幻灯片

8

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

幻灯片

9

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

幻灯片

10

图表类型使用特点擅长比较数据间的多少与大小关系柱形图条形图折线图饼形图擅长比较数据间的多少与大小关系（说明文字较多时使用）按时间轴表现数据的变化趋势适用于描述数据之间的比例分配关系P54表3-4

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

幻灯片

11

实作二在下发的第10讲数据文件中，对提供的数据进行图表转换，看一看不同的数据采用什么样的图表形式效果更好。

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

幻灯片

12

图表是将分析数据的结果表示出来的最有效的方法之一，但文本也是表达和组织信息的重要途径，两者相互结合起来才能将主题内容表达得更加清晰和直观。

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

幻灯片

13

评优活动分析报告参考图

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

幻灯片

14

根据数据图表的处理结果，配上相关的文字说明，做成简短的分析报告。——用图表和文字说明结合的方式更能阐述清楚想表达的内容。

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

幻灯片

15

实作三：参考评优活动分析报告，每位同学在数据文件中任选一任务，确定合适的图表，再依据图表分析结果，制作出分析报告。并提交到老师的邮箱中。邮件说明：收件邮箱：285209547@qq.com主题：第10讲+学号例如：3班13号的主题应为：第10讲190313附件：数据文件以附件形式发送。

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

幻灯片

16

通过这节课，同学们体验了表格信息加工与处理的过程，最终形成科学的分析报告，从而提炼出所需要的信息，以便我们对此做出有效的判断和决策。也希望同学们把这种处理和分析的能力运用于我们的学习和生活中，帮助解决学习生活中遇到的问题。

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________