Selamat Datang di Website ICDL Indonesia
Sabtu, 28 Maret 2015 M


Chapter 1    4
1.1. Background    4
1.2 Scope    8
1.3. Objective    10
1.3.1. General Objectives    10
1.3.1. Specific Objectives    10
1.3.3. More Specific Objectives    12
1.4. Outcome    13
Chapter 2    14
2.1. Institutional Criteria    14
2.1.1. General requirements    14
2.1.2. Administrative Requirements    14
2.1.3. Specific requirements    15
2.2. Accreditation Implementation Process    15
2.2.1. Indetification    15
2.2.2. Local Investatigation    16
2.2.3. The final process of Accreditation    16
2.2.4. Submitting Certificate of Accreditation    17
2.3. System test  Installation    17
2.4. Guidance    18
2.4.1. Business development    18
2.4.2. Technical Assistencies    18
2.4.3. ICDL Invigilator Guidance    19 Type of Guidance    19 Guidance Materials    19
Module 1  Concepts of Information Technology (IT)    20
Harware    20
Input/Output Device    20
Computer Performance    20
Memory and Storage    21
Input Device    21
Output Device    21
Input and Output Device    22
Software Concept    22
Network Types    22
Data Transfer    23
ICT and Everiday Life    23
Electronic Wolrd    23
Communication    23
Virtual Communities    24
Health    24
Environment    24
Security    24
Indentity/Authentication    24
Data Security    25
Viruses    25
Legal Issues    25
Copyright    25
Site Licences    25
Data Protection    25
Module 2  Using Windows Vista    26
A First look at Windows Vista    26
The Windows Desktop    26
Applications    27
Help    27
Files, Folders and Disks    28
Manipulating Folders    28
Manipulating Files    28
Copying and Moving Files    29
File Compression    29
Seacrhing for Data    29
Viruses, Spyware and cookies    29
Printing Issues    30
Module 3  Using Microsoft Word 2007    30
The Microsoft Word 2007 Screen    30
Startting to Use Microsoft Word 2007    30
Manipulating Text    31
The Clipboard    31
Text Formating    31
Paragraph Formatting    31
Adding Borders and Shading    32
Finding and Replacing Text    32
Tabs    32
Styles    32
Page Formatting    32
Tables    33
Graphics    33
Multiple Documents    33
Mail Merge    33
Customization    34
Proofing and Printing    34
Module 4  Using Microsoft Excel 2007    35
A First Look at Excel    35
Help    35
Selection Techniques    35
Manipulating Rows and Columns    36
Copying, Moving and Deleting    36
Searching    36
Manipulating Worksheets    37
Font Formatting    37
Alignment Formatting    37
Number Formatting    37
Freezing Row and Columns    38
Formulas    38
Relatives & Absolute Cell Referencing    38
Functions    38
Using Charts    38
Customizing Excel    39
Worksheet Setup    39
Preparing to Print a Worksheet    39
Module 5  Using Microsoft Access 2007    40
Database Concepts    40
A First Look at Access 2007    40
Opening a database & Security Issues    40
Creating a database & Using Views    41
Table Modification and Navigation    41
Field Properties, Validation & Input Masks    41
Manipulating Records & Tables    41
Primary Keys and Indexing    42
Filtering & Sorting    42
Relationships    42
Access 2007 Forms    42
Access 2007 Queries    43
Access 2007 Reports    43
Access 2007 Printing & Exporting Issues    44
Module 6  Using Microsoft PowerPoint 2007    44
First Steps With Presentations    44
Creating a Presentation    45
Module 7  Using Microsoft Office 2007    50
Internet Terminology and Concepts    50
Using Explorer    50
Searching The Web    51
Getting Help Within Internet Explorer    52
Customizing Internet Explorer    52
Feeds    52
Security Issues    53
Internet Explorer – Printing Issues    53
A First Look at Outlook    53
Terminology & Concepts    54
Sending Messages    54
Receiving, Reading and Replying to Messages    55
Manipulating Text and Files    55
Contacts    56
2.5. Partners    57
2.6. Educational Equipments    57
2.7. Evaluation and follow up of the Program    57
2.7.1. Implementation program evaluation    58
2.7.2. Follow up    58
2.8. The successfull indication    58
Chapter III    60
3.1 Funding and Fund resources    60
3.2. Program Executor    61
3.3. Responsible Team work:    62
Chapter 4    63
4.1. Fund allocation    65

Chapter 1

1.1. Background

Digital Literacy at the era of Information and Communication Technology,  became same  important as  traditional literacy, (the ability to read and write). Which recently President of The Republic of Indonesia instructed  to combat illiterate peoples in all over Indonesia, as acceleration programs to reduce at least 50% of illiterates peoples, and mandated to the Ministry of National Education as a priority program, related to the Dakar framework on “ Education for all”.

In the globalization era, the ability of reading and writing with academic qualification only is not enough for everyone to acquire the competitive workplaces without computing literacy, because there is no such profession, managerial or technical aspects without computing capability.

Therefore the serious program implementation in preparing digital literate for young generation must be done by the Government and non Governmental Organization. In order to produce competitive workforces. Otherwise the Indonesian Young generation will be  non competitive and non productive and we will face the serious problem in the future.

We have a lesson learned from India, Srilanka and many Middle East Countries which are in position of preparing their young generation with digital literacy. India and Srilanka successfully became IT work-forces supplier internationally, better than Philippines and Indonesia which both of the countries still depending to the domestic workers supply, even though we have a large number of educated populations. If we can anticipate the above mentioned problems seriously, its will be a part of the potential source to increase the national income.

To solve the above mentioned problem, Yayasan Pendidikan Indonesia (YPI Foundation) as International Computer Driving Licence (ICDL) licensee, proposed to the Indonesian Government trough the Ministry of National Education in 2006, to implement the ICDL program in Indonesia. Which was accepted by the Government, and we signed a memorandum of understanding with the Directorate General of non formal and informal education to implement the program at 300 more Public Community Colleges and 100 Private vocational Courses Institution in more than 300 Districts in all over Indonesia.

To implement of the above MOU , Yayasan Pendidikan Indonesia (YPI Foundation) provided services already to the above Public and Private Vocational Institutions, and trained with TOT methodology for 150 ICDL Invigilators at Al-Zaytun , ones of the ICDL approved Test Center in Western Java with success story in implementing ICDL program not only for the students but also for the Computer learning Instructors.

As result of the above successfully program implementation, on December 11, 2006 in the special occasion which was attended by the ICDL Asia Pacific CEO, the Chairman of Yayasan Pendidikan Indonesia (YPI Foundation) , and all available Director Generals of the Ministry of National Education.  At this event  Minister of National Education Prof.Dr. Bambang Sudibjo MBA announced that the ICDL program has been implemented in the Country and at the same time he submit formally the certificate of Accreditation to 71 Public Community College Head teachers.

On his speech the Minister suggested to all available Directorate Generals especially the Directorate General of formal Education to endorse and implement the ICDL program to formal education Institutions, such as Secondary Schools especially Senior Secondary  Vocational Schools. He mentioned as well in his speech to the Director General of Non Formal and Informal Education to include the Islamic Boarding Schools (Pesantren) in the ICDL program implementation.

To follow-up the above suggestion, We propose to implement the ICDL program at 183 Madrasah Aliyah (Islamic Secondary  Schools, 123 Private and 60 Public) in the Autonomy Province Aceh Nangroe Darussalam, with participation action research and programs systems between Yayasan Pendidikan Indonesia (YPI Foundation) and the responsible Indonesian Ministries, and non Governmental donors locally and Internationally, especially the Charitable Organization from Negara Brunei Darussalam through the ICDL Brunei Darussalam licensee.

