Karnataka SSLC Model Question Paper 2024 Information Technology

ACADEMIC YEAR

2024

Karnataka
Board
Model Paper

PÜ®ÝìoPÜ ÍÝÇÝ ±ÜÄàûæ ÊÜáñÜᤠÊÜåèƯ|ì¿á ÊÜáívÜÈ
ÊÜáÇæÉàÍÜÌÃÜí, ¸æíWÜÙÜãÃÜá & 560 003
KARNATAKA SCHOOL EXAMINATION AND ASSESSMENT BOARD
Malleshwaram, Bengaluru – 560 003

2023-24 ÃÜ GÓ….GÓ….GÇ….Ô. ÊÜÞ¨ÜÄ ±ÜÅÍ氱ܣÅPæ
S.S.L.C. MODEL QUESTION PAPER – 2023-24
ËÐÜ¿á ÊÜÞ×£ ñÜíñÜÅþÝ®Ü
Subject : Information Technology
PܮܰvÜ ÊÜáñÜᤠBíWÜÉ ÊÜÞ«ÜÂÊÜá / Kannada and English Medium
ÓÜÊÜá¿á 2 WÜípæ 15 ¯ËáÐÜWÜÙÜá ] ËÐÜ¿á ÓÜíPæàñÜ : 86-E K
WÜÄÐÜu AíPÜWÜÙÜá 60 ] Subject Code : 86-E K
CCE-RF : ÍÝÇÝ Ë¨Ý¦ìWÜÙÜá / Regular Fresh

±ÜÄàûݦìWÝX ÓÝÊÜޮܠÓÜãaÜ®æWÜÙÜá
General Instructions to the Candidate :
1. D ±ÜÅÍ氱ܣÅPæ¿áá Joár 34 ±ÜÅÍæ°WÜÙÜ®Üá° Öæãí©¨æ.
This Question Paper consists of 34 questions.
2. ±ÜÅÍ氱ܣÅPæ¿á®Üá° ×ÊÜáá¾S hÝPæp… ÊÜáãÆPÜ ÊæãÖÜÃÜá ÔàÇ… ÊÜÞvÜÇÝX¨æ. ±ÜÄàûæ
±ÝÅÃÜí»ÜÊÝWÜáÊÜ ÓÜÊÜá¿áPæR ¯ÊÜá¾ ±ÜÅÍ氱ܣÅPæ¿á ŸÆŸ© ±ÝÍÜÌìÊÜ®Üá° PÜñܤÄÔ,
±ÜÅÍ氱ܣÅ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.
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.

