PSC Computer Operator Practical Question Set 7

ATTEMPT ALL THE QUESTIONS

1.      You have a sample document provided. Type the Nepali Document as Provided.               [10]

cfkm\gf] Joj;fosf] k|s[lt cg'¿k pknAw ;fwgx¿nfO{ ljefhg ug{kb{5 . sd{rf/Lx¿sf] sfd, k|s[ltcg'¿ksf] :yfgsf] k|aGw ug{', plrt :yfgdf plrt ljefu, sfo{sIfsf] Joj:yf ug{'kb{5 . sd{rf/L, u|fxs, cfuGt's cfjthfjt ug{ cfjZostfcg';f/sf] vfnL :yfgsf] k|aGw ldnfpg'kb{5 eg] cgfjos¿kdf vfnL 7fpFx¿ 5f]8\g' klg Tolt pko'Qm x'Fb}g . cfjZostfcg¿k sd{rf/Lx¿sf] ef}lt k"jf{wf/ klg pQm :yfgdf pknAw u/fpg'kg]{ x'G5 . sd{rf/Lsf nflu kmlg{ cfuGt'sx¿ a:g] :yfg, 6]lnkmf]g, sDKo'6/ cyjf cfjZostfcg'¿k cGo pks/0fx¿ klg h8fg ug{'kb{5 .

sfof{no ;+/rgfsf] ¿kf+sg ubf{ cfkm" dftxtsf sd{rf/Lsf] sfo{z}nL, u|fxsx¿sf] ;Gt'li6 cflb s'/fsf] plrt d"Nof+sg ug{ ;lsg] u/L Joj:yf ldnfpg'kb{5 . k|ToIf cg'udg x'g] u/L jf ljleGg ;"rgf k|ljlwsf] k|of]u, h:t} M ;L;Ll6eLsf] k|of]u u/L x/;Dej sd{rf/L tyf cfuGt'sx¿sf] lg/LIf0f tyf cfjZostfcg'¿k lgoGq0f ;+oGqsf] ljsf; ug{'kb{5 . t;y{ sfof{no ;+/rgfsf] ¿k/]vf tof/ ug]{ cj:yfdf g} cfjZos k|aGw ldnfpg'kg]{ x'G5 .