ICDL Egypt which is managed by the UNESCO and ICDL Srilanka, successfully received donation from donors, such as Asian Development Bank and World Bank to implement ICDL program. With such donation they plan to support 1000,000 ICDL Candidates in each Country. By the above mentioned Participation Action programs, we expect that the success story of Egypt and Srilangka can be implemented as well in Indonesia.

1.2 Scope

The scope of this  proposal, is 183  Madrasah Aliyah in Nangroe Aceh Darussalam Indonesia, in the process of ICDL implementation, ICDL Indonesia will implement its planning  in cooperation with the  Ministry of Religious Affairs, and the Brunei Darussalam Charitable Organization will be invited to contribute to the program implementation trough ICDL Brunei Licensee. 

The major program implementation is the process of Accreditation to become ICDL Approved Test Center (ATC),  in order for the nominated Madrasah Aliyah to implement ICDL Training and Test legally. By implementing the program at the 123 Madrasah Aliyah in Nangroe Aceh Darussalam, ICDL Indonesia, ICDL Brunei Darussalam and its associates becomes the only Computing Certification providers in the world which will  support the Indonesian Government and International Charitable Organization to recover Nangroe Aceh Darussalam, especially to develop Nangroe Aceh Darussalam’s human resources, as almost all of the available donors focusing their donation for Infrastructure recovery  after the terrible Tsunami disaster.

1.3. Objective
1.3.1. General Objectives

The general objective of the sharing participation program as mentioned in this Proposal is revitalizing and preparing 183 Madrasah Aliyah in Nangroe Aceh Darussalam to become ICDL Approved Test Centers. By approving as ICDL Approved Test Center (ATC), the nominated Madrasah Aliyah can directly  provide training and testing of ICDL  Certification program to the students and the societies in general.

As ICDL Approved Test Center, Madrasah Aliyah in Nangroe Aceh Darusslam not only becomes the Islamic teaching and general knowledge providers, but also becomes  Center of life skills Education, especially Computing literacy skills. Finally the Approved ICDL Test Centers will be facilitators in bridging digital divide in the province.

1.3.2. Specific Objectives

•    To provide access or services to the Indonesian young generation from Nangroe Aceh Darussalam, for the Globally recognized Computing Certification with affordable cost.
•    To provide a chance to the ICDL Test Center (Madrasah Aliyah) to become a center of Information and technology Education, especially ICDL qualification
•    To develop a model of Information and Communication Technology Education, in order to Indonesia to develop  Internationally Recognize of the Indonesian standard of ICT qualification in the near future
•    To produce Indonesian Young Generation from Nangroe Aceh Darussalam with Computing skills, in order for them to continue their higher education or to become skilled workforces to enter a competitive workplaces locally or Internationally
•    By acquiring a computer skills the alumni of Madrasah Aliyah of Nangroe Aceh Darussalam not only qualified in the religious disciplines, but also knowledgeable in the computing skills, hopefully they become a skilled workforces who can compete in the competitive workplaces, locally or Internationally.
•    To Increase income from the skilled Nangroe Aceh Darussalam  workforces remittances.

1.3.3. More Specific Objectives

To revitalize Madrasah Aliyah in Nangroe Aceh Darussalam autonomic Province to become modern and innovative educational Institution equivalent with the Secular Educational Institution in Indonesia, and reducing the image of Islamic Educational Institution as Fundamentalist and terrorist producer, as statistically known that the number of Madrasah Aliyah in the Province is 183 units and its number of students is more 24,795 ( according to the Ministry of religious Affairs)

By increasing the capacity of Madrasah Aliyah we will improve the whole quality of National Education in the province, and in the Country in general.

1.4. Outcome

Expected outcome of the ICDL program implementation in Nangroe Aceh Darussalam is :

•    Readiness productive Indonesian young generation (from Nangroe Aceh Darussalam) with the International recognized Computer skills, in order from them to compete in this globalization era.
•    By approving as ICDL Approved test center, the Madrasah Aliyah bargaining position and its own motivation will be increased .
•    Awareness of the Indonesian Young generation for the Information and communication technology
•    Produce the competitive workforces especially the alumni of Madrasah Aliyah in order for them to capture the competitive ICT workplaces, locally or Internationally.
•    The ICDL alumni from Madrasah Aliyah  will be acceptable for the workplaces locally or Internationally.
•    Human resources development as part of the  Nangroe Aceh Darussalam recovery after the terrible  Tsunami in the Province.

Chapter 2

2.1. Institutional Criteria

The nominated Educational Institutions are Madrasah Aliyah (Islamic Secondary Schools) Private or Public Owned Institution which are located in the Autonomic Province Nangroe Aceh Darussalam Republic of Indonesia, with the following criteria:

2.1.1. General requirements

    Public or Private Madrasah Aliyah which is provided Educational program and located in the Autonomic Province of Nangroe Aceh Darussalam .
    Has the willingness to provide Computer Literacy Education.
    Provide uptodate Computer Laboratorium  at least 5 units to run  ICDL program training  and  test.
    Provide  a representative management
    Provide  a representative class-rooms which are open for all
    Enrolled at least 50 - 75 pupils and they are ready to register  the general applicants from the nearer society  as ICDL candidates.

2.1.2. Administrative Requirements

    Recommended by the  Officers or staffs of Local Office of Ministry of Raligious Affairs (Kandepag), who has a knowledge of the educational Innovation
    Has a formal legality to provide education from the Responsible Ministry ( Ministry of religious affairs)
    Agree to sign application to become ICDL test center
    Agree to accept the first assesment by ICDL Indonesia or Yayasan Pendidikan Indonesia
    Agree to sign a contract of accreditation with ICDL Indonesia on behalf European Computer Driving Licence Foundation
    Agree to purchase 7 test modules x 20 Candidates ( the cost will be arranged by ICDL Indonesia team work)
    Agree to pay Accreditation fee Rp. 5000,000,-  to ICDL Indonesia (will be funded by Yayasan Pendidikan Indonesia)
    Agree to follow all of the ICDL Indonesia regulation as stated on the Acreditation Contract.

2.1.3. Specific requirements

    The Nominated Islamic Secondary Schools should appoint a least 1 Invigilators, to monitor or supervise ICDL implementation program.
    The above Invigilators should be recommended by the headteacher of Islamic Secondary Schools, and meet the Criteria as ICDL Invigilator
    The Candidate of Invigilator should have ICDL core certificate or agree to participate special invigilator training provide by ICDL Indonesia

2.2. Accreditation Implementation Process

The Accreditation process will be done by the ICDL Indonesia staffs. With the following steps:

2.2.1. Indetification

    The nominated Islamic Secondary schools has been been identified by the ICDL Indonesia from the formal list of Madrasah Aliyah in the Autonomic Provine Nangroe Aceh Darussalam published by the Ministry of Religious Affairs Republic of Indonesia.
     Based on the serious discussion with the Minister of Religious Affairs on January 7, 2010, ICDL Indonesia delivered already the first Accreditation documment including ATC Application forms to be signed and returned to ICDL Indonesia head office in Jakarta or branch office in Surabaya.

 2.2.2. Local Investatigation

    ICDL Indonesia will send its outsourcing team to the  nominated Islamic Secondary Schools to do accreditation process as regulated by the ICDL Indonesia, then :

A.    Report to the ICDL Indonesia management with the photograps of the nominated schools and its own hardwares and softwares
B.    Recommend that the Islamic Secondary School is meet the ICDL Indonesia minimum requirement or rejected the application because not meet the minimum criteria.
C.    Submit all available documents to ICDL Indonesia for approval purposes

