• General Question/Answer session
• Work directly in your course

• Content areas

• Uploading documents
• Modifying information
• Inserting URLs
• Using the Assignments tools

• Content areas

• Uploading documents
• Modifying information
• Inserting URLs
• Using the Assignments tools

• Content areas

• Creating Folders
• Creating Learning Units
• Inserting Course Links
• Copy from one place to another within a course

• General Question/Answer session
• Work directly in your course

• Content areas

• Creating Folders
• Creating Learning Units
• Inserting Course Links
• Copy from one place to another within a course

• General Question/Answer session
• Work directly in your course

• Test Manager
• Pool Manager

• Test Manager
• Pool Manager

• Gradebook
• Gradebook Views

• Gradebook
• Gradebook Views

• Chapter 1: The Fundamentals
• Starting Microsoft Excel
• Giving commands to Excel
• Entering labels and values into a workbook
• Navigating a workbook
• Naming and saving a workbook
• Previewing, and printing a workbook
• Closing a workbook and exiting Excel

Chapter 2: Editing a Worksheet

• Enter and work with date values
• Edit, clear, and replace cell contents
• Cut, copy, paste, and move cells
• Work with and understand Absolute and Relative cell references
• Insert and delete cells, rows, and columns
• Use Undo and Redo
• Check the spelling of your worksheets
• Use advanced print options
• Basic file management
• Insert cell comments

Chapter 3:  Formatting a Worksheet

• Format fonts with the Formatting toolbar and menus
• Format values
• Adjust row height and column width
• Align a cell’s contents
• Add borders, colors, and patterns to cells
• Use the format painter to copy formatting
• Create a custom number format
• Create, apply, and modify a Style
• Use conditional formatting
• Merge cells

Chapter 5: Managing Your Workbooks

• Navigate between the sheets in a workbook
• Insert, delete, rename, and move worksheets
• Work with several worksheets and workbooks
• Split and freeze a window
• Add headers, footers, and page numbers to a worksheet
• Specify what gets printed and where the page breaks
• Adjust the margins, page size and orientation, and print scale
• Protect and hide a worksheet
• Create and use a template
• Consolidate multiple worksheets

Chapter 7: Working with Lists

• Create a list
• Use the Data Form to add, find, edit, and delete records
• Sort a list
• Use the AutoFilter to filter a list
• Create a custom AutoFilter
• Create and use an advanced filter
• Use data validation when entering records to a list

Chapter 9: Working with Other Programs

• Insert an Excel worksheet into a Word document
• Modify an embedded worksheet
• Link an Excel chart into a Word document
• Insert a graphic into a worksheet
• Open and save files in different formats

Chapter 4: Creating and Working with Charts

• Create a chart
• Move and resize a chart
• Format objects in a chart
• Change a chart’s source data
• Change a chart type
• Add titles, gridlines, annotations, and a data table to a chart
• Work with a 3-D chart
• Create and work with a custom chart
• Plot data on a map

Chapter 12: What-if Analysis

• Create a Scenario
• Create a Scenario Summary Report
• Create One and Two-Input Data Tables
• Use Goal Seek
• Set up complex what-if analysis with Solver

Chapter 6: More Functions and Formulas

• Create a formula with several operators and cell ranges
• Use the Insert Function feature to enter and edit formulas
• Create and use range names
• Select nonadjacent cell ranges
• Use the AutoCalculate feature
• Create a conditional formula with the IF function
• Use the PMT function
• Display and print formulas in a worksheet
• Identify and fix formula errors

Chapter 11: Data Analysis and PivotTables

• Create a PivotTable
• Change or “Pivot” a PivotTable
• Use the Page Field to filter what data is displayed in a PivotTable
• How to group information in a PivotTable by date
• Create and work with subtotals
• Use Database functions (DSUM)
• Use Lookup functions (VLOOKUP)
• Group and outline a worksheet

Chapter 8: Automating Tasks with Macros

• Record a macro
• Play a macro
• Assign a shortcut key and toolbar button to a macro
• Edit a macro’s Visual Basic code
• Insert code into an existing macro
• Declare variables using the DIM statement
• Prompt for user input
• Use If…Then statements

