© 2025 TVET CDACC

ICT LEVEL 4
IT/CU/ICTA/CR/02/4/MA
Computer Operations
July/August 2025

TVET CURRICULUM DEVELOPMENT, ASSESSMENT AND

CERTIFICATION COUNCIL (TVET CDACC)

OBSERVATION CHECKLIST

INSTRUCTIONS TO THE ASSESSOR:

1. This assessment is to take place in the prescribed order as arranged in the tool.
2. Capture clear photographs and/or videos of each candidate’s work as they perform
the tasks and label all media files with: Candidate Registration Number, Unit Code,
Practical Session Number, and Date.
3. Record candidate scores and assessor remarks in the observation checklists for each
session.
4. Store all completed checklists, media files, and candidate’s printings in a secure
digital/physical folder per candidate.

Page 1 of 14
 © 2025 TVET CDACC

1. CANDIDATE & ASSESSOR DETAILS

Candidate Name: Reg. Code:

____________________ ______________
Assessor Name: Date:
____________________ ______________
Venue:
____________________________________________________

2. PROJECT BRIEF

The candidate is required to demonstrate the ability to manage computer devices,

manage desktop settings, perform file management, manage computer software and
perform online jobs. They must complete three hands-on practical sessions (each
ranging from 1 - 3 hours) based on real-world tasks and an oral assessment (~1 hour)
to confirm conceptual understanding.

3. CUTTING LIST (PER CANDIDATE)

The following items should be provided for each candidate to facilitate the assessment
process.

Item Quantity Provided By

Computer with Microsoft Office (Word, Excel, 1 (shared in

Centre
Access, PowerPoint, Publisher) shifts)

Printer + Scanner (or MFP) Shared Centre

Internet Access Shared Centre

Flash Disk 1 Candidate

Gmail/Google account 1 Candidate

Page 2 of 14
 © 2025 TVET CDACC

4. SECTION 1 – SESSION 1 (~ 2 HOURS) Word Processing and Spreadsheet

Elements Covered:

 Process computerized word document

 Manipulate computerized Spreadsheet

Observation Checklist 1A
# Performance Criterion Max Marks Awarded
Created a folder on the desktop and name it
(a) 2
Interviews
First paragraph:
Typing text 1 mark; inserting drop cap 2 lines 3
1 mark, words in italics 1 mark
Typing the text; in bullets; placing columns;
3
(b) and line between
Typed the last paragraph 1 mark; inserted the
3
image 1 mark; wrapped text tight 1 mark
Saving as AI in the folder created
1

Formatting title:
(Award 1 mark for font type, 1 mark for font
(c) 4
size, 1 mark for double underline, 1 mark for
centre align)
Formatting the rest of passage:
(Award 1 mark for font type, 2 marks for font
(d) 6
size, 1 mark for justify align and 2 marks for
line spacing)
Typed the letter 6
Sender’s address right aligned 1
(e) Subject in bold 1
Placeholders for fields in bold 1
Inserting signature 1
Creating the data source
(f) 10
(Award 1 mark for each record)

Page 3 of 14
 © 2025 TVET CDACC