2.2.3. The final process of Accreditation

    ICDL Indonesia Licensee will preparing  Contract of Accreditation to be signed by the nominated  Islamic Secondary  School’a Headteacher
    One copy of The signed Contract of Accreditation must be returned  to the ICDL Indonesia management
    ICDL Indonesia Licensee then submit all documment to the ECDL Foundation by  a weekly report media in order to receive a code number or ID number of each Islamic Secondary School.

2.2.4. Submitting Certificate of Accreditation

    ICDL Indonesia management, will rechek all available documments and request the Islamic Secondary Schools to complete before issuing the certificate of Accreditation
    ICDL Indonesia can produce the certificate of Acreditation and/or receive it from the ECDL Foundation, then submit the certificate to each Islamic Secondary School through the Minister of  Religious Affairs
    The certificate of Accreditation submitting can be done on special occasion or destribute it directly throug courier.
    The special ocassion will be done and  ICDL Indonesia will invite Brunei Darussalam Kingdom Officer to submit officially with the Indonesian Minister of Religious Affairs, Minister of youth and Sports, Governor of Nangroe Aceh Darussalam.
    The above ocassion will be expossed by local and International media.

2.3. System test  Installation

The next process after the accreditation is the Instalation of ICDL test systems, with the following steps:

    ICDL Indonesia sending the list of new approves test center to Activ Training, with its own ID number, and contact persons.
    Activ Training will respond all or ICDL reportation, and sending the ICDL test system online or offline to Approved Test center through ICDL Indonesia Licensee.
    ICDL Indonesia Licensee, then forward all to the Islamic Secondary  Schools, with the test installation guide lines
    Activ training will send the file knows as DMTFILE directly to the Islamic Secondary schools through their email addresses
    Once the Islamic Secondary Schools completed all the ICDL test systems installation, they are ready to run ICDL program

2.4. Guidance

After being ICDL Approved test center, the Islamic Secondary Schools will receive a continuing guidance until they are ready to run the ICDL Program, which are :

2.4.1. Business development

    To succeed the ICDL program, ICDL Indonesia team will produce the guidlines how to prepare a business development, such as how to identify market and target market, how to negociate with Governmental bodies, and so on.
    ICDL Indonesia Licensee will help Islamic Secondary Schools with Marketing materials in soft or hard copies, to be reproduced by the Islamic Secondary Schools.
    ICDL Indonesia Licensee then include all available Islamic Secondary Schools at its own website and marketing materials.

2.4.2. Technical Assistencies

    ICDL Indonesia Licensee will open its own office or Contact persons 24 hours a day, ready to answer all questions from Islamic Secondary  Schools.
    ICDL Approved Test Center will receive special attention, using Telephones, facsimiles. Email and Skype acsess

2.4.3. ICDL Invigilator Guidance Type of Guidance

The ICDL Invigilator is the important human resources aspect to succeed the ICDL program at each Islamic Secondary Schools. That why we propose that each IDL Approved Test Center must appoint at least 1 Invigilator, and  Icdl Indonesia in association with ICDL Brunei Darussalam will trains them with the following methodology :

    Provide special training for the ICDL Invigilators to make sure that they have a capability to become a qualified Invigilators. Training will be held in the capital of Nangroe Aceh Darussalam  by face to face  tutorial
    Provide ICDL core courses to ICDL Invigilators in order for them to receive ICDL Certificates.
    Provide an online tutorial directly to each Invigilator, using email, sypky and all available media on the Internent. Guidance Materials

The Guidance materials for ICDL Approved Test Center and its own Invigilators are :

    Business Plan writing
    Operation manual for ICDL Approved Test Center in Bahasa Indonesia.
    How to operate ICDL program such as teachning learning and Testing
    7 modules of ICDL for the Invigilators Certification purposes :
Module 1
Concepts of Information Technology (IT)

•    Hardware
•    What is a personal computer?
•    Apple computers
•    Laptop & palmtop computers
•    Features of handheld portable digital devices
•    Personal Digital Assistant (PDA)
•    Mobile phones (cell phones)
•    Media players
•    Smartphones
•    Parts of a computer
•    The CPU
•    Memory (RAM)
•    Disks
•    The Hard (Fixed) Disk
Input/Output Device
•    Universal Serial Bus (USB) Port
•    Serial Port
•    Parallel Port
•    Network Port
•    FireWire Port
Computer Performance
•    Factors affecting computer performance
•    CPU Clock speed
•    RAM size
•    Hard disk speed and storage
•    Free hard disk space
•    De-fragmenting files
•    Multitasking considerations
•    CPU speeds
Memory and Storage
•    What is computer memory?
•    RAM
•    ROM
•    Video (graphics) memory
•    Measurement of storage capacity
•    Types of storage media
•    Internal hard disks
•    External hard disks
•    CDs
•    DVDs
•    Recordable CD & DVD drives
•    USB flash drives (memory sticks)
•    Memory cards
•    Network drives and on-line file storage
•    Floppy disks (diskettes)
Input Device
•    Input devices.
•    Keyboard
•    Mouse
•    Scanners
•    Tracker balls
•    Touch pads
•    Joysticks
•    Web cams
•    Digital cameras
•    Microphones
Output Device
•    Output devices
•    Traditional computer monitor
•    Flat screen computer screens
•    Projection devices
•    Speakers and headphones
•    Speech synthesizers
•    Printers
•    Different types of printer
•    Laser printers
•    Colour laser printers
•    Inkjet printers
•    Dot Matrix printers
Input and Output Device
Software Concept
•    What is software?
•    What is an operating system?
•    Examples of software applications
•    Word processing applications
•    Spreadsheets applications
•    Database applications
•    Presentation applications
•    E-mailing applications
•    Web browsing applications
•    Photo editing applications
•    Computer games
•    Difference between the operating system and application programs
•    Accessibility options
•    Voice recognition software
•    Screen reader software
•    Screen magnifier software
•    On-screen keyboard
Network Types
•    LAN (Local Area Network)
•    WLAN (Wireless Local Area Network)
•    WAN (Wide Area Network)
•    Client/server networks
•    Internet
•    World Wide Web (WWW) vs. the Internet
•    Intranets
•    Extranets
Data Transfer
•    Downloading from & uploading to a network
•    Data transfer rate measurement
•    Broadband vs. dial-up Internet connection services
•    Internet connection options
•    Features of a broadband Internet connection
ICT and Everiday Life
Electronic Wolrd
•    What does ‘Information and Communication Technology’ (ICT) mean?
•    Internet services for consumers
•    E-commerce
•    E-commerce
•    Advantages of e-commerce
•    Disadvantages of e-commerce
•    E-banking
•    E-government
•    E-learning
•    Uses of computer applications in education
•    Teleworking
•    Some of the advantages of tele-working
•    Some of the disadvantages of tele-working
•    Electronic mail (e-mail)
•    Instant messaging (IM)
•    Voice over Internet Protocol (VoIP)
•    Really Simple Syndication (RSS) feeds
•    Blogging (web logos)
•    Podcasts
Virtual Communities
•    Online (virtual) communities
•    Social networking websites
•    Internet forums (message boards / discussion boards)
•    Chat rooms
•    Online computer games
•    Publishing and sharing content online.
•    Sharing photos, video and audio clips.
•    Precautions when accessing online communities
•    What is ergonomics?
•    Repetitive Strain Injury (RSI)
•    Lighting issues when using a computer
•    Screen and keyboard positioning
•    Seating issues when using a computer
•    Wellbeing when using a computer
•    Make sure that cables are safely secured
•    Make sure that power points are not overloaded
•    Computer recycling options
•    Computer energy saving options
•    Computer logon user name (ID) and password.
•    Password policies
Data Security
•    Off-site backups
•    Why do you need to back up your computer?
•    Organising your computer for more efficient backups
•    Complete vs. incremental backups
•    What is a firewall?
•    Data theft issues
•    Computer viruses
•    Computer virus infection issues
•    Protecting against computer virus infection
•    What to do if you discover a virus on your computer
•    The limitations of anti virus software
Legal Issues
•    What is copyright?
•    Copyright Issues when copying files
Site Licences
•    Checking software licence status
•    What is an ‘end-user license agreement’?
•    Examining the ‘end-user license agreement’ within Office 2007 software
•    Types of licence agreement
•    What is shareware?
•    What is freeware?
•    Open source software
Data Protection
•    Data Protection and Privacy Issues
•    Data Protection Legislation
Module 2
Using Windows Vista
A First look at Windows Vista

