Preface |
|
xviii | |
Student Success Guide |
|
|
Student Success Guide: On the Path to Success |
|
|
Student Success 1 | |
|
|
Student Success 2 | |
|
Quick Tour of Microsoft OneNote |
|
|
Student Success 3 | |
|
|
|
|
Student Success 4 | |
|
|
Student Success 6 | |
|
Create To-Do Lists in OneNote |
|
|
Student Success 8 | |
|
Set Limits on Screen Time |
|
|
|
|
Student Success 10 | |
|
Use Technology to Collaborate |
|
|
Student Success 12 | |
|
Critical Thinking and Problem Solving |
|
|
Student Success 13 | |
|
Follow a Process for Critical Thinking |
|
|
Student Success 14 | |
|
Think Critically About Information on the Internet |
|
|
Student Success 16 | |
|
|
Concepts 2013 |
|
|
Unit A Understanding Essential Computer Concepts |
|
|
Concepts 1 | |
|
Recognize You Live and Work in the Digital World |
|
|
Concepts 2 | |
|
How to be a good online citizen |
|
|
|
Distinguish Types of Computers |
|
|
Concepts 4 | |
|
Computers are more personal than ever |
|
|
|
Identify Computer System Components |
|
|
Concepts 6 | |
|
About microprocessor speeds |
|
|
|
|
Concepts 8 | |
|
|
|
Summarize Types of Storage Media |
|
|
Concepts 10 | |
|
Rewriting on optical storage |
|
|
|
Differentiate Between Input Devices |
|
|
Concepts 12 | |
|
Understanding assistive devices |
|
|
|
|
Concepts 14 | |
|
About multifunction printers |
|
|
|
Describe Data Communications |
|
|
Concepts 16 | |
|
How computers represent and interpret data |
|
|
|
|
Concepts 18 | |
|
Understanding telecommunications |
|
|
|
|
Concepts 20 | |
|
Protecting information with passwords |
|
|
|
Understand System Software |
|
|
Concepts 22 | |
|
Examining Windows 8 hardware requirements |
|
|
|
Describe Types of Application Software |
|
|
Concepts 24 | |
|
|
Concepts 26 | |
Windows 8 |
|
|
Unit A Getting Started with Windows 8 |
|
|
Windows 1 | |
|
|
Windows 2 | |
|
|
|
Navigate the Start Screen and Desktop |
|
|
Windows 4 | |
|
|
Windows 6 | |
|
Using newer touch devices |
|
|
|
|
Windows 8 | |
|
Searching for apps and files |
|
|
|
|
Windows 10 | |
|
Using the Quick Access toolbar |
|
|
|
|
Windows 12 | |
|
Use Command Buttons, Menus, and Dialog Boxes |
|
|
Windows 14 | |
|
|
Windows 16 | |
|
Finding other ways to get help |
|
|
|
|
|
|
Windows 18 | |
|
Installing updates when you exit Windows |
|
|
|
|
Windows 20 | |
|
Unit B Understanding File Management |
|
|
Windows 25 | |
|
Understand Files and Folders |
|
|
Windows 26 | |
|
Plan your file organization |
|
|
|
|
Windows 28 | |
|
Explore the Files and Folders on Your Computer |
|
|
Windows 30 | |
|
Change File and Folder Views |
|
|
Windows 32 | |
|
|
|
Open, Edit, and Save Files |
|
|
Windows 34 | |
|
Comparing Save and Save As |
|
|
|
|
|
|
Windows 36 | |
|
Copying files using Send to |
|
|
|
|
Windows 38 | |
|
Using Windows 8 libraries |
|
|
|
Search for Files, Folders, and Programs |
|
|
Windows 40 | |
|
Using the Search Tools tab in File Explorer |
|
|
|
|
Windows 42 | |
|
More techniques for selecting and moving files |
|
|
|
|
Windows 44 | |
Internet Explorer 10 |
|
|
Unit A Getting Started with Internet Explorer 10 |
|
|
Internet 1 | |
|
|
Internet 2 | |
|
Internet Explorer 10 Metro version |
|
|
|
|
Internet 4 | |
|
Understanding the status bar |
|
|
|
|
Internet 6 | |
|
|
|
|
Internet 8 | |
|
|
|
|
Internet 10 | |
|
Creating and organizing favorites |
|
|
|
|
Internet 12 | |
|
Phishing and the SmartScreen Filter |
|
|
|
|
Internet 14 | |
|
|
|
|
Internet 16 | |
|
|
|
|
Internet 18 | |
|
Building an international community |
|
|
Office 2013 |
|
|
Unit A Getting Started with Microsoft Office 2013 |
|
|
Office 1 | |
|
Understand the Office 2013 Suite |
|
|
Office 2 | |
|
|
|
|
Office 4 | |
|
Starting an app using Windows 7 |
|
|
|
Using shortcut keys to move between Office programs |
|
|
|
Using the Office Clipboard |
|
|
|
Identify Office 2013 Screen Elements |
|
|
Office 6 | |
|
|
|
|
Office 8 | |
|
|
|
Open a File and Save It with a New Name |
|
|
Office 10 | |
|
Exploring File Open options |
|
|
|
Working in Compatibility Mode |
|
|
|
|
Office 12 | |
|
Customizing the Quick Access toolbar |
|
|
|
Creating a screen capture |
|
|
|
Get Help, Close a File, and Exit an App |
|
|
Office 14 | |
|
|
|
|
|
|
Office 16 | |
Word 2013 |
|
|
Unit A Creating Documents with Word 2013 |
|
|
Word 1 | |
|
Understand Word Processing Software |
|
|
Word 2 | |
|
|
|
|
Word 4 | |
|
|
Word 6 | |
|
|
Word 8 | |
|
Microsoft SkyDrive and Microsoft Office Web Apps |
|
|
|
|
Word 10 | |
|
Format Text Using the Mini Toolbar and the Ribbon |
|
|
Word 12 | |
|
|
Word 14 | |
|
Using the Undo, Redo, and Repeat commands |
|
|
|
|
Word 16 | |
|
Using Word document views |
|
|
|
|
Word 18 | |
|
|
Word 25 | |
|
|
Word 26 | |
|
|
|
|
Word 28 | |
|
Splitting the document window to copy and move items in a long document |
|
|
|
|
Word 30 | |
|
Copying and moving items between documents |
|
|
|
|
Word 32 | |
|
Navigating a document using the Navigation pane and the Go To command |
|
|
|
Check Spelling and Grammar |
|
|
Word 34 | |
|
Inserting text with AutoCorrect |
|
|
|
|
Word 36 | |
|
Publishing a blog directly from Word |
|
|
|
Using a dictionary and other apps for Word |
|
|
|
|
Word 38 | |
|
Sharing documents directly from Word, including e-mailing and faxing |
|
|
|
Work with Document Properties |
|
|
Word 40 | |
|
Viewing and modifying advanced document properties |
|
|
|
|
Word 42 | |
|
Unit C Formatting Text and Paragraphs |
|
|
Word 49 | |
|
|
Word 50 | |
|
|
|
|
Word 52 | |
|
|
|
Change Line and Paragraph Spacing |
|
|
Word 54 | |
|
Formatting with Quick Styles |
|
|
|
|
Word 56 | |
|
Formatting a document using themes |
|
|
|
|
Word 58 | |
|
|
Word 60 | |
|
Applying text effects and clearing formatting |
|
|
|
Add Bullets and Numbering |
|
|
Word 62 | |
|
Creating multilevel lists |
|
|
|
|
Word 64 | |
|
Highlighting text in a document |
|
|
|
|
Word 66 | |
|
|
Word 68 | |
|
Unit D Formatting Documents |
|
|
Word 77 | |
|
|
Word 78 | |
|
Changing orientation, margin settings, and paper size |
|
|
|
Create Sections and Columns |
|
|
Word 80 | |
|
Changing page layout settings for a section |
|
|
|
|
Word 82 | |
|
Controlling automatic pagination |
|
|
|
|
Word 84 | |
|
Moving around in a long document |
|
|
|
|
|
|
Word 86 | |
|
Adding a custom header or footer to the gallery |
|
|
|
|
Word 88 | |
|
Add Footnotes and Endnotes |
|
|
Word 90 | |
|
Customizing the layout and formatting of footnotes and endnotes |
|
|
|
|
Word 92 | |
|
Manage Sources and Create a Bibliography |
|
|
Word 94 | |
|
|
|
|
Word 96 | |
Excel 2013 |
|
|
Unit A Getting Started with Excel 2013 |
|
|
Excel 1 | |
|
Understand Spreadsheet Software |
|
|
Excel 2 | |
|
Identify Excel 2013 Window Components |
|
|
Excel 4 | |
|
Using SkyDrive and Web Apps |
|
|
|
|
Excel 6 | |
|
Enter Labels and Values and Use the AutoSum Button |
|
|
Excel 8 | |
|
|
|
|
Excel 10 | |
|
Recovering unsaved changes to a workbook file |
|
|
|
Enter and Edit a Simple Formula |
|
|
Excel 12 | |
|
Understanding named ranges |
|
|
|
|
Excel 14 | |
|
|
Excel 16 | |
|
Printing worksheet formulas |
|
|
|
|
|
|
Excel 18 | |
|
Unit B Working with Formulas and Functions |
|
|
Excel 25 | |
|
|
Excel 26 | |
|
Using Apps for Office to improve worksheet functionality Reviewing the order of precedence |
|
|
|
|
Excel 28 | |
|
|
Excel 30 | |
|
Using the COUNT and COUNTA functions |
|
|
|
Copy and Move Cell Entries |
|
|
Excel 32 | |
|
Inserting and deleting selected cells |
|
|
|
Understand Relative and Absolute Cell References |
|
|
Excel 34 | |
|
|
|
Copy Formulas with Relative Cell References |
|
|
Excel 36 | |
|
|
|
|
|
Copy Formulas with Absolute Cell References |
|
|
Excel 38 | |
|
Using the fill handle for sequential text or values |
|
|
|
Round a Value with a Function |
|
|
Excel 40 | |
|
Creating a new workbook using a template |
|
|
|
|
Excel 42 | |
|
Unit C Formatting a Worksheet |
|
|
Excel 51 | |
|
|
Excel 52 | |
|
|
|
Change Font and Font Size |
|
|
Excel 54 | |
|
Inserting and adjusting online pictures and other images |
|
|
|
Change Font Styles and Alignment |
|
|
Excel 56 | |
|
Rotating and indenting cell entries |
|
|
|
|
Excel 58 | |
|
|
|
Insert and Delete Rows and Columns |
|
|
Excel 60 | |
|
Hiding and unhiding columns and rows |
|
|
|
Adding and editing comments |
|
|
|
Apply Colors, Patterns, and Borders |
|
|
Excel 62 | |
|
Working with themes and cell styles |
|
|
|
Apply Conditional Formatting |
|
|
Excel 64 | |
|
Managing conditional formatting rules |
|
|
|
Rename and Move a Worksheet |
|
|
Excel 66 | |
|
Copying, Adding, and Deleting worksheets |
|
|
|
|
Excel 68 | |
|
|
|
|
Excel 70 | |
|
Unit D Working with Charts |
|
|
Excel 79 | |
|
|
Excel 80 | |
|
|
Excel 82 | |
|
|
|
|
Excel 84 | |
|
Moving an embedded chart to a sheet |
|
|
|
|
Excel 86 | |
|
Creating a combination chart |
|
|
|
|
|
|
Excel 88 | |
|
Adding data labels to a chart |
|
|
|
|
Excel 90 | |
|
|
|
Changing alignment and angle in axis labels and titles |
|
|
|
Annotate and Draw on a Chart |
|
|
Excel 92 | |
|
|
|
|
Excel 94 | |
|
|
Excel 96 | |
Integration 2013 |
|
|
Unit A Integrating Word and Excel |
|
|
Integration 1 | |
|
Integrate Data Between Word and Excel |
|
|
Integration 2 | |
|
Understanding object linking and embedding (OLE) |
|
|
|
Copy Data from Excel to Word |
|
|
Integration 4 | |
|
Copy a Chart from Excel to Word |
|
|
Integration 6 | |
|
|
Integration 8 | |
|
Opening linked files and reestablishing links to charts |
|
|
|
Embed a Word File in Excel |
|
|
Integration 10 | |
|
|
Integration 12 | |
Access 2013 |
|
|
Unit A Getting Started with Access 2013 |
|
|
Access 1 | |
|
Understand Relational Databases |
|
|
Access 2 | |
|
|
Access 4 | |
|
|
Access 6 | |
|
|
Access 8 | |
|
Creating a table in Datasheet View |
|
|
|
|
Access 10 | |
|
Learning about field properties |
|
|
|
|
Access 12 | |
|
|
Access 14 | |
|
Changing from Navigation mode to Edit mode |
|
|
|
|
|
|
Access 16 | |
|
Resizing and moving datasheet columns |
|
|
|
|
Access 18 | |
|
Unit B Building and Using Queries |
|
|
Access 27 | |
|
|
Access 28 | |
|
Work with Data in a Query |
|
|
Access 30 | |
|
Hiding and unhiding fields in a datasheet |
|
|
|
Freezing and unfreezing fields in a datasheet |
|
|
|
|
Access 32 | |
|
Adding or deleting a table in a query |
|
|
|
|
Access 34 | |
|
|
Access 36 | |
|
Using wildcard characters |
|
|
|
|
Access 38 | |
|
Searching for blank fields |
|
|
|
|
Access 40 | |
|
|
Access 42 | |
|
|
Access 44 | |
|
|
Access 53 | |
|
|
Access 54 | |
|
|
Access 56 | |
|
|
Access 58 | |
|
|
|
|
Access 60 | |
|
Bound versus unbound controls |
|
|
|
|
Access 62 | |
|
|
Access 64 | |
|
|
Access 66 | |
|
|
|
|
Access 68 | |
|
Applying a background image |
|
|
|
|
Access 70 | |
|
|
Access 79 | |
|
|
Access 80 | |
|
Changing page orientation |
|
|
|
|
Access 82 | |
|
|
Access 84 | |
|
Apply Group and Sort Orders |
|
|
Access 86 | |
|
|
Access 88 | |
|
Resize and Align Controls |
|
|
Access 90 | |
|
Precisely moving and resizing controls |
|
|
|
|
Access 92 | |
|
|
Access 94 | |
|
|
Access 96 | |
Integration 2013 |
|
|
Unit B Integrating Word, Excel, and Access |
|
|
Integration 17 | |
|
Integrate Data Among Word, Excel, and Access |
|
|
Integration 18 | |
|
Import an Excel Worksheet into Access |
|
|
Integration 20 | |
|
Copy a Word Table to Access |
|
|
Integration 22 | |
|
Link an Access Table to Excel and Word |
|
|
Integration 24 | |
|
Link an Access Table to Word |
|
|
Integration 26 | |
|
Opening linked files and enabling content |
|
|
|
|
Integration 28 | |
PowerPoint 2013 |
|
|
Unit A Creating a Presentation in PowerPoint 2013 |
|
|
PowerPoint 1 | |
|
Define Presentation Software |
|
|
PowerPoint 2 | |
|
Using PowerPoint on a touch screen |
|
|
|
Plan an Effective Presentation |
|
|
PowerPoint 4 | |
|
|
|
Examine the PowerPoint Window |
|
|
PowerPoint 6 | |
|
Viewing your presentation in gray scale or black and white |
|
|
|
|
PowerPoint 8 | |
|
Saving fonts with your presentation |
|
|
|
|
PowerPoint 10 | |
|
Entering and printing notes |
|
|
|
|
PowerPoint 12 | |
|
|
|
Compare Presentation Views |
|
|
PowerPoint 14 | |
|
Print a PowerPoint Presentation |
|
|
PowerPoint 16 | |
|
Microsoft Office Web Apps |
|
|
|
|
PowerPoint 18 | |
|
Unit B Modifying a Presentation |
|
|
PowerPoint 25 | |
|
Enter Text in Outline View |
|
|
PowerPoint 26 | |
|
Using proofing tools for other languages |
|
|
|
|
PowerPoint 28 | |
|
|
|
|
PowerPoint 30 | |
|
Choosing SmartArt graphics |
|
|
|
|
PowerPoint 32 | |
|
Use the Eyedropper to match colors |
|
|
|
Rearrange and Merge Shapes |
|
|
PowerPoint 34 | |
|
Changing the size and position of shapes |
|
|
|
Edit and Duplicate Shapes |
|
|
PowerPoint 36 | |
|
Editing points of a shape |
|
|
|
|
PowerPoint 38 | |
|
|
|
|
PowerPoint 40 | |
|
Creating superscript and subscript text |
|
|
|
|
PowerPoint 42 | |
|
Unit C Inserting Objects into a Presentation |
|
|
PowerPoint 49 | |
|
Insert Text from Microsoft Word |
|
|
PowerPoint 50 | |
|
Sending a presentation using email |
|
|
|
Insert and Style a Picture |
|
|
PowerPoint 52 | |
|
Saving slides as graphics |
|
|
|
|
PowerPoint 54 | |
|
Changing text box defaults |
|
|
|
|
PowerPoint 56 | |
|
Enter and Edit Chart Data |
|
|
PowerPoint 58 | |
|
Adding a hyperlink to a chart |
|
|
|
Insert Slides from Other Presentations |
|
|
PowerPoint 60 | |
|
Working with multiple windows |
|
|
|
|
PowerPoint 62 | |
|
|
|
Insert and Format WordArt |
|
|
PowerPoint 64 | |
|
Saving a presentation as a video |
|
|
|
|
PowerPoint 66 | |
|
Unit D Finishing a Presentation |
|
|
PowerPoint 73 | |
|
|
PowerPoint 74 | |
|
Create custom slide layouts |
|
|
|
Customize the Background and Theme |
|
|
PowerPoint 76 | |
|
|
PowerPoint 78 | |
|
Set Slide Transitions and Timings |
|
|
PowerPoint 80 | |
|
Rehearsing slide show timings |
|
|
|
|
PowerPoint 82 | |
|
Attaching a sound to an animation |
|
|
|
Use Proofing and Language Tools |
|
|
PowerPoint 84 | |
|
Checking spelling as you type |
|
|
|
|
PowerPoint 86 | |
|
Digitally sign a presentation |
|
|
|
|
PowerPoint 88 | |
|
|
|
|
PowerPoint 90 | |
Integration 2013 |
|
|
Unit C Integrating Word, Excel, Access, and PowerPoint |
|
|
Integration 33 | |
|
Integrate Data Among Word, Excel, Access, and PowerPoint |
|
|
Integration 34 | |
|
Import a Word Outline into PowerPoint |
|
|
Integration 36 | |
|
Embed an Excel Worksheet in PowerPoint |
|
|
Integration 38 | |
|
Link Access and Excel Objects to PowerPoint |
|
|
Integration 40 | |
|
|
Integration 42 | |
|
|
Integration 44 | |
Outlook 2013 |
|
|
Unit A Getting Started with Email |
|
|
Outlook 1 | |
|
|
Outlook 2 | |
|
|
Outlook 4 | |
|
|
Outlook 6 | |
|
Understanding message headers in emails you receive |
|
|
|
|
Outlook 8 | |
|
|
|
Receive and Reply to Emails |
|
|
Outlook 10 | |
|
Setting up vacation responses |
|
|
|
|
Outlook 12 | |
|
|
|
Flagging or labeling messages |
|
|
|
|
Outlook 14 | |
|
Reviewing options when sending messages |
|
|
|
Employ Good Email Practices |
|
|
Outlook 16 | |
|
Creating distribution lists |
|
|
|
|
Outlook 18 | |
|
Unit B Managing Information Using Outlook |
|
|
Outlook 25 | |
|
|
Outlook 26 | |
|
|
|
|
Outlook 28 | |
|
|
Outlook 30 | |
|
|
Outlook 32 | |
|
Sending electronic business cards |
|
|
|
|
Outlook 34 | |
|
|
Outlook 36 | |
|
Customizing Outlook Today |
|
|
|
Integrate Social Connectors |
|
|
Outlook 38 | |
|
|
Outlook 40 | |
|
|
|
|
Outlook 42 | |
Cloud |
|
|
Appendix A: Working in the Cloud |
|
|
Cloud 1 | |
|
Explore Office 365 and the Cloud |
|
|
Cloud 2 | |
|
|
Cloud 4 | |
|
|
|
How to disable default saving to OneDrive |
|
|
|
|
Cloud 6 | |
|
Exploring other Office Online Programs |
|
|
|
|
Cloud 8 | |
Integrated Projects |
|
|
Appendix B: Integrating Word, PowerPoint, Excel, and Access 2013 |
|
|
Integrated Projects 1 | |
|
Integrated Project 1: Word and PowerPoint |
|
|
Integrated Projects 2 | |
|
Integrated Project 2: Excel and Access |
|
|
Integrated Projects 6 | |
|
Integrated Project 3: Word, PowerPoint, Excel, and Access |
|
|
Integrated Projects 11 | |
SAM Projects |
|
|
|
SAM Projects 1 | |
|
|
SAM Projects 2 | |
|
|
SAM Projects 4 | |
|
|
SAM Projects 8 | |
|
|
SAM Projects 11 | |
|
|
SAM Projects 15 | |
|
|
SAM Projects 21 | |
|
|
SAM Projects 28 | |
|
|
SAM Projects 32 | |
Capstone Projects |
|
|
|
Capstone 1 | |
|
Word 2013 Capstone Project 1 |
|
|
Capstone 2 | |
|
Word 2013 Capstone Project 2 |
|
|
Capstone 4 | |
|
Excel 2013 Capstone Project 1 |
|
|
Capstone 6 | |
|
Excel 2013 Capstone Project 2 |
|
|
Capstone 8 | |
|
Access 2013 Capstone Project 1 |
|
|
Capstone 10 | |
|
Access 2013 Capstone Project 2 |
|
|
Capstone 12 | |
|
PowerPoint 2013 Capstone Project 1 |
|
|
Capstone 14 | |
|
PowerPoint 2013 Capstone Project 2 |
|
|
Capstone 16 | |
|
Integration Capstone Project 1 |
|
|
Capstone 18 | |
|
Integration Capstone Project 2 |
|
|
Capstone 20 | |
Glossary |
|
Glossary 1 | |
Index |
|
Index 20 | |