table of contents - testout · web viewsummary as you study this section, answer the following...

TestOut Desktop Pro Plus - English 5.0.x

LESSON PLAN

Revised 2018-09-27

2

Table of Contents

Section 0.0: Getting Started Information.......................................................................................4Online EssentialsSection 1.1: The Information Age..................................................................................................5Section 1.2: The Internet and Social Media...................................................................................7Section 1.3: Digital Communication...............................................................................................9Section 1.4: Online Safety and Security......................................................................................11Section 1.5: Evaluating Online Information.................................................................................13Computer EssentialsSection 2.1: Computer Hardware................................................................................................14Section 2.2: System Software.....................................................................................................16Section 2.3: File Management.....................................................................................................18Section 2.4: Application Software................................................................................................20Section 2.5: Networking and User Accounts...............................................................................22Section 2.6: Databases...............................................................................................................24Section 2.7: Computer Programming..........................................................................................26Section 2.8: Information Systems................................................................................................28Common Office FeaturesSection 3.1: Getting Started with Office.......................................................................................30Section 3.2: Customizing Views and Options..............................................................................31Section 3.3: Printing Files............................................................................................................32Section 3.4: Navigating Files.......................................................................................................33Section 3.5: Working with Objects...............................................................................................34Microsoft WordSection 4.1: Introduction to Word................................................................................................35Section 4.2: Creating Documents and Using the Clipboard........................................................36Section 4.3: Modifying Fonts.......................................................................................................38Section 4.4: Formatting Paragraphs............................................................................................40Section 4.5: Formatting Pages....................................................................................................42Section 4.6: Editing Documents..................................................................................................44Section 4.7: Inserting Illustrations and Other Elements...............................................................46Section 4.8: Creating and Formatting Tables..............................................................................48Section 4.9: Using Themes, Styles, and Templates....................................................................50Section 4.10: Managing References...........................................................................................51Section 4.11: Managing Headers, Footers, and Sections...........................................................53Section 4.12: Using Office Collaboration Features......................................................................55Section 4.13: Using Macros.........................................................................................................57Microsoft ExcelSection 5.1: Introduction to Excel................................................................................................58Section 5.2: Creating and Managing Workbooks........................................................................59Section 5.3: Organizing and Entering Data.................................................................................61Section 5.4: Changing Properties and Printing Worksheets........................................................60Section 5.5: Formatting Cells......................................................................................................62Section 5.6: Entering Simple Formulas.......................................................................................67Section 5.7: Using Advanced Functions......................................................................................69Section 5.8: Displaying Data in Charts........................................................................................71Copyright © 2018 TestOut Corporation. CompTIA, A+, Network+, Security+, Linux+ and related trademarks and trade names are the trademarks of CompTIA. Microsoft, MCITP, MSCA, MCTS, Windows and Office are the trademarks of Microsoft. Cisco and CCNA are the trademarks of Cisco. (ISC)2 and SSCP are the trademarks of (ISC)2. TestOut has no affiliation with any of these companies and the products and services advertised herein are not endorsed by any of them.

3

Section 5.9: Organizing Data in Tables.......................................................................................70Section 5.10: Summarizing Complex Data..................................................................................72Microsoft PowerPointSection 6.1: Introduction to PowerPoint......................................................................................76Section 6.2: Creating and Managing Presentations....................................................................77Section 6.3: Formatting Textual Content.....................................................................................78Section 6.4: Designing Slides......................................................................................................80Section 6.5: Using the Slide Master............................................................................................82Section 6.6: Formatting SmartArt and Shapes............................................................................80Section 6.7: Formatting Tables and Charts.................................................................................82Section 6.8: Formatting Pictures and Other Media......................................................................87Section 6.9: Applying Animations and Transitions......................................................................89Section 6.10: Delivering Presentations........................................................................................90Microsoft AccessSection 7.1: Introduction to Access.............................................................................................92Section 7.2: Managing Databases...............................................................................................93Section 7.3: Designing and Creating Tables...............................................................................90Section 7.4: Using Simple Queries..............................................................................................91Section 7.5: Creating Forms........................................................................................................92Section 7.6: Creating Reports.....................................................................................................98Section 7.7: Surveying Advanced Access Features....................................................................99Microsoft OutlookSection 8.1: Introduction to Outlook..........................................................................................101Section 8.2: Sending and Receiving Messages........................................................................102Section 8.3: Managing Messages.............................................................................................104Section 8.4: Working with the Calendar....................................................................................101Section 8.5: Managing Contacts and Groups............................................................................108Desktop Pro Practice ExamsDesktop Pro Certification Practice Exams.................................................................................110MOS 2016 Practice ExamsSection B.1: Preparing for MOS Certification............................................................................111Section B.2: Microsoft Word 2016 Core (77-725)......................................................................113Section B.3: Microsoft Excel 2016 Core (77-727).....................................................................115Section B.4: Microsoft PowerPoint 2016 (77-729).....................................................................117AppendicesAppendix A: Course Objectives.................................................................................................119Appendix B: Course Mapping to MOS Exam Objectives...........................................................142Appendix C: Approximate Time for the Course.........................................................................154

Copyright © 2018 TestOut Corporation. CompTIA, A+, Network+, Security+, Linux+ and related trademarks and trade names are the trademarks of CompTIA. Microsoft, MCITP, MSCA, MCTS, Windows and Office are the trademarks of Microsoft. Cisco and CCNA are the trademarks of Cisco. (ISC)2 and SSCP are the trademarks of (ISC)2. TestOut has no affiliation with any of these companies and the products and services advertised herein are not endorsed by any of them.

4

0.0: Getting Started Information

Summary

Video/Demo Time0.1 Video: Introduction to Desktop Pro Plus 7:04

Total Video Time 7:04

Fact 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 Labs

Total TimeAbout 38 minutes


5

1.1: The Information Age

Summary

As 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 color. Compare common image file types. Describe ethical considerations related to evolving forms of technology.

Video/Demo Time1.1.1 Introduction to Desktop Computer Systems 4:491.1.3 A Brief History of Computing 3:401.1.5 The Binary Number System 2:261.1.7 Bits & Bytes 3:441.1.9 Digital Sound & Video 5:071.1.11 Digital Images 3:571.1.13 File Compression 5:291.1.15 Technology and Ethics 3:39


Fact 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 Facts


6

1.1.14 File Compression Facts1.1.16 Technology and Ethics Facts1.1.17 Activity: Compare Digital Media

Number of Exam Questions10 questions



7

1.2: The Internet and Social Media

Summary


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/Demo Time1.2.1 The Web and Other Internet Technologies 4:471.2.3 Using a Web Browser 4:501.2.4 Web Browser Troubleshooting 3:561.2.10 Social Media 4:411.2.12 Cloud Computing 4:571.2.14 Online Streaming 2:28


Lab/Activity1.2.16 Skills Lab: Web Browsing with Internet Explorer

Fact Sheets1.2.2 Web and Internet Facts


8

1.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 Facts




9

1.3: Digital Communication

Summary


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/Demo Time1.3.1 Digital Communication 3:201.3.5 Introduction to Outlook 2:051.3.6 Checking Your Email 2:581.3.7 Formatting and Sending Messages 2:481.3.8 Email Etiquette 3:111.3.9 Attachments and Hyperlinks 2:52


Lab/Activity1.3.12 Skills Lab: Microsoft Outlook Email

Fact Sheets1.3.2 Digital Communication Facts1.3.3 Smartphone Facts1.3.4 Gmail and Google Calendar1.3.10 Outlook Facts1.3.11 Rules of Netiquette


10




11

1.4: Online Safety and Security

Summary


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/Demo Time1.4.1 Computer Security Risks 4:471.4.3 Windows Firewall 5:181.4.4 Malware Protection on Windows 4:011.4.6 Web Browsers and Email 7:301.4.7 Internet Safety and Security 7:581.4.9 Ecommerce Safeguards 4:531.4.11 Encryption and Authentication 3:32


Lab/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 Blocker

