Standard

 

BUS 143   Business Software Applications

Course Description:

These modules teaches participants how to us Microsoft Business Applications such as word, outlook and excel. Topics include introduction to Microsoft Word, introduction to Microsoft Outlook, and introduction to Microsoft Excel.

  

Competency Areas:

Hours:

 

 

 

Introduction to Microsoft Word

Class

2

Introduction to Microsoft Outlook

D. Lab

0

Introduction to Microsoft Excel

P. Lab/O.B.I.

0

 

Credit

2

Prerequisite:

None

Corequisite:

 

 

Course Guide

 

 

Competency

After completing this section, the student will:

Hours

Class

D. Lab

P. Lab/

O.B.I.

INTRODUCTION TO MICROSOFT WORD

10

0

0

Use Microsoft Word as  a word processor

Start Word

 

 

 

 

Use the Office Assistant

 

 

 

 

Use toolbars

 

 

 

 

Use Menus

 

 

 

 

Open documents

 

 

 

 

View documents

 

 

 

 

Close documents

 

 

 

 

Exist Word

 

 

 

 

Create documents

 

 

 

 

Save documents

 

 

 

 

Use versioning

 

 

 

 

Preview documents

 

 

 

 

Print documents

 

 

 

 

Find documents

 

 

 

 

Use the keyboard

 

 

 

 

Use the scroll bars

 

 

 

 

Use select browse objects

 

 

 

 

Use the document map

 

 

 

 

Insert and overtype text

 

 

 

 

Use special characters

 

 

 

 

Delete text

 

 

 

 

Change text case

 

 

 

 

Use repeat, undo, and redo

 

 

 

 

Use the mouse to select text

 

 

 

 

Use the keyboard to select text

 

 

 

 

Move and copy text

 

 

 

 

Use the clipboard

 

 

 

 

Use drag/drop to move/copy text

 

 

 

 

Use built in AutoText entries

 

 

 

 

Create an AutoText entry

 

 

 

 

Use AutoComplete

 

 

 

 

Delete an AutoText entry

 

 

 

 

Use AutoCorrect

 

 

 

 

Correct text automatically

 

 

 

 

Add an AutoCorrect entry

 

 

 

 

Delete an AutoCorrect

 

 

 

 

Use the format toolbar

 

 

 

 

Use the AutoFormat as you type

 

 

 

 

Use the format painter

 

 

 

 

Set margins

 

 

 

 

Set hyphenation

 

 

 

 

Change line and paragraph spacing

 

 

 

 

Change character spacing

 

 

 

 

Set tabs

 

 

 

 

Indent paragraphs

 

 

 

 

Display and hide non printing characters

 

 

 

 

Control text flow

 

 

 

 

Align text on a page

 

 

 

 

Change page orientation

 

 

 

 

Find text

 

 

 

 

Replace text

 

 

 

 

Find and replace word forms

 

 

 

 

Use the go to feature

 

 

 

 

Check spelling and grammar

 

 

 

 

Use the thesaurus

 

 

 

INTRODUCTION TO MICROSOFT OUTLOOK

8

0

0

Use Microsoft Outlook as an e-mail editor

Explore the Menus

 

 

 

 

Use the office assistant

 

 

 

 

Explore the toolbars

 

 

 

 

Explore the outlook bar

 

 

 

 

Explore the folder list

 

 

 

 

Customize outlook today

 

 

 

 

Apply address book settings

 

 

 

 

Verify outlook address book setting

 

 

 

 

Activate your personal address book

 

 

 

 

Add new entries to address book

 

 

 

 

Search for entries

 

 

 

 

Create distribution lists

 

 

 

 

Delete entries

 

 

 

 

Delete distribution lists

 

 

 

 

Manage the contacts folder

 

 

 

 

Create contacts

 

 

 

 

Edit contacts

 

 

 

 

Flag contacts for follow up

 

 

 

 

Delete contacts

 

 

 

 

Explore contact folder views

 

 

 

 

Import contact data

 

 

 

 

Create and send messages

 

 

 

 

Set voting buttons

 

 

 

 

Use voting buttons

 

 

 

 

Use delivery options

 

 

 

 

View incoming messages

 

 

 

 

Reply to messages

 

 

 

 

Forward messages

 

 

 

 

Recall messages

 

 

 

 

Organize messages

 

 

 

 

Delete messages

 

 

 

 

Schedule appointments

 

 

 

 

Schedule reoccurring appointments

 

 

 

 

Schedule multi days appointment

 

 

 

 

