Occupational Code: ICT ITS2

Ministry of Education
Sector: - ICT
Sub Sector: - Information Technology
Occupation: IT Support Service L-2
Candidate’s Package

The assessment covers the following units of competence:

1. Operate Database Application

2. Update and Document Operational Procedures
3. Administrate Network and Hardware Peripherals
4. Care for Network and Computer Hardware
5. Access and Use Internet
6. Implement Maintenance Procedures
7. Maintain Equipment and Consumables
8. Apply Problem Solving Techniques to Routine Malfunction
9. Participate in Workplace Communication
10. Work in Team Environment
11. Develop Business Practice
12. Apply Continuous Improvement Processes (Kaizen)

Candidate’s instructions and worksheets

 Instructions to Candidate
 Methods of Assessment
1. Observation/Demonstration with Oral Questioning/Interview

Candidate name
Registration number
Name of assessment center
Name of training provider

Candidate’s Package for IT Support – L2 (qualification Based)

 Occupational Code: ICT ITS2

INSTRUCTIONS TO THE CANDIDATE

Occupation: IT Support – L2
1. For Qualification-based assessment, you are to perform all the projects in this package
together.
2. For competence-based assessment, you are required to perform the specific project/s
where the competencies to be certified are included.
3. Read the Project package/s properly.
4. All your questions and clarifications should be addressed to the assessor only.
5. Complete the task/project described in the project package.
6. You are given fifteen (15) minutes reading time for each project and the number of
hours allocated for each project is indicated in the Project Information Sheet.
7. After you finish this assessment, you are required to submit all the project packages
provided to you.
8. You are allowed to use your tools/ instruments with the permission of the Assessor,
and this must be presented to the assessor before start of the test.
9. After you finish the assessment, you are required to sign the Competency Assessment
Results Summary, and return all the tools and materials borrowed.
10. You are also required to clean up your work station after completion of your work.

Candidate’s Package for IT Support – L2 (qualification Based)

Occupational Code: ICT ITS2

Project Information
Given the necessary tools, equipment and information, you are expected to perform
the following practical works.

The assessor should ask oral questions on which s/he is not satisfied by your
performance
Assessment Venue: the assessment should take place in a room suitable for IT
Assessment
Total Time Allotted for all Projects: - 4 hrs

Project 1. Dissembling and assembling a computer (UC 04,06,07,08)

On this project you will be performing disassembling and reassembling task.

(Total time for the project1: 30 minutes)

Task 1: Disassemble the CD-Rom, RAM, and BIOS battery of your computer

For this task you will be provided a full functional computer and you are
expected to disassemble the devices listed above following the standard
computer maintenance procedure

(Time allotted: 15 minutes)

Task 2: reassemble the CD-Rom, RAM, and BIOS battery back again

Under this task you are going to reassemble the dismounted CD-Rom, RAM,
and BIOS battery and make them operational again.

(Time allotted: 15 minutes)

Project 2. Accessing and browsing the internet (UC 02 & 05)

On this project you will demonstrate how to browse and get information from the
internet
(Total time for the project 2: 1hr)

Candidate’s Package for IT Support – L2 (qualification Based)

Occupational Code: ICT ITS2

Task 1: Make yahoo website a default page

Under this task you should set the website yahoo a default home page to your
web browser.

(Time allotted: 5 minutes)

Task 2: Find information about Nile River, copy and save it on a notepad on
your computer
Under this task you are expected to search information about river Nile then
save at least a paragraph on your computer copying it on a notepad.

(Time allotted: 20 minutes)

Task 3: Download a sound driver specific to your computer

Here you are expected to identify your computer’s sound driver and download
it from the internet.

(Time allotted: 15 minutes)

Task 4: Create a new email account using Gmail.

Under this task you should create a personal mail account in the format
‘coc_yourname@gmail.com’ and demonstrate is how to use it.

(Time allotted: 20 minutes)

Project 3. Administrate Network and Hardware Peripherals

(UC 03 & 04)

