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