Microsoft Word 2000

1. Working with text

1. Use the Undo, Redo, and Repeat commands
2. Apply font formats (Bold, Italic and Underline)
3. Use the SPELLING feature
4. Use the THESAURUS feature
5. Use the GRAMMAR feature
6. Insert page breaks
7. Highlight text in document
8. Insert and move text
9. Cut, Copy, Paste, and Paste Special using the Office Clipboard
10. Copy formats using the Format Painter
11. Select and change font and font size
12. Find and replace text
13. Apply character effects (superscript, subscript, strike through, small caps and outline)
14. Insert date and time
15. Insert symbols
16. Create and apply frequently used text with Auto Correct

2. Working with paragraph

1. Align text in paragraphs (Center, Left, Right and Justified)
2. Add bullets and numbering
3. Set character, line, and paragraph spacing option
4. Apply borders and shading to paragraphs
5. Use indentation option (Left, Right, First Line and Changing Indent
6. Use TABS command (Center, Decimal, Left, and Right)
7. Create and outline style numbered list
8. Set tabs with leader

3. Working with document

1. Print a document
2. Use print preview
3. Use Web page preview
4. Navigate through a document
5. Insert page numbers
6. Set page orientation
7. Set margins
8. Use Go To to locate specific elements in a document
9. Create and modify page numbers
10. Create modify headers and footers
11. Align text vertically
12. Create and use newspaper columns
13. Revise column structure
14. Prepare and print envelopes and labels
15. Apply styles
16. Create sections with formatting that differs from other sections
17. Use click & type

4. Managing files

1. Use save
2. Locate and open an existing document
3. Use Save As (different name, location or format)
4. Create a folder
5. Create a new document using a Wizard
6. Save as Web Page
7. Use templates to create a new word document
8. Create Hyperlinks
9. Use the Office Assistant
10. Send a Word document via e-mail

5. Using tables

1. Create and format tables
2. Add borders and shading to tables
3. Revise tables (insert & delete rows and columns, change cell formats)
4. Modify able structure (merge cells, change height and width)
5. Rotate text in a table

6. Work with pictures and charts

1. Use the drawing toolbar
2. Insert graphics into a document (Word Art, Clip art, Images)

back to top

Microsoft Excel 2000

1. Working with cells

1. Use Undo and Redo
2. Clear cell content
3. Enter text, dates, and numbers
4. Edit cell content
5. Go to a specific cell
6. Insert and delete selected cells
7. Cut, copy, paste special and move selected cells, use the Office Clipboard

2. Working with files

1. Use Save
2. Use Save As (different name, location, format)
3. Locate and open an existing workbook
4. Create a folder
5. Use templates to create a new workbook
6. Wave a worksheet/workbook as a Web Page
7. Send a workbook via e-mail
8. Use the Office Assistant

3. Formatting worksheets

1. Apply font styles (typeface, size, color and styles)
2. Apply number formats (currency, percent, dates, comma)
3. Modify size of rows and columns
4. Modify alignment of cell content
5. Adjust the decimal place
6. Use the Format Painter
7. Apply auto format
8. Apply cell borders and shading
9. Merging cells
10. Rotate text and change indents
11. Define, apply, and remove a style

4. Page setup and printing

1. Preview and print worksheets & workbooks
2. Use Web Page Preview
3. Print a selection
4. Change page orientation and scaling
5. Set page margins and centering
6. Insert and remove a page break
7. Set print, and clear a print area
8. Set up headers and footers
9. Set print titles and options (grid lines, print quality, row & column headings)

5. Working with worksheets & workbooks

1. Insert and delete rows and columns
2. Hide and unhidden rows and columns
3. Freeze and unfreeze rows and columns
4. Change the zoom setting
5. Move between worksheets in a workbook
6. Check spelling
7. Rename a worksheet
8. Insert and Delete worksheets
9. Move and copy worksheets
10. Link worksheets & consolidate data using 3D References

6. Working with formulas & functions

1. Enter a range within a formula by dragging
2. Enter formulas in a cell and using the formula bar
3. Revise formulas
4. Use references (absolute and relative)
5. Use Auto Sum
6. Use paste Function to insert a function
7. Use basic functions (average, sum, count, min, max)
8. Enter function using the formula palette
9. Use date fractions (now and date)
10. Use financial functions (FV and PMT)
11. Use logical functions (IF)

7. Using charts and objects

1. Preview and print charts
2. Use chart wizard to create a chart
3. Modify charts
4. Insert, move, and delete an object (picture)
5. Create and modify lines and objects

back to top

Microsoft Access 2000

1. Planning and designing databases

1. Determine appropriate data inputs for your database
2. Determine appropriate data outputs for your database
3. Create table structure
4. Establish table relationships

2. Working with Access

1. Use the Office Assistant
2. Select and object using the Objects Bar
3. Print database objects (tables, forms, reports, queries)
4. Navigate through records in a tale, query, or form
5. Create a database (using a Wizard or in Design View)

3. Building and modifying tables

1. Create tables by using the Table Wizard
2. Set primary keys
3. Modify field properties
4. Use multiple data types
5. Modify tables using Design View
6. Use the Lookup Wizard
7. Use the input mask wizard

4. Building and modifying forms

1. Create a form with the Form Wizard
2. Use the Control Toolbox to add controls
3. Modify Format Properties (font, style, font size, color, caption, etc.) of controls
4. Use form sections (headers, footers, detail)
5. Use a Calculated Control on a form

5. Viewing and organizing information

1. Use the Office Clop board
2. Switch between object Views
3. Enter records using a data sheet
4. Enter records using a form
5. Delete records from a table
6. Find a record
7. Sort records
8. Apply and remove filters (filter by form and filter by selection)
9. Specify criteria in a query
10. Display related records in a subtotals
11. Create a calculated field
12. Create and modify a multi-table select query

6. Defining relationships

1. Establish relationships
2. Enforce referential integrity

7. Producing reports

1. Create a report with the Report Wizard
2. Preview and print a report
3. Move and resize a control
4. Modify format properties (font, style, font size, color, caption, etc.)
5. Use the Control Toolbox to add controls
6. Use report sections (headers, footers, detail)
7. Use a Calculated Control in a report

8. Integrating with other application

1. Import data to a new table
2. Save a table, query, form as a Web page
3. Add Hyperlinks

9. Using Access Tools

1. Print Database Relationships
2. Backup and Restore a database
3. Compact and Repair a database

back to top

Microsoft Powerpoint 2000

1. Creating a presentation

1. Delete slides
2. Create a specified type of slide
3. Create a presentation from a template and/or a Wizard
4. Navigate among different views (slide, outline, sorter, tri-pane)
5. Create a new presentation from existing slides
6. Copy a slide from one presentation into another
7. Insert headers and footers
8. Create a Blank presentation
9. Create a presentation using the Auto Content Wizard
10. Send a presentation via e-mail

2. Modifying a presentation

1. Change the order of slides using Slide Sorter blew
2. Find and replace text
3. Change the layout for one or more slides
4. Change slide layout (Modify the Slide Master)
5. Modify slide sequence in the outline
6. Apply a design template

3. Working with text

1. Check spelling
2. Change and replace text fonts (individual slide and entire presentation)
3. Enter text in tri-pane view
4. Import Text from Word
5. Change the text alignment
6. Create a text box for entering text
7. Use the Wrap text in Text Box feature
8. Use the Office Clipboard
9. Use the Format Painter
10. Promote and Demote text in slide & outline panes

4. Working with visual elements

1. Add a picture from the Clip Art Gallery
2. Add and group shapes using Word Art or the Drawing Toolbar
3. Apply formatting
4. Place text inside a shape using a text box
5. Scale and size an object including Clip Art
6. Create tables within Powerpoint
7. Rotate and fill an object

5. Customizing a presentation

1. Add Auto Number bullets
2. Add speaker notes
3. Add graphical bullets
4. Add slide transitions
5. Animate text and objects

6. Creating output

1. Preview presentation in black and white
2. Print slides in a variety of formats
3. Print audience handouts
4. Print speaker notes in a specified format

7. Delivering a presentation

1. Start a slide show on any slide
2. Use on screen navigation tools
3. Print a slide as an overhead transparency
4. Use the pen during a presentation

8. Managing files

1. Save changes to a presentation
2. Save as a new presentation
3. Publish a presentation to the Web
4. Use Office Assistant
5. Insert hyperlink

back to top

1. The student develops the skills to create and present accurate and effective communication (oral and written) tailored to the specific purpose and needs of the audience.