Standard
|
BUS 143 Business
Software Applications
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 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