Fact SheetsCopyright © 2018 TestOut Corporation. CompTIA, A+, Network+, Security+, Linux+ and related trademarks and trade names are the trademarks of CompTIA. Microsoft, MCITP, MSCA, MCTS, Windows and Office are the trademarks of Microsoft. Cisco and CCNA are the trademarks of Cisco. (ISC)2 and SSCP are the trademarks of (ISC)2. TestOut has no affiliation with any of these companies and the products and services advertised herein are not endorsed by any of them.

12

1.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 Facts




13

1.5: Evaluating Online Information

Summary


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/Demo Time1.5.1 Online Searches 4:141.5.3 Copyright and Intellectual Property 5:141.5.5 Online Academic Research 5:13


Fact Sheets1.5.2 Online Searching Facts1.5.4 Copyright Facts1.5.6 Online Academic Research Facts1.5.7 Activity: Identify Sources




14

2.1: Computer Hardware

Summary


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/Demo Time2.1.1 Desktop and Mobile Devices 4:062.1.3 PC Hardware Components 5:232.1.5 PC Ports and Connectors 3:292.1.7 Peripheral Devices 4:472.1.9 Printers 2:182.1.11 Checking System Requirements 3:242.1.13 Using the Hardware Simulator 5:23


Lab/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 Printer

Fact Sheets2.1.2 Desktop vs. Mobile Devices2.1.4 PC Hardware Facts


15

2.1.6 PC Port and Connector Facts2.1.8 Peripheral Device Facts2.1.10 Printer Facts2.1.12 System Requirement Facts




16

2.2: System Software

Summary


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/Demo Time2.2.1 System Software 3:012.2.3 Operating System Functions 1:562.2.5 The Windows 10 Operating System 3:532.2.7 Windows Settings 2:572.2.9 Windows Printing Features 4:292.2.11 Windows Update 2:45


Lab/Activity2.2.13 Skills Lab: Explore Windows 10 Features2.2.14 Applied Lab: Change Display Settings2.2.15 Applied Lab: Connect to a Printer


17

2.2.16 Applied Lab: Share a Printer2.2.17 Applied Lab: Configure Windows Update

Fact 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 Facts




18

2.3: File Management

Summary


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/Demo Time2.3.1 Storage Devices 4:072.3.3 Windows File Management 6:052.3.5 Shared Storage 3:102.3.7 Cloud Storage 4:41


Lab/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 Storage

Fact Sheets2.3.2 File Storage Options2.3.4 Windows File Management Facts2.3.6 Shared Storage Facts2.3.8 Windows Cloud Storage Facts

Number of Exam Questions


19

10 questions



20

2.4: Application Software

Summary


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:

o Discussion boardso Screen sharingo Calendaringo Resource managemento Webinarso Collaborative editing

Video/Demo Time2.4.1 Desktop Applications 3:372.4.3 Collaboration Tools 3:06


Lab/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 Word

Fact Sheets2.4.2 Desktop Application Facts2.4.4 Collaboration Tool Facts2.4.5 Installing Applications


21




22

2.5: Networking and User Accounts

Summary


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/Demo Time2.5.1 Wired and Wireless Networks 3:122.5.3 The Internet 3:182.5.4 Internet Protocols 5:322.5.6 Network Servers 2:092.5.8 Windows User Accounts 3:08


Lab/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 Network

Fact Sheets2.5.2 Networking Facts2.5.5 Internet Protocol Facts2.5.7 Network Server Facts2.5.9 Windows User Account Facts


23




24

2.6: Databases

Summary


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:

o Fieldo Recordo Primary keyo Foreign keyo One-to-many relationship

Explain 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/Demo Time2.6.1 Introduction to Relational Databases 3:332.6.2 Database Terminology 2:172.6.3 Tour of Access 3:352.6.4 SQL 3:122.6.6 Big Data 4:22


Lab/Activity2.6.8 Skills Lab: Microsoft Access Databases

Fact Sheets2.6.5 Database Terms2.6.7 Big Data Facts



25



26

2.7: Computer Programming

Summary


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/Demo Time2.7.1 Basic Programming Concepts 3:352.7.2 HTML, CSS, and JavaScript 5:442.7.3 Object-Oriented Programming 3:202.7.6 Careers in Computer Programming 2:162.7.8 Artificial Intelligence 3:41


Fact 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 Assignment



27



28

2.8: Information Systems

Summary


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:

o Network Architecto Database Administratoro Programmero Support Specialisto Security Analyst

Video/Demo Time2.8.1 Introduction to Information Systems 3:152.8.3 Systems Analysis & Design 5:012.8.5 The ICT Industry 2:402.8.7 Information Technology Careers 3:33


Fact 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 Exploration


Total TimeCopyright © 2018 TestOut Corporation. CompTIA, A+, Network+, Security+, Linux+ and related trademarks and trade names are the trademarks of CompTIA. Microsoft, MCITP, MSCA, MCTS, Windows and Office are the trademarks of Microsoft. Cisco and CCNA are the trademarks of Cisco. (ISC)2 and SSCP are the trademarks of (ISC)2. TestOut has no affiliation with any of these companies and the products and services advertised herein are not endorsed by any of them.

29

About 45 minutes


30

3.1: Getting Started with Office

Summary


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/Demo Time3.1.1 Introduction to Office Applications 2:233.1.2 Learning Office Applications 4:243.1.3 The Ribbon 3:013.1.4 Beyond the Ribbon 4:183.1.5 Backstage View Options 3:383.1.6 Lab Types 4:30


Lab/Activity3.1.9 Skills Lab: Get Started with Office3.1.10 Challenge Lab: Get Started with Office

Fact Sheets3.1.7 Common Office Application Features3.1.8 Desktop vs. Web Applications



31

3.2: Customizing Views and Options

Summary


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/Demo Time3.2.1 Document Views 3:233.2.2 Customizing Toolbars and Ribbons 3:20


Lab/Activity3.2.4 Skills Lab: Customize Views and Options3.2.5 Challenge Lab: Customize Views and Options

Fact Sheets3.2.3 Customization Facts



32

3.3: Printing Files

Summary


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/Demo Time3.3.1 Printing Options in Office Applications 4:37


Lab/Activity3.3.3 Skills Lab: Print Files3.3.4 Challenge Lab: Print Files

Fact Sheets3.3.2 Office Printing Facts



33

3.4: Navigating Files

Summary


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/Demo Time3.4.1 Navigating Through a Word Document 4:243.4.2 Navigating Through an Excel Workbook 4:09


Lab/Activity3.4.4 Skills Lab: Navigate Files3.4.5 Challenge Lab: Navigate Files

Fact Sheets3.4.3 Navigation Facts



34

3.5: Working with Objects

Summary


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/Demo Time3.5.1 Formatting Images 4:493.5.2 Formatting Shapes 3:58


Lab/Activity3.5.4 Skills Lab: Work with Objects3.5.5 Challenge Lab: Work with Objects

Fact Sheets3.5.3 Object Formatting Facts



35

4.1: Introduction to Word

Summary

As 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/Demo Time4.1.1 Introduction to Word 2:19


Fact Sheets4.1.2 Word Tasks Overview



36

4.2: Creating Documents and Using the Clipboard

Summary


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/Demo Time4.2.1 Text Selection 3:084.2.2 The Clipboard 4:154.2.3 Document File Formats 3:264.2.4 Word Printing Tips 3:474.2.5 Text Importing 3:30


Lab/Activity4.2.7 Skills Lab: Create Documents4.2.8 Challenge Lab: Create Documents4.2.10 Applied Lab: Prepare a Business Memo


37

4.2.11 Applied Lab: Reorganize Class Notes

Fact Sheets4.2.6 Document Creation Facts4.2.9 Document Creation Tips



38

4.3: Modifying Fonts

Summary


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/Demo Time4.3.1 Font Changes 3:564.3.2 Font Choices 3:53


Lab/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 Worksheet

Fact Sheets4.3.3 Font Facts4.3.6 Font Tips

Total Time