•    Vista – Different versions
•    Starting Vista
•    Moving a window
•    Drag and drop
•    Select, then manipulate
•    Single clicking vs. double clicking
•    Viewing your ‘computer details’
•    Resizing a window, narrower or wider
•    Resizing a window, taller or shorter
•    Resizing a window in two directions at once
•    Maximising a window
•    Minimising a window
•    Closing a window
•    The Start button
•    The Start menu
•    Running a program using the Start menu
•    Entering text into a program
•    Saving data
•    Opening a file within a program
•    Shutting down Windows
•    Closing an application that is not responding
The Windows Desktop
•    What is the Windows Desktop?
•    Desktop icons
•    Moving Desktop icons
•    Windows Taskbar
•    Taskbar clock
•    Customising your Desktop
•    Customising the Desktop background wallpaper picture
•    Customizing the Desktop background color
•    Setting a screen saver
•    Setting your screen resolution
•    Modify the computer date and time
•    Setting the computer keyboard language and other regional settings
•    Setting the computer sound volume
•    The Sidebar and gadgets
•    Reordering gadgets
•    Closing a gadget
•    Running more than one program at a time
•    Starting WordPad
•    Using Print Screen within WordPad
•    Identifying the parts of an application window
•    Notepad
•    Calculator
•    Welcome Centre
•    Switching between programs
•    The ‘Switch between windows’ icon
•    Using Windows Flip 3D
•    Cascading windows
•    Displaying windows side by side
•    Installing programs
•    Removing programs
•    Creating and using a Desktop shortcut
•    Deleting a Desktop shortcut
•    Shutting down an application that has frozen
•    Restarting the computer
•    How to get help
•    The Help ‘Back’ and ‘Forward’ buttons
•    Printing a Help topic
•    Browsing for Help
•    Re-displaying the opening help screen
•    Demos
Files, Folders and Disks
•    What are files?
•    What are folders?
•    Types of drive and drive letters
•    Running the Windows Explorer program
•    Views within the Windows Explorer
•    Using the Windows Explorer scroll bar
•    Expanding and contracting drives and folders
•    Types of Windows Explorer icons
•    Drives, Folders and Files
•    Data storage devices
•    File sizes and disk storage capacities
Manipulating Folders
•    Navigating to the sample files folder
•    Creating a folder
•    Creating a subfolder
•    Renaming a folder
•    Deleting a folder
•    Displaying folder details
Manipulating Files
•    Viewing file details
•    Sorting the file list within the Windows Explorer
•    Recognizing common file types
•    Selecting multiple files
•    Counting the number of files, files of a particular type in a folder
•    Changing file attribute status
•    Renaming files
•    Deleting files
•    Restoring files and folders from the Recycle Bin
•    Emptying the Recycle Bin
Copying and Moving Files
•    The Windows Clipboard
•    Moving files between folders
•    Copying files between folders
•    Backups
•    Online Backups
•    Backing up data to a removable drive
File Compression
•    What is file compression?
•    Extracting compressed files
•    Compressing files
•    Disk formatting
Seacrhing for Data
•    Viewing recently accessed files
•    Searching for files on your hard disk
•    Advanced searching by file size
•    Advanced searching by date
•    Advanced searching by file content
•    Advanced searching using partial file names and specific locations
•    Searching for a file using wildcards instead of the full name
Viruses, Spyware and cookies
•    Computer viruses
•    Spy ware
•    Cookies
•    Virus checking programs
•    Scanning for viruses
•    Updating anti-virus programs
Printing Issues
•    Selecting a printer
•    Changing the default printer
•    Installing a new printer on the computer
•    Printing from an application
•    Using the Print Manager
Module 3
Using Microsoft Word 2007
The Microsoft Word 2007 Screen
•    Starting Microsoft Word 2007
•    The Microsoft Word 2007 screen
•    The levels of command organization
•    The Office Button
•    Ribbon Tabs
•    Switching between tabs using the mouse wheel
•    Groups
•    Dialog box launcher
Startting to Use Microsoft Word 2007
•    Using the default Microsoft Word document
•    Saving Microsoft Word documents
•    Opening and closing documents
•    Saving your file using a different file name
•    Creating a new document
•    Using Help within Microsoft Word
•    Alt key help
•    Closing Microsoft Word
•    Saving documents using different formats
•    Creating documents using different templates
•    Switching between Word Views
Manipulating Text
•    Select, then format
•    Selecting text
•    Inserting, deleting, undo and redo
•    Insert and overtype mode
•    Copying text within a document
•    Moving (cutting) text within a document
The Clipboard
•    Using the Clipboard
•    The Office Clipboard
•    Removing items from the Office Clipboard
Text Formating
•    Font type
•    Font size
•    Grow Font and Shrink Font icons
•    Font size keyboard shortcut
•    Bold, italic or underline
•    Subscript and superscript
•    Case changing
•    Highlighting
•    Font color
•    Copying text formatting
•    Removing formatting
•    Using Zoom
•    Inserting special characters and symbols
Paragraph Formatting
•    Paragraph marks
•    Soft paragraph (line break) marks
•    Good Practice Aligning and indenting text
•    Aligning text
•    Indenting paragraphs
•    Applying single or double line spacing within paragraphs
•    Applying spacing above or below paragraphs
•    Good Practice: Use paragraph spacing rather than using the Return key
•    Applying bullets to a list
•    Applying numbering a list
•    Modifying bullet and numbering formatting
•    Removing bullet or numbering formatting
Adding Borders and Shading
•    Adding a border
•    Modifying your borders
•    Adding shading
•    Modifying your shading
•    Applying borders to selected text
Finding and Replacing Text
•    Finding and replacing text
•    Tab stops
•    Setting and removing tabs
•    Viewing tab marks within a document using the Show/Hide icon
•    Applying styles to a word, line or a paragraph
Page Formatting
•    Page orientation and paper size
•    Changing the page size
•    Page margins
•    Page breaks
•    Good practice – Use Page breaks rather that repeatedly pressing the Return key
•    Headers and footers
•    Page numbering
•    Header and footer fields
•    Cover pages
•    Inserting a table
•    Navigating within a table
•    Selecting and editing text within a table
•    Selecting cells, rows, columns or the entire table
•    Inserting and deleting rows and columns
•    Modifying column width or row height
•    Modifying cell borders
•    Adding shading to cells
•    Modifying cell border width, color and style
•    Inserting Pictures
•    Inserting Clip Art
•    Inserting Shapes
•    Inserting Smart Art
•    Inserting a chart
•    Selecting, resizing and deleting graphics
•    Copying or moving graphics
Multiple Documents
•    Switching between open documents
•    Tiling or cascading documents on your screen
•    Comparing documents side by side
•    Copying or moving selected items between documents
Mail Merge
•    Starting the Mail Merge Wizard
•    Mail Merge Wizard - Step 1 of 6 ‘Select document type’
•    Mail Merge Wizard - Step 2 of 6 ‘Select Starting document’
•    Mail Merge Wizard - Step 3 of 6 ‘Select recipients’
•    Mail Merge Wizard - Step 4 of 6 ‘Write your letter’
•    Mail Merge Wizard - Step 5 of 6 ‘Preview your letters’
•    Mail Merge Wizard - Step 6 of 6
•    Creating a mailing list to be used within a mail merge
•    Merging a mailing list to produce labels
•    Setting and customizing Microsoft Word Options
•    Setting the User Name
•    Setting the default opening and saving folder
Proofing and Printing
•    The importance of proofing
•    Spell checking a document
•    Adding words to the built-in custom dictionary
•    Removing a word from the spell checking dictionary
•    Printing options
•    Printing only odd or even pages
•    Printing part of a document
•    Printing more than one page of a document per printed sheet
•    Previewing and printing a document
Module 4
Using Microsoft Excel 2007
A First Look at Excel

