Page 1
CLASS : 10th (Secondary) Code No. 4224
Series : Sec. M/2019
Roll Roll No.
IT & ITES
National Skills Qualification Framework (NSQF)
Level – 2
[ Hindi and English Medium ]
(Only for Fresh/Re-appear Candidates)
Time allowed : 2.30 hours ] [ Maximum Marks : 60
• Ñi;k tk¡p dj ysa fd bl iz'u-i= esa eqfnzr i`"B 8 rFkk
iz'u 39 gSaA
Please make sure that the printed pages in this
question paper are 8 in number and it contains
39 questions.
• iz'u-i= esa nkfgus gkFk dh vksj fn;s x;s dksM uEcj dks Nk=
mÙkj-iqfLrdk ds eq[;-i`"B ij fy[ksaA
The Code No. on the right side of the question paper
should be written by the candidate on the front page
of the answer-book.
• Ñi;k iz'u dk mÙkj fy[kuk 'kq: djus ls igys] iz'u dk Øekad
vo'; fy[ksaA
Before beginning to answer a question, its Serial
Number must be written.
4224 P. T. O.
Page 2
(2) 4224
• mÙkj-iqfLrdk ds chp esa [kkyh iUuk@iUus u NksM+saA
Don’t leave blank page / pages in your answer-book.
• mÙkj-iqfLrdk ds vfrfjDr dksbZ vU; 'khV ugha feysxhA vr%
vko';drkuqlkj gh fy[ksa vkSj fy[kk mÙkj u dkVsaA
Except answer-book, no extra sheet will be given.
Write to the point and do not strike the written
answer.
• ijh{kkFkhZ viuk jksy ua0 iz'u-i= ij vo'; fy[ksaA
Candidates must write their Roll Number on the
question paper.
• Ñi;k iz'uksa dk mÙkj nsus ls iwoZ ;g lqfuf'pr dj ysa fd iz'u-i=
iw.kZ o lgh gS] ijh{kk ds mijkUr bl lEcU/k esa dksbZ Hkh nkok
Lohdkj ugha fd;k tk;sxkA
Before answering the questions, ensure that you
have been supplied the correct and complete
question paper, no claim in this regard, will be
entertained after examination.
uksV % (i) iz'u Øekad 1 ls 3 esa ls dksbZ nks iz'u djsaA 'ks"k lHkh
iz'u vfuok;Z gSaA
Attempt any two questions from question
numbers 1 to 3. Rest are compulsory.
Page 3
(3) 4224
(ii) izR;sd iz'u ds vad mlds lkeus fn, x, gSaA
Marks of each question are indicated against
them.
(iii) iz'uksa ds mÙkj muds vadkuqlkj nhft,A
Answer the questions according to their
marks.
1. ,d jks dks Nqikus vkSj dkWye dks Ýht+ djus ds pj.k fy[ksaA 6
Write steps to hide a row and freeze a column.
2. LizsM'khV esa fofHkUu O;w dk o.kZu dhft,A 6
Explain various views in Spreadsheet.
3. ,d MkWD;wesaV esa 'ksi vkSj flacy Mkyus ds pj.k fy[ksaA 6
Write steps to insert shapes and symbols to a
document.
4. ,d MkWD;wesaV esa vkWCtsDV Mkyus ds pj.k fy[ksaA 3
Write steps to insert object to a document.
5. fofHkUu odZ'khV ds lsy tksM+us ds pj.k fy[ksaA 3
Write steps to link cells from different
worksheet.
4224 P. T. O.
Page 4
(4) 4224
6. fdlh daMh'ku ds vk/kkj ij LçsM'khV esa MkVk fQYVj djus ds
pj.k fy[ksaA 3
Write steps to filter data in spreadsheet based
on some condition.
7. ,uhes'ku D;k gS \ ,d çstsUVs'ku esa ,uhes'ku tksM+us ds pj.k
fy[ksaA 3
What are Animations ? Write steps to add
animation to a presentation.
8. tuZy ,aVªh D;k gS \ blesa dkSu-ls dk;Z fjdkWMZ fd, tkrs gSa \
3
What is a Journal Entry ? What activities are
recorded in it ?
9. CREATE TABLE SQL LVsVeasV dk flaVsDl vkSj mnkgj.k
nhft,A 3
Give syntax and example of CREATE TABLE
SQL statement.
10. MkVkcsl dh ifjHkk"kk nhft,A 1
Define Database.
11. çkbejh ^dh* dh ifjHkk"kk nhft,A 1
Define Primary Key.
Page 5
(5) 4224
12. Viy D;k gS \ 1
What is Tuple ?
13. DBMS esa fdUgha nks ckbujh Vkbi ds uke crk,¡A 1
Name any two binary types in DBMS.
14. bUlVZ SQL LVsVesaV dk flaVsDl nhft,A 1
Give SQL syntax of insert statement.
15. DDL D;k gS \ 1
What is DDL ?
16. dSys.Mj lkW¶Vos;j dk mi;ksx D;k gS \ 1
What is the use of calendar software ?
17. dSys.Mj lkW¶Vos;j }kjk vikW;UVesaV dks dSls vyx fd;k tk
ldrk gS \ 1
How an appointment is categorized by calendar
software ?
18. Lihdj uksV~l dh fo'ks"krk,¡ D;k gksuh pkfg, \ 1
What should be the characteristics of speaker
notes ?
19. LykbM Vªkaft'ku D;k gS \ 1
What is slide transition ?
4224 P. T. O.
Page 6
(6) 4224
20. ckj pkVZ D;k gS \ 1
What is Bar Chart ?
21. XY pkVZ D;k gS \ 1
What is XY Chart ?
22. LçsM'khV ds ist ysvkmV vkWI'ku esa dkSu-ls vkWI'ku lsV fd;s tk
ldrs gSa \ 1
What options can be set using page layout
option in Spreadsheet ?
23. MkWD;wesaV VsEIysV D;k gS \ 1
What is a document template ?
24. dEI;wVj usVodZ dh ifjHkk"kk nhft,A 1
Define Computer Network.
25. baLVsaV eSlsftax ds Qhpj D;k gSa \ 1
What are features of instant messaging ?
26. fQYVj ^dh* dk mi;ksx D;k gS \ 1
What is the use of filter keys ?
27. MsfLØfIVo jkbfVax D;k gS \ 1
What is descriptive writing ?
Page 7
(7) 4224
28. ySaMekdZ D;k gS \ 1
What is Landmark ?
29. fofHkUu çdkj ds fjdkmaV D;k gSa \ 1
What are various types of recount ?
[ oLrqfu"B ç'u ]
[ Objective Type Questions ]
30. WAN dk iw.kZ :i ............. gSA 1
Full form of WAN is ............ .
31. DSL dk iw.kZ :i ............. gSA 1
Full form of DSL is ............ .
32. DML dk iw.kZ :i ............. gSA 1
Full form of DML is ............ .
(Functional English)
Fill in the blanks from the options given :
33. For dessert, ………….. plate of kheer will do. 1
(a) an (b) the
(c) a (d) none
4224 P. T. O.
Page 8
(8) 4224
34. Can we sit on ………….. upper floor ? 1
(a) a (b) an
(c) the (d) none
35. It was ………….. who wanted to go to the beach. 1
(a) he (b) himself
(c) myself (d) none
36. I now live ………….. in the heart of Delhi. 1
(a) comfortable (b) comfortably
(c) daily (d) none
37. Walk ………….. you reach the traffic point. 1
(a) till (b) before
(c) after (d) none
38. I haven't seen them ………….. last July. 1
(a) from (b) on
(c) since (d) none
39. Vikrant keeps borrowing money ………….. me. 1
(a) at (b) with
(c) on (d) from
s