COMPUTER OPERATIONS
UNIT CODE: 0611 541 01A
Duration of Unit: 90 hours
Relationship to Occupational Standards
This unit addresses the Unit of Competency: Apply Computer Operations
Unit Description
This unit covers the competencies required to apply computer operations. It involves
processing computerized word documents, manipulating computerized spread sheets,
maintaining computerized databases, prepare PowerPoint presentation, manipulating graphic
application and performing online collaboration.
Summary of Learning Outcomes
Learning Outcomes Durations (Hours)
1. Process computerized word document 20
2. Manipulate computerized spreadsheet 25
om
3. Maintain computerized database 15
.c
et
tv
4. Prepare Power point presentation 10
sy
ea
5. Manipulate graphic application 10
6. Perform online collaboration 10
TOTAL 90
Learning Outcomes, Content and Suggested Assessment Methods
Learning Outcome Content Suggested Assessment
Methods
1. Process 1.1 Ergonomic risk factors ● Practical assessment
computerized word 1.2 Operating Computer devices ● Simulations
document 1.2.1 Meaning and importance of ● Project
computer ● Observation Checklist
1.2.2 Functions and Uses of ● Product Checklist
Computers ● Written assessment
1.2.3 Classification of computers ● Portfolio of evidence
1.2.4 Components of a computer
16
system
1.2.5 Computer Hardware
[Link] The System Unit
[Link] Input Devices
[Link].1 Mouse use
techniques
[Link].2 Keyboard Parts and
Use Techniques
[Link] Output Devices
[Link] Storage Devices
[Link] Computer Ports
1.2.6 Procedure for turning/off a
computer
1.2.7 Desktop Customization
1.2.8 File and Files Management
using an operating system
1.2.9 Computer external devices
om
.c
et
management
tv
sy
ea
1.3 Creation of computerized word
document
1.3.1 Introduction to word
document
1.3.2 Types of word processors
1.3.3 Creating word document
1.4 Editing and formatting word
document
1.3.4 Word document editing
features
[Link] Text editing
[Link] Paragraph editing
[Link] Document editing
1.4.1 Word document formatting
features
[Link] Text formatting
17
[Link] Paragraph
formatting
[Link] Document
formatting
1.4.2 Enhancing productivity
[Link] Set basic options/
preferences
[Link] Help resources
[Link] Use
magnification/zoo
m tools
[Link] Display, hide
built-in tool bar
1.5 Mail merge
1.5.1 Mail merge preparation
1.5.2 Mail merge output
1.6 Printing of computerized word
om
.c
et
document
tv
sy
ea
1.6.1 Print setup
1.6.2 Printing
2. Manipulate 2.1 Creation of Computerized ● Practical assessment
computerized spreadsheet workbook ● Simulations
spreadsheet 2.1.1 Spreadsheet concepts ● Project
2.1.2 Elements of spreadsheet ● Observation Checklist
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
18
referencing
[Link] Mixed cell
referencing
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
om
.c
et
[Link] Move or copy
tv
sy
ea
worksheets
[Link] Deleting
worksheets
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
19
2.3.2 Computerized spreadsheet
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
om
.c
et
3. Maintain 3.1 Computerised database user ● Practical assessment
tv
sy
ea
computerised requirements collection ● Simulations
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
[Link] ERD models
[Link] Relational models
20
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
3.4.4 Updating record
3.4.5 Printing database objects
[Link] Tables
om
.c
et
[Link] Forms
tv
sy
ea
[Link] Queries
[Link] Reports
4. Prepare Power point 4.1 Collection of Presentation ● Practical assessment
presentation requirements ● Simulations
4.1.1 Definition of terms ● Project
4.2.1 Presentation requirements ● Observation Checklist
4.2.2 Types of presentation ● Product Checklist
software ● Written assessment
4.2.3 Elements of presentation ● Portfolio of evidence
window
4.2.4 Manipulating
presentations
[Link] Create a
PowerPoint
presentation
21
[Link] Save a
PowerPoint
presentation
4.2.5 Working with
presentations
[Link] Switch between
open PowerPoint
presentations
4.2 Design presentation layout
4.2.1 Types of presentation
layout
4.2.2 Factors to consider when
designing presentation
layout
4.3 Creation of a Slide
4.3.1 Slide views
4.3.2 Slide designs
om
.c
et
4.3.3 Slide transition
tv
sy
ea
4.4 Manipulation of a slide
4.4.1 Adding data/text to a slide
4.4.2 Slide animation
4.4.3 Formatting data/text
4.4.4 Move/copy/delete a slide
4.4.5 Inserting header and
footer
4.4.6 Presentation objects
[Link] Tables
[Link] charts
4.4.7 Print setup
[Link] Printing
PowerPoint
presentation
22
5. Manipulate graphic 5.1 Collecting 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
[Link] Flyers
[Link] Posters
[Link] Cards
[Link] Certificates
om
.c
et
[Link] Magazines
tv
sy
ea
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
5.2.2 Add content to a
publication
5.2.3 Edit content to a
publication
23
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
objects in a publication
[Link] Textbox
[Link] Tables
[Link] Shapes
[Link] Pictures
om
.c
et
[Link] (PNG, JPEG, GIF)
tv
sy
ea
5.3 Publishing of graphic design
5.3.1 Prepare a publication
5.3.2 Print setup
5.3.3 Printing publication
6. Perform Online 6.1 Identification of Online ● Practical assessment
Collaboration collaboration tools ● Simulations
6.1.1 Definition of online ● Project
collaboration ● Observation Checklist
6.1.2 Importance of online ● Product Checklist
collaboration ● Written assessment
6.1.3 Factors to consider when ● Portfolio of evidence
choosing an online
collaboration tool
6.1.4 Online collaboration tools
[Link] Microsoft teams
[Link] Skype
24
[Link] Google drive
[Link] Zoom
[Link] Google meet
[Link] Slack
6.2 Online collaboration preparation
6.2.1 Online collaboration key
concepts
6.2.2 Common setup features
[Link] Download software to
support online
collaboration tools
[Link] Register and/ or set a
user account
6.2.3 Preparation for online
collaboration
6.3 Application of online collaborative
tools
om
.c
et
6.3.1 Using online collaborative
tv
sy
ea
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
[Link] Synchronization tools
6.4 Demonstrating Mobile
collaborations
25
6.4.1 Key concepts in mobile
applications
6.4.2 Mobile applications
permissions
6.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
S/No. Category/Item Description/ Quantity Recommended
Specifications Ratio
(Trainee: Item)
A Learning Materials
om
.c
1. Textbooks 5 pcs 5:1
et
tv
sy
ea
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
6. Lecture/theory room 1 25:1
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
26
D Tools and Equipment
12. Computers 25 pcs 1:1
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
27