©2025 TVET CDACC
MODULE 1
INFORMATION AND COMMUNICATION TECHNOLOGY
IT/OS/ICTA/CR/02/4/MA
PERFORM COMPUTER OPERATIONS
SEPTEMBER - NOVEMBER 2025
TVET CURRICULUM DEVELOPMENT, ASSESSMENT AND CERTIFICATION
COUNCIL (TVET CDACC)
PRACTICAL ASSESSMENT
INSTRUCTIONS TO THE CANDIDATE:
1. This unit of competence shall be assessed in three phases.
2. Each assessment session has the duration included in brackets
3. The third phase of the assessment shall include a practical session and an oral
assessment session.
4. The assessor will take photos and videos as you perform the tasks at critical points
during the assessment.
5. Ensure all required resources for the assessment have been provided before beginning
the assessment.
Page 1 of 6
©2025 TVET CDACC
PRACTICAL ASSESSMENT 1 (2 HOURS)
Elements Covered:
1. Process Computerized Word Document
Tasks:
a) Open a word processor and create a new document titled Meeting Minutes – ICT
Department. Type the following minutes as it appears below. Use Times New Roman ,
font size 12:
Minutes of Staff Meeting
Date: 20th August 2025
Time: 10:00 AM – 11:30 AM Venue: Conference Room A
Chairperson: Mr. John Doe Minute Taker: Jane Smith
1. Opening Remarks
The Chairperson welcomed all staff and emphasized punctuality in future meetings.
2. Review of Previous Minutes
The minutes of the previous meeting were confirmed as a true record without amendments.
3. Departmental Updates
Each department head presented their progress report. Key highlights included:
- IT Department reported successful migration to the new system.
- HR announced upcoming staff training in September.
- Finance noted timely submission of budget reports.
4. Upcoming Events
The annual staff retreat was scheduled for 15th October 2025. Planning committee formed.
5. Any Other Business
No major issues raised.
6. Closing Remarks
The Chairperson thanked members for their contributions and closed the meeting at 11:30
AM.
______________________________
Chairperson Signature & Date
f) Insert page numbers at the bottom-right corner of the page.
g) Insert a header with your full name.
h) Insert this shape at the top of the page.
j) Save the file and print the document.
Page 2 of 6
©2025 TVET CDACC
PRACTICAL ASSESSMENT 2 (2 HOURS)
Elements Covered:
1. Manipulate Computerized Spreadsheet
2. Maintain Computerized Database
Tasks 1A:
a) Open a spreadsheet and create the following table of sales on the spreadsheet:
Product January February March
Laptops 12 15 20
Desktops 10 8 12
Printers 6 7 9
Scanners 4 5 6
Projectors 3 4 5
b) Use cell referencing to calculate totals for each product across the 3 months.
c) Insert this type of chart to display product sales totals above.
Chart Title
6
5
4
3
2
1
0
Category 1 Category 2 Category 3 Category 4
Series 1 Series 2 Series 3
d) Insert this type of chart showing percentage contribution of each product to total sales.
Sales
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
e) Save the file as [Link] and print
Page 3 of 6
©2025 TVET CDACC
Task 1B:
f) Open a database application.
g) Create a table named Customers with the following fields:
• CustomerID (Number)
• Name (Text)
• Phone (Text)
h) Enter the following five sample records:
CustomerID Name Phone
1 Alice Mwangi 0712345678
2 John Otieno 0723456789
3 Grace Njeri 0734567890
4 Peter Kamau 0745678901
5 Sarah Achieng 0756789012
i) Run a query to display only customers whose phone numbers start with 072.
j) Save the database as CustomersDB.
Page 4 of 6
©2025 TVET CDACC
PRACTICAL ASSESSMENT 3 (3 HOURS)
Elements Covered:
1. Prepare PowerPoint presentation
2. Perform Online Collaboration
3. Perform Document Production
Task 1A:
a) Create a new presentation on the topic “Using ICT Safely.”
i. Slide 1 (Title Slide):
• Title: Using ICT Safely
• Subtitle: A Guide for Students
ii. Slide 2 (Content Slide with bullet points):
• Safe Internet Browsing
• Protecting Personal Information
• Avoiding Cyberbullying
iii. Slide 3 (Slide with Chart or Image):
• Insert an image of a padlock or a padlock icon.
b) Apply any built-in Design Theme to all slides.
c) Print slides in Handout View (2 slides per page).
Task 1B:
a) Sign in to your Gmail account.
b) Create a new document titled “Teamwork in ICT.” Using the collaboration tool
c) Type the following content into the document.
Teamwork in ICT
Teamwork is important in ICT because it allows people with different skills to work together
and solve problems more effectively.
✓ It improves communication and sharing of ideas.
✓ It saves time because tasks are divided among members.
✓ It helps members learn from one another.
d) Format the document as follows:
Page 5 of 6
©2025 TVET CDACC
• Make the title bold and underlined.
• Change the font color of the three bulleted points.
• Insert today’s date at the header of the page.
• Insert page number at the bottom of the page.
e) Share the document with the assessor by generating a shareable link (set permissions
to Editor).
f) Copy the shareable link.
g) Open your Gmail, compose a new email to the assessor with the subject line:
“Teamwork in ICT – Shared Document.”
h) Paste the document link into the email body.
i) Send the email.
j) From the collaboration tool , download a copy of the document as
Teamwork_in_ICT.docx and again as Teamwork_in_ICT.pdf to your computer.
k) Print the document
The assessor will proceed to ask you oral questions for 1 hour.
Page 6 of 6