Set reminders

 

 

 

 

Reschedule appointments

 

 

 

 

Deleting appointments

 

 

 

 

Mark events in your calendar

 

 

 

 

Configure calendar appointments

 

 

 

 

Create task manually

 

 

 

 

Create task from e-mail massages

 

 

 

 

Create recurring task

 

 

 

 

Set reminders

 

 

 

 

Group tasks

 

 

 

 

Mark task as complete

 

 

 

 

Delete tasks

 

 

 

 

Set journal entries

 

 

 

 

Create journal entries

 

 

 

 

Modify journal entries

 

 

 

 

Delete journal entries

 

 

 

 

Create notes

 

 

 

 

Modify notes

 

 

 

 

Copy notes to other views

 

 

 

 

Change the color of notes

 

 

 

 

Delete notes

 

 

 

 

Print e-mail messages

 

 

 

 

Print your calendar

 

 

 

 

Print contact information

 

 

 

 

Print tasks

 

 

 

 

Print journal entries

 

 

 

 

Print notes

 

 

 

INTRODUCTION TO MICROSOFT EXCEL

10

0

0

 

Explore spreadsheet uses

 

 

 

 

Define workbooks and spreadsheets

 

 

 

 

Use the office assistant

 

 

 

 

Move around in the workbook

 

 

 

 

Select ranges

 

 

 

 

Explore the toolbars

 

 

 

 

Explore the minus

 

 

 

 

Exit Excel

 

 

 

 

Enter text

 

 

 

 

Use the AutoComplete function

 

 

 

 

Enter numbers

 

 

 

 

Enter dates

 

 

 

 

Enter data

 

 

 

 

Save and close new workbooks

 

 

 

 

Copy data using the clipboard

 

 

 

 

Copy data using the AutoFill

 

 

 

 

Copy data using drag and drop

 

 

 

 

Copy/Move data from multiple sources

 

 

 

 

Delete data

 

 

 

 

Reverse actions

 

 

 

 

Save existing workbooks

 

 

 

 

Save workbooks with different manes

 

 

 

 

Insert rows and columns

 

 

 

 

Delete rows and columns

 

 

 

 

Us the columns width dialog box

 

 

 

 

Us the mouse

 

 

 

 

Use AutoFit

 

 

 

 

Use the number format

 

 

 

 

Use accounting/currency formats

 

 

 

 

Use the percent format

 

 

 

 

Use the comma format

 

 

 

 

Use the date format

 

 

 

 

Change alignment of data

 

 

 

 

Use the conditional formatting

 

 

 

 

Preview print jobs

 

 

 

 

Use page break preview

 

 

 

 

Change print size

 

 

 

 

Change margins

 

 

 

 

Create headers and footers

 

 

 

 

Print worksheets

 

 

 

 

Create formulas

 

 

 

 

Edit formulas

 

 

 

 

Use relative cell references

 

 

 

 

Use absoluter cell references

 

 

 

 

Use mixed cell references

 

 

 

 

Use the average function

 

 

 

 

Use the max function

 

 

 

 

Use the min function

 

 

 

 

Use AutoSum

 

 

 

 

Use the paste function feature

 

 

 

 

Use AutoCalculate

 

 

 

 

Move between worksheets

 

 

 

 

Insert and delete worksheets

 

 

 

 

Move/Copy data between worksheets

 

 

 

 

Move and copy worksheets

 

 

 

 

Group worksheets

 

 

 

 

Create 3-Dimensional formulas

 

 

 

 

Rename worksheets

 

 

 

 

Preview/Print multiple worksheets

 

 

 

 

Change text and font attributes

 

 

 

 

Rotate text

 

 

 

 

Indent text in cells

 

 

 

 

Add/Modify borders

 

 

 

 

Shade ranges

 

 

 

 

Create 3-Dimensional objects

 

 

 

 

Modify 3-Dimensional objects

 

 

 

 

Insert pictures

 

 

 

 

Resize and modify pictures

 

 

 

 

Create styles

 

 

 

 

Format cells with styles

 

 

 

 

Modify and delete styles

 

 

 

 

Use AutoFormat

 

 

 

 

Create charts

 

 

 

 

Format charts

 

 

 

 

Change chart types

 

 

 

 

Reposition legends

 

 

 

 

Resize and move charts

 

 

 

 

Edit chart data

 

 

 

 

Place data tables in charts

 

 

 

 

Modify data tables in charts

 

 

 

 

Print charts

 

 

 

 

Suggested Resources

 

Books:

 

Non