39

About 78 minutes


40

4.4: Formatting Paragraphs

Summary


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/Demo Time4.4.1 Paragraph and Line Spacing 4:134.4.2 Indentation and Tabs 4:274.4.3 Bulleted and Numbered Lists 3:414.4.4 Paragraph Borders and Shading 3:15


Lab/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 Lists


41

Fact Sheets4.4.5 Paragraph Formatting Facts4.4.8 Paragraph Formatting Tips



42

4.5: Formatting Pages

Summary


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/Demo Time4.5.1 Page Layout Options 3:244.5.2 Page and Column Breaks 2:214.5.3 Tab Stops 2:19


Lab/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 Program


43

4.5.4 Page Formatting Facts4.5.7 Page Formatting Tips



44

4.6: Editing Documents

Summary


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/Demo Time4.6.1 AutoCorrect Options 3:054.6.2 Spell Checking 2:134.6.3 The Thesaurus 4:10


Lab/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 Article

Fact Sheets4.6.4 Document Editing Facts4.6.7 Document Editing Tips


45



46

4.7: Inserting Illustrations and Other Elements

Summary


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/Demo Time4.7.1 Text Wrap Options 2:504.7.2 Illustration Formatting 4:004.7.3 Building Blocks and Other Elements 4:00


Lab/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 Flyer


47

Fact Sheets4.7.4 Word Illustration Facts4.7.7 Word Illustration Tips



48

4.8: Creating and Formatting Tables

Summary


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/Demo Time4.8.1 Word Tables 3:024.8.2 Table Formatting 5:014.8.3 Advanced Table Formatting 3:05


Lab/Activity4.8.5 Skills Lab: Create and Format Tables4.8.6 Challenge Lab: Create and Format Tables4.8.8 Applied Lab: Format a Calendar


49

4.8.9 Applied Lab: Format Tables for a Sales Report

Fact Sheets4.8.4 Word Table Facts4.8.7 Word Table Tips



50

4.9: Using Themes, Styles, and Templates

Summary


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/Demo Time4.9.1 Word Styles 3:444.9.2 Themes and Style Sets 4:044.9.3 Word Templates 2:58


Lab/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 Newsletter

Fact Sheets4.9.4 Word Theme & Style Facts4.9.7 Word Theme & Style Tips



51

4.10: Managing References

Summary


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/Demo Time4.10.1 Citations and References 4:174.10.2 Footnotes, Endnotes, and Advanced Citations 5:044.10.3 Captions 2:234.10.4 Table of Contents 2:37


Lab/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 Report

Fact Sheets4.10.5 Reference Facts4.10.8 Reference Tips


52



53

4.11: Managing Headers, Footers, and Sections

Summary


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/Demo Time4.11.1 Headers and Footers 4:094.11.2 Header and Footer Options 2:574.11.3 Next Page Section Breaks 4:334.11.4 Continuous Section Breaks 4:27


Lab/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 Report

Fact Sheets4.11.5 Word Header, Footer, & Section Facts4.11.8 Word Header, Footer, & Section Tips


54



55

4.12: Using Office Collaboration Features

Summary


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/Demo Time4.12.1 Track Changes and Comments 3:514.12.2 Combining Revisions 4:024.12.3 Distributing Files 4:27


Lab/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 Resume

Fact Sheets4.12.4 Collaboration Facts4.12.7 Collaboration Tips

Total Time


56

About 83 minutes


57

4.13: Using Macros

Summary


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/Demo Time4.13.1 Macros 5:03


Fact Sheets4.13.2 Macro Facts



58

5.1: Introduction to Excel

Summary


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/Demo Time5.1.1 Introduction to Excel 2:22


Fact Sheets5.1.2 Excel Tasks Overview



59

5.2: Creating and Managing Workbooks

Summary


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/Demo Time5.2.1 Spreadsheet Basics 3:265.2.2 Worksheet Management 1:515.2.3 Templates and Themes 1:575.2.4 External Data 2:45


Lab/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 Data

Fact Sheets5.2.5 Workbook Management Facts5.2.8 Workbook Management Tips


60



61

5.3: Organizing and Entering Data

Summary


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/Demo Time5.3.1 Deleting and Clearing Cells 1:595.3.2 Copy and Paste Options 3:425.3.3 Large Data Sets 4:04


Lab/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 Data


62

Fact Sheets5.3.4 Data Entry Facts5.3.7 Data Entry Tips



63

5.4: Changing Properties and Printing Worksheets

Summary


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/Demo Time5.4.1 Data Protection 3:055.4.2 Data Validation 3:215.4.3 Excel Printing Tips 3:17


Lab/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 Data


64

5.4.9 Applied Lab: Protect a Budget Worksheet

Fact Sheets5.4.4 Worksheet Printing Facts5.4.7 Worksheet Printing Tips



65

5.5: Formatting Cells

Summary


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/Demo Time5.5.1 Number Formats 3:155.5.2 Cell Formats 4:185.5.3 Cell Styles and Colors 2:065.5.4 Cell Borders 2:31


Lab/Activity5.5.6 Skills Lab: Format Cells5.5.7 Challenge Lab: Format Cells


66

5.5.9 Applied Lab: Camping Equipment Store5.5.10 Applied Lab: Format a Directory

Fact Sheets5.5.5 Cell Formatting Facts5.5.8 Cell Formatting Tips



67

5.6: Entering Simple Formulas

Summary


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/Demo Time5.6.1 AutoFill Options 3:395.6.2 Excel Formulas 3:585.6.3 Text Functions 3:245.6.4 CONCATENATE 3:25


Lab/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: Gradebook


68

5.6.5 Formula Facts5.6.8 Formula Tips



69

5.7: Using Advanced Functions

Summary


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/Demo Time5.7.1 Relative and Absolute References 3:125.7.2 Advanced Cell References 5:045.7.3 The IF Function 3:535.7.4 Logical Functions 2:555.7.5 Excel Error Messages 2:43


Lab/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 Company

Fact Sheets5.7.6 Advanced Function Facts


70

5.7.9 Advanced Function Tips



71

5.8: Displaying Data in Charts

Summary


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/Demo Time5.8.1 Chart Formatting 2:385.8.2 Chart Types 2:23


Lab/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 Results

Fact Sheets5.8.3 Chart Facts5.8.6 Chart Tips


72



73

5.9: Organizing Data in Tables

Summary


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/Demo Time5.9.1 Conditional Formatting 2:385.9.2 Excel Tables 2:315.9.3 Table Customization 2:40


Lab/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 Statistics

Fact Sheets5.9.4 Excel Table Facts5.9.7 Excel Table Tips


74



75

5.10: Summarizing Complex Data

Summary


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/Demo Time5.10.1 Creating Outlines 2:465.10.2 PivotTables 4:175.10.3 Advanced PivotTables 3:175.10.4 VLOOKUP 3:23


Lab/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 Store

Fact Sheets5.10.5 Complex Data Facts5.10.8 Complex Data Tips



76

6.1: Introduction to PowerPoint

Summary


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/Demo Time6.1.1 Introduction to PowerPoint 3:076.1.2 Best Practices in Design 3:36


Fact Sheets6.1.3 PowerPoint Tasks Overview



77

6.2: Creating and Managing Presentations

Summary


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 presentation. Organize a long presentation into relevant sections.

Video/Demo Time6.2.1 Slide Management 2:536.2.2 Presentation Sections 2:02


Lab/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 Template

Fact Sheets6.2.3 Presentation Management Facts6.2.6 Presentation Management Tips



78

6.3: Formatting Textual Content

Summary


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/Demo Time6.3.1 Text and Content Placeholders 3:286.3.2 Text Formatting 3:036.3.3 Managing Presentation Content 3:34


Lab/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 Report


79

Fact Sheets6.3.4 PowerPoint Text Formatting Facts6.3.7 PowerPoint Text Formatting Tips



80

6.4: Designing Slides

Summary


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/Demo Time6.4.1 Themes and Templates 3:046.4.2 Slide Backgrounds 2:22


