Presentation ECDL ICDL Advanced

Presentation ECDL ICDL Advanced

Microsoft PowerPoint 2003 Edition for ECDL Advanced

Outline

1) DESIGN CONSIDERATION

AUDIENCE AND ENVIRONMENT

• To plan a presentation with consideration to the environment and equipment

• To set up the audience seating appropriate to the venue

• To determine the needs of your prospective audience

ASSIMILATION

• To determine the most effective way an audience will learn by viewing the presentation

• To use colour in a presentation

DELIVERY

• To plan and design the presentation using a storyboard and time-line

2) SLIDES

SETUP

• To create a new presentation template

• To add custom background fill effects to the template

• To insert an image into the template

• To remove the image background colour

• To add bullets to the template

• To adjust the spacing between bullet points

• To merge two presentations into a single presentation

• To create an outline for a presentation using a word-processor

• To create new slides in the presentation by merging the word-processed outline

• To add a gradient background colour to a slide, or slides

• To apply a texture to the background of a slide or slides

• To apply a pattern to the background of a slide or slides

• To apply a picture to the background of a slide or slides

EXPORTING

• To save a slide in a specific picture format to a drive

3) PICTURES, IMAGES, DRAWN OBJECTS

MANIPULATION

• To convert a picture to a drawn object

• To group several drawn objects on a slide

• To ungroup several drawn objects on a slide

• To change the order of objects in a slide

• To change the position of an object in a slide using specific co-ordinates

• To distribute selected objects relative to a slide

• To remove a background from a slide

EFFECTS

• To make a picture, image, or drawn object semi-transparent

• To apply a 3-D effect to a drawn object

• To apply a shadow to a picture, image, or drawn object

• To reposition a shadow on a picture, image, or drawn object

• To change a shadow to a specific colour on a picture, image, or drawn object

• To apply a graduated background fill to a drawn object

• To apply a texture to a drawn object

• To apply a pattern to a drawn object

• To apply a picture to a drawn object

• To transfer a style from an object and apply it to another

EDITING IMAGES

• To install a secondary image/photo editing application

• To change the colour depth of an image

• To crop an image

• To re-scale an image proportionately

• To rotate an image

• To flip drawn image

• To mirror a drawn object

• To apply effects to an image

• To apply a negative effect to an image

• To apply a blurred effect to an image

• To apply a sharpened effect to an image

• To apply a softened effect to an image

• To apply an embossed effect to an image

• To change the mode of an image

• To change an image into greyscale

• To change an image into black and white

• To convert an image into a specific file format

• To convert an image into the bmp file format

• To convert an image into the gif file format

• To convert an image into the jpg file format

4) CHARTS/GRAPHS

USING CHARTS/GRAPHS

• To create a line-column chart on two axes

• To change a graph/chart type to another type

• To name a chart style

• To change a chart/graph type to a data series in a chart/graph

• To scale the value axis of a chart/graph

• To display the units in hundreds, thousands, and millions on a chart’s y-axis

FLOWCHARTS

• To insert a pre-set flowchart slide

• To apply drawing tools to the flowchart

• To change the chart style

• To draw a flowchart using the Flowchart palette in Autoshapes

• To delete flowchart shapes

• To change flowchart shapes using the Flowchart palette in AutoShapes

• To change the connector line type between flowchart shapes

• To change the connector line type using the Flowchart palette in Autoshapes

5) MULTIMEDIA

SOUND, VIDEO

• To insert a sound and set the automatic timing for a sound

• To insert a movie and set the entry effect with automatic timing

ANIMATION

• To introduce an animation by mouse click, automatically

• To change the sequence of animation

• To apply a dim effect to bulleted points, drawn objects after an animation.

• To animate chart elements

• To animate individual elements

6) MANAGING PRESENTATIONS

SLIDE SHOW CONTROL

• To use Action Buttons in a slide

• To use Action Buttons

• To apply timing to a slide transition

• To remove a timing from a slide transition

• To set a slide show to loop continuously

• To remove a continuous looping from a slide show

• To advance slides manually in a show

• To advance slides using timings, if present

• To include animation, if present

• To show the slides without animation, if present

CUSTOMISED SHOWS

• To create a customised show

• To edit a customised show

• To run a customised show

• To run a customised show using presentation controls

• To run a customised show by creating a hyperlink

