Productivity App |
|
|
Productivity Apps for School and Work PA-1 |
|
|
|
Introduction to OneNote 2016 PA-2 |
|
|
|
Introduction to Sway PA-6 |
|
|
|
Introduction to Office Mix PA-10 |
|
|
|
Introduction to Microsoft Edge PA-14 |
|
|
Concepts |
|
|
Module 1: Understanding Essential Computer Concepts Concepts |
|
|
1 | (1) |
|
Recognize You Live and Work in the Digital World Concepts |
|
|
2 | (2) |
|
How to be a good online citizen |
|
|
|
Distinguish Types of Computers Concepts |
|
|
4 | (2) |
|
|
|
Identify Computer System Components Concepts |
|
|
6 | (2) |
|
About microprocessor speeds |
|
|
|
Compare Types of Memory Concepts |
|
|
8 | (2) |
|
|
|
Summarize Types of Storage Media Concepts |
|
|
10 | (2) |
|
|
|
Differentiate Between Input Devices Concepts |
|
|
12 | (2) |
|
Understanding assistive devices |
|
|
|
Explain Output Devices Concepts |
|
|
14 | (2) |
|
|
|
Describe Data Communications Concepts |
|
|
16 | (2) |
|
Understanding USB types and connectors |
|
|
|
How computers represent and interpret data |
|
|
|
Define Types of Networks Concepts |
|
|
18 | (2) |
|
Understanding telecommunications |
|
|
|
Assess Security Threats Concepts |
|
|
20 | (2) |
|
Understanding two-factor authentication |
|
|
|
Understand System Software Concepts |
|
|
22 | (2) |
|
Protecting information with passwords |
|
|
|
Examining Windows 10 hardware requirements |
|
|
|
Describe Types of Application Software Concepts |
|
|
24 | (2) |
|
|
26 | |
Windows 10* |
|
|
Module 1: Getting Started with Windows 10 Windows |
|
|
1 | (24) |
|
|
2 | (2) |
|
Using a touch screen with Windows |
|
|
|
Navigate the Desktop and Start Menu Windows |
|
|
4 | (2) |
|
Point, Click, and Drag Windows |
|
|
6 | (2) |
|
Selecting and moving items using touch-screen devices |
|
|
|
|
8 | (2) |
|
|
|
Work with a Window Windows |
|
|
10 | (2) |
|
Using the Quick Access toolbar |
|
|
|
Manage Multiple Windows Windows |
|
|
12 | (2) |
|
Use Buttons, Menus, and Dialog Boxes Windows |
|
|
14 | (2) |
|
|
16 | (2) |
|
|
|
|
18 | (2) |
|
Installing updates when you exit Windows |
|
|
|
|
20 | (5) |
|
Module 2: Understanding File Management Windows |
|
|
25 | |
|
Understand Files and Folders Windows |
|
|
26 | (2) |
|
Plan your file organization |
|
|
|
Create and Save a File Windows |
|
|
28 | (2) |
|
Explore the Files and Folders on Your Computer Windows |
|
|
30 | (2) |
|
Using and disabling Quick Access view |
|
|
|
Change File and Folder Views Windows |
|
|
32 | (2) |
|
Using the Windows Action Center |
|
|
|
|
|
Open, Edit, and Save Files Windows |
|
|
34 | (2) |
|
Comparing Save and Save As |
|
|
|
|
|
|
36 | (2) |
|
Copying files using Send to |
|
|
|
Move and Rename Files Windows |
|
|
38 | (2) |
|
Using Task View to create multiple desktops |
|
|
|
Search for Files and Folders Windows |
|
|
40 | (2) |
|
Using the Search Tools tab in File Explorer |
|
|
|
|
|
Delete and Restore Files Windows |
|
|
42 | (2) |
|
More techniques for selecting and moving files |
|
|
|
|
44 | |
Office 2016* |
|
|
Module 1: Getting Started with Microsoft Office 2016 Office |
|
|
1 | (1) |
|
Understand the Office 2016 Suite Office |
|
|
2 | (2) |
|
|
|
Start an Office App Office |
|
|
4 | (2) |
|
|
|
Using shortcut keys to move between Office programs |
|
|
|
Using the Office Clipboard |
|
|
|
Identify Office 2016 Screen Elements Office |
|
|
6 | (2) |
|
|
|
Create and Save a File Office |
|
|
8 | (2) |
|
|
|
Open a File and Save It with a New Name... Office |
|
|
10 | (2) |
|
Exploring File Open options |
|
|
|
Working in Compatibility Mode |
|
|
|
View and Print Your Work Office |
|
|
12 | (2) |
|
Customizing the Quick Access toolbar |
|
|
|
Creating a screen capture |
|
|
|
Get Help, Close a File, and Exit an App Office |
|
|
14 | (2) |
|
Using Sharing features and Co-authoring capabilities |
|
|
|
|
|
|
16 | |
Word 2016* |
|
|
Module 1: Creating Documents with Word 2016 Word |
|
|
1 | (24) |
|
Understand Word Processing Software Word |
|
|
2 | (2) |
|
|
|
Explore the Word Window Word |
|
|
4 | (2) |
|
|
6 | (2) |
|
|
8 | (2) |
|
|
10 | (2) |
|
Format Text Using the Mini Toolbar and the Ribbon Word |
|
|
12 | (2) |
|
Use a Document Template Word |
|
|
14 | (2) |
|
Using the Undo, Redo, and Repeat commands |
|
|
|
|
16 | (2) |
|
Using Word document views |
|
|
|
|
18 | (7) |
|
Module 2: Editing Documents Word |
|
|
25 | (24) |
|
|
26 | (2) |
|
|
|
|
28 | (2) |
|
Splitting the document window to copy and move items in a long document |
|
|
|
Use the Office Clipboard Word |
|
|
30 | (2) |
|
Copying and moving items between documents |
|
|
|
Find and Replace Text Word |
|
|
32 | (2) |
|
Navigating a document using the Navigation pane and the Go To command |
|
|
|
Check Spelling and Grammar Word |
|
|
34 | (2) |
|
|
|
Inserting text with AutoCorrect |
|
|
|
Research Information Word |
|
|
36 | (2) |
|
Publishing a blog directly from Word |
|
|
|
Using a dictionary and other add-ins for Word |
|
|
|
|
38 | (2) |
|
Sharing documents directly from Word, including e-mailing |
|
|
|
Work with Document Properties Word |
|
|
40 | (2) |
|
Viewing and modifying advanced document properties |
|
|
|
|
42 | (7) |
|
Module 3: Formatting Text and Paragraphs Word |
|
|
49 | (28) |
|
|
50 | (2) |
|
|
|
Use the Format Painter Word |
|
|
52 | (2) |
|
|
|
Change Line and Paragraph Spacing Word |
|
|
54 | (2) |
|
Formatting with Quick Styles |
|
|
|
|
56 | (2) |
|
Formatting a document using themes |
|
|
|
|
58 | (2) |
|
|
60 | (2) |
|
Applying text effects and clearing formatting |
|
|
|
Add Bullets and Numbering Word |
|
|
62 | (2) |
|
Creating multilevel lists |
|
|
|
Add Borders and Shading Word |
|
|
64 | (2) |
|
Highlighting text in a document |
|
|
|
Insert Online Pictures Word |
|
|
66 | (2) |
|
|
68 | (9) |
|
Module 4: Formatting Documents Word |
|
|
77 | |
|
Set Document Margins Word |
|
|
78 | (2) |
|
Changing orientation, margin settings, and paper size |
|
|
|
Create Sections and Columns Word |
|
|
80 | (2) |
|
Changing page layout settings for a section |
|
|
|
|
82 | (2) |
|
Controlling automatic pagination |
|
|
|
|
84 | (2) |
|
Moving around in a long document |
|
|
|
|
|
Add Headers and Footers Word |
|
|
86 | (2) |
|
Adding a custom header or footer to the gallery |
|
|
|
|
88 | (2) |
|
Add Footnotes and Endnotes Word |
|
|
90 | (2) |
|
Customizing the layout and formatting of footnotes and endnotes |
|
|
|
|
92 | (2) |
|
Manage Sources and Create a Bibliography Word |
|
|
94 | (2) |
|
|
|
|
96 | |
Excel 2016* |
|
|
Module 1: Getting Started with Excel 2016 Excel |
|
|
1 | (24) |
|
Understand Spreadsheet Software Excel |
|
|
2 | (2) |
|
Identify Excel 2016 Window Components Excel |
|
|
4 | (2) |
|
Using OneDrive and Office Online |
|
|
|
Understand Formulas Excel |
|
|
6 | (2) |
|
Enter Labels and Values and Use the AutoSum Button Excel |
|
|
8 | (2) |
|
|
|
|
10 | (2) |
|
Recovering unsaved changes to a workbook file |
|
|
|
Enter and Edit a Simple Formula Excel |
|
|
12 | (2) |
|
Understanding named ranges |
|
|
|
Switch Worksheet Views Excel |
|
|
14 | (2) |
|
Choose Print Options Excel |
|
|
16 | (2) |
|
Printing worksheet formulas |
|
|
|
|
|
|
18 | (7) |
|
Module 2: Working with Formulas and Functions Excel |
|
|
25 | (26) |
|
Create a Complex Formula Excel |
|
|
26 | (2) |
|
Using Add-ins to improve worksheet functionality |
|
|
|
Reviewing the order of precedence |
|
|
|
|
28 | (2) |
|
|
30 | (2) |
|
Using the COUNT and COUNTA functions |
|
|
|
Copy and Move Cell Entries Excel |
|
|
32 | (2) |
|
Inserting and deleting selected cells |
|
|
|
Understand Relative and Absolute Cell References Excel |
|
|
34 | (2) |
|
|
|
Copy Formulas with Relative Cell References Excel |
|
|
36 | (2) |
|
|
|
Copy Formulas with Absolute Cell References Excel |
|
|
38 | (2) |
|
Using the fill handle for sequential text or values |
|
|
|
Round a Value with a Function Excel |
|
|
40 | (2) |
|
|
|
Creating a new workbook using a template |
|
|
|
|
42 | (9) |
|
Module 3: Formatting a Worksheet Excel |
|
|
51 | (28) |
|
|
52 | (2) |
|
|
|
Change Font and Font Size Excel |
|
|
54 | (2) |
|
Inserting and adjusting online pictures and other images |
|
|
|
Change Font Styles and Alignment Excel |
|
|
56 | (2) |
|
Rotating and indenting cell entries |
|
|
|
Adjust Column Width Excel |
|
|
58 | (2) |
|
|
|
Insert and Delete Rows and Columns Excel |
|
|
60 | (2) |
|
Hiding and unhiding columns and rows |
|
|
|
Adding and editing comments |
|
|
|
Apply Colors, Patterns, and Borders Excel |
|
|
62 | (2) |
|
Working with themes and cell styles |
|
|
|
Apply Conditional Formatting Excel |
|
|
64 | (2) |
|
Managing conditional formatting rules |
|
|
|
Rename and Move a Worksheet Excel |
|
|
66 | (2) |
|
Copying, adding, and deleting worksheets |
|
|
|
|
68 | (2) |
|
|
|
|
70 | (9) |
|
Module 4: Working with Charts Excel |
|
|
79 | |
|
|
80 | (2) |
|
|
82 | (2) |
|
|
|
Move and Resize a Chart Excel |
|
|
84 | (2) |
|
Moving an embedded chart to a sheet |
|
|
|
Change the Chart Design Excel |
|
|
86 | (2) |
|
|
|
|
|
Change the Chart Format Excel |
|
|
88 | (2) |
|
Adding data labels to a chart |
|
|
|
|
90 | (2) |
|
|
|
Changing alignment and angle in axis labels and titles |
|
|
|
Annotate and Draw on a Chart Excel |
|
|
92 | (2) |
|
|
|
|
94 | (2) |
|
Using the Insert Chart dialog box to discover new chart types |
|
|
|
|
96 | |
Integration |
|
|
Module 1: Integrating Word and Excel Integration |
|
|
1 | (1) |
|
Integrate Data Between Word and Excel Integration |
|
|
2 | (2) |
|
Understanding object linking and embedding (OLE) |
|
|
|
Copy Data from Excel to Word Integration |
|
|
4 | (2) |
|
Copy a Chart from Excel to Word Integration |
|
|
6 | (2) |
|
Create Linked Objects Integration |
|
|
8 | (2) |
|
Opening linked files and reestablishing links to charts |
|
|
|
Embed a Word File in Excel Integration |
|
|
10 | (2) |
|
|
12 | |
Access 2016* |
|
|
Module 1: Getting Started with Access 2016 Access |
|
|
1 | (26) |
|
Understand Relational Databases Access |
|
|
2 | (2) |
|
Explore a Database Access |
|
|
4 | (2) |
|
|
6 | (2) |
|
|
8 | (2) |
|
Creating a table in Datasheet View |
|
|
|
Create Primary Keys Access |
|
|
10 | (2) |
|
|
|
Learning about field properties |
|
|
|
|
12 | (2) |
|
|
14 | (2) |
|
Changing from Navigation mode to Edit mode |
|
|
|
|
|
|
16 | (2) |
|
Resizing and moving datasheet columns |
|
|
|
|
18 | (9) |
|
Module 2: Building and Using Queries Access |
|
|
27 | (26) |
|
Use the Query Wizard Access |
|
|
28 | (2) |
|
|
|
Work with Data in a Query Access |
|
|
30 | (2) |
|
Hiding and unhiding fields in a datasheet |
|
|
|
Freezing and unfreezing fields in a datasheet |
|
|
|
Use Query Design View Access |
|
|
32 | (2) |
|
Adding or deleting a table in a query |
|
|
|
Sort and Find Data Access |
|
|
34 | (2) |
|
|
36 | (2) |
|
Using wildcard characters |
|
|
|
Apply AND Criteria Access |
|
|
38 | (2) |
|
Searching for blank fields |
|
|
|
|
40 | (2) |
|
Format a Datasheet Access |
|
|
42 | (2) |
|
|
44 | (9) |
|
Module 3: Using Forms Access |
|
|
53 | (26) |
|
Use the Form Wizard Access |
|
|
54 | (2) |
|
Create a Split Form Access |
|
|
56 | (2) |
|
Use Form Layout View Access |
|
|
58 | (2) |
|
|
|
Add Fields to a Form Access |
|
|
60 | (2) |
|
Bound versus unbound controls |
|
|
|
Modify Form Controls Access |
|
|
62 | (2) |
|
Create Calculations Access |
|
|
64 | (2) |
|
|
66 | (2) |
|
|
|
|
68 | (2) |
|
Applying a background image |
|
|
|
|
70 | (9) |
|
Module 4: Using Reports Access |
|
|
79 | |
|
Use the Report Wizard Access |
|
|
80 | (2) |
|
Changing page orientation |
|
|
|
Use Report Layout View Access |
|
|
82 | (2) |
|
Review Report Sections Access |
|
|
84 | (2) |
|
Apply Group and Sort Orders Access |
|
|
86 | (2) |
|
|
|
Add Subtotals and Counts Access |
|
|
88 | (2) |
|
Resize and Align Controls Access |
|
|
90 | (2) |
|
Precisely moving and resizing controls |
|
|
|
|
92 | (2) |
|
Create Mailing Labels Access |
|
|
94 | (2) |
|
|
96 | |
Integration |
|
|
Module 2: Integrating Word, Excel, and Access Integration |
|
|
17 | |
|
Integrate Data Among Word, Excel, and Access Integration |
|
|
18 | (2) |
|
Import an Excel Worksheet into Access Integration |
|
|
20 | (2) |
|
Copy a Word Table to Access Integration |
|
|
22 | (2) |
|
Link an Access Table to Excel and Word Integration |
|
|
24 | (2) |
|
Link an Access Table to Word Integration |
|
|
26 | (2) |
|
Opening linked files and enabling content |
|
|
|
|
28 | |
Powerpoint 2016* |
|
|
Module 1: Creating a Presentation in PowerPoint 2016 Powerpoint |
|
|
1 | (24) |
|
Define Presentation Software Powerpoint |
|
|
2 | (2) |
|
Using PowerPoint on a touch screen |
|
|
|
Plan an Effective Presentation Powerpoint |
|
|
4 | (2) |
|
|
|
Examine the PowerPoint Window Powerpoint |
|
|
6 | (2) |
|
Viewing your presentation in gray scale or black and white |
|
|
|
Enter Slide Text Powerpoint |
|
|
8 | (2) |
|
|
|
Add a New Slide Powerpoint |
|
|
10 | (2) |
|
Entering and printing notes |
|
|
|
Apply a Design Theme Powerpoint |
|
|
12 | (2) |
|
|
|
Compare Presentation Views Powerpoint |
|
|
14 | (2) |
|
Print a PowerPoint Presentation Powerpoint |
|
|
16 | (2) |
|
Microsoft Office Online Apps |
|
|
|
|
18 | (7) |
|
Module 2: Modifying a Presentation Powerpoint |
|
|
25 | (24) |
|
Enter Text in Outline View Powerpoint |
|
|
26 | (2) |
|
Using proofing tools for other languages |
|
|
|
|
28 | (2) |
|
|
|
Convert Text to SmartArt Powerpoint |
|
|
30 | (2) |
|
Choosing SmartArt graphics |
|
|
|
Insert and Modify Shapes Powerpoint |
|
|
32 | (2) |
|
Using the Eyedropper to match colors |
|
|
|
Rearrange and Merge Shapes Powerpoint |
|
|
34 | (2) |
|
Changing the size and position of shapes |
|
|
|
Edit and Duplicate Shapes Powerpoint |
|
|
36 | (2) |
|
Editing points of a shape |
|
|
|
Align and Group Objects Powerpoint |
|
|
38 | (2) |
|
|
|
Add Slide Footers Powerpoint |
|
|
40 | (2) |
|
Creating superscript and subscript text |
|
|
|
|
42 | (7) |
|
Module 3: Inserting Objects into a Presentation Powerpoint |
|
|
49 | (24) |
|
Insert Text from Microsoft Word Powerpoint |
|
|
50 | (2) |
|
Sending a presentation using email |
|
|
|
Insert and Style a Picture Powerpoint |
|
|
52 | (2) |
|
Inserting a screen recording |
|
|
|
Insert a Text Box Powerpoint |
|
|
54 | (2) |
|
Changing text box defaults |
|
|
|
Insert a Chart Powerpoint |
|
|
56 | (2) |
|
Enter and Edit Chart Data Powerpoint |
|
|
58 | (2) |
|
Adding a hyperlink to a chart |
|
|
|
Insert Slides from Other Presentations Powerpoint |
|
|
60 | (2) |
|
Working with multiple windows |
|
|
|
Insert a Table Powerpoint |
|
|
62 | (2) |
|
|
|
Insert and Format WordArt Powerpoint |
|
|
64 | (2) |
|
Saving a presentation as a video |
|
|
|
|
66 | (7) |
|
Module 4: Finishing a Presentation Powerpoint |
|
|
73 | |
|
Modify Masters Powerpoint |
|
|
74 | (2) |
|
Create custom slide layouts |
|
|
|
Customize the Background and Theme Powerpoint |
|
|
76 | (2) |
|
Use Slide Show Commands Powerpoint |
|
|
78 | (2) |
|
Set Slide Transitions and Timings Powerpoint |
|
|
80 | (2) |
|
Rehearsing slide show timings |
|
|
|
Animate Objects Powerpoint |
|
|
82 | (2) |
|
Attaching a sound to an animation |
|
|
|
Use Proofing and Language Tools Powerpoint |
|
|
84 | (2) |
|
Checking spelling as you type |
|
|
|
Inspect a Presentation Powerpoint |
|
|
86 | (2) |
|
Digitally sign a presentation |
|
|
|
Create an Office Mix Powerpoint |
|
|
88 | (2) |
|
Inserting an interactive quiz |
|
|
|
|
90 | |
Integration |
|
|
Module 3: Integrating Word, Excel, Access, and PowerPoint Integration |
|
|
33 | |
|
Integrate Data Among Word, Excel, Access, and PowerPoint Integration |
|
|
34 | (2) |
|
Import a Word Outline into PowerPoint Integration |
|
|
36 | (2) |
|
Embed an Excel Worksheet in PowerPoint Integration |
|
|
38 | (2) |
|
Link Access and Excel Objects to PowerPoint Integration |
|
|
40 | (2) |
|
|
42 | (2) |
|
|
44 | |
Outlook 2016* |
|
|
Module 1: Getting Started with Email Outlook |
|
|
1 | (24) |
|
Communicate with Email Outlook |
|
|
2 | (2) |
|
Use Email Addresses Outlook |
|
|
4 | (2) |
|
Create and Send Emails Outlook |
|
|
6 | (2) |
|
Understanding message headers in emails you receive |
|
|
|
Understand Email Folders Outlook |
|
|
8 | (2) |
|
|
|
Receive and Reply to Emails Outlook |
|
|
10 | (2) |
|
Setting up vacation responses |
|
|
|
|
12 | (2) |
|
|
|
Flagging or labeling messages |
|
|
|
Send Email Attachments Outlook |
|
|
14 | (2) |
|
Reviewing options when sending messages |
|
|
|
Employ Good Email Practices Outlook |
|
|
16 | (2) |
|
Creating distribution lists |
|
|
|
|
18 | (7) |
|
Module 2: Managing Information Using Outlook Outlook |
|
|
25 | |
|
|
26 | (2) |
|
|
|
|
28 | (2) |
|
Manage Your Contacts Outlook |
|
|
30 | (2) |
|
Manage Your Calendar Outlook |
|
|
32 | (2) |
|
Sending electronic business cards |
|
|
|
|
34 | (2) |
|
|
36 | (2) |
|
Connect Mail to Contacts Outlook |
|
|
38 | (2) |
|
|
40 | (2) |
|
|
|
|
42 | |
Glossary Glossary |
|
1 | (16) |
Index Index |
|
17 | |