In the Internet Explorer and Outlook Express lesson you start by visiting the web site of Office Pools Pty Ltd, gathering information from the pages and sending an e-mail (to a real address which will send you a reply) requesting information about their pools.
Then you switch to being an employee at Office Pools Pty Ltd and go through the process of creating a spreadsheet to compare the costs of operating a pool. (You can easily adapt this exercise to comparing, say, detailed quotes from two builders to add an extension to your home.) You will turn the data into a graph so it is very easy to see the cost differences (this is also a good way to spot where one builder might have missed things in the quote). You plot a simple work schedule using the spreadsheet (you can use this technique to plan any straight-forward task that is too messy to keep on scraps of paper -- such as selling, buying and moving house).
Then you jump over to the Sales Department at Office Pools where you use Microsoft PowerPoint to create a presentation about installing the pool. (You could do the same thing to give a group of Scouts or Guides an overview of their next trek, or to show how the local park will appear for the next fete.)
Next you will invoke the Magic Happens Here process. You will use a wizard to create a standard letter and convert it to a template for Office Pools staff to use when answering requests for pool information there is even an address where you can send the letter and one of us will try to reply. (You can use this same wizard to create invitations to a party at your house - the steps you use to draw the company logo are the same ones you can use to create 101 different drawings for the invitation - and you can send everyone the same kind of invitation. Great for fetes and other such occasions.)
And finally, because Office Pools looks like such a great place to work, you will use the Resume wizard to create a very attractive application for a job in their office. (By the way, this type of resume is easy to change and adapt for different types of jobs.)
| Introduction | Lesson Project Overview |
| Starting MS Word | Word Screen Views |
| Workspace - top toolbars | Workspace - bottom bars (1) |
| Workspace - bottom bars (2) | Workspace - scroll bars, rulers |
| Workspace - Tabs on the ruler | Workspace - Split Window |
| Configuration - Tools > Options | Configuration - View tab (1) |
| Configuration - View tab (2) | Configuration - View tab (3) |
| Configuration - General tab | Configuration - Edit tab |
| Configuration - Print tab | Configuration - Save tab |
| Configuration - Spell, Track Changes, etc. | Configuration - File Locations |
| Configuration - AutoFormatting | Configuration - modifying toolbars |
| Configuration - helpful Clipit | Clipit configuration |
| Starting to write a letter | Wizard - Recipient Info tab |
| Wizard - Other & Sender tabs | Wizard - envelope (1) |
| Wizard - envelope (2) | Think "template" |
| Customizing the appearance | Page Setup |
| Save as Template | Tools > Options > Save |
| Saving the Normal template |
| Write letter - Open and Save | Write letter - lists - bulleted |
| Write letter - lists - numbered | Write letter - lists - alphabetical |
| Write letter - lists - subparagraph | Create a table |
| Format text in a cell | Format text in columns |
| Format table appearance | Special text effects |
| Second page header & footer | Line and page breaks |
| Introduction | Objectives |
| Starting Excel | Configuring the screen |
| Options - View | Options - Calculation |
| Options - Edit | Options - General |
| Options - Transition | Custom Lists, Chart and Color |
| Workspace - main menu | Workspace - Toolbars |
| Workspace - Formula and Status bars, | Headings, Cells |
| Office Assistant | Clipit Options, Screen Tips |
| Introduction | Rename, headings, Series Fill, text entry |
| Clear Contents, number entry, $ Format, Formula | Formula entry and Copy |
| AutoSum | Formatting (Bold font, Color Fill, Border) |
| Print Preview |
| Creating a good data table | Series Fill, Fill Down |
| Autosum | Average |
| Cell formats ($, shading, text, borders) | Using the Chart Wizard - the simplest pathway |
| Positioning the chart | Page setup for printing |
| Introduction | Add tasks to schedule |
| Dynamic series | Dates, Column, Resizing columns |
| Formatting and Print Preview | Entering and copying simple formulae |
| Introduction | PowerPoint Features |
| Toolbars | Office Assistant |
| Closing PowerPoint | Opening PowerPoint |
| New PP session and AutoContent explained | Design Template explained |
| Blank presentation explained | Start Auto Content Wizard |
| Auto Content Wizard | Normal and Outline Views |
| Cancel New Presentation Dialog Box | Slide View |
| Slide Sorter View | Slide Show View |
| Notes Page | Basic Formatting and Editing |
| Formatting continued | More Formatting |
| Outline toolbar | Closing Statement |
| Open Design Template | Formatting |
| Using Master Slide | Working with a Blank Presentation |
| Apply a Design Template |
| Open an Existing Presentation | Modifying the Master Slide |
| Create Objects using Autoshapes | Resizing and Coloring Objects |
| Introduction | Internet Explorer Screen |
| Access a website with a known URL | Navigating a website - following links |
| Sending an e-mail from Internet Explorer | Setting the default e-mail application in Internet Explorer |
| Checking the Internet account setup in Internet Explorer |
| Introduction | Starting Outlook Express |
| Changing Outlook Express Screen Layout | Add a Sender to your Address Book |
| Create a Return E-Mail to a Sender | Explanation of Send/Receive |
| Create an E-mail using the Address Book | Creating an E-Mail without the Address Book |
| Checking if an E-Mail Account exists in OE |