Office Business Writing Lessons and Topics by yaq43915

VIEWS: 0 PAGES: 13

									ElementK  MS Office / Business Writing Lessons and Topics 
 
 
Scroll through document to view lessons and topics, or click a link below to jump to the detail page 
for that application. 
 
 
       Access 2007 Level 1 
       Access 2007 Level 2 
       Excel 2007 Level 1 
       Excel 2007 Level 2 
       Outlook 2007 Level 1 
       Outlook 2007 Level 2 
       PowerPoint 2007 Level 1 
       PowerPoint 2007 Level 2 
       Word 2007 Level 1 
       Word 2007 Level 2 
       Effective Business Writing 
       Persuasive Business Writing 
       Grammar Essentials 
                               
ElementK  MS Office / Business Writing Lessons and Topics 
 
 
Access 2007 Level 1 
 
1. Exploring the Access Environment             2. Designing a Database
     Lesson Introduction                            Lesson Introduction
     Examine Database Concepts                      Describe the Relational Database Design Process
     Explore the User Interface                     Define Database Purpose
     Use an Existing Access Database                Review Existing Data
     Customize the Access Environment               Determine Fields
     Obtain Help                                    Group Fields into Tables
     Lesson Lab                                     Normalize Data
     Lesson Follow Up                               Designate Primary and Foreign Keys
                                                    Determine Table Relationships
                                                    Lesson Lab
                                                    Lesson Follow Up
                                                 
3. Building a Database                          4. Managing Data in a Table
    Lesson Introduction                             Lesson Introduction
    Create a New Database                           Modify Table Data
    Create a Table                                  Sort Records
    Manage Tables                                   Work with Subdatasheets
    Create a Table Relationship                     Lesson Lab
    Save a Database as a Previous Version           Lesson Follow Up
    Lesson Lab                                      Lesson Follow Up
    Lesson Follow Up                             
 
5. Querying a Database                          6. Designing Forms
    Lesson Introduction                                  Lesson Introduction
    Filter Records                                       View Data Using an Access Form
    Create a Query                                       Create a Form
    Add Criteria to a Query                              Modify the Design of a Form
    Add a Calculated Field to a Query                    Lesson Lab
    Perform Calculations on a Record Grouping            Lesson Follow Up
    Lesson Lab                                   
    Lesson Follow Up
 
7. Generating Reports
    Lesson Introduction
    View an Access Report
    Create a Report
    Add a Custom Calculated Field to a Report
    Format the Controls in a Report
    Apply an AutoFormat Style to a Report
    Prepare a Report for Print
    Lesson Lab
 
 
                               
ElementK  MS Office Library Titles and Topics 
 
 
Access 2007 Level 2  
 
1. Controlling Data Entry                                2. Joining Tables
         Lesson Introduction                                      Lesson Introduction
         Restrict Data Entry Using Field Properties               Create Query Joins
         Establish a Pattern for Entering Field Values            Join Unrelated Tables
         Create a List of Values for a Field                      Relate Data Within a Table
         Lesson Lab                                               Lesson Lab
         Lesson Follow Up                                         Lesson Follow Up
                                                          
 3. Creating Flexible Queries                            4. Improving Forms
         Lesson Introduction                                      Lesson Introduction
        Set Select Query Properties                               Design a Form Layout
        Create Parameter Queries                                  Enhance the Appearance of a Form
        Create Action Queries                                     Restrict Data Entry in Forms
        Lesson Lab                                                Add a Command Button to a Form
        Lesson Follow Up                                          Create a Subform
                                                                  Lesson Lab
                                                                  Lesson Follow Up
                                                          
5. Customizing Reports                                   6. Sharing Data Across Applications
         Lesson Introduction                                      Lesson Introduction
         Organize Report Information                              Import Data into Access
         Format the Report                                        Export Data
         Set Report Control Properties                            Analyze Access Data in Excel
         Control Report Pagination                                Export Data to a Text File
         Summarize Report Information                             Merge Access Data with a Word Document
         Add a Subreport to an Existing Report                    Lesson Lab
         Create a Mailing Label Report                            Lesson Follow Up
         Lesson Lab                                       
         Lesson Follow Up
 
 
     
                                    
ElementK  MS Office Library Titles and Topics 
 
 
Excel 2007 Level 1  
 
