Back to HOME PAGE

Email Me

MICROSOFT OFFICE Professional Lesson Plans

Class development with lectures, handouts and hands on exercises ~ 130 exercises.

Testing with quizzes, scenarios and on the job experience.

Microsoft Authorized Testing Center

 

MICROSOFT OFFICE BASICS

 

ABOUT MICROSOFT OFFICE 2000

PRACTICE USING THE MOUSE

USE MICROSOFT OFFICE SHORTCUT BAR

LEARN THE OFFICE WINDOW

SCREEN ELEMENTS

WORK WITH MENUS, TOOLBARS, AND DIALOG BOXES

USE SHORTCUT MENUS

PRACTICE USIING THE KEYBOARD

WORK WITH THE ZOOM OPTION

GET HELP FORM THE OFFICE ASSISTANT AND OTHER FEATURES

DISCOVER OFFICE 2000 WEB FEATURES

INTRODUCTION TO WORD, EXCEL, ACCESS, POWERPOINT, AND OUTLOOK

WORK WITH MUTIPLE FILES

 

MICROSOFT WORD

LESSON PLANS

 

GETTING STARTED WITH WORD

 

EXERCISE. 1

START AND EXIT WORD

CORRECT SIMPLE ERRORS

WORK WITH THE WORD WINDOW SCREEN ELEMENTS

WORK WITH SHOW/HIDE MARKS

CREATE NEW DOCUMENTS

SAVE NEW DOCUMENTS

CLOSE AN OPEN DOCUMENT

EXERCISE. 2

MOVE THE INSERTION POINT IN THE DOCUMENT

CHECK SPELLING AND GRAMMER IN A DOCUMENT

USE THE THESAURUS

EXERCISE. 3

UNDERSTAND THE AUTOCORRECT FEATURE

SELECT TEXT IN A DOCUMENT

USE AUTO TEXT

EXERCISE. 4

WORK WITH BUSINESS LETTER FORMATS

INSERT THE DATE AND TME IN A DOCUMENT

EXERCISE. 5

ALIGN TEXT WITH TABS

CREATE A MODIFIED-BLOCK BUSINESS LETTER

PREVIEW AN OPEN DOCUMENT

USE THE SHRINK TO FIT

WORK IN FULL SCREEN VIEW

PRINT AN OPEN DOCUMENT

USE UPPERCASE MODE AD THE CHANGE CASE FEATURE

EXERCISE. 6

FORMAT A PERSONAL BUSINESS LETTER

CREATE ENVELOPES AND LABELS

EXERCISE. 7

SEND E-MAIL FORM WORD

ATTACH A WORD DOCUMENT TO AN E-MAIL MESSAGE

SEND A WORD DOCUMENT AS E-MAIL

RECEIVE E-MAIL MESSAGES IN OUTLOOK OR OUTLOOK EXPRESS

EXERCISE. 8

CRITIAL THINKING EXERCISE.

 

BASIC EDITINT SKILLS; USING THE INTERNET AND WEB

 

EXERCISE. 9

OPEN AN EXISTIING DOCUMENT

WORK EITH PROOFREADERS’ MARKS

INSERT AND EDIT TEXT

USE OVERTYPE MODE

SAVE CHANGES TO A DOCUMENT

SAVE A DOCUMENT WITH ANOTHER NAME

EXERCISE. 10

USE THE READ-ONLY FEATURE

OPEN A DOCUMENT FORM WINDOWS

ENTER DOCUMENT PROPERTIES

EXERCISE. 11

DELETE TEXT IN A DOCUMENT

WORK WITH THE UNDO AND REDO

EXERCISE. 12

MOVE TEXT IN A DOCUMENT

CUT AND PASTE TEXT

WORK WITH THE DRAG-AND –DROP FEATURE

MOVE AN ENTIRE PARAGRAPH

EXERCISE. 13

WORK WITH COPT AND PASTE

COPY TEXT WITH THE DRAG-AND-DROP FEATURE

EXERCISE. 14

PREVIEW AN OPEN DOCUMENT

PRINT A CLOSED FILE AND MULTIPLE FILES

EXERCISE. 15

INTERNET BASICS

USE INTERNET FEATURES IN WORD

WORK WITH THE FAVORITES FOLDER

EXERCISE. 16

OPEN AN HTML DOCUMENT

WORK WITH WEB LAYOUT VIEW

SAVE A DOCUMENT AS A WEB PAGE

PREVIEW A WEB PAGE

EXERCISE. 17

CRITICAL THINKING EXERCISE.

FORMATTING BASICS

 

EXERCISE. 18

ALIGN TEXT IN A DOCUMENT