• To navigate back to the main presentation from a customised show

7) RELATING INFORMATION

LINKING

• To link text from a document into a slide as an object

• To link a range from a worksheet into a slide as an object

• To link a spreadsheet generated chart into a slide as an object

• To update or modify data linked into a presentation

• To change a linked object in a slide to an embedded object

• To insert an image from a file and link the image to the file

8) MACROS

RECORD, ASSIGN

• To record a macro

• To run a macro

• To assign a macro to a custom button on a toolbar

Check back soon there are more topics

Database ECDL ICDL Advanced

Database ECDL ICDL Advanced

Microsoft Access 2003 Edition for ECDL Advanced

Oluline

1) TABLE DESIGN

FIELDS, COLUMNS

• To set column data types

• To modify column data types

• To format Text data type

• To format Memo data type

• To format Hyperlink data type

• To format Currency data type

• To format Date/Time data type

• To choose appropriate data types

• To convert between data types

• To change a field to a different data type

• To create a lookup in a field

• To create a lookup from the values in a table or query

• To create a lookup from the values you type in

• To edit a lookup in a field

• To create a validation rule in a field

• To edit a validation rule in a field

• To create an input mask in a field

• To edit an input mask in a field

• To apply default value in a field

• To set required fields

RELATIONSHIPS/JOINS

• To identify a related table

• To create a relationship

• To delete a relationship

• To create one-to-one and one-to-many join types

• To create a one-to-one relationship

• To create a one-to-many relationship

• To modify one-to-many join type

• To create many-to-many relationship

• To modify many-to-many join type

• To apply inner join

• To apply outer join

• To apply self join

• To set referential integrity

• To set cascading options

• To create a two-table join

• To add another table to the query grid

• To add fields from different tables to the query grid

• To remove tables from the query builder

2) QUERY DESIGN

QUERY TYPES

• To create an Update Query

• To create a Delete Query

• To create a Make-Table Query

• To create an Append Query

QUERY FORMULAS

• To calculate totals for a single group

• To calculate totals for several groups

• Using Aggregate Functions

• To count the values in a specified column using the COUNT function

• To sum the values in a specified column using the SUM function

• To average the values in a specified column using the AVG function

• To find maximum value in a specified column using the MAX function

• To find minimum value in a specified column using the MIN function

• To create a crosstab query

• To create a crosstab query using the Crosstab Query Wizard

• To use Wildcards as parameters

• To create a calculation in design view

• To create an arithmetic expression in a query

• To create a logical (conditional) expression in a query

REFINE A QUERY

• To find duplicates using the Find Duplicates Query Wizard

• To find unmatched values using the Find Unmatched Query Wizard

• o find highest range of values in a query

• To find lowest range of values in a query

• To create a parameter query

• To find Null values

• To find NOT values

3) FORM DESIGN

CONTROLS

• To choose an appropriate control

• To place an unbound control

• To place a bound control

• To create a combo box

• To create a list box

• To create a check box

• To create an option button

• To create an option group

• To create expression control

• To create arithmetic expression control

• To create logical (conditional) expression control

• To set tab index for controls on a form

• To create form headers and footers

• To number form pages

SUBFORMS

• To use a subform

• To add a subform to a form

• To bring a subtotal from a subform to a main form

4) REPORT DESIGN

CALCULATIONS

• To place controls on a report

• To create arithmetic expression control

• To create logical (conditional) expression control

• To calculate percentage calculation control in a report

• To use common functions in calculated fields

• To use calculated fields in a report

• To concatenate (combine) values in an expression

• To create a report with running summaries

PRESENTATION

• To create Page Headers and Footers

• To create Report Headers and Footers

• To group records on a report

• To force page breaks after each record

• To force page breaks after each group of records

5) MACROS

RECORD & ASSIGN

• To create a new macro

• To run a macro

• To use the Single Step method to run a macro

• To attach macros to a form

• To attach the macro to a control in the form

• To attach macros to a report

• To attach the macro to a report event

• To attach the macro to a section of the report

• To attach the macro to the selected form property

6) IMPORT, EXPORT AND LINK DATA

DATA MANAGEMENT

• To import from text files

• To import from Excel spreadsheet

• To import from dBASE

• To import from Paradox

• To export data to a spreadsheet file

• To export data to a text file

• To export data to a dBASE file

