|
Software |
Level |
Description |
|
Access |
1 |
·
examine the Microsoft® Office Access database application.
·
manage the data in a database.
·
examine existing table relationships.
·
query the database.
·
design simple forms.
·
create and modify Access reports. |
|
Access |
2 |
·
follow the steps required to properly design a simple database.
·
create a new database with related tables.
·
control data entry by modifying the design of a table to
streamline data entry and maintain data
integrity.
·
find and retrieve desired data by using filters and joins between
tables and within a single table.
·
create flexible queries to display specified records; allow for
user-determined query criteria; and add,
update, and delete data with queries.
·
enhance the appearance, data entry, and data access capabilities
of your forms.
·
customize reports to better organize the displayed information
and produce specific print layouts such
as mailing labels.
·
use Access data in other applications, including Microsoft Word
and Excel. |
|
Access |
3 |
·
restructure an existing set of data to improve the design of a
database.
·
use a variety of techniques to summarize and present data with
queries.
·
create and revise basic Access macros.
·
create macros that improve data entry efficiency and integrity.
·
improve the effectiveness of data entry in forms.
·
improve the effectiveness of data displayed in reports.
·
maintain an Access database by using various utility tools. |
|
Access |
4 |
·
develop a data access page.
·
develop a data access page, a PivotTable, and a PivotChart.
·
import XML data and export Access data.
·
use VBA to automate a business process.
·
create and modify a database switchboard, and set and modify your
startup options.
·
distribute a database and add security features to it. |
|
Excel |
1 |
·
create a basic worksheet.
·
modify a worksheet.
·
perform calculations.
·
format a worksheet.
·
develop a workbook.
·
print the contents of a workbook.
·
customize the layout of the Excel window. |
|
Excel |
2 |
·
create and apply templates.
·
create and modify charts.
·
work with graphic objects.
·
calculate with advanced formulas.
·
sort and filter data.
·
use Excel with the Web.. |
|
Excel |
3 |
·
Customize workbooks.
·
Collaborate with others using workbooks.
·
Audit worksheets.
·
Analyze data.
·
Work with multiple workbooks.
·
Import and export data.
·
Structure workbooks with XML. |
|
Excel |
4 |
·
Develop macros.
·
Format worksheets.
·
Create an interactive worksheet.
·
Work with multiple worksheets.
·
Perform calculations. |
|
Outlook |
1 |
·
identify the components of the Outlook environment and compose
and respond to a simple message.
·
compose messages.
·
use folders to manage mail.
·
schedule appointments.
·
schedule meetings.
·
manage contacts and contact information.
·
create and edit tasks.
·
create and edit notes.. |
|
Outlook |
2 |
·
track work activities using the Outlook Journal.
·
customize the calendar by setting various calendar options.
·
modify message options.
·
make folder information available to other Outlook users.
·
assign and track tasks.
·
customize the Outlook environment.
·
sort, find and color-code items in your mailbox and calendar. |
|
Outlook |
3 |
·
Communicate using MSN Messenger.
·
Personalize your mail by using stationery and signatures.
·
Organize Outlook items by grouping, creating Search Folders,
setting rules, and applying conditional
formatting.
·
Use contacts to share, link, and communicate information.
·
Save and archive mail.
·
Create a custom form.
·
Set up your computer for offline and remote use. |
|
PowerPoint |
1 |
·
manipulate an existing PowerPoint presentation.
·
begin creating a presentation.
·
format text slides.
·
add tables to a presentation.
·
chart data in a presentation.
·
modify objects on slides.
·
add images to a presentation.
·
prepare to deliver a presentation.. |
|
PowerPoint |
2 |
·
create a design template.
·
create organization charts and diagrams.
·
add special effects to a Microsoft® Office PowerPoint® 2003
slide.
·
create a Web-based Microsoft® Office PowerPoint® 2003
presentation.
·
use a Microsoft® Office PowerPoint® 2003 presentation for
collaborative workgroup review.
·
use functionality that will enable you to deliver live,
self-service, and online presentations |
|
Project |
1 |
·
create a project plan file and enter task information.
·
create a work breakdown structure by organizing tasks and setting
task relationships.
·
assign project resources.
·
finalize the project plan file. |
|
Project |
2 |
·
exchange project plan data with other applications.
·
update a project plan.
·
create custom reports.
·
re-use existing project plan information. |
|
Publisher |
1 |
·
create a one-page publication.
·
modify a publication's layout and structure.
·
edit content in a publication.
·
format text.
·
format pictures.
·
identify the options for distributing a publication |
|
Visio |
1 |
·
Identify the various types of drawings you can create using Visio
and navigate in a Visio document.
·
Drag shapes from Visio stencils and resize, rotate, align, and
transform them.
·
Increase your productivity with smart features, such as numbering
shapes automatically, duplicating shapes
quickly, and grouping and aligning.
·
Create a flowchart or a cross-functional flowchart.
·
Create an organization chart manually or generate one from a text
file.
·
Create an office floor plan to scale. |
|
Visio |
2 |
·
Open and manipulate toolbars and stencil windows in the work
area.
·
Change background settings to enhance specific drawings.
·
Use the drawing tools and Operation command features to create
new custom shapes.
·
Integrate both simple and complex custom shapes in a drawing.
·
Create new masters in a stencil and edit masters.
·
Use the Document stencil to quickly take inventory of all the
shapes used in a drawing.
·
Create a new custom template and use it to quickly create a
drawing.
·
Create and use styles to quickly format multiple shapes in a
drawing.
·
Use layers to organize and control shapes in a drawing.
·
Link a Visio drawing within a Microsoft Word document and update
any changes.
·
Link shapes in a drawing to information contained in an external
database.
·
Convert a drawing to a Web page.
·
Use several techniques for preparing a drawing for printing. |
|
Word |
1 |
·
create a basic document.
·
edit documents by locating and modifying text.
·
format text.
·
format paragraphs.
·
use Word tools to make your documents more accurate.
·
add tables to a document.
·
add graphic elements to a document.
·
control a document's page setup and its overall appearance. |
|
Word |
2 |
·
manage data in lists.
·
customize tables and charts.
·
customize formatting.
·
work with custom styles.
·
modify pictures in a document.
·
create customized graphic elements.
·
control text flow.
·
automate common tasks.
·
automate document creation.
·
perform mail merges. |
|
Word |
3 |
·
Use Word with other programs.
·
Collaborate on documents.
·
Add reference marks and notes to a document.
·
Make long documents easier to use.
·
Secure documents and document information.
·
Create Web pages.
·
Create a form.
·
Use XML in Word. |
|
Windows XP Professional |
1 |
·
Use fundamental personal computing terminology.
·
Use fundamental Windows XP skills.
·
Use Windows Explorer to manage files and folders.
·
Use common Windows XP program techniques by working with several
programs at the same time. |
|
Windows XP Professional |
2 |
·
Customize the Windows XP environment.
·
Share files, folders, and resources over a network.
·
Access the Internet using Windows XP programs.
·
Use Windows XP tools to maintain the computer. |
|
Windows Vista |
1 |
·
identify the basic components and capabilities of personal
computers.
·
explore Windows Vista.
·
customize the Windows Vista desktop.
·
use common tools and programs available in Windows Vista.
·
manage folders and files.
·
browse the Internet using Internet Explorer 7.0. |
|
Windows Vista |
2 |
·
customize the Windows Vista environment.
·
work with Windows Vista applications.
·
work with Internet Explorer 7.0.
·
manage network communication and sharing.
·
back up and restore files and folders.
·
enhance system performance using technologies available in
Windows Vista. |