|
|
|
|
Microsoft Office 95 Course Outlines
Performance-based objectives
* Identify some fundamental personal computing concepts and terminology, such as hardware components, software, and computer networks. * Examine and identify components of the Windows 95 screen; select items with the mouse pointer; access Windows features by using the Start button; and work with windows by using buttons and dragging techniques. * Observe the contents of a hard disk by using the My Computer icon; observe shared resources by using the Network Neighborhood icon; and access a disk quickly by creating a desktop shortcut. * Become accustomed to common Windows program techniques by experimenting with Help and WordPad. * Work with multiple programs by using the taskbar to switch between tile windows. * Share data between programs by using the Edit, Copy and Edit, Paste commands; create simple graphic shapes by using the Paint accessory. * Display the contents of disks by using the Windows Explorer; create a folder by using a shortcut menu; copy and move documents and folders by dragging them; and sort and locate documents by using the Windows Explorer. * Prepare a disk for use with the Format command; copy and move groups of documents; delete and restore documents by using the Recycle Bin; and exit Windows by using the Shut Down command. Word 7.0: Level 1 (Windows 95) Performance-based objectives
* 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 speller and thesaurus. Word 7.0: Level 2 (Windows 95) Performance-based objectives
* Create, modify, perform calculations in, and import data in tables * Use styles to affect the appearance of paragraphs and create outlines * Create and use templates, and create a fax template * Merge a document with data to create multiple variations of a document * Create, run, and edit macros * Format text in columns with graphics; use section breaks to format a document Word 7.0: Advanced (Windows 95) 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 * Create a master document, a table of contents, and an index * Enhance document layout * Use highlights, comments, and revision marks to edit and share documents online Excel 7.0: Worksheets (Windows 95) Performance-based objectives
* Understand 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. Excel 7.0: Charting and Organizing Data (Windows 95) 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 7.0: Advanced (Windows 95) Performance-based objectives
* Customize toolbars and create styles and templates. * Create nested and decision making functions. * Analyze worksheet data by creating pivot tables. * Compare and contrast workbook files and file links. * Outline and consolidate worksheets; analyze worksheet data by using the Solver and Scenario Manager. * Display and protect worksheet data by locking cells. * Record and modify macros by using the Visual Basic Editor. PowerPoint 7.0: Introduction (Windows 95) 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 edit 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. PowerPoint 7.0: Advanced (Windows 95) Performance-based objectives
* Create a custom template by selecting a color scheme, background fill, and fonts. * Enhance a presentation by using graphic objects. * Examine the concept of embedded and imported information by using Microsoft applications. * Enhance a slide containing a flow chart by using advanced drawing techniques. * Customize the PowerPoint environment by modifying toolbars and using the Options dialog box. * Enhance a presentation by using animation. * Bring PowerPoint meeting notes into Word by using the Meeting Minder. Access 7.0: Level 1 (Windows 95) Performance-based objectives
* Understand database concepts and terminology in Access 7.0. * 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 7.0: Level 2 (Windows 95) 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 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. * Display table information that has a one-to-many relationship by creating forms that contain subforms. * Customize report designs by grouping, sorting, and summarizing data, and by adding subreports. Access 7.0: Advanced (Windows 95) Performance-based objectives
* Make select queries more versatile by using parameters; and use action queries to update data values and add or delete records. * Refine the information derived from queries by creating outer joins and using crosstab queries. * Enhance form design by manipulating control object properties. * Automate simple tasks by creating macros to open forms and control form properties. * Make forms more functional and automate tasks by creating macros. * Enhance the design of reports by hiding repetitive data, grouping data on prefix values, and using functions in controls. Microsoft Exchange Client 5.0: Introduction Performance-based objectives
* Understand basic email concepts, and address, create, and send Exchange messages to other Exchange users and to Internet users. * Use the Address Book to create a personal address book and personal distribution lists; handle received messages by replying to, forwarding, printing, and deleting messages. * Share information with other network users by attaching files; use custom forms to send messages. * Use Schedule+ to schedule appointments; edit, move, and delete appointments. * Use Schedule+ to schedule and manage meetings with other Exchange users. * Use the Inbox Assistant and Out of Office Assistant to create rules to forward, move, and automatically reply to messages. * Manage the email messages they receive by locating, sorting, filtering, and adding columns; apply custom views and create personal and public folders.
Microsoft Office for Windows 95: Document Integration Performance-based objectives
* Use the Microsoft Office Shortcut Bar by clicking on its buttons and changing its location on the screen. * Access documents and create new documents by using Office Shortcut Bar buttons. * Share data among documents by using the Copy and Paste, and Copy and Paste Special, Paste Link commands. * Place objects from various applications in other files by embedding them. * Experiment with shared Office tools by dragging and dropping objects between applications and by using the shared dictionary and AutoCorrect list. * Integrate PowerPoint slides and notes with Word by using the Meeting Minder, Write-Up, and Report-It features. * Use the Office Binder application to combine and work with different types of documents. * Change the Office Shortcut Bar's appearance by customizing it.
|
|
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.)