Activities

Test Review

Computer Software

Slide Presentation

Chapter 1: Computer Hardware

Chapter 2: Peripheral Devices

Chapter 3: Software

Chapter 4: Installing Software

Chapter 5: Getting Started with Windows

Chapter 6: Working with Windows Settings and Accounts

Chapter 7: Working with Files

Chapter 8: Getting Started with Application Software

Chapter 9: Creating a Document

Chapter 10: Formatting a Document

Chapter 11: Finalizing a Document

Chapter 12: Creating a Worksheet

Chapter 13: Formatting a Worksheet

Chapter 14: Finalizing a Worksheet

Chapter 15: Creating a Presentation

Chapter 16: Finalizing a Presentation

Chapter 17: Creating a Database

Chapter 18: Finalizing a Database

Chapter 19: Networks

Chapter 20: Working with E-Mail

Chapter 21: Browsing the Web

Chapter 22: Safety, Privacy, and Security

Videos

What is a Computer?

A Computer Chip

A Hard Disk Drive

Computer Keyboards

Touchpad and Touchscreen Computers

Printers

USB Ports

Computer Keyboard Care

Apple iOS

Arranging the Desktop

Working in Windows 7

Applications

• • Switching Between Application Windows

  • The Ribbon

  • Opening a File

  • Saving Files

  • Change Default Settings

  • Accessing Help

File Management

• • File Properties and Tags

  • Default Programs List

  • File Explorer

  • Navigating Folders

  • Folders and Libraries

  • Moving Files and Folders

  • Creating Tiles and Shortcuts

  • The Recycle Bin

  • Zipping Files

  • Sharing Files

  • Defragmenting a Hard Disk

Videos

Creating Documents

• • The Word Window

  • Creating a Document

  • Selecting Text

  • Moving, Copying, and Deleting Text

  • Undo, Redo, and Repeat

  • Spelling, Grammar, and Readability

  • The Thesausrus

  • Searching Text and Global Changes

  • Document Templates

  • Saving a Document

  • Printing a Document

  • Selecting Fonts, Font Sizes, and Text Colors

  • Applying Bold, Italic, and Underline Attributes

  • Font Dialog Box

  • Centering and Aligning Text

  • Working with Lists

  • Adjust Line Spacing and Using Tabs

  • Indenting Text

  • Creating a Table

  • Inserting Photos into Documents

  • Inserting Line Art into Documents

  • Setting Margins

Creating Spreadsheets

• • The Excel Window

  • Entering Labels and Values

  • Entering Formulas and Complex Formulas

  • Using Functions

  • Relative and Absolute Cell References

  • Working with Workbooks

  • Adding Borders and Background Colors

  • Formatting Worksheet Data and Applying Number Formats

  • Adjusting Column Width, Row Height, Centering, and Aligning Cell Contents

  • Deleting and inserting Rows and Columns

  • Worksheet Styles

  • Creating Charts

  • Modifying a Chart

  • Sorting Worksheet Data

  • Filtering Worksheet Data

  • Spell Checker and Testing Worksheets

  • Worksheet Layout and Margins

  • Worksheet Headers, Footers, Print Options and Printing a Worksheet

Creating Presentations

• • The PowerPoint Window

  • Selecting a Presentation Theme and Adding Slides

  • Adding Bullet Lists and Graphics

  • Adding Charts and Tables

  • Working with Multimedia Elements, Web Links, and Viewing a Slideshow

  • Using Normal View and Outline View

  • Adding Transitions and Working with the Slide Master

  • Adding Animation Effects

  • Spell Checker, Speaker Notes, and Printing Handouts

Creating Databases

• • Organizing a Database and Access Window

  • Creating a Database and Database Table

  • Saving Tables and Entering Data in Tables

  • Importing Data and Working with Tables

  • Creating a Query

  • Creating a Form

  • Creating and Printing a Report