PSC Computer Operator Practical Question Set 9

ATTEMPT ALL THE QUESTIONS
1.      You have a sample document provided. Type the Nepali Document as Provided.               [10]
g]kfnsf ;Gbe{df s'/f ubf{ ;g\ !(%) clw g]kfn /f0f zf;gsf] g]t[Tjdf lyof] . h'g a]nf g]kfndf 36gfqmdkl5 g]kfnL ;dfh ljb]zLx?sf nflu dxTjk"0f{ pj{/e"ld aGg k'Uof] . afx\o ;dks{ a9gfn] / b]z /f0fx?sf] lgoGq0faf6 d'Qm x'gfn] lj1fgx?aLr ;Dks{ / cWoogsf] cfbfgk|fg x'g yfNof] . ;g\ !(%) clw ;+:yfut ?kdf ;dfhzf:qLo dfgjzf:qLo b[li6sf]0faf6 s'g} ;}4flGts cfWff/df cWoog–cg';Gwfg x'g ;s]sf] lyPg\ . t/ s]xL ljb]zL ofqLx?, Jofkf/Lx?, wd{k|rf/sx?n] g]kfnL ;dfhsf] cWoog u/]sf lyP . tL cWoogx? ;"rgfx?sf ?kdf dfq ;Lldt lYP t/ klg To:tf ;|f\tx? ;+:s[lts , /fhlglts / cfly{s kIfx?sf] a'emfOsf nflu dxTjk"0f{ ;|f]t  ag]sf 5g\ . ;dfhzf:qLo÷dfgjzf:qLo 1fgsf b[li6sf]0fn] eg] g]kfnnfO{ Tolt gofF g} xf] eGg] tYo dfGg ;lsb}g . g]kfn k"jL{o bz{0faf6 a9L k|efljt 5 . k|flrgsfndf ljleGg wd{u|Gyx? h:tf] j]b, k'/f0f, pklgifb\, uLtf cflbsf] ljsf; ePsf] kfOG5 . log} wfld{s u|Gyx?df ;dfh / ;+:s[ltsf ljleGg kIfx?sf af/]df pNn]v ePsf] lyof] / 5 . To:;}af6 k|efljt tTsflng ;dfhsf] ljsf;qmd clxn];Dd klg lg/Gt/ rln/x]sf] 5 .

dg'sf] dg':d[lt, sf}l6Nosf] cy{zf:q, uf}td a'4sf] wfld{s bz{gdf klg ;dfh / ;+:s[ltsf af/]df k|z:q rrf{ ePsf] kfOG5 . o;kl5 klg lnR5lj tyf dNnsfndf klg ;dfh / ;+:s[ltaf/] ljleGg ;dflhs lgod tyf ;'wf/x? gePsf xf]OGg\ . dNnsfndf hol:ylt dNn, /fd zfxn] u/]sf ;'wf/x?nfO k|frLgsfnLg dfgjzf:qLo÷;dfhzf:qLo cWoogdf lgs} 7"nf] 5fk 5f8]sf 5g\ eGg] ul/G5 . To;n] gfsf/fTds k|efj kf/] klg ;dfhsf af/]df a'em\g tL 36gfx?n] 7"nf] of]ubfg lbPsf 5g\ . cf}Bf]lus qmflGt, la|l6; pklga]zafbsf] lj:tf/, kmfG;sf] /fHoqmflGt, a}l4s hfu/0f cflb sf/0fx?jf6 klZrdL b]zx?af o; laifosf] cWoog, cg';Gwfg ug]{ k|rng ljsf; ePsf] xf] . To;}sf] k|efj l9nf] g} eP klg g]kfndf klg kg{ uof] . ;g\ !(%) clw g]kfnL ;dfh / ;+:s[ltnfO{ cfwf/ agfP/ k|sflzt ul/Psf s[ltx? lgDgcg';f/ 5g\
o;/L ;g\ !(%) clw ;Lldt laifox?df dfq cWoog x'g ;s]sf] b]lvG5 h'g ;dfhzf:qLo / dfgjzf:qLo 1fgsf] clek|fon] ul/sf] lyPg . ;g\ !(%) kl5 g]kfn ;dfh;f:q / dfgjzf:qsf] ljsf;, cWoog, cg';GwfnnfO{v'Nnf ul/Psf] cj:yf, g]kfndf g} o; ;dfhsf] las;sf[ nflu ljleGg k|oTg / g]kfnL e'ld cWoogsfnf nflu lgs} pkof]lu / ;Defagf  ePsf] sf/0fn] ljljw txdf /x]/ ;dfhzf:q / dfgazf:qsf] cWoog cg';Gwfg  / ljsf; ePsf] kfOG5 . o;nfO{ lgDgcg';f/ lgDgcg';f/ pNn]v ug{ ;lsG5  .  

