Table of Contents



-5969009544381Revised Dec-12-201700Revised Dec-12-2017-914400-9144000003743325LESSON PLAN 00LESSON PLAN left2722245TestOut Desktop Pro - English 4.1.x 020000TestOut Desktop Pro - English 4.1.x Table of ContentsSection 0.0: Getting Started Information PAGEREF _0daec740-f966-4d76-8fc9-053005d58be44Computer and Internet BasicsSection 1.1: Computer Systems and the Internet PAGEREF _f5515909-cd2e-41af-b70f-8a410eeba9aa5Section 1.2: The Windows Operating System PAGEREF _0a26f71b-0b27-47cb-a3b0-946877e805d66Section 1.3: File Management PAGEREF _a368e0a3-0192-44d9-856d-85ba0bc21cdd7Section 1.4: Networking and System Updates PAGEREF _0eb9ce17-1248-49b0-893e-4b84bba0be7a8Section 1.5: Online Safety and Security PAGEREF _51dfea64-b141-4de1-acf2-39aa8ed0abb29Section 1.6: Computer Hardware PAGEREF _7028118d-fd5e-4b0b-bb9d-dd3ad5ebaffe10Section 1.7: Microsoft Office Application Features PAGEREF _f7d72278-5a89-468d-9486-be999ea2968611Microsoft WordSection 2.1: Introduction to Word PAGEREF _e02266ee-14a4-4f5d-9382-99ea4b786abe12Section 2.2: Creating Documents PAGEREF _850f2bc8-8b10-4b0f-84a5-f6294eea5ceb13Section 2.3: Managing and Printing Documents PAGEREF _95ba9ad5-55d3-43a8-9c66-9815c5a3ba0a14Section 2.4: Modifying Fonts PAGEREF _b008d21e-2ce8-4749-8305-9f3e150fd94a15Section 2.5: Formatting Paragraphs PAGEREF _718ca552-3c0e-4259-8d9b-a9535aa21a5a16Section 2.6: Formatting Pages PAGEREF _328a45f2-9195-4907-a188-5981a8dadaad17Section 2.7: Editing Documents PAGEREF _5c4b7ba6-4d05-4a7f-808c-99ad7d64a29418Section 2.8: Inserting Illustrations and Other Elements PAGEREF _17c4de11-4975-4e77-aa56-85ad5d0ce1cf19Section 2.9: Creating and Formatting Tables PAGEREF _7c6a12fc-77ce-4ae7-8197-d7257899891d20Section 2.10: Using Themes, Styles, and Templates PAGEREF _2dfaf23e-ba19-495f-bf68-5596189275b921Section 2.11: Managing References PAGEREF _adfe4d57-07eb-4c06-976b-06ef5f5516e322Section 2.12: Managing Headers, Footers, and Sections PAGEREF _6f142b8c-2bf2-4f2b-98f5-7cb40cfbdc8123Microsoft ExcelSection 3.1: Introduction to Excel PAGEREF _56da7100-ea86-462a-b49f-541a2fb0e18524Section 3.2: Creating and Managing Workbooks PAGEREF _722dc1da-37cc-411e-8733-923293316abc25Section 3.3: Organizing and Entering Data PAGEREF _cef2ef12-6038-46bf-9f7c-19a178f9302f26Section 3.4: Changing Properties and Printing Worksheets PAGEREF _3b09c9d6-7db6-48b2-933a-d337daa9f3cc27Section 3.5: Formatting Cells PAGEREF _8c011d7a-f633-40cd-a72b-4eebf651b55428Section 3.6: Entering Simple Formulas PAGEREF _315062da-679c-40a7-945e-35d7f453ce1130Section 3.7: Using Advanced Functions PAGEREF _b29ce491-33f1-4b5a-8f76-49a8f4d0ee4531Section 3.8: Analyzing Data in Charts PAGEREF _fd92735b-b7a0-4974-88fc-bd048b5fb52632Section 3.9: Analyzing Data in Tables PAGEREF _3c3fad4b-0bad-478b-b2dc-e9b6d53c50d533Microsoft PowerPointSection 4.1: Introduction to PowerPoint PAGEREF _ed61d61a-1e31-4107-b80d-30e2559a48c734Section 4.2: Creating and Managing Presentations PAGEREF _c1542395-b838-4123-b29c-23c26a9b81d835Section 4.3: Formatting Textual Content PAGEREF _86cfbd69-b19b-465f-bbca-f71d1487d32d36Section 4.4: Designing Slides PAGEREF _eb5b7786-39ef-4fe1-bed7-08adfb4f102f37Section 4.5: Using the Slide Master PAGEREF _bbcecc3e-aa87-49f0-801a-caa5bd62231a38Section 4.6: Formatting Illustrations and Tables PAGEREF _0cb1fca7-c4dd-48e5-9680-35fd747df97b39Section 4.7: Formatting Pictures and Other Media PAGEREF _659909c0-88c8-4cc5-a46d-2fb50a6a19bf40Section 4.8: Applying Animations and Transitions PAGEREF _c6fc9953-497b-4e6b-80af-0b4cbdd78e6f41Section 4.9: Delivering Presentations PAGEREF _91d99fe9-df65-455a-bbb1-2c9e0cbdbf6442Microsoft AccessSection 5.1: Introduction to Access PAGEREF _7fa860d8-a582-44ef-82e6-00e0b9f31db343Section 5.2: Managing Databases PAGEREF _839cd7c7-e648-4937-8c5b-c5b8911eff4d44Section 5.3: Designing and Creating Tables PAGEREF _5e519127-bfe1-4d45-98b5-78be16feaedf45Section 5.4: Using Simple Queries PAGEREF _39ffc58d-3eb5-4945-b318-2b9e0f56565646Section 5.5: Creating Forms PAGEREF _b61ce717-91ed-4c24-a784-cb062b2a5a9247Section 5.6: Creating Reports PAGEREF _4891a9c9-7d29-4903-b7a3-d559a36f848a48Desktop Pro Practice ExamsDesktop Pro Certification Practice Exams PAGEREF _practiceExams49AppendicesAppendix A: Course Objectives PAGEREF _appendixA50Appendix B: Approximate Time for the Course PAGEREF _appendixB640.0: Getting Started InformationSummaryVideo/DemoTime0.1 Video: Introduction to Desktop Pro7:04Total Video Time7:04Fact Sheets0.2 Course Overview0.3 Course Objectives0.4 Pop-up Blockers0.5 Tips for Mac Users0.6 Using the Simulated Labs0.7 Keyboard Shortcuts in LabsTotal TimeAbout 38 minutes1.1: Computer Systems and the InternetSummaryAs you study this section, answer the following questions: What are the essential components of a desktop computer system?How can you perform Internet searches on different Web browsers?What are some common troubleshooting tips to consider when browsing the Web?This section introduces you to desktop computer systems and Web browsers. After finishing this section, you should be proficient in the following tasks: Open a Windows application.Use a Web browser to navigate to a particular website.Save and access bookmarks in a Web browser.Perform an Internet search.Copy and paste a URL into the Address bar of a Web browser.Delete your Web browser's cache.Configure your Web browser to allow pop-ups from a particular domain.Video/DemoTime1.1.1 Introduction to Desktop Computer Systems4:491.1.3 Using a Web Browser4:501.1.4 Web Browser Troubleshooting3:56Total Video Time13:35Lab/Activity1.1.9 Skills Lab: Web Browsing with Internet ExplorerFact Sheets1.1.2 Desktop Computer System Facts1.1.5 Microsoft Internet Explorer Facts1.1.6 Google Chrome Facts1.1.7 Mozilla Firefox Facts1.1.8 Microsoft Edge FactsTotal TimeAbout 59 minutes1.2: The Windows Operating SystemSummaryAs you study this section, answer the following questions: What is the difference between computer hardware and software?What is the purpose of an operating system?How can the Windows operating system be configured through the Settings App?This section introduces you to the Windows 10 operating system and gives you practice running applications and using the Windows user interface. After finishing this section, you should be proficient in the following tasks: Change display settings in Windows.Use the Settings App to view system information.Configure a screen saver through the Settings App.Run Windows applications.Pin applications to the Start Menu and the taskbar.Unpin applications from the Start Menu and the taskbar.Create application shortcuts on the Windows desktop.Video/DemoTime1.2.1 Operating System Functions1:561.2.3 The Windows 10 Operating System3:531.2.5 Desktop Applications3:371.2.7 Windows Settings2:49Total Video Time12:15Lab/Activity1.2.9 Skills Lab: Explore Windows 10 Features1.2.10 Applied Lab: Use the Windows 10 User Interface1.2.11 Applied Lab: Change Display Settings1.2.12 Applied Lab: Run Desktop ApplicationsFact Sheets1.2.2 Common Operating Systems1.2.4 Windows 10 Components1.2.6 Desktop Application Facts1.2.8 Windows Settings FactsTotal TimeAbout 83 minutes1.3: File ManagementSummaryAs you study this section, answer the following questions: What are the advantages and disadvantages of different file storage options?How is cloud storage different from local file storage?When is it appropriate to share file storage with other users?This section introduces you to file storage options and gives you practice managing files in Windows. After finishing this section, you should be proficient in the following tasks: Create folders in the Windows file system.Copy, rename, and delete files in Windows.Copy files from the local Windows file system to OneDrive.Connect a USB thumb drive to a desktop computer and copy files from the drive to your local file system.Remove USB devices properly.Share a Windows folder with other users and grant them specific access to files within the folder.Use the Windows Recycle Bin.Video/DemoTime1.3.1 Storage Devices4:071.3.3 Windows File Management6:051.3.5 Shared Storage3:101.3.7 Cloud Storage4:41Total Video Time18:03Lab/Activity1.3.9 Skills Lab: Manage and Share Files in Windows1.3.10 Applied Lab: Manage Files1.3.11 Applied Lab: Copy Files from a USB Thumb Drive1.3.12 Applied Lab: Use Shared Storage1.3.13 Applied Lab: Use OneDrive StorageFact Sheets1.3.2 File Storage Options1.3.4 Windows File Management Facts1.3.6 Shared Storage Facts1.3.8 Windows Cloud Storage FactsTotal TimeAbout 99 minutes1.4: Networking and System UpdatesSummaryAs you study this section, answer the following questions: What are the characteristics of a strong password?What is the purpose of Windows Update?What hardware components are needed for a wired network? A wireless network?This section introduces you to computer networking and gives you practice creating user accounts, connecting to wireless networks, and configuring Windows Update. After finishing this section, you should be proficient in the following tasks: Create a local account for a user who already has a Microsoft login.Create a non-Microsoft user account.Connect to a secure wireless network.Configure Windows Update to install updates automatically.Video/DemoTime1.4.1 Wired and Wireless Networks3:121.4.3 The Internet3:181.4.5 Windows User Accounts3:071.4.7 Windows Update2:49Total Video Time12:26Lab/Activity1.4.9 Skills Lab: Use Networks and Windows Update1.4.10 Applied Lab: Create a User1.4.11 Applied Lab: Connect to a Wireless Network1.4.12 Applied Lab: Configure Windows UpdateFact Sheets1.4.2 Networking Facts1.4.4 Internet Facts1.4.6 Windows User Account Facts1.4.8 Windows Update FactsTotal TimeAbout 83 minutes1.5: Online Safety and SecuritySummaryAs you study this section, answer the following questions: What are the most common types of computer security risks?What can you do to protect yourself against Internet security risks?What are some ethical principles that encourage responsibility and trust in working with computers?This section introduces you to online safety and security issues and gives you practice configuring security settings and responding to social engineering tactics. After finishing this section, you should be proficient in the following tasks: Configure Windows Firewall for different networks.Configure privacy settings in Internet Explorer.Clear the browser history within Internet Explorer.Configure the Internet Explorer pop-up blocker.Evaluate email messages to determine if they are safe or if they represent a possible social engineering attack.Video/DemoTime1.5.1 Computer Security Risks4:471.5.3 Windows Firewall5:181.5.4 Malware Protection on Windows4:011.5.6 Web Browsers and Email7:301.5.8 Internet Safety and Security7:58Total Video Time29:34Lab/Activity1.5.12 Skills Lab: Practice Online Safety and Security1.5.13 Applied Lab: Configure Windows Firewall1.5.14 Applied Lab: Configure Privacy Settings in IE1.5.15 Applied Lab: Clear the Browser Cache1.5.16 Applied Lab: Respond to Social Engineering1.5.17 Applied Lab: Configure the IE Popup BlockerFact Sheets1.5.2 Computer Security Risks1.5.5 Windows 10 Security Measures1.5.7 Rules of Netiquette1.5.9 Internet Safety Facts1.5.10 Social Media Facts1.5.11 Computer EthicsTotal TimeAbout 130 minutes1.6: Computer HardwareSummaryAs you study this section, answer the following questions: Which types of computer devices are most appropriate for different types of users?What hardware components are generally required for a desktop computing system?What are the advantages and disadvantages of different types of printers?This section introduces you to computer hardware components and gives you practice setting up computer devices. After finishing this section, you should be proficient in the following tasks: Identify common peripheral devices by sight.Identify common ports and connectors by sight.Connect cables and peripherals to a computer system.Select appropriate hardware devices for particular scenarios.Video/DemoTime1.6.1 Desktop and Mobile Devices4:061.6.3 PC Hardware Components5:231.6.5 PC Ports and Connectors3:291.6.7 Peripheral Devices4:471.6.9 Printers2:181.6.11 Using the Hardware Simulator5:23Total Video Time25:26Lab/Activity1.6.12 Skills Lab: Connect Computer Devices1.6.13 Applied Lab: Connect a Monitor1.6.14 Applied Lab: Set Up a Computer1.6.15 Applied Lab: Install USB Devices1.6.16 Applied Lab: Connect a PrinterFact Sheets1.6.2 Desktop vs. Mobile Devices1.6.4 PC Hardware Facts1.6.6 PC Port and Connector Facts1.6.8 Peripheral Device Facts1.6.10 Printer FactsTotal TimeAbout 111 minutes1.7: Microsoft Office Application FeaturesSummaryAs you study this section, answer the following questions: What features are common to all Microsoft Office applications?What is the difference between a desktop application and a Web application?What components are required to send a document to a printer?This section introduces you to Microsoft Office application features and gives you practice setting up shared printers and printing from Office applications. After finishing this section, you should be proficient in the following tasks: Connect to a shared printer.Configure the default printer.Share a local printer with other users.Open and print a document from Microsoft Word.Open and print a spreadsheet from Microsoft Excel.Video/DemoTime1.7.1 Office Application Features: The Ribbon3:011.7.2 Office Application Features: Beyond the Ribbon4:181.7.5 Windows Printing Features4:29Total Video Time11:48Lab/Activity1.7.7 Skills Lab: Set up Printing with Microsoft Office1.7.8 Applied Lab: Connect to a Printer1.7.9 Applied Lab: Share a Printer1.7.10 Applied Lab: Open and Print a Document in WordFact Sheets1.7.3 Common Office Application Features1.7.4 Desktop vs. Web Applications1.7.6 Windows Printing FactsTotal TimeAbout 77 minutes2.1: Introduction to WordSummaryAs you study this introductory section, answer the following questions: Which features of Microsoft Word do you already feel comfortable using?Which features are you less familiar with?What types of documents would you like to create in the future?This section introduces you to Microsoft Word and provides an overview of the features you will be learning to use. In this section, you will be introduced to the following general tasks: Create documents.Use the Clipboard.Print documents.Modify fonts.Format paragraphs.Format pages.Edit documents.Insert illustrations.Create and format tables.Apply themes and styles.Manage citations and references.Work with headers and footers.Video/DemoTime2.1.1 Learning Office Applications4:242.1.2 Lab Types4:302.1.3 Introduction to Word2:19Total Video Time11:13Fact Sheets2.1.4 Word Tasks OverviewTotal TimeAbout 17 minutes2.2: Creating DocumentsSummaryAs you study this section, answer the following questions: What are some situations when you might want to paste text from the Clipboard using the Keep Text Only option?Does the Ctrl + V keyboard shortcut keep or remove formatting of inserted text?How can using Undo and Redo help you to learn how to use unfamiliar Word features?This section gives you extensive practice creating and working in Word documents. After finishing this section, you should be proficient in the following tasks: Create a new blank document.Open a downloaded document and enable editing.Move the insertion point.Enter text into a document.Select words, lines, and paragraphs.Delete text.Copy and cut text to the Clipboard.Paste formatted and unformatted text from the Clipboard.Clear the Clipboard.Undo or redo an action.Close a document.Reorganize the content in a document.Paste text from a website into a Word document.Video/DemoTime2.2.1 Text Selection3:082.2.2 The Clipboard4:15Total Video Time7:23Lab/Activity2.2.4 Skills Lab: Create Documents2.2.5 Challenge Lab: Create Documents2.2.7 Applied Lab: Prepare a Business Memo2.2.8 Applied Lab: Reorganize Class NotesFact Sheets2.2.3 Document Creation Facts2.2.6 Document Creation TipsTotal TimeAbout 78 minutes2.3: Managing and Printing DocumentsSummaryAs you study this section, answer the following questions: When is it appropriate to save a document as a .docx, PDF, or plain text file?What is the main purpose of document tags (configured in the document properties)?What printing options are appropriate to use in different scenarios?How will ScreenTips help you to learn Word with more confidence?This section gives you extensive practice managing and printing documents. After finishing this section, you should be proficient in the following tasks: Modify document properties.View document statistics.Save a Word document in various formats, including PDF and plain text.Print a custom range of pages in a document.Print from a non-default printer.Collapse and pin the ribbon.Use ScreenTip help.Scroll through a document.Prepare a document to be uploaded to the Web.Prepare a document to be distributed within a company.Video/DemoTime2.3.1 Document File Formats3:262.3.2 Word Printing Tips3:47Total Video Time7:13Lab/Activity2.3.4 Skills Lab: Manage and Print Documents2.3.5 Challenge Lab: Manage and Print Documents2.3.7 Applied Lab: Distribute a Company Memo2.3.8 Applied Lab: Prepare a Document for the WebFact Sheets2.3.3 Document Management Facts2.3.6 Document Management TipsTotal TimeAbout 78 minutes2.4: Modifying FontsSummaryAs you study this section, answer the following questions: What are the most important keyboard shortcuts associated with modifying fonts?Which practices should be avoided when working with fonts?Which types of fonts are generally best for displaying on-screen?Which fonts are easier to read on printed paper?This section gives you extensive practice modifying text within a Word document. After finishing this section, you should be proficient in the following tasks: Bold, italicize, or underline a selection of text.Modify the case of a word.Change the font color of selected text.Apply a superscript.Apply a subscript.Change the font size of selected text.Change the font of selected text.Apply a Text Effect to selected text.Apply Text Highlighting to selected text.Format the fonts in a resume.Create a math worksheet.Choose and format the fonts in an advertising flyer.Video/DemoTime2.4.1 Font Changes3:562.4.2 Font Choices3:53Total Video Time7:49Lab/Activity2.4.4 Skills Lab: Modify Fonts2.4.5 Challenge Lab: Modify Fonts2.4.7 Applied Lab: Prepare a Resume2.4.8 Applied Lab: Format a Math WorksheetFact Sheets2.4.3 Font Facts2.4.6 Font TipsTotal TimeAbout 78 minutes2.5: Formatting ParagraphsSummaryAs you study this section, answer the following questions: What is the difference between line and paragraph spacing?When is it appropriate to use a first line indent in a document? A hanging indent? A left indent?What paragraphs are affected by changing the widow/orphan control options?When is it appropriate to use a bulleted list? A numbered list?This section gives you extensive practice formatting paragraphs in a document. After finishing this section, you should be proficient in the following tasks: Align a paragraph to the left, right, or center of the page.Show and hide formatting symbols.Clear formatting within a selection.Change the line spacing for paragraphs.Change the spacing before and after a paragraph.Change paragraph indents.Apply a border to a paragraph.Apply shading to a paragraph.Set orphan/widow paragraph control options.Create a numbered list.Modify list numbering options.Create a bulleted list.Customize bullets.Adjust the indent level for lists.Format a series of lists in a document.Implement paragraph specifications for an academic paper.Video/DemoTime2.5.1 Paragraph and Line Spacing4:132.5.2 Indentation and Tabs4:272.5.3 Bulleted and Numbered Lists3:412.5.4 Paragraph Borders and Shading3:15Total Video Time15:36Lab/Activity2.5.6 Skills Lab: Format Paragraphs2.5.7 Challenge Lab: Format Paragraphs2.5.9 Applied Lab: Format Research Paper Paragraphs2.5.10 Applied Lab: Format ListsFact Sheets2.5.5 Paragraph Formatting Facts2.5.8 Paragraph Formatting TipsTotal TimeAbout 86 minutes2.6: Formatting PagesSummaryAs you study this section, answer the following questions: How can formatting pages add a more professional look to your documents?When is it appropriate to use portrait orientation? Landscape orientation?How is inserting a page break different from pressing Enter multiple times until you get to a new page?How can understanding tab stops make creating some types of documents easier?This section gives you extensive practice formatting pages in a document. After finishing this section, you should be proficient in the following tasks: Add a watermark to a page.Add a page border.Create and format multiple columns on a page.Insert and modify tab stops.Add dot leaders to tabs.Modify page margins.Modify page orientation.Insert a page break.Insert a column break.Align text vertically on a page.Format a report as a draft.Format only part of a document into two columns.Insert manual page breaks where needed in a document.Video/DemoTime2.6.1 Page Layout Options3:242.6.2 Page and Column Breaks2:212.6.3 Tab Stops2:19Total Video Time8:04Lab/Activity2.6.5 Skills Lab: Format Pages2.6.6 Challenge Lab: Format Pages2.6.8 Applied Lab: Format a Report Draft2.6.9 Applied Lab: Format a Music ProgramFact Sheets2.6.4 Page Formatting Facts2.6.7 Page Formatting TipsTotal TimeAbout 79 minutes2.7: Editing DocumentsSummaryAs you study this section, answer the following questions: When can you safely ignore potential errors that are flagged by the spelling and grammar checker?To what extent should you rely on the spelling and grammar checker to correct errors?When would you want to customize AutoCorrect to meet the needs of particular writing projects?This section gives you extensive practice editing Word documents. After finishing this section, you should be proficient in the following tasks: Find and replace a particular word within a document.Turn automatic spelling and grammar checking on and off.Use the spelling and grammar checker.Use the thesaurus to find synonyms.Count the total words in a document.Correct errors while typing with AutoCorrect.Customize AutoCorrect settings.Modify an AutoCorrect entry.Remove a hyperlink from text.Identify default AutoCorrect changes that might need to be modified.Ignore spelling and grammar suggestions when appropriate.Video/DemoTime2.7.1 AutoCorrect Options3:052.7.2 Spell Checking2:132.7.3 The Thesaurus4:10Total Video Time9:28Lab/Activity2.7.5 Skills Lab: Edit Documents2.7.6 Challenge Lab: Edit Documents2.7.8 Applied Lab: Edit an Essay2.7.9 Applied Lab: Edit a Newspaper ArticleFact Sheets2.7.4 Document Editing Facts2.7.7 Document Editing TipsTotal TimeAbout 80 minutes2.8: Inserting Illustrations and Other ElementsSummaryAs you study this section, answer the following questions: How can you effectively use graphics in your more creative documents?Which text wrap settings are typically the most appropriate for images inserted into a document?How can picture styles enhance or detract from the quality of your documents?This section gives you extensive practice using illustrations, pictures, and other graphics. After finishing this section, you should be proficient in the following tasks: Insert a picture from a file.Insert a picture from the Internet.Resize a picture or graphic.Move and align an image.Modify picture styles.Insert a symbol.Insert a shape.Insert the current date into a document.Delete a picture or graphic.Modify text wrap settings for visual appeal.Apply best practices in using graphics.Video/DemoTime2.8.1 Text Wrap Options2:502.8.2 Illustration Formatting4:00Total Video Time6:50Lab/Activity2.8.4 Skills Lab: Insert Illustrations2.8.5 Challenge Lab: Insert Illustrations2.8.7 Applied Lab: Insert Images for a Poster2.8.8 Applied Lab: Insert Images for a FlyerFact Sheets2.8.3 Word Illustration Facts2.8.6 Word Illustration TipsTotal TimeAbout 77 minutes2.9: Creating and Formatting TablesSummaryAs you study this section, answer the following questions: When can a table present information more effectively than a standard bulleted or numbered list?What is the easiest way to make a table more visually appealing?What is the difference between a header row or column, and a banded row or column?This section gives you extensive practice creating and modifying tables. After finishing this section, you should be proficient in the following tasks: Insert a blank table into a document.Add additional columns to an existing table.Add additional rows to an existing table.Modify cell alignment.Split or merge table cells.Format table cells.Convert a table to text.Enter or delete table data.Apply a table style.Use AutoFit to resize table columns to fit contents.Center or align a table.Delete rows and columns.Format the header row and other table style options.Align table data for better readability.Apply table styles that increase readability and visual appeal.Video/DemoTime2.9.1 Word Tables3:022.9.2 Table Formatting5:01Total Video Time8:03Lab/Activity2.9.4 Skills Lab: Create and Format Tables2.9.5 Challenge Lab: Create and Format Tables2.9.7 Applied Lab: Format a Calendar2.9.8 Applied Lab: Format Tables for a Sales ReportFact Sheets2.9.3 Word Table Facts2.9.6 Word Table TipsTotal TimeAbout 79 minutes2.10: Using Themes, Styles, and TemplatesSummaryAs you study this section, answer the following questions: What is the relationship between themes, styles, and style sets?How can using styles make it easier to change the look and feel of your documents?What kinds of documents can you create using a template?This section gives you extensive practice using styles, style groups, and themes. After finishing this section, you should be proficient in the following tasks: Create a document from an existing template.Remove content controls in a template.Modify the theme font.Apply heading styles to paragraphs.Modify text formatting using Format Painter.Change the theme for a document.Select a style set for a document.Edit an existing style.Format a newsletter to achieve both readability and visual appeal.Apply font and paragraph styles to an academic paper.Create a certificate using a template.Video/DemoTime2.10.1 Word Styles3:442.10.2 Themes and Style Sets4:042.10.3 Word Templates2:58Total Video Time10:46Lab/Activity2.10.5 Skills Lab: Use Themes, Styles, and Templates2.10.6 Challenge Lab: Use Themes, Styles, and Templates2.10.8 Applied Lab: Create a Certificate Using a Template2.10.9 Applied Lab: Format a NewsletterFact Sheets2.10.4 Word Theme & Style Facts2.10.7 Word Theme & Style TipsTotal TimeAbout 81 minutes2.11: Managing ReferencesSummaryAs you study this section, answer the following questions: Why is it important to properly cite your sources when writing a paper?How can using Word's citation tools make your papers easier to write?How can you know whether to use footnotes, endnotes, or in-text citations?This section gives you extensive practice creating and citing references. After finishing this section, you should be proficient in the following tasks: Insert a new citation source for a document.Edit a citation to add a page number.Insert a bibliography of current sources for a document.Insert a footnote at the bottom of the page.Insert an endnote.Modify the number format of footnotes.Edit a citation source.Convert a citation to static text.Import a citation source into the current document.Update a bibliography.Cite sources for an academic paper using the MLA, Chicago, and APA citation styles.Video/DemoTime2.11.1 Citations and References4:172.11.2 Footnotes, Endnotes, and Advanced Citations5:04Total Video Time9:21Lab/Activity2.11.4 Skills Lab: Manage References2.11.5 Challenge Lab: Manage References2.11.7 Applied Lab: Manage Essay References2.11.8 Applied Lab: Add Sources and Footnotes for Research ReportFact Sheets2.11.3 Reference Facts2.11.6 Reference TipsTotal TimeAbout 80 minutes2.12: Managing Headers, Footers, and SectionsSummaryAs you study this section, answer the following questions: When do you need to add a section break in a document?What information is most commonly entered into a header or a footer?What is the difference between a Next Page section break and a Continuous section break?This section gives you extensive practice managing headers, footers, and sections within a document. After finishing this section, you should be proficient in the following tasks: Insert information into the header or footer, including date and time, page number, and filename.Suppress the page number on the first page of a document.Restart page numbering for a new section.Close the header and footer.Insert a Next Page section break.Insert a Continuous section break.Format a section with a different page orientation.Begin numbering a formal document on the third page.Change document formatting from one column to two columns in the middle of a page.Video/DemoTime2.12.1 Headers and Footers4:092.12.2 Header and Footer Options2:572.12.3 Next Page Section Breaks4:332.12.4 Continuous Section Breaks4:27Total Video Time16:06Lab/Activity2.12.6 Skills Lab: Manage Headers, Footers, and Sections2.12.7 Challenge Lab: Manage Headers, Footers, and Sections2.12.9 Applied Lab: Format a Research Paper with Sections2.12.10 Applied Lab: Format a Survey ReportFact Sheets2.12.5 Word Header, Footer, & Section Facts2.12.8 Word Header, Footer, & Section TipsTotal TimeAbout 87 minutes3.1: Introduction to ExcelSummaryAs you study this introductory section, answer the following questions: Which features of Excel do you already feel comfortable using?Which features are you less familiar with?How can you use Excel for personal projects, such as data or financial analysis?This section introduces you to Microsoft Excel and provides an overview of the features you will be learning to use. In this section, you will be introduced to the following general tasks: Create workbooks.Manage worksheets.Enter data.Protect worksheets.Print worksheets.Format cells.Enter simple formulas.Use advanced functions.Create charts and graphs.Analyze data in tables.Video/DemoTime3.1.1 Introduction to Excel2:22Total Video Time2:22Fact Sheets3.1.2 Excel Tasks OverviewTotal TimeAbout 8 minutes3.2: Creating and Managing WorkbooksSummaryAs you study this section, answer the following questions: What are the best ways to organize your data into worksheets?What are the benefits of using multiple worksheets in the same workbook?How can you use Excel to keep your data organized?When should you save your workbook in a different file format?This section gives you extensive practice managing workbooks. After finishing this section, you should be proficient in the following tasks: Open a workbook.Create a new blank workbook.Change workbook properties.Enable editing to exit the Protected View.Insert and delete worksheets.Navigate between worksheets.Save a workbook in Excel format, in a character-separated values format (both tabs and commas), and as a PDF file.Rename worksheets.Reorder and color worksheet tabs.Move and copy a worksheet.Import data from a comma-separated text file.Collapse and pin the ribbon.Import data from various applications into Excel.Video/DemoTime3.2.1 Spreadsheet Basics3:263.2.2 Worksheet Management1:513.2.3 External Data2:45Total Video Time8:02Lab/Activity3.2.5 Skills Lab: Create and Manage Workbooks3.2.6 Challenge Lab: Create and Manage Workbooks3.2.8 Applied Lab: Organize Budget Worksheets3.2.9 Applied Lab: Import & Organize Research DataFact Sheets3.2.4 Workbook Management Facts3.2.7 Workbook Management TipsTotal TimeAbout 79 minutes3.3: Organizing and Entering DataSummaryAs you study this section, answer the following questions: What is the relationship between rows and columns in your workbook?When can you save time by copying and pasting rather than entering data by hand?When is it appropriate to delete an entire row or column, as opposed to deleting the data in the row or column?How can the Undo and Redo commands help you learn Excel?This section gives you extensive practice organizing and entering data into worksheets. After finishing this section, you should be proficient in the following tasks: Select a single cell and a range of cells.Enter worksheet titles.Enter column and row titles.Freeze column and row titles and panes.Enter text and numbers into cells.Use the Copy and Cut commands on cell ranges.Use paste options.Insert rows and columns into a sheet.Insert multiple rows in one operation.Delete and clear rows and columns.Hide and unhide rows and columns.Undo and redo actions.Manage a worksheet that contains a large data set.Insert new data between rows or columns.Divide data sets appropriately between worksheets.Video/DemoTime3.3.1 Deleting and Clearing Cells1:593.3.2 Copy and Paste Options3:423.3.3 Large Data Sets4:04Total Video Time9:45Lab/Activity3.3.5 Skills Lab: Organize and Enter Data3.3.6 Challenge Lab: Organize and Enter Data3.3.8 Applied Lab: Enter Survey Results Data3.3.9 Applied Lab: Organize Sales DataFact Sheets3.3.4 Data Entry Facts3.3.7 Data Entry TipsTotal TimeAbout 80 minutes3.4: Changing Properties and Printing WorksheetsSummaryAs you study this section, answer the following questions: What do you want your document to look like when it's printed?What are the advantages and disadvantages to printing a spreadsheet?How can you use document protection to help others use your workbook?When is it best to protect an entire worksheet? When is it best to leave some cells unprotected?This section gives you extensive practice printing and protecting worksheets. After finishing this section, you should be proficient in the following tasks: Lock and unlock cells.Protect worksheets and workbooks from changes.Edit workbook properties.Preview and print a worksheet.Set and clear the print area for a worksheet.Change worksheet margins.Create and modify a worksheet header.Create a worksheet footer.Change worksheet orientation for printing.Scale a worksheet to be printed on a single page.Add print titles.Prevent particular cells from being modified.Print a particular section of worksheet data.Include relevant worksheet properties in a printout.Optimize the printing of a worksheet.Video/DemoTime3.4.1 Data Protection3:053.4.2 Excel Printing Tips3:17Total Video Time6:22Lab/Activity3.4.4 Skills Lab: Change Properties and Print Worksheets3.4.5 Challenge Lab: Change Properties and Print Worksheets3.4.7 Applied Lab: Prepare and Print Sales Data3.4.8 Applied Lab: Protect a Budget WorksheetFact Sheets3.4.3 Worksheet Printing Facts3.4.6 Worksheet Printing TipsTotal TimeAbout 77 minutes3.5: Formatting CellsSummaryAs you study this section, answer the following questions: How does making your worksheet better looking increase its utility?When would it make sense to merge several cells together?How can you use number formatting to make your spreadsheet easier to use?How can colors communicate useful information to the user?This section gives you extensive practice formatting worksheet cells. After finishing this section, you should be proficient in the following tasks: Apply font style, size, and color changes to cells.Apply cell styles.Change the fill color (shading).Merge and center a range of cells.Apply number formatting to cells.Apply the percent style to cells.Increase and decrease decimal spaces.Enter and format dates.Adjust column widths (including AutoFit).Resolve the ###### error message.Adjust row heights.Align cell content.Rotate cell content.Clear cell formatting.Apply borders and border colors.Enter multiple lines of text (apply word wrap setting).Format cells as column or row totals.Adjust columns to display both numeric and textual data properly.Format a range of cells as a worksheet title.Video/DemoTime3.5.1 Number Formats3:153.5.2 Cell Formats4:183.5.3 Cell Styles and Colors2:063.5.4 Cell Borders2:31Total Video Time12:10Lab/Activity3.5.6 Skills Lab: Format Cells3.5.7 Challenge Lab: Format Cells3.5.9 Applied Lab: Camping Equipment Store3.5.10 Applied Lab: Format a DirectoryFact Sheets3.5.5 Cell Formatting Facts3.5.8 Cell Formatting TipsTotal TimeAbout 83 minutes3.6: Entering Simple FormulasSummaryAs you study this section, answer the following questions: How can formulas increase the power of your spreadsheet?When should you use arithmetic operators (+, -, *, /) in your formulas?When should you use built-in functions in your formulas?How can the AutoSum tool save you time?This section gives you extensive practice entering simple formulas into Excel. After finishing this section, you should be proficient in the following tasks: Enter a formula using the keyboard.Use the mouse to reference cells in a formula.Copy a formula using the fill handle.Copy a formula using the Clipboard.Sum a column or row using AutoSum.Calculate the MAX, MIN, AVERAGE, and MEDIAN of a data set.Use arithmetic operations properly in formulas.Add columns and rows of data.Copy formulas to cells that require similar calculations.Perform simple arithmetic that references cell values.Use AutoFill to enter data that follow a predictable pattern.Video/DemoTime3.6.1 AutoFill Options3:393.6.2 Excel Formulas3:58Total Video Time7:37Lab/Activity3.6.4 Skills Lab: Enter Simple Formulas3.6.5 Challenge Lab: Enter Simple Formulas3.6.7 Applied Lab: Cheese Shop3.6.8 Applied Lab: GradebookFact Sheets3.6.3 Formula Facts3.6.6 Formula TipsTotal TimeAbout 78 minutes3.7: Using Advanced FunctionsSummaryAs you study this section, answer the following questions: How can Excel make use of the same logic you use in everyday life?What should you do when you see an error message in Excel?Where can you find information about unfamiliar functions?How can multiple functions work together?This section gives you extensive practice entering more advanced functions into Excel. After finishing this section, you should be proficient in the following tasks: Enter a function using the Insert Function box.Display and hide formulas.Enter a formula using absolute references.Enter a formula using relative references.Use the IF function.Use COUNTIF, SUMIF, and AVERAGEIF.Use functions with multiple arguments.Copy a formula with absolute references.Copy a formula with relative references.Correct or ignore error messages, as appropriate.Select appropriate functions to perform conditional operations.Determine when to use an absolute reference in a formula.Verify that the desired values have been properly referenced within a formula.Video/DemoTime3.7.1 Relative and Absolute References3:123.7.2 The IF Function3:533.7.3 Logical Functions2:553.7.4 Excel Error Messages2:43Total Video Time12:43Lab/Activity3.7.6 Skills Lab: Use Advanced Functions3.7.7 Challenge Lab: Use Advanced Functions3.7.9 Applied Lab: County Fair3.7.10 Applied Lab: Toy CompanyFact Sheets3.7.5 Advanced Function Facts3.7.8 Advanced Function TipsTotal TimeAbout 83 minutes3.8: Analyzing Data in ChartsSummaryAs you study this section, answer the following questions: Why is it important to visualize your data?What problems could be caused by using the wrong chart type?What formatting options will make your chart more usable? Which ones will make it less usable?What information should you include in your chart? What information can you safely omit?This section gives you extensive practice creating and formatting charts in Excel. After finishing this section, you should be proficient in the following tasks: Select a data source for a chart.Add a data series to an existing chart.Insert a clustered column chart.Create a pie chart.Move a chart on a worksheet.Move a chart to its own worksheet.Resize a chart.Modify a chart style and type.Format chart elements.Show and hide chart elements.Use recommended charts.Insert a chart to show changes over time.Insert a chart to display the aggregate of a set of values.Modify chart layouts to better visualize data.Video/DemoTime3.8.1 Chart Formatting2:383.8.2 Chart Types2:23Total Video Time5:01Lab/Activity3.8.4 Skills Lab: Analyze Data in Charts3.8.5 Challenge Lab: Analyze Data in Charts3.8.7 Applied Lab: Stock Portfolio3.8.8 Applied Lab: Election ResultsFact Sheets3.8.3 Chart Facts3.8.6 Chart TipsTotal TimeAbout 76 minutes3.9: Analyzing Data in TablesSummaryAs you study this section, answer the following questions: What are some real-world benefits of using tables?Why would you want to be able to sort and filter your data?When could conditional formatting help you to understand your data better?Why should you concern yourself with removing duplicate information from your tables?This section gives you extensive practice using tables. After finishing this section, you should be proficient in the following tasks: Create a table.Apply table styles.Insert table rows and columns.Add a total row.Sort a table.Remove duplicate rows.Filter a table using AutoFilter options.Apply highlight cell rules for conditional formatting.Apply data bars for conditional formatting.Determine when a data set should be converted to a table.Sort rows of data based on the values in particular columns.Use both text and number filters to display only desired information.Conditionally format cells that contain the most important data.Video/DemoTime3.9.1 Conditional Formatting2:383.9.2 Excel Tables2:313.9.3 Table Customization2:40Total Video Time7:49Lab/Activity3.9.5 Skills Lab: Analyze Data in Tables3.9.6 Challenge Lab: Analyze Data in Tables3.9.8 Applied Lab: Pizza Chain3.9.9 Applied Lab: Baseball StatisticsFact Sheets3.9.4 Excel Table Facts3.9.7 Excel Table TipsTotal TimeAbout 78 minutes4.1: Introduction to PowerPointSummaryAs you study this introductory section, answer the following questions: Which features of PowerPoint do you already feel comfortable using?Which features are you less familiar with?What makes a PowerPoint presentation most effective?This section introduces you to Microsoft PowerPoint and provides an overview of the features you will be learning to use. In this section, you will be introduced to the following general tasks: Create and manage presentations.Format text within placeholders.Design slides.Use the Slide Master.Format illustrations.Format tables.Format pictures and media.Apply animations to slide elements.Apply transitions to slides.Deliver presentations.Print presentations and handouts.Video/DemoTime4.1.1 Introduction to PowerPoint3:074.1.2 Best Practices in Design3:36Total Video Time6:43Fact Sheets4.1.3 PowerPoint Tasks OverviewTotal TimeAbout 12 minutes4.2: Creating and Managing PresentationsSummaryAs you study this section, answer the following questions: How can a slide show help enhance your presentation?How many slides do you need to help you get your point across?What skills learned in other Office courses can you use in PowerPoint?This section gives you extensive practice creating and managing new PowerPoint presentations. After finishing this section, you should be proficient in the following tasks: Create a new blank presentation.Create a presentation using a template.Delete slides.Reorder slides.Duplicate slides.Save presentations in various formats.Copy and paste slides.Change presentation properties (e.g., author).Create new slides.Hide slides.Collapse and pin the ribbon.Add and remove sections in a presentation.Reorganize and modify an existing anize a long presentation into relevant sections.Video/DemoTime4.2.1 Slide Management2:534.2.2 Presentation Sections2:02Total Video Time4:55Lab/Activity4.2.4 Skills Lab: Create and Manage Presentations4.2.5 Challenge Lab: Create and Manage Presentations4.2.7 Applied Lab: Reorganize Presentation Slides4.2.8 Applied Lab: Create a New Presentation Using a TemplateFact Sheets4.2.3 Presentation Management Facts4.2.6 Presentation Management TipsTotal TimeAbout 75 minutes4.3: Formatting Textual ContentSummaryAs you study this section, answer the following questions: How can text enhance your presentation? How could it detract from your presentation?How much text is appropriate to include on each slide?What formatting changes can you make to your text to make it more interesting and readable?When can adding text to a shape make your presentation more meaningful?This section gives you extensive practice creating and formatting text in PowerPoint. After finishing this section, you should be proficient in the following tasks: Increase or decrease list levels.Modify a bulleted list style.Enter text into a placeholder.Add text to a shape.Change fonts and font styles.Change font colors and sizes.Align paragraph text.Change line spacing.Align text within a placeholder.Clear text formatting.Use Autofit to shrink text on overflow.Divide content into multiple slides.Use italics or a different font color to emphasize important content.Video/DemoTime4.3.1 Text and Content Placeholders3:284.3.2 Text Formatting3:03Total Video Time6:31Lab/Activity4.3.4 Skills Lab: Format Textual Content4.3.5 Challenge Lab: Format Textual Content4.3.7 Applied Lab: Format Text for a Sales Presentation4.3.8 Applied Lab: Format a Class ReportFact Sheets4.3.3 PowerPoint Text Formatting Facts4.3.6 PowerPoint Text Formatting TipsTotal TimeAbout 77 minutes4.4: Designing SlidesSummaryAs you study this section, answer the following questions: Which themes are appropriate for the message you want to get across with your presentation?How can the use of color and design enhance or detract from your message?Why is it important for your slides to have a consistent look and feel?Are there times when it could be more effective to have an inconsistent look and feel? Why?This section gives you extensive practice designing PowerPoint slides. After finishing this section, you should be proficient in the following tasks: Change the presentation theme.Use theme variants.Apply font and color themes.Change the size of slides.Insert a fill or picture into the slide background.Modify background transparency.Insert a slide with a particular layout.Change slide layouts.Keep the design of slides consistent across an entire presentation.Select the slide size based on the delivery platform.Select themes, styles, and images that complement the presentation topic.Video/DemoTime4.4.1 Themes and Templates3:044.4.2 Slide Backgrounds2:22Total Video Time5:26Lab/Activity4.4.4 Skills Lab: Design Slides4.4.5 Challenge Lab: Design Slides4.4.7 Applied Lab: Design a Business Plan Presentation4.4.8 Applied Lab: Design a Class PresentationFact Sheets4.4.3 Slide Design Facts4.4.6 Slide Design TipsTotal TimeAbout 76 minutes4.5: Using the Slide MasterSummaryAs you study this section, answer the following questions: How can using master slides make your presentation better?How can you save time by using master slides?What problems can arise from using master slides? How can you avoid these problems?This section gives you extensive practice using the Slide Master view. After finishing this section, you should be proficient in the following tasks: Insert a new slide master.Insert a new slide master layout.Modify text placeholders on a slide master.Insert a graphic into a slide master.Modify the font style in a slide master.Insert a placeholder.Delete a placeholder.Change the size of a placeholder.Copy and paste slide elements.Insert the slide number and date into slide footers.Determine when a new slide master or slide master layout is needed for a presentation.Modify an existing slide master layout to meet the needs of a presentation.Use slide master layouts to keep content consistent across slides.Video/DemoTime4.5.1 Slide Masters4:114.5.2 Slide Footers2:37Total Video Time6:48Lab/Activity4.5.4 Skills Lab: Use the Slide Master4.5.5 Challenge Lab: Use the Slide Master4.5.7 Applied Lab: Create a New Slide Master Layout4.5.8 Applied Lab: Customize a Slide Master LayoutFact Sheets4.5.3 Slide Master Facts4.5.6 Slide Master TipsTotal TimeAbout 77 minutes4.6: Formatting Illustrations and TablesSummaryAs you study this section, answer the following questions: How can tables help you organize data on a slide?What can you do to make your tables more understandable and less overwhelming?Which SmartArt designs can you use to get your point across?This section gives you extensive practice creating illustrations and tables in PowerPoint. After finishing this section, you should be proficient in the following tasks: Insert a table.Modify table layouts and design.Apply Quick Styles to drawing objects.Apply fill colors to drawing objects.Align and distribute objects.Add SmartArt diagrams.Convert a bulleted list into a SmartArt diagram.Change the stacking order of selected objects.Add WordArt to a new placeholder.Insert a shape.Select and modify SmartArt to graphically represent processes and organizational structures.Maintain a style for graphics that is consistent with the overall theme of a presentation.Use WordArt without detracting from the professionalism of a presentation.Video/DemoTime4.6.1 SmartArt3:094.6.2 PowerPoint Tables3:024.6.3 Object Formatting3:48Total Video Time9:59Lab/Activity4.6.5 Skills Lab: Format Illustrations and Tables4.6.6 Challenge Lab: Format Illustrations and Tables4.6.8 Applied Lab: Format Elements in a Class Presentation4.6.9 Applied Lab: Format a Business Presentation with SmartArtFact Sheets4.6.4 Illustration and Table Formatting Facts4.6.7 Illustration and Table Formatting TipsTotal TimeAbout 80 minutes4.7: Formatting Pictures and Other MediaSummaryAs you study this section, answer the following questions: How can you use pictures to captivate your audience?How can inappropriate use of pictures or videos make your presentation less effective?Are there any situations where you could effectively add a style to a video?When should you use audio clips to enhance your presentation?This section gives you extensive practice inserting and formatting images, videos, and sound in a presentation. After finishing this section, you should be proficient in the following tasks: Add pictures within content placeholders.Use the Picture Styles gallery.Change the size of images.Change the shape of a picture (e.g. crop option).Format picture borders.Insert videos.Adjust video brightness and contrast.Add video playback options.Resize a video.Add online pictures (i.e. clip art).Insert an audio file.Add a hyperlink to text.Incorporate high quality and relevant images into a presentation.Format images to match the overall theme of a presentation.Adjust the timing and visual quality of videos.Video/DemoTime4.7.1 Media Formatting2:58Total Video Time2:58Lab/Activity4.7.3 Skills Lab: Format Pictures and Other Media4.7.4 Challenge Lab: Format Pictures and Other Media4.7.6 Applied Lab: Format a Class Presentation on Confucius4.7.7 Applied Lab: Format a Class Presentation on PlatoFact Sheets4.7.2 Media Formatting Facts4.7.5 Media Formatting TipsTotal TimeAbout 73 minutes4.8: Applying Animations and TransitionsSummaryAs you study this section, answer the following questions: What types of presentations benefit from subtle transitions? From more obvious transitions?How can you use animations to help your audience follow your presentation better?What are the dangers of overusing animations and transitions?This section gives you extensive practice using animations and transitions in PowerPoint. After finishing this section, you should be proficient in the following tasks: Apply animation effects (entrance, exit, and emphasis).Modify the start timing of animations.Change the sequence of animations.Customize the direction of animations.Preview and test animations.Apply slide transitions.Modify the duration and timing of transitions.Test transitions.Avoid animations and transitions that detract from the central message of a presentation.Adjust the timing of animations to match the flow of a presentation.Video/DemoTime4.8.1 Animation2:564.8.2 Transitions3:10Total Video Time6:06Lab/Activity4.8.4 Skills Lab: Apply Animations and Transitions4.8.5 Challenge Lab: Apply Animations and Transitions4.8.7 Applied Lab: Add Transitions to a Presentation4.8.8 Applied Lab: Add Animations for EmphasisFact Sheets4.8.3 Animation and Transition Facts4.8.6 Animation and Transition TipsTotal TimeAbout 77 minutes4.9: Delivering PresentationsSummaryAs you study this section, answer the following questions: Why is it important to rehearse before giving a presentation?When have you observed someone giving a boring or ineffective presentation? How can you do better?What are the benefits of giving your audience a handout?How can you use the presenter view most effectively?This section gives you extensive practice using PowerPoint's presentation delivery tools. After finishing this section, you should be proficient in the following tasks: Check the spelling in presentations.Use the thesaurus pane.Add speaker notes to a presentation.Deliver a slide show presentation.Navigate a slide show in Presenter View.Use presentation tools.Preview and print handouts.Print speaker notes.Add headers and footers to notes and handouts.Format and print handouts to help the audience retain important information.Rehearse presentations in the actual setting where they will be delivered.Video/DemoTime4.9.1 Presentation Tools3:434.9.2 PowerPoint Print Options3:14Total Video Time6:57Lab/Activity4.9.4 Skills Lab: Deliver Presentations4.9.5 Challenge Lab: Deliver Presentations4.9.7 Applied Lab: Prepare for a Presentation4.9.8 Applied Lab: Deliver a PowerPoint LectureFact Sheets4.9.3 Presentation Delivery Facts4.9.6 Presentation Delivery TipsTotal TimeAbout 77 minutes5.1: Introduction to AccessSummaryAs you study this introductory section, answer the following questions: What is the purpose of a relational database?What types of databases have you accessed before?Why would you want to store certain types of data in Microsoft Access rather than in Microsoft Excel?This section introduces you to Microsoft Access and provides an overview of the features you will be learning to use. In this section, you will be introduced to the following general tasks: Plan the structure of a database.Manage data in a database.Create database tables.Use queries.Design forms.Create and format reports.Video/DemoTime5.1.1 Introduction to Relational Databases3:50Total Video Time3:50Fact Sheets5.1.2 Access Tasks OverviewTotal TimeAbout 9 minutes5.2: Managing DatabasesSummaryAs you study this section, answer the following questions: How are relational databases already part of your everyday life?What are the benefits of using a relational database as opposed to a spreadsheet?Why is it important for each record to have a unique primary key?This section will give you a background in relational databases, as well as extensive practice with managing an existing Access database. You will become proficient in performing the following tasks: Create a new blank database.Delete a record from a table.Open, close, and save database objects.Modify an existing record.Print a report.Rename a database object.Collapse and expand the navigation pane.Change database properties.Video/DemoTime5.2.1 Tour of Access2:595.2.2 Database Terminology2:23Total Video Time5:22Lab/Activity5.2.4 Skills Lab: Managing Databases5.2.5 Challenge Lab: Managing DatabasesFact Sheets5.2.3 Database Management Facts5.2.6 Database Management TipsTotal TimeAbout 56 minutes5.3: Designing and Creating TablesSummaryAs you study this section, answer the following questions: What are the advantages of keeping data in multiple tables? What are the disadvantages?How can you best organize the tables in your database?What one-to-many relationships do you see in your everyday life?This section will give you extensive practice with creating tables in Access. You will become proficient in performing the following tasks: Create a new table in design view.Create a new table in datasheet view.Add fields to a table.Change the data type of a field.Change the field size of a short text field.Set a default value.Create a lookup field.Create a relationship between two tables.Delete a field from a table.Import an Excel file to a table.Video/DemoTime5.3.1 Database Planning3:195.3.2 Table Design3:265.3.3 Default Values2:225.3.4 Relationships and Lookups3:225.3.5 Data Importing2:31Total Video Time15:00Lab/Activity5.3.7 Skills Lab: Design and Create Tables5.3.8 Challenge Lab: Design and Create Tables5.3.10 Applied Lab: Creating a Student Database5.3.11 Applied Lab: Creating a Library DatabaseFact Sheets5.3.6 Table Design Facts5.3.9 Table Design TipsTotal TimeAbout 85 minutes5.4: Using Simple QueriesSummaryAs you study this section, answer the following questions: What is the relationship between queries, relationships, and primary keys?What kinds of information do you want from your database? How can you design a query to get this information?How can you use criteria to hone the results of a query to your needs?This section will give you extensive practice with creating queries in Access. You will become proficient in performing the following tasks: Create a query in design view.Add fields from multiple tables to a query.Add new fields to an existing query.Use text, numeric, and date criteria in queries.Use totals to group, count, sum, and average data.Sort the information in a query.Add a caption to a query field.Hide a field in a query.Video/DemoTime5.4.1 Introduction to Queries2:255.4.2 Query Criteria3:025.4.3 Queries with Totals2:26Total Video Time7:53Lab/Activity5.4.5 Skills Lab: Create Queries5.4.6 Challenge Lab: Create Queries5.4.8 Applied Lab: Creating Queries for a School5.4.9 Applied Lab: Creating Queries for a LibraryFact Sheets5.4.4 Query Facts5.4.7 Query TipsTotal TimeAbout 78 minutes5.5: Creating FormsSummaryAs you study this section, answer the following questions: What are the dangers of letting other people enter data into your tables?How can you use forms to reduce the impact of multiple users on your database?How can you use forms to reduce data entry errors?This section will give you extensive practice with creating and formatting forms in Access. You will become proficient in performing the following tasks: Create a form based on a table.Create a form based on a query.Add a button to a form.Delete a field from a form.Add a new row to a form.Apply a theme to a form.Change a form label.Add a custom logo to a form.Video/DemoTime5.5.1 Access Forms2:205.5.2 Form Formatting3:22Total Video Time5:42Lab/Activity5.5.4 Skills Lab: Create Forms5.5.5 Challenge Lab: Create Forms5.5.7 Applied Lab: Creating Forms for a School5.5.8 Applied Lab: Creating Forms for a LibraryFact Sheets5.5.3 Form Facts5.5.6 Form TipsTotal TimeAbout 76 minutes5.6: Creating ReportsSummaryAs you study this section, answer the following questions: How can reports help you make sense of your data?Is a report's formatting important? Why or why not?What kinds of information do you want to include in your reports?This section will give you extensive practice with creating and formatting reports in Access. You will become proficient in performing the following tasks: Create a report using the Report Wizard.Create a report with summary information.Create a report based on a query.Delete a row from a report.Change the alternate row color settings.Format the outline of report elements.Apply a theme to a report.Change report labels.Add a custom logo to a report.Video/DemoTime5.6.1 The Report Wizard2:485.6.2 Reports with Totals2:395.6.3 Report Formatting4:38Total Video Time10:05Lab/Activity5.6.5 Skills Lab: Create Reports5.6.6 Challenge Lab: Create Reports5.6.8 Applied Lab: Creating Reports for a School5.6.9 Applied Lab: Creating Reports for a LibraryFact Sheets5.6.4 Report Facts5.6.7 Report TipsTotal TimeAbout 81 minutesDesktop Pro Practice ExamsA.0: Desktop Pro Certification Practice ExamsA.2 Desktop Pro Domain 1: Microsoft Word (12 questions)Total TimeAbout 180 minutes A.3 Desktop Pro Domain 2: Microsoft Excel (12 questions)Total TimeAbout 180 minutes A.4 Desktop Pro Domain 3: Microsoft PowerPoint (10 questions)Total TimeAbout 180 minutes A.5 Desktop Pro Certification Practice Exam (13 questions)Total TimeAbout 120 minutes Appendix A: Course ObjectivesThis course teaches basic computer skills and the use of Microsoft Office applications, including Word, Excel, PowerPoint, and Access. Chapter 1: Computer and Internet Basics 1.1 Computer Systems and the InternetOpen a Windows application.Use a Web browser to navigate to a particular website.Save and access bookmarks in a Web browser.Perform an Internet search.Copy and paste a URL into the Address bar of a Web browser.Delete your Web browser's cache.Configure your Web browser to allow pop-ups from a particular domain.1.2 The Windows Operating SystemChange display settings in Windows.Use the Settings App to view system information.Configure a screen saver through the Settings App.Run Windows applications.Pin applications to the Start Menu and the taskbar.Unpin applications from the Start Menu and the taskbar.Create application shortcuts on the Windows desktop.1.3 File ManagementCreate folders in the Windows file system.Copy, rename, and delete files in Windows.Copy files from the local Windows file system to OneDrive.Connect a USB thumb drive to a desktop computer and copy files from the drive to your local file system.Remove USB devices properly.Share a Windows folder with other users and grant them specific access to files within the folder.Use the Windows Recycle Bin.1.4 Networking and System UpdatesCreate a local account for a user who already has a Microsoft login.Create a non-Microsoft user account.Connect to a secure wireless network.Configure Windows Update to install updates automatically.1.5 Online Safety and SecurityConfigure Windows Firewall for different networks.Configure privacy settings in Internet Explorer.Clear the browser history within Internet Explorer.Configure the Internet Explorer pop-up blocker.Evaluate email messages to determine if they are safe or if they represent a possible social engineering attack.1.6 Computer HardwareIdentify common peripheral devices by sight.Identify common ports and connectors by sight.Connect cables and peripherals to a computer system.Select appropriate hardware devices for particular scenarios.1.7 Microsoft Office Application FeaturesConnect to a shared printer.Configure the default printer.Share a local printer with other users.Open and print a document from Microsoft Word.Open and print a spreadsheet from Microsoft Excel.Chapter 2: Microsoft Word 2.2 Creating DocumentsCreate a new blank document.Open a downloaded document and enable editing.Move the insertion point.Enter text into a document.Select words, lines, and paragraphs.Delete text.Copy and cut text to the Clipboard.Paste formatted and unformatted text from the Clipboard.Clear the Clipboard.Undo or redo an action.Close a document.Reorganize the content in a document.Paste text from a website into a Word document.2.3 Managing and Printing DocumentsModify document properties.View document statistics.Save a Word document in various formats, including PDF and plain text.Print a custom range of pages in a document.Print from a non-default printer.Collapse and pin the ribbon.Use ScreenTip help.Scroll through a document.Prepare a document to be uploaded to the Web.Prepare a document to be distributed within a company.2.4 Modifying FontsBold, italicize, or underline a selection of text.Modify the case of a word.Change the font color of selected text.Apply a superscript.Apply a subscript.Change the font size of selected text.Change the font of selected text.Apply a Text Effect to selected text.Apply Text Highlighting to selected text.Format the fonts in a resume.Create a math worksheet.Choose and format the fonts in an advertising flyer.2.5 Formatting ParagraphsAlign a paragraph to the left, right, or center of the page.Show and hide formatting symbols.Clear formatting within a selection.Change the line spacing for paragraphs.Change the spacing before and after a paragraph.Change paragraph indents.Apply a border to a paragraph.Apply shading to a paragraph.Set orphan/widow paragraph control options.Create a numbered list.Create a bulleted list.Customize bullets.Adjust the indent level for lists.Format a series of lists in a document.Implement paragraph specifications for an academic paper.2.6 Formatting PagesAdd a watermark to a page.Add a page border.Create and format multiple columns on a page.Insert and modify tab stops.Add dot leaders to tabs.Modify page margins.Modify page orientation.Insert a page break.Insert a column break.Align text vertically on a page.Format a report as a draft.Format only part of a document into two columns.Insert manual page breaks where needed in a document.2.7 Editing DocumentsFind and replace a particular word within a document.Turn automatic spelling and grammar checking on and off.Use the spelling and grammar checker.Use the thesaurus to find synonyms.Count the total words in a document.Correct errors while typing with AutoCorrect.Customize AutoCorrect settings.Modify an AutoCorrect entry.Remove a hyperlink from text.Identify default AutoCorrect changes that might need to be modified.Ignore spelling and grammar suggestions when appropriate.2.8 Inserting Illustrations and Other ElementsInsert a picture from a file.Insert a picture from the Internet.Resize a picture or graphic.Move and align an image.Modify picture styles.Insert a symbol.Insert a shape.Insert the current date into a document.Delete a picture or graphic.Modify text wrap settings for visual appeal.Apply best practices in using graphics.2.9 Creating and Formatting TablesInsert a blank table into a document.Add additional columns to an existing table.Add additional rows to an existing table.Modify cell alignment.Split or merge table cells.Format table cells.Convert a table to text.Enter or delete table data.Apply a table style.Resize table columns to fit contents.Center or align a table.Delete rows and columns.Format the header row and other table style options.Align table data for better readability.Apply table styles that increase readability and visual appeal.2.10 Using Themes, Styles, and TemplatesCreate a document from an existing template.Remove content controls in a template.Modify the theme font.Apply heading styles to paragraphs.Modify text formatting using Format Painter.Change the theme for a document.Select a style set for a document.Edit an existing style.Format a newsletter to achieve both readability and visual appeal.Apply font and paragraph styles to an academic paper.Create a certificate using a template.2.11 Managing ReferencesInsert a new citation source for a document.Edit a citation to add a page number.Insert a bibliography of current sources for a document.Insert a footnote at the bottom of the page.Insert an endnote.Modify the number format of footnotes.Edit a citation source.Convert a citation to static text.Import a citation source into the current document.Update a bibliography.Cite sources for an academic paper using the MLA, Chicago, and APA citation styles.2.12 Managing Headers, Footers, and SectionsInsert information into the header or footer, including date and time, page number, and filename.Suppress the page number on the first page of a document.Restart page numbering for a new section.Close the header and footer.Insert a Next Page section break.Format a section with a different page orientation.Begin numbering an academic paper on the third page.Change document formatting from one column to two columns in the middle of a page.Chapter 3: Microsoft Excel 3.2 Creating and Managing WorkbooksOpen a workbook.Create a new blank workbook.Change workbook properties.Enable editing to exit the Protected View.Insert and delete worksheets.Navigate between worksheets.Save a workbook in Excel format, in a character-separated values format (both tabs and commas), and as a PDF file.Rename worksheets.Reorder and color worksheet tabs.Move and copy a worksheet.Import data from a comma-separated text file.Collapse and pin the ribbon.Import data from various applications into Excel.3.3 Organizing and Entering DataSelect a single cell and a range of cells.Enter worksheet titles.Enter column and row titles.Freeze column and row titles and panes.Enter text and numbers into cells.Use the Copy and Cut commands on cell ranges.Use paste options.Insert rows and columns into a sheet.Insert multiple rows in one operation.Delete and clear rows and columns.Hide and unhide rows and columns.Undo and redo actions.Manage a worksheet that contains a large data set.Insert new data between rows or columns.Divide data sets appropriately between worksheets.3.4 Changing Properties and Printing WorksheetsLock and unlock cells.Protect worksheets and workbooks from changes.Preview and print a worksheet.Set and clear the print area for a worksheet.Change worksheet margins.Create and modify a worksheet header.Create a worksheet footer.Change worksheet orientation for printing.Scale a worksheet to be printed on a single page.Add print titles.Prevent particular cells from being modified.Print a particular section of worksheet data.Include relevant worksheet properties in a printout.Optimize the printing of a worksheet.3.5 Formatting CellsApply font style, size, and color changes to cells.Apply cell styles.Change the fill color (shading).Merge and center a range of cells.Apply number formatting to cells.Apply the percent style to cells.Increase and decrease decimal spaces.Enter and format dates.Adjust column widths (including AutoFit).Resolve the ###### error message.Adjust row heights.Align cell content.Rotate cell content.Clear cell formatting.Apply borders and border colors.Enter multiple lines of text (apply the word wrap setting).Format cells as column or row totals.Adjust columns to display both numeric and textual data properly.Format a range of cells as a worksheet title.3.6 Entering Simple FormulasEnter a formula using the keyboard.Use the mouse to reference cells in a formula.Copy a formula using the fill handle.Copy a formula using the Clipboard.Sum a column or row using AutoSum.Calculate the MAX, MIN, AVERAGE, and MEDIAN of a data set.Use arithmetic operations properly in formulas.Add columns and rows of data.Copy formulas to cells that require similar calculations.Perform simple arithmetic that references cell values.Use AutoFill to enter data that follow a predictable pattern.3.7 Using Advanced FunctionsEnter a function using the Insert Function box.Display and hide formulas.Enter a formula using absolute references.Enter a formula using relative references.Use the IF function.Use COUNTIF, SUMIF, and AVERAGEIF.Use functions with multiple arguments.Copy a formula with absolute references.Copy a formula with relative references.Correct or ignore error messages, as appropriate.Select appropriate functions to perform conditional operations.Determine when to use an absolute reference in a formula.Verify that the desired values have been properly referenced within a formula.3.8 Analyzing Data in ChartsSelect a data source for a chart.Add a data series to an existing chart.Insert a clustered column chart.Create a pie chart.Move a chart on a worksheet.Move a chart to its own worksheet.Resize a chart.Modify a chart style and type.Format chart elements.Show and hide chart elements.Use recommended charts.Insert a chart to show changes over time.Insert a chart to display the aggregate of a set of values.Modify chart layouts to better visualize data.3.9 Analyzing Data in TablesCreate a table.Apply table styles.Insert table rows and columns.Add a total row.Sort a table.Remove duplicate rows.Filter a table using AutoFilter options.Apply highlight cell rules for conditional formatting.Apply data bars for conditional formatting.Determine when a data set should be converted to a table.Sort rows of data based on the values in particular columns.Use both text and number filters to display only desired information.Conditionally format cells that contain the most important data.Chapter 4: Microsoft PowerPoint 4.2 Creating and Managing PresentationsCreate a new blank presentation.Create a presentation using a template.Delete slides.Reorder slides.Duplicate slides.Save presentations in various formats.Copy and paste slides.Change presentation properties (e.g., author).Create new slides.Hide slides.Collapse and pin the ribbon.Add and remove sections in a presentation.Reorganize and modify an existing anize a long presentation into relevant sections.4.3 Formatting Textual ContentIncrease or decrease list levels.Modify a bulleted list style.Enter text into a placeholder.Add text to a shape.Change fonts and font styles.Change font colors and sizes.Align paragraph text.Change line spacing.Align text within a placeholder.Clear text formatting.Use Autofit to shrink text on overflow.Divide content into multiple slides.Use italics or a different font color to emphasize important content.4.4 Designing SlidesChange the presentation theme.Use theme variants.Apply font and color themes.Change the size of slides.Insert a fill or picture into the slide background.Modify background transparency.Insert a slide with a particular layout.Change slide layouts.Keep the design of slides consistent across an entire presentation.Select the slide size based on the delivery platform.Select themes, styles, and images that complement the presentation topic.4.5 Using the Slide MasterInsert a new slide master.Insert a new slide master layout.Modify text placeholders on a slide master.Insert a graphic into a slide master.Modify the font style in a slide master.Insert a placeholder.Delete a placeholder.Change the size of a placeholder.Copy and paste slide elements.Insert the slide number and date into slide footers.Determine when a new slide master or slide master layout is needed for a presentation.Modify an existing slide master layout to meet the needs of a presentation.Use slide master layouts to keep content consistent across slides.4.6 Formatting Illustrations and TablesInsert a table.Modify table layouts and design.Apply Quick Styles to drawing objects.Apply fill colors to drawing objects.Align and distribute objects.Add SmartArt diagrams.Convert a bulleted list into a SmartArt diagram.Change the stacking order of selected objects.Add WordArt to a new placeholder.Insert a shape.Select and modify SmartArt to graphically represent processes and organizational structures.Maintain a style for graphics that is consistent with the overall theme of a presentation.Use WordArt without detracting from the professionalism of a presentation.4.7 Formatting Pictures and Other MediaAdd pictures within content placeholders.Use the Picture Styles gallery.Change the size of images.Change the shape of a picture (e.g. crop option).Format picture borders.Insert videos.Adjust video brightness and contrast.Add video playback options.Resize a video.Add online pictures (i.e. clip art).Insert an audio file.Add a hyperlink to text.Incorporate high quality and relevant images into a presentation.Format images to match the overall theme of a presentation.Adjust the timing and visual quality of videos.4.8 Applying Animations and TransitionsApply animation effects (entrance, exit, and emphasis).Modify the start timing of animations.Change the sequence of animations.Customize the direction of animations.Preview and test animations.Apply slide transitions.Modify the duration and timing of transitions.Test transitions.Avoid animations and transitions that detract from the central message of a presentation.Adjust the timing of animations to match the flow of a presentation.4.9 Delivering PresentationsCheck the spelling in presentations.Use the thesaurus pane.Add speaker notes to a presentation.Deliver a slide show presentation.Navigate a slide show in Presenter View.Use presentation tools.Preview and print handouts.Print speaker notes.Add headers and footers to notes and handouts.Format and print handouts to help the audience retain important information.Rehearse presentations in the actual setting where they will be delivered.Chapter 5: Microsoft Access 5.2 Managing DatabasesCreate a new blank database.Delete a record from a table.Open, close, and save database objects.Modify an existing record.Print a report.Rename a database object.Collapse and expand the navigation pane.Change database properties.5.3 Designing and Creating TablesCreate a new table in design view.Create a new table in datasheet view.Add fields to a table.Change the data type of a field.Change the field size of a short text field.Set a default value.Create a lookup field.Create a relationship between two tables.Delete a field from a table.Import an Excel file to a table.5.4 Using Simple QueriesCreate a query in design view.Add fields from multiple tables to a query.Add new fields to an existing query.Use text, numeric, and date criteria in queries.Use totals to group, count, sum, and average data.Sort the information in a query.Add a caption to a query field.Hide a field in a query.5.5 Creating FormsCreate a form based on a table.Create a form based on a query.Add a button to a form.Delete a field from a form.Add a new row to a form.Apply a theme to a form.Change a form label.Add a custom logo to a form.5.6 Creating ReportsCreate a report using the Report Wizard.Create a report with summary information.Create a report based on a query.Delete a row from a report.Change the alternate row color settings.Format the outline of report elements.Apply a theme to a report.Change report labels.Add a custom logo to a report.Appendix B: Approximate Time for the CourseThe total time for the LabSim for TestOut Desktop Pro course is approximately 58 hours and 13 minutes. Time is calculated by adding the approximate time for each section which is calculated using the following elements: Video/demo timesText Lessons (5 minutes assigned per text lesson)Lab Simulations (10 minutes assigned per applied lab; 20 minutes per skills lab; 20 minutes per challenge lab)End-of-Chapter Exams (60 minutes per exam)The breakdown for this course is as follows:ChapterSectionsTimeVideosLabsTextExams1.0: Computer and Internet Basics1.1: Computer Systems and the Internet591420251.2: The Windows Operating System831350201.3: File Management991960201.4: Networking and System Updates831350201.5: Online Safety and Security1303070301.6: Computer Hardware1112660251.7: Microsoft Office Application Features77125015Total11:422:076:002:351:00*2.0: Microsoft Word2.1: Introduction to Word1712052.2: Creating Documents78860102.3: Managing and Printing Documents78860102.4: Modifying Fonts78860102.5: Formatting Paragraphs861660102.6: Formatting Pages79960102.7: Editing Documents801060102.8: Inserting Illustrations and Other Elements77760102.9: Creating and Formatting Tables79960102.10: Using Themes, Styles, and Templates811160102.11: Managing References801060102.12: Managing Headers, Footers, and Sections87176010Total16:002:0511:001:551:003.0: Microsoft Excel3.1: Introduction to Excel83053.2: Creating and Managing Workbooks79960103.3: Organizing and Entering Data801060103.4: Changing Properties and Printing Worksheets77760103.5: Formatting Cells831360103.6: Entering Simple Formulas78860103.7: Using Advanced Functions831360103.8: Analyzing Data in Charts76660103.9: Analyzing Data in Tables7886010Total11:421:178:001:251:004.0: Microsoft PowerPoint4.1: Introduction to PowerPoint127054.2: Creating and Managing Presentations75560104.3: Formatting Textual Content77760104.4: Designing Slides76660104.5: Using the Slide Master77760104.6: Formatting Illustrations and Tables801060104.7: Formatting Pictures and Other Media73360104.8: Applying Animations and Transitions77760104.9: Delivering Presentations7776010Total11:240:598:001:251:005.0: Microsoft Access5.1: Introduction to Access94055.2: Managing Databases56640105.3: Designing and Creating Tables851560105.4: Using Simple Queries78860105.5: Creating Forms76660105.6: Creating Reports81116010Total7:250:504:400:551:00Total Course Time 58:13Desktop Pro Certification Practice ExamsA.0: Desktop Pro Practice ExamsNumber of QuestionsTimeA.2: Desktop Pro Domain 1: Microsoft Word12180A.3: Desktop Pro Domain 2: Microsoft Excel12180A.4: Desktop Pro Domain 3: Microsoft PowerPoint10180A.5: Desktop Pro Certification Practice Exam13120Total4711:00Total Practice Exam Time 11:00* Each chapter of the course includes a 60-minute final exam that is hidden from students until scheduled by the instructor. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download