Certified OpenOffice.
org & Linux (Desktop)
(Including Practical and Written Test)
Duration: da!s
W"O #"O$LD %TT&'D:
1. Those who need to support implementation of OpenOffice.org on Linux or MS
Windows.
2. Anyone who will create and manage large complex word processing pro!ects.
". Anyone who will use spreadsheet for data handling functions and data analysis
features.
#. Anyone who will plan and design effecti$e presentations.
P(&)(&*$I#IT&#:
1. %a$e attended the following compulsory training &
'sing OpenOffice.org (ffecti$ely
2. )refera*ly to ha$e also undergone the following trainings &
Linux +es,top - OpenOffice.org
or
.ntroduction to OpenOffice.org
". %a$e used the " components of OpenOffice.org for a minimum of " months.
#. /an perform *asic OpenOffice.org configuration including&
Add user data
/hange the print settings
/hange the paragraph formatting
Open Source Competency Centre (OSCC), MAMPU
Address: 3
rd
Floor, Enterprise Building 3, Cyberjaya. URL http://opensource.mampu.gov.my
Telephone: 603 83191200
CO$(#& O$TLI'&:
D%+ ,
1. .ntroduction to Linux +es,top
0arious linux des,tops & such as 1+( 23OM( and 45/( features
'sing start menu for applications and settings.
A*le to arrange create and edit files and folders permission
2. 2eneral OpenOffice.org
2etting help for OpenOffice.org
Starting OpenOffice.org
The general configuration
-. Word Processing (Writer)
Layout
i. 'sing Master document and Su*6documents.
ii. 'sing document sections including column layout.
+ocument Organi7ation
i. Adding 5oot and (nd notes.
ii. Adding and using *oo,mar,s.
iii. 'sing comments.
i$. Adding ta*le of contents.
Special Tools
i. 'sing the Mail Merge tool.
ii. 'sing a macro.
)rinting and (diting
i. )rinting
ii. 8ecord and re$iew changes.
D%+ .
. #preads/eet ) I (Calc)
(diting
i. Assigning conditional formatting.
ii. )aste cells with special options. (.g. Transpose remo$e formula and lin,s.
+ata %andling
i. 'sing filter to filtering data.
ii. 'sing lin,ing tool.
iii. 'sing data sort function.
Open Source Competency Centre (OSCC), MAMPU
Address: 3
rd
Floor, Enterprise Building 3, Cyberjaya. URL http://opensource.mampu.gov.my
Telephone: 603 83191200
'sage of functions
i$. 'sing a$erage function.
$. 'sing date9time functions.
$i. 'sing logical and financial functions.
0. #preads/eet ) II (Calc)
Analysis tools
i. 'sing the sol$er tool.
ii. 'sing the scenario tool.
iii. 'sing auditing tools.
D%+ -
1. Presentation ) I (I2press)
Slides
i. Merge word processed documents into presentation.
ii. Sa$ing slides in O+) ))T )+5 %TML SW5.
iii. Wor,ing with Master documents.
3. Presentation ) II (I2press)
Multimedia
i. Add and edit pictures and images.
ii. .nserting Mo$ie and Sound.
iii. .nserting Animated .mages.
Managing )resentation
i. 'sing %yperlin,
ii. Lin,ing chart to a change in spreadsheet
D%+
:. (xam preparation
8e$iew and self study.
Open Source Competency Centre (OSCC), MAMPU
Address: 3
rd
Floor, Enterprise Building 3, Cyberjaya. URL http://opensource.mampu.gov.my
Telephone: 603 83191200