Chapter 10: Using Excel with the Internet

• Add Hyperlinks to a Worksheet
• Browse Hyperlinks and using the Web Toolbar
• Save a Workbook as a Non-Interactive Web Page
• Save a Workbook as an Interactive Web Page
• Retrieve Information from a Web Page

Chapter 13: Advanced Topics

• Add, Remove, and Position Toolbars
• Create a Custom Toolbar
• Create a Custom AutoFill List
• Password Protect a Workbook
• Change Excel’s Default Options
• Find a File
• View and Change a File’s Properties
• Share a Workbook for Group Collaboration
• Revise a Shared Workbook

Chapter 1: The Fundamentals

• Starting Microsoft Word
• Give commands to Word
• Entering text and working with automatic corrections
• Inserting and deleting text
• Naming and saving a document
• Printing and closing a document
• Exiting Word

Chapter 2: Working with and Editing Text

• Opening a document and giving it a different name
• Understanding how to move through a document
• Viewing a document in different modes
• Cutting, copying, and pasting text
• Finding and replacing text
• Using spelling checking, the thesaurus, and word count
• Inserting special characters
• Using undo and redo
• Specifying which pages to print or printing multiple document copies

Chapter 3: Formatting Characters and Paragraphs

• Formatting characters
• Changing a paragraph’s alignment and spacing
• Indenting paragraphs
• Setting, changing, and removing tab stops
• Creating bulleted and numbered lists
• Adding borders and shading to a paragraph
• Understanding text flow and spacing before and after a paragraph

Chapter 4: Formatting Pages

• Changing a document’s margins
• Creating headers and footers
• Changing page orientation between portrait and landscape
• Previewing a document
• Controlling where the page breaks
• Adding section breaks and applying multiple page formats
• Printing envelopes
• Printing on both sides of the paper

Chapter 5: Working with Tables

• Creating a table
• Adjusting row height and column width
• Inserting and deleting rows and columns
• Formatting a table with borders and shading
• Formatting characters and paragraphs in a table
• Splitting and merging cells in a table
• Sorting information in a table
• Performing calculations in a table
• Working with tables that span over multiple pages

Chapter 6: Working with Templates and Styles

• Creating and using templates
• Creating and applying paragraph styles
• Creating and applying a character style
• Modifying an existing style
• Displaying styles in a document
• Attaching a different template to a document
• Copying styles between documents and templates

Chapter 7: Drawing and Working with Graphics

• Drawing on your documents
• Adding, arranging, and formatting text boxes
• Selecting, resizing, formatting, and deleting objects
• Inserting clip art and pictures
• Specifying how text wraps around pictures and text
• Aligning and grouping objects
• Drawing AutoShapes
• Flipping and rotating objects
• Layering objects
• Applying shadows and 3-D effects

Chapter 11: Working with WordArt and Charts

• Inserting a WordArt Object
• Formatting and Editing a WordArt Object
• Creating a Chart and Modifying a Chart
• Selecting a Chart Type
• Creating an Organization Chart
• Modifying and Formatting an Organization Chart

Chapter 8: Performing a Mail Merge

• Creating and working with a mail merged Main Document
• Creating a data source for the mail merge
• Entering records to the data source
• Inserting merge fields to the Main Document
• Selecting specific records to merge
• Creating and working with labels
• Using an existing database as the data source
• Creating and working with envelopes

Chapter 10: Working with Outlines and Long Documents

• Using Outline View to create an outline
• Viewing an outline—expanding and collapsing headings
• Organizing an outline
• Adding cross-references
• Adding bookmarks
• Adding footnotes
• Creating a table of contents
• Creating an index
• Creating a master document

Chapter 12: Working with Other Programs

• Inserting an Excel worksheet file into a Word document
• Modifying an embedded Excel worksheet
• Inserting a linked Excel chart in a Word document
• Opening and saving a WordPerfect file in Word
• Switching from WordPerfect to Microsoft Word

Chapter 13: Working with Forms

• Creating a new form
• Adding text fields to a form
• Adding check boxes to a form
• Adding drop-down fields to a form
• Assigning help to form fields
• Performing calculations in a form field
• Saving and filling out an form