s'g} klg j}1fgLs 1fg xfl;n ug]{ k4ltx?dWo] tfls{s / cg'ejfTds klg xf] . j}1flgs 1fg Tof] 1fg xf] h'g cg'ejdf / ts{df cfwfl/t x'G5 . h;nfO{ lg/LIf0f tyf kl/If0f og{ ;lsG5 . ;dfhzf:qdf s'g} cWoog ljifo;Fu ;DalGwt ;dflhs 36gf Pj\ ljZn]Z0f ul/G5 / cjnf]sg u/]/ k|Kt tYox?nfO{ ts{sf cfwf/df ;dflhs l;4fGtsf] lgdf{0f ug{ ;lsG5 / ;dfhdf k"j{:yflkt l;4fGtnfO{ k/LIf0f ug{ klg ;lsG5 . ;dfhzf:q j}1flgs k4ltsf] pkof]u u/]/ tfls{s Pjd\ cg'ejfTds lj1fg elgPsf] xf] .
  
2.      You have a sample document provided. Type the English Document as Provided.               [5]

Much of the popularity of Visual Basic comes from its Integrated Development Environment or IDE for short. In theory, you can edit your Visual Basic programs using any editor, including the aged Notepad, but I never met a programmer insane enough to do that. In fact, the IDE gives you everything you need to create great applications, to write code for them, to test and fine-tune them, and, finally, to produce executable files. These files are independent of the environment and therefore can be delivered to customers for execution on their machines, even if they haven't installed Visual Basic. It contains the same BASIC like language that has been popular over the years and it includes all the necessary extension required to produce windows programs. Visual Basic is not just a languages, it’s an integrated development environment in which you can develop, run, test and debug your applications.                                                             
     
  Upon start up, Visual Basic 6.0 will display the following dialog box as shown in Figure 1.1 You can choose to start a new project, open an existing project or select a list of recently opened programs. A project is a collection of files that make up your application. There are various types of applications that can be created; however, we shall concentrate on creating Standard EXE programs (EXE means executable program).

Now, click on the Standard EXE icon to go into the VB programming environment. Visual Basic applications are very popular as front end to much client/Server database system like SQL/Server, Oracle, MS access etc. If the server is willing to accept e-mail, the client announces whom the e-mail is coming from and whom it is going to. If such a recipient exists at the destination, the server gives the client the go-ahead to send the message. 


3.      Perform the following task in MS Word.                                                                                 [10]
a)      Type the following paragraph correctly.    [3]
Within the Internet, e-mail is delivered by having the source machine establish a TCP connection to port 25 of the destination machine. Listening to this port is an e-mail daemon that speaks SMTP (Simple Mail Transfer Protocol). This daemon accepts incoming connections and copies messages from them into the appropriate mailboxes. If a message cannot be delivered, an error report containing the first part of the undeliverable message is returned to the sender.

SMTP is a simple ASCII protocol. After establishing the TCP connection to port 25, the sending machine, operating as the client, waits for the receiving machine, operating as the server, to talk first. The server starts by sending a line of text giving its identity and telling whether it is prepared to receive mail. If it is not, the client releases the connection and tries again later.

b)      Format the typed paragraph as following criteria.      [5]
·         Apply 16 pt font size with bold and italic for heading and center align it.
·         Apply paragraph spacing after 12 pt for all paragraph.
·         Apply line spacing 1.5 lines for third paragraph and justify it.
·         Insert footnote "two or more than two computers connected with or without cable" for the underlined word of first paragraph.
·         insert cross reference for the underlined word of second paragraph with first paragraph's footnote numbers.   
c)      Insert  a clip art right side of second paragraph, set the  text wrapping square and insert caption between clip art as "Figure 1: clip art picture" from reference.        [2]

4.      Calculate the Electricity using in MS excel.                                                                             [10]
Nepal Electricity Authority
Kathmandu Nepal
Miter No
Name
Previous Reading
Current Reading
Consumed Unit
Bill Amount
1
Neema
4520
4585


2
Gita
5800
5872


3
Mohan
3210
3400


4
Kamal
4500
4612


5
Anil
7800
8100


Calculate
·         Unit Consumed
·         Amount
Condition
Ø  If unit is less than or equal to 20 unit, RS 80
Ø  If unit is greater than 20 unit, amount 7.7 for extra unit
Ø  If unit is grater than 250, amount is 9.9 for extra unit.

5. Create the following tables in database with give fields enter at least 3 records.                     [4]
      Items: Item ID, Item Descrip, Item Price
      Purchase: PurID, PurDate, PurQty, Item ID
     
      Create inventory details Report to list Purchase date, Item Description, Purchase Quantity and Pirie  

               