•    Starting the Excel program
•    What is the Active Cell?
•    The Excel cell referencing system
•    Entering numbers and text
•    Default text and number alignment
•    Adding a column of numbers
•    Worksheets and Workbooks
•    Saving a workbook
•    Closing a workbook
•    Creating a new workbook
•    Opening a workbook
•    Switching between workbooks
•    Saving a workbook using another name
•    Saving a workbook using a different file type
•    Getting help
•    Searching for Help
•    The Help 'Table of Contents'
•    Printing a Help topic
•    Alt key help
Selection Techniques
•    Why are selection techniques important?
•    Selecting a cell
•    Selecting a range of connecting cells
•    Selecting a range of non-connecting cells
•    Selecting the entire worksheet
•    Selecting a row
•    Selecting a range of connecting rows
•    Selecting a range of non-connected rows
•    Selecting a column
•    Selecting a range of connecting columns
•    Selecting a range of non-connecting columns
•    Good practice when creating of editing lists
Manipulating Rows and Columns
•    Inserting rows into a worksheet
•    Inserting columns into a worksheet
•    Deleting rows within a worksheet
•    Deleting columns within a worksheet
•    Modifying column widths
•    Modifying column widths using 'drag and drop'
•    Automatically resizing the column width to fit contents
•    Modifying row heights
Copying, Moving and Deleting
•    Copying a cell or range contents within a workbook.
•    Deleting cell contents
•    Moving the contents of a cell or range within a workbook
•    Editing cell content
•    Undo and Redo
•    Copying the contents of a cell or range between worksheets (within the same workbook)
•    Moving the contents of a cell or range between worksheets (within the same workbook)
•    Moving the contents of a cell or range between worksheets (in different workbooks)
•    Copying the contents of a cell or range between worksheets (in different workbooks)
•    AutoFill
•    Sorting a cell range
•    Searching and replacing data
Manipulating Worksheets
•    Switching between worksheets
•    Renaming a worksheet
•    Good practice with naming worksheets
•    Inserting a new worksheet
•    Deleting a worksheet
•    Copying a worksheet within a workbook
•    Moving a worksheet within a workbook
•    Copying or moving worksheets between workbooks
Font Formatting
•    Font type
•    Font size
•    Bold, italic, underline formatting
•    Cell border formatting
•    Formatting the background color
•    Formatting the font color
Alignment Formatting
•    Aligning contents in a cell range
•    Centering a title over a cell range
•    Cell orientation
•    Text wrapping
•    Format painter
Number Formatting
•    Number formats
•    Decimal point display
•    Applying and removing comma style formatting (to indicate thousands)
•    Currency symbol
•    Date styles
•    Percentages
•    Applying Percentage formatting to a cell or range
Freezing Row and Columns
•    Techniques for freezing row and column titles
•    Creating formulas
•    Good Practice: The easy way to create formulas
•    Copying formulas
•    Operators
•    Formula error messages
Relatives & Absolute Cell Referencing
•    Relative cell referencing within formulas
•    Absolute cell referencing within formulas
•    What is a function?
•    Common functions
•    Sum function
•    Average function
•    Max function
•    Min function
•    Count function
•    The COUNTA function
•    The COUNTBLANK function
•    What are 'IF functions'?
•    Using the IF function
Using Charts
•    Inserting a column chart
•    Inserting a line chart
•    Inserting a bar chart
•    Inserting a pie chart
•    Resizing a chart
•    Deleting a chart
•    Chart title or labels
•    Chart background color
•    Changing the column, bar, line or pie slice colors in a chart
•    Modifying the legend fill color
•    Changing the chart type
•    Modifying charts using the Layout tab
•    Copying and moving charts within a worksheet
•    Copying and moving charts between worksheets
•    Copying and moving charts between workbooks
Customizing Excel
•    Modifying basic Excel options
•    Minimizing the Ribbon
•    AutoCorrect options
Worksheet Setup
•    Worksheet margins
•    Worksheet orientation
•    Worksheet page size
•    Headers and footers
•    Header and footer fields
•    Scaling your worksheet to fit a page(s)
Preparing to Print a Worksheet
•    Visually check your calculations
•    Displaying gridlines when printing
•    Printing titles on every page when printing
•    Printing the Excel row and column headings
•    Spell checking
•    Previewing a worksheet
•    Comparing workbooks side by side
•    Zooming the view
•    Printing options
Module 5
Using Microsoft Access 2007
Database Concepts

•    What is a database?
•    What are databases used for?
•    What is a relational database?
•    What is a table?
•    What is a record (row)?
•    What is a field (column)?
•    What is data?
•    The difference between data and information
•    Data types
•    Common uses of large-scale databases
•    Database designers, database administrators and database users
A First Look at Access 2007
•    Opening Access 2007
•    Exploring the Access 2007 window
•    The Ribbon (Toolbar)
•    Ribbon tabs
•    Groups & Dialog Box Launcher
•    Navigating - Quick keys (shortcut keys)
•    Navigating – Pointer keys & quick keys
•    Navigating – Mouse wheel
•    Contextual tabs
•    Minimizing the Ribbon
•    Quick Access Toolbar
•    The Office Button
•    Microsoft Access Help
Opening a database & Security Issues
•    Opening a database
•    Security warnings
•    Trusted Locations - Trust Centre
•    Setting the default folder location within Access
Creating a database & Using Views
•    Creating a new database
•    Creating a new blank database
•    Saving a table
•    Adding and renaming fields
•    Using Datasheet View
•    Using Design View
•    Changing the view
Table Modification and Navigation
•    Adding Fields - Design View Data Type - Overview
•    Data Type - Descriptions
•    Using the Attachment data type
•    Adjusting column width
•    Moving a column to rearrange the column order
•    Adding records to a table
•    Navigating through records within a table
•    Navigation Pane
Field Properties, Validation & Input Masks
•    Field Properties
•    Input Mask
•    Validation Rules
•    Field Properties - Guides Tables
Manipulating Records & Tables
•    Closing an Object - Table
•    Renaming an Object - Table
•    Editing data within a record
•    Deleting data within a record
•    Using the Undo command
•    Deleting a single record
•    Deleting multiple records
•    Save As – Database Object
•    Deleting a table
Primary Keys and Indexing
•    Defining a Primary Key
•    Indexing
•    Creating a single-field Index
•    Creating a multiple-field Index
•    Deleting multi-field indexes
Filtering & Sorting
•    Text Filters
•    Applying a single filter
•    Clearing a single filter
•    Creating multiple filters
•    Clearing multiple filters
•    Sorting
•    Table relationships
•    One-to-many relationship
•    Many-to-many relationship
•    One-to-one relationships
•    Creating relationships between tables
•    Referential integrity
•    Cascade options
•    Cascade update related fields
•    Cascade delete related records
•    Enabling cascade options
•    Deleting relationships
Access 2007 Forms
•    Forms overview
•    Creating forms
•    Modifying forms
•    Modifying a form title
•    Modifying a form logo
•    Modifying a form label
•    Saving a form
•    Form View
•    Adding and formatting attachments
•    Modifying records
•    Deleting records
•    Adding records
•    Closing forms
•    Opening forms
•    Deleting a form
Access 2007 Queries
•    What are queries?
•    Creating a simple query
•    Adding criteria to a query
•    Running a query
•    Editing criteria in a query
•    Saving a query
•    Creating a two table query and sorting the results
•    What are Wildcards?
•    Deleting a query
Access 2007 Reports
•    What are reports?
•    Creating a simple report
•    Using the Report Wizard
•    Modifying the layout of a report
•    Widening a report column
•    Modifying the report title
•    Adding logos to a report
•    Auto Formatting a report
•    Modifying field names within a report
•    Inserting and formatting the date & time
•    Adding available fields to a report
•    Resizing reports for printing
•    Closing a report
•    Deleting a report
Access 2007 Printing & Exporting Issues
•    What does exporting data mean?
•    What is a spreadsheet format?
•    What is text only and CSV format?
•    What is an XML file?
•    Exporting a table or query output as an Excel spreadsheet using the Export Wizard
•    Exporting a table or query output as a text file using the Export Wizard
•    Exporting a table or query output as an XML formatted file using the Export Wizard
•    Considerations before printing
•    Print previewing
•    Which orientation, portrait or landscape?
•    Adjusting layout in Print Preview
•    Setting margins
•    Printing a complete table
•    Printing selected records
•    Printing a query or reports
•    Printing forms
Module 6
Using Microsoft PowerPoint 2007
First Steps With Presentations