Chapter 14: Creating Web Pages with Word

• Creating a Web page with the Web Page Wizard
• Modifying an existing Web page
• Converting an existing Word document to a Web page
• Adding hyperlinks to a Web page
• Viewing a Web page in a Web browser
• Applying a theme to Web page or document
• Working with frames

Chapter 9: Collaboration

• Adding revisions to a document
• Accepting and rejecting objectives
• Inserting comments
• Saving versions of a document
• Protecting a document
• Comparing documents

Chapter 1: The Fundamentals

• Starting Microsoft PowerPoint
• Understand the PowerPoint Program Screen
• Using Menus and Toolbars
• Using and Filling Out Dialog Boxes
• Using Keystroke Shortcuts and Right Mouse Button Menus
• Opening and Saving Presentations
• Creating a New Presentation
• Viewing and Printing a Presentation
• Moving around a Presentation

Chapter 2: Editing a Presentation

• Inserting New Slides and Entering Text
• Working in Outline View—Promoting and Demoting Slides
• Editing, Selecting, Replacing, and Deleting Text
• Cutting, Copying, and Pasting Text
• Finding and Replacing Text
• Using Undo, Redo, and Repeat
• Checking the Spelling in a Presentation
• Reorganizing a Presentation in Outline View
• Copying, Moving, and Deleting Slides in Slide Sorter View
• Adding Notes to Your Slides
• Working with More than One Presentation and Window
• Managing Your Files

Chapter 3: Formatting a Presentation

• Formatting Fonts
• Using the Format Painter to Copy and Apply Formatting
• Applying a Template’s Design to a Presentation
• Using Slide Masters
• Working with Color Schemes
• Changing the Slide Background
• Creating and Formatting Bulleted Lists
• Changing Paragraph Alignment and Line Spacing
• Checking Your Presentations for Visual Clarity
• Working Tabs and Indents and Changing the Page Setup

Chapter 4: Drawing and Working with Graphics

• Drawing on your slides
• Adding, arranging, and formatting text boxes
• Selecting, resizing, formatting, and deleting objects
• Inserting clip art and pictures
• Aligning and grouping objects
• Drawing AutoShapes
• Flipping and rotating objects
• Layering objects
• Applying shadows and 3-D effects

Chapter 5: Working with Tables and WordArt

• Creating and Working with a Table
• Adjusting Column Width and Row Height
• Inserting and Deleting Rows and Columns
• Adding Borders and Shading to a Table’s Cells
• Inserting a WordArt Object
• Formatting and Editing a WordArt Object

Chapter 6: Working with Graphs and Organizational Charts

• Creating a Chart and Modifying a Chart
• Selecting a Chart Type
• Creating an Organization Chart
• Modifying and Formatting an Organization Chart

Chapter 7: Delivering Your Presentation

• Delivering a Presentation on a Computer
• Using Slide Transitions
• Animating Text and Objects
• Rehearsing Slide Show Timings
• Creating a Presentation that Runs by Itself
• Creating a Custom Show

Chapter 8: Working with Multimedia

• Using the Pack and Go Wizard to Play a Presentation on another Computer
• Creating 35mm Slides and Using the Genigraphics Wizard
• Using the Meeting Minder
• Presenting a Slide Show over a Network or the Internet

Chapter 9: Working with Other Programs and the Internet

• Inserting Sound Files into Your Presentation
• Adding Voice Narration to Your Slides
• Inserting a Video Clip
• Creating a Custom Sound Track
• Automating the Multimedia in Your Presentation
• Inserting a Slide into a Microsoft Word Document
• Embedding a Microsoft Excel Worksheet into a Slide
• Modifying an Embedded Object
• Importing and Exporting an Outline
• Using Hyperlinks and Action Buttons
• Saving a Presentation as a Web Page

• Chapter 10: Advance Topics
• Adding, Positioning, and Removing Toolbars
• Customizing Toolbars
• Adding Comments to a Slide
• Customizing PowerPoint’s Defaults Options
• Viewing File Properties and Finding a File
• Recording a Macro
• Playing, Editing, and Deleting a Macro

• TBA