LEARNING PLAN
UNIT CODE: 0611 351 02A
Unit of Competence: Perform Computer Operations
Name of the Trainer:
Teaching Practice Institution:
Date of Preparation: 11/01/2025
Skill or Job task
This unit covers the learning outcomes, content, assessment methods, methods of delivery, and resources required to perform
computer operations. It involves processing computerized word documents, manipulating computerized spreadsheets, maintaining
computerized databases, preparing PowerPoint presentation slides, manipulating graphic applications, and performing online
collaboration.
Benchmark
I. Process computerized word document
II. Manipulate computerized spreadsheet
III. Maintain computerized database
IV. Prepare PowerPoint presentation
V. Manipulate graphic application
VI. Perform online collaboration
We Sessio Session Title Learning Trainer Trainee Resources & Learning Reflecti
ek n No. Outcomes Activities Activities References Checks/Assessme ons &
nts Date
We 1 Word By the end of the - Lecture on - Note - Shelly, G. B., - Quiz on
ek 1 (Theor Documents: session, trainees ergonomics ergonomics & Vermaat, M. ergonomics/proc
y, 2h) Introduction should be able E. (2023). essors
- Explain - Review
to:
word processors Microsoft - Creation
I. Explain processors Office 365 & summary
- Discuss
ergonomics risks Word 2021
- Discuss creation
Comprehensiv
II. Define word creation
e
processors
. Cengage
III. Discuss
Learning.
document
creation - Microsoft
Word
documentatio
n.
We 2 Word By the end of the - Demo - Create - PCs with MS - Document
ek 1 (Practic Documents: session, trainees document documents Word creation
al, 2h) Creating should be able creation assessment
- Edit text - Word
Documents to:
- Guide tutorials - Formatting
- Format
I. Create word editing checklist
text - Shelly, G. B.
documents
- Supervise (2023).
II. Use basic formatting
Lab Manual
editing tools .
III. Apply
formatting
We 1 Word By the end of the - Lecture on - Review - Shelly, G. B. - Quiz on editing
ek 2 (Theor Documents: session, trainees editing editing (2023). features
y, 2h) Advanced Editing should be able
- Explain - Analyze Microsoft - Tool summary
to:
tables/merg tables/merg Office 365 &
I. Explain editing e e Word
features
- Discuss - Discuss .
II. Discuss zoom/help tools
- Online Word
tables/mail tools
guides (e.g.,
merge
Microsoft).
III. Describe
productivity
tools
We 2 Word By the end of the - Demo - Create - PCs with MS - Table/merge
ek 2 (Practic Documents: session, trainees table tables Word assessment
al, 2h) Tables and should be able insertion
- Execute - Sample data - Tool usage
Merge to:
- Guide mail mail merge for merge checklist
I. Insert/edit merge
- Use - Word
tables
- Supervise zoom/help tutorials
II. Perform mail tool use
merge
III. Use
productivity
tools
We 1 Word By the end of the - Lecture on - Review - Shelly, G. B. - Quiz on
ek 3 (Theor Documents: session, trainees objects objects (2023). objects/printing
y, 2h) Objects and should be able
- Explain - Analyze Microsoft - TOC summary
Printing to:
lists/TOC lists/TOC Office 365 &
I. Explain object Word
- Discuss - Discuss
insertion
printing printing .
II. Discuss
- Printing
lists/TOC
guides (e.g.,
III. Describe print HP).
setup
We 2 Word By the end of the - Demo - Insert - PCs with MS - Object/TOC
ek 3 (Practic Documents: session, trainees object objects Word assessment
al, 2h) Objects and TOC should be able insertion
- Create - Printers - Printing
to:
- Guide lists/TOC checklist
- Sample
I. Insert lists/TOC
- Print images
pictures/shapes
- Supervise documents
II. Create printing
lists/TOC
III. Print
documents
We 1 Spreadsheets: By the end of the - Lecture on - Review - Shelly, G. B., - Quiz on
ek 4 (Theor Introduction session, trainees spreadsheet concepts & Vermaat, M. spreadsheets
y, 2h) should be able s E. (2023).
- List - Referencing
to:
- Explain elements Microsoft summary
I. Explain elements Office 365 &
- Analyze
spreadsheet Excel 2021
- Discuss referencing
concepts Comprehensiv
referencing
e
II. Define
elements (rows, . Cengage
cells) Learning.
III. Discuss cell - Excel
referencing documentatio
n.
We 2 Spreadsheets: By the end of the - Demo - Create - PCs with MS - Workbook
ek 4 (Practic Creating session, trainees workbook workbooks Excel assessment
al, 2h) Workbooks should be able creation
- Enter data - Excel - Reference
to:
- Guide data tutorials checklist
- Apply
I. Create entry
references - Sample data
workbooks
- Supervise
II. Enter data referencing
III. Use cell
references
We 1 CAT 1: Word and By the end of the - Administer - Complete - CAT 1 - CAT 1
ek 5 (Theor session, trainees
y, 2h) Spreadsheets should be able CAT 1 CAT 1 question bank assessment
to:
- Provide - Solve - Shelly, G. B. - Trainer feedback
I. Explain word questions problems (2023).
processing
- Evaluate - Reflect Microsoft
II. Discuss responses Office 365
spreadsheets
.
III. Solve
problems
We 2 CAT 1: Practical By the end of the - Administer - Create - PCs with MS - Practical CAT 1
ek 5 (Practic Word/Spreadshe session, trainees CAT 1 documents Office assessment
al, 2h) ets should be able
- Supervise - Edit - CAT 1 rubric - Documentation
to:
tasks workbooks evaluation
- Sample tasks
I. Create/edit
- Evaluate - Document
documents
performanc
II. Manipulate e
workbooks
III. Document
processes
We 1 Spreadsheets: By the end of the - Lecture on - Review - Shelly, G. B. - Quiz on
ek 6 (Theor Formulas and session, trainees formulas formulas (2023). formulas/formatti
y, 2h) Formatting should be able ng
- Explain - Analyze Microsoft
to:
formatting formatting Office 365 & - Chart summary
I. Explain
formulas/functio - Discuss - Discuss Excel
ns charts charts
.
II. Discuss
- Excel chart
formatting
guides.
III. Describe
charts
We 2 Spreadsheets: By the end of the - Demo - Use - PCs with MS - Formula/chart
ek 6 (Practic Formulas and session, trainees formulas formulas Excel assessment
al, 2h) Charts should be able
- Guide - Format - Sample - Formatting
to:
formatting worksheets datasets checklist
I. Apply
- Supervise - Create - Chart
formulas/functio
chart charts templates
ns
creation
II. Format
worksheets
III. Create charts
We 1 Databases: By the end of the - Lecture on - Review - Connolly, T., - Quiz on
ek 7 (Theor Introduction session, trainees databases concepts & Begg, C. databases
y, 2h) should be able (2023).
- Explain - Analyze - Requirement
to:
organizatio organizatio Database summary
I. Define n n Systems: A
database Practical
- Discuss - Discuss
concepts Approach
requiremen requiremen
II. Explain ts ts (7th ed.).
organization Pearson.
III. Discuss user - Access
requirements documentatio
n.
We 2 Databases: By the end of the - Demo - Create - PCs with MS - Table creation
ek 7 (Practic Creating Tables session, trainees table tables Access assessment
al, 2h) should be able creation
- Set - Access - Data entry
to:
- Guide field fields/keys tutorials checklist
I. Create tables setup
- Enter - Sample data
II. Define - Supervise records
fields/keys data entry
III. Enter records
We 1 Databases: By the end of the - Lecture on - Review - Connolly, T. - Quiz on
ek 8 (Theor Schema and session, trainees schema schema (2023). schema/objects
y, 2h) Objects should be able
- Explain - Analyze Database - Manipulation
to:
objects objects Systems summary
I. Explain schema
- Discuss - Discuss .
design
manipulatio manipulatio
- Online
II. Discuss n n
Access guides.
objects (forms,
queries)
III. Describe data
manipulation
We 2 Databases: By the end of the - Demo - Create - PCs with MS - Form/query
ek 8 (Practic Forms and session, trainees form forms Access assessment
al, 2h) Queries should be able creation
- Design - Sample - Manipulation
to:
- Guide queries database checklist
I. Create forms query
- - Query
design
II. Design queries Manipulate templates
- Supervise data
III. Manipulate
manipulatio
data
n
We 1 PowerPoint: By the end of the - Lecture on - Review - Shelly, G. B., - Quiz on
ek 9 (Theor Introduction session, trainees presentatio terms & Vermaat, M. presentations
y, 2h) should be able ns E. (2023).
- Analyze - Layout summary
to:
- Discuss requiremen Microsoft
I. Define requiremen ts Office 365 &
presentation ts PowerPoint
- Discuss
terms 2021
- Explain layouts
Comprehensiv
II. Discuss layouts
e
requirements
. Cengage
III. Explain slide
Learning.
layouts
- PowerPoint
documentatio
n.
We 2 PowerPoint: By the end of the - Demo - Create - PCs with MS - Slide creation
ek 9 (Practic Creating Slides session, trainees slide slides PowerPoint assessment
al, 2h) should be able creation
- Add - PowerPoint - Saving checklist
to:
- Guide text text/data tutorials
I. Create slides entry
- Save - Sample
II. Add text/data - Supervise presentatio content
saving ns
III. Save
presentations
We 1 CAT 2: Databases By the end of the - Administer - Complete - CAT 2 - CAT 2
ek (Theor and PowerPoint session, trainees CAT 2 CAT 2 question bank assessment
10 y, 2h) should be able
- Provide - Solve - Connolly, T. - Trainer feedback
to:
questions problems (2023).
I. Explain
- Evaluate - Reflect Database
database
responses Systems
management
.
II. Discuss
presentations
III. Solve
problems
We 2 CAT 2: Practical By the end of the - Administer - Manage - PCs with MS - Practical CAT 2
ek (Practic Databases/Powe session, trainees CAT 2 databases Access/Power assessment
10 al, 2h) rPoint should be able
- Supervise - Create
to: tasks slides Point - Documentation
evaluation
I. Manage - Evaluate - Document - CAT 2 rubric
database objects performanc
- Sample tasks
e
II. Create slides
III. Document
processes
We 1 PowerPoint: By the end of the - Lecture on - Review - Shelly, G. B. - Quiz on
ek (Theor Animation and session, trainees animations animations (2023). animations/printi
11 y, 2h) Printing should be able ng
- Explain - Analyze Microsoft
to:
manipulatio manipulatio Office 365 & - Manipulation
I. Explain n n PowerPoint summary
animations/trans
- Discuss - Discuss .
itions
printing printing
- Printing
II. Discuss slide
guides (e.g.,
manipulation
Canon).
III. Describe
printing
We 2 PowerPoint: By the end of the - Demo - Apply - PCs with MS - Animation/slide
ek (Practic Animations and session, trainees animations animations PowerPoint assessment
11 al, 2h) Slides should be able
- Guide - - Printers - Printing
to:
manipulatio Manipulate checklist
- Sample
I. Apply n slides
slides
animations/trans
itions - Supervise - Print
printing presentatio
II. Manipulate
ns
slides
III. Print
presentations
We 1 Graphic By the end of the - Lecture on - Review - Adobe Press. - Quiz on graphics
ek (Theor Applications: session, trainees graphics terms (2023).
- Publication
12 y, 2h) Introduction should be able
- Discuss - Analyze Adobe summary
to:
requiremen requiremen InDesign
I. Define graphic ts ts Classroom in
terms a Book
- Explain - Discuss
II. Discuss publications publications . Adobe Press.
requirements
- InDesign
III. Explain documentatio
publication types n.
We 2 Graphic By the end of the - Demo - Create - PCs with - Publication
ek (Practic Applications: session, trainees publication publications Adobe assessment
12 al, 2h) Creating Designs should be able creation InDesign
- Add - Formatting
to:
- Guide content - InDesign checklist
I. Create content tutorials
- Format
publications addition
text - Sample
II. Add content - Supervise templates
III. Format text formatting
We 1 Graphic By the end of the - Lecture on - Review - Adobe Press. - Quiz on
ek (Theor Applications: session, trainees formatting formatting (2023). formatting/printi
13 y, 2h) Formatting and should be able ng
- Explain - Analyze Adobe
Printing to:
objects objects InDesign - Object summary
I. Explain page
- Discuss - Discuss .
formatting
printing printing
- Printing
II. Discuss
guides (e.g.,
graphic objects
Epson).
III. Describe
printing
We 2 Graphic By the end of the - Demo - Format - PCs with - Formatting
ek (Practic Applications: session, trainees formatting pages Adobe assessment
13 al, 2h) Formatting should be able InDesign
- Guide - Insert - Printing
Designs to:
object objects - Printers checklist
I. Format pages insertion
- Print - Sample
II. Insert graphic - Supervise publications graphics
objects printing
III. Print
publications
We 1 Online By the end of the - Lecture on - Review - Horton, J. J. - Quiz on
ek (Theor Collaboration: session, trainees collaboratio collaboratio (2020). collaboration
should be able n
The Online
14 y, 2h) Introduction to: - Discuss n Labor Market - Tool summary
tools
I. Define - List tools . MIT Press.
collaboration - Explain
- Analyze - Zoom/Teams
setup
II. Discuss tools setup documentatio
(Zoom, Teams) n.
III. Explain setup
features
We 2 Online By the end of the - Demo tool - Set up - Internet- - Setup
ek (Practic Collaboration: session, trainees setup tools enabled PCs assessment
14 al, 2h) Tool Setup should be able
- Guide - Register - Zoom/Teams - Feature
to:
registration accounts software checklist
I. Set up
- Supervise - Test - Setup guides
collaboration
testing features
tools
II. Register
accounts
III. Test features
We 1 Online By the end of the - Lecture on - Review - Horton, J. J. - Quiz on
ek (Theor Collaboration: session, trainees applications applications (2020). applications
15 y, 2h) Applications should be able
- Discuss - Analyze The Online - Mobile
to:
email/calen email/calen Labor Market summary
I. Explain tool dars dars
.
applications - Explain - Discuss - Google
mobile mobile Drive/Outlook
II. Discuss
guides.
email/calendars
III. Describe
mobile
collaboration
We 2 Online By the end of the - Demo tool - Use tools - Internet- - Tool usage
ek (Practic Collaboration: session, trainees use enabled PCs assessment
- Manage
15 al, 2h) Using Tools should be able
- Guide email/calen - Mobile - Sync checklist
to:
email/calen dars devices
I. Use dars
- Sync apps -
collaboration
- Supervise Collaboration
tools
syncing software
II. Manage
email/calendars
III. Sync mobile
apps
We 1 Final Theory By the end of the - Administer - Complete - Exam - Theory exam
ek (Theor Assessment session, trainees exam exam question bank assessment
16 y, 2h) should be able
- Ensure - Apply - Shelly, G. B. - Trainer feedback
to:
integrity concepts (2023).
I. Demonstrate
- Provide - Reflect Microsoft
knowledge
II. Apply feedback Office 365
concepts
.
III. Analyze
operations
We 2 Capstone Project By the end of the - Supervise - Present - PCs with MS - Project
ek (Practic and Reflection session, trainees presentatio project Office/InDesig assessment
16 al, 2h) should be able ns n
- - Reflection
to:
- Evaluate Demonstrat - Presentation evaluation
I. Demonstrate performanc e skills tools
skills e
- Reflect - Reflective
II. Present - Guide journals
project reflection
III. Reflect on
outcomes