Microsoft Office Suite Productivity Software By: Ms. A. Shier For: TIK2O1-16 and -17 (Sem. 2) Purpose: To teach MS-Office Applications Word, Excel, PPT, Access and Outlook Overview of MS-Office Suite  Your boss asks you to create a presentation that she can deliver at the annual stockholders’ meeting in 2 days. Although you know creating a professional presentation is a challenge, this is the opportunity you’ve been waiting for—you were hired, in part, because of your abilities to use productivity programs. Overview of MS-Office Suite  You get started right away by using MS- Access (DBMS) to generate reports that provide you with important information about your company’s activities throughout the year. You then import the data you’ve extracted from Access into MS-Excel so that you can perform some statistical analyses (continued)… Overview of MS-Office Suite  (continued)… and produce a number of key charts and graphs for the stockholders. Now that you’ve got the background materials covered, you open MS-Word and you paste the charts from Excel and a number of the Access reports you’ve generated (continued)…. Overview of MS-Office Suite  (continued)…. into your Word document. You also type and format a meeting agenda that your boss will distribute to the attendees. Now comes the fun part: You open MS- PowerPoint and create a professional, visually appealing presentation (con’d)… Overview of MS-Office Suite  Using the Word, Excel and Access documents you’ve already created. As you put the finishing touches on your presentation—embedding an MP3 file into the introduction slide—you realize that you’ve finally been able to use the skills you’ve worked so hard to acquire. Overview of MS-Office Suite  All of the programs you’ve used to create your presentation are components of a suite of software programs called Microsoft Office. This Spotlight explores the various programs, features and uses of the components of MS-Office Suite software. Introducing MS-Office  If Microsoft Windows is your desktop, then you will probably use the tools in MS-Office Suite to complete your work. MS-Office is retailed in 3 versions: Standard (also sold as the Student and Teacher edition at a reduced price); Small Business; and, Professional Introducing MS-Office  The Standard version includes Word, Excel, Outlook (for managing email and contacts), and PowerPoint. (Office for the Macintosh uses a program called Entourage for managing email and contacts.) The Professional version includes the Standard version, as well as Access and Publisher (desktop publishing software) Introducing MS-Office  Released in 2003, Office 2003 is the most recent version (aside from Office 2007) on the market. In the following slides, we will look more closely at how the components of MS- Office can help you represent your thoughts, ideas and solutions in a professional way. The Shared Office Interface and Tools  MS-Office applications use many interfaces that are similar to those used in Windows. When an application is opened, you’ll see some or all of the following features within the Application Window (the area the encloses and displays the application). The Shared Office Interface and Tools  The Application Workspace displays the document you are currently working on. In computing, a Document is any type of product you create with the computer, including typewritten work, an electronic spreadsheet, or a graphical image. The Shared Office Interface and Tools  The topmost area of each program interface is called the Title Bar. It includes the program icon, the name of the application, and the name of the file you are working on. If you haven’t yet saved the file, you’ll see a generic file name, such as Untitled or Document1. The Shared Office Interface and Tools  Within the Title Bar, you’ll find Window Controls, which enable you to maximize, or enlarge, the window so that it fills the whole screen; minimize, or hide, the window or button; restore the window to the preceding unmaximized size; and, close the window when you’ve finished.