Lab/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 Presentation

Fact Sheets6.4.3 Slide Design Facts6.4.6 Slide Design Tips

Total Time


81

About 76 minutes


82

6.5: Using the Slide Master

Summary


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/Demo Time6.5.1 Slide Masters 4:116.5.2 Slide Footers 2:37


Lab/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 Layout

Fact Sheets6.5.3 Slide Master Facts6.5.6 Slide Master Tips


83



84

6.6: Formatting SmartArt and Shapes

Summary


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/Demo Time6.6.1 SmartArt 3:096.6.2 Object Formatting 3:48


Lab/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 SmartArt

Fact Sheets6.6.3 SmartArt and Shape Facts6.6.6 SmartArt and Shape Tips


85



86

6.7: Formatting Tables and Charts

Summary


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/Demo Time6.7.1 PowerPoint Charts 3:246.7.2 PowerPoint Tables 3:02


Lab/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 Presentation

Fact Sheets6.7.3 Table and Chart Formatting Facts6.7.6 Table and Chart Formatting Tips



87

6.8: Formatting Pictures and Other Media

Summary


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 file. Compress media. Adjust media start and stop times.

Video/Demo Time6.8.1 Media Formatting 2:586.8.2 Advanced Media Formatting 5:36


Lab/Activity6.8.4 Skills Lab: Format Pictures and Other Media


88

6.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 Plato

Fact Sheets6.8.3 Media Formatting Facts6.8.6 Media Formatting Tips



89

6.9: Applying Animations and Transitions

Summary


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/Demo Time6.9.1 Animation 2:566.9.2 Transitions 3:10


Lab/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 Emphasis

Fact Sheets6.9.3 Animation and Transition Facts6.9.6 Animation and Transition Tips



90

6.10: Delivering Presentations

Summary


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/Demo Time6.10.1 Presentation Tools 3:436.10.2 PowerPoint Print Options 3:146.10.3 Advanced Slide Show Options 3:38


Lab/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 Lecture


91

Fact Sheets6.10.4 Presentation Delivery Facts6.10.7 Presentation Delivery Tips



92

7.1: Introduction to Access

Summary


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/Demo Time7.1.1 Introduction to Relational Databases 3:50


Fact Sheets7.1.2 Access Tasks Overview



93

7.2: Managing Databases

Summary


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/Demo Time7.2.1 Tour of Access 2:597.2.2 Database Terminology 2:23


Lab/Activity7.2.4 Skills Lab: Managing Databases7.2.5 Challenge Lab: Managing Databases

Fact Sheets7.2.3 Database Management Facts7.2.6 Database Management Tips



94

7.3: Designing and Creating Tables

Summary


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/Demo Time7.3.1 Database Planning 3:197.3.2 Table Design 3:267.3.3 Default Values 2:227.3.4 Relationships and Lookups 3:227.3.5 Data Importing 2:31


Lab/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 Database

Fact Sheets7.3.6 Table Design Facts7.3.9 Table Design Tips

Total Time


95

About 85 minutes


96

7.4: Using Simple Queries

Summary


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/Demo Time7.4.1 Introduction to Queries 2:257.4.2 Query Criteria 3:027.4.3 Queries with Totals 2:26


Lab/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 Library

Fact Sheets7.4.4 Query Facts7.4.7 Query Tips



97

7.5: Creating Forms

Summary


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/Demo Time7.5.1 Access Forms 2:207.5.2 Form Formatting 3:22


Lab/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 Library

Fact Sheets7.5.3 Form Facts7.5.6 Form Tips



98

7.6: Creating Reports

Summary


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/Demo Time7.6.1 The Report Wizard 2:487.6.2 Reports with Totals 2:397.6.3 Report Formatting 4:38


Lab/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 Library

Fact Sheets7.6.4 Report Facts7.6.7 Report Tips



99

7.7: Surveying Advanced Access Features

Summary


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 option. Compact, 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.


100

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/Demo Time7.7.1 Managing Databases 2:527.7.2 Formatting Tables and Managing Records 2:457.7.3 Application Parts 1:597.7.4 Crosstab Queries 2:457.7.5 Query Parameters 2:087.7.6 Action Queries 5:507.7.7 Calculated Fields and Conditional Logic 5:027.7.8 Advanced Form Options 4:247.7.9 Navigation Forms 2:407.7.10 Advanced Report Options 2:03


Fact Sheets7.7.11 Advanced Query Facts7.7.12 Additional Access Facts and Videos



101

8.1: Introduction to Outlook

Summary


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 messages. Organize 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/Demo Time8.1.1 Introduction to Outlook 2:058.1.2 Checking Your Email 2:58


Fact Sheets8.1.3 Outlook Tasks Overview



102

8.2: Sending and Receiving Messages

Summary


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/Demo Time8.2.1 Formatting and Sending Messages 2:488.2.2 Email Etiquette 3:118.2.3 Signatures 2:338.2.4 Attachments and Hyperlinks 2:528.2.5 Tracking Options 3:09


Lab/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 Message


103

8.2.6 Message Facts8.2.9 Message Tips



104

8.3: Managing Messages

Summary


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/Demo Time8.3.1 Organizing Messages 2:478.3.2 Automating Outlook 5:208.3.3 Junk Mail and Clutter 2:438.3.4 Conversations 2:188.3.5 Searching in Outlook 3:418.3.6 Importing and Exporting 2:51


Lab/ActivityCopyright © 2018 TestOut Corporation. CompTIA, A+, Network+, Security+, Linux+ and related trademarks and trade names are the trademarks of CompTIA. Microsoft, MCITP, MSCA, MCTS, Windows and Office are the trademarks of Microsoft. Cisco and CCNA are the trademarks of Cisco. (ISC)2 and SSCP are the trademarks of (ISC)2. TestOut has no affiliation with any of these companies and the products and services advertised herein are not endorsed by any of them.

105

8.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 Messages

Fact Sheets8.3.7 Message Management Facts8.3.10 Message Management Tips



106

8.4: Working with the Calendar

Summary


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/Demo Time8.4.1 Create and Manage Calendars 3:328.4.2 Calendar Items 3:108.4.3 Meetings 3:168.4.4 Tasks 2:05


107


Lab/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 Items

Fact Sheets8.4.5 Calendar Facts8.4.8 Calendar Tips



108

8.5: Managing Contacts and Groups

Summary


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/Demo Time8.5.1 Creating Contacts 3:398.5.2 Contact Groups 2:318.5.3 Using the Navigation Bar 2:288.5.4 Working With Multiple Accounts 3:14


Lab/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 Groups


109

Fact Sheets8.5.5 Contact and Group Facts8.5.8 Contact and Group Tips



110

Desktop Pro Practice ExamsA.0: Desktop Pro Certification Practice Exams

A.2 Desktop Pro Domain 1: Microsoft Word (12 questions)


A.3 Desktop Pro Domain 2: Microsoft Excel (12 questions)


A.4 Desktop Pro Domain 3: Microsoft PowerPoint (10 questions)


A.5 Desktop Pro Certification Practice Exam (13 questions)



111

B.1: Preparing for MOS Certification

Summary

The 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.


112

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 certiport.com 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/Demo TimeB.1.1 Preparing for the MOS Exams 2:40B.1.2 Performing Unfamiliar Tasks 7:17B.1.3 Using TestOut MOS Practice Exams 3:30


Fact SheetsB.1.4 MOS Exam ObjectivesB.1.5 Taking an MOS Exam



https://certiport.pearsonvue.com/Educator-resources/Exam-details/Exam-tutorials

http://certiport.com/

113

B.2: Microsoft Word 2016 Core (77-725)

Summary

This 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 Images

Insert text boxes Apply artistic effects Apply picture effects

3.2.5 – Text Importing

Insert text from a file or external source

3.4.3 – Bulleted and Numbered Lists

Define 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


114

3.8.3 – Advanced Table Formatting

Convert text to tables Sort table data

3.10.4 – Table of Contents

