Public Service Commission
Computer Operator
Practical Set-1
Digital Nepl69
Create a folder named as Digital Nepal69_YourSymbol No. Use to save all your files inside this folder as needed.
WORD-PROCESSING
1) Design a thank you letter to your teachers and
relatives giving them credit of your success on Computer Operator
Examination 2078. Prepare letters for every individual using the information
below: (10)
a) Set the pages as Aqua Accent Page
color.
b) Page border should be double lined Showed on
Red Accent 2 color as darker as your wish.
c) Set the watermark as your full name in any
Devnagari Font having any one font style.
|
S.N. |
Name |
Last Name |
Address |
Relation |
|
1 |
Poonam |
Sharma |
Jaleshwar-2, Mahottari |
Teacher |
|
2 |
Prem |
Basnet |
Pokhara-5, Kaski |
Teacher |
|
3 |
Ram |
Bahadur |
Janakpur-12,Dhanusha |
Uncle |
|
4 |
Raju |
Karki |
Kirtipur-2, Kathmandu |
Friend |
|
5 |
Dipak |
Bhujel |
Lumbini-4, Lumbini |
Friend |
SPREADSHEET
2)
Design & calculate a Vat Bill of "The Mithila Resort" where the following items has
been served to you.
a) Save your sheet as
excel binary file.
b) Insert a appropriate chart to show the proper
info graphic of the bill.
c) Set currency data format on appropriate field.
|
S.N. |
Item
Name |
Rate |
Quantity |
Service
Charge |
VAT |
Disscount |
Total |
|
1. |
Momo |
80 |
6 |
7% |
13% |
5% |
|
|
2. |
Chowmin |
100 |
5 |
|
|||
|
3. |
Pizza |
250 |
12 |
|
|||
|
4. |
Burger |
120 |
9 |
|
DATABASE
3) Create the table
"Client" and entry the following records. Create a query to show only
those Clients details who have more than Rs 5000 due amount..
a) Set the Client Name Field's first letter should be in
capital.
b) Set client history Field as '...Years' when
you type the number it automatically output 'Years'.
|
S.N. |
Client Name |
Package Type |
Location |
Client History |
Due Ammount |
|
1. |
Sagar
Upaddhay |
128
Kbps |
Jaleshwar |
4
years |
2600 |
|
2. |
Bipana
Dhakal |
256 Kbps |
Suga |
3 years |
3500 |
|
3. |
Rajesh
Khanal |
5
Mbps |
Matihani |
5 years |
3000 |
|
4. |
Sweta
Bhatta |
10
Mbps |
Sari |
2 years |
6000 |
|
5. |
Laxmi
Shrestha |
20
Mbps |
Bajrahi |
6 years |
5500 |
PRESENTATION
4) Create a presentation
having 3 slides where first slide is for info about your institute, second for
the list of founding members of your institute and the last one for the
service you provide. Set your preferred transaction and design.
HTML
5) Make an html page which shows your own
bio-data.
*** Digital Nepal69 ***