Introduction Lesson 1 Microsoft Office 2010 and the Internet

1. Introduction Lesson 1Microsoft Office 2010 and the Internet Microsoft Office 2010 Advanced Cable / Morrison

2. About the Presentations • The presentations cover the objectives found in the opening of each lesson. • All lesson objectives are listed in the beginning of each presentation. • You may customize the presentations to fit your class needs. • Some figures from the lessons are included. A complete set of images from the book can be found on the Instructor Resources disc. 2

3. Objectives • Apply basic Microsoft Word, Excel, Access, PowerPoint, and Outlook features. • Search for information on the World Wide Web. • Evaluate Web sites. • Bookmark favorite Web sites. • Manage the history of the Web sites visited. 3 3

4. bookmark browser hits keywords search engine wildcard Vocabulary 4 4

5. Applying Word Features • Microsoft Word is a powerful, full-featured word processor. • Word lessons in this course will focus on features that: • Enable you to further enhance the appearance of documents • Save time in preparing and editing documents

6. Applying Word Features (continued) • Word offers several tools to: • Help you share documents • Effectively collaborate on projects

7. Applying Excel Features • Excel is aspreadsheet application. • Spreadsheets are used for entering, calculating, and analyzing data. • Excel’s advanced features: • Enable you to perform complex calculations and in-depth analysis

8. Applying Excel Features (continued) • With Excel, you can: • Generate professional looking reports, charts, and tables • Share workbooks with colleagues

9. Applying Access Features • Access is adatabase application. • Databases are used for storing and organizing information. • Made up of objects, including tables, queries, forms, and reports

10. Applying Access Features (continued) • Advanced lessons focus on: • Features that give you more control over how database records are viewed, edited, and professionally analyzed. • How to streamline data entry and editing. • How to present the data in an attractive, reader-friendly manner.

11. Applying PowerPoint Features • PowerPoint is a presentation graphics program. • Enables you to create presentation materials for a variety of audiences • Advanced lessons focus on: • Tools to add multimedia effects to slides • Creating your own color schemes, backgrounds, and design templates • Options for distributing a slide show

12. Applying Outlook Features • Outlook is a desktop information management application. • Helps keep track of e-mail messages, appointments, meetings, contact information, and tasks

13. Applying Outlook Features (continued) • Advanced lessons focus on: • Features that make it easier to manage contact information, manage e-mails, and communicate with others • Features and tools that make it easier to schedule events and track progress on tasks

14. Accessing Internet Resources • Microsoft Office 2010 provides quick and easy access to the World Wide Web. • A Browser is a program that connects you to remote computers and gives you the capability to access, view, and download data from the Web. • Microsoft’s browser program is Microsoft Internet Explorer.

15. Accessing Internet Resources (continued) • Searching for Information and Evaluating Web Sites: • Search engine: a tool designed to find information on the Web • Keywords: words that describe the information you are seeking • Hits: search results (the best matching Web sites) • Wildcard: a symbol that allows for variations in the spelling of words

16. Accessing Internet Resources (continued) • Searching for Information and Evaluating Web Sites (cont): • Domain name extensions help to identify the type of entity. • You are responsible for determining the integrity and validity of information from the Internet and its source.

17. Accessing Internet Resources (continued) • Searching for Information and Evaluating Web Sites (cont): • A guide for evaluating information on the Web

18. Accessing Internet Resources (continued) • Revisiting Web Sites: • Bookmark: a link that navigates you to the Web page • Saved in a Favorites folder • A browser keeps track of the sites visited through the History list. • Can be used to quickly revisit a site

19. Accessing Internet Resources (continued) • Revisiting Web Sites (cont): • Folders on the Favorites tab

20. Accessing Internet Resources (continued) • Revisiting Web Sites (cont): • You can easily delete • History list • Temporary Internet files • Cookies • Form data • Passwords Delete Browsing History dialog box

21. Summary In this lesson, you learned: • Microsoft Word is a powerful, full-featured word processor. Its advanced features enable users to further enhance the appearance of documents and save time preparing and editing documents. Developing a document often involves multiple team members, and Word offers several tools to help you share documents and effectively collaborate on projects. 21 21

22. Summary (continued) • Excel is the spreadsheet application in the Microsoft Office suite. Spreadsheets are used primarily for calculating and analyzing data, and Excel’s advanced features enable you to perform complex calculations and in-depth analysis. Excel includes many features that enable you to generate accurate and professional-looking reports, charts, and tables.

23. Summary (continued) • Access is the database application in the Office suite. Databases are used for storing and organizing information. The advanced features in Access give you more control over how database records are viewed, edited, and professionally analyzed. Effectively designed forms and reports help to streamline data entry and editing.

24. Summary (continued) • Microsoft PowerPoint is a presentation graphics program that enables you to create materials for presentations of many kinds. Its advanced features include several tools for customizing slide designs and using multimedia effects to enhance your content. Remote publishing features in PowerPoint enable you to share presentations over the Internet or a network.

25. Summary (continued) • Microsoft Outlook is a desktop information management program that provides several tools for scheduling appointments and meetings, managing and delegating tasks, and communicating with others. Advanced features help you customize the tools to fit your needs. • An enormous amount of information is available on the World Wide Web. Effective search strategies not only save you time, but they also lead you to more relevant sources.

26. Summary (continued) • When you depend on the Web for sources of information, it is your responsibility to determine the integrity and validity of the information and its source. • You can bookmark Web sites that you visit frequently and save the links to the Favorites folder. You can create additional folders to organize your Favorites list. • You can also quickly revisit a site by selecting the Web site from the History list, which can be organized by date, site, most visited, and the order the sites were visited on the current day.