Insert a standard table of contents Update a table of contents

5.6.1 – SmartArt

Create a SmartArt graphic Format a SmartArt graphic Modify SmartArt graphic content




115

B.3: Microsoft Excel 2016 Core (77-727)

Summary

This 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.



Insert 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 Tables

Sort data by multiple columns


116

4.9.4 – Sparklines (Text Lesson Video)

Insert sparklines




117

B.4: Microsoft PowerPoint 2016 (77-729)

Summary

This 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.



Display alignment tools

2.5.2 – Formatting Shapes

Apply styles to shapes and text boxes

3.12.3 – Distributing Files

Inspect a presentation

5.3.3 – Managing Presentation Content

Import Word document outlines Import slides from another presentation

5.3.4 – Format Text in Multiple Columns (Text Lesson Video)

Format text in multiple columns


118

5.7.3 – Import a Table (Text Lesson Video)

Import a table

5.10.3 – Advanced Slide Show Options

Create custom slide shows




119

Appendix 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 color. Compare 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.Copyright © 2018 TestOut Corporation. CompTIA, A+, Network+, Security+, Linux+ and related trademarks and trade names are the trademarks of CompTIA. Microsoft, MCITP, MSCA, MCTS, Windows and Office are the trademarks of Microsoft. Cisco and CCNA are the trademarks of Cisco. (ISC)2 and SSCP are the trademarks of (ISC)2. TestOut has no affiliation with any of these companies and the products and services advertised herein are not endorsed by any of them.

120

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.


121

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.


122

Identify application software that facilitates collaboration, including:o Discussion boardso Screen sharingo Calendaringo Resource managemento Webinarso Collaborative editing

2.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:

o Fieldo Recordo Primary keyo Foreign keyo One-to-many relationship

Explain 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.


123

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:

o Network Architecto Database Administratoro Programmero Support Specialisto Security Analyst

Chapter 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.


124

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.


125

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.


126

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.


127

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.


128

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.


129

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


130

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.


131

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.


132

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.


133

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 presentation. Organize 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.


134

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.


135

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.


136

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 file. Compress 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.


137

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.


138

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 option. Compact, 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.


139

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.


140

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.


141

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.


142

Appendix B: Course Mapping to MOS Exam Objectives77-725 Microsoft Office Specialist Word Core 2016

Objective Text: Word Objective Number

Desktop Pro Plus Section

1.0 Create and Manage DocumentsCreate a document

create a blank document 1.1.1 3.1 create a blank document using a template 1.1.2 4.9 open a PDF in Word for editing 1.1.3 4.2 insert text from a file or external source 1.1.4 4.2

Navigate through a document search for text 1.2.1 3.4 insert hyperlinks 1.2.2 3.4 create bookmarks 1.2.3 3.4 move to a specific location or object in a document 1.2.4 3.4

Format a Document modify page setup 1.3.1 4.5 apply document themes 1.3.2 4.9 apply document style sets 1.3.3 4.9 insert headers and footers 1.3.4 4.11 insert page numbers 1.3.5 4.11 format page background elements 1.3.6 4.5

Customize Options and Views for Documents change document views 1.4.1 3.2 customize views by using zoom settings 1.4.2 3.2 customize the Quick Access toolbar 1.4.3 3.2 split the window 1.4.4 3.2 add document properties 1.4.5 3.1 show or hide formatting symbols 1.4.6 4.4

Print and Save Documents modify print settings 1.5.1 3.3 save documents in alternative file formats 1.5.2 3.1 print all or part of a document 1.5.3 3.3 inspect a document for hidden properties or personal

information 1.5.4 4.12

inspect a document for accessibility issues 1.5.5 4.12 inspect a document for compatibility issues 1.5.6 4.12

2.0 Format Text, Paragraphs, and Sections


143



Insert Text and Paragraphs find and replace text 2.1.1 4.6 cut, copy and paste text 2.1.2 4.2 replace text by using AutoCorrect 2.1.3 4.6 insert special characters 2.1.4 4.7

Format Text and Paragraphs apply font formatting 2.2.1 4.3 apply formatting by using Format Painter 2.2.2 4.9 set line and paragraph spacing and indentation 2.2.3 4.4 clear formatting 2.2.4 4.4 apply a text highlight color to text selections 2.2.5 4.3 apply built-in styles to text 2.2.6 4.9 change text to WordArt 2.2.7 4.3

Order and Group Text and Paragraphs format text in multiple columns 2.3.1 4.5 insert page, section, or column breaks 2.3.2 4.5 & 4.11 change page setup options for a section 2.3.3 4.11

3.0 Create Tables and ListsCreate a Table

convert text to tables 3.1.1 4.8 convert tables to text 3.1.2 4.8 create a table by specifying rows and columns 3.1.3 4.8 apply table styles 3.1.4 4.8

Modify a Table sort table data 3.2.1 4.8 configure cell margins and spacing 3.2.2 4.8 merge and split cells 3.2.3 4.8 resize tables, rows, and columns 3.2.4 4.8 split tables 3.2.5 4.8 configure a repeating row header 3.2.6 4.8

Create and Modify a List create a numbered or bulleted list 3.3.1 4.4 change bullet characters or number formats for a list level 3.3.2 4.4 define a custom bullet character or number format 3.3.3 4.4 increase or decrease list levels 3.3.4 4.4 restart or continue list numbering 3.3.5 4.4 set starting number value 3.3.6 4.4

4.0 Create and Manage References


144



Create and Manage Reference Markers insert footnotes and endnotes 4.1.1 4.10 modify footnote and endnote properties 4.1.2 4.10 create bibliography citation sources 4.1.3 4.10 modify bibliography citation sources 4.1.4 4.10 insert citations for bibliographies 4.1.5 4.10 insert figure and table captions 4.1.6 4.10 modify caption properties 4.1.7 4.10

Create and Manage Simple References insert a standard table of contents 4.2.1 4.10 update a table of contents 4.2.2 4.10 insert a cover page 4.2.3 4.7

5.0 Insert and Format Graphic ElementsInsert Graphic Elements

insert shapes 5.1.1 4.7 insert pictures 5.1.2 4.7 insert a screen shot or screen clipping 5.1.3 4.7 insert text boxes 5.1.4 4.5 & 3.7

Format Graphic Elements apply artistic effects 5.2.1 3.5 apply picture effects 5.2.2 3.5 remove picture backgrounds 5.2.3 4.7 format objects 5.2.4 3.5 apply a picture style 5.2.5 3.5 & 4.7 wrap text around objects 5.2.6 4.7

position objects 5.2.7 3.5 add alternative text to objects for accessibility 5.2.8 4.12

Insert and Format SmartArt Graphics create a SmartArt graphic 5.3.1 6.6 format a SmartArt graphic 5.3.2 6.6 modify SmartArt graphic content 5.3.3 6.6


145

77-727 Microsoft Office Specialist Excel 2016

Objective Text: Excel Objective Number


1.0 Manage Worksheets and WorkbooksCreate Worksheets and Workbooks

create a workbook 1.1.1 3.1 import data from a delimited text file 1.1.2 5.2 add a worksheet to an existing workbook 1.1.3 5.2 copy and move a worksheet 1.1.4 5.2

Navigate in Worksheets and Workbooks search for data within a workbook 1.2.1 3.4 navigate to a named cell, range, or workbook element 1.2.2 3.4 insert and remove hyperlinks 1.2.3 3.4

Format Worksheets and Workbooks change worksheet tab color 1.3.1 5.2 rename a worksheet 1.3.2 5.2 change worksheet order 1.3.3 5.2 modify page setup 1.3.4 5.4 insert and delete columns or rows 1.3.5 5.3 change workbook themes 1.3.6 5.2 adjust row height and column width 1.3.7 5.5 insert headers and footers 1.3.8 5.4