[ Turn over

86-EK (Level-2) 2 CCE RF
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… væçÇÝW…, ¸ÝPÜÕ®Üá° ñæÃæ¿áÆá D PæÙÜX®ÜÊÜâWÜÙÜÈÉ ÓÜÄ¿Þ¨Ü PÜÅÊÜá

(A) File > Manage Templates > Templates

(B) File > Templates > Manage Templates

(C) Insert > Templates > Manage Templates

(D) Insert > Manage Templates > Templates

The correct sequence of options to open the template dialog box is

(A) File > Manage Templates > Templates

(B) File > Templates > Manage Templates

(C) Insert > Templates > Manage Templates

(D) Insert > Manage Templates > Templates

2. bñÜÅ oãÇ…¸ÝÃ… D PæÙÜX¬Ü ¿ÞÊÜ oãÇ… J¨ÜXÓÜáÊÜâ©ÆÉ

(A) µÆrÄíW… (B) PÝÅ°íW…

(C) µÉà°íW… (D) PݲÀáíW…

86-EK (Level-2) 3 CCE RF
The Image toolbar does not provide tool for

(A) Filtering (B) Cropping

(C) Flipping (D) Copying

3. pæí¯æÉàp… væçÇÝW… ¸ÝP…Õ¬Üá® ñæÃæ¿áÆá ÍÝp…ìPÜp… QàÈ

(A) Ctrl + Alt + N (B) Shift + Ctrl + N

(C) Ctrl + Alt + T (D) Shift + Alt + T

The shortcut key to open 'Template dialog box' is

(A) Ctrl + Alt + N (B) Shift + Ctrl + N

(C) Ctrl + Alt + T (D) Shift + Alt + T

4. D PæÙÜX®ÜÊÜâWÜÙÜÈÉ ¿ÞÊÜâ¨Üá ÓÜãPܤÊÝ¨Ü ÊÜÞÂPæãÅà ÖæÓÜÃÜá (ÊÜÞÂPæãÅà ®æàÊÜå…)

(A) 1formatword (B) format word

(C) format * word (D) format_word

Which of the following is a valid macro name ?

(A) 1formatword (B) formatword

(C) format * word (D) format_word

5. CÊÜâWÜÙÜÈÉ ¯æäÅàWÝÅËáíW… »ÝÐæ ( language ) ¿á®Üá° WÜáÃÜá£Ô

(A) PÝÂÇ…R (B) ¸æàÔP…

(C) ÃæçoÃ… (D) ÊÜÞÂPæãÅà

Identify the programming language, in the following.

(A) Calc (B) BASIC

(C) Writer (D) Macro

[ Turn over

86-EK (Level-2) 4 CCE RF
6. PÜÃæ¯Õ ¨ÜñݤíÍÜÊÜ®Üá° ÓÜíTæ ¨ÜñݤíÍܨÜÈÉ ÓÜíWÜÅ×ÓÜáñܤÊæ

(A) ÓÜÄ/ñܱÜâ³ (B) – 86

(C) $100 (D) 12/25/2019

An example for currency data type is,

(A) True/False (B) – 86

(C) $100 (D) 12/25/2019

7. D PæÙÜX®ÜÊÜâWÜÙÜÈÉ ¿ÞÊÜâ¨Üá pæP…Õ$r væàpÝ Ë«Ü AÆÉ

(A) ÊæáÊæãà (B) ÊÝÃ…PÝÂÃ…

(C) ¶æäÉàp… (D) PÝÂÃ…

Which of the following is NOT a text data type ?

(A) Memo (B) Varchar

(C) Float (D) Char

8. ÃæPÝv…ìWÜÙÜ®Üá° PæãàÐÜrPܨÜÈÉ ÓæàÄÓÜáÊÝWÜ, ®ÝÊÜâ ÊÜááí©®Ü µàÇ…xWæ aÜÈÓÜÆá
ŸÙÜÓÜáÊÜ QàÈ

(A) Tab (B) Ctrl

(C) Enter (D) Shift

While entering the records in table, we can move to next field by
pressing the key

(A) Tab (B) Ctrl

(C) Enter (D) Shift

86-EK (Level-2) 5 CCE RF
9. PÜí±ÜäÂoÃ…®ÜÈÉ PæÆÓÜ ÊÜÞvÜáÊÝWÜ PÜ|á¡WÜÙÜá J|X¨ÜÃæ, ®ÝÊÜâ
(A) PÜ|á¡WÜÙÜ®Üá° ÊÜááaÜc¸æàPÜá
(B) PÜí¯ÜäÂoÃ… ®æãàvܸæàPÜá
(C) PÜ|á¡WÜÚWæ BWÝWÜ bPÜR ÊÝ¿ÞÊÜá ÊÜÞvܸæàPÜá
(D) PÜí¯ÜäÂoÃ… ÊÜááí¨æ PÜáÚñÜá ­¨æª ÊÜÞvܸæàPÜá

While doing work with computer, eyes get dry. Then, we should

(A) Close the eyes

(B) Stop the eyes in front of computer

(C) Do periodically simple exercise of eyes

(D) Sit and sleep in front of computer
10. ¸æíQ ®Üí©ÓÜáÊÜ E±ÜPÜÃÜ|WÜÙÜ®Üá° ¿ÞÊÝWÜ ŸÙÜÓÜáñæ¤àÊæ
(A) PæÙÜWæ ¹¨ÝªWÜ (B) ˨ÜáÂñ… B[ÝñÜÊݨÝWÜ
(C) ¸æíQ B[ÝñÜÊݨÝWÜ (D) ÓÜáor WÝ¿áÊݨÝWÜ

When do we use a fire extinguisher ?

(A) In case of fall (B) In case of electric shock

(C) In case of fire (D) In case of burn injury

II. ÓÜãPܤÊÝ¨Ü EñܤÃÜ©í¨Ü ¹qrÃÜáÊÜ ÓܧÙÜÊÜ®Üá° »Ü£ì ÊÜÞw 4×1=4

Fill in the blanks with suitable answer :

11. BÂíPÜÃ…, bñÜÅPÜÇæ¿áÈÉ .......................... ¹í¨ÜáÊÝX ±ÝñÜÅÊÜ×ÓÜáñܤ¨æ.
Anchor acts as .................... point for a drawing.

12. IDE Cí¨Ü ÊÜÞvÜáÂÆ®Üá° aÜÇÝÀáÓÜÆá .......................... ¿á®Üá° Jñܤ¸æàPÜá.

The module can be executed from the IDE by pressing .............. .

[ Turn over

86-EK (Level-2) 6 CCE RF
13. BÃ…w¹GíGÓ… ¬Ü ËÓÜõñÜ ÃÜã¯Ü ………………… .
RDBMS stands for ......................... .

14. »è£PÜ A±Ý¿áWÜÙÜá EípÝWÜáÊÜâ¨Üá ………………… Äí¨Ü.
Physical hazards occur due to .................. .

III. 15. væàpÝ pæç±…WÜÙÜ®Üá° A-±Üqr¿áÈÉ ¯àw¨æ ÊÜáñÜᤠB-±Üqr¿áÈÉ AÊÜâWÜÚWæ E¨ÝÖÜÃÜOæWÜÙÜ®Üá°
¯àvÜÇÝX¨æ. AÊÜâWÜÙÜ®Üá° Öæãí©Ô EñܤÃÜWÜÙÜ®Üá° PÜÅÊÜÞûÜÃܨæãvÜ®æ ŸÃæÀáÄ 4 × 1 = 4
Data types are given in Column-A and their examples are
given in Column-B. Match them and write the answer along
with alphabet :
A-±Üqr B-±Üqr
Column-A Column-B
i) ÇÝíWÜ ÊÝÃ…PÝÂÃ… a) ©®ÝíPÜ ÊÜáñÜᤠÓÜÊÜá¿á væàpÝ
Long Varchar pæ篅
Date & Time data type

ii) PÝÂÃ… b) PÜÃæ¯Õ væàpÝ pæ篅
Char Currency data type
iii) 12/25/2019, 8:45 p.m. c) ¸æç®ÜÄ væàpÝ pæ篅
Binary data type

