UNIT 1: Office Word 2003
-
Explain the merge process
-
Use the Mail Merge Wizard and the Mail Merge toolbar
-
Use a letter template for the main document in a mail merge
-
Insert and format an AutoShape on a drawing canvas
-
Create and edit a data source
-
Insert and edit merge fields in a main document
-
Use an IF field in a main document
-
Create an outline numbered list
-
Merge and print form letters
-
Sort data records
-
Address and print mailing labels and print envelopes
-
Merge all data records to a directory
-
Change page orientation
-
Close all open Word documents
Collaboration Feature – Using Word’s Collaboration Tools
UNIT 2: Office PowerPoint 2003
Using
Visuals to Enhance a Slide Show
-
Create presentations using visuals
-
Open a Microsoft Word outline as a presentation
-
Add a picture to create a custom background
-
Format text-bases content
-
Insert and modify a clip
-
Customize bullets using the slide master
-
Insert and format a table
-
Create and format an organization chart
-
Apply a new design template to a single slide
-
Rearrange slides
-
Add an animation scheme to selected slides
-
Print slides as handouts
Modify Visual
Elements and Presentation Formats
-
Create presentations using the Autocontent Wizard
-
Create and scale a WordArt element and add it to the slide
-
Add sound effects and hyperlinks to slide
-
Create presentations using the Autocontent Wizard
-
Insert a chart, an Excel chart, and a Word table
-
Use a Thesaurus
-
Modify a presentation template by changing the color scheme
-
Add information to the slide master Footer Area
-
Add an action button and action setting
-
Apply transition effects to a presentation
-
Rehearse presentation timings and run a slide show with
hyperlinks
-
Print speaker notes
UNIT 3 Office Excel 2003
Creating, Sorting, and Querying a List
-
Create and manipulate a list
-
Delete sheets in a workbook
-
Validate data
-
Add computational fields to a list
-
Use the VLOOKUP function to look up a
value in a table
-
Use the Toggle Total Row in a list
-
Print a list
-
Display, add, and delete records and
change field values in a worksheet list
-
Sort a list on one field or multiple
fields
-
Display automatic subtotals
-
Use Group and Outline features to hide
and unhide data
-
Query a list
-
Apply functions, SUMIF and COUNTIF to
generate information from a list
-
Save a workbook in different file
formats
Creating
Templates and Working with Multiple Worksheets and Workbooks
-
Create and use a template
-
Use the ROUND function
-
Utilize custom format codes
-
Define, apply, and remove a style
-
Use the Research task pane to find a synonym
-
Add a worksheet to a workbook
-
Create formulas that use 3-D references
-
Draw a 3-D Cylinder chart
-
Use WordArt to create a title and create and modify lines and
objects
-
Assign comments to cells
-
Use the Research task pane to research a topic
-
Add a header or footer, change margins, and insert a page
break
-
Use the Find and Replace commands
-
Search for files and create and use a workspace file
-
Consolidate data by linking workbooks
UNIT 4:Office Access 2003
Reports, Forms, and Combo
Boxes
-
Create a report using the Report Wizard
-
Use sorting and grouping in a report
-
Move controls
-
Change properties
-
Add totals and subtotals to a report
-
Align and format controls
-
Remove controls
-
Change labels and column headings
-
Use multiple tables in a report
-
Remove unwanted controls
-
Understand report design considerations
-
Use the Form Wizard to create a form
-
Add a calculated field, combo boxes, and
a title to a form
|
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
|
