|
Knowledge
Successful students will have demonstrated
knowledge of:
- Manage text, data and graphics using the
following Microsoft Office 2002 application
packages: EXCEL, POWERPOINT and WORD.
- Use WORD to create a variety of advanced
documents and customize and automate the user
interface.
- Use spreadsheets for decision-making and present
numerical data in a meaningful way with the use
of tables, charts and graphs.
- Create on-screen presentations using Microsoft
PowerPoint 2002
- Prepare for a Vendor certification test by
demonstrating the ability to understand the
objectives and perform the skills required by
Microsoft to pass the WORD 2002 Expert and EXCEL
2002 Core MOUS tests.
- Apply previously acquired knowledge in a
self-directed manner.
Skills
Successful students will have demonstrated further
development in their abilities to:
- Use a wide range of editing and formatting
features.
- Work with advanced WORD features needed to
produce large documents, including outline,
columns, headers/footers, endnotes/footnotes,
automatically generated table of contents and
indexes.
- Create and modify WORD macros, styles, templates
and forms.
- Produce promotional documents such as flyers,
newsletters and announcements using graphics,
lines, borders, and shading.
- Use the merge mail features to customize
reports, letters and labels.
- Create a WORD form template with text, checkbox and
drop-down fields.
- Use PowerPoint to create and modify a
presentation and add transition and animation
effects.
- Modify the template of an existing presentation
by changing its colour scheme and/or background
shading.
- Use EXCEL to manipulate functions, formulas,
charts, clip art, and maps
- Print large worksheets with formulas or values,
headers/footers and gridlines.
- Integrate Excel with other programs and use it
to create web pages.
- Use filtering, sorting, subtotalling and pivot
table to organize and summarize data.
- Work with shared documents.
Attitudes
Successful students will have demonstrated
attitudes of:
- attention to detail when creating documents of
any kind
- the ability to remain calm when attempting to
solve computer-related problems
- confidence in his or her ability to learn a new
software application or package
- willingness to assist and teach other users when
appropriate
- an understanding of time management as it
relates to the challenges of problem-solving
|