OFF 101: Introduction to Microsoft Office Applications

• Demonstrate proficiency in working with the Windows environment
• Demonstrate knowledge of Microsoft Word by creating, saving, and editing flyers, letters, research papers, newsletters, and mail merged documents.
• Demonstrate knowledge of Microsoft Excel by creating, editing, analyzing, and saving spreadsheets with formulas, charts, graphics, and web pages.
• Demonstrate knowledge of Microsoft Access by creating, editing, sorting, filtering, and saving a database with tables, queries, forms, and reports.
• Demonstrate knowledge of Microsoft PowerPoint by developing a presentation, formatting, applying transitions, summarizing data, and analyzing tables and charts in a presentation
• Demonstrate integrating Word, Excel, Access, and PowerPoint by linking and exporting data into a document.
• Demonstrate the basic use of Microsoft Outlook in creating e-mail and contacts.

1. Introduction to Windows Environment and Microsoft Office
2. Overview of Computers
3. Word Processing
   1. Creating, editing retrieving, and saving documents
   2. Character, paragraph, and document formatting
   3. Spelling, grammar checker, and thesaurus
   4. Headers/footers
   5. Footnotes/endnotes
   6. Changing styles and creating a multi-level list
   7. Merge mailing labels and create a newsletter 
   8. Viewing documents
   9. Printing
   10. Creating letters, memos, reports, flyers
4. Spreadsheets
   1. Creating, editing, retrieving, and saving spreadsheets
   2. Formatting spreadsheets
   3. Using formulas and functions
   4. Copying, moving, deleting, and inserting
   5. Cell referencing: absolute vs. relative
   6. Edit values and constructing formulas for mathematical operations
   7. Create, sort, filter a worksheet
   8. Create a data table, validate data and define names 
   9. Creating and printing graphs and charts
5. Database
   1. Designing, creating, editing database
   2. Inserting and deleting records
   3. Saving, previewing, and printing reports
   4. Create, sort, filter a database
   5. Querying ad database
   6. Maintaining a database
   7. Creating forms and reports
6. Presentation
   1. Creating, editing, and saving a presentation
   2. Formatting a presentation with special features
   3. Creating and editing outlines
   4. Adding and editing clip art
   5. Adding, slide transitions, text builds, and automatic timing
   6. Presenting an electronic slide show
7. Object Linking and Embedding
8. Time Management
   1. Creating a schedule
   2. Entering appointments/recurring appointments
   3. Opening, editing, deleting, and saving a schedule
   4. Moving appointments
   5. Printing a schedule
   6. Using event scheduler
   7. Creating and printing a to-do list
   8. Creating and printing a contact list
9. Internet
   1. Browsing
   2. Using search engines
   3. Creating, sending, and retrieving email
   4. Downloading files
   5. Internet etiquette/ethics

1. Lab assignments with business document processing to apply each computer application.

2. Quizzes to test the theory of the applications.

3.  Training and applying concepts through testing.