Customize Options and Views for Worksheets and Workbooks hide or unhide worksheets 1.4.1 5.3 hide or unhide columns and rows 1.4.2 5.3 customize the Quick Access toolbar 1.4.3 3.2 change workbook views 1.4.4 3.2 change window views 1.4.5 3.2 & 5.3 modify document properties 1.4.6 3.1 change magnification by using zoom tools 1.4.7 3.2 display formulas 1.4.8 5.7

Configure Worksheets and Workbooks for Distribution set a print area 1.5.1 5.4 save workbooks in alternative file formats 1.5.2 5.2 print all or part of a workbook 1.5.3 3.3 set print scaling 1.5.4 3.3 display repeating row and column titles on multipage

worksheets1.5.5 5.4

inspect a workbook for hidden properties or personal information

1.5.6 4.12


146



inspect a workbook for accessibility issues 1.5.7 4.12 inspect a workbook for compatibility issues 1.5.8 4.12

2.0 Manage Data Cells and RangesInsert Data in Cells and Ranges

replace data 2.1.1 3.4 cut, copy, or paste data 2.1.2 5.3 paste data by using special paste options 2.1.3 5.3 fill cells by using Auto Fill 2.1.4 5.6 insert and delete cells 2.1.5 5.3

Format Cells and Ranges merge cells 2.2.1 5.5 modify cell alignment and indentation 2.2.2 5.5 format cells by using Format Painter 2.2.3 5.5 wrap text within cells 2.2.4 5.5 apply number formats 2.2.5 5.5 apply cell formats 2.2.6 5.5 apply cell styles 2.2.7 5.5

Summarize and Organize Data insert sparklines 2.3.1 5.9 outline data 2.3.2 5.10 insert subtotals 2.3.3 5.10 apply conditional formatting 2.3.4 5.9

3.0 Create TablesCreate and Manage Tables

create an Excel table from a cell range 3.1.1 5.9 convert a table to a cell range 3.1.2 5.9 add or remove table rows and columns 3.1.3 5.9

Manage Table Styles and Options apply styles to tables 3.2.1 5.9 configure table style options 3.2.2 5.9 insert total rows 3.2.3 5.9

Filter and Sort a Table filter records 3.3.1 5.9 sort data by multiple columns 3.3.2 5.9 change sort order 3.3.3 5.9 remove duplicate records 3.3.4 5.9

4.0 Perform Operations with Formulas and FunctionsSummarize Data by using Functions

insert references 4.1.1 5.7Copyright © 2018 TestOut Corporation. CompTIA, A+, Network+, Security+, Linux+ and related trademarks and trade names are the trademarks of CompTIA. Microsoft, MCITP, MSCA, MCTS, Windows and Office are the trademarks of Microsoft. Cisco and CCNA are the trademarks of Cisco. (ISC)2 and SSCP are the trademarks of (ISC)2. TestOut has no affiliation with any of these companies and the products and services advertised herein are not endorsed by any of them.

147



perform calculations by using the SUM function 4.1.2 5.6 perform calculations by using MIN and MAX functions 4.1.3 5.6 perform calculations by using the COUNT function 4.1.4 5.6 perform calculations by using the AVERAGE function 4.1.5 5.6

Perform Conditional Operations by using Functions perform logical operations by using the IF function 4.2.1 5.7 perform logical operations by using the SUMIF function 4.2.2 5.7 perform logical operations by using the AVERAGEIF

function4.2.3 5.7

perform statistical operations by using the COUNTIF function

4.2.4 5.7

Format and Modify Text by using Functions format text by using RIGHT, LEFT, and MID functions 4.3.1 5.6 format text by using UPPER, LOWER, and PROPER

functions4.3.2 5.6

format text by using the CONCATENATE function 4.3.3 5.65.0 Create Charts and ObjectsCreate Charts

create a new chart 5.1.1 5.8 add additional data series 5.1.2 5.8 switch between rows and columns in source data 5.1.3 5.8 analyze data by using Quick Analysis 5.1.4 5.10

Format Charts resize charts 5.2.1 5.8 add and modify chart elements 5.2.2 5.8 apply chart layouts and styles 5.2.3 5.8 move charts to a chart sheet 5.2.4 5.8

Insert and Format Objects insert text boxes and shapes 5.3.1 3.5 insert images 5.3.2 3.5 modify object properties 5.3.3 3.5 add alternative text to objects for accessibility 5.3.4 4.12

77-729 Microsoft Office Specialist PowerPoint 2016

Objective Text: PowerPoint Objective Number


1.0 Create and Manage Presentations


148



Create a Presentation create a new presentation 1.1.1 3.1 create a presentation based on a template 1.1.2 6.2 import Word document outlines 1.1.3 6.3

Insert and Format Slides insert specific slide layouts 1.2.1 6.4 duplicate existing slides 1.2.2 6.2 hide and unhide slides 1.2.3 6.2 delete slides 1.2.4 6.2 apply a different slide layout 1.2.5 6.4 modify individual slide backgrounds 1.2.6 6.4 insert slide headers, footers, and page numbers 1.2.7 6.5

Modify Slides, Handouts, and Notes change the slide master theme or background 1.3.1 6.5 modify slide master content 1.3.2 6.5 create a slide layout 1.3.3 6.5 modify a slide layout 1.3.4 6.5 modify the handout master 1.3.5 6.5 modify the notes master 1.3.6 6.5

Order and Group Slides create sections 1.4.1 6.2 modify slide order 1.4.2 6.2 rename sections 1.4.3 6.2

Change Presentation Options and Views change slide size 1.5.1 6.4 change views of a presentation 1.5.2 3.2 set file properties 1.5.3 3.1

Configure a Presentation for Print print all or part of a presentation 1.6.1 3.3 print notes pages 1.6.2 3.3 print handouts 1.6.3 3.3 print in color, grayscale, or black and white 1.6.4 3.3

Configure and Present a Slide Show create custom slide shows 1.7.1 6.10 configure slide show options 1.7.2 6.10 rehearse slide show timing 1.7.3 6.10 present a slide show by using Presenter View 1.7.4 6.10

2.0 Insert and Format Text, Shapes, and ImagesInsert and Format Text


149



insert text on a slide 2.1.1 6.3 apply formatting and styles to text 2.1.2 6.3 apply WordArt styles to text 2.1.3 6.6 format text in multiple columns 2.1.4 6.3 create bulleted and numbered lists 2.1.5 6.3 insert hyperlinks 2.1.6 6.8

Insert and Format Shapes and Text Boxes insert or replace shapes 2.2.1 3.5 insert text boxes 2.2.2 3.5 resize shapes and text boxes 2.2.3 3.5 format shapes and text boxes 2.2.4 3.5 apply styles to shapes and text boxes 2.2.5 3.5

Insert and Format Images insert images 2.3.1 3.5 resize and crop images 2.3.2 6.8 apply styles and effects 2.3.3 6.8

Order and Group Objects order objects 2.4.1 6.6 align objects 2.4.2 6.6 group objects 2.4.3 6.6 display alignment tools 2.4.4 3.5

3.0 Insert Tables, Charts, SmartArt, and MediaInsert and Format Tables

create a table 3.1.1 6.7 insert and delete table rows and columns 3.1.2 6.7 apply table styles 3.1.3 6.7 import a table 3.1.4 6.7

Insert and Format Charts create a chart 3.2.1 6.7 import a chart 3.2.2 6.7 change the Chart Type 3.2.3 6.7 add a legend to a chart 3.2.4 6.7 change the chart style of a chart 3.2.5 6.7

Insert and Format SmartArt graphics create SmartArt graphics 3.3.1 6.6 convert lists to SmartArt graphics 3.3.2 6.6 add shapes to SmartArt graphics 3.3.3 6.6 reorder shapes in SmartArt graphics 3.3.4 6.6 change the color of SmartArt graphics 3.3.5 6.6


150



Insert and Manage Media insert audio and video clips 3.4.1 6.8 configure media playback options 3.4.2 6.8 adjust media window size 3.4.3 6.8 set the video start and stop time 3.4.4 6.8 set media timing options 3.4.5 6.8

4.0 Apply Transitions and AnimationsApply Slide Transitions

