Basic Clerical Works (Level – I)

Project 1 – Word Processing

In this part of the assessment, you are expected to demonstrate the following competencies when
answering the questions:

 Operate a Personal Computer

 Develop Keyboard Skills

Task 1 – Create a folder on the Desktop with BCW (your name)and create 2 sub-folders by the name
Ms-Word & Ms-Excel.
Task 2 - Type the following paragraph on your computer and save it as Project 1under the Ms-Word
sub-folder.
Work Attitude Behavior
Attitude to me refers to the ‘feel’ part of your work. It relates to how you feel
about your work and your approach towards work. Hence, work attitude behavior is
intangible. You cannot see it. Your colleagues cannot see it. But people can feel it.
People whom you work with can feel your work attitude behavior.
They can feel it if you carry out your tasks with pride. They can feel whether you
belief in your work or not. They know if you have passion in your work.
These positive attitudes at work are a ‘subconscious’ transfer of feelings.
It is important to cultivate a positive attitude at work from early on in their
career. It is something that is from within and it takes time to cultivate.

Task 3 - Copy the first paragraph & paste it between the 2nd and 3rd paragraphs three times
Task 4 - Change its font style into “Century Gothic”
Task 5 - Divide this paragraph into 3 columns make a line between them
Task 6 - Change the third paragraph font style into “Times New Roman”
Task 7 - Make the font size of the title “18” and centered
Task 8 - Set the font size of the paragraphs to “14” and justified
Task 9 - Set the left and right margins to 0.3 inch
Task 10- set a drop cap
Task 11- set a water mark name it by “never give up”.
PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 1
 STANDARD MEMO HEADING

Though the format for a memo may vary from one organization to another, the standard heading
consists of a series of clearly labeled lines that convey key information about the memo’s contents and
its distribution. The following are standard elements of a memo header:

Date: The date on which the memo is distributed

To: The person(s) to whom it is primarily addressed

(sometimes with job title)

cc: Name(s) of anyone else who receives a copy

(sometimes with job title)

From: Name of the writer, usually followed by his/her

handwritten initials (sometimes with job title)

Subject: or Re: Concise statement of the memo’s topic

INTEROFFICE MEMO
Used to send & receive messages between offices or departments in the same
organization. It is also called: interoffice letter, interoffice memorandum, internal
memo, internal letter, internal memorandum, memorandum or simply memo.

2*2 memo Two-by-two (2 X 2)

Name of Organization Parts of memo
Interoffice Memo
1.name of organization
To: xxxxxxxxx Date: xx/xx/xx EC
From: xxxxxxx Subject: xxxxxxxxxxxx

Xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
2. The title: “Interoffice Memo”

/cc 1) 3. The sub-titles: To, From, Date & Subject

PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 2

4.body
5. Writers identification
1) Three-by-one (3 X 1)

Name of Organization
Interoffice Memo

To: xxxxxxxxxxxxxxx Date: xx/xx/xx EC

From: xxxxxxxxxxxxxxx
Subject: xxxxxxxxxxxx

Xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

/cc

Four by zero memo(4*0)memo

Name of Organization
Interoffice Memo

To: xxxxxxxxxxxxxxx
Date: xx/xx/xx EC
From: xxxxxxxxxxxxxxx
Subject: xxxxxxxxxxxx

Xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

/cc

PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 3

Project 1 - Interoffice Memorandum
Task 1 - Prepare the following Interoffice Memorandum using a three by one style and save it by the name
Memo under Business folder.
ABC car Rent, a car rent company in Addis Ababa wants to launch a very special TV advertisement.
Hence, the manager of the company requests the marketing department to design advertisement
specification. A page document about the specification has been attached to this memo. The copy of
this memo is being given to the sales supervisor of the company

Project 2 - Interoffice Memorandum

Task 1 - Prepare the following Interoffice Memorandum using a four by zero style and save it by the name
Memo under National folder.
The memo is prepared by Dr. Michael Hagos (Managing Director), to W/ro Tigist Arega (Marketing
Department). Use the current Gregorian date for the memo.
The managing director of XYZ Company has written a letter about salary increment of
each employee in the marketing department. The managing director has attached a 3 page
detail about the increment.
Project 3-Interoffice Memorandum
Task 1 - Prepare the following Interoffice Memorandum using a two by two style and save it by the name
Memorandum under water folder.
MrAwolBeshir requests data from student service about the number of newly entry students
of 2006 E.C. MrAwol need the data timely before end of current semester. Use 2 page
attachments.

PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 4

Sections of a Business Letter
Each section of your letter should adhere to the appropriate format, starting with your contact
information and that of your recipient’s; salutation; the body of the letter; closing; and finally,
your signature.

Your Contact Information

 Your Name
 Your Job Title
 Your Company
 Your Address
 City, State Zip Code
 Your Phone Number
 Your Email Address

The Date
 The date you're penning the correspondence

Recipient’s Contact Information

 Their Name
 Their Title
 Their Company
 The Company’s Address
 City, State Zip Code

The Salutation
 Use "To Whom It May Concern," if you’re unsure specifically whom you’re addressing.

PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 5

  Use the formal salutation “Dear Mr./Ms./Dr. [Last Name],” if you do not know the
recipient.
 Use “Dear [First Name],” only if you have an informal relationship with the recipient.

The Body
 Use single-spaced lines with an added space between each paragraph, after the
salutation, and above the closing.
 Left justify your letter (against the left margin).

Make the purpose of your letter clear through simple and targeted language, keeping the
opening paragraph brief. You can start with, “I am writing in reference to…” and from there,
communicate only what you need to say.

The subsequent paragraphs should include information that gives your reader a full
understanding of your objective(s) but avoid meandering sentences and needlessly long words.
Again, keep it concise to sustain their attention.

If your intent is to persuade the recipient in some way, whether it's to invest money, give you a
reference, hire you, partner with you, or fix an issue, create a compelling case for your cause. If,
for example, you want the reader to sponsor a charity event, identify any overlap with their
company’s philanthropic goals. Convince the reader that helping you would be mutually
beneficial, and you will increase your chances of winning their support.

Closing Salutation
Keep your closing paragraph to two sentences. Simply reiterate your reason for writing and
thank the reader for considering your request. Some good options for your closing include:
 Respectfully yours
 Yours sincerely
 Cordially
 Respectfully
If your letter is less formal, consider using:

 All the best

 Best
 Thank you
PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 6
  Regards

Your Signature
Write your signature just beneath your closing and leave four single spaces between your closing
and your typed full name, title, phone number, email address, and any other contact information
you want to include. Use the format below:
Your handwritten signature

Typed full name

Title

A good rule of thumb is to proofread your correspondence twice and then have a colleague
review it to ensure nothing was missed.

PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 7

Business Letter Example
Business Letter Example (Text Version)
Your Name
Your Job Title
Your Company
Your Address
City, State Zip Code
Your Phone Number
Your Email Address

Date

Recipient Name
Recipient Title
Recipient Company
Recipient’s Company’s Address
City, State Zip Code

Dear Mr./Ms. Last Name,

I would like to invite you to attend our upcoming Liberal Arts department job networking event. The
event will be held on the afternoon of February 1, 20XX. We wish to provide our graduating seniors with an
opportunity to meet business leaders in the area who may be looking for new hires who hold degrees in the
Liberal Arts.

The event will be held at the Cox Student Center at Northern State University and will last about two to
three hours. If you have an interest in attending or sending a company representative to meet with our
students, please let me know at your earliest convenience and I can reserve a table for you.

Thank for your time and I hope to hear from you soon.

Respectfully,

Your signature (hard copy letter)

Your Typed Name

Your Job Title

If you're sending an email letter, your signature will be slightly different. Rather than including your contact
information in the heading of the letter, list it below your signature. For example:

PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 8

 Project III – Interoffice Memorandum

 Prepare the following interoffice memorandum using the two by twostyle. The
memo is sent to Prof. YalemtsehayTekola from Dr. AregaYitnaw (Loan
Department Head). The copies of this memo given to the Chairman of the
P.L.C. Use the date March 25, 2016 for the memo. Save your memo by the
name Memo under the Letter folder.
The LoanDepartment hasstudied about the price of construction materials in the city
(Addis Ababa)by conducting different researches. Hence, wants to inform the General

PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 9

Manager (Prof. Yalemtsehay Tekola) that there should be a better improved loan that
will help the capacity building offices to purchase items.

BUSINESS LETTER
An external communication medium used to send & receive messages
between different organizations.Business letters are used for different
purposes; like placing orders, making inquiries, making credit request,
requesting claims & adjustment, to apologize for a wrong or simply to
convey goodwill, etc.

Parts of Letter
A business letter has different parts and categorized into two:
A. Basic parts
1. Letter head (sender’s address)
2. Date line
3. Reference number
4. Inside address (receiver’s address)
5. Salutation (dear sir, madam)
6. Subject
7. Body

PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 10

 8. Complementary close (sincerely)
9. Signer’s identification (

B. Supplemental parts
1. Personal or confidential notation
2. Attention line
3. Signature
4. Writer’s identification( eg manager)
5. Enclosure (attachment)
6. Copy notation (No of copy distributed)
7. Post script (please kindly response immediately)
Business Letter Styles
A business letter can be prepared in many different styles; the
most common of these being three

PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 11

 COC BASED QUESTIONS (OPC,DEVELOP KEYBOARD AND EXCEL 2012
E.C

1) Full block
xxxx
xxxx 1

xxxxx 2

xxxxx 3

xxxxx
4
xxxxx
xxxxx
5
xxxxxxx
6
7
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxx

xxxxxx
8

xxxxxx
xxxxxx 9

2) Modified block
3)
xxxx
xxxx 1

xxxxx 2

xxxxx 3

xxxxx 4
xxxxx
5
xxxxx
6
xxxxxxx
7
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxx
8
xxxxxx

9
xxxxxx
xxxxxx

PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 12

 COC BASED QUESTIONS (OPC,DEVELOP KEYBOARD AND EXCEL 2012
E.C

3. Modified block with indents (Semi-block

xxxx
xxxx 1

xxxxx
2
xxxxx
3
xxxxx
xxxxx
4

xxxxx
5
xxxxxxx
6
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
7
xxxxxx

xxxxxx
8
xxxxxx

Project 1– Business letter

Prepare a business letter using a full block letter style.
Today’s date; Ref. No. Bus/001/15; the letter is written by: GASHEM
COMMUNICATIONS SKILLS TRAINING CENTER, P.O.Box 2961, Addis Ababa,
Ethiopia; Written to JUPITER TRADING, P.O.Box 1198, Addis Ababa, Ethiopia;
Dear Sir/Madam; Subject: Letter of Enquiry; With respect; TizitaNegash, General
Manager.

PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 13

 COC BASED QUESTIONS (OPC,DEVELOP KEYBOARD AND EXCEL 2012
E.C

We are planning to launch practical computer training programmed in the coming

academic year. We, thus require 30 most up-to-date personal computers for the training
program.
Could you, therefore, supply these items on the usual trade terms? We hope to hear from
you at your earliest convenience.

Project 2 – Spreadsheet
In this part of the assessment you are expected to demonstrate the following
competencies when answering the questions:
 Create and Use Spreadsheets
Task 1 - Copy the data below on spreadsheet software.

Industry
No Assets Liabilities Capital Income Expense
Title
1 Mobile 2,500 900
2 Shoes 5,850 1,500
3 transport 10,400 4,900
4 Leather 3,000 1,250
5 Paper 7,650 3,000
Total
Average
Minimum
Maximum

PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 14

 COC BASED QUESTIONS (OPC,DEVELOP KEYBOARD AND EXCEL 2012
E.C

Task 2 - Calculate according the following formula:

1.1.1. Capital = Asset – Liability
1.1.2. Income = 35% of Assets
1.1.3. Expense = 25% of Liabilities
Task 3 - Calculate the total, average, minimum, and maximum results
Task 4 - Apply the appropriate formatting
Task 5 - Set the digits to one decimal places in the ‘Income’ and
‘Expense’ columns
Task 6 - Produce the following chart
a) Chart Title: “FINANCIAL DATA OF 5 INDUSTRIES”
b) Horizontal axis: “Accounting Information”
c) Vertical axis: “Dollar Value”
d) Rename the tab for the chart as “Conical Chart”

PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 15

 COC BASED QUESTIONS (OPC,DEVELOP KEYBOARD AND EXCEL 2012
E.C

e) Task 7 - Save your work using file name Project 2 under the Ms-
Excel sub-folder.
Project 7. Perform the following illustration in Microsoft excel.

No. Name of the Assets Liabilities Capital Revenue Expenditure

company

1. DELL 3409 1000

2. IBM 8677 2000

3. TOSHIBA 5674 1500

4. COMPAQ 4000 1000

5. HP 6540 2000

Total

Average

Maximum

Minimum

Task 1. Calculate Capital =Asset-Liabilities

Task 2.Calculate Revenue = 30% of Assets
Task 3.Calculate Expenditure = 15% of Liabilities
Task 4. Calculate the Total, Average, Minimum, and Maximum results
Task 5.Save your file on local disk D by the file name computer technology.

PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 16

 COC BASED QUESTIONS (OPC,DEVELOP KEYBOARD AND EXCEL 2012
E.C

Project 2 – Spreadsheet
In this part of the assessment you are expected to demonstrate the following competencies when answering the
questions:
 Create and Use Spreadsheets
Task 1 - Copy the data below on spreadsheet software.

company total vat net

No Assets Liabilities Capital Income Expense
name
1 GAGE COLLEGE 2,500 900
2 ADMASS 5,850 1,500
UNIVERSITY
3 RIFT VALLEY 10,400 4,900
4 GREAT 3,000 1,250
COLLEGE
5 SELECT 7,650 3,000
COLLEGE
Average
Minimum
Maximum

Task 2 - Calculate according the following formula:

1.1.4. Capital = Asset – Liability
1.1.5. Income = 25% of Assets
1.1.6. Expense = 15% of Liabilities
1.1.7. VAT=45%of total price
1.1.8. NET=30%of capital
Task 3 - Calculate the total, average, minimum, and maximum results
Task 4 - Apply the appropriate formatting

Task 5 - Produce the following chart

PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 17

 COC BASED QUESTIONS (OPC,DEVELOP KEYBOARD AND EXCEL 2012
E.C
f) Independent chart
g) Chart Title: “FINANCIAL DATA OF 5 company”
h) Horizontal axis: “Accounting Information”
i)Vertical axis: “birr Value”
j) Rename the tab for the chart as “Cone Chart”
k) Task 6- Save your work using file name Project 2 under the Ms-Excel sub-folder.

Task 1 - Copy the data below on spreadsheet software.

Student
No mathes english phy bio total Average grade rank comment
name
1 yonas 85 98 84 78
2 Alemu 65 75 58 94
3 Abebe 75 65 87 88
4 heran 77 84 78 85
5 hellen 99 51 45 98

THANK YOU FOR YOUR TIME AND KIND CONSIDERATION!!!

END

PREPARED BY:- YONAS ABEBE( MECHANICAL ENGINEER) Page 18