Table of Contents



-5619759525000Revised 2020-06-1200Revised 2020-06-12-914400-9144000003743325LESSON PLAN 00LESSON PLAN left2722245TestOut Desktop Pro Plus - English 5.0.x 020000TestOut Desktop Pro Plus - English 5.0.x Table of Contents Section 0.0: Getting Started Information PAGEREF _1f8aa404-6fcd-46f5-8d1d-670ae8d810064Online EssentialsSection 1.1: The Information Age PAGEREF _8fb2d7ba-0d6e-44e2-afe0-eea730463fb25Section 1.2: The Internet and Social Media PAGEREF _37477988-c883-4d54-b67f-186b0f1347bb7Section 1.3: Digital Communication PAGEREF _d7fd3c3e-3bda-4c5c-b0b6-da0205bb9e8d9Section 1.4: Online Safety and Security PAGEREF _cd1a9938-7ba2-48b9-b7e7-8505971479cc11Section 1.5: Evaluating Online Information PAGEREF _63c147fe-5b9e-4caf-b772-1921f8b1c1e513Computer EssentialsSection 2.1: Computer Hardware PAGEREF _98498cef-fe2d-413c-b27a-e7a8aae5515214Section 2.2: System Software PAGEREF _3513334c-ae89-4742-9411-f557dc6772fa16Section 2.3: File Management PAGEREF _cefd67c9-c0e9-41b8-a4cb-148797d3a84318Section 2.4: Application Software PAGEREF _65f4aad2-45ad-4d0b-84a9-4686bfa8684020Section 2.5: Networking and User Accounts PAGEREF _fe303c6f-cfff-47b0-9e11-e6109d95e5fb22Section 2.6: Databases PAGEREF _826e1d18-bc7c-4971-9389-0b7420d601d424Section 2.7: Computer Programming PAGEREF _948b07b9-b647-4479-9fae-66b535ee2aac26Section 2.8: Information Systems PAGEREF _92fa88b9-d083-47cd-bb3b-37981db52d2127Common Office FeaturesSection 3.1: Getting Started with Office PAGEREF _f648797b-8db7-43fa-9797-65d89e94ed9228Section 3.2: Customizing Views and Options PAGEREF _8b75adf7-444f-4d3a-90d2-7b47f8df0a3d29Section 3.3: Printing Files PAGEREF _d37ec73b-4fde-4cb1-a9d7-56c84c4a328a30Section 3.4: Navigating Files PAGEREF _cda94056-8dc7-4649-bbac-28f399a70e4c31Section 3.5: Working with Objects PAGEREF _84bc1882-ca76-4d1a-8ac4-e6456502849532Microsoft WordSection 4.1: Introduction to Word PAGEREF _1f825df0-d18d-4733-91c2-d21c70334f4833Section 4.2: Creating Documents and Using the Clipboard PAGEREF _3797abc9-f6e2-42a9-93c2-ef2c00a82e0834Section 4.3: Modifying Fonts PAGEREF _94b1d7e1-0780-46a2-b673-094f2168aaf736Section 4.4: Formatting Paragraphs PAGEREF _7c825595-4295-45bd-ae37-aaa44f3b030d37Section 4.5: Formatting Pages PAGEREF _f2f42707-b68a-4192-95e7-40db355b1c9b39Section 4.6: Editing Documents PAGEREF _64614405-cd62-4bde-85cd-77e96a22a09841Section 4.7: Inserting Illustrations and Other Elements PAGEREF _4e146331-d671-4800-b148-3a6bad82086c42Section 4.8: Creating and Formatting Tables PAGEREF _6b1747d9-4b65-49ec-bf0a-5f93a6af393744Section 4.9: Using Themes, Styles, and Templates PAGEREF _85c12584-953d-43af-9e0f-ceda3555519a46Section 4.10: Managing References PAGEREF _ea844672-ec1e-440c-837e-2f14a336e61947Section 4.11: Managing Headers, Footers, and Sections PAGEREF _6c0a2908-8b81-4d6a-9239-b22dc318948a49Section 4.12: Using Office Collaboration Features PAGEREF _19cb5464-9b88-4b47-aa8b-44023893d25f50Section 4.13: Using Macros PAGEREF _e2bc6187-5d58-4d2f-94fe-0f2d76417e0551Microsoft ExcelSection 5.1: Introduction to Excel PAGEREF _89d469c6-b1d6-4f29-8446-64049466a84a52Section 5.2: Creating and Managing Workbooks PAGEREF _08392e42-6678-428b-a759-4545d8d0012653Section 5.3: Organizing and Entering Data PAGEREF _fe17cea7-34cb-42d2-ac16-b4439c18b7e355Section 5.4: Changing Properties and Printing Worksheets60Section 5.5: Formatting Cells62Section 5.6: Entering Simple Formulas PAGEREF _f9c38bea-96ac-49f4-aa55-24f0fcdcf41f61Section 5.7: Using Advanced Functions PAGEREF _44a9b8c1-5b7a-4ae4-bad7-9de5d715481e63Section 5.8: Displaying Data in Charts PAGEREF _106f5bb9-e625-4d1b-b451-4eeeaee11be065Section 5.9: Organizing Data in Tables70Section 5.10: Summarizing Complex Data72Microsoft PowerPointSection 6.1: Introduction to PowerPoint PAGEREF _4fd68367-43b6-40c4-ac5e-78a57509d2aa70Section 6.2: Creating and Managing Presentations PAGEREF _07757c06-a011-4a06-a851-c8b599378b7d71Section 6.3: Formatting Textual Content PAGEREF _7d3d747b-43c6-484d-b75d-abf73ea3526572Section 6.4: Designing Slides PAGEREF _fef7444c-7768-4868-8420-c29832b8828b74Section 6.5: Using the Slide Master PAGEREF _5dea754b-7f3a-498b-84aa-0e8b88a55af975Section 6.6: Formatting SmartArt and Shapes80Section 6.7: Formatting Tables and Charts82Section 6.8: Formatting Pictures and Other Media PAGEREF _858ccfef-9696-4505-94f2-7dd2afa500d180Section 6.9: Applying Animations and Transitions PAGEREF _1617f1c9-0067-4ed7-bb7a-8fd357d8391f82Section 6.10: Delivering Presentations PAGEREF _12c05dc6-f43e-4274-a1f0-1398af7ca59883Microsoft AccessSection 7.1: Introduction to Access PAGEREF _52d610f5-95a6-4d70-9853-da754f2a087585Section 7.2: Managing Databases PAGEREF _b6afcaf0-b076-4ffc-b8f2-4a27b2cb04da86Section 7.3: Designing and Creating Tables90Section 7.4: Using Simple Queries91Section 7.5: Creating Forms92Section 7.6: Creating Reports PAGEREF _9460a7a3-42ec-4876-8fe4-0b2d5fd2614990Section 7.7: Surveying Advanced Access Features PAGEREF _f0c775a2-8863-4dcb-9d62-7cfed50bf29391Microsoft OutlookSection 8.1: Introduction to Outlook PAGEREF _3b697810-19e0-4eb8-808e-657c239c3b7693Section 8.2: Sending and Receiving Messages PAGEREF _5d9fd395-526b-4e67-bbaf-c5cb8ed3ae8394Section 8.3: Managing Messages PAGEREF _8d06bd49-7d7b-466d-a857-7ce2f86783fe96Section 8.4: Working with the Calendar101Section 8.5: Managing Contacts and Groups PAGEREF _39320f6a-fd53-46c5-a292-b0f77f914254100Desktop Pro Practice ExamsDesktop Pro Certification Practice Exams PAGEREF _practiceExams102MOS 2016 Practice ExamsSection B.1: Preparing for MOS Certification PAGEREF _1cb64c64-50e8-4269-9b4e-ad6460316120103Section B.2: Microsoft Word 2016 Core (77-725) PAGEREF _fcf94820-0175-4a89-b96f-3153ededb833105Section B.3: Microsoft Excel 2016 Core (77-727) PAGEREF _78e78ecd-4a7f-4a6e-90d5-5d475defa8f6107Section B.4: Microsoft PowerPoint 2016 (77-729) PAGEREF _b2570c4a-d97c-4b34-aa0b-57fdfac71a53109AppendicesAppendix A: Course Objectives PAGEREF _appendixA111Appendix B: Course Mapping to MOS Exam Objectives PAGEREF appendixB 134Appendix C: Approximate Time for the Course1540.0: Getting Started InformationSummaryVideo/DemoTime0.1 Video: Introduction to Desktop Pro Plus7: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: The Information AgeSummaryAs you study this section, answer the following questions: How are today's computers similar to the earliest computers? How are they different?How do computers convert physical signals into digital data?When is it best to use compressed files? When is it better to use uncompressed files?This section introduces you to the history of computing and the basics of how computers work. It covers the following learning objectives: Recall significant developments in the history of modern computing.Identify uses of computers in today's world.Describe the binary number system used by computers to process data.Define bits and bytes.Explain how physical signals are translated into digital information.Describe how audio and video are stored digitally.Distinguish between raster and vector images.Select the best format for digital images.Describe how RGB values determine pixel pare common image file types.Describe ethical considerations related to evolving forms of technology.Video/DemoTime1.1.1 Introduction to Desktop Computer Systems4:491.1.3 A Brief History of Computing3:401.1.5 The Binary Number System2:261.1.7 Bits & Bytes3:441.1.9 Digital Sound & Video5:071.1.11 Digital Images3:571.1.13 File Compression5:291.1.15 Technology and Ethics3:39Total Video Time32:51Fact Sheets1.1.2 Desktop Computer System Facts1.1.4 Computing History Facts1.1.6 Binary Number System Facts1.1.8 Bits & Bytes Facts1.1.10 Digital Sound & Video Facts1.1.12 Digital Image Facts1.1.14 File Compression Facts1.1.16 Technology and Ethics Facts1.1.17 Activity: Compare Digital MediaNumber of Exam Questions10 questionsTotal TimeAbout 88 minutes1.2: The Internet and Social MediaSummaryAs you study this section, answer the following questions: What is the relationship between the Internet, the World Wide Web, and web browsers?What are some benefits of using social media? What are some drawbacks?How should I respond when I am a victim of cyberbullying? How should I respond when I see someone else being bullied?This section introduces you to the Internet and social media, and gives you practice using an Internet browser. It covers the following learning objectives: Define the World Wide Web.Describe the essential components of the Web, including websites, URLs, hyperlinks, web browsers, and search engines.Identify technologies that use the Internet, including the Web, email, instant messaging, VoIP, and the Internet of Things.Identify common web applications, including Webmail, Google Docs, Facebook, and YouTube.Define and describe the uses of cloud computing.Define social media and describe its uses.Recognize the risks and responsibilities of using social media.Identify and appropriately respond to cyberbullying.Describe the difference between downloading, live streaming, and on-demand streaming.Use a web browser to access the World Wide Web.Make basic changes to browser settings.Video/DemoTime1.2.1 The Web and Other Internet Technologies4:471.2.3 Using a Web Browser4:501.2.4 Web Browser Troubleshooting3:561.2.10 Social Media4:411.2.12 Cloud Computing4:571.2.14 Online Streaming2:28Total Video Time25:39Lab/Activity1.2.16 Skills Lab: Web Browsing with Internet ExplorerFact Sheets1.2.2 Web and Internet Facts1.2.5 Website Navigation1.2.6 Microsoft Internet Explorer Facts1.2.7 Google Chrome Facts1.2.8 Mozilla Firefox Facts1.2.9 Microsoft Edge Facts1.2.11 Social Media Facts1.2.13 Cloud Computing Facts1.2.15 Online Streaming FactsNumber of Exam Questions10 questionsTotal TimeAbout 101 minutes1.3: Digital CommunicationSummaryAs you study this section, answer the following questions: What methods of digital communication do you use on a regular basis?Why is it important to follow rules of etiquette when interacting online?How does a webmail application such as Gmail differ from a desktop mail application such as Microsoft Outlook?This section introduces you to different methods of digital communication and gives you practice composing and sending email messages. It covers the following learning objectives: Identify and describe various forms of electronic communication, including email, instant messaging, forums, text messaging, video chat, and social networking.Download and install smartphone apps.Send and receive SMS messages.Identify popular mobile operating systems.Explain the difference between WiFi and cellular-enabled Internet access.Identify options for transferring digital photos from your smartphone to your PC.Describe the basic features of popular web-based applications such as Gmail and Google Calendar.Use Microsoft Outlook to format, send, and receive email.Identify common rules of netiquette.Video/DemoTime1.3.1 Digital Communication3:201.3.5 Introduction to Outlook2:051.3.6 Checking Your Email2:581.3.7 Formatting and Sending Messages2:481.3.8 Email Etiquette3:111.3.9 Attachments and Hyperlinks2:52Total Video Time17:14Lab/Activity1.3.12 Skills Lab: Microsoft Outlook EmailFact Sheets1.3.2 Digital Communication Facts1.3.3 Smartphone Facts1.3.4 Gmail and Google Calendar1.3.10 Outlook Facts1.3.11 Rules of NetiquetteNumber of Exam Questions10 questionsTotal TimeAbout 73 minutes1.4: 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 safeguards you should consider when making online purchases?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.Evaluate email messages to determine if they represent a possible social engineering attack.Safely spend money on the Internet.Explain why it's important to back up data.Describe the basics of data encryption.Describe the importance of having a secure password.Configure a browser popup blocker.Adjust browser privacy settings.Define different kinds of malware and know how to avoid them.Clear a browser's cache.Video/DemoTime1.4.1 Computer Security Risks4:471.4.3 Windows Firewall5:181.4.4 Malware Protection on Windows4:011.4.6 Web Browsers and Email7:301.4.7 Internet Safety and Security7:581.4.9 Ecommerce Safeguards4:531.4.11 Encryption and Authentication3:32Total Video Time37:59Lab/Activity1.4.13 Skills Lab: Practice Online Safety and Security1.4.14 Applied Lab: Configure Windows Firewall1.4.15 Applied Lab: Configure Privacy Settings in IE1.4.16 Applied Lab: Clear the Browser Cache1.4.17 Applied Lab: Respond to Social Engineering1.4.18 Applied Lab: Configure the IE Popup BlockerFact Sheets1.4.2 Computer Security Risks1.4.5 Windows 10 Security Measures1.4.8 Internet Safety Facts1.4.10 Ecommerce Safety Facts1.4.12 Encryption and Authentication FactsNumber of Exam Questions10 questionsTotal TimeAbout 143 minutes1.5: Evaluating Online InformationSummaryAs you study this section, answer the following questions: How does content on the Internet attempt to influence the way I think? Who stands to benefit from this influence?How can I use search engines to find the information I'm looking for?How can I protect my intellectual property? How can I protect the intellectual property of others?This section introduces you to sources of online information and how to appropriately evaluate and use them. It covers the following learning objectives: Use advanced search to find information on the Internet.Understand the implications of copyright and intellectual property laws for Internet use.Define and describe the uses of webpages, blogs, wikis, and podcasts.Recognize primary, secondary, and tertiary sources, and describe the uses of each.Scrutinize a source for potential bias or false information.Know the difference between scholarly and consumer-level sources.Video/DemoTime1.5.1 Online Searches4:141.5.3 Copyright and Intellectual Property5:141.5.5 Online Academic Research5:13Total Video Time14:41Fact Sheets1.5.2 Online Searching Facts1.5.4 Copyright Facts1.5.6 Online Academic Research Facts1.5.7 Activity: Identify SourcesNumber of Exam Questions10 questionsTotal TimeAbout 45 minutes2.1: 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.Evaluate whether a computer system measures up to a list of minimum requirements.Use the Settings app to view system information.Identify and state the purpose of common hardware components.Video/DemoTime2.1.1 Desktop and Mobile Devices4:062.1.3 PC Hardware Components5:232.1.5 PC Ports and Connectors3:292.1.7 Peripheral Devices4:472.1.9 Printers2:182.1.11 Checking System Requirements3:242.1.13 Using the Hardware Simulator5:23Total Video Time28:50Lab/Activity2.1.14 Skills Lab: Connect Computer Devices2.1.15 Applied Lab: Connect a Monitor2.1.16 Applied Lab: Set Up a Computer2.1.17 Applied Lab: Install USB Devices2.1.18 Applied Lab: Connect a PrinterFact Sheets2.1.2 Desktop vs. Mobile Devices2.1.4 PC Hardware Facts2.1.6 PC Port and Connector Facts2.1.8 Peripheral Device Facts2.1.10 Printer Facts2.1.12 System Requirement FactsNumber of Exam Questions10 questionsTotal TimeAbout 129 minutes2.2: System SoftwareSummaryAs you study this section, answer the following questions: What is the difference between hardware, system software, and application software?What is the purpose of an operating system?How can the Windows operating system be configured through the Settings app?What components are required to send a document to a printer?What is the difference between a local and a network printer?When do you need to manage print jobs that are queued up waiting for the printer?This section introduces you to the Windows 10 operating system and gives you practice using the Windows user interface. It covers the following learning objectives: Identify and describe different types of system software.Identify common operating systems.Identify and describe components of the Windows 10 operating system.Change display settings in Windows.Use the Settings app to view system information.Configure a screen saver through the Settings app.Describe Windows printing features.Connect to a shared printer.Configure the default printer.Share a local printer with other users.Configure Windows Update settings.Back up and restore files.Recognize and use utility software.Video/DemoTime2.2.1 System Software3:012.2.3 Operating System Functions1:562.2.5 The Windows 10 Operating System3:532.2.7 Windows Settings2:572.2.9 Windows Printing Features4:292.2.11 Windows Update2:45Total Video Time19:01Lab/Activity2.2.13 Skills Lab: Explore Windows 10 Features2.2.14 Applied Lab: Change Display Settings2.2.15 Applied Lab: Connect to a Printer2.2.16 Applied Lab: Share a Printer2.2.17 Applied Lab: Configure Windows UpdateFact Sheets2.2.2 System Software Facts2.2.4 Common Operating Systems2.2.6 Windows 10 Components2.2.8 Windows Settings Facts2.2.10 Windows Printing Facts2.2.12 Windows Update FactsNumber of Exam Questions10 questionsTotal TimeAbout 120 minutes2.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/DemoTime2.3.1 Storage Devices4:072.3.3 Windows File Management6:052.3.5 Shared Storage3:102.3.7 Cloud Storage4:41Total Video Time18:03Lab/Activity2.3.9 Skills Lab: Manage and Share Files in Windows2.3.10 Applied Lab: Manage Files2.3.11 Applied Lab: Copy Files from a USB Thumb Drive2.3.12 Applied Lab: Use Shared Storage2.3.13 Applied Lab: Use OneDrive StorageFact Sheets2.3.2 File Storage Options2.3.4 Windows File Management Facts2.3.6 Shared Storage Facts2.3.8 Windows Cloud Storage FactsNumber of Exam Questions10 questionsTotal TimeAbout 109 minutes2.4: Application SoftwareSummaryAs you study this section, answer the following questions: What software applications can assist you in collaborating with other people?What are the safest methods of installing applications?What are the advantages and disadvantages of software subscriptions?This section introduces you to desktop applications and gives you practice configuring access to these applications. After finishing this section, you should be proficient in the following tasks: 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.Open and print a document from Microsoft Word.Describe the advantages and disadvantages of different software installation methods.Identify application software that facilitates collaboration, including: Discussion boardsScreen sharingCalendaringResource managementWebinarsCollaborative editingVideo/DemoTime2.4.1 Desktop Applications3:372.4.3 Collaboration Tools3:06Total Video Time6:43Lab/Activity2.4.6 Skills Lab: Use Desktop Applications2.4.7 Applied Lab: Run Desktop Applications2.4.8 Applied Lab: Open and Print a Document in WordFact Sheets2.4.2 Desktop Application Facts2.4.4 Collaboration Tool Facts2.4.5 Installing ApplicationsNumber of Exam Questions6 questionsTotal TimeAbout 68 minutes2.5: Networking and User AccountsSummaryAs you study this section, answer the following questions: Why is it important that computers on a network use the same protocols?What hardware components are needed for a wired network? A wireless network?How can you create a user account to allow a friend or family member to log in to your computer?This section introduces you to computer networking and gives you practice creating user accounts, removing accounts, and connecting to wireless networks. It covers the following objectives: Define and state some advantages of computer networking.Describe the relationship between ISPs and the Internet.Define the Internet and understand basic Internet protocols.Explain the role of hosts and servers on a network.Create a local account for a user who already has a Microsoft login.Create a non-Microsoft user account.Remove user accounts.Connect to a public WiFi network.Connect to a secure wireless network.Video/DemoTime2.5.1 Wired and Wireless Networks3:122.5.3 The Internet3:182.5.4 Internet Protocols5:322.5.6 Network Servers2:092.5.8 Windows User Accounts3:08Total Video Time17:19Lab/Activity2.5.10 Skills Lab: Configure Networking and User Accounts2.5.11 Applied Lab: Create a User2.5.12 Applied Lab: Connect to a Wireless NetworkFact Sheets2.5.2 Networking Facts2.5.5 Internet Protocol Facts2.5.7 Network Server Facts2.5.9 Windows User Account FactsNumber of Exam Questions6 questionsTotal TimeAbout 84 minutes2.6: DatabasesSummaryAs you study this section, answer the following questions: What are the advantages to storing data in a relational database? Are there disadvantages?What databases do you interact with in your everyday life?What kinds of questions can be answered by analyzing Big Data?This section introduces you to relational databases. It covers the following learning objectives: Identify and state the purposes of a relational database.Define basic relational database terminology including: FieldRecordPrimary keyForeign keyOne-to-many relationshipExplain what SQL is and interpret a basic SQL query.Define the term Big Data and describe its related challenges and opportunities.Use Microsoft Access to perform basic operations on database objects, including tables, forms, queries, and reports.Video/DemoTime2.6.1 Introduction to Relational Databases3:332.6.2 Database Terminology2:172.6.3 Tour of Access3:352.6.4 SQL3:122.6.6 Big Data4:22Total Video Time16:59Lab/Activity2.6.8 Skills Lab: Microsoft Access DatabasesFact Sheets2.6.5 Database Terms2.6.7 Big Data FactsNumber of Exam Questions7 questionsTotal TimeAbout 54 minutes2.7: Computer ProgrammingSummaryAs you study this section, answer the following questions: Why must computer programs be precise in giving instructions to the computer?What products and services that I use were created by programmers?How has artificial intelligence already affected my life?This section introduces you to computer programming. It covers the following learning objectives: Explain what computer programming is and why it is useful.Describe the difference between developing computer programs and using software packages.Name several programming languages.Analyze and understand pseudocode.Describe several careers in computer science.Identify and understand the purposes of HTML, CSS, and JavaScript in a web browser.Describe the relationship between computer programming and artificial intelligence.Explain the advantages of Object-Oriented Programming.Create a simple Microsoft Excel macro using Visual Basic for Applications (VBA).Video/DemoTime2.7.1 Basic Programming Concepts3:352.7.2 HTML, CSS, and JavaScript5:442.7.3 Object-Oriented Programming3:202.7.6 Careers in Computer Programming2:162.7.8 Artificial Intelligence3:41Total Video Time18:36Fact Sheets2.7.4 Basic Programming Facts2.7.5 HTML, CSS, and JavaScript Facts2.7.7 Computer Science Career Facts2.7.9 Artificial Intelligence Facts2.7.10 Activity: Excel VBA AssignmentNumber of Exam Questions9 questionsTotal TimeAbout 53 minutes2.8: Information SystemsSummaryAs you study this section, answer the following questions: How do technology, people, and procedures work together in an information system?What are some principles for effective systems analysis and design?What are some examples of information technology careers?This section introduces you to information systems. It covers the following learning objectives: Describe the components of an information system.Identify and describe the most important sectors of the ICT industry.Conduct online research on a career that interests you in information technology.Identify the traditional stages of the System Development Life Cycle (SDLC).Describe modern alternatives to a linear process of systems analysis and design.Describe several IT careers, including the following: Network ArchitectDatabase AdministratorProgrammerSupport SpecialistSecurity AnalystVideo/DemoTime2.8.1 Introduction to Information Systems3:152.8.3 Systems Analysis & Design5:012.8.5 The ICT Industry2:402.8.7 Information Technology Careers3:33Total Video Time14:29Fact Sheets2.8.2 Information System Facts2.8.4 Systems Analysis Facts2.8.6 ICT Industry Facts2.8.8 IT Career Facts2.8.9 Activity: IT Career ExplorationNumber of Exam Questions5 questionsTotal TimeAbout 45 minutes3.1: Getting Started with OfficeSummaryAs you study this section, answer the following questions: How are Word, Excel, and PowerPoint similar to each other?When is it appropriate to save a file locally? Remotely?What kinds of commands can be accessed through the Ribbon?This section lets you practice using some of the basic features of Microsoft Office applications. It covers the following learning objectives: Create a new blank file.Save a file to the local computer.Save a file remotely with OneDrive.Save in alternate file formats.Enable a downloaded file for editing.Open an existing file.Edit file properties.Collapse and expand the Ribbon.Video/DemoTime3.1.1 Introduction to Office Applications2:233.1.2 Learning Office Applications4:243.1.3 The Ribbon3:013.1.4 Beyond the Ribbon4:183.1.5 Backstage View Options3:383.1.6 Lab Types4:30Total Video Time22:14Lab/Activity3.1.9 Skills Lab: Get Started with Office3.1.10 Challenge Lab: Get Started with OfficeFact Sheets3.1.7 Common Office Application Features3.1.8 Desktop vs. Web ApplicationsTotal TimeAbout 73 minutes3.2: Customizing Views and OptionsSummaryAs you study this section, answer the following questions: What are the advantages and disadvantages of zooming in? Zooming out?When would it be beneficial to split an application window?How can customizing the Quick Access Toolbar make it more useful?This section lets you practice using different viewing options in Microsoft Office. It covers the following learning objectives: Change document views.Use zoom.Customize the Quick Access Toolbar.Customize the Ribbon.Split the window.Video/DemoTime3.2.1 Document Views3:233.2.2 Customizing Toolbars and Ribbons3:20Total Video Time6:43Lab/Activity3.2.4 Skills Lab: Customize Views and Options3.2.5 Challenge Lab: Customize Views and OptionsFact Sheets3.2.3 Customization FactsTotal TimeAbout 52 minutes3.3: Printing FilesSummaryAs you study this section, answer the following questions: How can printing handouts improve a PowerPoint presentation?What print settings are appropriate for what contexts?When is it best to print part of a document, as opposed to the whole thing?This section lets you practice printing in Microsoft Office applications. It covers the following learning objectives: Configure documents to print.Print sections of documents.Set print scaling.Change page setup options.Print individual Excel worksheets.Print handouts in PowerPoint.Configure PowerPoint to print in grayscale.Print speaker notes in PowerPoint.Video/DemoTime3.3.1 Printing Options in Office Applications4:37Total Video Time4:37Lab/Activity3.3.3 Skills Lab: Print Files3.3.4 Challenge Lab: Print FilesFact Sheets3.3.2 Office Printing FactsTotal TimeAbout 50 minutes3.4: Navigating FilesSummaryAs you study this section, answer the following questions: How can Find and Replace be used to save time?When is it better to use Go To? When is it better to use Find?What can hyperlinks do to improve a document?This section lets you practice navigating and searching in Microsoft Office products. It covers the following learning objectives: Search for text within a document.Insert hyperlinks.Create bookmarks.Use Go To.Find and Replace data.Video/DemoTime3.4.1 Navigating Through a Word Document4:243.4.2 Navigating Through an Excel Workbook4:09Total Video Time8:33Lab/Activity3.4.4 Skills Lab: Navigate Files3.4.5 Challenge Lab: Navigate FilesFact Sheets3.4.3 Navigation FactsTotal TimeAbout 54 minutes3.5: Working with ObjectsSummaryAs you study this section, answer the following questions: How can learning to work with objects in one application carry over to another one?How are pictures similar to shapes? How are they different?How can objects be used to improve a document, presentation, or workbook?This section lets you practice inserting and formatting objects such as shapes and images. It covers the following learning objectives: Insert textboxes.Insert images.Add borders, styles, and effects to objects.Change object colors.Modify object properties.Position objects.Modify shape backgrounds.Apply borders to shapes.Insert shapes.Create custom shapes.Apply styles to objects.Resize objects.Display gridlines.Video/DemoTime3.5.1 Formatting Images4:493.5.2 Formatting Shapes3:58Total Video Time8:47Lab/Activity3.5.4 Skills Lab: Work with Objects3.5.5 Challenge Lab: Work with ObjectsFact Sheets3.5.3 Object Formatting FactsTotal TimeAbout 54 minutes4.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?Which 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.Use collaboration features.Use macros.Video/DemoTime4.1.1 Introduction to Word2:19Total Video Time2:19Fact Sheets4.1.2 Word Tasks OverviewTotal TimeAbout 8 minutes4.2: Creating Documents and Using the ClipboardSummaryAs 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.Print documents.Scroll through a document.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.Open a PDF for editing.Insert text from an external source.Reorganize the content in a document.Paste text from a website into a Word document.Video/DemoTime4.2.1 Text Selection3:084.2.2 The Clipboard4:154.2.3 Document File Formats3:264.2.4 Word Printing Tips3:474.2.5 Text Importing3:30Total Video Time18:06Lab/Activity4.2.7 Skills Lab: Create Documents4.2.8 Challenge Lab: Create Documents4.2.10 Applied Lab: Prepare a Business Memo4.2.11 Applied Lab: Reorganize Class NotesFact Sheets4.2.6 Document Creation Facts4.2.9 Document Creation TipsTotal TimeAbout 89 minutes4.3: 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/DemoTime4.3.1 Font Changes3:564.3.2 Font Choices3:53Total Video Time7:49Lab/Activity4.3.4 Skills Lab: Modify Fonts4.3.5 Challenge Lab: Modify Fonts4.3.7 Applied Lab: Prepare a Resume4.3.8 Applied Lab: Format a Math WorksheetFact Sheets4.3.3 Font Facts4.3.6 Font TipsTotal TimeAbout 78 minutes4.4: 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/DemoTime4.4.1 Paragraph and Line Spacing4:134.4.2 Indentation and Tabs4:274.4.3 Bulleted and Numbered Lists3:414.4.4 Paragraph Borders and Shading3:15Total Video Time15:36Lab/Activity4.4.6 Skills Lab: Format Paragraphs4.4.7 Challenge Lab: Format Paragraphs4.4.9 Applied Lab: Format Research Paper Paragraphs4.4.10 Applied Lab: Format ListsFact Sheets4.4.5 Paragraph Formatting Facts4.4.8 Paragraph Formatting TipsTotal TimeAbout 86 minutes4.5: 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.Modify hyphenation options.Add line numbers.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/DemoTime4.5.1 Page Layout Options3:244.5.2 Page and Column Breaks2:214.5.3 Tab Stops2:19Total Video Time8:04Lab/Activity4.5.5 Skills Lab: Format Pages4.5.6 Challenge Lab: Format Pages4.5.8 Applied Lab: Format a Report Draft4.5.9 Applied Lab: Format a Music ProgramFact Sheets4.5.4 Page Formatting Facts4.5.7 Page Formatting TipsTotal TimeAbout 79 minutes4.6: 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/DemoTime4.6.1 AutoCorrect Options3:054.6.2 Spell Checking2:134.6.3 The Thesaurus4:10Total Video Time9:28Lab/Activity4.6.5 Skills Lab: Edit Documents4.6.6 Challenge Lab: Edit Documents4.6.8 Applied Lab: Edit an Essay4.6.9 Applied Lab: Edit a Newspaper ArticleFact Sheets4.6.4 Document Editing Facts4.6.7 Document Editing TipsTotal TimeAbout 80 minutes4.7: 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.Insert a cover page.Insert a screen shot and screen clipping.Insert text boxes.Insert Quick Parts.Use the Building Blocks Organizer.Create Custom Building Blocks.Remove picture backgrounds.Modify text wrap settings for visual appeal.Apply best practices in using graphics.Video/DemoTime4.7.1 Text Wrap Options2:504.7.2 Illustration Formatting4:004.7.3 Building Blocks and Other Elements4:00Total Video Time10:50Lab/Activity4.7.5 Skills Lab: Insert Illustrations4.7.6 Challenge Lab: Insert Illustrations4.7.8 Applied Lab: Insert Images for a Poster4.7.9 Applied Lab: Insert Images for a FlyerFact Sheets4.7.4 Word Illustration Facts4.7.7 Word Illustration TipsTotal TimeAbout 81 minutes4.8: 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.Convert text to a table.Configure cell margins and spacing.Split tables.Configure a repeating row header.Align table data for better readability.Apply table styles that increase readability and visual appeal.Video/DemoTime4.8.1 Word Tables3:024.8.2 Table Formatting5:014.8.3 Advanced Table Formatting3:05Total Video Time11:08Lab/Activity4.8.5 Skills Lab: Create and Format Tables4.8.6 Challenge Lab: Create and Format Tables4.8.8 Applied Lab: Format a Calendar4.8.9 Applied Lab: Format Tables for a Sales ReportFact Sheets4.8.4 Word Table Facts4.8.7 Word Table TipsTotal TimeAbout 82 minutes4.9: 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/DemoTime4.9.1 Word Styles3:444.9.2 Themes and Style Sets4:044.9.3 Word Templates2:58Total Video Time10:46Lab/Activity4.9.5 Skills Lab: Use Themes, Styles, and Templates4.9.6 Challenge Lab: Use Themes, Styles, and Templates4.9.8 Applied Lab: Create a Certificate Using a Template4.9.9 Applied Lab: Format a NewsletterFact Sheets4.9.4 Word Theme & Style Facts4.9.7 Word Theme & Style TipsTotal TimeAbout 81 minutes4.10: 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.Insert figure and table captions.Modify caption properties.Insert a table of contents.Cite sources for an academic paper using the MLA, Chicago, and APA citation styles.Video/DemoTime4.10.1 Citations and References4:174.10.2 Footnotes, Endnotes, and Advanced Citations5:044.10.3 Captions2:234.10.4 Table of Contents2:37Total Video Time14:21Lab/Activity4.10.6 Skills Lab: Manage References4.10.7 Challenge Lab: Manage References4.10.9 Applied Lab: Manage Essay References4.10.10 Applied Lab: Add References to Research ReportFact Sheets4.10.5 Reference Facts4.10.8 Reference TipsTotal TimeAbout 85 minutes4.11: 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/DemoTime4.11.1 Headers and Footers4:094.11.2 Header and Footer Options2:574.11.3 Next Page Section Breaks4:334.11.4 Continuous Section Breaks4:27Total Video Time16:06Lab/Activity4.11.6 Skills Lab: Manage Headers, Footers, and Sections4.11.7 Challenge Lab: Manage Headers, Footers, and Sections4.11.9 Applied Lab: Format a Research Paper with Sections4.11.10 Applied Lab: Format a Survey ReportFact Sheets4.11.5 Word Header, Footer, & Section Facts4.11.8 Word Header, Footer, & Section TipsTotal TimeAbout 87 minutes4.12: Using Office Collaboration FeaturesSummaryAs you study this section, answer the following questions: How can collaboration features make it easier to work with others?When is it appropriate to add comments to a document?What are the best ways to share a file with collaborators?This section gives you extensive practice using Microsoft Office collaboration features. It covers the following learning objectives: Enable Track Changes.Accept and reject changes.Discard changes from specific users.Protect documents with passwords.Mark a document as final.Add and manage comments.Restrict permissions.Use Compare and Combine on different documents.Inspect a document for sharing.Remove personal metadata.Inspect a document for accessibility.Add alternative text for accessibility.Embed custom fonts into a document.Video/DemoTime4.12.1 Track Changes and Comments3:514.12.2 Combining Revisions4:024.12.3 Distributing Files4:27Total Video Time12:20Lab/Activity4.12.5 Skills Lab: Use Collaboration Features4.12.6 Challenge Lab: Use Collaboration Features4.12.8 Applied Lab: Prepare a Business Memo for Distribution4.12.9 Applied Lab: Prepare an Online ResumeFact Sheets4.12.4 Collaboration Facts4.12.7 Collaboration TipsTotal TimeAbout 83 minutes4.13: Using MacrosSummaryAs you study this section, answer the following questions: When does it make sense to create macros?Why is macro security important?What are some of the limitations of macros?This section will introduce macros in both Word and Excel. It covers the following learning objectives: Record simple macros.Assign shortcut keys to macros.Manage macro security.Video/DemoTime4.13.1 Macros5:03Total Video Time5:03Fact Sheets4.13.2 Macro FactsTotal TimeAbout 11 minutes5.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.Summarize complex data using PivotTables and outlines.Video/DemoTime5.1.1 Introduction to Excel2:22Total Video Time2:22Fact Sheets5.1.2 Excel Tasks OverviewTotal TimeAbout 8 minutes5.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.Create a new workbook using a template.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.Import data from various applications into Excel.Video/DemoTime5.2.1 Spreadsheet Basics3:265.2.2 Worksheet Management1:515.2.3 Templates and Themes1:575.2.4 External Data2:45Total Video Time9:59Lab/Activity5.2.6 Skills Lab: Create and Manage Workbooks5.2.7 Challenge Lab: Create and Manage Workbooks5.2.9 Applied Lab: Organize Budget Worksheets5.2.10 Applied Lab: Import & Organize Research DataFact Sheets5.2.5 Workbook Management Facts5.2.8 Workbook Management TipsTotal TimeAbout 80 minutes5.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.Hide and unhide worksheets.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/DemoTime5.3.1 Deleting and Clearing Cells1:595.3.2 Copy and Paste Options3:425.3.3 Large Data Sets4:04Total Video Time9:45Lab/Activity5.3.5 Skills Lab: Organize and Enter Data5.3.6 Challenge Lab: Organize and Enter Data5.3.8 Applied Lab: Enter Survey Results Data5.3.9 Applied Lab: Organize Sales DataFact Sheets5.3.4 Data Entry Facts5.3.7 Data Entry TipsTotal TimeAbout 80 minutes5.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.Add data validation to a worksheet.Limit cell input to a list.Add a custom input message to a cell.Customize the error alert for invalid data.Include relevant worksheet properties in a printout.Optimize the printing of a worksheet.Video/DemoTime5.4.1 Data Protection3:055.4.2 Data Validation3:215.4.3 Excel Printing Tips3:17Total Video Time9:43Lab/Activity5.4.5 Skills Lab: Change Properties and Print Worksheets5.4.6 Challenge Lab: Change Properties and Print Worksheets5.4.8 Applied Lab: Prepare and Print Sales Data5.4.9 Applied Lab: Protect a Budget WorksheetFact Sheets5.4.4 Worksheet Printing Facts5.4.7 Worksheet Printing TipsTotal TimeAbout 80 minutes5.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.Use Format Painter.Adjust columns to display both numeric and textual data properly.Format a range of cells as a worksheet title.Video/DemoTime5.5.1 Number Formats3:155.5.2 Cell Formats4:185.5.3 Cell Styles and Colors2:065.5.4 Cell Borders2:31Total Video Time12:10Lab/Activity5.5.6 Skills Lab: Format Cells5.5.7 Challenge Lab: Format Cells5.5.9 Applied Lab: Camping Equipment Store5.5.10 Applied Lab: Format a DirectoryFact Sheets5.5.5 Cell Formatting Facts5.5.8 Cell Formatting TipsTotal TimeAbout 83 minutes5.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 the RIGHT, LEFT, and MID functions.Use the CONCATENATE function.Use the UPPER and LOWER functions.Use the COUNTA and COUNTBLANK functions.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.Use Flash Fill.Video/DemoTime5.6.1 AutoFill Options3:395.6.2 Excel Formulas3:585.6.3 Text Functions3:245.6.4 CONCATENATE3:25Total Video Time14:26Lab/Activity5.6.6 Skills Lab: Enter Simple Formulas5.6.7 Challenge Lab: Enter Simple Formulas5.6.9 Applied Lab: Cheese Shop5.6.10 Applied Lab: GradebookFact Sheets5.6.5 Formula Facts5.6.8 Formula TipsTotal TimeAbout 85 minutes5.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.Enter a formula using mixed references.Use the IF function.Use COUNTIF, SUMIF, and AVERAGEIF.Use functions with multiple arguments.Copy a formula with absolute, relative, or mixed references.Reference cells on other worksheets.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/DemoTime5.7.1 Relative and Absolute References3:125.7.2 Advanced Cell References5:045.7.3 The IF Function3:535.7.4 Logical Functions2:555.7.5 Excel Error Messages2:43Total Video Time17:47Lab/Activity5.7.7 Skills Lab: Use Advanced Functions5.7.8 Challenge Lab: Use Advanced Functions5.7.10 Applied Lab: County Fair5.7.11 Applied Lab: Toy CompanyFact Sheets5.7.6 Advanced Function Facts5.7.9 Advanced Function TipsTotal TimeAbout 88 minutes5.8: Displaying 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/DemoTime5.8.1 Chart Formatting2:385.8.2 Chart Types2:23Total Video Time5:01Lab/Activity5.8.4 Skills Lab: Display Data in Charts5.8.5 Challenge Lab: Display Data in Charts5.8.7 Applied Lab: Stock Portfolio5.8.8 Applied Lab: Election ResultsFact Sheets5.8.3 Chart Facts5.8.6 Chart TipsTotal TimeAbout 76 minutes5.9: Organizing 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.Analyze data using sparklines.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/DemoTime5.9.1 Conditional Formatting2:385.9.2 Excel Tables2:315.9.3 Table Customization2:40Total Video Time7:49Lab/Activity5.9.5 Skills Lab: Organize Data in Tables5.9.6 Challenge Lab: Organize Data in Tables5.9.8 Applied Lab: Pizza Chain5.9.9 Applied Lab: Baseball StatisticsFact Sheets5.9.4 Excel Table Facts5.9.7 Excel Table TipsTotal TimeAbout 78 minutes5.10: Summarizing Complex DataSummaryAs you study this section, answer the following questions: How can an outline help organize transactional data?What are some good uses for the VLOOKUP function?When could PivotTables be used to answer questions about complex data?This section will give you extensive practice using outlines, VLOOKUP, and PivotTables in Excel. It covers the following learning objectives: Create outlines.Collapse groups of data in outlines.Insert subtotals.Use the VLOOKUP function.Create PivotTables.Add fields to PivotTables.Calculate values in PivotTables.Add slicers to PivotTables.Create and use PivotCharts.Use Quick Analysis tools.Video/DemoTime5.10.1 Creating Outlines2:465.10.2 PivotTables4:175.10.3 Advanced PivotTables3:175.10.4 VLOOKUP3:23Total Video Time13:43Lab/Activity5.10.6 Skills Lab: Summarize Complex Data5.10.7 Challenge Lab: Summarize Complex Data5.10.9 Applied Lab: Muffin Café5.10.10 Applied Lab: Hardware StoreFact Sheets5.10.5 Complex Data Facts5.10.8 Complex Data TipsTotal TimeAbout 84 minutes6.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 SmartArt and other illustrations.Format tables and charts.Format pictures and media.Apply animations to slide elements.Apply transitions to slides.Deliver presentations.Print presentations and handouts.Video/DemoTime6.1.1 Introduction to PowerPoint3:076.1.2 Best Practices in Design3:36Total Video Time6:43Fact Sheets6.1.3 PowerPoint Tasks OverviewTotal TimeAbout 12 minutes6.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 applications 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.Create new slides.Hide and unhide slides.Add and remove sections in a presentation.Reorganize and modify an existing anize a long presentation into relevant sections.Video/DemoTime6.2.1 Slide Management2:536.2.2 Presentation Sections2:02Total Video Time4:55Lab/Activity6.2.4 Skills Lab: Create and Manage Presentations6.2.5 Challenge Lab: Create and Manage Presentations6.2.7 Applied Lab: Reorganize Presentation Slides6.2.8 Applied Lab: Create a New Presentation Using a TemplateFact Sheets6.2.3 Presentation Management Facts6.2.6 Presentation Management TipsTotal TimeAbout 75 minutes6.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.Format text in multiple columns.Use Autofit to shrink text on overflow.Divide content into multiple slides.Import Word document outlines.Insert slides from another presentation.Preserve presentation content.Use italics or a different font color to emphasize important content.Video/DemoTime6.3.1 Text and Content Placeholders3:286.3.2 Text Formatting3:036.3.3 Managing Presentation Content3:34Total Video Time10:05Lab/Activity6.3.5 Skills Lab: Format Textual Content6.3.6 Challenge Lab: Format Textual Content6.3.8 Applied Lab: Format Text for a Sales Presentation6.3.9 Applied Lab: Format a Class ReportFact Sheets6.3.4 PowerPoint Text Formatting Facts6.3.7 PowerPoint Text Formatting TipsTotal TimeAbout 81 minutes6.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/DemoTime6.4.1 Themes and Templates3:046.4.2 Slide Backgrounds2:22Total Video Time5:26Lab/Activity6.4.4 Skills Lab: Design Slides6.4.5 Challenge Lab: Design Slides6.4.7 Applied Lab: Design a Business Plan Presentation6.4.8 Applied Lab: Design a Class PresentationFact Sheets6.4.3 Slide Design Facts6.4.6 Slide Design TipsTotal TimeAbout 76 minutes6.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.Modify the handout and notes masters.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/DemoTime6.5.1 Slide Masters4:116.5.2 Slide Footers2:37Total Video Time6:48Lab/Activity6.5.4 Skills Lab: Use the Slide Master6.5.5 Challenge Lab: Use the Slide Master6.5.7 Applied Lab: Create a New Slide Master Layout6.5.8 Applied Lab: Customize a Slide Master LayoutFact Sheets6.5.3 Slide Master Facts6.5.6 Slide Master TipsTotal TimeAbout 77 minutes6.6: Formatting SmartArt and ShapesSummaryAs you study this section, answer the following questions: Which SmartArt designs can you use to get your point across?What does it mean to distribute objects horizontally or vertically on a slide?When is the stacking order of shapes or other objects important?This section gives you extensive practice creating SmartArt and other illustrations in PowerPoint. After finishing this section, you should be proficient in the following tasks: 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.Add and remove SmartArt shapes.Change the order of SmartArt shapes.Change the color and layout of SmartArt.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/DemoTime6.6.1 SmartArt3:096.6.2 Object Formatting3:48Total Video Time6:57Lab/Activity6.6.4 Skills Lab: Format SmartArt and Shapes6.6.5 Challenge Lab: Format SmartArt and Shapes6.6.7 Applied Lab: Format Elements in a Class Presentation6.6.8 Applied Lab: Format a Business Presentation with SmartArtFact Sheets6.6.3 SmartArt and Shape Facts6.6.6 SmartArt and Shape TipsTotal TimeAbout 77 minutes6.7: Formatting Tables and ChartsSummaryAs you study this section, answer the following questions: What special considerations should be taken when designing a table to be displayed in front of an audience?How can charts be used to help an audience understand a presentation?How are tables in PowerPoint similar to other applications? How are they different?This section gives you extensive practice with creating charts and tables in PowerPoint. It covers the following learning objectives: Create new tables.Add and remove rows and columns.Apply table styles.Import tables from external sources.Modify chart styles and types.Insert charts.Add legends to charts.Customize chart parameters.Import charts from external sources.Video/DemoTime6.7.1 PowerPoint Charts3:246.7.2 PowerPoint Tables3:02Total Video Time6:26Lab/Activity6.7.4 Skills Lab: Format Tables and Charts6.7.5 Challenge Lab: Format Tables and Charts6.7.7 Applied Lab: Modify a PowerPoint Table6.7.8 Applied Lab: Prepare a Sales PresentationFact Sheets6.7.3 Table and Chart Formatting Facts6.7.6 Table and Chart Formatting TipsTotal TimeAbout 77 minutes6.8: 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.Trim timing on media clips.Package a presentation for CD.Link to external media.Apply color corrections to a media press media.Adjust media start and stop times.Video/DemoTime6.8.1 Media Formatting2:586.8.2 Advanced Media Formatting5:36Total Video Time8:34Lab/Activity6.8.4 Skills Lab: Format Pictures and Other Media6.8.5 Challenge Lab: Format Pictures and Other Media6.8.7 Applied Lab: Format a Class Presentation on Confucius6.8.8 Applied Lab: Format a Class Presentation on PlatoFact Sheets6.8.3 Media Formatting Facts6.8.6 Media Formatting TipsTotal TimeAbout 79 minutes6.9: 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/DemoTime6.9.1 Animation2:566.9.2 Transitions3:10Total Video Time6:06Lab/Activity6.9.4 Skills Lab: Apply Animations and Transitions6.9.5 Challenge Lab: Apply Animations and Transitions6.9.7 Applied Lab: Add Transitions to a Presentation6.9.8 Applied Lab: Add Animations for EmphasisFact Sheets6.9.3 Animation and Transition Facts6.9.6 Animation and Transition TipsTotal TimeAbout 77 minutes6.10: 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.Export presentations to other formats.Create custom slide shows.Rehearse slide show timing.Annotate slide shows.Record a slide show.Create a video from a slide show.Format and print handouts to help the audience retain important information.Rehearse presentations in the actual setting where they will be delivered.Video/DemoTime6.10.1 Presentation Tools3:436.10.2 PowerPoint Print Options3:146.10.3 Advanced Slide Show Options3:38Total Video Time10:35Lab/Activity6.10.5 Skills Lab: Deliver Presentations6.10.6 Challenge Lab: Deliver Presentations6.10.8 Applied Lab: Prepare for a Presentation6.10.9 Applied Lab: Deliver a PowerPoint LectureFact Sheets6.10.4 Presentation Delivery Facts6.10.7 Presentation Delivery TipsTotal TimeAbout 81 minutes7.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.Explore more advanced Access features.Video/DemoTime7.1.1 Introduction to Relational Databases3:50Total Video Time3:50Fact Sheets7.1.2 Access Tasks OverviewTotal TimeAbout 9 minutes7.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/DemoTime7.2.1 Tour of Access2:597.2.2 Database Terminology2:23Total Video Time5:22Lab/Activity7.2.4 Skills Lab: Managing Databases7.2.5 Challenge Lab: Managing DatabasesFact Sheets7.2.3 Database Management Facts7.2.6 Database Management TipsTotal TimeAbout 56 minutes7.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/DemoTime7.3.1 Database Planning3:197.3.2 Table Design3:267.3.3 Default Values2:227.3.4 Relationships and Lookups3:227.3.5 Data Importing2:31Total Video Time15:00Lab/Activity7.3.7 Skills Lab: Design and Create Tables7.3.8 Challenge Lab: Design and Create Tables7.3.10 Applied Lab: Creating a Student Database7.3.11 Applied Lab: Creating a Library DatabaseFact Sheets7.3.6 Table Design Facts7.3.9 Table Design TipsTotal TimeAbout 85 minutes7.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/DemoTime7.4.1 Introduction to Queries2:257.4.2 Query Criteria3:027.4.3 Queries with Totals2:26Total Video Time7:53Lab/Activity7.4.5 Skills Lab: Create Queries7.4.6 Challenge Lab: Create Queries7.4.8 Applied Lab: Creating Queries for a School7.4.9 Applied Lab: Creating Queries for a LibraryFact Sheets7.4.4 Query Facts7.4.7 Query TipsTotal TimeAbout 78 minutes7.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/DemoTime7.5.1 Access Forms2:207.5.2 Form Formatting3:22Total Video Time5:42Lab/Activity7.5.4 Skills Lab: Create Forms7.5.5 Challenge Lab: Create Forms7.5.7 Applied Lab: Creating Forms for a School7.5.8 Applied Lab: Creating Forms for a LibraryFact Sheets7.5.3 Form Facts7.5.6 Form TipsTotal TimeAbout 76 minutes7.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/DemoTime7.6.1 The Report Wizard2:487.6.2 Reports with Totals2:397.6.3 Report Formatting4:38Total Video Time10:05Lab/Activity7.6.5 Skills Lab: Create Reports7.6.6 Challenge Lab: Create Reports7.6.8 Applied Lab: Creating Reports for a School7.6.9 Applied Lab: Creating Reports for a LibraryFact Sheets7.6.4 Report Facts7.6.7 Report TipsTotal TimeAbout 81 minutes7.7: Surveying Advanced Access FeaturesSummaryAs you study this section, answer the following questions: How can a navigation form make a database easier to use?What are some good uses for application parts?What is the difference between select queries and action queries?How can adding parameters to query criteria make a database easier to use?Why is it useful to be able to print information from a database?This section will survey several advanced Access features that you can practice in the live application. It covers the following learning objectives: Create a database from a template.Import database objects.Create and modify navigation forms.Set a form as a startup pact, repair, back up, and encrypt a database.Recover data from a backup.Split a database.Save a database as a template.Export data to alternative formats.Use application parts.Hide and unhide table fields.Add total rows and table descriptions.Find and replace data.Sort table records.Add data validation rules to fields.Use input masks to ensure correct data entry.Change number formatting for fields.Print individual records from a table.Add a filter to a table.Create crosstab queries.Add parameters to query criteria.Create and run action queries, including delete, rename, and append queries.Use formulas to create calculated fields.Use conditional logic in queries.Set form control properties, such as margins and padding.Configure print settings.Insert backgrounds, headers, and footers into forms.Create and format a navigation form.Add a subform.Add report controls.Change the data source for a field in a report.Edit the tab index.Change the control source for a form.Sort a report.Format a report with multiple columns.Change report orientation.Video/DemoTime7.7.1 Managing Databases2:527.7.2 Formatting Tables and Managing Records2:457.7.3 Application Parts1:597.7.4 Crosstab Queries2:457.7.5 Query Parameters2:087.7.6 Action Queries5:507.7.7 Calculated Fields and Conditional Logic5:027.7.8 Advanced Form Options4:247.7.9 Navigation Forms2:407.7.10 Advanced Report Options2:03Total Video Time32:28Fact Sheets7.7.11 Advanced Query Facts7.7.12 Additional Access Facts and VideosTotal TimeAbout 43 minutes8.1: Introduction to OutlookSummaryAs you study this introductory section, answer the following questions: Which Outlook features are also available in webmail applications such as Gmail or Yahoo! Mail?Which mail and calendar features are unique to Outlook?How can Outlook be used to improve workplace collaboration?This section introduces you to Microsoft Outlook 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: Read email messages.Format and send email anize and manage messages.Automate Outlook tasks.Create and manage calendar items.Schedule meetings.Create and assign tasks.Create notes.Create contacts and contact groups.Video/DemoTime8.1.1 Introduction to Outlook2:058.1.2 Checking Your Email2:58Total Video Time5:03Fact Sheets8.1.3 Outlook Tasks OverviewTotal TimeAbout 11 minutes8.2: Sending and Receiving MessagesSummaryAs you study this section, answer the following questions: How can email make me a more productive employee?When should I use email instead of scheduling in-person meetings?What are the security risks of using email? How can you make sure you stay safe?This section gives you extensive practice sending and receiving email messages. It covers the following learning objectives: Compose and send an email.Mark a message as read or unread.Apply text formatting to an email.Apply themes and styles to an email.Use Forward, Reply, and Reply All.Use To, Cc, and Bcc.Create and use an email signature.Change default formatting options for messages.Add, open, and remove email attachments.Preview and save email attachments.Add hyperlinks to text.Insert an image into a message.Include a read receipt with an email.Add voting options to an email.Flag an outgoing email for follow up, importance, and sensitivity.Video/DemoTime8.2.1 Formatting and Sending Messages2:488.2.2 Email Etiquette3:118.2.3 Signatures2:338.2.4 Attachments and Hyperlinks2:528.2.5 Tracking Options3:09Total Video Time14:33Lab/Activity8.2.7 Skills Lab: Send and Receive Messages8.2.8 Challenge Lab: Send and Receive Messages8.2.10 Applied Lab: Create and Send a Message8.2.11 Applied Lab: Reply to a MessageFact Sheets8.2.6 Message Facts8.2.9 Message TipsTotal TimeAbout 85 minutes8.3: Managing MessagesSummaryAs you study this section, answer the following questions: What are the benefits of keeping your Outlook account organized?How can using Outlook's automation features make managing my email easier?Why is it important to carefully monitor my junk mail seettings?How are search folders different than regular folders?This section gives you extensive practice managing email messages in Outlook. It covers the following learning objectives: Sort email messages.Create new email folders.Move messages into folders.Apply categories to emails.Flag received messages.Create and edit rules.Create and use Quick Steps.Redirect replies to another email address.Set up automatic replies.Recall a message.Configure AutoArchive.Customize junk mail options.Use the Clutter feature.Clean up and ignore conversations.Search and use Advanced Find.Create search folders.Import and export mail folders.Save an email to your hard drive.Delete an email message.Print an email.Video/DemoTime8.3.1 Organizing Messages2:478.3.2 Automating Outlook5:208.3.3 Junk Mail and Clutter2:438.3.4 Conversations2:188.3.5 Searching in Outlook3:418.3.6 Importing and Exporting2:51Total Video Time19:40Lab/Activity8.3.8 Skills Lab: Manage Messages8.3.9 Challenge Lab: Manage Messages8.3.11 Applied Lab: Manage Rules and Replies8.3.12 Applied Lab: Organize and Filter MessagesFact Sheets8.3.7 Message Management Facts8.3.10 Message Management TipsTotal TimeAbout 90 minutes8.4: Working with the CalendarSummaryAs you study this section, answer the following questions: How can Outlook's calendars help me work more efficiently?Which details of my calendars should I share? Which details should I keep private?Why is it important to respond promptly to meeting requests?This section gives you extensive practice creating and managing calendars. It covers the following learning objectives: Share a calendar.Create and add a new calendar.Delete a calendar.Adjust viewing details for calendars.Modify calendar time zones.Set calendar work times.Display and manage multiple calendars.Manage calendar groups.Add appointments to a calendar.Set recurrence for a calendar item.Set calendar item importance.Forward a calendar item.Categorize calendar items.Change the free or busy status of a calendar item.Update individual or recurring calendar items.Create a new meeting.Configure reminders.Share meeting notes.Cancel a meeting.Respond to a meeting request.Use the Scheduling Assistant.Use Room Finder to set up a meeting location.Create a meeting from an email.Create a new task.Assign a task to another person.Video/DemoTime8.4.1 Create and Manage Calendars3:328.4.2 Calendar Items3:108.4.3 Meetings3:168.4.4 Tasks2:05Total Video Time12:03Lab/Activity8.4.6 Skills Lab: Work with the Calendar8.4.7 Challenge Lab: Work with the Calendar8.4.9 Applied Lab: Schedule Calendar Items8.4.10 Applied Lab: Work with Calendar ItemsFact Sheets8.4.5 Calendar Facts8.4.8 Calendar TipsTotal TimeAbout 83 minutes8.5: Managing Contacts and GroupsSummaryAs you study this section, answer the following questions: How can contact groups save me time when I write emails?When might I want to work with more than one Outlook account?Which people should I create contacts for?This section gives you extensive practice using contacts and contact groups in Outlook. It covers the following learning objectives: Create a new contact.Share contacts.Edit contact information.Attach an image to a contact.Add tags to contacts.Distinguish between contacts and other users in the Address Book.Send a message to a contact group.Create a contact group.Add and remove members from a contact group.Delete contacts and contact groups.Update contacts within contact groups.Add notes to a contact group.Send emails to contact groups.Use the Tasks, Notes, and Folders views.Customize the navigation bar.Add and manage a new Outlook account.Delegate access to an Outlook account.Import contacts from external sources.Video/DemoTime8.5.1 Creating Contacts3:398.5.2 Contact Groups2:318.5.3 Using the Navigation Bar2:288.5.4 Working With Multiple Accounts3:14Total Video Time11:52Lab/Activity8.5.6 Skills Lab: Manage Contacts and Groups8.5.7 Challenge Lab: Manage Contacts and Groups8.5.9 Applied Lab: Create and Modify Contacts8.5.10 Applied Lab: Work with Contact GroupsFact Sheets8.5.5 Contact and Group Facts8.5.8 Contact and Group TipsTotal TimeAbout 82 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 B.1: Preparing for MOS CertificationSummaryThe best way to prepare for the Microsoft Office Specialist exams is to study the material in the Desktop Pro Plus course. Watch the instructional videos, complete the labs, and experiment with real projects in the live applications. The instruction and practice tests in this section can help you with your final preparation. We recommend that you take the following steps as you prepare for the MOS exams: Study the Desktop Pro Plus Course MaterialThe course materials include instruction, demonstrations, and hands-on practice. As you work through the course, follow these hints for the most effective study methods: Read all of the exam objectives. Use the MOS Exam Objectives sheet in this section to review the objectives for the particular exam you are studying for. The objectives outline the skills and knowledge you'll need for the official MOS certification exam. The Desktop Pro Plus course is designed to present the information you need to pass the exam questions covering these objectives.Work through your study materials completely. Watch the videos, read the material and click all the links for each section. Practice the tasks so that you feel comfortable with your ability to complete them. Do not skip sections unless you are sure you understand the content and can easily answer questions about each of the objectives. Even if you already know the material, a review never hurts, especially for advanced skills.Take the MOS Practice ExamsWhen you have finished studying the course material, you are ready to take the MOS practice exams for Word, Excel, and PowerPoint. These exams provide a final check to help you decide if you’re ready to take the actual exams. Each form (A and B) has approximately the same number of questions and tasks as the MOS exam. Consider the following tips as you take the practice exams. Treat the certification practice exams like you would the real thing: set aside an hour for each form, find an environment where you won’t be distracted, and complete the entire exam form in one sitting.After completing each set of tasks and clicking Done, you will not be able to return to those tasks.When you’re done with the practice exam form, you’ll get a report of which tasks you did correctly and which ones you missed. To see the detailed feedback, click the Individual Responses option and then open the lab report for the questions you missed. Review the course material for those questions.Keep in mind that after you click Done on the Exam Report, you’ll no longer have access to your individual responses for that practice session.Schedule and Take the MOS ExamAfter studying the Desktop Pro Plus course materials and taking the MOS practice exams, you are ready to take the official MOS exams. Consider the following tips as you schedule and take the MOS exams. If you will be scheduling the exam yourself, go to and locate Certifications.The Certiport website also includes an online Exam Tutorial.When taking the MOS exam, keep an eye on the time. You’ll have 50 minutes to finish the whole test, and there will be about 35 total tasks. That means you have about a minute and a half to perform each individual task. If you get to a task that you can’t figure out after a couple of minutes, just skip it. It’s better to miss one task early on than to get yourself into a time crunch. You’ll almost certainly come across a few tasks that you’ve never done or even heard of before. However, before you skip the task, look for relevant panes and dialog boxes, which typically have most of the settings you'll need. If you see a contextual tab, that's usually the best place to start searching. If the question asks for a specific setting, you may need to hover the mouse and read the tool tips to find the right one.Video/DemoTimeB.1.1 Preparing for the MOS Exams2:40B.1.2 Performing Unfamiliar Tasks7:17B.1.3 Using TestOut MOS Practice Exams3:30Total Video Time13:27Fact SheetsB.1.4 MOS Exam ObjectivesB.1.5 Taking an MOS ExamTotal TimeAbout 24 minutesB.2: Microsoft Word 2016 Core (77-725)SummaryThis section includes two practice exam forms for the MOS Word 2016 Core exam (77-725). Each form includes approximately the same number of questions and tasks as the actual MOS exam. While a few questions are repeated across the forms, we recommend that you complete both. This will help you with pacing and give you greater confidence as you prepare for certification. While the Desktop Pro Plus course includes lab simulations for most MOS objectives, some of the objectives are covered only through text and video instruction. For these objectives, we encourage you to study the video demonstrations and to experiment with the relevant features using the live Microsoft Office applications. If you are preparing for the MOS Word Core exam, pay particular attention to the following learning resources that cover objectives that do not include lab simulations within the course. Video Resources for Non-Simulated MOS Objectives 2.5.1 – Formatting ImagesInsert text boxes Apply artistic effects Apply picture effects 3.2.5 – Text ImportingInsert text from a file or external source 3.4.3 – Bulleted and Numbered ListsDefine a custom bullet character or number format 3.7.4 – Cover Page (Text Lesson Video)Insert a cover page 3.7.4 – Remove Picture Backgrounds (Text Lesson Video)Remove picture backgrounds 3.8.3 – Advanced Table FormattingConvert text to tables Sort table data 3.10.4 – Table of ContentsInsert a standard table of contents Update a table of contents 5.6.1 – SmartArtCreate a SmartArt graphic Format a SmartArt graphic Modify SmartArt graphic content Number of Exam Questions14 questionsTotal TimeAbout 105 minutesB.3: Microsoft Excel 2016 Core (77-727)SummaryThis section includes two practice exam forms for the MOS Excel 2016 Core exam (77-727). Each form includes approximately the same number of questions and tasks as the actual MOS exam. While a few questions are repeated across the forms, we recommend that you complete both. This will help you with pacing and give you greater confidence as you prepare for certification. While the Desktop Pro Plus course includes lab simulations for most MOS objectives, some of the objectives are covered only through text and video instruction. For these objectives, we encourage you to study the video demonstrations and to experiment with the relevant features using the live Microsoft Office applications. If you are preparing for the MOS Excel Core exam, pay particular attention to the following learning resources that cover objectives that do not include lab simulations within the course. Video Resources for Non-Simulated MOS Objectives 2.5.1 – Formatting ImagesInsert images Modify object properties 3.12.3 – Distributing Files Inspect a workbook for hidden properties or personal information 4.3.4 – Hide Worksheets (Text Lesson Video)Hide or unhide worksheets 4.8.3 – Chart Design Features (Text Lesson Table)Switch between rows and columns in source data Move charts to a chart sheet 4.9.2 – Excel TablesSort data by multiple columns 4.9.4 – Sparklines (Text Lesson Video)Insert sparklines Number of Exam Questions14 questionsTotal TimeAbout 105 minutesB.4: Microsoft PowerPoint 2016 (77-729)SummaryThis section includes two practice exam forms for the MOS PowerPoint 2016 exam (77-729). Each form includes approximately the same number of questions and tasks as the actual MOS exam. While a few questions are repeated across the forms, we recommend that you complete both. This will help you with pacing and give you greater confidence as you prepare for certification. While the Desktop Pro Plus course includes lab simulations for most MOS objectives, some of the objectives are covered only through text and video instruction. For these objectives, we encourage you to study the video demonstrations and to experiment with the relevant features using the live Microsoft Office applications. If you are preparing for the MOS PowerPoint exam, pay particular attention to the following learning resources that cover objectives that do not include lab simulations within the course. Video Resources for Non-Simulated MOS Objectives 2.5.1 – Formatting ImagesDisplay alignment tools 2.5.2 – Formatting ShapesApply styles to shapes and text boxes 3.12.3 – Distributing FilesInspect a presentation 5.3.3 – Managing Presentation ContentImport Word document outlines Import slides from another presentation 5.3.4 – Format Text in Multiple Columns (Text Lesson Video)Format text in multiple columns 5.7.3 – Import a Table (Text Lesson Video)Import a table 5.10.3 – Advanced Slide Show OptionsCreate custom slide shows Number of Exam Questions14 questionsTotal TimeAbout 105 minutesAppendix A: Course ObjectivesThis course teaches basic computer technology skills and the use of Microsoft Office applications, including Word, Excel, PowerPoint, Access, and Outlook. Chapter 1: Online Essentials 1.1 The Information Age Recall significant developments in the history of modern computing. Identify uses of computers in today's world. Describe the binary number system used by computers to process data.Define bits and bytes.Explain how physical signals are translated into digital information.Describe how audio and video are stored digitally.Distinguish between raster and vector images.Select the best format for digital images.Describe how RGB values determine pixel pare common image file types.Describe ethical considerations related to evolving forms of technology.1.2 The Internet and Social Media Define the World Wide Web.Describe the essential components of the Web, including websites, URLs, hyperlinks, web browsers, and search engines.Identify technologies that use the Internet, including the Web, email, instant messaging, VoIP, and the Internet of Things.Identify common web applications, including Webmail, Google Docs, Facebook, and YouTube.Define and describe the uses of cloud computing.Define social media and describe its uses.Recognize the risks and responsibilities of using social media.Identify and appropriately respond to cyberbullying.Describe the difference between downloading, live streaming, and on-demand streaming.Use a web browser to access the World Wide Web.Make basic changes to browser settings.1.3 Digital Communication Identify and describe various forms of electronic communication, including email, instant messaging, forums, text messaging, video chat, and social networking.Download and install smartphone apps.Send and receive SMS messages.Identify popular mobile operating systems.Explain the difference between WiFi and cellular-enabled Internet access.Identify options for transferring digital photos from your smartphone to your PC.Describe the basic features of popular web-based applications such as Gmail and Google Calendar.Use Microsoft Outlook to format, send, and receive email.Identify common rules of netiquette.1.4 Online Safety and Security Configure Windows Firewall for different networks.Evaluate email messages to determine if they represent a possible social engineering attack.Safely spend money on the Internet.Explain why it's important to back up data.Describe the basics of data encryption.Describe the importance of having a secure password.Configure a browser popup blocker.Adjust browser privacy settings.Define different kinds of malware and know how to avoid them.Clear a browser's cache.1.5 Evaluating Online Information Use advanced search to find information on the Internet.Understand the implications of copyright and intellectual property laws for Internet use.Define and describe the uses of webpages, blogs, wikis, and podcasts.Recognize primary, secondary, and tertiary sources, and describe the uses of each.Scrutinize a source for potential bias or false information.Know the difference between scholarly and consumer-level sources.Chapter 2: Computer Essentials 2.1 Computer Hardware 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.Evaluate whether a computer system measures up to a list of minimum requirements.Use the Settings app to view system information.Identify and state the purpose of common hardware components.2.2 System Software Identify and describe different types of system software.Identify common operating systems.Identify and describe components of the Windows 10 operating system.Change display settings in Windows.Use the Settings app to view system information.Configure a screen saver through the Settings app.Describe Windows printing features.Connect to a shared printer.Configure the default printer.Share a local printer with other users.Configure Windows Update settings.Back up and restore files.Recognize and use utility software.2.3 File Management 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.2.4 Application Software 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.Open and print a document from Microsoft Word.Describe the advantages and disadvantages of different software installation methods.Identify application software that facilitates collaboration, including:Discussion boardsScreen sharingCalendaringResource managementWebinarsCollaborative editing2.5 Networking and User Accounts Define and state some advantages of computer networking.Describe the relationship between ISPs and the Internet.Define the Internet and understand basic Internet protocols.Explain the role of hosts and servers on a network.Create a local account for a user who already has a Microsoft login.Create a non-Microsoft user account.Remove user accounts.Connect to a public WiFi network.Connect to a secure wireless network.2.6 Databases Identify and state the purposes of a relational database.Define basic relational database terminology including:FieldRecordPrimary keyForeign keyOne-to-many relationshipExplain what SQL is and interpret a basic SQL query.Define the term Big Data and describe its related challenges and opportunities.Use Microsoft Access to perform basic operations on database objects, including tables, forms, queries, and reports.2.7 Computer Programming Explain what computer programming is and why it is useful.Describe the difference between developing computer programs and using software packages.Name several programming languages.Analyze and understand pseudocode.Describe several careers in computer science.Identify and understand the purposes of HTML, CSS, and JavaScript in a web browser.Describe the relationship between computer programming and artificial intelligence.Explain the advantages of Object-Oriented Programming.Create a simple Microsoft Excel macro using Visual Basic for Applications (VBA).2.8 Information Systems Describe the components of an information system.Identify and describe the most important sectors of the ICT industry.Conduct online research on a career that interests you in information technology.Identify the traditional stages of the System Development Life Cycle (SDLC).Describe modern alternatives to a linear process of systems analysis and design.Describe several IT careers, including the following:Network ArchitectDatabase AdministratorProgrammerSupport SpecialistSecurity AnalystChapter 3: Common Office Features 3.1 Getting Started with Office Create a new blank file.Save a file to the local computer.Save a file remotely with OneDrive.Save in alternate file formats.Enable a downloaded file for editing.Open an existing file.Edit file properties.Collapse and expand the Ribbon.3.2 Customizing Views and Options Change document views.Use zoom.Customize the Quick Access Toolbar.Customize the Ribbon.Split the window.3.3 Printing Files Configure documents to print.Print sections of documents.Set print scaling.Change page setup options.Print individual Excel worksheets.Print handouts in PowerPoint.Configure PowerPoint to print in grayscale.Print speaker notes in PowerPoint.3.4 Navigating Files Search for text within a document.Insert hyperlinks.Create bookmarks.Use Go To.Find and Replace data.3.5 Working with Objects Insert textboxes.Insert images.Add borders, styles, and effects to objects.Change object colors.Modify object properties.Position objects.Modify shape backgrounds.Apply borders to shapes.Insert shapes.Create custom shapes.Apply styles to objects.Resize objects.Display gridlines.Chapter 4: Microsoft Word 4.2 Creating Documents and Using the Clipboard Create a new blank document.Open a downloaded document and enable editing.Print documents.Scroll through a document.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.Open a PDF for editing.Insert text from an external source.Reorganize the content in a document.Paste text from a website into a Word document.4.3 Modifying Fonts 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.4.4 Formatting Paragraphs 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.4.5 Formatting Pages 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.Modify hyphenation options.Add line numbers.Format a report as a draft.Format only part of a document into two columns.Insert manual page breaks where needed in a document.4.6 Editing Documents 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.4.7 Inserting Illustrations and Other Elements 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.Insert a cover page.Insert a screen shot and screen clipping.Insert text boxes.Insert Quick Parts.Use the Building Blocks Organizer.Create Custom Building Blocks.Remove picture backgrounds.Modify text wrap settings for visual appeal.Apply best practices in using graphics.4.8 Creating and Formatting Tables 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.Convert text to a table.Configure cell margins and spacing.Split tables.Configure a repeating row header.Align table data for better readability.Apply table styles that increase readability and visual appeal.4.9 Using Themes, Styles, and Templates 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.4.10 Managing References 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.Insert figure and table captions.Modify caption properties.Insert a table of contents.Cite sources for an academic paper using the MLA, Chicago, and APA citation styles.4.11 Managing Headers, Footers, and Sections 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.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.4.12 Using Office Collaboration Features Enable Track Changes.Accept and reject changes.Discard changes from specific users.Protect documents with passwords.Mark a document as final.Add and manage comments.Restrict permissions.Use Compare and Combine on different documents.Inspect a document for sharing.Remove personal metadata.Inspect a document for accessibility.Add alternative text for accessibility.Embed custom fonts into a document.4.13 Using Macros Record simple macros.Assign shortcut keys to macros.Manage macro security.Chapter 5: Microsoft Excel 5.2 Creating and Managing Workbooks Open a workbook.Create a new blank workbook.Create a new workbook using a template.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.Import data from various applications into Excel.5.3 Organizing and Entering Data 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.Hide and unhide worksheets.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.5.4 Changing Properties and Printing Worksheets 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.Add data validation to a worksheet.Limit cell input to a list.Add a custom input message to a cell.Customize the error alert for invalid data.Include relevant worksheet properties in a printout.Optimize the printing of a worksheet.5.5 Formatting Cells 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.Use Format Painter.Adjust columns to display both numeric and textual data properly.Format a range of cells as a worksheet title.5.6 Entering Simple Formulas 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 the RIGHT, LEFT, and MID functions.Use the CONCATENATE function.Use the UPPER and LOWER functions.Use the COUNTA and COUNTBLANK functions.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.Use Flash Fill.5.7 Using Advanced Functions Enter a function using the Insert Function box.Display and hide formulas.Enter a formula using absolute references.Enter a formula using relative references.Enter a formula using mixed references.Use the IF function.Use COUNTIF, SUMIF, and AVERAGEIF.Use functions with multiple arguments.Copy a formula with absolute, relative, or mixed references.Reference cells on other worksheets.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.5.8 Displaying Data in Charts 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.5.9 Organizing Data in Tables 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.Analyze data using sparklines.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.5.10 Summarizing Complex Data Create outlines.Collapse groups of data in outlines.Insert subtotals.Use the VLOOKUP function.Create PivotTables.Add fields to PivotTables.Calculate values in PivotTables.Add slicers to PivotTables.Create and use PivotCharts.Use Quick Analysis tools.Chapter 6: Microsoft PowerPoint 6.2 Creating and Managing Presentations 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.Create new slides.Hide and unhide slides.Add and remove sections in a presentation.Reorganize and modify an existing anize a long presentation into relevant sections.6.3 Formatting Textual Content 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.Format text in multiple columns.Use Autofit to shrink text on overflow.Divide content into multiple slides.Import Word document outlines.Insert slides from another presentation.Preserve presentation content.Use italics or a different font color to emphasize important content.6.4 Designing Slides 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.6.5 Using the Slide Master 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.Modify the handout and notes masters.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.6.6 Formatting SmartArt and Shapes 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.Add and remove SmartArt shapes.Change the order of SmartArt shapes.Change the color and layout of SmartArt.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.6.7 Formatting Tables and Charts Create new tables.Add and remove rows and columns.Apply table styles.Import tables from external sources.Modify chart styles and types.Insert charts.Add legends to charts.Customize chart parameters.Import charts from external sources.6.8 Formatting Pictures and Other Media 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.Trim timing on media clips.Package a presentation for CD.Link to external media.Apply color corrections to a media press media.Adjust media start and stop times.6.9 Applying Animations and Transitions 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.6.10 Delivering Presentations 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.Export presentations to other formats.Create custom slide shows.Rehearse slide show timing.Annotate slide shows.Record a slide show.Create a video from a slide show.Format and print handouts to help the audience retain important information.Rehearse presentations in the actual setting where they will be delivered.Chapter 7: Microsoft Access 7.2 Managing Databases 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.7.3 Designing and Creating Tables 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.7.4 Using Simple Queries 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.7.5 Creating Forms 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.7.6 Creating Reports 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.7.7 Surveying Advanced Access Features Create a database from a template.Import database objects.Create and modify navigation forms.Set a form as a startup pact, repair, back up, and encrypt a database.Recover data from a backup.Split a database.Save a database as a template.Export data to alternative formats.Use application parts.Hide and unhide table fields.Add total rows and table descriptions.Find and replace data.Sort table records.Add data validation rules to fields.Use input masks to ensure correct data entry.Change number formatting for fields.Print individual records from a table.Add a filter to a table.Create crosstab queries.Add parameters to query criteria.Create and run action queries, including delete, rename, and append queries.Use formulas to create calculated fields.Use conditional logic in queries.Set form control properties, such as margins and padding.Configure print settings.Insert backgrounds, headers, and footers into forms.Create and format a navigation form.Add a subform.Add report controls.Change the data source for a field in a report.Edit the tab index.Change the control source for a form.Sort a report.Format a report with multiple columns.Change report orientation.Chapter 8: Microsoft Outlook 8.2 Sending and Receiving Messages Compose and send an email.Mark a message as read or unread.Apply text formatting to an email.Apply themes and styles to an email.Use Forward, Reply, and Reply All.Use To, Cc, and Bcc.Create and use an email signature.Change default formatting options for messages.Add, open, and remove email attachments.Preview and save email attachments.Add hyperlinks to text.Insert an image into a message.Include a read receipt with an email.Add voting options to an email.Flag an outgoing email for follow up, importance, and sensitivity.8.3 Managing Messages Sort email messages.Create new email folders.Move messages into folders.Apply categories to emails.Flag received messages.Create and edit rules.Create and use Quick Steps.Redirect replies to another email address.Set up automatic replies.Recall a message.Configure AutoArchive.Customize junk mail options.Use the Clutter feature.Clean up and ignore conversations.Search and use Advanced Find.Create search folders.Import and export mail folders.Save an email to your hard drive.Delete an email message.Print an email.8.4 Working with the Calendar Share a calendar.Create and add a new calendar.Delete a calendar.Adjust viewing details for calendars.Modify calendar time zones.Set calendar work times.Display and manage multiple calendars.Manage calendar groups.Add appointments to a calendar.Set recurrence for a calendar item.Set calendar item importance.Forward a calendar item.Categorize calendar items.Change the free or busy status of a calendar item.Update individual or recurring calendar items.Create a new meeting.Configure reminders.Share meeting notes.Cancel a meeting.Respond to a meeting request.Use the Scheduling Assistant.Use Room Finder to set up a meeting location.Create a meeting from an email.Create a new task.Assign a task to another person.8.5 Managing Contacts and Groups Create a new contact.Share contacts.Edit contact information.Attach an image to a contact.Add tags to contacts.Distinguish between contacts and other users in the Address Book.Send a message to a contact group.Create a contact group.Add and remove members from a contact group.Delete contacts and contact groups.Update contacts within contact groups.Add notes to a contact group.Send emails to contact groups.Use the Tasks, Notes, and Folders views.Customize the navigation bar.Add and manage a new Outlook account.Delegate access to an Outlook account.Import contacts from external sources.Appendix B: Course Mapping to MOS Exam Objectives77-725 Microsoft Office Specialist Word Core 2016Objective Text: WordObjective NumberDesktop Pro Plus Section1.0 Create and Manage DocumentsCreate a document create a blank document1.1.13.1create a blank document using a template1.1.24.9open a PDF in Word for editing1.1.34.2insert text from a file or external source1.1.44.2Navigate through a documentsearch for text1.2.13.4insert hyperlinks1.2.23.4create bookmarks1.2.33.4move to a specific location or object in a document1.2.43.4Format a Document modify page setup1.3.14.5apply document themes1.3.24.9apply document style sets1.3.34.9insert headers and footers1.3.44.11insert page numbers1.3.54.11format page background elements1.3.64.5Customize Options and Views for Documentschange document views1.4.13.2customize views by using zoom settings1.4.23.2customize the Quick Access toolbar1.4.33.2split the window1.4.43.2add document properties1.4.53.1show or hide formatting symbols1.4.64.4Print and Save Documentsmodify print settings1.5.13.3save documents in alternative file formats1.5.23.1print all or part of a document1.5.33.3inspect a document for hidden properties or personal information1.5.44.12inspect a document for accessibility issues1.5.54.12inspect a document for compatibility issues1.5.64.122.0 Format Text, Paragraphs, and SectionsInsert Text and Paragraphsfind and replace text2.1.14.6cut, copy and paste text2.1.24.2replace text by using AutoCorrect2.1.34.6insert special characters2.1.44.7Format Text and Paragraphsapply font formatting2.2.14.3apply formatting by using Format Painter2.2.24.9set line and paragraph spacing and indentation2.2.34.4clear formatting2.2.44.4apply a text highlight color to text selections2.2.54.3apply built-in styles to text2.2.64.9change text to WordArt2.2.74.3Order and Group Text and Paragraphsformat text in multiple columns2.3.14.5insert page, section, or column breaks2.3.24.5 & 4.11change page setup options for a section2.3.34.113.0 Create Tables and ListsCreate a Tableconvert text to tables3.1.14.8convert tables to text3.1.24.8create a table by specifying rows and columns3.1.34.8apply table styles3.1.44.8Modify a Tablesort table data3.2.14.8configure cell margins and spacing3.2.24.8merge and split cells 3.2.34.8resize tables, rows, and columns3.2.44.8split tables3.2.54.8configure a repeating row header3.2.64.8Create and Modify a Listcreate a numbered or bulleted list3.3.14.4change bullet characters or number formats for a list level3.3.24.4define a custom bullet character or number format3.3.34.4increase or decrease list levels3.3.44.4restart or continue list numbering3.3.54.4set starting number value3.3.64.44.0 Create and Manage ReferencesCreate and Manage Reference Markersinsert footnotes and endnotes4.1.14.10modify footnote and endnote properties4.1.24.10create bibliography citation sources4.1.34.10modify bibliography citation sources4.1.44.10insert citations for bibliographies4.1.54.10insert figure and table captions4.1.64.10modify caption properties4.1.74.10Create and Manage Simple Referencesinsert a standard table of contents4.2.14.10update a table of contents4.2.24.10insert a cover page4.2.34.75.0 Insert and Format Graphic ElementsInsert Graphic Elementsinsert shapes5.1.14.7insert pictures5.1.24.7insert a screen shot or screen clipping5.1.34.7insert text boxes5.1.44.5 & 3.7Format Graphic Elementsapply artistic effects5.2.13.5apply picture effects5.2.23.5remove picture backgrounds5.2.34.7format objects5.2.43.5apply a picture style5.2.53.5 & 4.7wrap text around objects5.2.64.7position objects5.2.73.5add alternative text to objects for accessibility5.2.84.12Insert and Format SmartArt Graphicscreate a SmartArt graphic5.3.16.6format a SmartArt graphic5.3.26.6modify SmartArt graphic content5.3.36.677-727 Microsoft Office Specialist Excel 2016Objective Text: ExcelObjective NumberDesktop Pro Plus Section1.0 Manage Worksheets and WorkbooksCreate Worksheets and Workbookscreate a workbook1.1.13.1import data from a delimited text file1.1.25.2add a worksheet to an existing workbook1.1.35.2copy and move a worksheet1.1.45.2Navigate in Worksheets and Workbookssearch for data within a workbook1.2.13.4navigate to a named cell, range, or workbook element1.2.23.4insert and remove hyperlinks1.2.33.4Format Worksheets and Workbookschange worksheet tab color1.3.15.2rename a worksheet1.3.25.2change worksheet order1.3.35.2modify page setup1.3.45.4insert and delete columns or rows1.3.55.3change workbook themes1.3.65.2adjust row height and column width1.3.75.5insert headers and footers1.3.85.4Customize Options and Views for Worksheets and Workbookshide or unhide worksheets1.4.15.3hide or unhide columns and rows1.4.25.3customize the Quick Access toolbar1.4.33.2change workbook views1.4.43.2change window views1.4.53.2 & 5.3modify document properties1.4.63.1change magnification by using zoom tools1.4.73.2display formulas1.4.85.7Configure Worksheets and Workbooks for Distributionset a print area1.5.15.4save workbooks in alternative file formats1.5.25.2print all or part of a workbook1.5.33.3set print scaling1.5.43.3display repeating row and column titles on multipage worksheets1.5.55.4inspect a workbook for hidden properties or personal information1.5.64.12inspect a workbook for accessibility issues1.5.74.12inspect a workbook for compatibility issues1.5.84.122.0 Manage Data Cells and RangesInsert Data in Cells and Rangesreplace data2.1.13.4cut, copy, or paste data2.1.25.3paste data by using special paste options2.1.35.3fill cells by using Auto Fill2.1.45.6insert and delete cells2.1.55.3Format Cells and Rangesmerge cells2.2.15.5modify cell alignment and indentation2.2.25.5format cells by using Format Painter2.2.35.5wrap text within cells2.2.45.5apply number formats2.2.55.5apply cell formats2.2.65.5apply cell styles2.2.75.5Summarize and Organize Datainsert sparklines2.3.15.9outline data2.3.25.10insert subtotals2.3.35.10apply conditional formatting2.3.45.93.0 Create TablesCreate and Manage Tablescreate an Excel table from a cell range3.1.15.9convert a table to a cell range3.1.25.9add or remove table rows and columns3.1.35.9Manage Table Styles and Optionsapply styles to tables3.2.15.9configure table style options3.2.25.9insert total rows3.2.35.9Filter and Sort a Tablefilter records3.3.15.9sort data by multiple columns3.3.25.9change sort order3.3.35.9remove duplicate records3.3.45.94.0 Perform Operations with Formulas and FunctionsSummarize Data by using Functionsinsert references4.1.15.7perform calculations by using the SUM function4.1.25.6perform calculations by using MIN and MAX functions4.1.35.6perform calculations by using the COUNT function4.1.45.6perform calculations by using the AVERAGE function4.1.55.6Perform Conditional Operations by using Functionsperform logical operations by using the IF function4.2.15.7perform logical operations by using the SUMIF function4.2.25.7perform logical operations by using the AVERAGEIF function4.2.35.7perform statistical operations by using the COUNTIF function4.2.45.7Format and Modify Text by using Functionsformat text by using RIGHT, LEFT, and MID functions4.3.15.6format text by using UPPER, LOWER, and PROPER functions4.3.25.6format text by using the CONCATENATE function4.3.35.65.0 Create Charts and ObjectsCreate Chartscreate a new chart5.1.15.8add additional data series5.1.25.8switch between rows and columns in source data5.1.35.8analyze data by using Quick Analysis5.1.45.10Format Chartsresize charts5.2.15.8add and modify chart elements5.2.25.8apply chart layouts and styles5.2.35.8move charts to a chart sheet5.2.45.8Insert and Format Objectsinsert text boxes and shapes5.3.13.5insert images5.3.23.5modify object properties5.3.33.5add alternative text to objects for accessibility5.3.44.1277-729 Microsoft Office Specialist PowerPoint 2016Objective Text: PowerPointObjective NumberDesktop Pro Plus Section1.0 Create and Manage PresentationsCreate a Presentationcreate a new presentation1.1.13.1create a presentation based on a template1.1.26.2import Word document outlines1.1.36.3Insert and Format Slidesinsert specific slide layouts1.2.16.4duplicate existing slides1.2.26.2hide and unhide slides1.2.36.2delete slides1.2.46.2apply a different slide layout1.2.56.4modify individual slide backgrounds1.2.66.4insert slide headers, footers, and page numbers1.2.76.5Modify Slides, Handouts, and Noteschange the slide master theme or background1.3.16.5modify slide master content1.3.26.5create a slide layout1.3.36.5modify a slide layout1.3.46.5modify the handout master1.3.56.5modify the notes master1.3.66.5Order and Group Slidescreate sections 1.4.16.2modify slide order1.4.26.2rename sections1.4.36.2Change Presentation Options and Viewschange slide size1.5.16.4change views of a presentation1.5.23.2set file properties1.5.33.1Configure a Presentation for Printprint all or part of a presentation1.6.13.3print notes pages1.6.23.3print handouts1.6.33.3print in color, grayscale, or black and white1.6.43.3Configure and Present a Slide Showcreate custom slide shows1.7.16.10configure slide show options1.7.26.10rehearse slide show timing1.7.36.10present a slide show by using Presenter View1.7.46.102.0 Insert and Format Text, Shapes, and ImagesInsert and Format Textinsert text on a slide2.1.16.3apply formatting and styles to text2.1.26.3apply WordArt styles to text2.1.36.6format text in multiple columns2.1.46.3create bulleted and numbered lists2.1.56.3insert hyperlinks2.1.66.8Insert and Format Shapes and Text Boxesinsert or replace shapes2.2.13.5insert text boxes2.2.23.5resize shapes and text boxes2.2.33.5format shapes and text boxes2.2.43.5apply styles to shapes and text boxes2.2.53.5Insert and Format Imagesinsert images2.3.13.5resize and crop images2.3.26.8apply styles and effects2.3.36.8Order and Group Objectsorder objects2.4.16.6align objects2.4.26.6group objects2.4.36.6display alignment tools2.4.43.53.0 Insert Tables, Charts, SmartArt, and MediaInsert and Format Tablescreate a table3.1.16.7insert and delete table rows and columns3.1.26.7apply table styles3.1.36.7import a table3.1.46.7Insert and Format Chartscreate a chart 3.2.16.7import a chart3.2.26.7change the Chart Type3.2.36.7add a legend to a chart3.2.46.7change the chart style of a chart3.2.56.7Insert and Format SmartArt graphicscreate SmartArt graphics3.3.16.6convert lists to SmartArt graphics3.3.26.6add shapes to SmartArt graphics3.3.36.6reorder shapes in SmartArt graphics3.3.46.6change the color of SmartArt graphics3.3.56.6Insert and Manage Mediainsert audio and video clips3.4.16.8configure media playback options3.4.26.8adjust media window size3.4.36.8set the video start and stop time3.4.46.8set media timing options3.4.56.84.0 Apply Transitions and AnimationsApply Slide Transitionsinsert slide transitions4.1.16.9set transition effect options4.1.26.9Animate Slide Contentapply animations to objects4.2.16.9apply animations to text4.2.26.9set animation effect options4.2.36.9set animation paths4.2.46.9Set Timing for Transitions and Animationsset transition effect duration4.3.16.9configure transition start and finish options4.3.26.9reorder animations on a slide4.3.36.95.0 Manage Multiple PresentationsMerge Content from Multiple Presentationsinsert slides from another presentation5.1.16.3compare two presentations5.1.24.12insert comments5.1.34.12review comments5.1.44.12Finalize Presentationsprotect a presentation5.2.14.12inspect a presentation5.2.24.12proof a presentation5.2.36.10preserve presentation content5.2.44.12, 6.3 & 6.8export presentations to other formats5.2.56.8 & 6.1077-730 Microsoft Office Specialist Access 2016Objective Text: AccessObjective NumberDesktop Pro Plus Section?1.0 Create and Manage a DatabaseCreate and Modify Databasescreate a blank desktop database1.1.17.2create a database from a template1.1.27.7create a database by using import objects or data from other sources1.1.37.7delete database objects1.1.47.2Manage Relationships and Keyscreate and modify relationships1.2.17.3set the primary key1.2.27.3enforce referential integrity1.2.37.3set foreign keys1.2.47.3view relationships1.2.57.3Navigate through a Databasenavigate specific records1.3.17.2create and modify a navigation form1.3.27.7set a form as the startup option1.3.37.7display objects in the Navigation Pane1.3.47.2change views of objects1.3.57.3Protect and Maintain Databasescompact a database1.4.17.7repair a database1.4.27.7back up a database1.4.37.7split a database1.4.47.7encrypt a database with a password1.4.57.7recover data from backup1.4.67.7Print and Export Dataprint reports1.5.17.2print records1.5.27.7save a databases as a template1.5.37.7export objects to alternative formats 1.5.47.7?2.0 Build Tables?Create Tablescreate a table2.1.17.3import data into tables2.1.27.3create linked tables from external sources2.1.37.7import tables from other databases2.1.47.7create a table from a template with application parts2.1.57.7Manage Tableshide fields in tables2.2.17.7add total rows2.2.27.7add table descriptions2.2.37.7rename tables2.2.47.3Manage Records in Tablesupdate records2.3.17.2add records2.3.27.2delete records2.3.37.2append records from external data2.3.47.2find and replace data2.3.57.7sort records2.3.67.7filter records2.3.77.7Create and Modify Fieldsadd fields to tables2.4.17.3add validation rules to fields2.4.27.7change field captions2.4.37.3change field sizes2.4.47.3change field data types2.4.57.3configure fields to auto-increment2.4.67.3set default values2.4.77.3using input masks2.4.87.7delete fields2.4.97.3?3.0 Create Queries?Create a Queryrun a query3.1.17.4create a crosstab query3.1.27.7create a parameter query3.1.37.7create an action query3.1.47.7create a multi-table query3.1.57.4save a query3.1.67.4Modify a Queryrename a query3.2.17.2add fields3.2.27.4remove fields3.2.37.4hide fields3.2.47.4sort data within queries3.2.57.4format fields within queries3.2.67.4Create Calculated Fields and Grouping within Queriesadd calculated fields3.3.17.7set filtering criteria3.3.27.4group and summarize data3.3.37.4group data by using comparison operators3.3.47.4group data by using arithmetic and logical operators3.3.57.74.0 Create Forms?Create a Formcreate a form4.1.17.5create a form from a template with application parts4.1.27.7save a form4.1.37.5Configure Form Controlsmove form controls4.2.17.5add form controls4.2.27.5modify data sources4.2.37.7remove form controls4.2.47.5set form control properties4.2.57.7manage labels4.2.67.5add sub-forms4.2.77.7Format a Formmodify tab order 4.3.17.7configure print settings4.3.27.7sort records by form field4.3.37.7apply a theme4.3.47.5control form positioning4.3.57.7insert backgrounds4.3.67.7insert headers and footers4.3.77.7insert images4.3.87.6?5.0 Create Reports?Create a Reportcreate a report based on the query or table5.1.17.6create a report in Design view5.1.27.6create a report by using a wizard5.1.37.6Configure Report Controlsgroup and sort fields 5.2.17.6 & 7.7modify data sources5.2.27.7add report controls5.2.37.7add and modify labels5.2.47.6Format a Reportformat a report into multiple columns5.3.17.7add calculated fields5.3.27.6control report positioning5.3.37.7format report elements5.3.47.6change report orientation5.3.57.7insert header and footer information5.3.67.7insert images5.3.77.6apply a theme5.3.87.677-731 Microsoft Office Specialist Outlook 2016Objective Text: OutlookObjective NumberDesktop Pro Plus Section?1.0 Manage the Outlook Environment for ProductivityCustomize Settingscustomize reply messages1.1.18.2change text formats for all outgoing messages1.1.28.2customize the Navigation Pane1.1.38.5configure views1.1.48.5manage multiple accounts1.1.58.5add an account1.1.68.5Print and Save Informationprint message, calendar, contact, or task information1.2.18.3save message attachments1.2.28.2preview attachments1.2.38.2save messages in alternate formats1.2.48.3export messages to a data file1.2.58.3Perform Search Operations in Outlookcreate new search folders1.3.18.3search for items in messages, tasks, contacts, or calendars1.3.28.3search by using advanced find1.3.38.3search by folder1.3.48.3?2.0 Manage Messages?Configure Mail Settingsset fonts for new messages and responses2.1.18.2create, assign, and modify signatures2.1.28.2create and manage rules2.1.38.3create automatic replies2.1.48.3create messages by using Quick Parts2.1.54.7configure junk e-mail and clutter settings2.1.68.3Create Messagescreate a message2.2.18.2add or remove message attachments 2.2.28.2add cc and bcc to messages2.2.38.2add tracking and voting options2.2.48.2forward and reply to messages2.2.58.2request a delivery or read receipt2.2.68.2redirect replies2.2.78.3flag outgoing messages for follow up, importance, and sensitivity2.2.88.2recall a message2.2.98.3Format a Messageformat text2.3.18.2insert hyperlinks2.3.28.2apply themes and styles2.3.38.2insert images2.3.48.2add a signature to specific messages2.3.58.2Organize and Manage Messagessort messages2.4.18.3move messages between folders2.4.28.3add new local folders2.4.38.3apply categories2.4.48.3clean up messages2.4.58.3mark a message as read or unread2.4.68.1flag received messages2.4.78.3ignore messages2.4.88.3sort messages by conversation2.4.98.3delete messages2.4.108.3automate repetitive tasks by using Quick Steps2.4.118.3configure basic AutoArchive settings2.4.128.3Delegate access2.4.138.5?3.0 Manage Schedules?Create and Manage Calendarscreate and add calendars3.1.18.4adjust viewing details for calendars3.1.28.4modify calendar time zones3.1.38.4delete calendars3.1.48.4set calendar work times3.1.58.4manage multiple calendars3.1.68.4manage calendar groups3.1.78.4display multiple calendars3.1.88.4share calendars3.1.98.4Create Appointments, Meetings, and Eventscreate calendar items3.2.18.4create recurring calendar items3.2.28.4cancel calendar items3.2.38.4create calendar items from messages3.2.48.4set calendar item times3.2.58.4setup meetings by using the scheduling assistant3.2.68.4set free or busy status for calendar items3.2.78.4schedule resources3.2.88.4Setup meeting location by using Room Finder3.2.98.4Organize and Manage Appointments, Meetings, and Eventsset calendar item importance3.3.18.4forward calendar items3.3.28.4configure reminders3.3.38.4add participants3.3.48.4respond to invitations3.3.58.4update individual or recurring calendar items3.3.68.4share meeting notes3.3.78.4categorize calendar items3.3.88.4Create and Manage Notes and Taskscreate and manage tasks 3.4.18.4create and organizing notes3.4.28.54.0 Manage Contacts and Groups?Create and Manage Contactscreate a new contact4.1.18.5delete contacts4.1.28.5import contacts from external sources4.1.38.5edit contact information4.1.48.5attach an image to a contact4.1.58.5add tags to contacts4.1.68.5share contacts4.1.78.5create and manage address books4.1.88.5Create and Manage Contact Groupcreate new contact groups4.2.18.5add contacts to existing contact groups4.2.28.5add notes to a contact group4.2.38.5update contacts within contact groups4.2.48.5delete contact groups4.2.58.5delete contact group members4.2.68.5Appendix C: Approximate Time for the CourseThe total time for the LabSim for TestOut Desktop Pro Plus course is approximately 83 hours and 56 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)Section exams (1 minute per question)End-of-Chaper exams (60 minutes per exam)Additionally, there are approximately another 13 hours of Practice Test material at the end of the course.The breakdown for this course is as follows:ModuleSectionsTimeVideosLabsTextExams1.0: Online Essentials1.1: The Information Age8833045101.2: The Internet and Social Media101262045101.3: Digital Communication73182025101.4: Online Safety and Security143387025101.5: Evaluating Online Information451502010End-of-Chapter Exam6060*Total8:302:101:502:401:502.0: Computer Essentials2.1: Computer Hardware129296030102.2: System Software120206030102.3: File Management109196020102.4: Application Software687401562.5: Networking and User Accounts8418402062.6: Databases5417201072.7: Computer Programming531902592.8: Information Systems45150255End-of-Chapter Exam6060*Total12:022:244:402:552:033.0: Common Office Features3.1: Getting Started with Office7222401003.2: Customizing Views and Options52740503.3: Printing Files50540503.4: Navigating Files54940503.5: Working with Objects5494050End-of-Chapter Exam6060*Total5:420:523:200:301:004.0: Microsoft Word4.1: Introduction to Word830504.2: Creating Documents and Using the Clipboard8919601004.3: Modifying Fonts788601004.4: Formatting Paragraphs8616601004.5: Formatting Pages799601004.6: Editing Documents8010601004.7: Inserting Illustrations and Other Elements8111601004.8: Creating and Formatting Tables8212601004.9: Using Themes, Styles, and Templates8111601004.10: Managing References8515601004.11: Managing Headers, Footers, and Sections8717601004.12: Using Office Collaboration Features8313601004.13: Using Macros116050End-of-Chapter Exam6060*Total16:302:3011:002:001:005.0: Microsoft Excel5.1: Introduction to Excel830505.2: Creating and Managing Workbooks8010601005.3: Organizing and Entering Data8010601005.4: Changing Properties and Printing Worksheets8010601005.5: Formatting Cells8313601005.6: Entering Simple Formulas8515601005.7: Using Advanced Functions8818601005.8: Displaying Data in Charts766601005.9: Organizing Data in Tables788601005.10: Summarizing Complex Data841460100End-of-Chapter Exam6060*Total13:221:479:001:351:006.0: Microsoft PowerPoint6.1: Introduction to PowerPoint1270506.2: Creating and Managing Presentations755601006.3: Formatting Textual Content8111601006.4: Designing Slides766601006.5: Using the Slide Master777601006.6: Formatting SmartArt and Shapes777601006.7: Formatting Tables and Charts777601006.8: Formatting Pictures and Other Media799601006.9: Applying Animations and Transitions777601006.10: Delivering Presentations811160100End-of-Chapter Exam6060*Total12:521:179:001:351:007.0: Microsoft Access7.1: Introduction to Access940507.2: Managing Databases566401007.3: Designing and Creating Tables8515601007.4: Using Simple Queries788601007.5: Creating Forms766601007.6: Creating Reports8010601007.7: Surveying Advanced Access Features43330100End-of-Chapter Exam6060*Total8:071:224:401:051:008.0: Microsoft Outlook8.1: Introduction to Outlook1160508.2: Sending and Receiving Messages8515601008.3: Managing Messages9020601008.4: Working with the Calendar8313601008.5: Managing Contacts and Groups821260100End-of-Chapter Exam6060*Total6:511:064:000:451:00Total Course Time 83:56* Each chapter of the course includes a 60-minute final exam that is hidden from students until scheduled by the instructor.The TestOut Desktop Pro Plus course includes practice tests for students who are preparing for either the Desktop Pro Certification exam or the Microsoft Office Specialist exams. The breakdown for the practice exams is as follows:Desktop Pro Certification Practice ExamsA.0: Desktop Pro Practice ExamsNumber of QuestionsTimeA.2: Desktop Pro Domain 1: Microsoft Word122:00A.3: Desktop Pro Domain 2: Microsoft Excel122:00A.4: Desktop Pro Domain 3: Microsoft PowerPoint102:00A.5: Desktop Pro Certification Practice Exam132:00Total478:00MOS 2016 Certification Practice ExamsB.0: MOS 2016 Practice ExamsNumber of QuestionsTimeB.2.1: Microsoft Word Practice – Form A70:50B.2.2: Microsoft Word Practice – Form B70:50B.3.1: Microsoft Excel Practice – Form A70:50B.3.2: Microsoft Excel Practice – Form B70:50B.4.1: Microsoft PowerPoint Practice – Form A70:50B.4.2: Microsoft PowerPoint Practice – Form B70:50Total42 (30 Unique)5:00Total Practice Exam Time 13:00 ................
................

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

Google Online Preview   Download