Table of Contents
Part 1 Technology
Fundamentals
Chapter 1 Getting Started with Computer Concepts
Concept 1 The Computer Is a System
Concept 2 Common Operating Systems
Concept 3 Input Devices
Concept 4 Storage Devices
Concept 5 Apps and Applications
Concept 6 Networks
Concept 7 Cloud Computing
Concept 8 Share Files with Others
Concept 9 Office 365
Concept 10 Buying a Computer
Chapter 2 Getting Started with Windows 8
Skill 1 Sign In to Windows 8
Skill 2 Work with Store Apps
Skill 3 Create and Save Documents
Skill 4 Search for Applications, Files, and Settings
Skill 5 Download and Unzip Student Data Files
Skill 6 View Files in File Explorer
Skill 7 Search for and Copy Files
Skill 8 Move, Rename, and Delete Files
Skill 9 Personalize the Desktop and Create Snips
Skill 10 Print, Restore Settings, and Sign Out
More Skills
Skill 11 Customize the Start Screen
Skill 12 Modify the Desktop
Skill 13 Switch to a Microsoft Account
Skill 14 Use the SkyDrive App
Chapter 3 Browse with Internet Explorer
Skill 1 Browse from the Start Screen
Skill 2 Browse from the Desktop and Add Favorites
Skill 3 Navigate and Search Websites
Skill 4 Use Accelerators and Search Providers
Skill 5 Manage Browser Tabs
Skill 6 Organize Favorites
Skill 7 Print and Save Web Pages
Skill 8 View and Delete Browsing History
Skill 9 Protect Online Privacy
Skill 10 Manage Pop–ups and Check Website Safety
More Skills
Skill 11 Change Your Home Page
Skill 12 Add Navigation Tiles to the Start Screen
Skill 13 Add Tracking Protection
Skill 14 Change Internet Security Settings
Part 2 Getting Started with Microsoft Office Applications
Chapter 1 Common Features of Office 2013
Skill 1 Start Office Applications
Skill 2 Create Documents from Templates
Skill 3 Type and Edit Text
Skill 4 Save Files and Create Folders
Skill 5 Apply Themes and Format Text
Skill 6 Preview and Print Documents
Skill 7 Open and Save Student Data Files
Skill 8 Format Worksheets
Skill 9 Copy and Paste Objects and Format Slides
Skill 10 Format Access Reports
More Skills
Skill 11 Store Office Files on SkyDrive
Skill 12 Use Office Help
Skill 13 Send Files as E–mail Attachments
Skill 14 Optimize Office 2013 RT
Part 3 Microsoft Office
Microsoft Word
Introduction to Word
Chapter 1 Create Letters and Memos
Skill 1 Type Letter Text
Skill 2 Apply Styles and Set Grammar and Spelling Options
Skill 3 Select and Insert Text
Skill 4 Copy, Cut, and Paste Text
Skill 5 Check Spelling and Grammar
Skill 6 Check Writing Style and Insert Synonyms
Skill 7 Use Format Painter
Skill 8 Apply Advanced Font Settings
Skill 9 Create Document Footers
Skill 10 Save Documents as PDF Files
More Skills
Skill 11 Prepare Documents for Distribution
Skill 12 Insert Screen Shots into Documents
Skill 13 Split and Arrange Windows
Skill 14 Insert Symbols
Chapter 2 Create Business Reports
Skill 1 Find and Replace Text
Skill 2 Insert and Modify Footnotes
Skill 3 Add Sources
Skill 4 Insert Citations and Bibliographies
Skill 5 Format Bulleted and Numbered Lists
Skill 6 Set Paragraph Indents
Skill 7 Modify Line and Paragraph Spacing
Skill 8 Set Line and Page Break Options and Modify Styles
Skill 9 View Multiple Pages and Set Margins
Skill 10 Create Custom Headers and Footers
More Skills
Skill 11 Record AutoCorrect Entries
Skill 12 Use AutoFormat to Create Numbered Lists
Skill 13 Format and Customize Lists
Skill 14 Create Standard Outlines
Chapter 3 Create Flyers
Skill 1 Insert Text and Pictures from Files
Skill 2 Resize and Align Pictures
Skill 3 Apply Picture Styles and Artistic Effects
Skill 4 Set Tab Stops
Skill 5 Type Tabbed Lists
Skill 6 Apply Table Styles
Skill 7 Create Tables
Skill 8 Delete and Add Table Rows and Columns
Skill 9 Format Text in Table Cells
Skill 10 Format Tables
More Skills
Skill 11 Insert Text Boxes
Skill 12 Format with WordArt
Skill 13 Convert Text into Tables
Skill 14 Insert Drop Caps
Chapter 4 Create Newsletters and Mail Merge Documents
Skill 1 Modify Themes and Create Columns
Skill 2 Modify Margins and Columns
Skill 3 Apply Text Effects
Skill 4 Create Styles
Skill 5 Add Borders and Shading to Paragraphs and Pages
Skill 6 Insert and Adjust Online Pictures
Skill 7 Insert SmartArt
Skill 8 Format SmartArt
Skill 9 Create Labels Using Mail Merge
Skill 10 Preview and Print Mail Merge Documents
More Skills
Skill 11 Optimize Documents for Read Mode
Skill 12 Work in Outline View
Skill 13 Manage Document Properties
Skill 14 Save Documents as Web Pages
Word Capstone Project
Integrated Project 1: Format Academic Reports and Include Information from the Web
Integrated Project 2: Use Excel Data in Word Mail Merge
Word Web App Project: Create Flyers Using Word Web App
Microsoft Excel
Introduction to Excel
Chapter 1 Create Workbooks with Excel 2013
Skill 1 Create and Save Workbooks
Skill 2 Enter Data and Merge and Center Titles
Skill 3 Construct Addition and Subtraction Formulas
Skill 4 Construct Multiplication and Division Formulas
Skill 5 Adjust Column Widths and Apply Cell Styles
Skill 6 Insert the SUM Function
Skill 7 AutoFill Formulas and Data
Skill 8 Format, Edit, and Check Spelling
Skill 9 Insert Footers and Adjust Page Settings
Skill 10 Display Formulas and Print Worksheets
More Skills
Skill 11 Create Workbooks from Templates
Skill 12 Insert Names into Formulas
Skill 13 Create Templates
Skill 14 Manage Document Properties
Chapter 2 Insert Summary Functions and Create Charts
Skill 1 Align and Wrap Text
Skill 2 Apply Absolute Cell References
Skill 3 Format Numbers
Skill 4 Insert the AVERAGE Function
Skill 5 Insert the MIN and MAX Functions
Skill 6 Create Column Charts
Skill 7 Format Column Charts
Skill 8 Create and Format Pie Charts
Skill 9 Update Charts and Insert WordArt
Skill 10 Preview and Print Multiple Worksheets
More Skills
Skill 11 Insert, Edit, and Delete Comments
Skill 12 Change Chart Types
Skill 13 Copy Excel Data to Word Documents
Skill 14 Fill Data with Flash Fill
Chapter 3 Manage Multiple Worksheets
Skill 1 Organize Worksheet Tabs
Skill 2 Enter and Format Dates
Skill 3 Clear Cell Contents and Formats
Skill 4 Move Cell Contents and Use Paste Options
Skill 5 Enter Data in Grouped Worksheets
Skill 6 Insert Multiple Math Operators in Formulas
Skill 7 Format Grouped Worksheets
Skill 8 Insert, Hide, Delete, and Move Worksheets
Skill 9 Create Summary Worksheets
Skill 10 Create Clustered Bar Charts
More Skills
Skill 11 Create Organization Charts
Skill 12 Create Line Charts
Skill 13 Set and Clear Print Areas
Skill 14 Create, Edit, and Delete Hyperlinks
Chapter 4 More Functions and Excel Tables
Skill 1 Insert the TODAY, NOW, and COUNT Functions
Skill 2 Insert the IF Function
Skill 3 Move Functions, Add Borders, and Rotate Text
Skill 4 Apply Conditional Formatting
Skill 5 Insert Sparklines
Skill 6 Use Find and Replace
Skill 7 Freeze and Unfreeze Panes
Skill 8 Create, Sort, and Filter Excel Tables
Skill 9 Filter Data
Skill 10 Convert Tables to Ranges, Hide Rows and Columns, and Format Large Worksheets
More Skills
Skill 11 Apply Conditional Color Scales with Top and Bottom Rules and Clear Rules
Skill 12 Insert the Payment (PMT) Function
Skill 13 Create PivotTable Reports
Skill 14 Use Goal Seek
Excel Capstone Project
Integrated Project 3: Copy Word Tables into Excel Worksheets
Integrated Project 4: Link Data from Excel
Microsoft Access
Introduction to Access
Chapter 1 Create Database Tables
Skill 1 Create Databases
Skill 2 Create Tables in Datasheet View
Skill 3 Enter Data into Datasheets
Skill 4 Create Tables in Design View
Skill 5 Relate Tables
Skill 6 Enter Data in Related Tables
Skill 7 Import Data into Tables
Skill 8 Filter and Sort Datasheets
Skill 9 Format Datasheets
Skill 10 Preview and Print Datasheets
More Skills
Skill 11 Compact and Repair Databases
Skill 12 Work with the Long Text Data Type
Skill 13 Work with the Attachment Data Type
Skill 14 Work with the Hyperlink and Yes/No Data Types
Chapter 2 Create Select Queries
Skill 1 Create Queries with the Simple Query Wizard
Skill 2 Add Text Criteria
Skill 3 Add Calculated Fields to Tables
Skill 4 Create Queries in Design View
Skill 5 Add Comparison Operators
Skill 6 Add Date and Time Criteria
Skill 7 Group and Total Queries
Skill 8 Add Calculated Fields to Queries
Skill 9 Work with Logical Operators
Skill 10 Add Wildcards to Query Criteria
More Skills
Skill 11 Export Queries to Excel
Skill 12 Export Queries as Web Pages
Skill 13 Link to External Data Sources
Skill 14 Create Crosstab Queries
Chapter 3 Create Forms
Skill 1 Use the Form Wizard
Skill 2 Use Forms to Modify Data
Skill 3 Format Forms in Layout View
Skill 4 Add Controls and Conditional Formatting
Skill 5 Use the Form Tool
Skill 6 Work with Tabular Layouts
Skill 7 Add Input Masks
Skill 8 Change Data in One–to–Many Forms
Skill 9 Create Forms from Queries
Skill 10 Create Navigation Forms
More Skills
Skill 11 Validate Fields
Skill 12 Create Databases from Templates
Skill 13 Create Macros
Skill 14 Create Access Apps
Chapter 4 Create Reports
Skill 1 Build Queries for Reports
Skill 2 Create Reports Using the Report Tool
Skill 3 Format Reports
Skill 4 Add Totals to Reports
Skill 5 Preview and Print Reports
Skill 6 Create Reports with the Blank Report Tool
Skill 7 Group and Sort Reports
Skill 8 Modify Report Layouts
Skill 9 Filter Reports
Skill 10 Create Label Reports
More Skills
Skill 11 Import Objects from Other Databases
Skill 12 Export Reports to Word
Skill 13 Save Reports as PDF Documents
Skill 14 Save Reports as Web Pages and Save Export Steps
Access Capstone Project
Integrated Project 6: Create Envelopes from Access Queries
Integrated Project 5: Refer to Cells in Other Workbooks
Excel Web App Project: Create Workbooks Using Excel Web App
Integrated Project 7: Export Access Data to Word Documents
Access Web App Project: Create OneNote Notebooks
Microsoft PowerPoint
Introduction to PowerPoint
Chapter 1 Getting Started with PowerPoint 2013
Skill 1 Open, View, and Save Presentations
Skill 2 Edit and Replace Text
Skill 3 Format Slide Text
Skill 4 Check Spelling and Use the Thesaurus
Skill 5 Insert Slides and Modify Slide Layouts
Skill 6 Insert and Format Pictures
Skill 7 Organize Slides in Slide Sorter View
Skill 8 Apply Slide Transitions and View Slide Shows
Skill 9 Insert Headers and Footers and Print Handouts
Skill 10 Add Notes Pages and Use Presenter View
More Skills
Skill 11 Add Online Pictures
Skill 12 Print Presentations, Notes Pages, and Custom Ranges
Skill 13 Move and Delete Slides in Normal View
Skill 14 Change Slide Size and Orientation
Chapter 2 Format a Presentation
Skill 1 Create New Presentations
Skill 2 Change Themes and Variants
Skill 3 Change Font Colors and Effects
Skill 4 Format Slide Backgrounds with Fill
Skill 5 Add Pictures and Textures to Slide Backgrounds
Skill 6 Format Text with WordArt
Skill 7 Change Character Spacing
Skill 8 Modify Bulleted and Numbered Lists
Skill 9 Move and Copy Text and Objects
Skill 10 Use Format Painter and Clear All Formatting
More Skills
Skill 11 Edit Slide Masters
Skill 12 Save and Apply Presentation Templates
Skill 13 Create Slides from Microsoft Word Outlines
Skill 14 Design Presentations with Contrast
Chapter 3 Enhance Presentations with Graphics
Skill 1 Insert Slides from Other Presentations
Skill 2 Insert, Size, and Move Online Pictures
Skill 3 Modify Picture Shapes, Borders, and Effects
Skill 4 Insert, Size, and Move Shapes
Skill 5 Add Text to Shapes and Insert Text Boxes
Skill 6 Apply Gradient Fills and Group and Align Graphics
Skill 7 Convert Text to SmartArt Graphics and Add Shapes
Skill 8 Modify SmartArt Layouts, Colors, and Styles
Skill 9 Insert Video Files
Skill 10 Apply Video Styles and Adjust Videos
More Skills
Skill 11 Compress Pictures
Skill 12 Save Groups as Picture Files
Skill 13 Change Object Order
Skill 14 Insert a Screen Shot in a Presentation
Chapter 4 Present Data Using Tables, Charts, and Animation
Skill 1 Insert Tables
Skill 2 Modify Table Layouts
Skill 3 Apply Table Styles
Skill 4 Insert Column Charts
Skill 5 Edit and Format Charts
Skill 6 Insert Pie Charts
Skill 7 Apply Animation Effects and Change Duration
Skill 8 Modify Animation Timings and Use Animation Painter
Skill 9 Delay or Remove Animation
Skill 10 Navigate Slide Shows
More Skills
Skill 11 Save Presentations to CDs
Skill 12 Insert Hyperlinks in Presentations
Skill 13 Create Photo Albums
Skill 14 Add Images to Tables
PowerPoint Capstone Project
Integrated Project 8: Copy and Paste Between Office Programs
Integrated Project 9: Send PowerPoint Handouts to Word
PowerPoint Web App Project: Create Presentations Using the PowerPoint Web App
Glossary
Index