• To export data to a Paradox file

• To link to an external text file

• To link to Microsoft Excel spreadsheet

Check back soon there are more topics

Spreadsheets ECDL ICDL Advanced

Spreadsheets ECDL ICDL Advanced

Outline

Microsoft Excel 2003 Edition for ECDL Advanced

1) EDITING

DATA

• What does naming a cell range mean?

• Rules for naming cells and ranges

• To name cells

• To navigate workbooks using named ranges

• To create named ranges based on cell values

• To delete named cells/ranges

• To AutoFormat a cell range

• To remove the effects of AutoFormat

• To create a custom number format

• Using custom number formatting codes

• Example custom number formatting

• What is ‘conditional formatting’?

• To format a range of cells using conditional formatting

• To use the Paste Special command

• ‘Paste Special’ options

• To transpose data

• Why import data?

• Common Text formats

• What is the Text Import Wizard?

• To import text into a worksheet using the Text Import Wizard

DISPLAY

• To freeze column titles

• To freeze row titles

• To freeze row and column titles at the same time

• To unfreeze rows or columns

• To hide rows

• To hide columns

• To re-display hidden columns

• To re-display hidden rows

• To hide worksheets

• To re-display hidden worksheets

• To create subtotals

• To remove subtotals

• What are data tables?

• To use a one input Data Table command

• To use a two input data table command

PROTECTION

• What is ‘worksheet protection’?

• To protect a worksheet

• To un-protect a worksheet

• To protect cells

• To unprotect cells

SECURITY

• To specify a password for opening a workbook

• To specify a password for saving a workbook

• To use the ‘read-only recommended’ option

• To use the ‘Always create backup’ option

• To protect a workbook

• To un-protect a workbook

• To remove a password from an Excel workbook

2) DATA HANDLING

SORTING

• Sorting an internal Excel list

• To sort the data within a list

• To sort the list on a single field

• Using the ‘Then by’ sort option

• To use custom sorting options

QUERYING / FILTERING

• What is ‘AutoFilter’?

• To use AutoFilter

• Using drop down AutoFilters

• To perform multiple queries

• To specify a conditional filter criteria

• Using the And / Or filters

• To remove all AutoFilters

• To use Top 10 AutoFilter

• To filter unique records

• To use the Advanced Filter

LINKING

• To link individual cells within a worksheet

• To link charts to data within a worksheet

• To link a cell range on one worksheet to another worksheet

• To link data on one worksheet to a chart in another worksheet

• To link charts between worksheets

• To link data from one workbook to another

• To link a chart from one workbook to another

• Copying a chart from one workbook to another

• What is embedding?

• What is linking?

• To copy data to the Clipboard

• To embed data (or a chart) from Excel into Word

• To Paste Link selected Excel data / chart to Word

• To consolidate data over several worksheets

TEMPLATES

• What are templates?

• To use a template

• To create a template

• To edit a template

CHARTS & GRAPHS

• To use the Chart Wizard to create a chart

• To quickly create a chart using default settings

• To change the angle of pie chart slices

• To format the chart axis numbers

• To format the chart axis scales

• To format the chart axis text

• To move a chart item

• To resize a chart item

• To re-position a chart title

• To re-position a chart legend

• To re-position a chart data label

• To explode all the segments within a pie chart

• To delete a data series in a chart

• To add a data series to a chart

• To modify the chart type for a defined data series

• To widen the gap between columns / bars within a 2-D chart

• To insert an image into a 2D chart (as a background)

• To insert an image into a 2D chart (to format a column or bar of data)

3) FUNCTIONS

USING FUNCTIONS

• What is the 'Insert Function’ utility?

• Ways to access the Function Wizard

• To use the Insert Function to enter a function

• To use the TODAY function

• To use the DAY function

• To use the MONTH function

• To use the YEAR function

• To use the SUMIF function

• To use SUMPOSITIVE function LOTUS

• To use the ROUND function

• Rounding up or rounding down

• To use the COUNT function

• To use the COUNTA function

• To use the COUNTIF function

• To use the PROPER function

• To use the UPPER function

• To use the LOWER function

• To use the CONCATENATE function

• What is the FV function?

• FV Syntax

• Things to be careful of when using FV

• The NPV (Net Present Value) function

• NPV Syntax

• The PMT function

• PMT Syntax

