Microsoft Office Secretarial Expert
This class is designed to be taught based on either Office 2000 or on Office XP (2002)

Course Length: 5 Weeks - Day Classes / 7 Weeks - Evenings (Total Hours: 91)

Overview: This course is for the student who wants to improve their resume and net worth by becoming proficient in every aspect of Microsoft Office 2000 / XP. The course begins with an introduction to the Windows operating system, and an overview of the Internet using Internet Explorer, sending and receiving E-mail, and how to do searches and research information on the World Wide Web. From there, Microsoft Office 2000 / XP, including Microsoft Word, Excel, Access, PowerPoint and Outlook, are covered in great depth. The courseware is M.O.U.S. Certified (Microsoft Office User Specialist) for those students wishing to eventually become Microsoft certified at a higher level. This course differs from many similar courses by first building a strong foundation in the ‘language’ of computers and the Internet – Microsoft Windows – and then developing a complete array of strong secretarial skills. 

Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities. 

Benefits: Students will first learn computer, network, and Internet basics. In addition, they will learn how to use the Windows environment to locate and manage information on their hard drive, to work with Windows programs, and to access and browse the World Wide Web. Once the basic foundations have been established, they will also become proficient with all the components of Microsoft Office 2000 / XP, developing expert secretarial skills necessary in today's business environment, and improving their resume and personal growth. 

Target student: Students enrolling in this course should understand very little about computers and working with the operating system.

Performance-based objectives: Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to: 

Windows / Internet 

Ø     Use fundamental personal computing concepts and terminology.

Ø     Work with Windows desktop objects and windows.

Ø     Navigate to information stored on their computer.

Ø     Use Windows Explorer to manage files and folders.

Ø     Use common Windows program techniques by working with WordPad and Paint.

Ø     Customize the Windows desktop to best suit their needs.

Ø     Access the Internet and use the basic functions of the Internet Explorer environment.

Ø     Explore some of Windows additional Accessory programs.

Ø     Describe the software and hardware required to connect to the Internet, and identify the main components of the Internet Explorer window.

Ø     Find Web sites that contain useful information, and use Favorites to maintain links to particularly useful sites.

Ø     Use Internet Explorer’s Help system to get information about how to browse more efficiently and effectively.

Ø     Download and unzip zipped files from the Internet, and browse and use files from an FTP site.

Ø     Use the Internet Options dialog box to specify a home page, control History, and change settings for temporary Internet files.

Ø     Personalize the default home page and identify other candidates to be used as a home page.

MS Word 2000 / XP 

Ø     Create and save a document; open an existing document; and use simple editing techniques.

Ø     Navigate in a large document by using the mouse and keyboard.

Ø     Edit a document by using more sophisticated techniques, including moving and copying text within a document and between documents.

Ø     Apply and remove character and paragraph formatting.

Ø     Use tabs and create and modify a table structure.

Ø     Adjust margins, add and delete page breaks, and create headers and footers.

Ø     Use Word’s proofing tools, such as the spelling checker and thesaurus, and print a document, envelope, and labels.

Ø     Save an existing document as a Web page and preview it in a browser.

Ø     Use section breaks to format a document and format text in columns.

Ø     Create, modify, and use tables as page-layout elements and sort table data.

Ø     Merge a document with data to make variations of one document.

Ø     Create, modify, and use styles to affect the appearance of text.

Ø     Create and use templates, including the fax template.

Ø     Create, modify, and use macros.

Ø     Use advanced techniques for working with styles.

Ø     Insert odd and even headers and footers, and adjust margins for document binding.

Ø     Enhance documents by drawing in a document and using clip art and WordArt.

Ø     Manage long documents by adding a table of contents, an index, bookmarks, and cross-references.

Ø     Manage document changes by creating different versions of a document, tracking document changes, adding comments, and accepting or rejecting document changes.

Ø     Prepare a document for an intranet by inserting hyperlinks, sound, a movie clip, and scrolling text into a web page.

MS Excel 2000 / XP

Ø     Identify the disadvantages of paper spreadsheets and the advantages of electronic spreadsheets by exploring both.

Ø     Create a basic worksheet by entering text, values, and formulas.

Ø     Create formulas by using Excel’s built-in functions.

Ø     Move and copy data by using shortcut menus, drag-and-drop editing, and toolbar buttons.

Ø     Change the appearance of worksheet data by using a variety of formatting techniques.

Ø     Prepare a document for printing by using the spell checking feature and a variety of printing options.

Ø     Use the three-dimensional aspect of the Excel workbook environment by creating formulas that refer to cells on multiple worksheets.

Ø     Save an Excel workbook as a Web page.

Ø     Create charts that graphically represent worksheet data.

Ø     Modify charts.

Ø     Customize charts by applying formatting.

Ø     Enhance worksheets and charts by using the drawing tools to add graphic objects.

Ø     Sort information in a list by using the Data, Sort command.