EXERCISE. 19

WORK WITH FONTS AND FONT SIZES

EXERCISE. 20

APPLY FORT AND TEXT EFFECTS

UNDERLINE TEXT

CHANGE FONT COLORS

HIGHLIGHT TEXT

COPY FORMATTING IN A DOCUMENT

EXERCISE. 21

ENHANCE A DOCUMENT WITH SYMBOLS

EXERCISE. 22

WORK WITH BULLETED AND NUMBERED LISTS

SORT ITEMS IN A LIST

EXERCISE. 23

ADJUST LINE AND PARAGRAHP SPACING

SET TEXT INDENTS

EXERCISE. 24

CREATE A ONE-PAGE REPORT

SET DOCUMENT MARGINS

EXERCISE. 25

CREATE HYPERLINKS

EDIT HYPERLINKS

EXERCISE. 26

USE WEB PAGE TEMPLATES

WORK WITH WEB PAGE TITLES AND GRAPHICS

APPLY BACKGROUNDS AND THEMES

EXERCISE. 27

CRITICAL THINKING EXERCISE.

CREATING TABLES

 

EXERCISE. 28

CREATE A TABLE

WORK WITH DATA IN A TABLE

ENHANCE A TABLE

EXERCISE. 29

SET ALIGNMENTS WITHIN TABLE CELLS

ALIGN TABLE ON A PAGE

SET COLUMN WIDTHS AND ROW HIGGHTS

EXERCISE. 30

USE THE TABLES AND BORDERS TOOLBAR

WORK WITH THE DRAW TABLE FEATURE

MOVE AND RESIZE TABLES

COMBINE AND DIVIDE CELLS IN A TABLE

ROTATE AND WRAP TABLE TEXT

EXERCISE. 31

MAKE SIMPLE CLACULATIONS IN A TABLE

WORK WITH NUMBER FORMATS

ENHANCE A TABLE WITH CELL BORDERS AND SHADING

SORT ROWS IN A TABLE

EXERCISE. 32

CRITICAL THINKING EXERCISE.

CREATING DOCUMENTSS WITH MERGE

 

EXERCISE. 33

MERGE BASICS

WORK WITH MAIN AND DATA SOURCE DOCUMENTS

EXERCISE. 34

MERGE WITH AN EXISTING DATA SOURCE

CREATE ENVELOPES AND LABELS

MERGE WITH ACCESS DATA

EXERCISE. 35

CRITICAL THINKING EXERCISE.

 

MICROSOFT EXCEL LESSON PLANS

 

GETTING STARTED WITH EXCEL 2000

 

EXERCISE. 1

EXCEL BASICS

LEARN THE EXCEL WINDOW SCREEN ELEMENTS

USE THE MENUS AND TOOLBARS

WORK WITH THE MOUSE AND KEYBOARD

EXERCISE. 2

CREATE A NEW WORKBOOK

MAKE SIMPLE CORRECTIONS

WORK WITH LABELS

USE THE VIEW MENU

SAVE AND CLOSE A WORKBOOK

EXERCISE. 3

USE THE AUTOCMPLETE AND PICK FORM LIST FEATURE

UNDERSTAND THE AUTOCORRECT FEATURE

WORK WITH DATA IN A WORKSHEET

USE THE UNDO AND REDO

CHECK SPELLING IN A WORKSHEET

EXERCISE. 4

ENTER NUMERIC LABELS AND VALUES

CHANGE LABEL ALIGNMENT

USE COLUMN WIDTHS TO ACCOMMODATE DATA

WORK WITH INDENTS

EXERCISE. 5

INTEGRATE AN EXCEL WORKSHEET AND A WORD DOCUMENT

WORK WITH DATAT FROM THE INTERNET

EXERCISE. 6

CRITICAL THINKING EXERCISE.

 

ENTERING FORMULAS AND FORMATTING A WORKSHEET

 

 

EXERCISE. 7

FORMULA BASICS

EXERCISE. 8

OPEN EXISTING FILES

SAVE AND CLOSE A WORKSHEET

USE EXCEL’S VIRUS-CHECKING FEATURE

WORK WITH RANGES

EXERCISE. 9

ENHANCE DATA WITH DIFFERENT FORMATS

WORK WITH FONTSAND FONT SIZES

EXERCISE. 10

COPY AND PASTE DATA AND FORMULAS

PRINT ON OPEN WORKSHEET

EXERCISE. 11

SAVE A WORKSHEET AS A WEB PAGE

VIEW THE WEB PAGE

EXERCISE. 12

CRITIAL THINKING EXERCISE.

 

WORKING WITH FUNCTIONS, FORMULAS, AND PRINT OPTIONS

 

 

