Page 1
Karnataka School Examination and Assessment Board
QUESTION
PAPERS
2024
Page 2
CCE RF(A)/666/061
Question Paper Serial No.
A
CÈÉí¨Ü PÜñܤÄÔ
Joár ÊÜáá©ÅñÜ ±ÜâoWÜÙÜ ÓÜíTæÂ : 12 ]
Total No. of Printed Pages : 12 ]
Joár ±ÜÅÍæ°WÜÙÜ ÓÜíTæÂ : 34 ]
CCE RF
Revised Syllabus
Total No. of Questions : 34 ]
ÓÜíPæàñÜ ÓÜíTæÂ : 86-E K NSQF LEVEL-2
Code No. : 86-E K
ËÐÜ¿á ÊÜÞ×£ ñÜíñÜÅþÝ®Ü
Subject : Information Technology
PܮܰvÜ ÊÜáñÜᤠCíXÉÐ… ÊÜÞ«ÜÂÊÜá / Kannada and English Medium
TEAR HERE TO OPEN THE QUESTION PAPER
ÍÝÇÝ A»Ü¦ì / Regular Fresh
©®ÝíPÜ 04. 04. 2024 ] [ Date : 04. 04. 2024
±ÜÅÍæ°±Ü£ÅPæ¿á®Üá° ñæÃæ¿áÆá CÈÉ PÜñܤÄÔ
ÓÜÊÜá¿á ¸æÙÜWæY 10-15 Äí¨Ü ÊÜá«ÝÂÖܰ 12-30 ÃÜÊÜÃæWæ ] [ Time : 10-15 A.M. to 12-30 P.M.
WÜÄÐÜu AíPÜWÜÙÜá 60 ] [ Max. Marks : 60
±ÜÄàûݦìWÝX ÓÝÊÜޮܠÓÜãaÜ®Wæ ÙÜ Üá / General Instructions to the Candidate :
04. 04. 2024
Cut here/CÈÉ PÜñܤÄÔ
1. D ±ÜÅÍæ°±Ü£ÅPæ¿áá Joár 34 ±ÜÅÍæ°WÜÙÜ®Üá° Öæãí©¨æ.
This Question Paper consists of 34 questions.
2. D ±ÜÅÍæ°±Ü£ÅPæ¿á®Üá° ×ÊÜáá¾S hÝPæp… ÊÜáãÆPÜ ÊæãÖÜÃÜá ÔàÇ… ÊÜÞvÜÇÝX¨æ. ±ÜÄàûæ
±ÝÅÃÜí»ÜÊÝWÜáÊÜ ÓÜÊÜá¿áPæR ¯ÊÜá¾ ±ÜÅÍæ°±Ü£ÅPæ¿á ŸÆŸ© ±ÝÍÜÌìÊÜ®Üá° PÜñܤÄÔ ¸Ý|ÊÜ®Üá° A®ÜáÓÜÄÔ ,
GvÜŸ© ±ÝÍÜÌìÊÜ®Üá° PÜñܤÄÓܸæàw. ±ÜÅÍæ°±Ü£ÅPæ¿áÈÉ GÇÝÉ ±ÜâoWÜÙÜá CÊæÁáà Gí¨Üá ±ÜÄàüÔPæãÚÛ.
This question paper has been sealed by reverse jacket. You have to cut on the
right side to open the paper at the time of commencement of the examination
( Follow the arrow ). Do not cut the left side to open the paper. Check
whether all the pages of the question paper are intact.
3. ±ÜÅÍæ°WÜÚWæ PæãqrÃÜáÊÜ ÓÜãaÜ®æWÜÙÜ®Üá° ±ÝÈÔ.
Follow the instructions given against the questions.
4. ŸÆ »ÝWܨÜÈÉ PæãqrÃÜáÊÜ AíQWÜÙÜá ±ÜÅÍæ°WÜÚXÃÜáÊÜ ±Üä|ì AíPÜWÜÙÜ®Üá° ñæãàÄÓÜáñÜ¤Êæ.
Figures in the right hand margin indicate maximum marks for the question.
5. ±ÜÅÍæ°±Ü£ÅPæ¿á®Üá° K©PæãÙÜÛÆá 15 ¯ËáÐÜWÜÙÜ PÝÇÝÊÜPÝÍÜÊÜâ ÓæàĨÜíñæ, EñܤÄÓÜÆá
¯WÜ©±ÜwÓÜÇÝ¨Ü ÓÜÊÜá¿áÊÜ®Üá° ±ÜÅÍæ°±Ü£ÅPæ¿á ÊæáàÇݽWܨÜÈÉ ¯àvÜÇÝX¨æ.
The maximum time to answer the paper is given at the top of the question
paper. It includes 15 minutes for reading the question paper.
Tear here
6. ¯ÊÜáWæ ËñÜÄÓÜÇÝXÃÜáÊÜ ±ÜÅÍæ°±Ü£ÅPæ¿á BÊÜ꣤ ( Version ) ÊÜáñÜᤠ¯ÊÜá¾ ±ÜÅÊæàÍÜ ±ÜñÜŨÜÈÉ
ÊÜáá©ÅñÜÊÝXÃÜáÊÜ ±ÜÅÍæ°±Ü£ÅPæ¿á BÊÜ꣤ Jí¨æà BXÃÜáÊÜâ¨Ü®Üá° TÝñÜıÜwÔPæãÚÛ.
Ensure that, the Version of the question paper distributed to you and the
Version printed on your admission ticket is the same.
1 of 12
Page 3
CCE RF(A)/666/061 86-EK (Level-2)
I. D PæÙÜX®Ü ±ÜÅÍæ°WÜÚWæ A¥ÜÊÝ A±Üä|ì ÖæàÚPæWÜÚWæ ®ÝÆáR BÁáRWÜÙÜ®Üá° ¯àvÜÇÝX¨æ.
AÊÜâWÜÙÜÈÉ ÖæaÜác ÓÜãPܤÊÝ¨Ü EñܤÃÜÊÜ®Üá° BÄÔ, A¨ÜÃÜ PÜÅÊÜÞûÜÃܨæãí©Wæ ±Üä|ì
EñܤÃÜÊÜ®Üá° ŸÃæÀáÄ 10 × 1 = 10
Four alternatives are given for each of the following questions /
incomplete statements. Choose the correct alternative and write the
complete answer along with its question number and alphabet :
1. pÝÅÂP… aæàígÓ… BÁáR¿áá ¨æãÃæ¿ááÊÜ ±Üqr
(A) ¶æçÇ… (B) Gwp…
(C) C®…ÓÜp…ì (D) ÊÜäÂ
Track changes option is available in the menu,
(A) File (B) Edit
(C) Insert (D) View
2. pæàŸÇ… B¶… PÜípæíp…®ÜÈÉ D PæÙÜX®Ü ¿ÞÊÜ pݸ… ËË«Ü GíqÅàÓ… ÍæçÈ¿á®Üá°
Óæp… ÊÜÞvÜáÊÜ BÁáR¿á®Üá° Öæãí©¨æ
(A) Óær„Ç…Õ (B) GíqÅàÓ…
(C) ¸ÝÂP…WèÅív… (D) pæç±…
Which of the following tabs contains options to set styles for
various entries in the table of content ?
(A) Styles (B) Entries
(C) Background (D) Type
04. 04. 2024 2 of 12
Page 4
CCE RF(A)/666/061 86-EK (Level-2)
3. D PæÙÜX®Ü ¿ÞÊÜ oãÆ®Üá° bñÜÅ oãÇ…¸ÝÃ… J¨ÜXÓÜáÊÜâ©ÇÉ
(A) µÆrÄíW… (B) PÝŲíW…
(C) µÉ²íW… (D) PݲÀáíW…
Which of the following tools is not provided by image tool bar ?
(A) Filtering (B) Cropping
(C) Flipping (D) Copying
4. ¨ÜñݤíÍÜÊÜ®Üá° PæãÅ{àPÜÃÜ| ÊÜÞvÜÆá ŸÙÜÓÜŸÖÜá¨Ý¨Ü wà¶ÝÇ…r ¶ÜíûÜ®…
(A) BÊÜÃæàh… (B) ÊÜÞÂP…Õ
(C) ÓÜÊÜå… (D) Pèíp…
The default function used to consolidate the data is
(A) Average (B) Max
(C) Sum (D) Count
5. D PæÙÜX®ÜÊÜâWÜÙÜÈÉ Jí¨Üá ±æäÅàWÝÅËáíW… ÇÝíWæÌàh…
(A) PÝÂÇ…R (B) ¸æàÔP…
(C) Ô&ÃæçoÃ… (D) ÊÜÞÂPæãÅà
The programming language in the following is
(A) Calc (B) Basic
(C) C writer (D) Macro
6. w.¹.GÊÜå….GÓ….®Ü ËÓÜõñÜÃÜã±Ü
(A) væàpÝ ÊÜáñÜᤠŸáP…Õ ÊÜÞ®æàh…Êæáíp… ÔÓÜrÊÜå…
(B) væàpÝ ÊÜÞ®æàh…Êæáíp… ÊÜáÈr ÔÓÜrÊÜå…
(C) væàpݸæàÓ… ÊÜÞ®æàh…Êæáíp… ÔÓÜrÊÜå…
(D) vÜá²ÉPæàp… ŸáP…Õ ÊÜÞ®æàh…Êæáíp… ÔÓÜrÊÜå…
04. 04. 2024 3 of 12
Page 5
CCE RF(A)/666/061 86-EK (Level-2)
The expanded form of DBMS is
(A) Data and Books Management System
(B) Data Management Multi System
(C) Data Base Management System
(D) Duplicate Books Management System
7. GQÕÔríW… væàpݸæàÓ…A®Üá° ñæÃæ¿áÆá ŸÙÜÓÜáÊÜ ÍÝp…ìPÜp… QàÈ
(A) Ctrl + D (B) Ctrl + E
(C) Ctrl + F (D) Ctrl + O
The shortcut key to open an existing database is
(A) Ctrl + D (B) Ctrl + E
(C) Ctrl + F (D) Ctrl + O
8. D PæÙÜX®ÜÊÜâWÜÙÜÈÉ ¿ÞÊÜâ¨Üá pæP…Õ$r pæç±…®Ü Ë«ÜÊÜÆÉ
(A) ¶æäÉàp… (B) ÊæáÊæãà
(C) ÊÝÃ…PÝÂÃ… (D) PÝÂÃ…
Which of the following is NOT a type of text data type ?
(A) Float (B) Memo
(C) Varchar (D) Char
9. ÊÝñÝÊÜÃÜ|¨ÜÈÉ ÊÝ¿ááÊÜÞÈ®ÜÂÊÝWÜÆá ÊÜááS PÝÃÜ|
(A) ±ÝÅ~WÜÙÜá (B) «ÜãÙÜá
(C) ÊÜáÃÜWÜÙÜá (D) ¯àÃÜá
04. 04. 2024 4 of 12
Page 6
CCE RF(A)/666/061 86-EK (Level-2)
The main cause for air pollution in the environment is
(A) Animals (B) Dust
(C) Trees (D) Water
10. ±ÝÅ¥ÜËáPÜ ¸æíQ EípݨÝWÜ ÓÜí±ÜQìÓܸæàPÝ¨Ü ñÜáñÜáì ¨ÜãÃÜÊÝ~ ÓÜíTæÂ
(A) 100 (B) 101
(C) 108 (D) 111
The emergency telephone number to be contacted for primary fire
is
(A) 100 (B) 101
(C) 108 (D) 111
II. ÓÜãPܤÊÝ¨Ü EñܤÃÜ©í¨Ü ¹qrÃÜáÊÜ ÓܧÙÜÊÜ®Üá° »Ü£ì ÊÜÞw 4×1=4
Fill in the blanks with suitable answer :
11. ±Ü¨ÜÓÜíÓÜRÃÜOæ¿áÈÉ ÍæçÈ¿á ÓÜÄ¿Þ¨Ü ŸÙÜPæ¿áá .......................... A®Üá°
ÓÜá«ÝÄÓÜáñܤ¨æ.
Proper use of style improves ................... in a document.
12. ËñÜÄñÜÖÝÙæ¿áÈÉ w¶ÝÇ…r¯í¨Ü ÊÜÞÂPæãÅàÊÜ®Üá° ..........................®ÜÈÉ
EÚÓÜÇÝWÜáñܤ¨æ.
By default macro is saved in the ................. in a spreadsheet.
13. Jí¨Üá væàpݸæàÓ…®ÜÈÉ ®ÝÊÜâ ±ÜŨÜÎìÓܸæàPÝ¨Ü µàÇ…xWÜÙÜ®Üá° ¯©ìÐÜr±ÜwÓÜÆá
ŸÙÜÓÜáÊÜâ¨Üá ………………… .
In a database we can specify the fields that we want to display
using a .................. .
04. 04. 2024 5 of 12
Page 7
CCE RF(A)/666/061 86-EK (Level-2)
14. PæÆÓÜ¨Ü ±ÜÄÓÜÃܨÜÈÉ ÓÝÊÜÞ®ÜÂÊÝX ®æÆ, Wæãàvæ, ñÝÃÜÔ CÊÜâWÜÚí¨Ü A¥ÜÊÝ
¿áíñÜÅWÜÙæãí©Wæ PÝ¿áì ¯ÊÜì×ÓÜáÊÝWÜ EípÝWÜŸÖÜá¨Ý¨Ü A±Ý¿áWÜÙÜ®Üá°
………………… G®Üá°ñæ¤àÊæ.
In a workplace the risks arising from floor, wall, ceiling or
handling machineries are called .................. .
III. 15. A-±Üqr¿áÈÉ ËñÜÄñÜÖÝÙæ¿á ±ÜqrWÜÙÜ®Üá° ÊÜáñÜᤠB-±Üqr¿áÈÉ AÊÜâWÜÙÜ BÁáRWÜÙÜ®Üá°
¯àvÜÇÝX¨æ. AÊÜâWÜÙÜ®Üá° Öæãí©Ô EñܤÃÜWÜÙÜ®Üá° PÜÅÊÜÞûÜÃܨæãvÜ®æ ŸÃæÀáÄ
4×1=4
The menus of spreadsheet are given in Column-A and their
options are given in Column-B. Match them and write the
answer along with alphabet :
A-±Üqr B-±Üqr
Column-A Column-B
i) Gwp… ±Üqr a) Óܸ…pæãàoÇ…
Edit menu Subtotal
ii) C®…ÓÜp…ì ±Üqr b) WæãàÇ… ÔàP…
Insert menu Goal seek
iii) oãÇ… ±Üqr c) Öæç±ÜÃ… ÈíP…
Tool menu Hyperlink
iv) vÝpÝ ±Üqr d) ÃæPÝv…ì ÇæçŸÅÄ
Data menu Record library
e) pÝÅÂP… aæàígÓ…
Track changes
f) C®…ÓÜp…ì Îàp…
Insert sheet
g) ÈíPÜá oá GP…Õoì®ÜÇ… væàpÝ
Link to external data
04. 04. 2024 6 of 12
Page 8
CCE RF(A)/666/061 86-EK (Level-2)
IV. D PæÙÜX®Ü ±ÜÅÍæ°WÜÚWæ EñܤÄÔ 6×1=6
Answer the following questions :
16. ÊÝoÃ…ÊÜÞP…ì Gí¨ÜÃæà®Üá
What is watermark ?
17. vÝPÜáÂÊæáíp…®ÜÈÉ µÇ… ¶ÝÊÜÞìp… BÁáR¿á E±ÜÁãàWÜÊæà®Üá
What is the use of fill format in a document ?
18. ÊÜÞÂPæãÅà Gí¨ÜÃæà®Üá
What is macro ?
19. WæãàÇ… ÔàP… A®Üá° ÊÝÂTݯÔ.
Define Goal seek.
20. PÝÂÇ…R®ÜÈÉ ËñÜÄñÜÖÝÙæ¿á ¶æçÇ… GP…Õpæ®…ÐÜ®… A®Üá° ŸÃæÀáÄ.
Write the extension of spreadsheet file in calc.
21. væàpݸæàÓ… A®Üá° ÊÝÂTݯÔ.
Define a database.
V. D PæÙÜX®Ü ±ÜÅÍæ°WÜÚWæ EñܤÄÔ 6 × 2 = 12
Answer the following questions :
22. vÝPÜáÂÊæáíp…®ÜÈÉ vÝÅÂW… ÊÜáñÜᤠvÝű… Ë«Ý®Ü ŸÙÜÔ WÝÂÆÄÀáí¨Ü bñÜÅÊÜ®Üá°
ÓæàÄÓÜáÊÜ ÖÜíñÜWÜÙÜ®Üá° ŸÃæÀáÄ.
Write the steps to insert an image from the gallery using drag and
drop method in a document.
04. 04. 2024 7 of 12
Page 9
CCE RF(A)/666/061 86-EK (Level-2)
23. ±æäÔÐܯíW… B¶… CÊæáàg®Üá° ¯¿áí£ÅÓÜáÊÜ AíÍÜWÜÙÜ®Üá° £ÚÔ.
Mention the factors controlling positioning of an image.
24. ÊÝp…&C¶… A®ÝÈÔÓ… oãÇ… A®Üá° HPæ E±ÜÁãàXÓÜáñæ¤àÊæ
Why is what-if analysis tool used ?
A¥ÜÊÝ /OR
ËñÜÄñÜÖÝÙæ¿áÈÉ ÊÝp…&C¶… Ô®ÝÄÁãàÓ… Gí¨ÜÃæà®Üá
What is what-if scenarios in spreadsheet ?
25. ȸæÅ BµàÓ…®ÜÈÉ PæÌ„Ä ÃÜbÓÜáÊÜ ¿ÞÊÜâ¨Ý¨ÜÃÜã GÃÜvÜá ˫ݮÜWÜÙÜ®Üá° ŸÃæÀáÄ.
Name any two ways of creating query in LibreOffice.
A¥ÜÊÝ /OR
BÃ….w.¹.GÊÜå….GÓ….®Ü ¿ÞÊÜâ¨Ý¨ÜÃÜã GÃÜvÜá B¸æjP…rWÜÙÜ®Üá° ŸÃæÀáÄ.
Write any two objects of RDBMS.
26. ®ÜãÂÊÜáÄP… væàpÝpæç±…®ÜÈÉ ¿ÞÊÜâ¨Ý¨ÜÃÜã ®ÝÆáR Ë«ÜWÜÙÜ®Üá° ŸÃæÀáÄ.
Name any four types of Numeric data type.
27. WÜ|PÜ¿áíñÜÅ E¨æãÂàWÜ ÓܧÙܨÜÈÉ®Ü ¿ÞÊÜâ¨Ý¨ÜÃÜã ®ÝÆáR ÓÜáÃÜüñÜ PÜÅÊÜáWÜÙÜ®Üá° ±Üqr
ÊÜÞw.
List any four safety requirements for computer workplace.
04. 04. 2024 8 of 12
Page 10
CCE RF(A)/666/061 86-EK (Level-2)
VI. D PæÙÜX®Ü ±ÜÅÍæ°WÜÚWæ EñܤÄÔ 4 × 3 = 12
Answer the following questions :
28. vÝPÜáÂÊæáíp…®ÜÈÉ ÖæãÓÜ ÍæçÈ¿á®Üá° ÖæàWæ ®ÜËàPÜÃÜ| ( Update ) ÊÜÞvÜÇÝWÜáñܤ¨æ
How to update a new style in a document ?
A¥ÜÊÝ /OR
C®…ÓÜp…ì CÊæáàh… BÁáR¿á®Üá° E±ÜÁãàXÔ, ȸæÅ BµàÓ… vÝPÜáÂÊæáíp…Wæ
bñÜÅÊÜ®Üá° ( Image ) ÓæàÄÓÜáÊÜ ÖÜíñÜWÜÙÜ®Üá° ŸÃæÀáÄ.
Explain the steps to insert an image in a document, using insert
image option.
29. ÃæçoÃ… vÝPÜáÂÊæáíp…®ÜÈÉ CÃÜáÊÜ BÃÜá ËË«Ü ÍæçÈ¿á Ë«ÜWÜÙÜ®Üá° ËÊÜÄÔ.
Explain the six different categories of styles in a writer document.
30. ËñÜÄñÜÖÝÙæ¿áÈÉ ÊÜÞÂPæãÅà ÊÜÞvÜáÂÇ…®Üá° ÖæÓÜÄÓÜáÊÜ ¯¿áÊÜáWÜÙÜ®Üá° ŸÃæÀáÄ.
Name the rules for naming a macro module in a spreadsheet.
31. væàpݸæàÓ…®Ü ¿ÞÊÜâ¨Ý¨ÜÃÜã ÊÜáãÃÜá væàpÝ pæç±…ÕWÜÙÜ®Üá° ËÊÜÄÔ.
Explain any three data types in database.
VII. D PæÙÜX®Ü ±ÜÅÍæ°WÜÚWæ EñܤÄÔ 3 × 4 = 12
Answer the following questions :
32. vÝÅÀáíW… B¸æjP…r A®Üá° WÜáí±Üâ ÊÜÞvÜáÊÜ ÖÜíñÜWÜÙÜ®Üá° ËÊÜÄÔ.
Explain the steps for grouping drawing objects.
A¥ÜÊÝ /OR
04. 04. 2024 9 of 12
Page 11
CCE RF(A)/666/061 86-EK (Level-2)
pæí±æÉàp… A®Üá° BÊÜá¨Üá ( Import ) ÊÜÞwPæãÙÜáÛÊÜ ÖÜíñÜWÜÙÜ®Üá° ËÊÜÄÔ.
Explain the steps to import a template.
33. D PæÙÜX®Ü ±Ü¨ÜWÜÙÜ®Üá° ÊÝÂTݯÔ
(i) G¯rq
(ii) pæàŸÇ…
(iii) µàÇ…x
(iv) ÃæPÝv…ì
Define the following terms :
(i) Entity
(ii) Table
(iii) Field
(iv) Record
A¥ÜÊÝ /OR
w.¹.GÊÜå….GÓ….®Ü ¿ÞÊÜâ¨Ý¨ÜÃÜã ®ÝÆáR E±ÜÁãàWÜWÜÙÜ®Üá° ËÊÜÄÔ.
Explain any four advantages of DBMS.
04. 04. 2024 10 of 12
Page 12
CCE RF(A)/666/061 86-EK (Level-2)
34. D PæÙÜX®Ü ±Ü¨ÜWÜÙÜ®Üá° ËÊÜÄÔ
(i) ¨ÜñݤíÍÜ £¨Ü᪱Üw ÊÜÞvÜáÊÜâ¨Üá ( Editing a data )
(ii) ¨ÜñݤíÍÜ ËíWÜwÓÜá ( Sorting a data )
Explain the following terms :
(i) Editing a data
(ii) Sorting a data.
04. 04. 2024 11 of 12
Page 13
CCE RF(A)/666/061 86-EK (Level-2)
04. 04. 2024 12 of 12
Page 14
QUESTION PAPERS
GET PREVIOUS YEAR QUESTION PAPERS FOR ALL CLASSES FOR CBSE, ISCSE, ISC AND ALL ALL
STATE BOARDS HERE AT
Andhra Pradesh Board Question Papers
BOARD
WISE Assam Board Question Papers
Bihar Board Question Papers
Chhattisgarh Board Question Papers
Goa Board Question Papers
Gujarat Board Question Papers
Haryana Board Question Papers
Himachal Pradesh Board Question Papers
J&K State Board Question Papers
Jharkhand Board Question Papers
Karnataka Board Question Papers
Kerala Board Question Papers
Madhya Pradesh Board Question Papers
Maharashtra State Board Question Papers
Manipur Board Question Papers
Meghalaya Board Question Papers
Mizoram Board Question Papers
Nagaland Board Question Papers
Orissa Board Question Papers
Punjab Board Question Papers
Rajasthan Board Question Papers
Tamil Nadu Board Question Papers
Telangana State Board Question Papers
Tripura Board Question Papers
Uttarakhand Board Question Papers
Uttar Pradesh (UP) Board Question Papers
West Bengal (WB) Board Question Papers