•    Opening PowerPoint
•    Opening a presentation
•    Navigating between slides
•    Using the Zoom tool
•    Changing PowerPoint views
•    Using Help
•    Saving a presentation
•    Closing a presentation
•    Closing PowerPoint
•    Opening multiple presentations
•    Switching between multiple presentations
Creating a Presentation
•    Creating a new presentation
•    Inserting a new slide
•    Good Practice when creating slide content
•    Undo and Redo
•    Saving a presentation
•    Saving a presentation using a different name
Manipulating Slides
•    Inserting slides with a particular slide layout
•    Modifying the slide layout
•    Changing the background color on the active slide
•    Changing background color on all the slides within a presentation
•    Applying a theme to a presentation
Text Boxes (Placeholders)
•    What are Text Boxes (Placeholders)?
•    Resizing a Text Box (Placeholder)
•    Moving a Text Box (Placeholder)
Selecting. Copying, Moving, Resizing and Deleting Text
•    Selecting text
•    Moving text within a slide
•    Moving text between slides within a presentation or between presentations
•    Copying text within a slide
•    Copying text between slides within a presentation or between presentations
•    Deleting text
Searching Your Presentation
•    Using Find
•    Using Replace
Font Formatting
•    Font formatting options
•    Changing the font type
•    Changing font size
•    Increasing or decreasing the font size
•    Bold, Italic or Underline formatting
•    Strikethrough effects
•    Shadow effects
•    Character spacing
•    Changing case
•    Font color
•    Clearing all text formatting
Paragraph Formatting
•    Text alignment
•    Columns
•    Modifying bullet point formatting
•    Using numbering instead of bullet points
•    Changing the list level
•    Indenting bulleted text
•    Line spacing vs. paragraph spacing
•    Line spacing
•    Paragraph spacing
•    Using Outline view
•    PowerPoint Presenter Notes
•    Text direction
•    Text alignment within a Text Box (placeholder)
•    Text AutoFit
•    Using the Format Painter
•    Table selection techniques
•    Column selection
•    Row selection
•    Entire table selection
•    Creating a table
•    Applying a style to a table
•    Cell background shading
•    Adding table effects
•    Adding 'Quick Styles' to selected text
•    Applying borders to cells
•    Deleting rows or columns
•    Inserting rows or columns
•    Modifying column width and row height
•    Distributing rows and columns
Selecting, Copying, Moving, Resizing and Deleting Illustrations
•    Selecting an illustration
•    Moving an illustration
•    Copying an illustration
•    Deleting an illustration
•    Resizing an illustration
•    Stretching an illustration
•    Copying illustrations between presentations
•    Moving illustrations between presentations
Inserting Illustrations
•    Inserting Illustrations within PowerPoint
•    Inserting pictures
•    Inserting Clip Art
•    Inserting Shapes
•    Inserting text into a shape
•    Inserting perfect circles or perfect squares
•    Inserting a line
•    Inserting a free drawn line
•    Inserting an arrow
•    Inserting a text box
•    Inserting Smart Art
•    Inserting Charts
Formatting Shapes
•    Formatting the shape background fill color style
•    Formatting the shape line weight and style
•    Formatting the shape line color
•    Applying a shadow to an illustration
•    Modifying arrow line shapes and size
•    Rotating or flipping an illustration
•    Rotating illustrations by dragging with the mouse
•    Layering illustrations to the front or back
•    Aligning graphics relative to each other or relative to the slide
•    Aligning shapes relative to the left of a slide
•    Aligning shapes relative to the center of a slide
•    Aligning shapes relative to the right of a slide
•    Aligning shapes relative to the top of a slide
•    Aligning shapes relative to the bottom of a slide
•    Grouping and ungrouping objects
Formatting Charts
•    Changing the chart type
•    Changing the background color in the chart
•    Changing the column, bar, line or pie slice colors in the chart
•    Chart title manipulation
•    Adding data labels to a chart
•    What is an organization chart?
•    Creating an organization chart
•    Adding labels to items within an organization chart
•    Adding a co-worker to an organization chart
•    Adding a subordinates within an organization chart
•    Adding a manager within an organization chart
•    Removing an item from an organization chart
Moving, Copying, and Deleting Slides MOVING, COPYING AND DELETING SLIDES
•    Moving slides within a presentation or between presentations
•    Copying slides within a presentation
•    Deleting a slide or slides
•    Copying slides between presentations
•    Moving slides between presentations
Slide Masters
•    What is a slide master?
•    Inserting a picture (clipart) into a master slide
•    Inserting an image (from a file) into a master slide
•    Inserting a drawn object (shape) into a master slide
•    Removing a graphic from a master slide
•    Creating a footer
•    Automatic slide numbering
Slide Shows
•    Running a slide show
•    Slide show transition effects
•    Slide show animation effects
•    Modifying slide show animation effects
•    Hiding slides
•    Displaying hidden slides
Printing and Proofing
•    Spell-checking
•    Using Portrait or Landscape slide orientation
•    Selecting your output format
•    Visually inspect each slide before printing
•    Printing a presentation
Customizing and Compatibility
•    Modifying PowerPoint options
•    Compatibility issues when saving a presentation
•    Other file types you can use for saving a presentation
•    Saving a presentation as a template
•    Creating a new presentation based on a customized template
Module 7
Using Microsoft Office 2007
Internet Terminology and Concepts