EXERCISE. 13

FUNCTIONS BASICS

USE THE FORMULA BAR AND PALETTE

WORK WITH PASTE FUNCTION

AUTOCALCULATE DATA

EXERCISE. 14

CREATE A SERIES

CREATE NATURAL LANGUAGE FORMULAS

ADD COMMENTS

EXERCISE. 15

SET UP PRINT OPTIONS

WORK WITH PAGE SETUP

INSERT HEADERS AND FOOTERS

EXERCISE. 16

INSERT PAGE BREAKS

PREVIEW PAGE BREAK

EXERCISE. 17

USE PRIN TITLES

EXERCISE. 18

CREATE AN INTERACTIVE WEB REPORT

EXERCISE. 19

CRITICAL THINKING EXERCISE.

 

ADVANCED FORMATTING AND EDITING

 

 

EXERCISE. 20

INSERT AND DELET COLUMNS AND ROWS

CUT AND PASTE DATA

USE THE DRAG-AND-DROP FEATURE

EXERCISE. 21

USE COPY AND PASTE SPECIAL

TRANSPOSE DATA IN A WORKSHEET

EXERCISE. 22

FREEZE WORKSHEET TITLES

SPLIT WORKSHEET PANES

USE SCROLL TIPS

CREATE A NEW WORKBOOK

WINDOW BETWEEN OPEN WORKBOOKS

WORK WITH COPY AND PASTE SPECIAL

EXERCISE. 23

WORK WITH WORKBOOK SHEETS

SET PRINT OPTIONS

EXERCISE. 24

NAME RENGES IN A WORKBOOK

EXERCISE. 25

EXTRACT AND COMBINE DATA

EXERCISE. 26

DISPLAY OPEN WORKBOOKS

DRAG-AND-DROP DATA BETWEEN WORKBOOKS

LINK WORKBOOKS

EXERCISE. 27

WORK WITH 3-D FORMULAS

COPY SHEETS

DUPLICATE WORKBOOK WINDOW

EXERCISE. 28

LINK AND EMBED OBJECTS AND FILES

WORK WITH LINKED FILES

USE OFFICE LINKS

EXERCISE. 29

CRITICAL THINKING EXERCISE.


MICROSOFT ACCESS LESSON PLANS

 

GETTING STARTED WITH ACCESS 2000

 

 

EXERCISE. 1

COPY DATA FILES AND DESELECT THE READ-ONLY ATTRUBUTE

START ACCESS AND OPEN A DATABASE

NAVIGATE IN A DATABASE

SORT RECORDS

EXERCISE. 2

ENTER RECORDS IN A DATABASE

CORRECT A FIELD ENTRY

PRINT DATADSHEET AND FORMS

PRINT PREVIEW A DATABASE

EXERCISE. 3

PLAN A DATABASE

CREATE A NEW DATABASE FILE

CREATE A TABLE IN DATABASE VIEW

CHANE FIELD NAMES IN DATASHEET VIEW

SAVE A TABLE DESIGN

EXERCISE. 4

OPEN A DATABASE FILE

EDIT A TABLE IN DESIGN VIEW

SWITCH BETWEEN TABLE VIEW

ADD A PRIMARY KEY

EXERCISE. 5

CHANGE DATASHEET COLUMN WIDTH

FREEZE COLUMNS

SET SECURTIY TO PROTECT A DATABASE

EXERCISE. 6

CREATE A FORM FROM AN EXISTING DATASHEET

USE FORM DESIGN VIEW

WORK WITH CONTROLS

EXERCISE. 7

EXPORT AN ACCESS OBJECT TO AN EXCEL WORKSHEET

PUBLISH AND ACCESS OBJECT TO A WORK DOCUMENT

EXERCISE. 8

CRITICAL THINKING EXERCISE.

 

BASIC DATABASE EDITING AND PRINTING

 

 

EXERCISE. 9

WORK WITH FIELDS IN DESIGN VIEW

ADD A LOOKUP VALUE LIST FIELD

RENAME A FIELD

EXERCISE. 10

INSERT, DELETE, AND MOVE COLUMNS IN DATASHEET VIEW

PRINT DATASHEETS AND FORMS

HIDE DATASHEET FIELDS

EXERCISE. 11

WORK WITH FORM VIEW TOOLBOX

CREATE LABELS

USE PRINT SETUP

PRINT WITH HEADER AND FOOTERS

EXERCISE. 12

WORK WITH RECORDS

REMOVE GRIDLINES

ADD BACKGROUNDS

EXERCISE. 13

SWITCH AMONG OPEN OBJECTS

USE FORM AUTOFORMAT