insert slide transitions 4.1.1 6.9 set transition effect options 4.1.2 6.9

Animate Slide Content apply animations to objects 4.2.1 6.9 apply animations to text 4.2.2 6.9 set animation effect options 4.2.3 6.9 set animation paths 4.2.4 6.9

Set Timing for Transitions and Animations set transition effect duration 4.3.1 6.9 configure transition start and finish options 4.3.2 6.9 reorder animations on a slide 4.3.3 6.9

5.0 Manage Multiple PresentationsMerge Content from Multiple Presentations

insert slides from another presentation 5.1.1 6.3 compare two presentations 5.1.2 4.12 insert comments 5.1.3 4.12 review comments 5.1.4 4.12

Finalize Presentations protect a presentation 5.2.1 4.12 inspect a presentation 5.2.2 4.12 proof a presentation 5.2.3 6.10 preserve presentation content 5.2.4 4.12, 6.3

& 6.8 export presentations to other formats 5.2.5 6.8 & 6.10


151

77-730 Microsoft Office Specialist Access 2016

Objective Text: Access Objective Number


1.0 Create and Manage a DatabaseCreate and Modify Databases

create a blank desktop database 1.1.1 7.2 create a database from a template 1.1.2 7.7 create a database by using import objects or data from

other sources1.1.3 7.7

delete database objects 1.1.4 7.2Manage Relationships and Keys

create and modify relationships 1.2.1 7.3 set the primary key 1.2.2 7.3 enforce referential integrity 1.2.3 7.3 set foreign keys 1.2.4 7.3 view relationships 1.2.5 7.3

Navigate through a Database navigate specific records 1.3.1 7.2 create and modify a navigation form 1.3.2 7.7 set a form as the startup option 1.3.3 7.7 display objects in the Navigation Pane 1.3.4 7.2 change views of objects 1.3.5 7.3

Protect and Maintain Databases compact a database 1.4.1 7.7 repair a database 1.4.2 7.7 back up a database 1.4.3 7.7 split a database 1.4.4 7.7 encrypt a database with a password 1.4.5 7.7 recover data from backup 1.4.6 7.7

Print and Export Data print reports 1.5.1 7.2 print records 1.5.2 7.7 save a databases as a template 1.5.3 7.7 export objects to alternative formats 1.5.4 7.7

2.0 Build Tables Create Tables

create a table 2.1.1 7.3 import data into tables 2.1.2 7.3 create linked tables from external sources 2.1.3 7.7


152



import tables from other databases 2.1.4 7.7 create a table from a template with application parts 2.1.5 7.7

Manage Tables hide fields in tables 2.2.1 7.7 add total rows 2.2.2 7.7 add table descriptions 2.2.3 7.7 rename tables 2.2.4 7.3

Manage Records in Tables update records 2.3.1 7.2 add records 2.3.2 7.2 delete records 2.3.3 7.2 append records from external data 2.3.4 7.2 find and replace data 2.3.5 7.7 sort records 2.3.6 7.7 filter records 2.3.7 7.7

Create and Modify Fields add fields to tables 2.4.1 7.3 add validation rules to fields 2.4.2 7.7 change field captions 2.4.3 7.3 change field sizes 2.4.4 7.3 change field data types 2.4.5 7.3 configure fields to auto-increment 2.4.6 7.3 set default values 2.4.7 7.3 using input masks 2.4.8 7.7 delete fields 2.4.9 7.3

3.0 Create Queries Create a Query

run a query 3.1.1 7.4 create a crosstab query 3.1.2 7.7 create a parameter query 3.1.3 7.7 create an action query 3.1.4 7.7 create a multi-table query 3.1.5 7.4 save a query 3.1.6 7.4

Modify a Query rename a query 3.2.1 7.2 add fields 3.2.2 7.4 remove fields 3.2.3 7.4 hide fields 3.2.4 7.4 sort data within queries 3.2.5 7.4


153



format fields within queries 3.2.6 7.4Create Calculated Fields and Grouping within Queries

add calculated fields 3.3.1 7.7 set filtering criteria 3.3.2 7.4 group and summarize data 3.3.3 7.4 group data by using comparison operators 3.3.4 7.4 group data by using arithmetic and logical operators 3.3.5 7.7

4.0 Create Forms Create a Form

create a form 4.1.1 7.5 create a form from a template with application parts 4.1.2 7.7 save a form 4.1.3 7.5

Configure Form Controls move form controls 4.2.1 7.5 add form controls 4.2.2 7.5 modify data sources 4.2.3 7.7 remove form controls 4.2.4 7.5 set form control properties 4.2.5 7.7 manage labels 4.2.6 7.5 add sub-forms 4.2.7 7.7

Format a Form modify tab order 4.3.1 7.7 configure print settings 4.3.2 7.7 sort records by form field 4.3.3 7.7 apply a theme 4.3.4 7.5 control form positioning 4.3.5 7.7 insert backgrounds 4.3.6 7.7 insert headers and footers 4.3.7 7.7 insert images 4.3.8 7.6

5.0 Create Reports Create a Report

create a report based on the query or table 5.1.1 7.6 create a report in Design view 5.1.2 7.6 create a report by using a wizard 5.1.3 7.6

Configure Report Controls group and sort fields 5.2.1 7.6 & 7.7 modify data sources 5.2.2 7.7 add report controls 5.2.3 7.7 add and modify labels 5.2.4 7.6


154



Format a Report format a report into multiple columns 5.3.1 7.7 add calculated fields 5.3.2 7.6 control report positioning 5.3.3 7.7 format report elements 5.3.4 7.6 change report orientation 5.3.5 7.7 insert header and footer information 5.3.6 7.7 insert images 5.3.7 7.6 apply a theme 5.3.8 7.6


155

77-731 Microsoft Office Specialist Outlook 2016

Objective Text: Outlook Objective Number


1.0 Manage the Outlook Environment for ProductivityCustomize Settings

customize reply messages 1.1.1 8.2 change text formats for all outgoing messages 1.1.2 8.2 customize the Navigation Pane 1.1.3 8.5 configure views 1.1.4 8.5 manage multiple accounts 1.1.5 8.5 add an account 1.1.6 8.5

Print and Save Information print message, calendar, contact, or task information 1.2.1 8.3 save message attachments 1.2.2 8.2 preview attachments 1.2.3 8.2 save messages in alternate formats 1.2.4 8.3 export messages to a data file 1.2.5 8.3

Perform Search Operations in Outlook create new search folders 1.3.1 8.3 search for items in messages, tasks, contacts, or calendars 1.3.2 8.3 search by using advanced find 1.3.3 8.3 search by folder 1.3.4 8.3

2.0 Manage Messages Configure Mail Settings

set fonts for new messages and responses 2.1.1 8.2 create, assign, and modify signatures 2.1.2 8.2 create and manage rules 2.1.3 8.3 create automatic replies 2.1.4 8.3 create messages by using Quick Parts 2.1.5 4.7 configure junk e-mail and clutter settings 2.1.6 8.3

Create Messages create a message 2.2.1 8.2 add or remove message attachments 2.2.2 8.2 add cc and bcc to messages 2.2.3 8.2 add tracking and voting options 2.2.4 8.2 forward and reply to messages 2.2.5 8.2 request a delivery or read receipt 2.2.6 8.2 redirect replies 2.2.7 8.3 flag outgoing messages for follow up, importance, and 2.2.8 8.2


156



sensitivity recall a message 2.2.9 8.3

Format a Message format text 2.3.1 8.2 insert hyperlinks 2.3.2 8.2 apply themes and styles 2.3.3 8.2 insert images 2.3.4 8.2 add a signature to specific messages 2.3.5 8.2

Organize and Manage Messages sort messages 2.4.1 8.3 move messages between folders 2.4.2 8.3 add new local folders 2.4.3 8.3 apply categories 2.4.4 8.3 clean up messages 2.4.5 8.3 mark a message as read or unread 2.4.6 8.1 flag received messages 2.4.7 8.3 ignore messages 2.4.8 8.3 sort messages by conversation 2.4.9 8.3 delete messages 2.4.10 8.3 automate repetitive tasks by using Quick Steps 2.4.11 8.3 configure basic AutoArchive settings 2.4.12 8.3 Delegate access 2.4.13 8.5

