COMPUTER OPERATIONS
ISCED UNIT CODE: 0611 351 02A
TVET CDACC UNIT CODE: IT/CU/ICTA/CR/02/4/MA
Duration of Unit: 150 hours
Relationship to Occupational Standards
This unit addresses the Unit of Competency: Perform Computer Operations
Unit Description
This unit covers the competencies required to perform computer operations. It involves
processing computerized word documents, manipulating computerized spreadsheets,
maintaining computerized databases, preparing PowerPoint presentation slides, manipulating
graphic application and performing online collaboration.
m
Summary of Learning Outcomes
o
.c
et
tv
sy
Learning Outcomes Durations(Hours)
ea
1. Process computerized word document 30
2. Manipulate computerized spreadsheet 30
3. Maintain computerized database 30
4. Prepare PowerPoint presentation 20
5. Manipulate graphic application 25
6. Perform online collaboration 15
Total Hours: 150
Learning Outcomes, Content and Suggested Assessment Methods
Learning Outcome Content Suggested Assessment
Methods
©TVET CDACC, 2025
1. Process 1.1 Ergonomics risk factors ● Practical assessment
computerized word 1.2 Creation of computerized word ● Simulations
document document ● Project
1.2.1 Introduction to word document ● Observation Checklist
1.2.2 Types of word processors ● Product Checklist
1.2.3 Creating word document ● Written assessment
1.2.4 Editing and formatting word ● Portfolio of evidence
document
1.2.5 Word document editing
features
[Link] Text editing
[Link] Paragraph editing
[Link] Document editing
1.2.6 Word document formatting
features
[Link] Text formatting
om
[Link] Paragraph formatting
.c
et
tv
sy
[Link] Document formatting
ea
1.2.7 Enhancing productivity
[Link] Set basic options/
preferences
[Link] Help resources
[Link] Use magnification/zoom
tools
[Link] Display, hide built-in tool
bar
1.3 Creation and manipulation of tables
1.3.1 Inserting tables
1.3.2 Working with tables
1.4 Mail merge
1.5.1 Mail merge preparation
©TVET CDACC, 2025
1.5.2 Mail merge output
1.5 Inserting word processing objects
1.5.1 Picture
1.5.2 Shapes
1.5.3 Table
1.5.4 Charts
1.6 Generating list of figures and table
of content
1.6.1 List of figures
1.6.2 Table of content
1.7 Printing of computerized word
document
1.7.1 Print setup
1.7.2 Printing
2. Manipulate 2.1 Creation of Computerized ● Practical assessment
computerized spreadsheet workbook ● Simulations
om
spreadsheet 2.1.1 Spreadsheet concepts ● Project
.c
et
tv
sy
2.1.2 Elements of spreadsheet ● Observation Checklist
ea
window ● Product Checklist
[Link] Worksheet ● Written assessment
[Link] workbook ● Portfolio of evidence
[Link] Rows
[Link] columns
[Link] Cells
2.2 Cell referencing
[Link] Relative cell
referencing
[Link] Absolute cell
referencing
[Link] Mixed cell
referencing
©TVET CDACC, 2025
2.2.2 Spreadsheet editing
features
[Link] Worksheet editing
[Link] Inserting
rows/columns
[Link] Removing
rows/columns
[Link] Adjusting row
heights and column
width
[Link] Inserting
worksheets
[Link] Renaming
worksheets
[Link] Move or copy
worksheets
o m
[Link] Deleting
.c
et
tv
sy
worksheets
ea
2.2.3 Data manipulation in
spreadsheets
[Link] Data entry
[Link] Types of data
2.3 Formulas and functions
[Link] Formulas and
functions syntax
[Link] Arithmetic
functions
[Link] logical functions
[Link] Look up functions
2.3.2 Computerized spreadsheet
10
©TVET CDACC, 2025
worksheet formatting
[Link] Font styles
[Link] Alignment
[Link] Borders and
shading
[Link] Header and footer
2.4 Charts generation
[Link] Types of charts
[Link] Insert charts
[Link] Labelling and
Editing charts
[Link] Computerized
spreadsheet
workbook printing
[Link] Print setup
[Link] Printing
m
o
3. Maintain 3.1 Computerised database user ● Practical assessment
.c
et
tv
sy
computerised requirements collection ● Simulations
ea
database 3.1.1 Introduction to database ● Project
[Link] Key concepts ● Observation Checklist
[Link] Database ● Product Checklist
organisation ● Written assessment
[Link] Database ● Portfolio of evidence
relationships
[Link] Database
operations
3.1.2 Collection of User
requirements
3.2 Design Computerised database
schema
3.2.1 Creating database models
11
©TVET CDACC, 2025
[Link] ERD models
[Link] Relational models
3.3 Creation of Computerised database
objects
3.3.1 Database Objects
[Link] Tables
[Link] Records
[Link] Fields
[Link] Keys
[Link] Forms
[Link] Queries
[Link] Reports
3.4 Data manipulation
3.4.1 Inserting records
3.4.2 Retrieving records
3.4.3 Deleting records
om
3.4.4 Updating record
.c
et
tv
sy
3.4.5 Printing database objects
ea
[Link] Tables
[Link] Forms
[Link] Queries
[Link] Reports
4. Prepare Power point 4.1 Collecting PowerPoint Presentation ● Practical assessment
presentation requirements ● Simulations
4.1.1 Definition of terms ● Project
4.1.2 Presentation requirements ● Observation Checklist
4.1.3 Types of presentation ● Product Checklist
software ● Written assessment
4.1.4 Elements of presentation ● Portfolio of evidence
window
4.2 Creating PowerPoint slides
12
©TVET CDACC, 2025
4.2.1 Types of presentation
layout
4.2.2 Factors to consider when
designing presentation
layout
4.2.3 Design a PowerPoint
presentation
4.2.4 Create a PowerPoint
presentation
4.2.5 Save a PowerPoint
presentation
4.3 Exhibit presentation views
4.2.1 Slide views
4.2.2 Working with
presentations
[Link] Switch between
om
open PowerPoint
.c
et
tv
sy
presentations
ea
4.4 Perform animation and transitions
4.4.1 Slide animation
4.4.2 Slide transition
4.5 Manipulation of PowerPoint slides
4.5.1 Adding data/text to a slide
4.5.2 Formatting data/text
4.5.3 Move/copy/delete a slide
4.5.4 Inserting header and
footer
4.5.5 Presentation objects
[Link] Tables
[Link] Charts
4.6 Printing of PowerPoint slides
13
©TVET CDACC, 2025
4.6.1 Print setup
4.6.2 Printing PowerPoint
presentation
5. Manipulate graphic 5.1 Identifying graphic design ● Practical assessment
application requirements ● Simulations
5.1.1 Definition of terms ● Project
5.1.2 Graphic application ● Written assessment
requirements ● Portfolio of evidence
5.1.3 Types of graphic
application software
5.1.4 Types of publications
designs
[Link] Templates
[Link] Banners
[Link] Booklets
[Link] Brochures
om
[Link] Flyers
.c
et
tv
sy
[Link] Posters
ea
[Link] Cards
[Link] Certificates
[Link] Magazines
5.1.5 Elements of Graphic
application window
5.2 Creation of graphic design
5.2.1 Perform basic tasks using
graphic application
software
[Link] Publication type
[Link] Page setup
[Link] Ruler/guides
[Link] Page views
14
©TVET CDACC, 2025
5.2.2 Add content to a
publication
5.2.3 Edit content to a
publication
5.2.4 Format text and
paragraphs in a
publication
5.2.5 Page formatting in a
publication
[Link] Columns
[Link] Borders and shading
[Link] Headers and footers
[Link] Background
[Link] Watermarks
[Link] Orientation
5.2.6 Work with graphics
om
objects in a publication
.c
et
tv
sy
[Link] Textbox
ea
[Link] Tables
[Link] Shapes
[Link] Pictures
[Link] (PNG, JPEG, GIF)
5.3 Publishing of graphic design
5.3.1 Prepare a publication
5.3.2 Print setup
5.3.3 Printing publication
6. Perform document 6.1 Printing documents ● Practical assessment
production 6.1.1 Introduction to document ● Simulations
production ● Project
6.1.2 Types of printers ● Observation Checklist
15
©TVET CDACC, 2025
6.1.3 Document printing ● Product Checklist
6.2 Document scanning ● Written assessment
6.2.1 Types of scanners ● Portfolio of evidence
6.2.2 Document scanning
6.3 Document duplication
7. Perform Online 7.1 Identification of Online ● Practical assessment
Collaboration collaboration tools ● Simulations
7.1.1 Definition of online ● Project
collaboration ● Observation Checklist
7.1.2 Importance of online ● Product Checklist
collaboration ● Written assessment
7.1.3 Factors to consider when ● Portfolio of evidence
choosing an online
collaboration tool
7.1.4 Online collaboration tools
[Link] Microsoft teams
om
[Link] Skype
.c
et
tv
sy
[Link] Google drive
ea
[Link] Zoom
[Link] Google meet
[Link] Slack
7.2 Online collaboration preparation
7.2.1 Online collaboration key
concepts
7.2.2 Common setup features
[Link] Download software to
support online
collaboration tools
[Link] Register and/ or set a
user account
7.2.3 Preparation for online
16
©TVET CDACC, 2025
collaboration
7.3 Application of online collaborative
tools
7.3.1 Using online collaborative
tools
[Link] Online storage media
[Link] Using email
[Link].1 Sending and
receiving email
[Link].2 Tools and settings
[Link].3 Organizing email
[Link] Using calendars
[Link] Online calendars
[Link] Social media
[Link] Online learning
environment
om
[Link] Synchronization tools
.c
et
tv
sy
7.4 Demonstrating Mobile
ea
collaborations
7.4.1 Key concepts in mobile
applications
7.4.2 Mobile applications
permissions
7.4.3 Synchronization
Suggested Delivery Methods
● Demonstration by trainer
● Practical work by trainee
● Viewing of related videos
● Group discussions
● Facilitation using active learning strategies
Recommended Resources for 25 Trainees
17
©TVET CDACC, 2025
S/No. Category/Item Description/ Quantity Recommended
Specifications Ratio
(Trainee: Item)
A Learning Materials
1. Textbooks 5 pcs 5:1
2. Installation manuals 5 pcs 5:1
3. Flip Charts 5 pcs 5:1
4. PowerPoint presentations For trainer’s use
5. Magazines/brochures/busin
ess cards
B Learning Facilities &
infrastructure
om
.c
6. Lecture/theory room 1 25:1
et
tv
sy
ea
7. Laboratory 1 25:1
C Consumable materials
8. Printing papers 1 ream 1:20
9. Foolscaps 1 ream
10. Toners/cartridges 2 pcs 13:1
11. Assorted colour of
whiteboard markers
D Tools and Equipment
12. Computers 25 pcs 1:1
18
©TVET CDACC, 2025
13. Projector 1 pc 25:1
14. Printers 2 pcs 1:13
15. Whiteboard 1 pc 25:1
16. Flash drives 5 pcs 5:1
17. 1 External Hard drive 1 pcs 25:1
18. Application software suite 5 pcs 5:1
om
.c
et
tv
sy
ea
19
©TVET CDACC, 2025