survey 调查表 双语版教案

Grade: 7 Subject: Computer

Length: 40 min Topic: `Survey Chart Software: Excel 2003 年级: 7 学科: 信息技术(计算机)

时间: 40 分钟题目: 调查表软件: Excel 2003

Survey Chart Auto Sum Chart Wizard topic design collect total 调查表自动求和图表向导题目设计收集总计

Computers Paper/Notebook Pen Samples of Survey

课程准备:

计算机(每2人一台) 笔记本钢笔调查表样例(基本样例,超越样例)

Students learn about how to gather information and how to make a survey based on different groups. Survey their classmates and use spreadsheets to organize and calculate the information.

课程说明:

本节课是Excel 2003的第二节课，本节课复习了第一节课地址簿中的数据输入，新知识点为：自动求和，图表向导的使用。同时本节课又为下一节课做了铺垫（预算表）。

1.Design the survey: topic, content, number of what you want to interview (male,

female). Draw your design on the paper/notebook.

2.Input all the information: words, numbers, pictures (exceed).

https://www.360docs.net/doc/5410363529.html,anize and calculate the information.(Auto sum)

4.Make a survey chart.

课程内容：

1、设计调查表：主题，内容，需要采访的数据，在纸上设计出调查表。

2、输入信息：文字、数字，图片（超越内容）等

3、组织和计算数据。（自动求和）

4、利用图表向导制作调查图表。

Knowledge and Technology:

1、Let the student remember the new vocabularies.

2、Students will learn how to collect the information that they need。

3、Students will master how to calculate the number with the Auto Sum

button.

4、Students will know how to make a chart with the Chart Wizard

button.

Process and Methods:

1、Solve the easier contents----Auto Sum, by the method of Team

Explore.

2、Do the Practice Activity of “Survey the most XX program”.

3、By means of Demonstrating，figure out the key point and

difficult point----make a chart.

4、The students complete the class mission with the knowledge of

new and old by the method of Mission Driven.

Attitudes and Values:

1、In order to get the real information by doing activities in class. In

order to have the good habits of getting the scientific data by

themselves in stead of thinking.

2、Train them in getting used to do things with computer.

3、Train them in group work and communicating with others.

课程目标（三维）：

知识与技能：

1、让学生记忆新的词汇。

2、学生要学会如何收集自己需要的信息。

3、学生要掌握如何利用自动求和功能对数据进行求和计算。

4、学会要知道如何使用图表向导功能制作图表。

过程与方法：

1、使用小组合作探究法解决本课中较简单的知识点----自动求和。

2、进行课堂实践活动—“调查最XX的家校联欢节目”。

3、通过演示法解决本课中的重点也是难点----制作图表。

4、使用任务驱动法让学生使用新旧技能完成课堂任务。

情感态度与价值观：

1、让学生在课堂上进行课堂实践活动，得到第一手的真实数据，让学

生养成利用科学方法得到数据的好习惯，摈弃主观臆造数据的方

法。

2、培养学生的信息技术素养，使其习惯于使用计算机来处理问题。

3、培养学生的小组协作，与他人交流沟通的能力。

1、Warm up(3 min)导入

We have appreciated our Parents-School Gala on the 1st of May, and we had a wonderful time together. Which program do you like best? Which one do you dislike? Which is the most creative program? Which program is most meaningful? We learned how to make a worksheet in Excel. Today we will make a Survey Chart. Design a survey about any topic that you are interested in.

我们在五一欣赏了家校联欢，共同度过了美妙的时刻，你最喜欢哪个节目？

最不喜欢哪个节目？哪个节目最有创意？哪个节目最 有意义？上次课我们学习了如何在Excel 中制作表格，今天我们将要学习调查图表，请选择一个题目，设计一个调查表。

2、 Show the example (2 min)展示样例 Teacher will show the example to the students, tell them how to collect the information.

教师展示调查表实例，告知学生如何收集信息。

3、Pair work ：Do the Practice Activity (5 min)小组合作 实践活动 Elements: topic, number of the people that you will interview, number of the boy, number of the girl.

元素：主题，采访的人数，男生人数，女生人数。 Activity: Students will use the programme to interview their classmates, write down the information that they get. Then organize the data ，make their survey on the notebook.

活动：学生使用节目单来采访同学，将得到的数据记录下来，然后总结归纳数据，在笔记本上画出调查表。

4、 Sum the data, learn by themselves (8 min)----key point

合计数据 自我探索

This knowledge is easier but important. The students can do it by themselves or by the demonstration of the student with strong skills.

Auto Sum

这个知识点简单但很重要。学生可以自己探索或者在计算机技能较好的学生的带领下完成。

自动求和

5、Make a survey chart (12 min) 制作调查图表

Show the sample, enlighten the students how to make a survey chart.

Draw it?

Let the smart Excel to create it? How to do it?

Teacher demonstrates the steps to make a survey chart by the Chart Wizard.

展示示例，启发学生思考如何制作图表。

画出来么？

让Excel软件来生成么？如何操作？

教师演示操作步骤。

All the groups make their own survey chart.

Give the following example. This is for the students with strong computer skills (exceeding example).

所有的小组开始制作自己的调查图表。

给出下面的示例。这个示例是为学有余力的学生准备的（超越范例）

6、Show the work（6 min）展示作品

One member of the group explains the work that they have made and the other member operates.

一个成员解说自己的作品，另一名成员操作。

Share your work，here is the content you should mention:

1. What’s your topic?

2. How many people did you interview (boy girl)?

3. Show your survey, explain it.

4. What skills do you like best? Why?

分享作品，这里是你分享时需要提到的内容：

1、调查表的主题是什么？

2、你各采访了多少人（男生、女生）？

3、你最喜欢其中的哪个操作技能？（自动求和、图表向导）为什么？

7、Homework（1 min）课下探究

Preview the budget.

预习预算表

8、Summary(3 min) 总结

Let the student tell what they have learned in this class.

让学生说出他们本节课学到的知识。

Assessment评价体系

From the students:

1.By themselves:

What is your favorite part of the survey? (What are you proud of?) What do you think can be better?

2.By other students:

Do you like it? Why or why not?

From teacher:

课堂情况记录：

1班：

2班：

3班：4班：5班：6班：Should work hard approaching exceeding

formative have not finished

their survey on

paper

have finished their

survey on paper

finished their survey on

paper well, add something

related to the topic

summative have not finished

their survey chart in

Excel

have finished their

survey chart in

Excel

finished their survey in Excel

well, adorned the chart(add

pictures, change the column's

color, change the text style)