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