Productivity Apps |
|
Productivity Apps for School and Work |
|
1 | (1) |
Introduction to OneNote 2016 |
|
2 | (4) |
Introduction to Sway |
|
6 | (4) |
Introduction to Office Mix |
|
10 | (4) |
Introduction to Microsoft Edge |
|
14 | |
|
|
|
Module 1 Computer and Internet Basics |
|
|
1 | (22) |
|
|
2 | (2) |
|
|
4 | (2) |
|
Understanding the importance of stored programs |
|
|
|
|
6 | (2) |
|
|
|
|
8 | (2) |
|
|
10 | (2) |
|
|
12 | (2) |
|
Working in the cloud and using web apps How to Communicate Using Digital Devices |
|
|
14 | (2) |
|
|
|
How to Protect Your Privacy, Data, and Devices Concepts |
|
|
16 | (2) |
|
Key Terms & Module Review |
|
|
18 | (1) |
|
|
19 | (1) |
|
|
20 | (2) |
|
|
22 | (1) |
|
Module 2 Computer Hardware |
|
|
23 | (22) |
|
|
24 | (2) |
|
Dedicated mobile digital devices Display Devices |
|
|
26 | (2) |
|
|
28 | (2) |
|
Options for printing your photos Data Storage---An Overview |
|
|
30 | (2) |
|
Maintaining your hardware Data Storage Systems Features |
|
|
32 | (2) |
|
Non-technical words used to describe using a data storage system |
|
|
|
Optical Data Storage Systems |
|
|
34 | (2) |
|
Understanding hard drive partitions |
|
|
|
Viewing your data storage systems using File Explorer |
|
|
|
Solid-State Data Storage Systems |
|
|
36 | (2) |
|
How to Add Devices to Your Computer |
|
|
38 | (2) |
|
Key Terms & Module Review |
|
|
40 | (1) |
|
|
41 | (1) |
|
|
42 | (2) |
|
|
44 | (1) |
|
Module 3 Computer Software |
|
|
45 | (24) |
|
|
46 | (2) |
|
Installed software that comes with new personal computers |
|
|
|
|
48 | (2) |
|
How does digital technology affect intellectual property laws? |
|
|
|
How To Install and Uninstall Software |
|
|
50 | (2) |
|
Operating Systems---An Overview |
|
|
52 | (2) |
|
Operating Systems---A Comparison |
|
|
54 | (2) |
|
Comparing types of operating systems Utility Software |
|
|
56 | (2) |
|
Office Productivity Software |
|
|
58 | (2) |
|
|
|
Other productivity software |
|
|
|
|
60 | (2) |
|
|
|
Other Application Software |
|
|
62 | (2) |
|
Key Terms & Module Review |
|
|
64 | (1) |
|
|
65 | (1) |
|
|
66 | (2) |
|
|
68 | (1) |
|
Module 4 File Management and Digital Electronics |
|
|
69 | |
|
|
70 | (2) |
|
|
72 | (2) |
|
Folders and subfolders vs. directories and subdirectories |
|
|
|
|
74 | (2) |
|
How to Manage Computer Files |
|
|
76 | (2) |
|
Deleting folders and files |
|
|
|
How Computers Represent Data |
|
|
78 | (2) |
|
More about bits and bytes |
|
|
|
Integrated Circuits---An Overview |
|
|
80 | (2) |
|
|
82 | (2) |
|
How the processor gets instructions |
|
|
|
|
84 | (2) |
|
Other Types of Computer Memory |
|
|
86 | (2) |
|
Understanding remote vs. cloud storage? |
|
|
|
Key Terms & Module Review |
|
|
88 | (1) |
|
|
89 | (1) |
|
|
90 | (2) |
|
|
92 | (1) |
|
|
93 | |
|
|
|
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 |
|
|
|
|
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 Customizing Details view |
|
|
|
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 | (4) |
|
|
|
|
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 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) |
|
|
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 Add Hyperlinks |
|
|
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 Insert Page Breaks |
|
|
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 Scaling to fit |
|
|
|
|
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 Insert a Function |
|
|
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 References |
|
|
34 | (2) |
|
|
|
Copy Formulas with Relative Cell References |
|
|
36 | (2) |
|
|
|
Copy Formulas with Absolute Cell References |
|
|
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 Practice |
|
|
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 Adjust Column Width |
|
|
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 Change the Chart Design |
|
|
86 | (2) |
|
|
|
|
|
|
88 | (2) |
|
Adding data labels to a chart Format 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 Access |
|
|
1 | (26) |
|
Understand Relational Databases |
|
|
2 | (2) |
|
|
4 | (2) |
|
|
6 | (2) |
|
|
8 | (2) |
|
Creating a table in Datasheet View Create Primary Keys |
|
|
10 | (2) |
|
|
|
Learning about field properties |
|
|
|
|
12 | (2) |
|
|
14 | (2) |
|
Changing from Navigation mode to Edit mode Cloudcomputing Edit Data |
|
|
16 | (2) |
|
Resizing and moving datasheet columns Practice |
|
|
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 Sort and Find Data |
|
|
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 Practice |
|
|
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 Format a Report |
|
|
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 Practice |
|
|
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) |
|
|
|
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 Practice |
|
|
42 | (7) |
|
Module 3 Inserting Objects into a Presentation |
|
|
49 | (24) |
|
Insert Text from Microsoft Word |
|
|
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 Understand Email Folders |
|
|
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 Practice |
|
|
18 | (7) |
|
Module 2 Managing Information Using |
|
|
25 | |
|
|
26 | (2) |
|
|
|
|
28 | (2) |
|
|
30 | (2) |
|
|
32 | (2) |
|
Sending electronic business cards Manage Tasks |
|
|
34 | (2) |
|
|
36 | (2) |
|
|
38 | (2) |
|
|
40 | (2) |
|
Coordinating calendars Practice |
|
|
42 | |
Glossary |
|
1 | (25) |
Index |
|
26 | |