3.0 Manage Schedules Create and Manage Calendars

create and add calendars 3.1.1 8.4 adjust viewing details for calendars 3.1.2 8.4 modify calendar time zones 3.1.3 8.4 delete calendars 3.1.4 8.4 set calendar work times 3.1.5 8.4 manage multiple calendars 3.1.6 8.4 manage calendar groups 3.1.7 8.4 display multiple calendars 3.1.8 8.4 share calendars 3.1.9 8.4

Create Appointments, Meetings, and Events create calendar items 3.2.1 8.4 create recurring calendar items 3.2.2 8.4 cancel calendar items 3.2.3 8.4 create calendar items from messages 3.2.4 8.4 set calendar item times 3.2.5 8.4


157



setup meetings by using the scheduling assistant 3.2.6 8.4 set free or busy status for calendar items 3.2.7 8.4 schedule resources 3.2.8 8.4 Setup meeting location by using Room Finder 3.2.9 8.4

Organize and Manage Appointments, Meetings, and Events set calendar item importance 3.3.1 8.4 forward calendar items 3.3.2 8.4 configure reminders 3.3.3 8.4 add participants 3.3.4 8.4 respond to invitations 3.3.5 8.4 update individual or recurring calendar items 3.3.6 8.4 share meeting notes 3.3.7 8.4 categorize calendar items 3.3.8 8.4

Create and Manage Notes and Tasks create and manage tasks 3.4.1 8.4 create and organizing notes 3.4.2 8.5

4.0 Manage Contacts and Groups Create and Manage Contacts

create a new contact 4.1.1 8.5 delete contacts 4.1.2 8.5 import contacts from external sources 4.1.3 8.5 edit contact information 4.1.4 8.5 attach an image to a contact 4.1.5 8.5 add tags to contacts 4.1.6 8.5 share contacts 4.1.7 8.5 create and manage address books 4.1.8 8.5

Create and Manage Contact Group create new contact groups 4.2.1 8.5 add contacts to existing contact groups 4.2.2 8.5 add notes to a contact group 4.2.3 8.5 update contacts within contact groups 4.2.4 8.5 delete contact groups 4.2.5 8.5 delete contact group members 4.2.6 8.5


158

Appendix 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 times Text 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 16 hours of Practice Test material at the end of the course.

The breakdown for this course is as follows:

Module Sections Time Videos Labs Text Exams1.0: Online Essentials

1.1: The Information Age 88 33 0 45 101.2: The Internet and Social Media 101 26 20 45 101.3: Digital Communication 73 18 20 25 101.4: Online Safety and Security 143 38 70 25 101.5: Evaluating Online Information 45 15 0 20 10End-of-Chapter Exam 60 60*

Total 8:30 2:10 1:50 2:40 1:502.0: Computer Essentials

2.1: Computer Hardware 129 29 60 30 102.2: System Software 120 20 60 30 102.3: File Management 109 19 60 20 102.4: Application Software 68 7 40 15 62.5: Networking and User Accounts 84 18 40 20 62.6: Databases 54 17 20 10 72.7: Computer Programming 53 19 0 25 92.8: Information Systems 45 15 0 25 5End-of-Chapter Exam 60 60*

Total 12:02 2:24 4:40 2:55 2:033.0: Common Office Features

3.1: Getting Started with Office 72 22 40 10 03.2: Customizing Views and Options 52 7 40 5 03.3: Printing Files 50 5 40 5 03.4: Navigating Files 54 9 40 5 03.5: Working with Objects 54 9 40 5 0End-of-Chapter Exam 60 60*

Total 5:42 0:52 3:20 0:30 1:00


159

4.0: Microsoft Word4.1: Introduction to Word 8 3 0 5 04.2: Creating Documents and Using the Clipboard 89 19 60 10 04.3: Modifying Fonts 78 8 60 10 04.4: Formatting Paragraphs 86 16 60 10 04.5: Formatting Pages 79 9 60 10 04.6: Editing Documents 80 10 60 10 04.7: Inserting Illustrations and Other Elements 81 11 60 10 04.8: Creating and Formatting Tables 82 12 60 10 04.9: Using Themes, Styles, and Templates 81 11 60 10 04.10: Managing References 85 15 60 10 04.11: Managing Headers, Footers, and Sections 87 17 60 10 04.12: Using Office Collaboration Features 83 13 60 10 04.13: Using Macros 11 6 0 5 0End-of-Chapter Exam 60 60*

Total 16:30 2:30 11:00 2:00 1:005.0: Microsoft Excel

5.1: Introduction to Excel 8 3 0 5 05.2: Creating and Managing Workbooks 80 10 60 10 05.3: Organizing and Entering Data 80 10 60 10 05.4: Changing Properties and Printing Worksheets 80 10 60 10 05.5: Formatting Cells 83 13 60 10 05.6: Entering Simple Formulas 85 15 60 10 05.7: Using Advanced Functions 88 18 60 10 05.8: Displaying Data in Charts 76 6 60 10 05.9: Organizing Data in Tables 78 8 60 10 05.10: Summarizing Complex Data 84 14 60 10 0End-of-Chapter Exam 60 60*

Total 13:22 1:47 9:00 1:35 1:006.0: Microsoft PowerPoint

6.1: Introduction to PowerPoint 12 7 0 5 06.2: Creating and Managing Presentations 75 5 60 10 06.3: Formatting Textual Content 81 11 60 10 06.4: Designing Slides 76 6 60 10 06.5: Using the Slide Master 77 7 60 10 06.6: Formatting SmartArt and Shapes 77 7 60 10 06.7: Formatting Tables and Charts 77 7 60 10 06.8: Formatting Pictures and Other Media 79 9 60 10 06.9: Applying Animations and Transitions 77 7 60 10 06.10: Delivering Presentations 81 11 60 10 0End-of-Chapter Exam 60 60*

Total 12:52 1:17 9:00 1:35 1:007.0: Microsoft Access

7.1: Introduction to Access 9 4 0 5 07.2: Managing Databases 56 6 40 10 07.3: Designing and Creating Tables 85 15 60 10 0


160

7.4: Using Simple Queries 78 8 60 10 07.5: Creating Forms 76 6 60 10 07.6: Creating Reports 80 10 60 10 07.7: Surveying Advanced Access Features 43 33 0 10 0End-of-Chapter Exam 60 60*

Total 8:07 1:22 4:40 1:05 1:008.0: Microsoft Outlook

8.1: Introduction to Outlook 11 6 0 5 08.2: Sending and Receiving Messages 85 15 60 10 08.3: Managing Messages 90 20 60 10 08.4: Working with the Calendar 83 13 60 10 08.5: Managing Contacts and Groups 82 12 60 10 0End-of-Chapter Exam 60 60*

Total 6:51 1:06 4:00 0:45 1: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.


161

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 Exams Number of Questions TimeA.2: Desktop Pro Domain 1: Microsoft Word 12 180A.3: Desktop Pro Domain 2: Microsoft Excel 12 180A.4: Desktop Pro Domain 3: Microsoft PowerPoint 10 180A.5: Desktop Pro Certification Practice Exam 13 120

Total 47 11:00Total Desktop Pro Practice Exam Time 11:00

MOS 2016 Certification Practice ExamsB.0: MOS 2016 Practice Exams Number of Questions TimeB.2.1: Microsoft Word Practice – Form A 7 50B.2.2: Microsoft Word Practice – Form B 7 50B.3.1: Microsoft Excel Practice – Form A 7 50B.3.2: Microsoft Excel Practice – Form B 7 50B.4.1: Microsoft PowerPoint Practice – Form A 7 50B.4.2: Microsoft PowerPoint Practice – Form B 7 50

Total 42 5:00Total MOS Practice Exam Time 5:00