sfof{nosf] sfdsf] k|s[ltcg'¿k x/]s sd{rf/Lx¿n] lglZrt 9+un] cfˆgf] sfo{ ;Dkfbg ug{ kfpg'kb{5 . ljleGg ljefu / PsfOx¿sf] ;dGjo x'g' klg TolQs} h?/L x'G5 . sd{rf/L tyf ljleGg ljefux¿n] cf/fdbfoL tyf :jtGqk"j{s sfo{ ug{ kfPsf] v08df clwstd sfo{s'zntf b]vfpg] df}sf kfpFb5g\ eg] sd{rf/Lsf] pTkfbsTjdf klg ;sf/fTds k|efj kg{ hfG5 . t;y{ pknAw :yfgx¿sf] plrt ;dfof]hg tyf Joj:yfkgn] g} clws pTkfbsTj k|bfg ug]{ s'/fdf b'O{ dt x'g ;Sb}g .

sfof{nosf] sfo{;Dkfbgsf] lznlznfdf Ps ljefusf] csf]{ ljefu / Ps sd{rf/Lsf] csf]{ sd{rf/L;Fu ;dGjosf] cfjZostf kb{5 . x/]s sfo{x¿ Pscsf{;Fu ;DalGwt / kl/k"/s x'G5g\ . t;y{ o:tf] cGt/;~rf/ k|0ffnL r':t b'/:t ePdf dfq clwstd pTkfbsTjsf] ck]Iff ug{ ;lsG5 . ljleGg ;"rgf k|0ffnLsf] plrt Jojyfkg, plrt sfo{sIfsf] Joj:yfkg / ;"rgf cfbfgk|bfg z}nLdf ;/n / k|efjzfnL k4ltsf] ;dfof]hg ug{'kb{5 . o;/L ;DalGwt ljefu, sd{rf/Lx¿n] cfjZostfcg'¿k cfˆgf s'g} klg ;d:of, ;Gb]z, lgb]{zg cflb tTsfn} ;~rf/ ug{ ;Sb5g\ .

x/]s sd{rf/L tyf cfuGt'sx¿n] cfkm" /x]sf] sfof{no x/tj/n] ;'/lIft xf]; eGg] rfxG5g\ . t;y{ sfof{no ;+/rgf lgdf{0f ubf{ plrt ;'/Iffsf] k|aGw ldnfpg'kg]{ x'G5 . cfly{s lqmofsnfk x'g] sfof{nox?df cem ;'/Iffsf] k|aGw cToGt} r':t b'?:t x'g cfjZos 5 . t;y{ sfof{no;Fu ;DalGwt ;a}sf] ;'/Iffy{ ljleGg ;"rgf k|ljlw ;+oGq, ;'/Iff uf8{ cflbsf] plrt k|aGw ldnfpg'kb{5 .

cfjZostfcg'?k sd{rf/L tyf cfuGt'sx?sf] sfo{sf] uf]kgLotf x'g] u/L sfof{no ;+/rgfsf] lgdf{0f ug{' kb{5 . ;'/Iffsf] b[li6sf]0faf6 ;+j]bzLn sfo{x?sf nflu ljz]if sfo{sIfsf] k|aGw ldnfpg ;lsG5 . uf]Ko?kdf ug'{kg]{ sfo{;Dkfbgx? cGo sd{rf/L jf cfuGt'ssf] kx'Fraf6 leGb} /fVg ;Sg] u/L sfof{no ;+/rgf lgdf{0f ug'{kb{5 . ;+:yfsf] efjL sfo{of]hgf, /0fgLlt cflbh:tf sfo{x? ;a} sd{rf/Lx?nfO{ hfgsf/L lbg cfjZos gx'g ;Sb5 . t;y{ o:tf sfo{x?sf] uf]kgLotfdf ;hu / rgfvf] x'g'kb{5 .

2.      You have a sample document provided. Type the English Document as Provided.               [5]

FESTIVAL

Chhat:-

             The tradition of fasting is widely practiced in the Awadhi society scattered in and around Mid-western Terai  like Nawalparasi, Rupandehi, Kapilhastu,Banke, etc. women practice fasting more than men

                            Nagpanchami, Yam Dwitiya, Diwali,etc. are some of the important days for fasting in this society. There is a tradition of singing songs or rhymes or Bhajans or recting stories related to the respective God during such fastings. Women mostly fast to fulfill their wishes.For example:-an unmarried women fasts to get a good husband with a decent family and a married women fasts for good furtune, well-being.Prosperity and good health of her own ,her husband and children.

Diwali:

Occurs on the 15^thdays of kartik. It is celebrate in the memory of Ram’s returns to Ayodhya after fourteen years of exile.Laxmi, the goddess of wealth is worshipped at night . The doors and the gates of their houses are left open . Such is done to welcome the arrival and entrance o fLaxmi . The poor are given alms factory workers are given bonus. Merchants, traders and  shopkeepers change their account books on this occasion. The Hindu keep their doors open in honoron  of Laxmi to enter the houses . Houses are cieaned and white washed . They are decorated with pictures, toys and paper flowers. People paint and polish all wooden and iron things . It is a festival of three days. Diwali, Govardhan pooja  and Bhai pooja . people buy new clothes , ufensils and packets of candles or lamps. The children buy fire works  and crackers, sweets are sold in plenty. Sweets and  greeting cards are exchanged among friends, neighbours and relatives. Women prepare special food people lighten their houses with lamps , candles and electric bulbs.

3.      Make a list of your 5 best friends and use mail merge to send invitation card to all of the invitation card should be as follows:                                                                      [10]

4.      Prepare the sales record and commission for 5 salesmen:                                                      [10]

S.N.	Name	SalesAmount	Commission %	Commission Amount	Net Amount
1	Pramod	310000
2	Manoj	335000
3	Anil	285000
4	Ashok	175000
5	Rajib	245000

Condition:

If sales amount is less than 50000 than commission is 4%.

If sales amount is greater than 50000 and less than 150000, commission is 8 %.

If sales amount is greater than 150000 and less than 200000, commission is 10%.

If sales amount is greater than 200000 and less than 250000, commission is 12%.

If sales amount is greater than 250000 and less than 300000, commission is 15%.

If sales amount is greater than 300000, commission is 18%

5. Create a table and perform the following task Using MS Access.                                             [4]

                SID                 AutoNumber

            SName                        Text

            Maths              Number

            Science            Number          

            English            Number

a.       Add 5 student records

b.      Display Total, Percent, Result, and Division using Query.

c.       Create report of Result sheet

5.  Make 3 slides with your introduction and Academic Qualification, insert picture, insert current date and time in footer and slide number.                                                                    [3]

7.      Make the following table in HTML.                                                                                           [3]

DAYS	INCOME	EXPENSES
Sunday	5000	3000
Monday	7000	2700
Tuesday	4050	1900

-Best of Luck-



Click Here to Download....... Download PDF

PSC Computer Operator Practical Question Set 6

ATTEMPT ALL THE QUESTIONS

1.      You have a sample document provided. Type the Nepali Document as Provided.               [10]

;dfhdf j[4nfO{ af]emsf] ?kdf lnOG5 . nueu () k|ltzt j[4x? cfkmgf] 5f]/f ;Fu a:5 . 5f]/L k/fO{ 3/sL x'g egL pgLx?;Fu a:g rfxFb}gg\ t/ ToxL 5f]/fn] x]/rfx gu/]kl5 pgLx? cGoofsf] l;sf/ x'g k'U5 . :yfgLo laP=P8 kf; dgf]h s'zjfxfnfO{ tkfO{n] cfkmgf] kl/jf/df j[4sf] x]/rfx s;/L ug'{x'G5 egL ;f]Wbf a'af cfdf v]tdf sfd ug'x'G5 cfkm" cfof]usf] tof/Ldf 5' cfjZostf k/]sf] j]nf cfdf a'afn] g} ;xof]u ug'[x'G5 .

       v'Nnf k|ZgjnLaf6 s] :ki6 x'G5 eGg] oxfFsf $% k|ltzt j[4n] dfq cfkmgf kl/jf/df v';Lsf ;fy afrL/x]sf] 5g\ . To;}u/L j[4x?sf] cj:yfnfO{ x]bf{ pgLx?;Fu ;do latfpg] dflg;sf] klg cefj 5 . kmnM:j?k pgLx? klg PSnf]kgfaf6 u|l;t 5g\ .