•    World Wide Web (WWW) vs. the Internet
•    URL (Uniform Resource Locator)
•    Hyperlinks
•    ISP (Internet Service Provider)
•    Web sites and URLs
•    Structure of a Web Address
•    Web Browser
•    Podcasts
Using Explorer
•    Opening the Microsoft Internet Explorer program
•    Entering a URL into the Address Bar
•    Minimizing, maximizing, restoring and closing icons
•    Zoom
•    Hyperlinks
•    Navigating through Web sites
•    Back and Forward buttons
•    Forcing a Web page to display within a new window
•    Forcing a Web page to display within a new tab
•    Switching between tabs
•    Quick Tabs
•    Tab List
•    Closing a tab
•    Stop button
•    Refreshing Web pages
•    Really Simple Syndication (RSS) feeds
•    Internet Explorer icons
•    Copying a picture from a Web site page
•    Saving a picture on a Web page as a picture file
•    Copying a Web address (URL) to a document
•    Saving a Web page
•    Downloading files from a Web page
•    Adobe Acrobat files
Searching The Web
•    Search Engines
•    Searching using Instant Search
•    Searching using the Address Bar
•    Adding new search engines
•    Temporarily changing the search engine
•    Changing the default search engine
•    Using keywords and phrases
•    Don't use a single search word!
•    Searching using specific words
•    Searching using an exact phrase
•    Searching by excluding a word(s)
•    Searching by date
•    Searching by file format
•    Online encyclopedia
•    Online dictionaries
Getting Help Within Internet Explorer
•    Displaying Help
•    Help Demos
•    Browsing for Help
•    Printing Help sheets
Customizing Internet Explorer
•    Setting your Home Page (stating page)
•    Visiting the Home Page
•    Setting multiple Home Pages
•    Revisiting Web pages via the address bar
•    Displaying your viewing history
•    Deleting a history item
•    Deleting the entire browsing history and temporary files
•    Customizing history options
•    Internet cache
•    Emptying the cache and deleting temporary Internet files
•    Adding a Web page to your favorites
•    Opening a favorite (bookmark)
•    Creating a new favorites folder
•    Moving a favorite to a folder
•    Renaming a bookmark
•    Deleting a bookmark
•    Adding a Web page to a specified bookmark folder
•    Deleting a favorites folder
•    Toolbars
•    Disabling picture display
•    Setting your default browser
•    Installing Add-ons
•    What are feeds?
•    Viewing Web pages containing feeds
•    Subscribing to feeds
•    Viewing subscribed feeds
•    Unsubscribing from Feeds
Security Issues
•    Internet security & password logons
•    Risks associated with online activity
•    Parental control options
•    Submitting & resetting Web based forms
•    Protected sites
•    Digital certificates
•    Encryption
•    Secure web sites and https
•    Viruses & Virus checkers
•    Malware & Spyware
•    Worms & Trojans
•    Spam
•    Fraud
•    Firewall
•    Pop-Up blocking
•    Turing off popup blocking
•    Cookies
•    Information Bar
•    Phishing Filter
•    Parental Filtering
•    Windows Update
Internet Explorer – Printing Issues
•    Previewing Web pages
•    Page Setup - Orientation, paper size and page margins
•    Printing the entire Web page
•    Printing a selected area on a Web page
•    Printing specific page(s)
•    Printing a number of copies
A First Look at Outlook
•    Starting Outlook
•    The Microsoft Outlook Screen
•    Help and Outlook Demos
•    Printing help sheets
•    Microsoft Outlook Navigation Pane
•    Microsoft Outlook Standard Toolbar
•    Displaying or hiding toolbars
•    Quick way of displaying / hiding toolbars
•    Closing Outlook
Terminology & Concepts
•    The structure of an email address
•    The advantages of using email
•    Netiquette
•    Spam or Unsolicited Email
•    Viruses
•    Phishing
•    Digital signatures
•    SMS (short message service)
•    Voice over Internet Protocol (VoIP)
•    Benefits of VoIP
•    Instant messaging (IM)
•    Benefits of IM
•    Online (virtual) communities
•    Social networking websites
•    Internet forums
•    Chat rooms
•    Online computer games
Sending Messages
•    Creating and sending your first email
•    Checking that your email was sent
•    Sending emails to more than one person at a time
•    Receiving emails
•    Sending a copy of a message to another address
•    What is a blind carbon copy?
•    Using blind carbon copy
•    Setting the message subject
•    Spell checking your message
•    Attaching a file to a message
•    Removing an inserted file from an email
•    Issues when sending file attachments
•    Setting message importance (message priority)
•    Setting message sensitivity
•    Saving a draft copy of an e-mail
Receiving, Reading and Replying to Messages
•    The Inbox Folder
•    Opening the Inbox folder
•    The Inbox Screen
•    Selecting a message
•    Message Status icons
•    Reading a message
•    Switching between open Message windows
•    Forwarding a message
•    Opening or saving an attached file
•    Replying to the sender of a message
•    Replying to the sender and all recipients of a message
•    Setting message reply options so that the original message is inserted, or not inserted
•    Printing a message
•    Previewing a message before printing
•    Printing Options
Manipulating Text and Files
•    Selecting a word within the Message window
•    Selecting a line within the Message window
•    Selecting a paragraph within the Message window
•    Selecting all text within the Message window
•    Selecting text using the mouse
•    Copying text to the Clipboard from a message
•    Pasting text from the Clipboard into a message
•    Copying text from one message to another
•    Cutting text to the Clipboard from a message
•    Moving text from one message to another
•    Copying text from another application into a message
•    Deleting text in a message
•    Deleting text to the left of the insertion point
•    Deleting text to the right of the insertion point
•    Deleting an attached file from a message
•    What are contacts?
•    Opening the Contacts folder
•    Creating a contact
•    Adding the sender of a message to contacts
•    Addressing an email to a contact
•    Deleting a contact
•    What is a distribution list?
•    Creating a new distribution list
•    Adding an email address to a distribution list
•    Removing an email address from a distribution list
•    Sending an email to a distribution list
Organizing Mail
•    Searching for a message
•    Searching for messages by sender, subject or content
•    Creating a new mail folder
•    Moving a message to a different folder
•    Deleting a mail folder
•    Sorting the contents of the Inbox
•    Deleting a message
•    Opening the ‘Deleted Items’ folder
•    Restoring a message from the ‘Deleted Items’ folder
•    Emptying the ‘Deleted Items’ folder
•    Automatically emptying the ‘Deleted Items’ folder when you exit Outlook
•    Flagging a message
•    Removing a flag mark from a mail message
•    Identifying an e-mail as read, unread
•    Marking a message as unread
•    Marking a message as read
Customizing Settings
•    Adding an Inbox heading
•    Removing an Inbox heading
•    Resetting the Inbox headings

2.5. Partners

To succeed the ICDL program implementation as stated on this Conceptual framework. ICDL Indonesia will share with the following Institutions:

•    Ministry of Religious Affairs
•    Ministry of National Education
•    Brunie Darussalam Charitable  Organization
•    ICDL Brunei Darussalam
•    European Computer Driving Licence (ECDL) Foundation.

2.6. Educational Equipments

The educational equipments needed to implement the ICDL program at each Islamic Secondary Schools:

•    Teaching and Learning facilities such as Computer lab, to facilitate ICDL candidates (some the donation fund will be allocated to purchase and deliver to the nominated Madrasah Aliyah which is not preparing itsselve with minimum requirement of 5 PC)
•    Uptodate ICDL Coursewares as recommeneded by ECDL Foundation following the lates development of ICDL modules
•    Transporation facilities and other accreditation process equipments

2.7. Evaluation and follow up of the Program

Evaluation and follow up of the program implementation :

2.7.1. Implementation program evaluation

•    Continue evaluation and guidance of 183 Islamic Secondary Schools in the Autonomic Province of Nangroe Aceh Darussalam.
•    ICDL Invigilator evaluation
•    ICDL Coursewares evaluation
•    ICDL Test Systems installation evaluation
•    Implementation program evaluation at all available Islamic Secondary  Schools (ICDL - ATC)

2.7.2. Follow up