1.  Creating a Basic Worksheet                    2. Performing Calculations
     Lesson Introduction                               Lesson Introduction
     Explore the User Interface and the Ribbon         Create Basic Formulas
     Navigate and Select in Excel                      Calculate with Functions
     Obtain Help                                       Copy Formulas and Functions
     Enter Data and Save a Workbook                    Lesson Lab
     Customize the Quick Access Toolbar                Lesson Follow Up
     Lesson Lab                                    
     Lesson Follow Up
 
3. Modifying a Worksheet                          4. Formatting a Worksheet
    Lesson Introduction                                Lesson Introduction
    Manipulate Data                                    Modify Fonts
    Insert and Delete Cells, Columns, and Rows         Add Borders and Color to Cells
    Search for Data in a Worksheet                     Change Column Width and Row Height
    Spell Check a Worksheet                            Apply Number Formats
    Lesson Lab                                         Position Cell Contents
    Lesson Follow Up                                   Apply Cell Styles
                                                       Lesson Lab
                                                       Lesson Follow Up  
                                                   
5. Printing Workbook Contents                     6. Managing Large Workbooks
     Lesson Introduction                              Lesson Introduction
     Print Contents Using Default Print Options       Format Worksheet Tabs
     Set Print Options                                Manage Worksheets in a Workbook
     Set Page Breaks                                  Manage the View of Large Worksheets
     Lesson Lab                                       Lesson Lab
     Lesson Follow Up                                 Lesson Follow Up
                                                   
 
 
                                 
ElementK  MS Office Library Titles and Topics 
 
 
Excel 2007 Level 2 
 
1. Calculating Data with Advanced Formulas           2. Organizing Worksheet and Table Data
    Lesson Introduction                                  Lesson Introduction
    Manage Cell and Range Names                          Create and Modify Tables
    Calculate Data Across Worksheets                     Format Tables
    Use Specialized Functions                            Sort or Filter Worksheet or Table Data
    Analyze Data with Logical and Lookup Functions       Calculate Data in a Table or Worksheet
    Lesson Lab                                           Lesson Lab
    Lesson Follow Up                                     Lesson Follow Up
                                                      
3. Presenting Data Using Charts                      4. Analyzing Data Using PivotTables and
     Lesson Introduction                             PivotCharts
     Create a Chart                                       Lesson Introduction
     Modify Charts                                        Create a PivotTable Report
     Format Charts                                        Analyze Data Using PivotCharts
     Lesson Lab                                           Lesson Lab
     Lesson Follow Up                                     Lesson Follow Up
                                                      
5. Inserting Graphic Objects                         6. Customizing and Enhancing Workbooks and
     Lesson Introduction                             the Excel Environment
     Insert and Modify Pictures and ClipArt               Lesson Introduction
     Draw and Modify Shapes                               Customize the Excel Environment
     Illustrate Workflow Using SmartArt Graphics          Customize Workbooks
     Layer and Group Graphic Objects                      Manage Themes
     Lesson Lab                                           Create and Use Templates
     Lesson Follow Up                                     Lesson Lab
                                                          Lesson Follow Up
                                                      
 
 
                                
ElementK  MS Office Library Titles and Topics 
 
 
MS Office Outlook 2007 Level 1 
 
1. Getting Started with Outlook                2. Composing Messages
    Lesson Introduction                            Lesson Introduction
    Explore the Outlook Interface                  Address a Message
    Send a Simple Message                          Format a Message
    Read Messages                                  Check Spelling and Grammar
    Reply to and Forward a Message                 Attach a File
    Print a Message                                Lesson Lab
    Delete a Message                               Lesson Follow Up
    Lesson Lab                                  
    Lesson Follow Up
 
3. Organizing Messages                         4. Managing Contacts
    Lesson Introduction                            Lesson Introduction
    Open and Save an Attachment                    Add a Contact
    Flag a Message                                 Sort and Find Contacts
    Organize Content with Folders                  Find the Geographical Location of a Contact
    Lesson Lab                                     Manage Contacts
    Lesson Follow Up                               Lesson Lab
                                                   Lesson Follow Up
                                                
5. Scheduling Appointments                     6. Scheduling Meetings
     Lesson Introduction                            Lesson Introduction
     Explore the Outlook Calendar                   Schedule a Meeting
     Schedule an Appointment                        Reply to a Meeting Request
     Assign Categories and Edit Appointments        Propose a New Meeting Time
     Lesson Lab                                     Manage Meetings
     Lesson Follow Up                               Print the Calendar
                                                    Lesson Lab
                                                    Lesson Follow Up
                                                
