Practical Secretarial Exercises: I. Office Software
Practical Secretarial Exercises: I. Office Software
Answer the questions below in order to help Clara understand the profession.
I. Office software:
a) Identify these different software programs and explain their importance for a secretary
and
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
Et and
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
II- OFFICE EQUIPMENT
a) List the different parts of this landline telephone
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
----------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------
j) What is franking (postage stamping)? ---------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------
k) What are the steps a secretary should follow when receiving mail? ----------------------------
----------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------
l) What is bypass printing and why is it used? --------------------------------------------------------
----------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------
m) Name the different printers below and describe the distinguishing features of each.
.
Prints Names Particularity
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
n) Identify the different office supplies below and give their role
Tools Names Roles
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
List all the tools present on this sheet and give their roles
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
TELEPHONY WORKSHOP
You are an executive secretary at ALPHA CONSULTING (P.O. Box 1143 Yaoundé), a
company specializing in auditing and various consulting services.
Your company has been selected to organize a refresher seminar for the secretaries of GICAM.
The theme of the seminar is “Organizational Management and the Handling of Mail,
Documentation, and Archives.” It will take place from September 3 to September 6, 2023, at
the GICAM headquarters in Douala.
Your director, Mr. BEJEME, asks you to make a phone call to the Director of Human
Resources of GICAM, Mr. FOTIO, in order to confirm this working session.
Task:
PHOTOCOPYING WORKSHOP
SCANNER WORKSHOP
INTERNET WORKSHOP
You need a business card template to send to your clients in order to build loyalty to your company.
Your director wishes to organize a work visit to a firm that is more experienced than yours. For this purpose,
he assigns you part of the organization and asks you to propose a detailed plan of all the activities you will
carry out before, during, and after the visit.
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
Presentation model
Task: Fill in the table above.
Period Activity
Case 2
During the month of August 2023, “TOP MODEL” has a project to make three wedding dress designs.
Each design has a specific production time. The durations are as follows:
Cuttting
Straight dress Four – tiered dress Simple pleat dress
Operations
Workshop
Clients
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
Suppliers
Internal administration
The director asks you to implement an efficient filing system to facilitate document management. Below is
a list of documents received by the administrative department:
QUESTIONS
Global Distribution
Alpha Business
Express Market
Central Market
Beta Commerce
Delta Services
Office Pro
Africa Trade
Clients
Suppliers
Invoices
Purchase Orders
Correspondence
Contracts
i) Propose a logical organization of the filing cabinet.
j) Indicate the tools needed for this filing system (binders, dividers, folders, etc.).
k) Explain the advantages of a good filing system in a commercial company.
l) A client calls to request Invoice No. 208 dated March 10, 2025.
Explain the procedure for quickly retrieving this document from the archives.
Indicate the risks of poor filing in a company.
What does “CPU” stand for? Which of the following is an input device?
A. Central Processing Unit A. Monitor
B. Computer Personal Unit B. Printer
C. Central Program Utility C. Keyboard
D. Control Processing Unit D. Speaker
What is the main function of RAM? Which device is used to print documents?
A. Store data permanently A. Scanner
B. Execute programs B. Printer
C. Temporary storage of data C. Mouse
D. Control hardware D. Projector
What does “USB” stand for? Which of the following is NOT an operating
system?
A. Universal Serial Bus
A. Windows
B. United System Backup
B. Linux
C. User Service Box
C. Microsoft Word
D. Universal System Base
D. macOS
What is a file? Which device is used to scan documents?
A. A type of hardware A. Scanner
B. A collection of data stored on a computer B. Printer
C. A computer virus C. Monitor
D. A software D. Keyboard
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
PROBLEM SITUATION I
You work as an Executive Secretary at NOVA ÉNERGIE, which will participate in the Eco-Innovation Fair
in Yaoundé from October 10 to 12, 2025.
Your supervisor asks you to prepare all the necessary documentation for the event (invitations, registration
tracking, dashboard, and presentation of objectives).
TASK
Expected formatting:
Content:
Formatting requirements:
II – Spreadsheet (Excel)
Data to enter
Required tasks
Create:
Slides
1. Cover page
o Title: NOVA ÉNERGIE at the Eco-Innovation Fair
o Date and location
2. Company presentation
3. Our key figures for 2024
o Insert a chart from Excel (copied and pasted)
4. Objectives of our participation
o Bullet points (qualitative and commercial objectives)
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
Expected formatting
PROBLEM SITUATION II
You are a secretary at SOLARIX INDUSTRIE, a company specializing in solar panels. It has just signed a
strategic partnership with the German company Sonnentech GmbH.
Your manager asks you to prepare a professional communication file to present to management.
Content to include
Expected formatting
V – Spreadsheet (Excel)
Data to enter
Estimated Cost Difference
Expense Item Actual Cost (CFA) % Difference
(CFA) (CFA)
Feasibility study 7,800,000 8,123,500
Legal translation 1,625,500 1,495,000
Internal communication 780,000 617,500
Launch meeting 1,170,800 1,235,000
Required tasks
VI – Presentation (PowerPoint)
Cover Page
Main costs
Projected schedule
Table with key dates:
Conclusion
Quote or slogan
Contact details
Illustrative image
Formatting:
You work for the General Secretariat of the Administrative City of Douala.
An Inter-Company Forum will take place on September 21, 2025, at its premises.
As an executive secretary, you are responsible for preparing and distributing communication materials,
monitoring tables, and presentation tools.
TASK
VII – Word Processing (Word)
File: Convocation_Forum.docx
Create an official invitation letter intended for the directors of partner companies.
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
Content
Formatting
Confirmed
No. Company Sector Representative Name Email Phone No. of participants Remarks
(Y/N)
Tasks
Content
Page 1 (Cover):
Contact details
Layout requirements
3.
To file
Filing (classification)
Key word / indexing word
Archiving
2. Can documents be archived without being filed first? Justify your answer.
3. What is the importance of filing and archiving for a company or organization?
PART 3: CORRESPONDENCE
11. Do you think it is necessary for the receptionist to know all the company’s services and/or products
well?
a. Yes, absolutely
b. No, it is not their role
12. Which expression seems preferable?
a. Who is it from?
b. Who are you?
c. Does he know you?
d. Who should I announce?
13. Reception duties are mainly:
a. A duty station to maintain
b. An image of the company to uphold
c. Monitoring visitors
d. Providing calm for managers
14. What is meant by first-level reception?
a. The first reception is directing people
b. A high-quality reception
15. To obtain precise information, which type of question should preferably be used?
a. Open question
b. Closed question
16. What should be done first when dealing with an unhappy person?
a. Listen and show empathy
b. Stop them and ask them to calm down
c. Justify yourself and apologize
17. Identify and underline the two intruders among the elements of the 5P method in reception and
communication:
a. Precise
b. Prudent
c. Positive
d. Personalized
e. Preventive
f. Professional
g. Present
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
Heading (Rubric)
Directory / Index
Purge (removal of obsolete files)
1. True
2. False
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
b) AFNOR means:
1. AFNOR NF Z-48-001
2. AFNOR NF Z-44-001
3. AFNOR NF Z-48-004
1. Regularly
2. Rarely
3. Periodically
1. Thematic filing
2. Geographic filing
3. Idea-based filing
1. True
2. False
PART 2: CORRESPONDENCE
1. Define correspondence.
2. Present three characteristics of administrative correspondence.
3. Give four importance/advantages of correspondence.
1. Define:
Workstation
Ergonomics
Working conditions
2. Present two laws (principles) you know that can be effective tools for organizing your tasks. Give the
types of offices you know.
3. Present the different types of agendas (planners) you know.
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
PART 1: CORRESPONDENCE
SITUATION
You are the assistant to the director of the company MODORAMA S.A., located at 29 Garibaldi Street,
69006 Lyon.
The chief accountant, Mr. Claude LEMONIER, informs you that Mrs. Georgette DUCLAS, owner of the
TREND boutique, has not yet paid the invoice below.
Task
Mr. LEMONIER asks you to write a reminder letter including the following points:
Boutique TREND
Mrs. Georgette DUCLAS
15 Fontenoy Street
54000 NANCY
Date: 31/03/2008
Invoice No.: PL 54
Order Date: 15/03/2008
Customer No.: FE 34/A
Net
Ref. Description Qty Gross Unit Price Discount Total VAT
Amount
T-8913 Trouser suit 10 170.00 10% 1530.00 19% 1820.70
R-8956 Disco 70 dress 10 40.00 0% 400.00 19% 476.00
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
Name: ____________________
First name: ________________
Identification No.: __________
Complete the following table summarizing different telephone reception situations. Provide very precise
answers.
5. You do not understand the name of your caller. What do you do?
SITUATION 2
After completing your training at VTIL, you are recruited in a large company as the head of reception and
communication.
After starting your position, you notice that the reception service is not functioning properly.
The suggestion box is always full of customer complaints, and clients often call just to complain about the
quality of products, services, and staff.
Using this situation and your own knowledge, answer the following questions:
Reception
Reception service
Communication
Active listening
B – Questions
1. Define:
To classify
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
Indexing
Key word (main heading)
Numerical filing
Alphabetical filing
Alphanumeric filing
Numerical filing
Chronological filing
Geographical filing
Decimal filing
Ideological filing
PART 3: CORRESPONDENCE
1. Present three types of administrative correspondence with two examples for each type.
2. What is the difference between an administrative note, a report, minutes, and a summary report?
• American kindergarten
• The time news
• O.I.F
• Banks of Central African States
• Northern bakery
• General insurance
• Fishmongers
• Congelcam
• Eat to live National Company Sugar and dairy company
Annexe 1
You are employed at FONBAH SARL of NORD OUEST BP: 67749 BAMENDA, specialized in
the marketing of computers and computer accessories directed by Mr. ARREY Johnson. This
morning, your Manager gives you the order of the customer COM ITEMS BP: 456 LIMBE
annotated below and asks you to send him a notice of partial shipment.
Work to be undertaken:
Write the letter accompanying the partial shipment.
After the examination of the job applications received in your company, the application of Mrs.
NGOWOH ELISABETH BP: 210 Buea was retained. Your Director asks you to summon the
candidate for an interview on June 25, 2021 at 10 a.m. sharp.
Work to be done:
Write the invitation letter addressed to the successful candidate
1) Complete the table in Appendix 2.
Appendix 2
Appendix 3
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
Modem
USB Key
Printer
Scaner
Webcam
Monitor
Mouse
a. Water
b. A brush or air pump
c. A toothbrush and toothpaste
d. A dry clothesbrush
8- Tell us in a few lines how do you store your workstation at the end of the day
COMPREHENSIVE VOCATIONAL PAPER
You are a Bilingual Office Automation Secretary newly employed to assist the chief Executive Director of
the country Representative of GREEN FILED company Ltd, P.O. BOX 4555 Mora-Cameroon. You are
given the following files to work on.
(c) Indexing;
(d) Filing Cabinet;
(4) You have received the following documents from the main service of Green Field
Company.
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
APPERNDIX N°1
QUESTIONS:
PANTON Ltd
Panton Manufacturing Ltd
Panton Works/ Nkwen/ Bamenda
Tel: 237 322 567 894
Email : [Link]@[Link]
MEMO
TO: All supervisors
From: The Chief Executive
Date: 6th February 20
Subject: New Machinery
As part of the company’s expansion program, we are introducing RICHO Aficio MP C5000
and CanonScan machines which will increase productivity and reduce costs, thus making us
more competitive in overseas markets.
The new machinery will not any way affect job security, and there will be opportunities for
retraining for all production staff.
A full consultation process has taken place with the Union, and cooperation has been agreed in
installing and maintaining the new machines.
Please call a meeting of your team members on Wednesday morning at 9 :30 am to inform them
of these changes.
(b) Influence
(c) Learning new skills
(b) The Unity Palace is 20 kilometers away from the Hilton Hotel. He asks you to make necessary
arrangements on his behalf for him to arrive on time at the reception
APPENDIX N°2b :
RSVP Buffet
a) Internet;
b) Telephone;
c) Intranet;
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
2). As secretary to the chief Executive Director of the Country Representative GREEN FIELD
Bamenda- Cameroon, you are contacted by the organization telephonist whenever people wish to
speak to him on the telephone. Write down 3 methods how you will deal with these calls?
3). Name 2 points to be noted when taking telephone messages
4). When is it necessary to use the telephone alphabet? Give one precise example
(b) Suggest by writing a suitable pre- recoded message that will be listened by every caller who is
put though to such a machine when you were absent
SECTION B :
Here is a set of Professional Communication Multiple Choice Question (MCQs) focuses on
« Barriers of Communication »
ANSWER :
Explanation :_______________________________________________________________
___________________________________________________________________
ANSWER :
Explantation :_________________________________________________________________
______________________________________________________________________
ANSWER :
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
Explanation :__________________________________________________________________
______________________________________________________________________
4) Both encoding and decoding of message are influenced by our emotion. a) True, b) False
ANSEWER:
Explanation:__________________________________________________________________
______________________________________________________________________
ANSWER :
Explanation :
____________________________________________________________________________
____________________________________________________________
ANSWER :
EXPLANATION : __________________________________________________________
___________________________________________________________________
ANSWER :
Explanation : __________________________________________________________________
______________________________________________________________________
(a) When the sender transmits the message, (b) When the message enters the channel, (c) When the
message leaves the channels, (d) When the receiver understands the message.
ANSWER:
Explanation : __________________________________________________________________
10). Wich of these mus be avoided for effective communication. (a) Sharing of activity, (b) Listening, (c)
Ambiguity, (d) Politeness
ANSWER :
Explanation : _________________________________________________________________
______________________________________________________________________
(a) Clarity in language, (b) Listen poorly, (c)Home communication skills, (d) Adequate medium
ANSWER :
Explanation : ____________________________________________________________
_____________________________________________________________________
APPENDIX : N°4
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
QUESTIONS :
2-
3-
VOCATIONAL TRAINING INSTITUTE OF LEADERSHIP
CENTRE DE FORMATION PROFESSIONNELLE ET LANGUES ETRANGERES
Agrément n°379/MINEFOP/SG/DFOP/SDGSF/CSACD
4-
5-
6-
7-
10
11
12
13
14
15
2). There are numerous advantages of the email. It is personal and easy to use. Name three (03)
disadvantages of the email.
5). What is the meaning of C.c : and B.c.c : as used when writing emails using the Internet ?
6) . Name the devices used in APPENDIX N°4 used to communicate orally?