iv) oãÅ / ¶ÝÇ…Õ d) ÊæáàÊæã væàpÝ pæ篅
True/False Memo data type

e) pæP…Õ$r µP…Õ væàpÝ pæ篅
Text fix data type

f) pæP…Õ$r væàpÝ pæ篅
Text data type
g) ŸãÈ¿á®… væàpÝ pæ篅
Boolean data type.

86-EK (Level-2) 7 CCE RF
IV. D PæÙÜX®Ü ±ÜÅÍæ°WÜÚWæ EñܤÄÔ 6×1=6
Answer the following questions :

16. ȸæÅ BµàÓ… ÃæçoÃ…¬ÜÈÉ ÍæçÈ Gí¨ÜÃæà®Üá ?
What is style in LibreOffice writer ?

17. ToC ¿á®Üá° ÊÝÂTݯÔ.

Define ToC.

18. ¿ÞÊÜ E¯ÜPÜÃÜ| ŸÙÜÔ ËñÜÄñÜ ÖÝÙæ¿áÈÉ Lp…Çæ笅 ÃÜbÓÜáñæ¤àÊæ
Which tool is used to create an outline in spreadsheet ?

19. ÊÜÞÂPæãÅàÊÜ®Üá° ÖæÓÜÄÓÜÆá A®ÜáÓÜÄÓÜáÊÜ ¿ÞÊÜâ¨Ý¨ÜÃÜã Jí¨Üá ¯¿áÊÜáÊÜ®Üá°
ŸÃæÀáÄ.
Write any one rule to follow for naming macros in spreadsheet.