• The PV (Present Value) function

• PV syntax

• To use the RATE function

• To use the HLOOKUP function

• To use the VLOOKUP function

• To use the IF function

• Functions and named ranges

• Action_if_true

• Action_if_false

• The IF( ) Function an example

• To enter an IF ( ) function

• To use the AND function

• To use the OR function

• The ISERROR function

• Example of using ISERROR.

• The DSUM function

• An example of using DSUM

• The DMIN function

• An example of using DMIN

• The DMAX function

• An example using DMAX

• The DCOUNT function

• Example of using the DCOUNT function

• What are nested functions?

4) ANALYSIS

PIVOT TABLES / DYNAMIC CROSSTAB

• What are Pivot Tables?

• To create a PivotTable

• To drop data into the Pivot Table

• To modify data and refresh the Pivot Table

• To group data within a Pivot table

SCENARIOS / VERSIONS

• What is the ‘Scenario Manager’?

• Scenario Manager an example

• To show a scenario

• To view an alternative scenario

• To create a scenario summary

AUDITING

• To use tracers to audit a worksheet

• To display the Formula Auditing toolbar

• The Formula Auditing toolbar icons

• To trace errors in a cell

• An example of using 'trace precedents'

• To trace the dependants of a cell

• An example of using 'trace the dependants'

• To display all formulas within a worksheet

• What are cell comments?

• To add a comment

• To display a comment

• To remove a comment

• To edit a comment

5) SPECIAL TOOLS

MACROS

• What are Macros?

• To record a Macro

• To assign a macro to a shortcut key

• To run a macro using the Tools Macro command

• To run a macro assigned to a shortcut key

• Macros can be dangerous

• To disable macros when opening a workbook

• To create a custom toolbar

• To assign a macro to custom button on a toolbar

Check back soon there are more topics

Word Processing ECDL ICDL Advanced

Word Processing ECDL ICDL Advanced

Microsoft Word 2003 Edition for ECDL Advanced Syllabus One

Outline

TEXT

• To apply text effects

• What are text animations?

• To add text animation effects

• What is AutoCorrect?

• To use AutoCorrect

• To use AutoCorrect to insert symbols

• To reverse the automatic changing of text by AutoCorrect

• To use AutoCorrect Exceptions

• To enable automatic spelling correction

• To create an AutoCorrect entry

• To automatically format a document

• To remove each formatting change

• To set AutoFormat options

• Automatically formatting tables

• What is ‘AutoText’?

• To insert an AutoText entry into a document

• To remove an AutoText entry

• To display the AutoText toolbar

• The AutoText toolbar

• To create an AutoText entry

• What is text wrapping?

• To modify text wrapping around a picture

• Text orientation options are only available in text boxes or tables

• To orientate text within a table

• To orientate text within a Text Box

• What is WordArt?

• To create a WordArt object

• To edit a WordArt object

PARAGRAPHS

• What are borders?

• To add shadowing or shading to a border

• To apply white text on a black background

• To add a border using the Border icon

• To add a border to an object using the drop down menus

• To remove a border from an object

• To set widow and orphan paragraph controls

• What are Styles?

• To use the Style List box

• To view all available styles

• To view applied paragraph styles

• To create a style using example text

• To display the ‘Styles and Formatting’ side panel

• To create a new style which will be available within all new documents

• To apply a style to a selected part of the document

• To modify a style

• What is Outline View used for?

• To create an outline document

TEMPLATES

• What are templates?

• To find the location of the NORMAL.DOT, template file

• To edit a template

• To create a template, based on an existing document

• To create a template, based on an existing template

COLLABORATIVE EDITING

• To add a comment

• To remove a comment

• To display and edit comments

• To go to a comment within a document

• To enable the tracking of changes within a document

• To view details of changes made

• To set options for tracking changes

• To accept or reject changes

2) LAYOUT

MASTER DOCUMENTS

• What are Master Documents?

• To create a Master Document

• Master Document icons

• To create a subdocument, based on heading styles, within a Master Document

• To add a subdocument

• To delete a subdocument

TABLE OF CONTENTS

• What is the ‘Table of Contents’ feature

• To use heading styles to mark Table of Contents entries

• To create a Table of Contents

• To update a Table of Contents

• To automatically update a Table of Contents when printing

• To apply formatting options to a Table of Contents

