Productivity App |
|
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 Computer and Internet Basics |
|
|
1 | (22) |
|
|
2 | (2) |
|
|
4 | (2) |
|
Understanding the importance of stored programs Types of Computers |
|
|
6 | (2) |
|
Video game consoles Personal Computers |
|
|
8 | (2) |
|
|
10 | (2) |
|
|
12 | (2) |
|
Working in the cloud and using web apps How to Communicate Using Digital Devices |
|
|
14 | (2) |
|
What is spam? How to Protect Your Privacy, Data, and Devices |
|
|
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 Licenses and Copyrights |
|
|
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) |
|
Software suites Other productivity software Graphics Software |
|
|
60 | (2) |
|
Using data responsibly 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 | (1) |
|
|
70 | (2) |
|
|
72 | (2) |
|
Folders and subfolders vs. directories and subdirectories Computer File Basics |
|
|
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 Computer Memory: RAM |
|
|
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 Start an App |
|
|
8 | (2) |
|
Using the Windows Store Work with a Window |
|
|
10 | (2) |
|
Using the Quick Access toolbar Manage Multiple Windows |
|
|
12 | (2) |
|
Use Buttons, Menus, and Dialog Boxes |
|
|
14 | (2) |
|
|
16 | (2) |
|
Using Cortana Exit Windows 10 |
|
|
18 | (2) |
|
Installing updates when you exit Windows Practice |
|
|
20 | (5) |
|
Module 2 Understanding File Management |
|
|
25 | (1) |
|
Understand Files and Folders |
|
|
26 | (2) |
|
Plan your file organization Create and Save a File |
|
|
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 Copy Files |
|
|
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 Delete and Restore Files |
|
|
42 | (2) |
|
More techniques for selecting and moving files Practice |
|
|
44 | |
|
|
|
Module 1 Getting Started with Microsoft Office 2016 |
|
|
1 | (1) |
|
Understand the Office 2016 Suite |
|
|
2 | (2) |
|
What is Office 365? Start an Office App |
|
|
4 | (2) |
|
Enabling touch mode Using shortcut keys to move between Office programs Using the Office Clipboard Identify Office 2016 Screen Elements |
|
|
6 | (2) |
|
Using Backstage view Create and Save a File |
|
|
8 | (2) |
|
Saving files to OneDrive Open a File and Save It with a New Name |
|
|
10 | (2) |
|
Exploring File Open options Working in Compatibility Mode View and Print Your Work |
|
|
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 Recovering a document Practice |
|
|
16 | |
|
|
|
Module 1 Creating Documents with Word 2016 |
|
|
1 | (24) |
|
Understand Word Processing Software |
|
|
2 | (2) |
|
Planning a document Explore the Word Window |
|
|
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 Navigate a Document |
|
|
16 | (2) |
|
Using Word document views Practice |
|
|
18 | (7) |
|
Module 2 Editing Documents |
|
|
25 | (24) |
|
|
26 | (2) |
|
Using keyboard shortcuts Copy and Paste Text |
|
|
28 | (2) |
|
Splitting the document window to copy and move items in a long document Use the Office Clipboard |
|
|
30 | (2) |
|
Copying and moving items between documents Find and Replace Text |
|
|
32 | (2) |
|
Navigating a document using the Navigation pane and the Go To command Check Spelling and Grammar |
|
|
34 | (2) |
|
Using Smart Lookup Inserting text with AutoCorrect Research Information |
|
|
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 Practice |
|
|
42 | (7) |
|
Module 3 Formatting Text and Paragraphs |
|
|
49 | (28) |
|
|
50 | (2) |
|
Adding a drop cap Use the Format Painter |
|
|
52 | (2) |
|
Underlining text Change Line and Paragraph Spacing |
|
|
54 | (2) |
|
Formatting with Quick Styles Align Paragraphs |
|
|
56 | (2) |
|
Formatting a document using themes Work with Tabs |
|
|
58 | (2) |
|
|
60 | (2) |
|
Applying text effects and clearing formatting Add Bullets and Numbering |
|
|
62 | (2) |
|
Creating multilevel lists Add Borders and Shading |
|
|
64 | (2) |
|
Highlighting text in a document Insert Online Pictures |
|
|
66 | (2) |
|
|
68 | (9) |
|
Module 4 Formatting Documents Word |
|
|
77 | (1) |
|
|
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 Insert Page Numbers |
|
|
84 | (2) |
|
Moving around in a long document Inserting Quick Parts Add Headers and Footers |
|
|
86 | (2) |
|
Adding a custom header or footer to the gallery Insert a Table |
|
|
88 | (2) |
|
Add Footnotes and Endnotes |
|
|
90 | (2) |
|
Customizing the layout and formatting of footnotes and endnotes\ Insert Citations |
|
|
92 | (2) |
|
Manage Sources and Create a Bibliography |
|
|
94 | (2) |
|
Working with Web sources Practice |
|
|
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 Understand Formulas |
|
|
6 | (2) |
|
Enter Labels and Values and Use the AutoSum Button |
|
|
8 | (2) |
|
Navigating a worksheet Edit Cell Entries |
|
|
10 | (2) |
|
Recovering unsaved changes to a workbook file Enter and Edit a Simple Formula |
|
|
12 | (2) |
|
Understanding named ranges Switch Worksheet Views |
|
|
14 | (2) |
|
|
16 | (2) |
|
Printing worksheet formulas Scaling to fit Practice |
|
|
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) |
|
Using a mixed reference Copy Formulas with Relative Cell References |
|
|
36 | (2) |
|
Using Paste Preview 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) |
|
Using Auto Fill options Creating a new workbook using a template Practice |
|
|
42 | (9) |
|
Module 3 Formatting a Worksheet |
|
|
51 | (28) |
|
|
52 | (2) |
|
Formatting as a table 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) |
|
Changing row height 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 Check Spelling |
|
|
68 | (2) |
|
Emailing a workbook Practice |
|
|
70 | (9) |
|
Module 4 Working with Charts |
|
|
79 | (1) |
|
|
80 | (2) |
|
|
82 | (2) |
|
Creating sparklines Move and Resize a Chart |
|
|
84 | (2) |
|
Moving an embedded chart to a sheet Change the Chart Design |
|
|
86 | (2) |
|
Creating a combo chart Working with a 3-D chart Change the Chart Format |
|
|
88 | (2) |
|
Adding data labels to a chart Format a Chart |
|
|
90 | (2) |
|
Previewing a chart Changing alignment and angle in axis labels and titles Annotate and Draw on a Chart |
|
|
92 | (2) |
|
Adding SmartArt graphics Create a Pie Chart |
|
|
94 | (2) |
|
Using the Insert Chart dialog box to discover new chart types Practice |
|
|
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 Create Primary Keys |
|
|
10 | (2) |
|
Object views Learning about field properties Relate Two Tables |
|
|
12 | (2) |
|
|
14 | (2) |
|
Changing from Navigation mode to Edit mode Cloud computing Edit Data |
|
|
16 | (2) |
|
Resizing and moving datasheet columns Practice |
|
|
18 | (9) |
|
Module 2 Building and Using Queries |
|
|
27 | (26) |
|
|
28 | (2) |
|
Simple Query Wizard Work with Data in a Query |
|
|
30 | (2) |
|
Hiding and unhiding fields in a datasheet Freezing and unfreezing fields in a datasheet Use Query Design View |
|
|
32 | (2) |
|
Adding or deleting a table in a query Sort and Find Data |
|
|
34 | (2) |
|
|
36 | (2) |
|
Using wildcard characters Apply AND Criteria |
|
|
38 | (2) |
|
Searching for blank fields Apply OR Criteria |
|
|
40 | (2) |
|
|
42 | (2) |
|
|
44 | (9) |
|
|
53 | (26) |
|
|
54 | (2) |
|
|
56 | (2) |
|
|
58 | (2) |
|
Table layouts Add Fields to a Form |
|
|
60 | (2) |
|
Bound versus unbound controls Modify Form Controls |
|
|
62 | (2) |
|
|
64 | (2) |
|
|
66 | (2) |
|
Form layouts Insert an Image |
|
|
68 | (2) |
|
Applying a background image Practice |
|
|
70 | (9) |
|
|
79 | (1) |
|
|
80 | (2) |
|
Changing page orientation Use Report Layout View |
|
|
82 | (2) |
|
|
84 | (2) |
|
Apply Group and Sort Orders |
|
|
86 | (2) |
|
Record Source Property Add Subtotals and Counts |
|
|
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) |
|
Understanding copyright Examine the PowerPoint Window |
|
|
6 | (2) |
|
Viewing your presentation in gray scale or black and white Enter Slide Text |
|
|
8 | (2) |
|
Inking a slide Add a New Slide |
|
|
10 | (2) |
|
Entering and printing notes Apply a Design Theme |
|
|
12 | (2) |
|
Customizing themes Compare Presentation Views |
|
|
14 | (2) |
|
Print a PowerPoint Presentation |
|
|
16 | (2) |
|
Microsoft Office Online Apps Practice |
|
|
18 | (7) |
|
Module 2 Modifying a Presentation |
|
|
25 | (24) |
|
Enter Text in Outline View |
|
|
26 | (2) |
|
Using proofing tools for other languages Format Text |
|
|
28 | (2) |
|
Replacing text and fonts Convert Text to SmartArt |
|
|
30 | (2) |
|
Choosing SmartArt graphics Insert and Modify Shapes |
|
|
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 Align and Group Objects |
|
|
38 | (2) |
|
Distributing objects Add Slide Footers |
|
|
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 Insert a Text Box |
|
|
54 | (2) |
|
Changing text box defaults Insert a Chart |
|
|
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 Insert a Table |
|
|
62 | (2) |
|
Setting permissions Insert and Format WordArt |
|
|
64 | (2) |
|
Saving a presentation as a video Practice |
|
|
66 | (7) |
|
Module 4 Finishing a Presentation |
|
|
73 | (1) |
|
|
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 Animate Objects |
|
|
82 | (2) |
|
Attaching a sound to an animation Use Proofing and Language Tools |
|
|
84 | (2) |
|
Checking spelling as you type Inspect a Presentation |
|
|
86 | (2) |
|
Digitally sign a presentation Create an Office Mix |
|
|
88 | (2) |
|
Inserting an interactive quiz Practice |
|
|
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) |
|
Managing your email Receive and Reply to Emails |
|
|
10 | (2) |
|
Setting up vacation responses Forward Emails |
|
|
12 | (2) |
|
Controlling your message Flagging or labeling messages Send Email Attachments |
|
|
14 | (2) |
|
Reviewing options when sending messages Employ Good Email Practices |
|
|
16 | (2) |
|
Creating distribution lists Practice |
|
|
18 | (7) |
|
Module 2 Managing Information Using Outlook |
|
|
25 | (1) |
|
|
26 | (2) |
|
Weather in Calendar view Organize Email |
|
|
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 | |