ࡱ>  #` Bbjbj5G5G W-W-9< < < < t ^^^t_p` bc^"d"d"de< =pArtvvvvvv$hwx EsdeEsEs< < "d"d4eueueuEsj< 8"d "dteuEsteueuRt  j"db  l^sv&N<t%tjjF EsEseuEsEsEsEsEstjEsEsEsEsEsEsEs $$#$HAd $#HA < < < < < <  Microsoft Office Integration 2007 Integrating Office 2007 Applications and the World Wide Web A Guide to this Instructors Manual: We have designed this Instructors Manual to supplement and enhance your teaching experience through classroom activities and a cohesive chapter summary. This document is organized chronologically, using the same heading in red that you see in the textbook. Under each heading you will find (in order): Lecture Notes that summarize the section, Figures and Boxes found in the section, if any, Teacher Tips, Classroom Activities, and Lab Activities. Pay special attention to teaching tips, and activities geared towards quizzing your students, enhancing their critical thinking skills, and encouraging experimentation within the software. In addition to this Instructors Manual, our Instructors Resources CD also contains PowerPoint Presentations, Test Banks, and other supplements to aid in your teaching experience. For your students: Our latest online feature, CourseCasts, is a library of weekly podcasts designed to keep your students up to date with the latest in technology news. Direct your students to  HYPERLINK "http://coursecasts.course.com/" http://coursecasts.course.com, where they can download the most recent CourseCast onto their mp3 player. Ken Baldauf, host of CourseCasts, is a faculty member of the Florida State University Computer Science Department where he is responsible for teaching technology classes to thousands of FSU students each year. Ken is an expert in the latest technology and sorts through and aggregates the most pertinent news and information for CourseCasts so your students can spend their time enjoying technology, rather than trying to figure it out. Open or close your lecture with a discussion based on the latest CourseCast. Table of Contents HYPERLINK \l "_Chapter_Objectives"Chapter Objectives HYPERLINK \l "_Chapter_Objectives" 1HYPERLINK \l "_INT_2:_Introduction_1"INT 2: Introduction HYPERLINK \l "_INT_2:_Introduction_1" 2HYPERLINK \l "_EX_5:_Project_One Worksheet with "INT 2: Project Integrating Office 2007 Applications and the World Wide Web HYPERLINK \l "_EX_5:_Project_One Worksheet with " 2HYPERLINK \l "_EX_6:_Starting_Excel"INT 5: Adding Hyperlinks to a Word DocumentHYPERLINK \l "_EX_6:_Starting_Excel"2HYPERLINK \l "_EX_9:_The_Excel worksheet"INT 13: Embedding an Excel Chart into a Word DocumentHYPERLINK \l "_EX_9:_The_Excel worksheet"3HYPERLINK \l "_EX_11:_Worksheet_window"INT 19: Viewing the Word Document in Your Browser and Saving It as a Web PageHYPERLINK \l "_EX_11:_Worksheet_window"4HYPERLINK \l "_EX_13:_Selecting_a cell"INT 23: Creating a PowerPoint Presentation Web PageHYPERLINK \l "_EX_13:_Selecting_a cell"4HYPERLINK \l "_INT_28:_Creating_a Web Page from an"INT 28: Creating a Web Page from an Access ReportHYPERLINK \l "_EX_16:_Entering_text"5HYPERLINK \l "_EX_21:_Entering_numbers"INT 38: Testing the Web SiteHYPERLINK \l "_EX_21:_Entering_numbers"5HYPERLINK \l "_End_of_Chapter_Material"End of Chapter MaterialHYPERLINK \l "_End_of_Chapter_Material"5HYPERLINK \l "_Glossary_of_Key_Terms"Glossary of Key Terms HYPERLINK \l "_Glossary_of_Key_Terms" 7 Chapter Objectives Students will have mastered the material in Chapter One when they can: Integrate the Office 2007 applications to create a Web site Add hyperlinks to a Word document Embed an Excel chart into a Word document Add a hyperlink to a PowerPoint slide Create Web pages from a PowerPoint presentation Add a hyperlink to an Access report Create a Web page from an Access report Test a Web site in a browser INT 2: Introduction LECTURE NOTES Define and discuss Integration and the four common usages in information technology CLASSROOM ACTIVITIES Class Discussion: Ask students to write down a list of things that come to mind when they hear the term, Integration. Have them share and discuss their ideas with the class. INT 2: Project Integrating Office 2007 Applications and the World Wide Web LECTURE NOTES Review the Makin-It Real Estate Company project Use Figures 1-1a through 1-1g to illustrate the tasks required to complete the project FIGURES: 1-1a, 1-1b, 1-1c, 1-1d, 1-1e, 1-1f, 1-1g TEACHER TIPS Make sure the four files from Figure 1-1 are accessible to the students. They will need a Word document, an Excel workbook, a PowerPoint presentation, and an Access database. The inside back cover of the book gives instructions for downloading the data files for students. CLASSROOM ACTIVITIES Class Discussion: Ask students to identify various types of documents that could be used to create Web sites for businesses and write their ideas on the board. INT 5: Adding Hyperlinks to a Word Document LECTURE NOTES Define home page and hyperlink Review the three hyperlinks in the project Use Figure 1-2 to illustrate starting Word, open an existing document, and save the document with another name Use Figure 1-3 to illustrate inserting a table into a Word document Use Figures 1-4 through 1-7 to remove the table border, view gridlines, and AutoFit the table contents Use Figure 1-8 to illustrate inserting text for hyperlinks Define and discuss the Insert Hyperlink feature Use Figure 1-9 to create a hyperlink to PowerPoint Web pages Use Figure 1-10 to illustrate inserting the remaining hyperlinks FIGURES: 1-2, 1-3, 1-4, 1-5, 1-6, 1-7, 1-8, 1-9, 1-10 BOXES: BTW: Web Pages. Review the information on Web pages and Office 2007. BTW: Hyperlinks. Review information on hyperlinks, note that hyperlinks can link to both external and internal locations. Other Ways: Encourage your students to explore other ways to insert a table into a Word document. Other Ways: Encourage your students to explore other ways to create a hyperlink. CLASSROOM ACTIVITIES Class Discussion: Ask students why a table should be used instead of just typing in text or using tabs. Discuss the benefits of using a table to insert text and graphics so they line up appropriately, versus using tabs or just trying to line them up. Which would make the Web page more visually appealing? LAB ACTIVITIES 1. Have students search the Internet for examples of home pages. Encourage them to find and click examples of text and image hyperlinks. Have students make a list of the URLs for both the home pages and the linked pages. INT 13: Embedding an Excel Chart into a Word Document LECTURE NOTES Define Object Linking and Embedding (OLE), source object, destination document, paste special and source program Discuss the steps to start Excel and open an existing workbook Use Figures 1-11 through 1-15 to illustrate embedding an Excel chart into a Word document Use Table 1-1 to review the three copy methods used in Office 2007 Use Figures 1-16 through 1-18 to illustrate changing the size of an embedded object Review the steps to quit Excel FIGURES: 1-11, 1-12, 1-13, 1-14, 1-15, 1-16, 1-17, 1-18 BOXES: BTW: Embedded Objects. Review the information on embedded objects and the advantages of using Microsoft Office 2007. BTW: Objects. Review the information on objects and the advantage of the Paste Special feature. BTW: Resizing. Review the information on resizing. Other Ways: Encourage your students to explore other ways to embed charts into documents. TEACHER TIPS You can create a hyperlink quickly without having to use the Insert Hyperlink dialog box by dragging selected text or pictures from a Word document or by dragging a Web address or hyperlink from some Web browsers. You cannot drag drawing objects, such as Shapes, to create hyperlinks. To create a hyperlink for a drawing object, select the object, right-click, and then click Hyperlink on the shortcut menu. CLASSROOM ACTIVITIES Quick Quiz: What is the difference between the source document and the destination document? (Answer: A source object is where the object comes from, the destination document is where the object is going to) Class Discussion: When you use the Paste command to paste an object, the object becomes part of the destination document and only can be edited using features of the destination application. When you use the Paste Special command to embed an object, the object becomes part of the destination document but can be edited using features of the source application. When would you use Paste Special instead of Paste? Why? LAB ACTIVITIES 1. Have students add a graphic to a document and distort the graphic by changing the size but not locking the aspect ratio. Ask them to write a brief paragraph describing what happened. INT 19: Viewing the Word Document in Your Browser and Saving It as a Web Page LECTURE NOTES Use Figures 1-19 through 1-23 to review adding a button to the Quick Access Toolbar and previewing the Web page Review the steps to save a document with a new name Use Figure 1-24 to illustrate previewing the Web page Review the steps to reset the Quick Access Toolbar and quit Word FIGURES: 1-19, 1-20, 1-21, 1-22, 1-23, 1-24 BOXES: BTW: Web Page Formatting. Review the information on Web page formatting and Word. BTW: Web Programming Languages. Review the information on Web programming languages. TEACHER TIPS The Web toolbar is not available in Microsoft Office PowerPoint 2007, Microsoft Office Word 2007, or Microsoft Office Excel 2007. The Address box is now called the Location box, and it displays Uniform Resource Locators (URL)(Uniform Resource Locator (URL): An address that specifies a protocol (such as HTTP or FTP) and a location of an object, document, World Wide Web page, or other destination on the Internet or an intranet. For example: http://www.example.com/.) or other paths. If you use it often enough, you can add the Location box to the Quick Access Toolbar. Other commands that were on the Web toolbar that you can add to the Quick Access Toolbar as well are the Back and Forward buttons. CLASSROOM ACTIVITIES Project to Assign: Using Figure 1-24, ask the students to identify changes they could make to the Web page to improve its appearance. Have students make a list of their suggestions or if they choose, they can create a page with the same information presented in a different format or with different graphics or charts. INT 23: Creating a PowerPoint Presentation Web Page LECTURE NOTES Discuss and review PowerPoint presentations and the ability to save as a Web page Use Figure 1-25 to illustrate starting PowerPoint and open an existing presentation Use Figure 1-26 to illustrate adding text for a hyperlink into a PowerPoint presentation Use Figure 1-27 to review inserting a hyperlink into a PowerPoint presentation Use Figure 1-28 to review the procedures for adding and removing a button from the Quick Access Toolbar and viewing the Web page in your browser Review the steps to save the PowerPoint presentation as a Web page Discuss the steps to remove a button from the Quick Access Toolbar, quit PowerPoint, and close your browser FIGURES: 1-25, 1-26, 1-27, 1-28 BOXES: BTW: Keeping Links Fresh. Review the information on keeping links fresh. BTW: Web Page Publishing. Review the information on Web page publishing. BTW: Outline. Review the information on the Outline pane. BTW: Viewing Web Pages. Review the information on viewing Web pages. Other Ways: Encourage your students to explore other ways to add text for a hyperlink. Other Ways: Encourage your students to explore other ways to insert a hyperlink. CLASSROOM ACTIVITIES Class Discussion: Have students compare and contrast adding text for a hyperlink in PowerPoint with inserting text for hyperlinks into a Word document as described on page INT 11. INT 28: Creating a Web Page from an Access Report LECTURE NOTES Define and discuss Access database reports Use Figure 1-29 to start Access and open an existing database Use Figures 1-30 through 1-36 to illustrate creating a report using the Report wizard Use Figures 1-37 through 1-42 to illustrate adding a hyperlink to a report and changing the text background color Use Figures 1-43 through 1-45 to illustrate saving the report and viewing it in your browser Discuss and review the importance of editing documents for better Web readability Review the steps to close your browser and quit Access FIGURES: 1-29, 1-30, 1-31, 1-32, 1-33, 1-34, 1-35, 1-36, 1-37, 1-38, 1-39, 1-40, 1-41, 1-42, 1-43, 1-44, 1-45 CLASSROOM ACTIVITIES Quick Quiz: What is one of the common purposes of data access pages? (Answer: For viewing records of a database via a company intranet or the World Wide Web) Projects to Assign: Using Figure 1-36, ask the students to identify changes to the data access page that will increase its readability. Have students make a list of their suggestions on the board and vote on the ones that will increase its readability the most. Compare Figure 1-36 to Figure 1-42 and discuss the changes. INT 38: Testing the Web Site LECTURE NOTES Discuss the need to test the Web site and verify hyperlinks Use Figure 1-46 to illustrate testing the Web site Review the steps to verify the hyperlinks Discuss the steps to quit e-mail and close your browser FIGURE: 1-46 CLASSROOM ACTIVITIES Group Activity: Break students into small groups and ask them to discuss and compile a written list of opinions on the features demonstrated and how comfortable they feel with creating these Web pages and data access pages. Have each group share their opinions with the class. End of Chapter Material Learn It Online is a series of online student exercises that test your knowledge of chapter content and key terms. Apply Your Knowledge is a student assignment that helps you to reinforce the skills and apply the concepts you learned in this chapter. Extend Your Knowledge is a student assignment that challenges you to extend the skills you learned in this chapter and to experiment with new skills. You may need to use Help to complete the assignment. Make It Right is a student assignment that requires you to analyze a presentation and correct all errors and/or improve the design. In the Lab (Lab): In the Lab is a series of student assignments that ask you to design and/or create a presentation using the guidelines, concepts, and skills presented in this chapter. The assignments are listed in order of increasing difficulty. Cases and Places is a series of student assignments where you apply your creative thinking and problem solving skills to design and implement a solution. Glossary of Key Terms destination document (INT 13) gridlines (INT 9) home page (INT 6) HTML (INT 23) hyperlink (INT 6) Insert Hyperlink feature (INT 11) Object Linking and Embedding, (OLE) (INT 13) outline (INT 27) Paste Special (INT 13) source object (INT 13) source program (INT 13)  HYPERLINK \l "_Excel_2007" Top of Document     Page  PAGE 22 of  NUMPAGES 7 Project 1: Creating a Worksheet and an Embedded Chart Integration 2007 Instructors Manual Page  PAGE 2 of  NUMPAGES 7 PPT 1. PAGE 1  "]^{|  d 齧{iWEi6'6h~UhLCJOJQJaJh~UhCJOJQJaJ"h~Uh 65;CJOJQJaJ"h~Uh \5;CJOJQJaJ"h~UhsQ.5;CJOJQJaJ+h~Uh~i5;B*CJ$OJQJaJ$ph+h~Uh5;B*CJ$OJQJaJ$ph+h~Uh~i5;B*CJ0OJQJaJ0ph+h~Uh5;B*CJ0OJQJaJ0ph+h~Uh^-5;B*CJ0OJQJaJ0ph+h~Uh9K.5;B*CJ0OJQJaJ0ph"^    'a $Ifgd Z!gd!#lgd7gd  7$8$H$gd gda dgda$d-DM a$gd9K.ABBd g    + C D E ^ g   z پپ٠sdTC h~Uh CJOJQJ^JaJh~Uh 5OJQJ\^Jh~Uh60CJOJQJaJh~Uh7CJOJQJaJh~UhvICJOJQJaJh~UhTCJOJQJaJh~Uh(6CJOJQJaJh~UhHsCJOJQJaJh~UhGCJOJQJaJh~UCJOJQJaJh~UhCJOJQJaJ.h~Uh5>*B*CJOJQJXaJphz { '(KLM_`aٷpZI:h~UhHsCJOJQJaJ h~UhHs0JCJOJQJaJ+jh~Uhg3|CJOJQJUaJh~Uh& CJOJQJaJ%jh~UhHsCJOJQJUaJ*h~Uh!#5>*B*OJQJXaJphh~UhCJOJQJaJh~Uh CJOJQJaJ$h~Uh 0JCJOJQJ^JaJ h~Uh CJOJQJ^JaJ)jh~Uh CJOJQJU^JaJab짒eTC2 h~Uhunn0JCJOJQJaJ h~UhJ0JCJOJQJaJ h~Uh0JCJOJQJaJ7j|h~Uhg3|>*B*CJOJQJUaJph h~Uh& 0JCJOJQJaJ)jh~UhJ0JCJOJQJUaJh~UhHsCJOJQJaJ h~Uh 0`0JCJOJQJaJ+jh~Uhg3|CJOJQJUaJh~Uh& CJOJQJaJ%jh~Uh& CJOJQJUaJ}}+Rkd$$Ifl0 !\ t44 la $Ifgd$ykd$$Ifl0 !\ t044 la/014568}~Ϲިn]L]?h~Uhunn0JCJaJ h~Uhunn0JCJOJQJaJ h~UhJ0JCJOJQJaJ h~Uh0JCJOJQJaJ+j)h~Uhg3|CJOJQJUaJ%jh~Uh`~CJOJQJUaJ h~Uh`~0JCJOJQJaJ+j h~Uhg3|CJOJQJUaJh~Uh& CJOJQJaJ%jh~Uh& CJOJQJUaJh~Uh`~CJOJQJaJ<=IRkd($$Ifl0 !\ t44 laRkd$$Ifl0 !\ t44 la $Ifgd$ $Ifgd& 789:;=>hֶ~maK=֧h0JCJOJQJaJ+jhh XCJOJQJUaJhCJOJQJaJ h~Uhunn0JCJOJQJaJ+jh~Uhg3|CJOJQJUaJ%jh~Uh`~CJOJQJUaJh~Uh`~CJOJQJaJh~Uh& CJOJQJaJ h~Uh`~0JCJOJQJaJ%jh~Uh& CJOJQJUaJ+jh~Uhg3|CJOJQJUaJhijJKLMuֶsdNֶ+jth~Uhg3|CJOJQJUaJh~Uh& CJOJQJaJh0JCJOJQJaJ+jNhh XCJOJQJUaJhCJOJQJaJ%jh~Uh& CJOJQJUaJh~Uh`~CJOJQJaJ h~Uhunn0JCJOJQJaJ%jh~Uh`~CJOJQJUaJ+jh~Uhg3|CJOJQJUaJLz{ RRkd $$Ifl0 !\ t44 la $Ifgd$Rkd$$Ifl0 !\ t44 lauvwxy{|  ?ֹpdNֹ?h~UhunnCJOJQJaJ+j hh XCJOJQJUaJhCJOJQJaJ h~Uhunn0JCJOJQJaJ+j) h~Uhg3|CJOJQJUaJh~Uh& CJOJQJaJ%jh~Uh`~CJOJQJUaJh~Uh`~CJOJQJaJh0JCJOJQJaJ%jh~Uh& CJOJQJUaJ+j hh XCJOJQJUaJ  tRRkd $$Ifl0 !\ t44 la $Ifgd$RkdO $$Ifl0 !\ t44 la?@ArstuֶsdNֶ+j h~Uhg3|CJOJQJUaJh~Uh& CJOJQJaJh0JCJOJQJaJ+j hh XCJOJQJUaJhCJOJQJaJ%jh~Uh& CJOJQJUaJh~Uh`~CJOJQJaJ h~Uhunn0JCJOJQJaJ%jh~Uh`~CJOJQJUaJ+j h~UhM#CJOJQJUaJABCZ[\]ֹpdNֹ?h~Uh& CJOJQJaJ+jhh XCJOJQJUaJhCJOJQJaJ h~Uh 0JCJOJQJaJ+jZh~UhH%CJOJQJUaJh~Uh CJOJQJaJ%jh~Uh-CJOJQJUaJh~Uh`~CJOJQJaJh0JCJOJQJaJ%jh~Uh& CJOJQJUaJ+j8hh XCJOJQJUaJ\RRkd$$Ifl0 !\ t44 la $Ifgd$Rkd$$Ifl0 !\ t44 la ֶ~mfM41h~Uh~5;>*B*CJOJQJXaJph1h~Uh8o5;>*B*CJOJQJXaJph h~UhHs h~Uhunn0JCJOJQJaJ+jh~Uhg3|CJOJQJUaJh~Uh& CJOJQJaJ%jh~Uh& CJOJQJUaJh~Uh-CJOJQJaJ h~Uh-0JCJOJQJaJ%jh~Uh-CJOJQJUaJ+jh~Uhg3|CJOJQJUaJUVMI & F!Eƀ5FlgdgdsQ. dxgdsQ.gdHsRkd-$$Ifl0 !\ t44 la :EV׹הjUUF׹h~Uh~CJOJQJaJ)h~UhsQ.56>*B*OJQJXph)h~Uh%!56>*B*OJQJXph)h~Uh/56>*B*OJQJXph)h~Uh56>*B*OJQJXphh~Uh;CJOJQJaJh~UhCJOJQJaJh~UhGCJOJQJaJh~UhsQ.CJOJQJaJ1h~UhsQ.5;>*B*CJOJQJXaJphk!I & F!Eƀ5FlgdI & F!Eƀ5FlgdI & F!Eƀ5Flgd4Xk!I & F!Eƀ5FlgdI & F!Eƀ5FlgdI & F!Eƀ5Flgd)a\V$gduYgdI & FEƀ5FgdgdsQ.gdsQ.I & F!Eƀ5FlgdsQ.()/09lĵӈӈ|gR=)h~UhDO56>*B*OJQJXph)h~Uhf56>*B*OJQJXph)h~Uh56>*B*OJQJXphh~UCJOJQJaJh~UhQZCJOJQJaJh~UhuYCJOJQJaJh~UhO9CJOJQJaJh~UhCJOJQJaJh~Uh%!CJOJQJaJh~UhDOCJOJQJaJh~UhCJOJQJaJh~Uh CJOJQJaJ)$2b`I & FEƀ5FgdgdsQ.gdAK$ & FEƀ5F.gd#$1239RZabf~o`o~`~QB`h~Uh$CJOJQJaJh~Uh CJOJQJaJh~Uh CJOJQJaJh~UhDOCJOJQJaJh~Uh kXCJOJQJaJh~UhCJOJQJaJh~Uh~CJOJQJaJ)h~UhsQ.56>*B*OJQJXph)h~UhDO56>*B*OJQJXph)h~Uhf56>*B*OJQJXph)h~Uh56>*B*OJQJXphb  !$gd -DM gd -DM gdMygdgdsQ.I & FEƀ5Fgd:  !23ĸ⩚|gR=)h~Uh6+E56>*B*OJQJXph)h~UhA56>*B*OJQJXph)h~Uh56>*B*OJQJXphh~UhDOCJOJQJaJh~UhO9CJOJQJaJh~UhTCJOJQJaJh~UhCJOJQJaJh~UCJOJQJaJh~UhCJOJQJaJh~Uh CJOJQJaJh~UhMyCJOJQJaJh~UhACJOJQJaJ!aI & FEƀ5FgdgdgdI & F$Eƀ5F.gdxEHRTUYZ~ufufWHWH9uh~UhHsCJOJQJaJh~Uh6+ECJOJQJaJh~UhCJOJQJaJh~Uh\(9CJOJQJaJh~Uh CJOJQJaJh~UhCJOJQJaJh~UhCJOJQJaJh~UhCJOJQJaJh~Uh8oCJOJQJaJ)h~Uh56>*B*OJQJXph)h~Uh56>*B*OJQJXph)h~Uh56>*B*OJQJXphEk!I & FEƀ5FgdI & FEƀ5FgdI & FEƀ5Fgd_k!I & FEƀ5F gd\(9I & FEƀ5F gdI & FEƀ5FgdHIkfffagdgdI & FEƀ5F gdI & FEƀ5F gdDEFQRc³³whwYh~Uh%CJOJQJaJh~UhF8CJOJQJaJh~Uh7CJOJQJaJh~UhTCJOJQJaJh~UhCJOJQJaJh~Uh9K.CJOJQJaJh~Uh CJOJQJaJh~Uh 6CJOJQJaJh~Uh6CJOJQJaJh~UhCJOJQJaJh~UhO9CJOJQJaJFk!I & FEƀ5F.gd'I & FEƀ5F.gd9K.I & FEƀ5F.gd'A B Q .!d!_YYTOgdgd%$gd%K$ & FEƀ5F.gd%$gdngdxI & FEƀ5F.gdP Q T .!1!2!4!6!c!d!q!r!!ӵӠvavaRC4h~UhxH`CJOJQJaJh~UhCJOJQJaJh~Uh8oCJOJQJaJ)h~Uh56>*B*OJQJXph)h~UhxH`56>*B*OJQJXph)h~UhR56>*B*OJQJXph)h~Uh56>*B*OJQJXphh~UhtCJOJQJaJh~UhCJOJQJaJh~Uh%CJOJQJaJh~UhO9CJOJQJaJh~UhxCJOJQJaJd!r!!""fI & FEƀ5FgdI & FEƀ5Fgdgd!!""""2#3#>#j#l#q#r#x###############$$F$G$M$U$W$]$q$r$y$z$$$$$$$ĵė◇ӦӇӦӇӦxxӗh~Uh9K.CJOJQJaJh~Uh6CJOJQJaJh~Uhg CJOJQJaJh~UhjCJOJQJaJh~UhJ~CJOJQJaJh~UhCJOJQJaJh~UhxH`CJOJQJaJh~UhCJOJQJaJh~Uh\n"CJOJQJaJ-""|""#k!I & FEƀ5FgdI & FEƀ5FgdI & FEƀ5Fgd#2#3#k#l#s##fI & FEƀ5F.gd'gdI & FEƀ5Fgd#H${$$k!I & FEƀ5F.gd9K.I & FEƀ5F.gd9K.I & FEƀ5F.gdxH`$$$}&~&&&K$ & F"Eƀ5F.gdj 0gdi` -DM gd -DM gd'gd$$$$ %0%%%|&}&~&&&&c')))))ѿѯѣvgXgIB; h~Uhj h~Uhh~Uh]sCJOJQJaJh~UhjCJOJQJaJh~UhxH`CJOJQJaJh~UhkBCJOJQJaJh~Uhi`CJOJQJaJh~UhCJOJQJaJh~UCJOJQJaJh~Uh~qu<CJOJQJaJ#h~Uh~quCJOJQJ\^JaJ h~Uh~quCJOJQJ^JaJh~UhCJOJQJaJh~Uh'CJOJQJaJ&c'd'))))*,*e`[VQgd8ogdcgdjgd]sI & F"Eƀ5F.gdjgdxH`K$ & F"Eƀ5F)gd)))))**,*N*******++G+H+Q+U+s+t+u+z+{+|++ձufWWWHh~UhCJOJQJaJh~Uh\CJOJQJaJh~UhKCJOJQJaJh~Uh\(9CJOJQJaJh~UhcCJOJQJaJh~UhjCJOJQJaJh~UhCJOJQJaJh~Uh8oCJOJQJaJ)h~Uhj56>*B*OJQJXph)h~Uhc56>*B*OJQJXph)h~Uh56>*B*OJQJXph,***+k!I & FEƀ5F gdcI & FEƀ5FgdcI & FEƀ5Fgdc+G+H+t+u+|++UQ & F hEƀ5F.^hgdFgd\gdcgdjI & FEƀ5F gdc++++++++++++++ , ,,,!,",#,$,/,0,,,-.7.ѳ¤saN$h~Uh G0J"CJOJQJ^JaJ#h~Uh GCJOJQJ\^JaJ h~UhCJOJQJ^JaJ h~Uh GCJOJQJ^JaJh~Uh7$TCJOJQJaJh~Uh#uCJOJQJaJh~UhS'CJOJQJaJh~UhjCJOJQJaJh~UhCJOJQJaJh~UhCJOJQJaJh~Uh6CJOJQJaJ+#,$,1,../E0HK$ & FEƀ5F.gd]sgdnU -DM gd G^gd7$TQ & F hEƀ5F.^hgdF7.:.....//~/////D0E0H0I0K0M0x0y0~iTi?i)h~Uhq\056>*B*OJQJXph)h~UhOr56>*B*OJQJXph)h~Uhv6%56>*B*OJQJXph)h~Uh56>*B*OJQJXphh~Uh3hCJOJQJaJh~Uh 0`CJOJQJaJh~UhnUCJOJQJaJh~UhqCJOJQJaJh~Uh GCJOJQJaJ h~Uh GCJOJQJ^JaJ h~Uh9K.CJOJQJ^JaJE0y000-1aI & FEƀ5F gdv6%I & FEƀ5F gdv6%gd8ogdv6%y00000033353<3>3C3V3X3333333333334 44 4"4M4N4O444444444ĵӦⵗӗxxxxxxxh~Uh9K.CJOJQJaJh~Uh6CJOJQJaJh~UhqCJOJQJaJh~Uhv6%CJOJQJaJh~Uh*mCJOJQJaJh~Uhq\0CJOJQJaJh~UhCJOJQJaJh~UhOrCJOJQJaJh~Uh8oCJOJQJaJ)-111f2k!I & FEƀ5FgdI & FEƀ5Fgdv6%I & FEƀ5F gdv6%f22336373>3k\OOJgd*m  0gdOr 0gdv6%I & FEƀ5Fgdv6%I & FEƀ5Fgdv6%>333]Q & F hEƀ5F.^hgd9K.Q & F hEƀ5F.^hgdF3 4O4]Q & F hEƀ5F.^hgd9K.Q & F hEƀ5F.^hgd9K.O4444 5]PJ$gdv6%  0gdOrQ & F hEƀ5F.^hgdq\0Q & F hEƀ5F.^hgdq\04 5 55555555555566 666ӵӠvvgXI:Xh~UhCJCJOJQJaJh~Uh)7CJOJQJaJh~Uh CJOJQJaJh~Uh8oCJOJQJaJ)h~Uhq\056>*B*OJQJXph)h~Uh 56>*B*OJQJXph)h~Uh56>*B*OJQJXphh~Uh 0`CJOJQJaJh~Uh]sCJOJQJaJh~Uhq\0CJOJQJaJh~Uhv6%CJOJQJaJh~UhGCJOJQJaJ 5556,6XI & FEƀ5Fgd ^gdF^gd|K$ & FEƀ5F.gdq\06+6,6j678"8,8.8j8p88888888=9Q9a9b9g9ӵĦwhYJh~UhCJOJQJaJh~UhtCJOJQJaJh~UhwhCJOJQJaJh~Uh CJOJQJ]aJh~UhGCJOJQJ]aJh~Uh[cCCJOJQJaJh~Uhq\0CJOJQJaJh~Uh CJOJQJaJh~Uh\(9CJOJQJaJh~Uh)7CJOJQJaJh~UhCJCJOJQJaJh~Uh0CJOJQJaJ,6j6627k!I & FEƀ5Fgd\(9I & FEƀ5Fgd\(9I & FEƀ5Fgd 27778k!I & FEƀ5Fgd I & FEƀ5Fgd)7I & FEƀ5Fgd\(98888888K$ & FEƀ5F.gdwh 0^`gd  0gd ^gdq\0gd 8<9=9:::WRMgd8ogdH?K$ & FEƀ5F.gd0$gd0V & F *88Eƀ5F)^8`gd)7g9k9U:V:Z:a:d:e:~::::::::::::::::;;{;ⵠvvgXIh~Uh\(9CJOJQJaJh~Uh7CJOJQJaJh~Uh8oCJOJQJaJ)h~Uh056>*B*OJQJXph)h~Uh 56>*B*OJQJXph)h~Uh56>*B*OJQJXphh~UhtCJOJQJaJh~Uh)7CJOJQJaJh~UhCJOJQJaJh~Uh0CJOJQJaJh~Uh 0`CJOJQJaJ::;C;k!I & FEƀ5Fgd7I & FEƀ5Fgd7I & FEƀ5Fgd7C;{;|;;;;<<NH$gd0K$ & FEƀ5F.gd0$ 0^`gd C"gd I & FEƀ5Fgd7{;;;;;;;;;;;;;;;<~<<<<<<ózk\G)h~Uh-56>*B*OJQJXphh~UhrRCJOJQJaJh~UhGCJOJQJaJh~UCJOJQJaJh~Uh1RCJOJQJaJh~UhwhCJOJQJaJh~UhxQ,CJOJQJaJh~Uh CJOJQJ]aJh~UhGCJOJQJ]aJh~UhCJOJQJaJh~Uh0CJOJQJaJh~Uh CJOJQJaJ<<<A=eI & FEƀ5Fgd>pgd& K$ & FEƀ5F.gdrR<< =*=@=A=y====>>??@@@@@@@@۴۴۴۴ۄnZE)h~Uhh56>*B*OJQJXph&h~Uh.5>*B*OJQJXph*h~UhH?5>*B*OJQJXaJphh~Uh)7CJOJQJaJ"h~Uh& >*CJOJQJXaJh~Uh& CJOJQJaJ.h~Uh>p5>*B*CJOJQJXaJphh~Uh>pCJOJQJaJh~Uh-CJOJQJaJ)h~Uhc"56>*B*OJQJXphA==>?k!I & FEƀ5Fgd>pI & FEƀ5Fgd>pI & FEƀ5Fgd>p?@@@@@k^YTgd& gdH? `gd>pI & FEƀ5Fgd>pI & FEƀ5Fgd& @@@@@@dAeAAAAAAAAAs`Q;`*` h~UhHs0JCJOJQJaJ+jh~Uh Z!CJOJQJUaJh~UhHsCJOJQJaJ%jh~UhHsCJOJQJUaJh~Uh~CJOJQJaJ"h~Uhh)7CJOJQJaJh~UhCJOJQJaJh~Uhc"CJOJQJaJh~UhH?CJOJQJaJ)h~Uh>p56>*B*OJQJXph&h~Uh>p5>*B*OJQJXph)h~Uh~56>*B*OJQJXph@@@eL$ & F1$Eƀ5FgdH?L$ & F1$Eƀ5FgdH?@AAeL$ & F1$Eƀ5FgdH?L$ & F1$Eƀ5FgdH?A&AHAeL$ & F1$Eƀ5FgdH?L$ & F1$Eƀ5FgdH?HAuAAeL$ & F1$Eƀ5F gdH?L$ & F1$Eƀ5FgdH?AAAeL$ & F1$Eƀ5F gdH?L$ & F1$Eƀ5F gdH?AAAABBBBBB B BcBdBeBBBBB$a$ !$$1$gdZJL$ & F1$Eƀ5F gdH?AAABBBBBB BBBBBBBBB)B*B+B,BcBeBpBBBBBBBBBBBBBBBBBBBBBBBBBBտ߻լլջջ廨h$h _0JmHnHuhh*h& 0JmHnHuh*0JmHnHujh*0JU h*0JhajhaUh~Uh'CJOJQJaJ1BBBBB$1$gdZJ6&P1h:pZJ/ =!h"`#$`% = 0&P1h:pZJ/ =!"`#$`% P 9 0&P1h:pZJ/ =!"`#$`% 9 0&P1h:pH?/ =!"`#$`% O 0&P1h:p./ =!"`#$`% P0 9 0&P1h:pc"/ =!"`#$`% O 0&P1h:punn/ =!"`#$`% P0  DyK _Chapter_ObjectivesDyK _Chapter_Objectivesh$$If!vh5\5#v\#v:Vl t5\5/ DyK _INT_2:_Introduction_1DyK _INT_2:_Introduction_1$$If!vh5\5#v\#v:Vl t05\5DyK %_EX_5:_Project_One  Worksheet with DyK %_EX_5:_Project_One  Worksheet with $$If!vh5\5#v\#v:Vl t05\5DyK _EX_6:_Starting_ExcelDyK _EX_6:_Starting_Excel$$If!vh5\5#v\#v:Vl t05\5DyK _EX_9:_The_Excel worksheetDyK _EX_9:_The_Excel worksheet$$If!vh5\5#v\#v:Vl t05\5DyK _EX_11:_Worksheet_windowDyK _EX_11:_Worksheet_window$$If!vh5\5#v\#v:Vl t05\5DyK _EX_13:_Selecting_a cellDyK _EX_13:_Selecting_a cell$$If!vh5\5#v\#v:Vl t05\5DyK %_INT_28:_Creating_a Web Page from anDyK _EX_16:_Entering_text$$If!vh5\5#v\#v:Vl t05\5DyK _EX_21:_Entering_numbersDyK _EX_21:_Entering_numbers$$If!vh5\5#v\#v:Vl t05\5DyK _End_of_Chapter_MaterialDyK _End_of_Chapter_Material$$If!vh5\5#v\#v:Vl t05\5DyK _Glossary_of_Key_TermsDyK _Glossary_of_Key_Terms$$If!vh5\5#v\#v:Vl t05\5yDyK  _Excel_2007#<@< (6NormalCJ_HmH sH tH F@F sQ. Heading 1$dh@&;CJL@L sQ. Heading 2$$dh@&a$;CJ V@V L Heading 3$<@&5CJOJQJ\^JaJ>@> sQ. Heading 7 <@&aJD@D sQ. Heading 8 <@& 6]aJN @N  Heading 9 <@&CJOJQJ^JaJDA@D Default Paragraph FontRi@R  Table Normal4 l4a (k(No List4@4 sQ.Header  !4 @4 sQ.Footer  !.)@. sQ. Page NumberFB@"F sQ. Body Text$$dhxa$CJ$NO2N i`Level 1>1$7$8$H$^`>CJaJB'AB wComment ReferenceCJaJ8R8 w Comment TextCJ@jQR@ wComment Subject5\H@rH w Balloon TextCJOJQJ^JaJj@j Z Table Grid7:V0 Z Table Web 2h:V03j B*`Jph6U@6 n Hyperlink >*B*phFV@F nFollowedHyperlink >*B* ph<O< !#Head B5CJOJQJO aUnitW$d!%d$&d!'d$-DM 3N!O$P!Q$56B*CJ(OJQJaJ(ph(O( !#Unit tF^@F My Normal (Web)dd[$\$aJ&& /JTOC 1 VYV H? Document Map!-D M CJOJQJ^J<O!< G acicollapsed1 <:V 0448:8w>y"^'a < = L z { t   \  U V 4X)$2b  !E_HIFABQ.dr"|23klsH{}~cd!!!!","""#G#H#t#u#|###$$$1$&&'E(y(((-)))f**++6+7+>+++ ,O,,,, ---.,.j..2///0000000:0 000k0k0k0k0k0k0k0k0k0k0k0k0k 0k0k0k0k0k0k0k 0k 0k0k0k0k0k0k0k0k0k0k0k0k0k0k0k0k0k0k0k0k0k0k0k00h 0h ! 0h ! 0h ! 0h ! 0h ! 0h ! 0h ! 0h !`0h x0h 0  0 0 0  0 x0h 0I 0I 0I0I0I0x0x0x0x0x$ 0xx0h 0 0 0 0 0 0 0 0 0 00000 0 0 0 000 0000x0h 0, 0, 0, 0, 0, 0, 0,0,0,0,0, 0, 0, 0, 0,0,0,0,0,0," 0," 0,0," 0,0,0,0,x0h 0# 0# 0# 0# 0#0#0#0#0# 0# 0#0#0#0#0#0# 0#x0h 0j* 0j* 0j* 0j* 0j* 0j* 0j* 0j*0j*0j*0j*0j* 0j* 0j* 0j* 0j* 0j* 0j*0j*0j* 0j*x0h 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/0/0/0/0/0/ 0/{00| "^'a < = L z { t   \  U V 4X)$2b  !E_HIFABQ.dr"|23klsH{}~cd!!!!","""#G#H#t#u#|###$$$1$&&'E(y(((-)))f**++6+7+>+++ ,O,,,, ---.,.j..2///0000000<1=122223C3{3|33334444A5567888888899&9H9u9999999:::::: : :c:d:e::::::::0000^0^0^0^0^0^0^0^0^0^0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^ 0^00 0 ! 0 ! 0 ! 0 ! 0 ! 0 ! 0 ! 0 !@0 x0 0 000 0x0 0 0 00000000$ 0x0 0 0 0 0 0 0 0 0  0  0 0000 0 0 0 000 0000x0 0. 0. 0. 0. 0. 0. 0.0.0.0.0. 0. 0. 0. 0.0.0.0.0.0." 0." 0.0." 0.0.0.0.x0 0! 0! 0! 0! 0 !0!0!0!0! 0! 0!0!0!0!0!0! 0!x0 0E( 0 E( 0 E( 0 E( 0 E( 0E( 0E( 0E(0E(0E(0E(0E( 0E( 0E( 0E( 0E( 0E( 0E(0E(0E( 0E(x0 0- 0- 0- 0- 0- 0- 0- 0-0-0-0-0-0- 0- 0-0- 0-x0 02 02 02 02 0202020202 0202`02x0  04 04 04 04 04 040404x0  08 08 08 08 08 08 08 08 0 8 0 8 0 80808@000@000@000@000@0@0@0@0@0@0@000 0P0"^'a < = L z { t   \  U V 4X)$2b  !E_HIFABQ.dr"|23klsH{}~cd!!!!","""#G#H#t#u#|###$$$1$&&'E(y(((-)))f**++6+7+>+++ ,O,,,, ---.,.j..2///0000000<1=122223C3{3|33334444A5567888888899&9H9u9999999::: :c:d:e::::::0000k0k0k0k0k0k0k0k0k0k0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k 0k00h 0h ! 0h ! 0h ! 0h ! 0h ! 0h ! 0h ! 0h !`0h x0h 0  0 0 0  0 x0h 0I 0I 0I0I0I0x0x0x0x0x$ 0xx0h 0 0 0 0 0 0 0 0  0  0 0000 0 0 0 000 0000x0h 0, 0, 0, 0, 0, 0, 0,0,0,0,0, 0, 0, 0, 0,0,0,0,0,0," 0," 0 ,0," 0,0,0,0,x0h 0# 0# 0# 0# 0 #0#0#0#0# 0# 0#0#0#0#0#0# 0#x0h 0j* 0 j* 0 j* 0 j* 0 j* 0j* 0j* 0j*0j*0j*0j*0j* 0j* 0j* 0j* 0j* 0j* 0j*0j*0j* 0j*x0h 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/0/0/0/0/0/ 0/ 0000 00x0v 0I5 0I5 0I5 0I5 0I50I50I50I50I5 0I50I5`0I5x0v  07 07 07 07 07 070707x0v @ 0; 0 ;@ 0;@ 0 ;@ 0;@ 0;@ 0; 0 ;@ 0;@ 0;@ 0;0;h00p @0@0@0@0@0@0@0@0@0@0@0 00 gd z ahu? !$)+7.y046g9{;<@AB"%&')+,.01359;=?CFHMORTV\^cfhkr )b!d!""##$&,*++E0-1f2>33O4 5,62788:C;<A=?@@AHAAABB#(*-/24678:<>@ABDEGIJKLNPQSUWXYZ[]_`abdegijlmnopqsB$z'L_a0}  8 : = i J L v x {   @ r t    B Z \ 999:XXXXXXXXXXXXXXXXXXXXXXXX +-!!!8@0(  B S  ?:@ _Toc150248910 _Excel_2007 OLE_LINK1 OLE_LINK2 _Hlt150310516 _Hlt150310379 _Hlt150310380 _Hlt150575747 _Hlt150575748 _Hlt150249993 _Toc150248911_Chapter_Objectives$_EX_4:_What_is Microsoft Excel 2007? _Toc150248912$_OUT_2:_What_is Microsoft Office Out_INT_2:_Introduction_INT_2:_Introduction_1$_EX_5:_Project_One  Worksheet with _Toc150248913$_OUT_3:_Project_ Communicating Over$_INT_2:_Project_ Integrating Office _Plan_Ahead:_EX_6:_Starting_Excel _Toc150248914$_OUT_5:_Starting_and Customizing Out$_INT_5:_Adding_Hyperlinks to a Word _EX_9:_The_Excel worksheet _Toc150248915$_OUT_7:_The_Inbox  Microsoft Outloo$_INT_13:_Embedding_an Excel Chart in_EX_11:_Worksheet_window _Toc150248916$_OUT_10:_Working_with Incoming Messa$_INT_19:_Viewing_the Word Document i_EX_13:_Selecting_a cell _Toc150248917$_OUT_23:_Working_with Outgoing Messa$_INT_23:_Creating_a PowerPoint Prese_EX_16:_Entering_text _Toc150248918#_OUT_33:_Organizing_E-Mail Messages$_INT_28:_Creating_a Web Page from an_EX_21:_Entering_numbers _Toc150248919_OUT_44:_Using_Contacts_INT_38:_Testing_the Web Site_EX_23:_Calculating_a sum$_EX_24:_Using_the fill handle to cop_OUT_61:_Tracking_Activities_EX_28:_Saving_the project_EX_53:_Excel_Help_OUT_62:_Outlook_Help_End_of_Chapter_Material_Glossary_of_Key_Terms _Hlt150917536 _Hlt150917537 _Hlt150310427 _Hlt150310512 _Hlt150576662 _Hlt159482753 _Hlt159851008 _Hlt150310454 _Hlt150918437 _Hlt150918438RXX ....!!!!E(E(E(E(----2222444444489999999999:@@@@@ @  ! "%#$&)'(*-+,./0123456@7@8@9@:@;@<@=@>@?@SYY ...6!!!!E(E(E(M(----2222444444489999999999:"-99:::::::: : ::::"]99:::::::: : ::::3""8899999:::::::: : :e:p:u::::::::::::"-99:::::::: : ::::$U(V*S02 ,0k O|o5U \"&)$ˤNdWz:V_BN }NBz.x!:$.W#L$z:VZ1z:V6,D kF&2GVn9LVp<cL8o@Mʻ CO$δ R"HKUz:VYVQ#}[4O]O~^z:V$a}b(SDfqrl|jjd*3lz:V'DEx^B@wxʻNm}L&~z:VbN{ hh^h`o(hH. ^`hH. L^`LhH. ^`hH.   ^ `hH. U LU ^U `LhH. %%^%`hH. ^`hH. L^`LhH. hh^h`o(hH. ^`hH. L^`LhH. ^`hH.   ^ `hH. U LU ^U `LhH. %%^%`hH. ^`hH. L^`LhH. ^`o(hH. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH. ^`o(hH. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.h ^`o(hH.h ^`hH.h  L ^ `LhH.h c c ^c `hH.h 33^3`hH.h L^`LhH.h ^`hH.h ^`hH.h sLs^s`LhH. hh^h`o(hH. ^`hH. L^`LhH. ^`hH.   ^ `hH. U LU ^U `LhH. %%^%`hH. ^`hH. L^`LhH. *E*^*`Eo(hH) ^`o(hH) ??^?`o(hH) ^`o(hH() ^`o(hH() ww^w`o(hH()   ^ `o(hH. G G ^G `o(hH.   ^ `o(hH. hh^h`o(hH. ^`hH. L^`LhH. ^`hH.   ^ `hH. U LU ^U `LhH. %%^%`hH. ^`hH. L^`LhH. hh^h`o(hH. ^`hH. L^`LhH. ^`hH.   ^ `hH. U LU ^U `LhH. %%^%`hH. ^`hH. L^`LhH. hh^h`o(hH. ^`hH. L^`LhH. ^`hH.   ^ `hH. U LU ^U `LhH. %%^%`hH. ^`hH. L^`LhH. hh^h`o(hH. ^`hH. L^`LhH. ^`hH.   ^ `hH. U LU ^U `LhH. %%^%`hH. ^`hH. L^`LhH.h#E#^#`E5CJaJo(hH)h ^`o(hH)h 88^8`o(hH)h ^`o(hH()h ^`o(hH()h pp^p`o(hH()h   ^ `o(hH.h @ @ ^@ `o(hH.h   ^ `o(hH. #E#^#`Eo(hH) ^`o(hH) 88^8`o(hH) ^`o(hH() ^`o(hH() pp^p`o(hH()   ^ `o(hH. @ @ ^@ `o(hH.   ^ `o(hH.^`.^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.0h^`0OJQJo(hH^`OJQJ^Jo(hHopp^p`OJQJo(hH@ @ ^@ `OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHoPP^P`OJQJo(hH hh^h`o(hH. ^`hH. L^`LhH. ^`hH.   ^ `hH. U LU ^U `LhH. %%^%`hH. ^`hH. L^`LhH.0h^`0OJQJo(hH ^`o(hH.pp^p`OJQJo(hH@ @ ^@ `OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHoPP^P`OJQJo(hHh hh^h`hH.88^8`o()h L^`LhH.h   ^ `hH.h   ^ `hH.h xLx^x`LhH.h HH^H`hH.h ^`hH.h L^`LhH. S^`So(hH. ^`o(hH. 0^`0o(hH) i0^i`0o(hH) 9 0^9 `0o(hH()  0^ `0o(hH() 0^`0o(hH() 0^`0o(hH() y0^y`0o(hH() hh^h`o(hH. ^`hH. L^`LhH. ^`hH.   ^ `hH. U LU ^U `LhH. %%^%`hH. ^`hH. L^`LhH.0h^`0OJQJo(hH^`OJQJ^Jo(hHohh^h`B*OJQJo(phhH@ @ ^@ `OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHoPP^P`OJQJo(hH #E#^#`Eo(hH) ^`o(hH) 88^8`o(hH) ^`o(hH() ^`o(hH() pp^p`o(hH()   ^ `o(hH. @ @ ^@ `o(hH.   ^ `o(hH. hh^h`o(hH. ^`hH. L^`LhH. ^`hH.   ^ `hH. U LU ^U `LhH. %%^%`hH. ^`hH. L^`LhH. hh^h`o(hH. ^`hH. L^`LhH. ^`hH.   ^ `hH. U LU ^U `LhH. %%^%`hH. ^`hH. L^`LhH.h^`B*OJQJo(phhHhpp^p`OJQJ^Jo(hHoh@ @ ^@ `OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHhPP^P`OJQJ^Jo(hHoh  ^ `OJQJo(hH #E#^#`Eo(hH) ^`o(hH) 88^8`o(hH) ^`o(hH() ^`o(hH() pp^p`o(hH()   ^ `o(hH. @ @ ^@ `o(hH.   ^ `o(hH. hh^h`o(hH. ^`hH. L^`LhH. ^`hH.   ^ `hH. U LU ^U `LhH. %%^%`hH. ^`hH. L^`LhH. hh^h`o(hH. ^`hH. L^`LhH. ^`hH.   ^ `hH. U LU ^U `LhH. %%^%`hH. ^`hH. L^`LhH. hh^h`o(hH. ^`hH. L^`LhH. ^`hH.   ^ `hH. U LU ^U `LhH. %%^%`hH. ^`hH. L^`LhH. hh^h`o(hH. ^`hH. L^`LhH. ^`hH.   ^ `hH. U LU ^U `LhH. %%^%`hH. ^`hH. L^`LhH. #E#^#`Eo(hH) ^`o(hH) 88^8`o(hH) ^`o(hH() ^`o(hH() pp^p`o(hH()   ^ `o(hH. @ @ ^@ `o(hH.   ^ `o(hH.hhh^h`CJOJQJ^Jo(lh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hH S^`So(hH. 88^8`o(hH. 0^`0o(hH)  0^ `0o(hH) \ 0^\ `0o(hH() ,0^,`0o(hH() 0^`0o(hH() 0^`0o(hH() 0^`0o(hH()h hh^h`hH.h 88^8`hH.h L^`LhH.h   ^ `hH.h   ^ `hH.h xLx^x`LhH.h HH^H`hH.h ^`hH.h L^`LhH. #E#^#`Eo(hH) ^`o(hH) 88^8`o(hH) ^`o(hH() ^`o(hH() pp^p`o(hH()   ^ `o(hH. @ @ ^@ `o(hH.   ^ `o(hH. hh^h`o(hH. ^`hH. L^`LhH. ^`hH.   ^ `hH. U LU ^U `LhH. %%^%`hH. ^`hH. L^`LhH.$kFL$n9LKUZ1O~^ RB@wx~5U k 2 DfO]$aYVo@M CO}[_B }Nb.x!)U(l|j*SNdW6,D*3l.W#b'DExcL2GNm}$$鰸        鰸        鰸        鰸        鰸        鰸        鰸        鰸        鰸        鰸        JG        h       h鰸               鰸        h #      鰸        鰸                鰸        鰸        鰸        鰸        r                 鰸        P"~j1]?>u!)9vn~;~*FrG#;YQ3KN9G#%\<)9v?>u! gggg)`X|~"~j+o1]~*FrYQ3 ggggn~+o|~KN9/kB-kJ:l?F~-DOMOha XY|JBbJ~~ F `. 0 @G "" R _ " : ^-1q)U8tC<st ;Vi%!*Yu7Jbl\]s'clG\bj! " N SG! Z!\! C"'N"\n"%%5%v6%a%Op%o&S''c'f'#(/K)Gi)z)P*?+ z+/,xQ,9K.sQ.q\0+2mi3*4+4{,4o-4HF4G4]4k4 s4(5 6K 7D7Tg7F8?j8\(9O95X:]:;;kX;t<G%='=-=X,>??H?|?!@AZA_A>B[cCsD-D6+EFO!F:F G5H'IH%gHXHRICJ pJKK)/Lf:LBCLHML,MAMvOP,P]P>TQR1RfHRJR\R&S`S7$TU(UnUuUs%V[HVOlWX kXNeYuYQZ2[,\cp]G^_ _3_ 0`xH` s` aaHb;tcndae fzfDDgp\g3hwh~iJiijajdj\tj(k0nkFl+l m*mnpqiqvq rJIrOrF,s,?sHs]sbs?Ktut&u+u~qu-w.yMyMySyly zmCzxz|z|*|g3|w}|W}9X~`~r~q@"eX#qAzH_-`P0,Vt XKaivIG3GZ7_rF+*B .k --k8JxP7ILTz,AfK!# \*(6>pg _/J-]fdwUj.+{H?~$0=$zr*5if%~Unm{ 4LgmAc4} SSh ]rY$VAt 60}zg'>R5`bN<`'*ZJJQ C[nyL L=`Sw_Z+st~YIBt7DT\Sg3GfwM#7 vt,CCJK`x'_2ArRU\x\. 5<CiH& H%ua#urvon-=8ar%0#sa))<B\`7c"j.{/M 13ruPi`yx~Q_r-)7)8(h Q$< Ibx!^'a < = L z { t   \ U V r|c!|##$r'449::: :::'0'0'0]4]4]4]4]4]4]4]4]4a0a0a0a0a0@""|l"":@UnknownJulie KittrellGz Times New Roman5Symbol3& z Arial7 SylfaenK& zaTahomaLucidasans9Garamond?5 z Courier New;Wingdings"1h5F欲fW1iW1i!4d99 2qHX ?4sQ.Microsoft Office 2003hhawkins klmartinez$                           ! " # Oh+'0  , L X d p|Microsoft Office 2003 hhawkins Normal.dot klmartinez3Microsoft Office Word@F#@bRV@"3a`@XlW1՜.+,D՜.+,P  hp   Course Technologyi9 Microsoft Office 2003 Title  8@ _PID_HLINKSA -hEt  _Excel_2007ZWBt _Glossary_of_Key_TermsZW?t _Glossary_of_Key_Terms<t _End_of_Chapter_Material9t _End_of_Chapter_MaterialD6t _EX_21:_Entering_numbersD3t _EX_21:_Entering_numbersZ0t _EX_16:_Entering_text)p-t %_INT_28:_Creating_a Web Page from an0:*t _EX_13:_Selecting_a cell0:'t _EX_13:_Selecting_a cell=x$t _EX_11:_Worksheet_window=x!t _EX_11:_Worksheet_windowBt _EX_9:_The_Excel worksheetBt _EX_9:_The_Excel worksheet@Jt _EX_6:_Starting_Excel@Jt _EX_6:_Starting_Excel/S t %_EX_5:_Project_One  Worksheet with /S t %_EX_5:_Project_One  Worksheet with ] t _INT_2:_Introduction_1] t _INT_2:_Introduction_1xnt _Chapter_Objectivesxnt _Chapter_Objectives<&http://coursecasts.course.com/t   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstvwxyz{|}~ Root Entry F0l Data u51TableWordDocumentSummaryInformation(DocumentSummaryInformation8CompObjq  FMicrosoft Office Word Document MSWordDocWord.Document.89q