j[4x?sf] ;+Vofdf j[l4 x'g' g]kfn dfq} xf]Og ls ljZjs} r'gf}tLsf] ?kdf /x]sf] 5 . csf]{ lt/ hGdb/ 3l6/x]sf] cj:yf 5  h;n] ubf{ cfl>t hg;Vof j[l4 x'g uO{ b]zsf] ;Dk"0f{ kIfdf gsf/fTds  k|efj kg{ hfG5 . kl5Nnf] cfof]hgfnfO{ x]bf{ @)^* ;fndf ^)± sf] aflif{s j[l4b/ #=)& k|ltzt /x]sf] 5 eg] ^%± sf] jflif{s j[l4b/ #=%) k|ltzt tyf &%± sf] jflif{s j[l4b/ #=&% k|ltzt /x]sf] 5 . h'g lbgk|lt lbg j[l4 x'b} uO/x]sf] 5 .

       ;dfhn] 5f]/fn] k|fyldstf lbPsf] sf/0f j[4x? 5f]/f ;Fu a:g rng 5 . oxfFsf nueu $) k|ltzt j[4x? cfwf k]6 vfP/ ;'Tg' k/]sf] cj:yf 5 eGf] $) k|ltztn] dfq plrt :jf:Yo ;]jf kfO/x]sf] 5g\ . oxfFsf nueu *& k|ltzt PSnf]kgsf] l;sf/ ePsf] 5g\ . To;}u/L nueu ^% k|ltzt j[4x? cfkmgf] k]6 kfNgsf] nflu * b]lv ( 306f sfd ul//xg' k/]sf] cj:yf 5 . w]/] h;f] j[4n] k"/fgf] n'uf kmfF6f] nufpg' kg]{ cj:yf b]lvPsf] 5 eg] nueut ^) k|ltzt cfˆg} 5f]/f a'xf/Laf6 lkl8t 5g\ .

g]kfnsf] j[4 cj:yfnfO{ x]bf{ cGo 7fpFsf] t'ngfdf oxfFsf] j[4x? jl9 lkl8t 5g\ . hf] j[4 ;/sf/L hflu/af6 cjsfz kfPsf] 5g\ pgsf] 5f]/f a'xf/Ln] ;DklQ kfpg] nf]en] x]/rfx ul//x]sf 5g\ eg] ;fw/0f j[4n] b'Mv kfO/x]sf] 5g\ . To:t} ul/a kl/jf/sf j[4x?n], 5f]/L dfq ePsf j[4x? cem} jl9 cGoodf k/]sf] 5g\ .

       g]kfn ;/sf/n] j[4x?sf] nflu eQf Joj:yf u/] tfklg ljleGg sf/0fn] eQf ;odf g kfpg] , sd kfpg] tyf eQf lng 6f9fF lng hfg' kg]{ / 306} nfOgdf a:g' kg]{ h:tf Jofks ;d:ofx? /x]sf] 5g\ . ljleGg ;+3 ;+:yfx?n] pgLx?sf] af/] cWoog u/] tfklg ;/sf/sf] :ki6 gLltsf] To;sf sfo{qmdx? c;kmn eO/x]sf] 5g\ . ljBfnLo kf7oqmddf afnaflnsf, dlxnf, blnt cflbsf] ;+/If0fsf] af/] pNn]v ul/Psf] eP tfklg j[4sf] ;+/If0fsf] nflu :ki6 pNn]v gul/psf] cj:yf 5 t;y{ j[4x?sf] o:tf] ;d:ofnfO{ ;dfwg ug{ :yfgLo lgsfo b]lv lnP/ /fli6«o ?kd} ljleGg sfo{qmdx? ;+rfng ug'{kg]{ cfhsf] 68sf/f] cfjZostf b]lvPsf] 5 o; cWoogaf6 .

2.      You have a sample document provided. Type the English Document as Provided.               [5]

Human beings are continuously engaged in some activity or other in order to satisfy their unlimited wants. Every day we come across the word ‘business’ or ‘businessman’ directly or indirectly. Business has become essential part of modern world. However, Business is an economic activity, which is related with continuous and regular production and distribution of goods and services for satisfying human wants.

All of us need food, clothing and shelter. These needs are the basic human needs. We also have many other household needs that are to be satisfied in our daily lives. We meet these requirements from the shopkeeper. The shopkeeper gets from wholesaler. The wholesaler gets from manufacturers. The shopkeeper, the wholesaler, the manufacturer are doing business and therefore they are called as Businessman.

In short, all those economic activities which are concerned with earning profit and creating wealth through the production and exchange of goods and services is called business.

The economy led by market is called market economy. In this economy, all economic activities are performed by private sectors. The government doesn’t interfere in the activities of people and business organizations. There is personal freedom to the people and business organization. The government just facilitates the private sectors by providing security, maintaining peace and justice, establishing good diplomatic relationships with other countries and so on. That’s why government is called facilitator rather than doer. It does not make the investment. The investment is made only by private sector. Production, utilization of resources, pricing, employment etc are according to market demand and supply of goods and services. The demand and supply are called market forces.

3.      Prepare the following tasks in MS Word which are given bellows:                          [10]

a.       Insert the image from picture. Wrap the text to the image.

b.      Insert image on the footer.

c.       Inset boarder and shading on paragraph.

d.      Make numbered list as follows:

Information of Hardware and Software

1.      Hardware

a.       Mouse

b.      Keyboard

c.       Monitor

d.      CPU

2.      Software

a.       MS Office

b.      Photoshop

c.       PageMaker

d.      CorelDraw

e.       Insert table as follow:

Tribhuwan University, Kirtipur
2075/04/04		Exam Schedule	2075/05/15
A	A		A	B

4.      Create the following table and calculate 'Final Grade' as the average of four exams. Award letter grade A, B, C or D based on final Grade is above 90, 70, 60, or below 60 respectively. Alphabetize the list. Plot the bar chart of final grade.                                                            [10]

Name	Exam 1	Exam 2	Exam 3	Final	Final Grade	Letter Grade
Nigam	80	85	95	93
Amit	76	60	83	70
Basant	88	86	80	81
Pramod	91	86	89	84
Manoj	96	92	90	93
Anil	86	87	80	92
Ashok	76	81	88	79
Rajib	75	70	79	83

5. Create a table using following field and make a suitable primary key.                                     [4]

Field (Data Type) Size

EmpID (Number)

EmpName (Text) 30

Address (Text) 50

Phone Number (number)

Email Address (Text) 40

a.        Insert any five records to the given table.

b.        Create a query EmpName in ascending order

c.        Create suitable report for the records you entered. 

6.  Prepare a given presentation as given follows:                                                                           [3]

            First Slide: Title Slide

            Second Slide: Insert a table

            Third Slide: Insert a chart based on the table on previous slide.

            Apply animation to each object on every slide and transition to make the presentation automatic

7.      Create a HTML web page for a College with three frames. The first frames. The frame will be horizontal on top displaying the name and address of college. Second frame which is vertical on left will list the available faculties. The third frame will be the right of second Frame and will display the introduction to the college. Save your webpage in College folder inside your working folder.                                                                                                          [3]

-Best of Luck-



Click Here to Download........ Download PDF