•    Submitting the Certificate of Accreditation to the all available ATC ( Islamic Secondary Schools)
•    ICDL Program socialization by the Islamic Secondary Schools to their own target market
•    Implementation of training and test as scheduled by the Islamic Secondary Schools
•    Coninuing guidance by ICDL Indonesia to each Islamic Secondary Schools during the contract periode
•    Annual auditing by ICDL Indonesia to make sure that each Islamic Secondary  School still well qualified to run ICDL program.

2.8. The successfull indication

•    The program implemantation successfull if all available nominated Islamic Secondary Schools meet the ICDL requirements
•    All of the available nominated Institutions accepted as ICDL Approved test centers.
•    All available Invigilators passed the ICDL Certification test and received the ICDL Certificates as requested by ECDL Foundation
•    All available Islamic Secondary Schools can run well the ICDL program and can increase the digital Literacy awarrness of its community members
•    All available ICDL Approved test center can market the ICDL program, then receive revenue, so they can pay back theri own ICT investment
•    All availabel ICDL alumni from Islamic Secondary Schools can be distribute to the International or local workplaces or continuing their higher Education

Chapter III

3.1 Funding and Fund resources

The total estimated cost of the ICDL implementation program for 183 Islamic Secondary Schools is Rp. 5,255,760,000,-  with the following estimation:

  • Accreditation cost  @Rp. 5.000,000 x 183 ATC           Rp.       915,000,000,-
  • ICDL cusewares cost @Rp.175,000 x 2x 20 x 183      Rp.   1,281.000,000,-
  • 4000 Invigilator training @ Rp. 3000,000 x 183         Rp.       549,000,000,-
  • ICDL test cost 7 Eurox7modulesxRp.14,000 x20x183 Rp.   2, 510,760,000,-
  • Amount    Rp.  5, 255, 760,000

The above mentioned expenditure is not include the possibility to support some Madrasah Aliyah with uptodate PCs, which will be allocated to meet the minimum requirement of ICDL. The number of Computer is 500 Units each Rp. 7,500,000,- (including delivery) = Rp. 3.750,000,000,-.

ICDL Indonesia and ICDL Brunei Darussalam will be more than happy if the prospective donors will agree to support our contribution to Nangroe Aceh Darussalam not only for the above fund allocation but also for the equipment cost.

We will provide the Computer specification and offering letter from DeLL Principal or Distributors in Indonesia.

Expected fund resources :

•    Yayasan Pendidikan Indonesia (YPI Foundation)
•    Ministry of religious Affairs.
•    Ministry of National Education
•    Brunei Darussalam Charitable Organziation
Yayasan Pendidikan Indonesia (YPI) as ICDL Indonesia Licensee will contribute its share for the Accreditation cost for the amount of Rp. 915,000,000,-

The remaining balance will be arranged by the team work of ICDL Indonesia  and ICDL Brunei Darussalam to complete the cost of ICDL implementation for 183 Madrasah Aliyah in the Autonomic Province of Nangroe Aceah darussalam, which is approximately Rp. 4,340,760,000. (the cost of Courseware printing, test Purachase, Invigilatior training)

As suggested by the Ambassador of The Kingdom of Netherlands, His Excelelency Dr. Nikolaus Van Dam we would like to approach the authorities to include the ICDL program implementation at 183 Islamic Secondary Schools in Nangroe Aceh Darussalam, as part of the program called ” ICT Education” in Indonesia, which will be funded by the Dutch Trust Fund through the World Bank.

We are now in position of communicating intensively with the prominet Charitable Organziation in the Middle east Countries for the above financial supporting purpose, but we are more than happy if ICDL brunei Darussalam could help us to communicate with Brunei Darussalam donors.

3.2. Program Executor

The main program executor of the ICDL program implementation at 183 Islamic Secondary  Schools in Nangroe Aceh darussalam  is :

1.    YAYASAN PENDIDIKAN INDONESIA (YPI Foundation as ICDL Indonesia Licensee addressed at:
•    Apartment Puri kemayoran Blok HB II kemayoran jakarta as the head Office Indonesia barat.
•    dan Jalan Darmo kali N0.1 B Surabaya as branch office for East Indonesia.

3.3. Responsible Team work:

Board of Advisors

Drs. Faisal Madani MSc.ED
Drs. Ali Mukmin Tanjung,SH.M.Hum


MYR Agung Sidayu
Chairman  ICDL Indonesia Licensee

Finance Manager
Drs.Taufan Berliano Ramadhani

Technical Operators
AR Dotokusumo and ICDL Indonesia team work

ICDL Indonesia will do partnership with ICDL Brunei Darussalam to succeed the above implementation program transparantly, and we will report on weekly basis to the donors, in order for them to receive any updated progress.

We agree to sign A memorandum of Undesrtanding or any mutual relatisonship agreement with ICDL brunei Darussalam and the representative of the prospective donors if needed.

Chapter 4

The implementation process of the ICDL program at 183 Indonesian Islamic Secondary Schools will be implemented step by step as scheduled. And we hope that the Certificate of Accreditation will be submitted by the President of the Republic Indonesia Dr. Haji Susilo Bambang Yudhoyono at the Presidential Palace in the Capital of Indonesia Jakarta, or in Aceh And we try to do our best to invite International Government and Non Govenmental leaders to attend the above ceremony, especially the Sultan of the Kingdom of Brunei Darussalam, Sultan Dr. Haji Hassanal Bolkiah Muizzadin Waddaulah.

If the implementation of the program running well as requested by ICDL Indonesian and its Partners. The program will be the only program which is shared between Government and Non Governmental Organization and Community in general in bridging digital divide in Nangroe Aceh Darussalam after the Tsunami terrible tragedy .

Hopefully the Implementation program of ICDL Concept at 183 Madrasah Aliyah, will become a starting Innovation program to improve the quality of the Islamic Secondary School (Madrasah Aliyah) Graduates, not only to  make equal endorsement for the Schools comparing to the general secondary Schools under the Ministry of National Education, but the most important thing is  to acquire equal treatment  as mandated by the Indonesian Constitution.

Actually the allocation budget for education in the Country, which is 20% of the total national budget is for all educational endeavors, not only for the Educational Institutions under the Ministry of National Education, but must be allocated equally to the Ministry of Religious Affairs to handle all available level of Education from Primary to University level of studies and Institution.

Presently the allocation of the above National budget is dominated by the Educational Institutions under the Ministry of National Education. Event though the number of Educational  Institution under the Ministry of Religious Affairs is more than 30% of the total available Educational Institutions in the Country. 

Finally we believe that the ICDL program implementation at 183 Islamic Secondary Schools will increase Innovation awareness of the whole available Islamic Secondary Schools and the final result is no more fundamentalist or Radicalisms issue from International Communities.

Last but not least the implementation of the project proposal will increase the positive image of Brunei Darussalam leaders, because of their sincere support to recover Nangroe Aceh Darussalam not only to develop the Autonomic Province Human resources but also to bridge the digital divide in Indonesia.

4.1. Fund allocation

1    Accreditation proces               
    a. Accreditation implementation  183 MAN/S   Rp. 5,000,000    Rp.        915,000,000,-   (from YPI Foundation)
2    Test cost               
    a. Test purchase  20 x 7 x 1000    140,000 test    Rp.     686,000    Rp.    2, 510,760,000,-    (Donor)
3    Courseware cost               
    a Courseware purchase      7320    Rp.    175,000    Rp.    1,281.000,000,-    (Donor)
4    Invigilator test training    183    Rp. 3,000,000     Rp.       549,000,000,-    (Donor)
    TOTAL AMOUNT             Rp.    5, 255, 760,000

© 2015 Copyright ICDL Indonesia. All Right Reserved.