20. w¹GíGÓ…¬ÜÈÉ væàpÝ ÊÜÞvæÇ… Gí¨ÜÃæà¬Üá
What is data model in DBMS ?

21. ÊÝp…&C¶… A®ÝÈÔÓ… oãƬÜá® ÊÝÂTÝ­Ô.
Define the term 'what-if' analysis.

V. D PæÙÜX®Ü ±ÜÅÍæ°WÜÚWæ EñܤÄÔ 6 × 2 = 12

Answer the following questions :

22. ȸæÅ BµàÓ… ÃæçoÃ…¬ÜÈÉ bñÜÅÊܬÜá® ÓæàÄÓÜáÊÜ ¬ÝÆáR Ë«ÜWÜÙܬÜá® ŸÃæÀáÄ.

Write 4 methods of inserting image in LibreOffice writer.

[ Turn over

86-EK (Level-2) 8 CCE RF
23. D PæÙÜX®Ü ÍæçÈ ÊÜWÜìWÜÙÜ®Üá° ÊÝÂTݯÔ
(a) PÝÂÃæPÜrÃ… ÍæçÈWÜÙÜá
(b) ¶æÅàÊÜå… ÍæçÈWÜÙÜá
Define the following terms in style categories :

(a) Character styles

(b) Frame styles

A¥ÜÊÝ /OR
vÝÅÀáíW… oãÇ…¸ÝÃ…¬ÜÈÉ Æ»ÜÂËÃÜáÊÜ ¿ÞÊÜâ¨Ý¨ÜÃÜã ¬ÝÆáR BÁáRWÜÙܬÜá®
ŸÃæÀáÄ.
Write any four options present in drawing tool bar.

24. ËñÜÄñÜÖÝÙæ¿áÈÉ AŸÕÆãÂp… ÊÜáñÜᤠÄÇæàqÊ… Öæç¯ÜÃ…ÈíP…WÜÙÜ ¬ÜvÜáˬÜ
ÊÜÂñÝÂÓÜWÜÙæà®Üá
Differentiate between absolute and relative hyperlink.

25. D PæÙÜX®Ü ±Ü¨ÜWÜÙÜ®Üá° ÊÝÂTݯÔ
(a) ±æùÊÜáÄ QàÈ
(b) PÝÂíwvæàíp… QàÈ

Define the following terms :

(a) Primary key

(b) Candidate key.

A¥ÜÊÝ /OR
BÃ…w¹GíGÓ…¬Ü B¸æjP…rWÜÙÜ®Üá° ±Üqr ÊÜÞw.

List the objects of RDBMS.

86-EK (Level-2) 9 CCE RF
26. ¬æp…ÊÜP…ì væàpÝ ÊÜÞvæÇ… ÊÜáñÜᤠÄÇæàÐܬÜÇ… væàvÝ ÊÜÞvæÇ… ¬ÜvÜáˬÜ
ÊÜÂñÝÂÓÜWÜÙæà®Üá

Differentiate between the network data model and relational data
model.

27. PÜí¯ÜäÂoÃ…Wæ ÓÜퟘԨÜíñæ ¿ÞÊÜâ¨Ý¨ÜÃÜã GÃÜvÜá BÃæãàWÜ ÊÜáñÜᤠÓÜáÃÜûÜñÝ
ÓÜÆÖæWÜÙܬÜá® ŸÃæÀáÄ.

Write any two health and safety tips, related to computers.

VI. D PæÙÜX®Ü ±ÜÅÍæ°WÜÚWæ EñܤÄÔ 4 × 3 = 12
Answer the following questions :

28. ȸæÅ BµàÓ… ÃæçoÃ…¬ÜÈÉ ÃæàTÝbñÜÅWÜÙܬÜá® WÜáí¯Üâ ÊÜÞvÜáÊÜ ÖÜíñÜWÜÙܬÜá® ŸÃæÀáÄ.

Write the steps for grouping drawing objects in LibreOffice writer.

29. ȸæÅ BµàÓ… ÃæçoÃ…¬ÜÈÉ ÍæçÈWÜÙÜ®Üá° ®ÜËàPÜÃÜ|WæãÚÓÜáÊÜ ÖÜíñÜWÜÙܬÜá® ŸÃæÀáÄ.

Write the steps to update styles in LibreOffice writer.

A¥ÜÊÝ /OR

ȸæÅ BµàÓ… ÃæçoÃ…¬ÜÈÉ bñÜÅÊܬÜá® ÊÜáÃÜáWÝñÜÅWæãÚÓÜÆá ÖÜíñÜWÜÙܬÜá® ŸÃæÀáÄ.

Write the steps for resizing of an image in LibreOffice writer.

30. ËñÜÄñÜÖÝÙæ¿áÈÉ ÊÜÞÂPæãÅàÊܬÜá® Ãܬ… ÊÜÞvÜáÊÜ ÖÜíñÜWÜÙܬÜá® ŸÃæÀáÄ.

Write the steps for running a macro in spreadsheet.

31. w¹GíGÓ…¬ÜÈÉ ÄÇæàÐܬÜÇ… væàpݸæàÓ…®Ü ±ÝÄ»ÝÑPÜ ±Ü¨ÜWÜÙÜ®Üá° ±Üqr ÊÜÞw.

List the Relational Database Terminologies in DBMS.

[ Turn over

86-EK (Level-2) 10 CCE RF
VI. D PæÙÜX®Ü ±ÜÅÍæ°WÜÚWæ EñܤÄÔ 4 × 3 = 12
Answer the following questions :
32. ȸæÅ BµàÓ… ÃæçoÃ…¬ÜÈÉ ¯æäÔÐÜ­íW… B¶… CÊæáàh…­í¨Ü ­¿áí£ÅÓÜƱvÜáÊÜ
¬ÝÆáR ÓæqríW…WÜÙܬÜá® ËÊÜÄÔ.
Explain the four settings which are controlled by positioning of an
image in LibreOffice writer.

A¥ÜÊÝ /OR

ȸæÅ BµàÓ… ÃæçoÃ…¬ÜÈÉ D PæÙÜX¬Ü bñÜÅ E¯ÜPÜÃÜ|WÜÙÜ E¯ÜÁãàWÜWÜÙܬÜá®
ŸÃæÀáÄ.

(a) PÝű… (b) CÊæáàh… Êæãàv…

(c) pÝÅ®…Õ±ÜÃæ¯Õ (d) Ãæãpæàp…

Write the effects on image of the following tools in LibreOffice
writer.

(a) Crop (b) Image mode

(c) Transparency (d) Rotate

33. ËñÜÄñÜÖÝÙæ¿áÈÉ ÄiÓÜrÃ… væàpÝ ÓæãàÓ…ì A¬Üá® ÈíP… ÊÜÞvÜÆá ÖÜíñÜWÜÙܬÜá®
ŸÃæÀáÄ.

Write the steps to link Registered data source in spreadsheet.

A¥ÜÊÝ /OR

ËñÜÄñÜÖÝÙæ¿áÈÉ D E±ÜPÜÃÜ|WÜÙÜ®Üá° ÊÝÂTݯÔ

(a) WÜãű…Õ

86-EK (Level-2) 11 CCE RF
(b) Óܸ…pæãàoÇ…

(c) ÊÝp… C¶… Ô¬ÝÄÁãàÓ…

(d) WæãàÇ… ÔàP…

Define the following tools/terms in spreadsheet :

(a) Groups

(b) Subtotal

(c) What if scenarios

(d) Goal seek

34. w¹GíGÓ…¬Ü ¿ÞÊÜâ¨Ý¨ÜÃÜã ¬ÝÆáR ¯ÜÅÁãàg¬ÜWÜÙܬÜá® ËÊÜÄÔ.

Explain any four advantages of DBMS.

[ Turn over

86-EK (Level-2) 12 CCE RF