Ø     Locate information quickly in a list that meets specified conditions by using the Advanced filter feature.

Ø     Customize toolbars and create styles and templates.

Ø     Create decision-making functions.

Ø     Analyze worksheet data by creating pivot tables.

Ø     Compare and contrast workbook files and file links.

Ø     Outline and consolidate worksheets and analyze worksheet data by using the Scenario Manager.

Ø     Display and protect worksheet data by locking cells.

Ø     Record and modify macros by using the Visual Basic Editor.

Ø     Create and work with interactive Web documents.

MS Access 2000 / XP

Ø     Define the purpose of and terminology associated with a relational database and Access objects.

Ø     Follow the steps required to properly design a database.

Ø     Create tables to hold data and then establish table relationships.

Ø     Modify the design of and work with data in tables.

Ø     Create, modify the design of, and work with select queries.

Ø     Create and modify forms to work with your data.

Ø     Create and modify reports to select, organize, and print data.

Ø     Share data with other applications and enforce referential integrity.

Ø     Modify the design of a table to streamline data entry and maintain data integrity.

Ø     Use a filter to show records that match criteria and generate different query results by creating different types of joins between tables.

Ø     Create select queries that display special records and design other types of queries, including parameter and action queries.

Ø     Create forms and change their designs to enhance the appearance and usability of a form, and to make your form more professional.

Ø     Create reports and change their designs to better organize and summarize information, and to improve the appearance by enhancing data layout and working with report pagination.

Ø     Create, modify, and work with data access pages.

MS PowerPoint 2000 / XP

Ø     Start the PowerPoint program, identify on-screen features, and navigate through a presentation.

Ø     Create and edit bullet slides.

Ø     Use PowerPoint’s drawing tools to create a slide.

Ø     Incorporate clip art and WordArt objects in a slide.

Ø     Create and enhance organization charts, and create and edits charts by using Microsoft Graph.

Ø     Change the overall appearance of a presentation by using design templates and the Slide Master.

Ø     Run a slide show, become familiar with slide show options, and add notes to a slide.

Ø     Preview and save a PowerPoint presentation as a Web page and open a locally stored presentation in Internet Explorer.

Ø     Create a custom template by selecting a color scheme, background fill, fonts and clip art.

Ø     Enhance a presentation by using custom clip art, animation, and movies.

Ø     Work with embedded and imported objects by using Microsoft applications.

Ø     Customize the PowerPoint environment by modifying toolbars and using the Options dialog box.

Ø     Build interactive presentations by creating hyperlinks and action buttons and create custom slide shows.

Ø     Become familiar with collaboration features by creating online meetings and broadcast presentations.

MS Outlook 2000 / XP

Ø     Identify the elements of the Outlook application window and explore Outlook components.

Ø     Send, receive, and act on mail messages.

Ø     Use additional message-handling options, insert text into a message, and create multiple Signatures.

Ø     Create personal folders and organize Outlook 2000 / XP folders.

Ø     Create, edit, and categorize single appointments and recurring appointments and create events.

Ø     Create, send, and manage meeting requests.

Ø     Create, edit, and assign tasks, and create and edit contacts.

Ø     Manage and customize their mail environment by creating stationery and archiving mail messages.

Ø     Become familiar with some of Outlook’s advanced mail features, including importing a vCard file, creating a Personal Address Book, and sending and receiving a fax.

Ø     Customize Calendar options and share Calendar information with other users.

Ø     Use the Calendar to communicate with others over the Internet.

Ø     Manage contacts and tasks by flagging and exporting contacts and organizing tasks by category.

Ø     Work offline, including creating a quick synchronization group and synchronizing by message size, and familiarize themselves with the steps necessary for setting up Newsreader and sending and receiving information through Newsreader.

---

Class Title	Hours	Evenings	Days
Windows: Introduction	6.5	Mon / Tue	Monday
Internet Explorer & WWW	6.5	Wed / Thur	Wednesday
Word 2000 Level I	6.5	Mon / Tue	Friday
Word 2000 Level II	6.5	Wed / Thur	Monday
Word 2000 Level III	6.5	Mon / Tue	Wednesday
Excel 2000 Level I	6.5	Wed / Thur	Friday
Excel 2000 Level II	6.5	Mon / Tue	Monday
Excel 2000 Level III	6.5	Wed / Thur	Wednesday
Access 2000 Level I	6.5	Mon / Tue	Friday
Access 2000 Level II	6.5	Wed / Thur	Monday
PowerPoint 2000 Level I	6.5	Mon / Tue	Wednesday
PowerPoint 2000 Advanced	6.5	Wed / Thur	Friday
Outlook 2000 Level I	6.5	Mon / Tue	Monday
Outlook 2000 Advanced	6.5	Wed / Thur	Wednesday
Total Class Hours:	91
Total Weeks:		7 Weeks	5 Weeks
Total Package Cost:	$1,775
Class Times:		5:00pm - 8:15pm	9:00am - 4:30pm