7. Managing Tasks and Notes
    Lesson Introduction
    Create a Task
    Edit and Update a Task
    Create a Note
    Edit a Note
    Display a Note on the Desktop
    Lesson Lab
    Lesson Follow Up
 
 
 
                               
ElementK  MS Office Library Titles and Topics 
 
 
MS Office Outlook 2007 Level 2 

1. Setting Calendar Options                          2. Customizing Message Options
     Lesson Introduction                                 Lesson Introduction
     Set Work Days and Times                             Modify Message Settings
     Display an Additional Time Zone                     Modify Delivery Options
     Set Availability Options                            Change the Message Format
     Lesson Lab                                          Notify Others that You Will Be Out of the Office
     Lesson Follow Up                                    Create a Distribution List
                                                         Insert a Hyperlink
                                                         Lesson Lab
                                                         Lesson Follow Up

3. Tracking Work Activities Using the Journal        4. Managing Tasks
     Lesson Introduction                                 Lesson Introduction
     Automatically Record a Journal Entry                Assign a Task
     Manually Record a Journal Entry                     Reply to a Task Request
     Modify a Journal Entry                              Send a Task Update
     Lesson Lab                                          Track Assigned Tasks
     Lesson Follow Up                                    Lesson Lab
                                                         Lesson Follow Up

5. Sharing Folder Information                        6. Customizing the Outlook Environment
     Lesson Introduction                                 Lesson Introduction
     Specify Folder Permissions                          Customize the Toolbar
     Delegate Access to Folders                          Create a New Toolbar
     Access Another User's Folder                        Customize the Menu Bar
     Send Calendar Information in an Email Message       Customize the Quick Access Toolbar
     Lesson Lab                                          Customize the To-Do Bar
     Lesson Follow Up                                    Create a Folder Home Page
                                                         Lesson Lab
                                                         Lesson Follow Up

7. Locating Outlook Items                            8. Working with Public Folders
     Lesson Introduction                                 Lesson Introduction
     Sort Messages Using Multiple Criteria               Create a Public Folder
     Find Messages                                       Add Users to a Public Folder
     Find Outlook Items Using Multiple Criteria          Post Information in a Public Folder
     Filter Messages                                     Send an Email Message to a Public Folder
     Organize Messages                                   Lesson Lab
     Manage Junk Email                                   Lesson Follow Up
     Lesson Lab
     Lesson Follow Up


 
                                 
ElementK  MS Office Library Titles and Topics 
 
 
MS Office PowerPoint 2007 Level 1 
 
1. Getting Started with PowerPoint        2. Creating a Presentation
    Lesson Introduction                        Lesson Introduction
    Explore the User Interface                 Create a Presentation
    Navigate and View a Presentation           Edit Text
    Use Microsoft PowerPoint Help              Add Slides to a Presentation
    Enter Text                                 Arrange Slides
    Save a Presentation                        Work with Themes
    Lesson Lab                                 Lesson Lab
    Lesson Follow Up                           Lesson Follow Up
                                           
3. Formatting Text on Slides              4. Adding Graphical Objects to a Presentation
     Lesson Introduction                      Lesson Introduction
     Apply Character Formats                  Insert Clip Art and Pictures
     Apply Paragraph Formats                  Draw Shapes
     Format Text Placeholders                 Insert WordArt
     Lesson Lab                               Lesson Lab
     Lesson Follow Up                         Lesson Follow Up
                                           
5. Modifying Objects                      6. Adding Tables to a Presentation
    Lesson Introduction                       Lesson Introduction
    Work with Objects                         Create a Table
    Change Object Orientation                 Format Tables
    Format Objects                            Insert a Table from Microsoft Word
    Group and Ungroup Objects                 Lesson Lab
    Arrange Objects                           Lesson Follow Up
    Lesson Lab                             
    Lesson Follow Up
 
7. Inserting Charts in a Presentation     8. Preparing to Deliver a Presentation
     Lesson Introduction                       Lesson Introduction
     Create a Chart                            Review Content
     Edit Chart Data                           Add Transitions
     Modify a Chart                            Apply an Animation Effect
     Paste a Chart from Microsoft Excel        Create Speaker Notes
     Lesson Lab                                Print a Presentation
     Lesson Follow Up                          Lesson Lab
                                               Lesson Follow Up
                                           
 
 
                               