6.      Perform the following task in MS PowerPoint.                                                                         [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.      Write HTML code to do following tasks.                                                                                   [3]
a.       Display the txt 'Generation of Computer' in heading 2 formats and insert a horizontal line below it.
b.      Create a ordered list. the list items should be First generation, Second Generation
c.       Insert an image whose that should  be 300 pixel and their height 200 Pixels.


 Best of Lock


Click there to download..............  Download PDF





PSC Computer Operator Practical Question Set 8



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

dfgj  Ps ;fdflhs k|f0fL xf] . pm k|flrg ;dob]lv g} ;d"xdf j:g], Pscfk;df ;DaGw :yflkt ug] , ;xof]i ;befk /fvg] cflb qmLofsnfkx? ug{ yfNof] . o;/L dfgjn] cfkm\gf cfjZostfnfO{ kl/k'lt{ ug}{ qmddf ljleGg lsl;dsf ;fdflhs ;DaGwsf] ljsf; u/L ;fdflhs ;+/rgfsf] lgd{g ug{ nfUof] . dfgjn] agfPsf] ;fdflhs ;DaGwx?sf] hfnf] g} ;fdfh xf]  . ;fdfhdf x'g] ;fdflhs cGt/;DaGw, ;fdflhs cGt/lqmof, ;fdflhs ;xof]u ug{ ;dfhdfb]vfkg]{ ljleGg k|ltof]lutfx?, ;ª\\3if{ cflbsf ;DaGwdf uxg ?kn] cWoog ug]{ zf:qnfO{ ;dfhzf:q elgG5 . cGo ;fdflhs zf:qx?n] ;dfhsf jf/]df cf–cfkm\g} b[li6sf]0fcg';f/ cWoog ub{5g\ . To;}n] ;dfhnfO{ lj:t[t ?kdf uxg l/sf af6 cWoog ug]{ zf:q g}  ;dfh zf:q xf] . ;dfhzf:qsf] cfkm\g} cWoog k4lt, If]q, ljifoj:t' ePsf] x'gfn] o;nfO{ :jtGq lj1fg klg elgG5 . h;n] ;dfhdf 36g] ljleGg 36gfx? tyf ;dflhs rfnrng, k/Dk/f, k|yf, nf]s/Llt, cflbsf cWoog ub{5 .

   ;dfhzf:q eg]sf] ;dfhsf] cWoog ug]{ zf"q xf] h;n] ;fdflhs hLjg, Jojxf/, ;d:of, cGt/lqmof, k|lqmof cflbsf] cWoog ub{5g\ . h;/L k|s[lts j1fgn\ k|s[lts 36gfx?sf] cWoog ub{5, /fhgLltzf:qn] ;/sf/, /fHo, lgod, sfg'g cflbsf] cWoog ub{5 To;} u/L ;dfhs 36gfx?sf] cWoog ug{sf] nflu ;dfhzf:qsf] k|of]u ul/G5 . h'g zJbsf] k|of]u ;j{k|yd ;g\  !*#* df k|mfG;sf bfz{lgs August Comtw n] /]sf x'g\ . To;}n] pgnfO{ ;dfhZf:qsf lktf  elgG5 . o;}n] ;fdflhs 36gf tyf tYox?sf] j}1flgs  vf]h ug{, Too;nfO{ ;dli6ut ?kdf a'emg, ;fdflhs 36gfx? ;dfhdf lsg / s;/L 36\b5g\ eGg]af/]df j}1flgs 9ª\un] JoVof tyf ljZn]if0f ug]{ zf:q g} ;dfhZf:q xf] .

pko{'Qm zAbx?sf] cy{af6 s] eGg ;lsg5 eg] ;dfhzfq eg]sf] ;dfhsf] lj1fg xf] jf ;dfhsf] cWoog ug]{ zf"q xf] . ;dfhdf b]lvg] ;fdflhs Jojxf/, ;fdlhs k|lqmof, ;fdflhs ;DaGw, ;dflhs cGt/lqmof cyjf ;fdflhs 36gf Pjd\ ;d:ofx?sf ;DaGwdf j}1flgs k4ltcg';f/ cWoog ug]{ zf:qnfO{ g} ;dfhzf:q elgG5 . csf]{ zAbdf eGg] xf] eg] ;dfh Pjd\ ;dflhs lhjg;Fu ;DalGwt ljljw 36gf Pjd\ ;d:ofx?sf ;DaGwdf uxg ?kdf cWoog ug]{ zf:qnfO{ g} ;dfhzf:q (Sociology) elgG5 .

s'g} klg ljz'4 lj1fgsf] d'Vo nIo eg]sf] 1fg cfh{g ug'{ xf] . o;n] k|fKt 1fgnfO{ o;/L, p;/L nfu' ug'{k5{  eg]/ Jojxfl/s ?kdf nfu' ub}{g . ;dfhzf:q ljleGg ;dflhs 36gfx?nfO{ j}1flgs cWoog u/]/ n1fg k|fKt ul/G5 . ;dfhzf:qn] s'g} sfd ug{sf nflu ;Nnfx dfq lbg] ub{5 t/ cfkm}F To; 1fgnfO{ Jojxf/df nfu' ug{ cufl8 a9b}g . pbfx/0fsf nflu ef}ltszf:qsf] k'nsf] lgdf{g ub}{g, /;fogzf:qLn] /f]lusf] pkrf/ ub}{g . h;/L cGo ljifox?n] ;ª\slnt 1fg Pjd\ l;4fGtsf] k|of]u Jojxfl/s  ?kdf nfu' ug]{ sfd ;dflhs sfo{ Pjd\ cGo ;dflhs lj1fg4f/f ul/G5 . To;}n] ;dfhzf:q Ps ljz'4 lj1fg xf] eg] Jojxfl/s lj1fg xf]Og .

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

