问题 问答题 案例分析题

课题:公式的使用(选自初中第四册Excel部分)内容:Excel计算公式的使用某教师撰写了如下教学目标:(一)知识与技能(1)掌握相对地址及绝对地址的含义。(2)掌握公式的组成部分。(3)掌握公式的组成及其输入。(4)掌握公式计算及SUM函数。(5)掌握相对地址及绝对地址的引用。(二)情感态度与价值观培养协作精神。要求:(1)根据新课程理念和要求,重新设计教学目标,教学目标要具体、明确、可评价,行为动词使用恰当。(2)确定教学重点和难点。(3)简述本节课你选择的教学方法,并简单陈述理由。(4)结合本节课所提供的内容,说出几种常用的教材处理方法。

答案

参考答案:

(1)教学目标①通过使用公式进行表格单元的计算,使学生在公式中引用单元格地址,了解相对地址与绝对地址的作用:②知道公式的组成及输入方法,学会使用公式进行简单的计算;③通过小组协作学习,促进学生养成相互交流、协作的习惯。

(2)教学重点:公式的组成、单元格地址的引用。教学难点:相对地址与绝对地址的使用。

(3)使用小组协作法、任务驱动教学法、演示教学法等方法中的若干种,不宜过多。理由略。

(4)教材处理:补充增加、合并或分解、调整顺序、弱化和删除等等。如本节课可增加运算符的简单知识,将SUM函数调整到后面等。

完形填空

Recently a group of second-graders visited our school library to work on a “holidays around the world” project. The children created pictures showing holiday customs and then created voice recordings explaining what they drew.    小题1:   Now imagine taking things one step further and creating Podcasts in a classroom setting.

The term Podcast refers to an audio recording, linked to the Web, that can be downloaded to a personal MP3 player. The word is created from broadcast and from iPod—the wildly popular MP3 player from Apple.

Using audio with students isn’t new, of course. Teachers have used audiobooks at listening centers and recorded student voice on tape or CD for many years.    小题2:   Podcasts, however, can reach a much wider audience in a time frame outside the school days. Booktalking, an old way of getting kids excited about books, gets a tech assistance with Podcasting. Students can do some booktalking themselves; book review Podcasts seem to be another natural way for students to share what they know, providing an alternative to the book report.

 小题3:  Teachers made audio Podcasts, including visuals or video clips for any content area instruction and review. Some teachers have begun to record themselves teaching important concepts; this creates an account of information online for kids to access when they’re stuck on a homework assignment.   小题4:   Imagine being a classroom teacher in September who can actually hear how his or her students were reading in June the school year before.

You don’t need an iPod to make a Podcast.    小题5:  While an MP3 player is a popular and useful gadget, your audience doesn’t need MP3 players to listen, either. Your students and their families can use the computer to play back what you’ve recorded.

A.Audio and video files can also function as assessment tools.

B.It is clearly showed in the incident that student-created voice recordings are effective.

C.Podcasting is of vital importance to the classroom setting.

D.Podcasting is used for various excellent reasons.E. You can make a Podcast if you have a computer, a microphone, and some free software.

F. Podcasting needs a variety of devices.

G. Voice and music have been seen as the original media for teaching.

单项选择题 B1型题