ElementK  MS Office Library Titles and Topics 
 
 
MS Office PowerPoint 2007 Level 2 
 
1. Customizing the PowerPoint Environment         2. Customizing a Design Template
    Lesson Introduction                               Lesson Introduction
    Customize the Quick Access Toolbar                Set Up a Slide Master
    Personalize the PowerPoint Interface              Customize Slide Layouts
    Customize Save Options                            Create Custom Themes
    Apply Advanced Customization Options              Add Headers and Footers
    Lesson Lab                                        Modify the Notes Master
    Lesson Follow Up                                  Modify the Handout Master
                                                      Lesson Lab
                                                      Lesson Follow Up
                                                   
3. Adding Diagrams to a Presentation              4. Adding Special Effects to Presentations
    Lesson Introduction                               Lesson Introduction
    Create Diagrams                                   Add Multimedia Elements
    Modify Diagrams                                   Customize Slide Component Animations
    Lesson Lab                                        Lesson Lab
    Lesson Follow Up                                  Lesson Follow Up
                                                   
5. Customizing a Slide Show Presentation          6. Collaborating on a Presentation
    Lesson Introduction                               Lesson Introduction
    Set Up a Custom Show                              Review a Presentation
    Annotate a Presentation                           Publish Slides to a Slide Library
    Create a Presenter-Independent Slide Show         Share a Presentation
    Set Up a Slide Show to Repeat Automatically       Lesson Lab
    Lesson Lab                                        Lesson Follow Up
    Lesson Follow Up                               
 
7. Securing and Distributing a Presentation
     Lesson Introduction
     Secure Presentations
     Package a Presentation
     Publish a Presentation as a Web Page
     Lesson Lab
     Lesson Follow Up
 
 
 
                               
ElementK  MS Office Library Titles and Topics 
 
 
MS Office Word Level 1 
 
1. Creating a Basic Document                    2. Editing a Document
     Lesson Introduction                             Lesson Introduction
     Explore the User Interface                      Navigate and Select Text in a Document
     Open and View a Document                        Insert, Delete, or Rearrange Text
     Customize the Word Environment                  Undo Changes
     Obtain Help                                     Search and Replace Text
     Enter Text                                      Lesson Lab
     Save a Document                                 Lesson Follow Up
     Preview and Print a Document                
     Lesson Lab
     Lesson Follow Up
 
3. Formatting Text                              4. Formatting Paragraphs
     Lesson Introduction                             Lesson Introduction
     Change Font Appearance                          Set Tabs to Align Text
     Highlight Text                                  Control Paragraph Layout
     Lesson Lab                                      Add Borders and Shading
     Lesson Follow Up                                Apply Styles
                                                     Create Lists
                                                     Manage Formatting
                                                     Lesson Lab
                                                     Lesson Follow Up
                                                 
5. Adding Tables                                6. Inserting Graphic Objects
    Lesson Introduction                              Lesson Introduction
    Create a Table                                   Add Visual Effects Using Symbols/Special Characters
    Modify the Table Structure                       Insert Illustrations
    Format a Table                                   Lesson Lab
    Convert Text to a Table or Tables to Text        Lesson Follow Up
    Lesson Lab                                   
    Lesson Follow Up
 
7. Controlling Page Appearance                  8. Proofing a Document
    Lesson Introduction                              Lesson Introduction
    Control Page Layout                              Check Spelling, Grammar, and Word Count
    Apply a Page Border and Color                    Enhance Textual Meaning Using the Thesaurus
    Add Watermarks                                   Customize AutoCorrect Options
    Add Headers and Footers                          Lesson Lab
    Lesson Lab                                       Lesson Follow Up
    Lesson Follow Up                             
 
 
 
                                
ElementK  MS Office Library Titles and Topics 
 
 
MS Office Word Level 2 
 
1. Managing Lists                                    2. Customizing Tables and Charts
    Lesson Introduction                                  Lesson Introduction
    Sort a List                                          Sort Table Data
    Renumber a List                                      Control Cell Layout
    Customize Lists                                      Perform Calculations in a Table
    Lesson Lab                                           Create Charts
    Lesson Follow Up                                     Lesson Lab
                                                         Lesson Follow Up
                                                      