Mail merging:
(Award 2 marks for linking the letter with the
(g) 10
data source, 1 mark for inserting each mere
field (6 marks), 2 marks for saving changes
(h) Printed the specified 3 letters 3

Total Marks in Task 1A 55

Page 4 of 14
 © 2025 TVET CDACC

Observation Checklist 1B
# Performance Criterion Max Marks Awarded
Typing the 4 records 4
Typing the column headings; in bold
2

Merging cells in row 1; typing text

2

(a) Typing text in rows 7,8,9 and columns uppercase

2

Typing text in columns F,G, Capitalizing each

2
word
Saving with the correct name; in the named
2
folder.
Sorting data
(Award 1 mark for sorting using the correct
(b) 3
criteria and 2 marks for sorting only the required
data)
Calculated the total score for each student
(Award 1 mark for correct function and 1 mark 2
for auto filling)
Calculated the average score for each student
(Award 1 mark for correct function and 1 mark 2
for auto filling)
(c)
Calculated the highest score for each subject
(Award 1 mark for correct function and 1 mark 2
for auto filling)
Calculated the lowest score for each subject
(Award 1 mark for correct function and 1 mark 2
for auto filling)
Creating a line chart;
(Award 2 marks for inserting line chart, 1 mark
(d) for correct data, 1 mark for title, 1 mark for 7
legend, 1 mark for horizontal axis title and 1
mark for vertical axis title)

Page 5 of 14
 © 2025 TVET CDACC

Printing
(Award 1 mark for page orientation and 2 marks
(e) 3
for printing both the data and the chart on one
sheet)

Total Marks in Task 1B 35

Page 6 of 14
 © 2025 TVET CDACC

5. SECTION 2 – SESSION 2 (~ 2 HOURS)

Elements Covered:
 Maintain computerized database
 Prepare PowerPoint Presentation

Observation Checklist 2A
Max Awarded
# Items to be Evaluated
Marks

(a) Created a folder named MidTerm on the Desktop 2

(b) Creating a database file named Masomo; in the named

2
folder

(c) Creating a table named Books 1

6 field names and data types 6 8

Assigning primary key 1

(d) Creating a table named Borrowers 1

5 field names and data types 5 7

Assigning primary key 1

(e) Creating appropriate relationship between the tables. 2

(f) Entering 3 records in each table, total 6 records 6

(g) Creating two forms named BooksForm and

BorrowersForm using the two tables. 6

(award 3 marks for each form created)

(h) Creating a query named Borrowed; to display the Title,

Author, Status and Borrower Name.
6
(award 1 mark for query name, 1 mark for each field and
1 mark for correct criteria)

Page 7 of 14
 © 2025 TVET CDACC

Max Awarded
# Items to be Evaluated
Marks

(i) Creating a report named BooksRpt; to display all the

books in the library.
4
(Award 2 mark for report name and 2 marks for the
correct source of data)

(j) Printed BooksRpt and BorrowersForm

2
(Award 1 mark for each correct report printed)

TOTAL 45

Observation Checklist 2B
# Performance Criterion Max Marks Awarded

(a) Slide 1: 3
Typing title 1mk
Inserting the picture 2 mks
Slide 2: 3
Typing the title 1mk
Typing; and formatting the content 2 mks
Slide 3: 3
Typing the title 1mk
Typing; and numbering the content 2 mks
Slide 4: 6
Typing the title 1mk
Typing; bold; increased font size 3 mks
Indenting and bulleting 2 mks
Slide 5: 3
Typing the title 1mk
Inserting the table and keying in the data 2 mks

Page 8 of 14
 © 2025 TVET CDACC

Slide 6: 3
Typing the title 1mk
Inserting the smartart and keying in the data 2
mks
Slide 7: 1
Typing the title and content 1mk

(b) Converted the text in title slide to a WordArt 2

(c) Applying a slide design 2

(d) Applying Shape Circle slide transitions to all the 2

slides
(e) Apply Wedge animation to all the slides 2

(f) Inserted a new slide after slide 5; inserted a 3-D 7

clustered; column chart; using correct data; with
legend; and horizontal; and vertical axes titles
(g) Inserted slide numbers; to appear on every page 2
(h) Inserted header reading “Gender mainstreaming” 2
to appear on every slide
(i) Created a custom slide show named Tanzania; to 2
include slides 1,5, 6 and 7;
(j) Printed a horizontal; handout of 4 slides per page 2
Total Marks in Section 2A 45

Page 9 of 14
 © 2025 TVET CDACC

6. SECTION 3 – SESSION 3 (~3 HOURS)

Elements Covered:

 Manipulate graphic application

 Perform Online Collaboration

Observation Checklist 3A
Performance Criterion Max
# Awarded
Marks
Set up the page or drawing area using the given
(a) 4
measurements
Included the given details
(b) 10
(Award 2 marks for each detail)

(c) Added an appropriate logo or symbol 4

Applied Design and Layout

(d) Use of colors, shapes, and alignment of objects 6
(Award 2 marks for each detail)
Ensured good spacing and contrast between text
and background 6
(Award 2 marks for each detail)
Saved the business card
(e) (Award 1 mark for correct file name, 1 mark for 2
the folder)
Producing pdf
(f) (Award 2 marks for the pdf, 1 mark for saving it 3
in the folder)
Total Marks in Section 3A 35

Page 10 of 14
 © 2025 TVET CDACC

Observation Checklist 3B
Performance Criterion Max
# Awarded
Marks
Successfully logged in to Google account 3
(a) Uploaded the pdf file named MyBizCard
5
into Google Drive
Creating email subject 2

Adding To address 2

(b)
Adding CC address 2

Attached MyBizCard pdf file

4
(Attaching the file 2 mks, as a link 2 mks

Changed Theme to Candy 2

(c) Change the maximum page size to show
5
100 conversations

Total Marks in Section 3A 25

Page 11 of 14
 © 2025 TVET CDACC

7. SECTION 4 – ORAL ASSESSMENT (25 MARKS)

Expected Response (Key Max Awarded
No. Question
Points) Marks Marks
What is meant by
Proper posture, equipment
1 computer 2
setup;
ergonomics?
Why is computer
To prevents fatigue, injury,
ergonomics 2
enhances productivity.
important?
Differentiate
Save updates current file; Save
between Save and
2 As creates a new copy or 2
Save As in word
changes format/location.
processing.
Name and describe
Relative (A1), Absolute
any two cell
3 ($A$1), Mixed ($A1 or A$1); 4
referencing types
affect copying formulas.
used in spreadsheets.
Retrieves data based on
What is a query in a
4 criteria; filters, sorts, 2
database?
computes results from tables.
Visual communication,
State two advantages
engagement, multimedia
5 of using presentation 2
integration, structured
software.
delivery.
What is a flyer and
Single-page publication for
which software can
6 events or promos; use 2
you use to create
Microsoft Publisher.
one?
Explain the process
of creating a PDF
File → Save As → change
8 document when 3
Save as type to PDF.
using Microsoft
Word.

Page 12 of 14
 © 2025 TVET CDACC

Mention three
Tools: Google Docs, Zoom,
examples of online
Microsoft Teams; Benefit:
9 collaboration tools 4
teamwork, real-time editing,
and one benefit of
communication.
using them.
What is the Form: data entry/edit
difference between a interface; Report: formatted
10 2
form and a report in output for printing/viewing
a database? data.
Total 25

Page 13 of 14
 © 2025 TVET CDACC

8. SUMMARY OF ASSESSMENT
S/N SECTION Total Marks Marks Awarded
1. Assessment 1 90
2. Assessment 2 90
3. Assessment 3 60
4. Oral Assessment 25
5. Grand Total 265

The candidate was found to be:

Competent Not yet Competent

(Please tick as appropriate)
The candidate is competent if the candidate obtains at least 50%

Page 14 of 14