SECTIONS

• Why use section breaks?

• To insert a section break within a document

• To delete a section break in a document

COLUMNS

• What are columns?

• To create columns from existing text

• To change the number of columns

• To remove multi-column formatting

• To apply further formatting to columns

• To keep text within columns together

• To balance columns

• To use preset column formats

• To modify column width and spacing

• To change columns width using drag and drop techniques

• To insert column breaks

• To delete a column break

3) DOCUMENT ORGANISATION

REFERENCING

• To add a bookmark

• To ‘Go To’ a bookmark within a document

• To delete a bookmark

• What is an index entry?

• To create an index entry for a document

• To compile an index

• To edit an index entry

• What are cross-references?

• To create a cross-reference to an item on a particular page

• To update your cross-references

• To delete a cross-reference

FIELD CODES

• What are Word Fields?

• To insert the date or time into a document (as a field)

• Inserting the time or date as text vs. insertion as a time or date field

• To insert a filename/ location field

• To use AutoText to insert the filename (and path)

• Viewing, Updating, Unlinking, Locking and Navigating Fields

• Useful Field keyboard shortcuts

• To update a field

• To edit a field

• To lock and unlock fields

• To delete a field code

FOOTNOTES / ENDNOTES

• To create a Footnote or Endnote

• To delete a Footnote or Endnote

• To go to Footnotes or Endnotes (and edit them)

• To use footnote & endnote formatting options

SECURITY

• To set a password for a document

• To remove a password from a document

4) DOCUMENT ELEMENTS

TABLES

• To merge cells in a table

• To split cells in a table

• To split a table

• To convert tabbed text to a table

• To sort data within a table

• To sum (i.e. add) numbers within rows or columns

• To update calculations

• To perform other calculations

FORMS

• What are forms?

• To create a form, (and protect it)

• To password protect a form

• To edit a form

• To insert a Text Form field into a form

• To modify a Text Form field

• To insert a Check Box Form Field into a form

• To modify a Check Box Form field

• To insert a drop down menu into a form

• To modify a Drop Down Form field

• To delete a field within a form

• To protect a form

TEXT BOXES

• To insert a Text Box

• To delete a Text Box (and Drawing Canvas)

• To modify the Text Box size using the Format Text Box dialog box

• To modify Text Box internal margins

• To move a Text Box

• To re-size a Text Box

• To modify Text Box colours and lines

• To apply Text Box Fill Effects

• To create linked text boxes

SPREADSHEETS

• To insert an Excel worksheet into a Word document

• To edit an Excel worksheet, embedded within a Word document

• To create a chart from a Word table

• To create a chart from worksheet data pasted into a document

• To insert a chart using the Insert / Picture / Chart command

• To modify a chart created using the Insert / Picture / Chart command

• To change the chart type

• To modify chart formatting

• To convert a chart to a 3-D chart

• To position a chart within Word

IMAGES / DRAWING

• To insert a Drawing Object into your document

• To modify drawing object borders

• To add a border to a clipart image and modify it

• To create a drawing using the drawing tools

• The Drawing toolbar icons

• To format a drawing

• To create a drawing using AutoShapes

• To send to the font or back

• To send an AutoShape behind text

• To send an AutoShape from behind the text, to in front of the text

• What is grouping and ungrouping?

• To group objects

• To ungroup objects

• What is a watermark (washout)?

• To create a watermark (washout) from a picture or drawing

CAPTIONS

• To add an caption

• To update a caption

• To apply customised number captions to an image, table or worksheet

• To use the automatic caption option

5) SPECIAL TOOLS

MAIL MERGE

• What is Mail Merging?

• To open a mail merge data source

• To edit a record in a data source

• To add a record to a data source

• To delete a record from the data source

• To insert merge fields into a document

• To set a criteria using Mail Merge

• To sort using Mail Merge

• To merge the documents

MACROS

• To record a macro

• To assign a macro to a keyboard shortcut

• Storing macros within templates

• What is linking (i.e. copying) macros?

• To copy macros between templates using the Organizer

• To run a macro

• To create a custom toolbar

• To assign a macro to custom button on a toolbar

6) PRINTING

PREPARING TO PRINT

• To print just the odd pages of a document

• To print just the even pages of a document

• To print a defined section within a document

• To print a defined number of pages per sheet

Check back soon there are more topics