3. Customizing Formatting with Styles and Themes     4. Modifying Pictures
    Lesson Introduction                                  Lesson Introduction
    Create or Modify a Text Style                        Resize a Picture
    Create a Custom List or Table Style                  Adjust Picture Appearance Settings
    Apply Default and Customized Document Themes         Wrap Text Around a Picture
    Lesson Lab                                           Lesson Lab
    Lesson Follow Up                                     Lesson Follow Up
                                                      
5. Creating Customized Graphic Elements              6. Inserting Content Using Quick Parts
     Lesson Introduction                                  Lesson Introduction
     Create Text Boxes and Pull Quotes                    Insert Building Blocks
     Draw Shapes                                          Create Building Blocks
     Add WordArt and Other Special Effects to Text        Modify Building Blocks
     Create Complex Illustrations with SmartArt           Insert Fields Using Quick Parts
     Lesson Lab                                           Lesson Lab
     Lesson Follow Up                                     Lesson Follow Up
                                                      
7. Controlling Text Flow                             8. Using Templates to Automate Document
    Lesson Introduction                              Creation
    Control Paragraph Flow                               Lesson Introduction
    Insert Section Breaks                                Create a Document Based on a Template
    Insert Columns                                       Create a Template
    Link Text Boxes to Control Text Flow                 Lesson Lab
    Lesson Lab                                           Lesson Follow Up
    Lesson Follow Up                                  
 
9. Automating Mail Merges                            10. Using Macros to Automate Tasks
    Lesson Introduction                                  Lesson Introduction
    Perform a Mail Merge                                 Perform a Task Automatically Using a Macro
    Mail Merge Envelopes and Labels                      Create a Macro
    Use Word to Create a Data Source                     Lesson Lab
    Lesson Lab                                           Lesson Follow Up
    Lesson Follow Up

 
                                
ElementK  Effective Business Writing Skills Titles and Topics 
 
 
Effective Business Writing 
 
1. Writing Effective Business Communication                    2. Writing a Business Letter
    Lesson Introduction                                            Lesson Introduction
    Analyze Your Audience                                          Write a Business Letter
    Write an Internal Announcement                                 Write a Thank You Letter
    Write Email Responding to Routine Requests                     Lesson Lab
    Write Email to Respond Positively to Customer Complaints       Lesson Follow Up
    Write Bad-News Messages                                     
    Business Simulation
    Lesson Follow Up
 
 
 
 
 
Persuasive Business Writing 
 
1. Writing Effective Business Communication
    Lesson Introduction
    Persuade Your Audience
    Write an Executive Summary
    Use Visuals
    Business Simulation
    Lesson Follow Up
 
 
                               
ElementK  Effective Business Writing Skills Titles and Topics 
 
 
Grammar Essentials 
 
1. Identifying Nouns, Pronouns, and Verbs             2. Identifying Adjectives and Adverbs
     Lesson Introduction                                   Lesson Introduction
     Identify Nouns                                        Use Adjectives
     Identify Pronouns                                     Use Adverbs
     Identify Verbs                                        Lesson Follow Up
     Lesson Follow Up

2. Identifying Prepositions, Conjunctions             3. Identifying Rules
     Lesson Introduction                                   Lesson Introduction
     Use Prepositions                                      Monitor Sentences
     Use Conjunctions                                      Monitor Modifiers
     Use Interjections                                     Avoid Common Errors
     Lesson Follow Up                                      Simulation
                                                           Lesson Follow Up

4. Identifying Correct Punctuation                    5. Improving Word Choices
     Lesson Introduction                                  Lesson Introduction
     Identify Sentence Fragments                          Identify Commonly Misused Words
     Identify Run-Ons, Comma Splices, and Solutions       Identify Synonyms, Antomyms, Homonyms
     Lesson Follow Up                                     Lesson Follow Up

6. Building Effective Sentences                       7. Editing Effectively
    Lesson Introduction                                    Lesson Introduction
    Identify the Goal                                      Use Correct Spelling
    Consider the Audience                                  Achieve Clarity
    Consider the Context                                   Lesson Follow Up
    Lesson Follow Up

8. Avoiding Hypercorrections
    Lesson Introduction
    Avoid Hypercorrections
    Achieve Simplicity
    Lesson Follow Up

 

								
To top