worksheet讲义ppt
最新计算机应用基础windows7+office-第四章教学讲义ppt课件
任务1 创建员工信息表
5）清除单元格
“清除”下拉列表
任务1 制作员工信息表
3.数据输入与编辑
1）向单元格 输入数据的方法
2）不同类型数据 的输入
任务1 制作员工信息表
4.自动填充数据
1）用鼠标拖动实现数据的自动填充
选中一个单元格或单元格区域， 指向填充柄，当鼠标指针变成黑色 十字形状时按住鼠标左键不放，向 上、下、左、右4个方向进行拖动， 实现数据的填充。另外，按住Ctrl 键的同时拖动鼠标，也可以实现数 据的有序填充。
（1）删除单元格
（2）快速删除行 3）删除单元格、行或列
（3）快速删除列
任务1 创建员工信息表
4）移动和复制单元格
移动单元格是指将单元格中的数据移到目的单元格 中，原有位置留下空白单元格。复制单元格是指将单元 格中的数据复制到目的单元格中，原有位置的数据仍然 存在。
移动和复制单元格的方法基本相同，首先选定要移 动或复制数据的单元格，然后在“开始”选项卡的“剪贴板 ”组中单击“剪切”按钮或“复制”按钮，再选中目标位置处 的单元格，最后单击“剪贴板”组中的“粘贴”按钮，即可 将单元格的数据移动或复制到目标单元格中。
任务1 创建员工信息表
4）工作表的复制
工作表的复制是通过“移动或复制工作表”对话框来实现的。例 如，在“员工信息表.xlsx”工作簿文件中，要对工作表“宏发公司 员工信息表”进行复制，可以右击“宏发公司员工信息表”标签，在 弹出的快捷菜单中选择“移动或复制”命令，打开“移动或复制工作 表”对话框。在此对话框中，在“将选定工作表移至下列选定工作表 之前”列表框中选择Sheet3选项，再选中“建立副本”复选框，单击 “确定”按钮返回工作表。此时已复制一份“宏发公司员工信息表”在 Sheet3工作表之前，显示的工作表名称为“宏发公司员工信息表（ 2）”。
第5章 Worksheet(工作表)对象PPT
2020/3/15
11
3、使用ActiveSheet属性引用活动工作表
使用ActiveSheet属性可以返回当前活动工作 表
MsgBox
2020/3/15
12
工作表的添加与删除
在工作簿中添加工作表使用Add方法，语法如下
expression.Add(Before, After, Count, Type)
2020/3/15
6
2.2 使用工作表的编号
工作表编号（索引号）是指工作表在工作簿中的位 置，Excel根据工作表在工作表标签中的位置以1开始 从左向右进行编号。
Worksheets(1).Select 该代码选中并激活当前工作簿中第1个工作表
2020/3/15
7
使用Worksheet对象的Index属性可以返回工 作表的编号：
End Sub
2020/3/15
14
三、工作表的添加与删除
3.1、工作表对象的Delete方法删除指定的对象， 语法如下：
expression.Delete
参数expression是必需的，该表达式返回“应用于”列表 中的对象之一 例如：Sheet7.Delete
2020/3/15
15
3.2、工作表中插入行
在工作表的中插入空行，需要使用Insert方法
Sheet1.Rows(3).Insert 在sheet1的第2行和第3行之间插入一行空行
Worksheet 1
WorksheetsUnit 1 My First JobAnswers for Worksheet 1Answers for Worksheet 2Unit 2 American Homes and British HomesWorksheet 1NameAddress an envelope to your imaginary girl/boyfriend, using the following address information.1.Invent a full name for your friend (including both a first name and a last name).It might be fun to incorporate a “middle name” as well. American teenagers and college students would often write out their friends names with great flare and creativity. For example: Michael Joseph Steckler.2.Invent a reasonable address and country. (No fantasy places, such as the moonor Mars in the Galaxy). You can use the following:Country: U.S.A, Britain, Australia, Japan, New Zealand, Canada, etc.Province/State: New South Wales, New York, Ontario, Montana, etc.City: Toronto, Tokyo, Osaka, Seoul, Boston, London, Sydney, Hong Kong, Columbia Falls, etc.Postal code: ZP 21 D, 10034-2344, 59912, etc.Street Name and Number: 105 King’s Street, 2008 Thomason Boulevard, 991 FifthAvenue, 12 Garden Path, 45 Oxford Road, 225 Pine ValleyLoop, etc.3.Write your true home address in English.Address the following envelope. Be sure to put each part of the address in the right position.Worksheet 2NameRead the section of American Homes and find answers to the following questions.Suggested Points for Worksheet 2Worksheet 3NameRead the section of British Homes and find answers to the following questions.Suggested points for Worksheet 3Worksheet 4NameStudy the following chart and write your points of view in the appropriate boxes.Unit 3 What Is in a Name?Worksheet 1 NameFill in the blanks.Suggested points for Worksheet 1Worksheet 2 NameFill in the blanks.Suggested points for Worksheet 2Worksheet 3NameYour friend has found the following web page information and had it printed out for you. You decide to take the first step to protect your rights by completing this web page form.Thomason Billy LLPThomason Billy LLP has extensive experience in employment cases. There is no charge for this consultation and we hope we can help you.We accept cases on a contingency basis. We pay all trial preparation costs necessary to prosecute a case and are only paid if, and when, we are successful.All information will be kept confidential. We will respond to the email address you provide. If the address is inaccurate, we will not be able to contact you. Please double check your email address.If you need immediate help, call 800-815 4752.Tell Us Who You Are and How We Can Contact You.First NameLast NameNumber, Street & AptCity, Zip Code & StateDay Time PhoneEvening PhoneWhen did you first learn that you had been discriminated against?YYYY.MMM.DD (e.g. 2003.06.18)In what city, county and state/province did it happen?State the names & addresses of the offending party: Describe the events that you believeconstitute discrimination.If the information you have providedis complete, please press the Sendbutton below to send it to theThomason Billy LLP Law Firm. Ifyou wish to start over, press theClear All Fields button below andre-enter all information. Yourinformation will be keptconfidential.Please be aware that the transmissionof an email inquiry itself does notcreate an attorney-client relationship.Our firm can’t serve as your counselin any matter unless you and ourfirm expressly agree in writing thatwe serve as your attorney.Worksheet 4 NameSuggested points for Worksheet 4Unit 4 Doing Away with the King’s EnglishWorksheet 1 NameUnit 5 England as Seen by AmericansName1.Have you ever traveled to any city/town/village/county/countryother than the place you live in?2.If so, list at least three things in that other city, etc.,that you thinkare different from your own familiar culture. (E.g. ways of talking, ways of treating a stranger, ways of cooking, types ofentertainment, concerns, landscapes, city views, aspects ofarchitecture, business, etc.)3 Might you be biased against this unfamiliar culture? If so, why so; ifnot, why not?NameName1.What do the locals do when their friends or relatives get married?2.What do the locals do when a baby is born to a family?3.What do the locals do when their friends or relatives die? (Or: How dothe locals behave at a funeral?)NameSuggested points for Worksheet 4Unit 6 The First Day at SchoolWorksheet 1 NameWorksheet 2NameThink of at least three things that you would like to do during the coming winter vacation.Worksheet 3 NameSuggested points for Worksheet 3Worksheet 4NameCoping with learning difficultiesYou should respect me, including my learning difficultiesby a studentAccording to Richard, he experienced paralyzing shyness on his first day of school. His mind went blank when he was asked to write and speak before the class.Richard Wright was not the only child who showed paralyzingshyness in school. Many students experience different learningproblems. Here is a high school student, who tells us hisproblems in learning.1.“My mind often goes blank when asked to recite a text or astory before my fellow students.”2.“M y memory is terrible when it comes to rememberingnames or dates.”3.“The knowledge I learned is not accessible when I takeexaminations. So I am never happy with the results of mytests.”4.“I have difficulties remembering the schoolwork. And I oftenfail to check my notebook for the assignments I must do.”5.“I often find it difficult to concentrate on schoolwork.”What should I do to solve my problems? Please giveme some suggestions/advice.Unit 7 ComputersWorksheet 1Name1. What is the title of the book?2. What is the story/book about?3. Name a few features of the book that appeal to you.4. Name a few features of the book that annoy you when you were reading.Unit 8 The Missing MonarchsWorksheet 1NameSurprises! Surprises!! And Surprises!!!Work individually first1.Read the following surprises.a.John surprised everyone in the class when he suddenly stood up and shot out ofthe door.b.The class were surprised when asked to do a quiz.c.The students surprised their teacher by holding a party in celebration of herbirthday.2.I also want to plan a surprise for the class. Mmmm …,I’ve got an idea.SurprisesWhat is your idea of a possible surprise?Write it in the following blank.Work in your group3. Group workLet’s plan a surprise for the class/teacher/parents/ …Worksheet 2 NameWorksheet 3NameProtection of wildlife in our worldWhat is a habitat?Are there any wildlife habitats in China?Unit 9 The Risks of LifeWorksheet 1NameRead the following conversation and fill in A’s words.A: 8734059B: May I speak to Dr. Thomas Nelson?A: Speaking. May I ask who’s calling?B: This is Lee Ting, secretary at the Dean’s Office.A:B: I’m calling to inform you about some changes in our arrangements for next week.A:B: Well, first, the seminar will be moved to the law school Auditorium. And secondly, the time will be 3:00 pm on Monday instead of Tuesday. Will that be all right with you?A:B: Oh, by the way, the Dean wants to know if you have any special needs for facilities for your presentation.A:B: Ok, overhead projector, or PowerPoint projector. What about audio equipment?Do you want me to arrange a wireless microphone for you?A:B: Sure, we’ll put a microphone on the podium. Oh, and finally, we have to cancel the field visit because there really won’t be time for it.A:B: In that case, should I tell the Dean that you had really hoped to see the lab?A:B: Sure, I’ll let him know this first thing when he returns to the office.Worksheet 2NameList some things that you could do to help your classmate who cannot come to school for a week because of illness.What would you say to her/him on the phone?Write down possible sentences that you could say to her/him.Worksheet 3NameMy story of a good turn deserves anotherWorksheet 4 Name。
英语课堂教学中worksheet的设计与使用
浅谈英语课堂教学中worksheet的设计与使用摘要：本文以对话教学课和语篇教学课为载体，浅谈教师在课堂教学中应如何设计worksheet，以培养学生的语言运用能力，提升课堂教学实效性。
关键词：worksheet；课堂活动；活动设计中图分类号：g623.31 文献标志码：a 文章编号：1674-9324（2013）21-0053-02worksheet是指工作单、备忘录以及（学生的）活页练习题等。
学生完成的练习题或学习活动时用的辅助图片等都可以称为worksheet。
worksheet能为学生提供清晰和直观的视觉信息，因此在日常教学中被广泛运用。
教师可以利用worksheet引导学生进行知识的理解、巩固和练习等活动，使学生获得充分的听说训练，提高口语及书面表达能力，为在真实的语言情境中运用所学语言打下坚实的基础。
但有些教师在设计worksheet时只注重形式的多样性，而忽略了其有效性，导致worksheet的使用流于形式，不能充分激活学生的思维。
本文以对话教学课和语篇教学课为载体，结合实例，浅谈在小学英语课堂教学中如何设计与利用worksheet，培养学生的语言运用能力。
对话和篇章是语言输入的主要渠道。
教师在对话和篇章教学中利用worksheet帮助学生感知和理解学习内容，进而帮助学生顺利地输出语言。
一、呈现环节，利用worksheet帮助学生理解学习内容在教学pep小学英语六年级上册unit3blet’s talk时，教师依据对话的主要内容（正确作答以“where，what，when”引导的特殊疑问句），在顺利完成“let’s try”的内容后进行了如下设计。
首先，用ppt呈现worksheeet的内容（见图1）。
随后教师对学生说：just now we talked something about sarah.how about chenjie？let’s listen and finish the blank fillings：where？what？when？然后，学生听录音，听完后独立完成填空，而后师生一起校对答案。