LOOKUP FIELD VALUES FROM ANOTHER TABLE

EXERCISE. 14

IMPORT EXCEL DATA INTO AN ACCESS TABLE

LINK TO AN EXCEL WORKSHEET

COPY DATA FROM WORD TO EXCEL

EXERCISE. 15

RELATE TABLES

ENFORCE REFERENTIAL INTEGRITY

WORK WITH RELATED RECORDS

SET SUBDATASHEETS

EXERCISE. 16

CRITICAL THINKING EXERCISE.

 

FIND INFORMATION IN A DATABASE

 

 

EXERCISE. 17

USE DATABSE WIZARDS

WORK WITH SWITCHBOARDS

EXERCISE. 18

FIND AND REPLACE DATA

SEARCH USING WILDCARDS

EXERCISE. 19

WORK WITH MULTIPLE SORTS

REMOVE SORT

CHANGE COLUMN ORDER

EXERCISE. 20

FILTER A RECORD SUBSET

FILTER BY SELECTION

FILTER EXCLUDING SELECTION

FILTER FOR ENTRY

FILTER BY FORM

EXERCISE. 21

USE ADVANCED FILTER/SORT

SORT ROWS

USE THE CRITERIA ROW

EXERCISE. 22

WORK WITH DATA ACCESS PAGES

ADD FIELDS

ALIGN AD SIZE CONTROLS

EXERCISE. 23

CRITICAL THINKING EXERCISE.

 

WORKING WITH QUERIES

 

 

EXERCISE. 24

QUERY BASICS

CREATE A QUERY

CHOOSING FIELDS FOR A QUERY

SORTING RECORDS IN A QUERY

CRITERIA IN A QUERY

DISPLAY THE DATABASE

SAVE A QUERY

EXECISE 25

USE ALL FIELDS OF A TABLE FOR A QUERY

CHANGE A QUERY DESIGN

DELETE AND MOVE FIELDS

RENAME A QUERY

PRINT A QUERY DATASHEET

EXERCISE. 26

CHANGE FIELD FORMAT IN QUERY DESIGN

CHANGE FIELD NAMES IN QUERY DESIGN

ADDING CALCULATIONS TO A QUERY

EXERCISE. 27

CREATE A QUERY USING DATA FROM MULTIPLE TABLES

EXERCISE. 28

CRITICAL THINKING EXERCISE.

 

MICROSOFT POWERPOINT LESSON PLANS

 

 

GETTING STARTED WITH POWERPOINT 2000

 

 

EXERCISE. 1

POWERPOINT BASICS

USE THE BLANK PRESENTATION OPTION

USE AUTOLAYOUT

LEARN THE POWERPOINT SCREEN ELEMENTS

USE THE TEMPLATE OPTION

INSERT TEXT IN A PRESENTATION

ADD SILDES TO PRESENTATION

SAVE A NEW PRESENTATION

SAVE A PRESENTATION AS A WEB PAGE

EXERCISE. 2

OPEN AN EXISTING PRESENTATION

WORK WITH SLIDE VIEW

MOVE AROUND IN A PRESENTATION

CHECK THE SPELLING IN A PRESENTATON

PRINT A PRESENTATION

CHANGE A SLIDE’S LAYOUT

APPLY A DIFFERENT TEMPLATE

EXERCISE. 3

INSERT OBJECTS IN A PRESENTATION

CORRECT ERRORS WITH UNDO

EXERCISE. 4

MOVE, COPY, DUPLICATE, AND DELETE SLIDES

WORK IN SLIDE SORTER VIEW

EXERCISE. 5

WORK IN OUTLINE VIEW

CREATE A SUMMARY SLIDE

EXERCISE. 6

USE DATA CREATED IN OTHER PROGRAMS

IMPORT/EXPORT AN OUTLINE CREATED IN WORK

LINK AN EXCEL WORKSHEET

EXERCISE. 7

CRITICAL THINKING EXERCISE.

 

EDITING AND FORMATTING A PRESENTATION

 

 

EXERCISE. 8

SELECT AND ALIGN TEXT IN A PRESENTATION

ENHANCE TEXT APPEARANCE

WORK WITH THE CHANGE CASE FEATURE

APPLY SLIDE COLOR SCHEMES AND BACKGROUNDS

EXERCISE. 9

COPY TEXT FORMATTING

MOVE AND COPY TEXT

ADJUST PARAGRAPH SPACING

WORK WITH OBJECTS

EXERCISE. 10

CREATE SLIDE AND TITLE MASTERS

WORK IN SLIDE MASTER VIEW

INSERT FOOTER TEXT

 CHANGE BULLETS

