|
Knowledge
- Manage text, data and graphics using the following Microsoft Office
XP application.
- Use Object linking and Embedding (OLE)to share information between
various application packages.
- Manage information using Microsoft Access 2002 to create tables,
reports, queries and forms.
- Create on-screen presentations, transparencies and slides using
Microsoft PowerPoint 2002.
- Use spreadsheets for decision-making and presenting numerical data
in a meaningful way with the use of tables, charts and graphs.
- Use the Internet to search for information and graphics to use in a
number of Office XP applications.
Skills
Successful students will have demonstrated further development in
their abilities to:
USE WORD 2002 to:
- Use the merge mail features to customize reports, letters and
labels
- Create and modify styles and templates
- Work with advanced features needed to produce large documents,
including outline, headers/footers, automatically generated table of
contents and indexes
- Insert graphics downloaded from the Internet into Word documents
- Integrate Word with other programs and with the world wide web.
USE EXCEL 2002 TO:
- Manipulate functions, formulas, charts and graphs
- Distinguish between a workbook and a worksheet
- Print large worksheets with formulas or values, headers/footers and
gridlines
- Differentiate between relative, absolute and mixed addresses
- Use the IF function to implement a decision
- Distinguish between different types of charts, stating the
advantages and disadvantages of each
- Create a compound document consisting of a word processing memo, a
worksheet and a chart
- Customize existing toolbars and buttons or create new ones
- Integrate Excel with other programs and with the world wide web
USE ACCESS 2002 to:
- Define the following terms: field, record, table and database
- Describe a relational database; distinguish between a one-to-many
and a many-to-many relationship
- Describe the data types and properties available within Access and
the purpose of each: set the primary key for a table
- Create more advanced queries and forms without the use of a Wizard
- Use controls, boxes and buttons in the creation of forms
- Differentiate between a query and a table; explain how the objects
in an Access database (tables, forms, queries and reports) interact
with one another
- Customize reports
- Integrate Access with other programs
USE POWERPOINT 2002 TO:
- Create, modify and view an existing presentation
- Use the Outline view to add or delete slides
- Add clip art to an existing slide
- Use the Rehearse Timings feature, the Meeting Minder, Slide
Navigator and Pen
- Apply a design template to a presentation
- Add transition effects to the slides in a presentation; apply
animation effects to the bullets and graphical objects in a specific
slide
- Modify the template of an existing presentation by changing its
colour scheme and/or background shading
- Use a slide master to format a presentation
- Integrate PowerPoint with other programs and with the world wide web
Attitudes
Successful students will have demonstrated attitudes of:
1. flexibility, responsibility, honesty
2. willingness to work with others
3. an ability to tackle problems in a systematic and methodical
manner
4. attention to detail when creating documents of any kind
5. the ability to remain calm when attempting to solve
computer-related problems
6. confidence in his or her ability to learn a new software
application or package
7. willingness to assist and teach other users when appropriate
8. an understanding of time management as it relates to the
challenges of problem-solving
|