Perform Computer Operations
Perform Computer Operations
PRACTICAL ASSESSMENT
Page 1 of 12
© 2026 TVET CDACC
Printed By: Kapcherop Technical And Vocational College
Date: 07.07.2026 09:48 PM
PRACTICAL ASSESSMENT 1 (4 HOURS) AND ORAL ASSESSMENT 1 (10 MINUTES)
Elements Covered
1. Process Computerized word document
Printed By: Kapcherop Technical And Vocational College
Create a folder on your desktop named: “Comp_OperatorExam_YourName”. Save all the files
inside this folder with the specified names and submit all files at the end of the assessment.
Printed By: Kapcherop Technical And Vocational College
Tasks Date: 07.07.2026 09:48 PM
PROCESS COMPUTERIZED WORD DOCUMENT
Printed By: Kapcherop Technical And Vocational College
a) Create a Word Processing Document.
Date: 07.07.2026 09:48 PM
Open a word processor and create a document named “[Link]”.
b) Report Writing
Type 200 – 250 words report, on the topic: “The importance of computers in Modern
organizations”.
Your report should clearly explain how computers improve communication, data
management, decision making, productivity, and service delivery in organizations.
Printed By: Kapcherop Technical And Vocational College
Use appropriate
Date: 07.07.2026 09:48 PM report formatting, including:
i. An introductory paragraph.
ii. At least Three (3) key benefits explained clearly.
iii. A concluding paragraph. Printed By: Kapcherop Technical And Vocational College
Date: 07.07.2026 09:48 PM
c) Apply the following formatting exactly as specified:
i. Title: Forte, 17pt, Bold, Centered
Printed By: Kapcherop Technical And Vocational College
ii. Headings: Algerian, 14pt, Bold, Blue
Date: 07.07.2026 09:48 PM
iii. Body text: Times New Roman, 12pt,Printed
1.5-line spacing
By: Kapcherop Technical And Vocational College
v. Insert a header containing your name and a footer containing page number and
automatic date.
Printed By: Kapcherop Technical And Vocational College
Date: 07.07.2026 09:48 PM
vi. Insert a drop cap at the beginning of the first paragraph
vii. Add a watermark with the words “COMPUTER REPORT”
d) Table
Printed Creation
By: Kapcherop and Mail
Technical Merge College
And Vocational Preparation. Within the same document [Link],
i. 09:48
Date: 07.07.2026 InsertPMa new page after the report.
ii. Create a table with 5 rows and 4 columns using the following headings:
Page 2 of 12
© 2026 TVET CDACC
Printed By: Kapcherop Technical And Vocational College
Date: 07.07.2026 09:48 PM
• Student Name, Course, Grade, and Remarks
iii. Enter details for four (4) sample students
iv. Apply boldBy:formatting
Printed to the header
Kapcherop Technical row College
And Vocational
vi. Apply table border to all cells using a 1pt solid line
e) Table enhancements
Printed By: Kapcherop Technical And Vocational College
i. Add a new row at the bottom of the table showing Average Grade calculated in
Date: 07.07.2026 09:48 PM
percentage
Printed By: Kapcherop Technical And Vocational College
ii. Sort the table by Grade from the highest to the lowest
Date: 07.07.2026 09:48 PM
iii. Insert a table caption above the table: “Table 1: Student Performance Summary”
f) Mail merge: Invitation letter
Create a mail merge document to send invitation letters to students for a graduation
ceremony.
i. Create Recipients List using Microsoft Excel, create a file named [Link]
with the following columns and five (5) sample students:
Printed By: Kapcherop Technical And Vocational College
Title
Date: 07.07.2026 09:48 PM First Name Last Name Course Email Address
ii. Create Invitation Letter Template. In Microsoft Word, create an invitation letter
template containing the following placeholders:
• <<Title>> <<First_Name>> <<Last_Name>>
Printed By: Kapcherop Technical And Vocational College
Date: 07.07.2026 09:48 PM
• <<Course>>
• <<Email_Address>>
Printed By: Kapcherop Technical And Vocational College
• PM
Date: 07.07.2026 09:48 The letter must include:
Date of graduation: 20th October 2026
Printed By: Kapcherop Technical And Vocational College
•
Date: 07.07.2026 09:48 PM
• Venue: Main Hall, “Name of your institution”
• Time: 10:00 AM
Printed By: Kapcherop Technical And Vocational College
• DressDate:
Code: Formal
07.07.2026 09:48 PM
• Yellow fill with black text for Profit between 10,000 and 30,000
Date: 07.07.2026 09:48 PM
iii. Create a pie chart showing the percentage contribution of each month’s Sales to
Total Sales. Place the pie chart on the same sheet as the data.
Printed By: Kapcherop Technical And Vocational College
d) Functions, Filtering
Date: 07.07.2026 and
09:48 PM data Analysis
• Average of Expenses
• Average of Profit
• MAX and MIN to find highest and lowest sales
ii. Apply AutoFilter to the data and:
• Display only months where profit > 25, 000
• Display
Printed By: Kapcherop Technical only months
And Vocational College where Sales between 50,000 and 70,000
iii. Data organization
Date: 07.07.2026 09:48 PM
Elements Covered
Date: 07.07.2026 09:48 PM
Printed By: Kapcherop Technical And Vocational College
1. Maintain computerized Database. Date: 07.07.2026 09:48 PM
Page 5 of 12
© 2026 TVET CDACC
Printed By: Kapcherop Technical And Vocational College
Date: 07.07.2026 09:48 PM
a) Open Microsoft Access and create a database named “[Link]” and save it
inside your folder.
b) Create the following
Printed By:tables using
Kapcherop the field
Technical names provided
And Vocational College in the tables below:
i. Patients
Date:table named
07.07.2026 as:
09:48 PMtblPatients
PATIENTS TABLE09:48 PM
Date: 07.07.2026 DOCTORS TABLE
• PatientID • DoctorID
• FirstName • FirstName
• LastName • LastName
• PhoneNumber
• Gender
YearsOfExperience
• Kapcherop
PhoneNumber
Printed By: Technical And Vocational College
•
Date: 07.07.2026 09:48 PM
• ConsultationFee
• BloodGroup
Printed By: Kapcherop Technical And Vocational College
• RoomNumber
•Date:RegistrationDate
07.07.2026 09:48 PM
Printed By: Kapcherop Technical And Vocational College
• Available
Date: 07.07.2026 09:48 PM
• MedicalCondition
Page 6 of 12
© 2026 TVET CDACC
Printed By: Kapcherop Technical And Vocational College
Date: 07.07.2026 09:48 PM
• Set validation rule for BloodGroup
• Apply Currency format for ConsultationFee
SetBy:Validation
•Printed rule forAnd
Kapcherop Technical YearsOfExperience
Vocational College
Date: 07.07.2026 09:48 PM
• Set correct field properties for Available (Yes/No with default value)
iv. Entering Records:
• Enter at least Ten (10) records in the Patients table
Printed By: Kapcherop Technical And Vocational College
• Enter
Date: 07.07.2026 at
09:48 PM least six (6) records in the Doctors table correctly
c) Create Relationship
Printed By: Kapcherop Technical And Vocational College
i. Create an appropriate relationship between the two09:48
Date: 07.07.2026 tables
PM so that a patient can be
assigned to a doctor.
ii. Enforce referential integrity
iii. Assign doctors to patients
d) Create and save the following queries as indicated:
i. Create a query named “qryAllPatients”
• Displays
Printed By: Kapcherop Technical all theCollege
And Vocational patients
•
Date: 07.07.2026 09:48 PM
Sort by LastName in ascending order
ii. Create a query named “qryPatientsByBloodGroup”:
• That display the following fields: Patient Name, BloodGroup,
Printed By: Kapcherop Technical And Vocational College
PhoneNumber, MedicalCondition
Date: 07.07.2026 09:48 PM
• PM
Date: 07.07.2026 09:48 Displays patient Name, assigned doctor, medical Condition and Doctor’s
Printed By: Kapcherop Technical And Vocational College
Specialization. Date: 07.07.2026 09:48 PM
e) Forms
i. Create a formPrinted
named “frmPatientEntry” based on the tblPatients table and apply a
By: Kapcherop Technical And Vocational College
professional theme/color
Date: 07.07.2026scheme
09:48 PM
ii. Create a form named “frmDoctorList” based on the tblDoctors table and apply a
professional theme matching the patient form
iii. Use the created forms to enter
Printed By: Kapcherop Technical And Vocational College
Date: 07.07.2026 09:48 PM
• Two (2) new records for Patients.
• Two (2) new records for Doctors.
Page 7 of 12
© 2026 TVET CDACC
Printed By: Kapcherop Technical And Vocational College
Date: 07.07.2026 09:48 PM
f) Reports
i. Create a report named rptPatientDirectory based on tblPatients:
Display
•Printed the following
By: Kapcherop fields:
Technical And patientID,
Vocational College FullName, Gender, BloodGroup,
• PreparedDate:
by:07.07.2026
“Your Name”
09:48 PM
Page 8 of 12
© 2026 TVET CDACC
Printed By: Kapcherop Technical And Vocational College
Date: 07.07.2026 09:48 PM
Slide 6 (conclusion and • Enter the title
Recommendations) • Include summary of main points
• Recommendations
Printed By: Kapcherop Technical And Vocational College
Date: 07.07.2026 09:48 PM
• Closing statement
b) Design and theme. Apply the following:
i. Use a consistent design theme for all slides
Printed By: Kapcherop Technical And Vocational College
ii. 07.07.2026
Date: All slides09:48
titlePMmust be bold and at least 32pt font size
iii. Body text must be at least 24pt font for readability
Printed By: Kapcherop Technical And Vocational College
iv. Insert a footer on all slides containing:
Date: 07.07.2026 09:48 PM
• Milk Hospital
• Slide Number
c) Insert Visual Elements
i. Insert at least Two (2) different images relevant to a hospital/ health care setting
ii. Insert a shape on slide 5 (Data Security) with a text label such as: “Important” or
“ALERT”
Printed By: Kapcherop Technical And Vocational College
iii. 09:48
Date: 07.07.2026 InsertPMa text box somewhere in the presentation with an additional note such as:
“Did You Know? 80% of hospitals now use EMRs”.
iv. Insert a SmartArt Graphic on slide 3
Printed By: Kapcherop Technical And Vocational College
d) Animations and Transitions Date: 07.07.2026 09:48 PM
i. Apply a different slide transition to slides 1,2, and 3
ii. Set transition duration to 1.00 second for all slides
Printed By: Kapcherop Technical And Vocational College
iii. Apply
Date: 07.07.2026 09:48an
PManimation to the title on Slide 1
iv. Apply an animation to the bullet points on Slide 3, so they appear one by one
Printed By: Kapcherop Technical And Vocational College
Date: 07.07.2026 09:48 PM
e) Review and saving
i. Add speaker notes to slide 4 with at least 3 sentences explaining what you would
Printed By: Kapcherop Technical And Vocational College
say to the hospital board. 09:48 PM
Date: 07.07.2026
Page 9 of 12
© 2026 TVET CDACC
Printed By: Kapcherop Technical And Vocational College
Date: 07.07.2026 09:48 PM
PRACTICAL ASSESSMENT 3 (4 HOURS) AND ORAL ASSESSMENT 3 (10 MINUTES)
Elements Covered
1. Manipulate graphic application.
Printed By: Kapcherop Technical And Vocational College
Tasks
Manipulate Graphic Application
Printed By: Kapcherop Technical And Vocational College
Milk Hospital needs a tri-fold brochure for new patients. The brochure should provide information
Date: 07.07.2026 09:48 PM
about the hospital’s services, doctors, and contact details.
Printed By: Kapcherop Technical And Vocational College
a) Set Up the Brochure Date: 07.07.2026 09:48 PM
c)Printed
Inside Left Panel
By: Kapcherop Technical And Vocational College
Page 10 of 12
© 2026 TVET CDACC
Printed By: Kapcherop Technical And Vocational College
Date: 07.07.2026 09:48 PM
On the inside right (Panel 4), include:
• Title: “Patient Testimonials”
• Add TwoPrinted
(2) short testimonials
By: Kapcherop from
Technical And fake patients:
Vocational College
g) By:
Printed Formatting
Kapcherop Technical And Vocational College
Ensure
Date: 07.07.2026 thePM
09:48 brochure has:
i. Consistent fonts throughout
ii. Bold headings
Printed By: Kapcherop Technical And Vocational College
iii. Color scheme matching the template
Date: 07.07.2026 09:48 PM
iv. Short and clear text
h) Saving and publication
Printed By: Kapcherop Technical And Vocational College
Date:i.07.07.2026
Save the publication
09:48 PM in your folder as: MilkHospital_Brochure.pub
ii. Export as: MilkHospital_Brochure.pdf Printed By: Kapcherop Technical And Vocational College
Date: 07.07.2026 09:48 PM
iii. Print the pdf and submit to the examiner.
1. Perform Online Collaboration
Printed By: Kapcherop Technical And Vocational College
This task tests yourDate:
ability to collaborate
07.07.2026 09:48 PM online and submit published work.
Page 11 of 12
© 2026 TVET CDACC
Printed By: Kapcherop Technical And Vocational College
Date: 07.07.2026 09:48 PM
v. Ensure that the classmate has permission to edit and add a comment regarding your
brochure
vi. Reply to Printed
their comments
By: Kapcherop Technical And Vocational College
viii. Update your Publisher file and re-upload to your Google drive folder.
Page 12 of 12