EXERCISE. 11

WORK WITH RULES AND GUIDES

USE FLOATING TOOLBARS

CREATE GRAPHIC OBJECTS

WORK WITH AUTOSHAPES

GROUP AND UNGROUP OBJECTS

LAYER OBJECTS

EXERCISE. 12

CREATE A CUSTOM TEMPLATE

WORK WITH CUSTOM TEMPLATES

EXERCISE. 13

ORGANIZATION CHART BASICS

EXERCISE. 14

USE CHARTS AND TABLES IN A PRESENTATION

EXERCISE. 15

EMBED A POWERPOINT SLIDE IN A WORK DOCUMENT

EXPORT POWERPOINT SLIDES AND NOTES TO A WORD DOCUMENT

EXPORT POWERPOINT TEXT TO A WORD DOCUMENT

EXERCISE. 16

CRITICIAL THINKING EXERCISE.

 

SETTING UP A SLIDE SHOW

 

 

EXERCISE. 17

CHECK SLIDES FOR STYLE AND CONSISTENCY

SHOW A PRESENATION

ADD TRANSITIONS, SOUNDS,AND TIMINGS

HIDE SLIDES

EXERCISE. 18

WORK WITH ANIMATION

USE THE ANIMATION EFFECT TOOLBAR

EXERCISE. 19

USE THE ANNOTATION FEATURE

ADD MUSIC AND MOVIE FILES TO A PRESENTATION

EXERCISE. 20

CREATE NOTES PAGS AND HANDOUTS

WORK WITH NOTES MASTER AND HANDOUT MASTER

USE THE PACK AND GO FEATURE

USE MEETING MINDER

INCORPORATE MEETING FEEDBACK

EXERCISE. 21

SET UP AND RUN A PRESENTATION

CREATE CONTINUOUSLY RUNNING PRESENTATIONS

EXERCISE. 22

SAVE A PRESENTATION AS A WEB SITE

PUBLISH A PRESENTATION

MAKE YOUR WEB PRESENTATION MORE EFFICIENT

EXERCISE. 23

EXPORT A PRESENTATION TO OVERHEAD

EXPORT A PRESENTATION TO 35MM SLIDES

FIND CLIP ART ON TAHE INTERNET

USE PRESENTATION CONFERENCING

EXERCISE. 24

CRITICAL THINKING EXERCISE.

 

MICROSOFT CHALLENGE

LESSON PLANS

 

 

EXERCISE. 1

RETRIEVE DATA FROM THE INTERNET

SEND DOCUMENT VIA E-MAIL

EXERCISE. 2

LOCATE DATA ON THE INTERNET

ENTER DATA INTO EXCEL WORKSHEET

INSERT WORKSHEET INTO WORK DOCUMENT

EXERCISE. 3

CREATE A POWERPOINT PRESENTATION FROM A WORD DOCUMENT

DOWNLOAD CLIP ART FROM THE WEB

INSERT CLIP ART IN A POWERPOINT PRESENTATION

LINK EXCEL DATA WITH A CHART ON A POWERPOINT SLIDE

EXERCISE. 4

CREATE A WEB PAGE WITH WORD

SAVE A PRESENTATION AS A WEB SITE

LINK THE WEB PAGE TO TH PRESENTATION WEB SITE

LINK THE WEB PAGE TO AN INTERNET SITE

EXERCISE. 5

EXPORT AN ACCESS TABLE TO EXCEL

E-MAIL AN EXCEL WORKSHEET

RECEIVE AN EXCEL WORKSHEET VIA E-MAIL AND SAVE IT IN HTML FORMAT

EDIT AN HTML WORKSHEET IN EXCEL

EXERCISE. 7

SAVE AN EXCEL WORKSHEET AS A WEB PAGE

LINK A WORD DOCUMENT TO THE EXCEL WEB PAGE

SEND THE WORD DOCUMENT VIA E-MAIL

EXERCISE. 8

SEND AN E-MAIL MESSAGE FROM WORD WITH A HYPERLINK TO AN EXCEL WORKSHEET

LINK A EXCEL WORKSHEET TO AN ACCESS DATABASE

USE THE LINKED WORKSHEET AS A DATA SOURCE FOR A MAIL MERGE

EXERCISE. 9

RETRIEVE CLIP ART FROM THE WEB

INSERT CLIP ART IN AN EXCEL WORKSHEET

COPY CHARTS FROM A WORKSHEET ONTO POWERPOINT SLIDES

SAVE THE PRESENTATION AS A WEB SITE

LINK A WORD DOCUMENT TO THE PRESENTATION WEB SITE

Back to HOME PAGE

Email Lawson

Back to TOP