Nepal’s planners have always faced an uphill task in ensuring energy self-sufficiency. The main issues in the past have been politics, the absence of a strategic vision, and policies that forced the country to suffer chronic power cuts. But the country has a new beginning with a new government that has promised political stability and economic prosperity.

The other challenge is an engineering one. Nepal may have one of the highest per capita hydropower potential, but most of the total 1044MW capacity today comes from run-of-river plants which depend on the water flow to turn turbines, and not from reservoirs that can store monsoon water for the dry season.

This means the country suffers from shortfalls in production during winter when peak demand is highest. There are also the daily peaks in the mornings and evenings that need to be covered by Nepal’s only storage dam, the 92MW Kulekhani cascade. Currently, Nepal meets nearly all its peak demand by importing coal-fired electricity from India.

Peak load demand is traditionally met with electricity from hydropower reservoirs or power plants burning fossil fuels. But as countries try to meet carbon emission targets, there is pressure to adopt solar and other renewable energy sources to meet gap.

The other advantage is that a project of this scale can be up and running within two years compared to the decade that it will take for Nepal’s next big reservoir projects like Budi Gandaki and Tanahu. Solar is also much more ecologically benign. There is a neat fit: Nepal’s peak demand is in winter when solar generation is highest because of cloudless skies.

3.      Perform the following Task in MS Word                                                                    [10]  
 a. Create a document with 9 pages and insert page numbers. The first page three pages should be numbers 1,2, 3; the next three pages should be numbered i, ii, iii  and the last three pages be a, b, c.
 b. Enter the following text and save the file name your symbol number and Apply 'pscpassword' as         password to protect it from unauthorized open.
        Hackers at convention test voting systems for bugs:

    LAS VEGAS (Reuters) - Def Con, one of the world’s largest security conventions, served as a laboratory for breaking into voting machines on Friday, extending its efforts to identify potential security flaws in technology that may be used in the November U.S. elections.
       Hackers will continue to probe the systems over the weekend in a bid to discover new vulnerabilities, which could be turned over to voting machine makers to fix.






The three-day Las Vegas-based “Voting Village” also aimed to expose security issues in digital poll books and memory-card readers
4.      Prepare the following task in excel.                                                                                          [10]
     a.       Enter the following data in your worksheet and save it as Excel_YourSymbolNumber in your              folder in desktop.       [2]
 Loan Amount
325000 
Loan Dura on in year 
Rate 

 Interest

         b.       Enter formula for the rate so that it will be 15% if loan Dura on is less than 4 years and loan                 Amount is more than one lacks, otherwise it should be 9%.     [2]
           c.      Calculate interest = loan amount × loan dura on × rate / 100          [1]
           d.       Change the value of loan Dura on as necessary to get 95000 in interest.                [2]
           e.      Apply thick line boarder around the table and single thin line for the inner lines.  [1]
           f.       Enter "Interest Calculation" as  header and set page number as the bottom center of page. [2]
     
     5. Perform the following task Using MS Access.                                                              [4]
       Field Name
       Field Type
       Size
      Validation rule
       Roll No
       Number
        2
        1-99
       S Name
       Text
       40

       Marks
       Number
       1.1
      0.0-4.0
            Condition:
a.       Who have failed (obtained marks<1.6)
b.      Who have scored more than 2.8

      6.      Perform the following task in MS PowerPoint.                                                                         [3]
a.       Create a presentation with three slides to introduce your village.      [1]
b.      Set up slide timing so that first slide will appear for 2 second, seconds slide for 3 seconds and third slide for 2 seconds.                   [2]

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

Roll No
Student Details
      Name
       Address
        1  
      Nigam Narayan
      Dhalkewar
        2
       Arjun Chaudhary
      Mahendranagar




-Best of Luck-



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