|
|
|
|
Microsoft Office 2000 Course Outlines
Course customization There is virtually no such thing as a "stock" course at Fox Valley Computing; we’ve never believed in "one size fits all." We always strive to answer relevant student questions, and relate the software to the students’ (and your organization’s!) specific needs. Following are general course outlines for training at your site. We say "general" because every client’s training needs are different. We will be happy to perform a thorough needs analysis and propose a training solution package that is unique to your organization’s needs. Many times, more formal customization of our courseware is desired. We can customize the topics, combine lessons from multiple books, even print your company logo on the cover. We will be happy to assess your needs and make recommendations accordingly.
Microsoft Office 2000: New Features Performance-based objectives
* Use and customize components of the interface common to all Office 2000 programs, including the Office Assistant and online Help, adaptive menus and toolbars, and common dialog boxes. * Use new features of Word 2000, Excel 2000, and PowerPoint 2000 that make it faster and easier to perform everyday tasks. * Use new and improved features across the suite, including the Clipboard toolbar, ClipArt Gallery, and email tools. * Complete basic Web authoring tasks in Office 2000 including saving, previewing, and managing HTML files; create Web documents in each Office program that take advantage of new features related to Web authoring. Performance-based objectives
Word 2000: Level 2 Performance-based objectives
* 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. * Discuss Internet and Web features, create and edit a Web document, and preview a Web document in a browser. Word 2000: Advanced Performance-based objectives
* Use advanced techniques for working with styles. * Create and use templates and forms. * 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, cross-references, and odd and even headers and footers, and by adjusting margins for document binding. * 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. Performance-based objectives
* 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. Excel 2000: Charting and Organizing Data Performance-based objectives
* 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. Excel 2000: Advanced Performance-based objectives
* 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. Performance-based objectives
* 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. PowerPoint 2000: Advanced Performance-based objectives
* 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. Performance-based objectives
* Understand database concepts and terminology in Access 2000. * Design and create tables. * Enter and manipulate data in tables. * Use Access queries to select and analyze information in a table. * Create data forms for viewing and inputting data. * Create reports that summarize and group data. * Perform database maintenance procedures. Access 2000: Level 2 Performance-based objectives
* Normalize sample tables by identifying design problems. * Establish relationships between tables by analyzing table relationships and enforcing referential integrity. * Customize table designs by setting field properties to maintain data integrity, by creating a lookup list, and by creating indexes. * Design select queries by using multiple tables to calculate, group, average, and concatenate values and to show top values. * Customize form designs by creating calculated fields, combo boxes, and unbound controls. * Interact with data through a browser by creating and using data access pages. * Customize report designs by grouping, sorting, and summarizing data, and by adding subreports. Access 2000: Advanced Performance-based objectives
* Make select queries more versatile and useful by using parameters; use action queries to update data values and add or delete records. * Generate different query types by creating various types of joins between tables; use crosstab queries to summarize data. * Use advanced form features including properties, functions, and design tools to facilitate data entry and improve accuracy in forms; display table information that has a one-to-many relationship by creating forms that contain subforms. * Automate tasks by creating macros to open forms and control form properties. * Make forms more functional by using macros to provide user interaction and automate data entry. * Make reports more concise and easier to understand by using properties and functions in report controls; create mailing labels. * Use Internet-related Access tools by inserting hyperlinks and using the Web toolbar. Access 2000: Introduction to Application Development Performance-based objectives
* Design an application by defining application objectives and requirements and by using external data sources. * Navigate from one form to another in data-entry mode by using a command button. * Automate a form designed as a dialog box by using a macro group. * Create and modify a Switchboard form by using the Switchboard Manager. * Customize forms by creating custom toolbars and menus. * Create a form to use as a splash screen on application startup by setting properties and writing Visual Basic for Applications code. * Identify elements of Visual Basic for Applications syntax and decide where to place code by examining a global function, a module-level function, and an event procedure. * Secure an application by defining application-level and file-level security, by creating a workgroup information file, and by setting a database password. Performance-based objectives
* Identify the Outlook 2000 interface. * 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 folders. * Create, edit, and categorize single appointments and recurring appointments. * Create, send, and manage meeting requests. * Create, edit, assign, and track tasks, and create and edit contacts. Outlook 2000: Advanced Performance-based objectives
* Manage and arrange Outlook items by sorting, filtering, and using the Advanced Find feature; by displaying custom views; and by creating custom forms. * Customize the Outlook environment by creating custom toolbars and menu items to add to the Outlook Bar. * Communicate with contacts by sending faxes, share contacts with other users, automatically record items associated with contacts in the Journal by setting options in the Options dialog box, and organize contacts and notes. * Create and use templates and forms. * Integrate Outlook 2000 with Office applications by importing and exporting Office documents, creating an Office document in Outlook, and sending an Outlook message from Office applications. * Share information with other Outlook users by creating, replying to, and editing posts in public folders; creating and posting to Net Folders; and granting other Outlook users folder permissions. * Investigate Internet and remote mail features by accessing Internet Explorer from Outlook, creating Outlook items in Internet Explorer, creating messages in HTML format, adding hyperlinks, and discussing Microsoft NetMeeting, the Outlook Newsreader, and remote mail options. Performance-based objectives
* Create a new FrontPage web. * Create links between and within web pages. * Apply formatting to characters and paragraphs and apply themes. * Insert, size, align, and link images. * Create, modify, and enhance a table. * Perform basic web page management techniques. FrontPage 2000: Advanced Performance-based objectives
* Apply web site design considerations when creating a web site with a wizard. Students will also be able to add and modify structural elements in an existing web. * Apply web page design concepts to create and modify web pages by using frames. * Build a web-based form to collect and store user data. * Modify pictures as well as add sound and web components (such as rotating banner ads, marquee text, and ActiveX controls) to their web pages. * Use reports and tasks to manage and collaborate on web site creation. * Animate text and format text and web pages with Dynamic HTML and style sheets. Microsoft Office 2000: Document Integration Performance-based objectives
* Customize the Microsoft Office Shortcut Bar and use it to get help from the Office Assistant, open existing Office documents, and create new ones. * Use the Office Clipboard to copy and paste data between Office documents and create and edit links between Office applications. * Differentiate between embedding and linking, open and edit an embedded object, and use different methods to embed objects. * Leverage shared Microsoft Office 2000 features (hyperlinks) and tools (SpellChecker, AutoCorrect, WordArt, and clip art). * Use Microsoft Office Binder to modify and organize multiple documents. * Create a PowerPoint presentation based on a Word outline and existing slides, use the Meeting Minder, and preview a presentation as a Web page. * Use Outlook to track document activity, import an existing Access database, and use imported information in a Word mail merge. Microsoft Office 2000: Web Components and Collaboration Performance-based objectives
* Create Office 2000 Web documents by saving Word and PowerPoint documents as Web pages. * Create interactive Office 2000 Web documents by using Excel and Access Web Components when saving documents as Web pages. * Manipulate Office 2000 Web document information in a browser by using Office 2000 Web Components. * Create a corporate intranet web by collecting and publishing Office 2000 Web documents in FrontPage 2000. * Collaborate on documents in Office 2000 applications and in a browser by using the Web Discussions feature. * Share information with others by using the online broadcast and online meeting features. Microsoft Office 2000: Macro Programming Using Visual Basic for Applications Performance-based objectives
* Run macros and explain the basics of a Visual Basic Module. * Create relative and absolute recorded macros and assign macros to various objects in a workbook. * Write procedures that test conditions and then run only certain statements based on the results. * Write procedures that execute one or more lines of code repetitively. * Store Excel macros so they are available in any workbook. * Create macros in Word 2000. * Create macros that interact with the user.
Fox Valley Computing Corporate Computer Training Specialists1220 Anderson Drive Batavia, IL 60510 (630) 879-5629 Fax (630) 879-9793 |
|
Send mail to info@foxvalleycomputing.com with questions or comments about this web site.
|
Fox
Valley Computing uses courseware from Ziff-Davis Education, which is honored to have been
chosen to be the first Microsoft Independent Courseware vendor. Adhering to the strictest
standards, our courseware for Microsoft Office and Microsoft FrontPage is certified at the
Expert level (the highest level.)