On this project you are expected to install, configure, maintain and troubleshoot local
area network and peripherals.
(Total time for the project 3: 80 minutes)

Task 1: Install and configure a network

Under this task you are required to prepare two network cables to connect the
two computers using switch/hub. Test your cabling using cable tester you are
provided with.

(Time allotted: 45 minutes)

Task 2: Creating a folder and making it accessible in the network

Under this task you are expected to create a folder called ‘COC’ on one of
your computer and share it to the other computer

Candidate’s Package for IT Support – L2 (qualification Based)

Occupational Code: ICT ITS2

(Time allotted: 20 minutes)

Task 3: Add a shared printer from the network

A printer will be available to you shared from a remote computer and you are
to add that printer to one of your computer and then you are required to print a
test page.

(Time allotted: 15 minutes)

Project 4. Operating Database Application (UC 01)

On this project you are required to create a database and under the same database
you will be creating tables, forms, queries and reports. You will be provided with the
necessary information to perform this project.
(Total time for the project 4: 70 minutes)

Task1: Create a database called WORLD

On this task you create a new blank database using the above given name.

(Time allotted: 5 minutes)

Task 2: Create the following tables under the database you just created on
Task 1
For this task, you are given the two tables’ design below that you are required
to create. The fields which are indicated with a ‘(PK)’ symbol are the primary
key of each table.

(Time allotted: 10 minutes)

Table 1: Continents
Field Data Type
Continent_ID (PK) Text
Name Text
Area Number

Table 2: Countries
Field Data Type
Country ID (PK) Text
Name Text
Population Number
Continent_ID (FK) Number

Task 3: Create Relationship between the two tables using ‘Continent_ID’ field.

Candidate’s Package for IT Support – L2 (qualification Based)

Occupational Code: ICT ITS2

Under this task you are required to create a one-to-many relationship between
the continents and countries Tables

(Time allotted: 10 minutes)

Task 4: Enter the following sample data on the tables as given below
Under this task you enter the data given below on each table

(Time allotted: 15 minutes)

Continents

Continent_ID Name Area (in millions km2)

Cn1 Africa 30
Cn2 Europe 10
Cn3 Asia 43
Cn4 South America 17

Countries

Country ID Name Population (in millions) Continent_ID

Cn1 Ethiopia 83 Cn1
Cn2 Kenya 40 Cn1
Cn3 France 25 Cn2
Cn4 China 1000 Cn3

Task 5: Create a Form for table Countries

Under this task you expected to create a form that can be used as a data
entry form for table countries.

(Time allotted: 10 minutes)

Task 6: Create a query that shows all the countries which are found in
continent Africa and have a population greater than 20 Million
Under this task you are required to create a Query that should retrieve all
those data that meet the above stated criteria range.

(Time allotted: 10 minutes)

Task 7. Create a report for continent table that contains only continent name
and area.
Under this task you are required to create a Report that meets the above
criteria

(Time allotted: 10 minutes)

Candidate’s Package for IT Support – L2 (qualification Based)

Occupational Code: ICT ITS2

Materials and supplies per candidate

No Item description Quantity unit Specification
1 Connector 8 pcs RJ45
2 Paper 3 pcs A4 size
3 Network cable 4 pcs UTP CAT 5/6

Tools, Instruments & Equipment

No Item description Quantity unit Specification
1 Personal computer 2 pcs Pentium Iv, 512 MB RAM, 20GB HDD
free; 1.8GHZ processor,
2 Cable tester 1 pcs Analog / Digital cable tester
3 Switch/hub 1 pcs 8 Ports
4 Crimper 1 pcs Functional
5 Printer(shared) 1 pcs Laser jet
6 Installed Software 3 pcs  Windows Xp sp3
 Ms Office 2007
 Drivers (all)

Note: Materials and tools may be modified by the Assessor, depending on the
actual job performed, and location & the standard installation practices of the
country.

Candidate’s Package for IT Support – L2 (qualification Based)