SET~4

Series : EFGH/S

.
Roll No. Q.P. Code 89/S

Candidates must write the Q.P.

Code on the title page of the
answer-book.
NOTE
(I) (I) Please check that this question
19 paper contains 19 printed pages.

(II) (II) Q.P. Code given on the right hand

side of the question paper should be
written on the title page of the
answer-book by the candidate.
(III) 21 (III) Please check that this question
paper contains 21 questions.
(IV) (IV) Please write down the Serial
, Number of the question in the
answer-book at the given place
before attempting it.
(V) 15 (V) 15 minute time has been allotted to
read this question paper. The
question paper will be distributed
10.15 10.15
at 10.15 a.m. From 10.15 a.m. to
10.30
10.30 a.m., the candidates will read
the question paper only and will not
write any answer on the answer-book
# during this period.

INFORMATION TECHNOLOGY
:2 : 50
Time allowed : 2 hours Maximum Marks : 50

89/S # 1| P a g e P.T.O.
(i)

(ii) 21

(iii)
(iv) (5 + 16) = 21 , 2

(5 + 10) = 15
(v)

(vi) 24
(a) 5
(b)
(c)
(d)

(vii) 26
(a) 16
(b) 10
(c)
(d)

( ) (24 )

1. 6 4 4×1=4

(i) (Communication Cycle) ? 1

(A)

(B)

(C) (transmit)

89/S # 2| P a g e
 (D)

89/S # 3| P a g e
General Instructions :
(i) Please read the instructions carefully.
(ii) This question paper consists of 21 questions in two Sections : Section A
and Section B.
(iii) Section A has Objective Type Questions, whereas Section B contains
Subjective Type Questions.
(iv) Out of the given (5 + 16) = 21 questions, a candidate has to answer
(5 + 10) = 15 questions in the allotted (maximum) time of 2 hours.
(v) All questions of a particular section must be attempted in the correct order.
(vi) Section A : Objective Type Questions (24 marks) :
(a) This section has 5 questions.
(b) There is no negative marking.
(c) Do as per the instructions given.
(d) Marks allotted are mentioned against each question/part.
(vii) Section B : Subjective Type Questions (26 marks) :
(a) This section has 16 questions.
(b) A candidate has to do 10 questions.
(c) Do as per the instructions given.
(d) Marks allotted are mentioned against each question/part.

Section A

(Objective Type Questions) (24 Marks)

1. Answer any 4 out of the given 6 questions on Employability Skills. 4×1=4

(i) What is the role of feedback in the Communication Cycle ? 1

(A) To initiate the message

(B) To acknowledge and respond to the message

(C) To transmit the message

(D) To interrupt the communication

89/S # 4| P a g e P.T.O.
 (ii) (Stress Management) ? 1

(A)

(B)

(C)

(D)

(iii) ? 1

(A)

(B)

(C)
(D)

(iv) (SMART) ? 1
(A) (Simple) (B) (Special)

(C) (Specific) (D) (Social)

(v) (Sustainable Development) ? 1

(A)

(B)

(C)

(D)

(vi) ? 1
(A) (Gaming Software)

(B) (Designing Software)

(C) (Operating System)

89/S # 5| P a g e
 (D) (Internet Software)

89/S # 6| P a g e
 (ii) What is the ultimate goal of stress management ? 1
(A) Being depressed
(B) Ignoring stress
(C) Being stressed at all times
(D) Maintaining a balance between life, work, and relaxation

(iii) Which of the following is an example of a wage employed person ? 1

(A) A taxi driver who owns his own car
(B) An accountant working at a Bank
(C) A freelance photographer
(D) A shop owner

(iv) 1
(A) Simple (B) Special
(C) Specific (D) Social

(v) Why is there a need for Sustainable Development ? 1

(A)
ability to meet their needs
(B) To focus solely on environmental conservation
(C) To increase the consumption of resources
(D) To guarantee short-term economic growth

(vi) The most important software in any computer is the . 1

(A) Gaming Software
(B) Designing Software
(C) Operating System
(D) Internet Software

89/S # 7| P a g e P.T.O.
2. 6 5 5 1=5
(i) (save)
1
(A) (Table of Contents)
(B) (Style)
(C) (Comments)
(D) (Track Changes)

(ii) LibreOffice Writer

(filtering) (resizing) (cropping) (rotating)

? 1
(A) (Image) (B) (Drawing)
(C) (Formatting) (D) (Standard)

(iii) (topics) (subtopics)

1
(A) (Template) (B) (Table)
(C) (Table of Contents) (D) (Content)

(iv) LibreOffice Writer , (menu) (Track

Changes) ? 1
(A) (File) (B) (Edit)
(C) (View) (D) (Insert)

(v) (Writer)
1
(A) (Image Wrapping)
(B) (Picture Wrapping)
(C) (Image Placement)
(D) (Text Wrapping)
(vi) (Table of Contents) (Index)
(Bibliography) (dialog box)_______________________________1
(A) 4 (B) 5
89/S # 8| P a g e
 (C) 6 (D) 7

89/S # 9| P a g e
2. Answer any 5 out of the given 6 questions. 5×1=5

(i) is a collection of all formatting information, which you

want to save and then apply on the document. 1
(A) Table of Contents
(B) Style
(C) Comments
(D) Track Changes

(ii) Ravi wants to use tools for filtering, resizing, cropping and rotating of
an image inserted in his project created in LibreOffice Writer. Which
toolbar should he use to access these tools ? 1
(A) Image (B) Drawing
(C) Formatting (D) Standard

(iii) contains a list of topics and subtopics that have been

covered in the book along with page numbers.
1
(A) Template (B) Table
(C) Table of Contents (D) Content

(iv) In LibreOffice Writer, which of the following menus contains the Track
Changes option ?

1
(A) File (B) Edit
(C) View (D) Insert

(v) feature of Writer allows the placement of image in relation

to text. 1
(A) Image Wrapping
(B) Picture Wrapping
(C) Image Placement
(D) Text Wrapping

(vi) There are tabs present in the Table of Contents, Index or

Bibliography dialog box. 1
89/S # 10| P a g P.T.O.
e
 (A) 4 (B) 5
(C) 6 (D) 7

89/S # 11| P a g P.T.O.

e
3. 6 5 5 1=5

(i) LibreOffice Calc

(sum) (average) 1
(A) Average (B) Subtotal
(C) Comment (D) Link
(ii) Calc (option) (trends)
(relationships) , (multiple)
(worksheets) (single) (spreadsheet)
1
(A) Consolidate (B) Subtotal
(C) Group by (D) Goal Seek
(iii) (cell)
1

(A) (Notes) (B) (Data)

(C) (Total) (D) (Comment)

(iv) sign Absolute

Cell Reference) 1
(A) # (B) @
(C) % (D) $
(v) LibreOffice Calc , (specific
output) 1
(A) Subtotal (B) Goal Seek
(C) Macros (D) Hyperlink
(vi) LibreOffice Calc
1
(A) (Record Changes)

(B) (Hyperlink)
(C) (Make Changes)
(D) (Cell Reference)

89/S # 12| P a g
e
3. Answer any 5 out of the given 6 questions. 5×1=5

(i) The tool in LibreOffice Calc creates the group automatically

and applies common functions like sum, average on the grouped data.
(A) Average (B) Subtotal
(C) Comment (D) Link

(ii) option of Calc is used to view and compare a variety of data

from multiple worksheets into a single spreadsheet, for identifying
trends and relationships. 1
(A) Consolidate (B) Subtotal
(C) Group by (D) Goal Seek

(iii) is used to add notes or suggestions to a cell in a spreadsheet.

(A) Notes (B) Data
(C) Total (D) Comment

(iv) The sign is used for absolute cell reference in a spreadsheet.

(A) # (B) @

(C) % (D) $

(v) Which of the following feature of LibreOffice Calc, helps in finding out
the input for the specific output ?

1
(A) Subtotal (B) Goal Seek
(C) Macros (D) Hyperlink

(vi) feature of LibreOffice Calc provides different ways to record

the changes made by one or the other users in the spreadsheet.
1
(A) Record Changes
(B) Hyperlink
89/S # 13| P a g P.T.O.
e
 (C) Make Changes
(D) Cell Reference

89/S # 14| P a g P.T.O.

e
4. 6 5 5 1=5

(i)
(user-friendly)
(easy-to-read) (enter) 1
(A) (Report) (B) (Form)
(C) (Query) (D) (Database)

(ii) LibreOffice Base view

(enter) 1
(A) Design (B) Enter
(C) Datasheet (D) Query
(iii) (multiple)
(inconsistency)
1
(A) (Owner)
(B) (Design)
(C) (Database)
(D) (Redundancy)

(iv) LibreOffice Base 1

(A)
(B) (open source)
(C) (character)
(D)
(v) (object) 1
(A) (Query) (B) (Table)
(C) (Chart) (D) (Report)

(vi) (key) (row)

1
(A) Foreign (B) Primary
(C) Relational (D) Column
89/S # 15| P a g e
4. Answer any 5 out of the given 6 questions. 5×1=5

(i) A is an object of the database that has a user-friendly

interface where data can be entered and seen in an attractive and
easy-to-read format.
1
(A) Report (B) Form
(C) Query (D) Database

(ii) In LibreOffice Base, data can be entered in a table only in

view. 1
(A) Design (B) Enter
(C) Datasheet (D) Query

(iii) While working with multiple tables, you need to check and reduce the
and inconsistency of data. 1
(A) Owner
(B) Design
(C) Database
(D) Redundancy

(iv) Which of the following statements is true about LibreOffice Base ? 1

(A) It is a spreadsheet software.
(B) It is a free and open source software.
(C) It can store only character data.
(D) It is a designing software.

(v) Which of the following is not an object in a database ? 1

(A) Query (B) Table
(C) Chart (D) Report

(vi) A key is a field that uniquely identifies a row in a table. 1

(A) Foreign (B) Primary
(C) Relational (D) Column
89/S # 16| P a g e P.T.O.
89/S # 17| P a g e P.T.O.
5. 6 5 5 1=5

(i) (hazard) 1
(A) (Rapid Action Team)

(B)
(C)
(D) (emergency
response)
(ii) (workplace)
? 1
(A)
(B) electrical controls
(C)

(D)
(iii) (fire classification) ,
1
(A) A (B) B
(C) C (D) D
(iv)
(factor) 1
(A)

(B)
(C)
(D)

(v)
1
(A)
(B)
(C)
(D)

89/S # 12| P a g e
5. Answer any 5 out of the given 6 questions. 5×1=5

(i) What is a hazard in the context of safety and health ? 1

(A) Rapid Action Team
(B) Something that can cause harm to people
(C) A safety measure implemented to prevent accidents
(D) An emergency response plan for workplace incidents

(ii) Which of the following is not a valid safety guideline of a workplace ?

(A) Make sure all areas have proper lighting
(B) Do not play with electrical controls or switches
(C) Shut down all machines before leaving the workplace
(D) Wear loose clothing or jewellery when working with machines

(iii) In fire classification, electrical material and equipment comes under

. 1
(A) Class A material (B) Class B material
(C) Class C material (D) Class D material

(iv) What is a major contributing factor to obesity, especially in children,

with respect to use of computers ?

1
(A) Excessive physical activity
(B) Spending long hours on computers without breaks
(C) Eating healthy snacks while using the computer
(D) Regular exercise during computer breaks

(v) Which of the following is compulsory in order to provide a healthy

working environment to the employees ?

1
(A) Shopping corner
89/S # 13| P a g e P.T.O.
 (B) Cleanliness of the workplace
(C) Library
(D) Music therapy room

89/S # 13| P a g e P.T.O.

 (vi) (slip and fall) 1
(A) (Physical hazard)

(B) (Electrical hazard)

(C) (Chemical hazard)
(D) (Biological hazard)

26

5 3 20 30
3 2=6

6. (non-verbal communication) 2

7. (qualities) 2

2
8.
9. (stress management techniques)
2

10. (Sustainable Development) 2

6 4 20 30 4 2= 8

11. LibreOffice Writer (template)

(save) 2

12. (Accidents) (Emergencies) 2

13. LibreOffice Calc Shared Spreadsheet ?

2

14. (Relative) (Absolute) ? 2

15. LibreOffice Base S

2

89/S # 14| P a g e
16. 2

89/S # 14| P a g e
 (vi) Slip and fall is a type of . 1
(A) Physical hazard
(B) Electrical hazard
(C) Chemical hazard
(D) Biological hazard

Section B
(Subjective Type Questions) (26 marks)

Answer any 3 out of the given 5 questions on Employability Skills in 20 30 words

each. 3×2=6

6. What is non-verbal communication ? Give examples. 2

7. Give any four qualities of a successful entrepreneur. 2

8. How can a computer be protected against viruses ? Discuss in brief. 2

9. Mention any four simple stress management techniques. 2

10. Briefly discuss the importance of Sustainable Development. 2

Answer any 4 out of the given 6 questions in 20 30 words each. 4×2=8

11. What are templates in LibreOffice Writer ? What all can be created and
saved in a template ?

12. Differentiate between Accidents and Emergencies. 2

13.
two advantages of sharing a spreadsheet. 2

14. What is Relative and Absolute Hyperlink in a spreadsheet ? 2

15.
its two types. 2

89/S # 15| P a g e P.T.O.

16. Give any two ways to avoid slips and falls at the workplace. 2

89/S # 15| P a g e P.T.O.

 5 3 50 80 3 4=12

17. LibreOffice Writer

(adjust) (arrange)

: 2+1+1=4
Text (positioning image) , Anchoring
Arrangement
(Invert Image Filter)
Grouping drawing objects

18. LibreOffice Calc 1+1+2=4

(Macros)

19. multiple
(relationship) 1+2+1=4

prerequisite

LibreOffice Base (relationship) ,

(common field) (data type) ,

20.
dry eyes
1+2+1=4
(ergonomics)

ergonomically
89/S # 16| P a g e
 Occupational Overuse Syndrome

89/S # 16| P a g e
Answer any 3 out of the given 5 questions in 50 80 words each. 3×4=12

17. Ankita is designing a birthday card for her friend, in LibreOffice Writer.
She inserted a few pictures which she wants to adjust and arrange in
different ways. Help her do the same by explaining the following to her :
2+1+1=4
(a) With reference to positioning image in the text, differentiate
between Anchoring and Arrangement.
(b) What is the effect of Invert Image Filter on the image ?
(c) What do you mean by Grouping drawing objects ?

18. In context of LibreOffice Calc, answer the following : 1+1+2=4

(a) Define the term Macros.
(b) State any two rules for naming a Macro.
(c) Give the steps to record a Macro.

19. While working with multiple tables, you need to set up relationships
between the tables of a database. 1+2+1=4
Answer the following questions based on the above information :
(a) What is the most important prerequisite for setting a relationship
between the two tables ?
(b) How many types of relationships can be created between two
tables ? Name any two.
(c) While setting up relationship between two tables in LibreOffice
Base, what will happen if the data type of common field in both
tables is not same ?

20. Amit, an office employee, has been experiencing the problem of dry eyes
due to long hours spent working on his computer in the office. Guide him
by answering the following questions : 1+2+1=4
(a) Define the term ergonomics.
(b) Suggest two ergonomically correct measures to avoid the above
health issue.
(c) What is Occupational Overuse Syndrome ?

89/S # 17| P a g e P.T.O.

21. (table) BOOKS
4

BID Name DOP Type Price

2001 2019-05-19 Inspire 450.00

4003 Millionaire 2017-12-21 Inspire 340.00

3024 The Chair 2020-02-25 Horror 320.00

2082 Morning Tea 2017-11-20 Mystery 310.00

1502 Nightingale 2021-06-15 Biography 270.00

1300 The Truth 2020-08-18 Mystery 510.00

( ) candidate keys

( ) (attribute) (primary key)

( ) Price (data type)

( ) BOOLEAN Datatype.

89/S # 18| P a g e
21. Consider the table BOOKS given below and answer the questions that
follow :

BID Name DOP Type Price

2001 Gift 2019-05-19 Inspire 450.00

4003 Millionaire 2017-12-21 Inspire 340.00

3024 The Chair 2020-02-25 Horror 320.00

2082 Morning Tea 2017-11-20 Mystery 310.00

1502 Nightingale 2021-06-15 Biography 270.00

1300 The Truth 2020-08-18 Mystery 510.00

BID Book Identification, DOP Date of Purchase :

(a) Identify and name the candidate keys from the above table.

(b) Identify and write the attribute which is best suitable to be

declared as a primary key.

(c)
answer.

(d) Explain in short BOOLEAN Datatype.

89/S # 19| P a g e P.T.O.

 89/S
Marking Scheme
Strictly Confidential
(For Internal and Restricted use only)
SECONDARY SCHOOL SUPPLEMENTARY EXAMINATION, 2025
SUBJECT NAME : INFORMATION TECHNOLOGY (SUB. CODE-402)
General Instructions: -
You are aware that evaluation is the most important process in the actual and correct
assessment of the candidates. A small mistake in evaluation may lead to serious
problems which may affect the future of the candidates, education system and
teaching profession. To avoid mistakes, it is requested that before starting
evaluation you must read and understand the spot evaluation guidelines carefully.
“Evaluation policy is a confidential policy as it is related to the confidentiality
of the examinations conducted, Evaluation done and several other
aspects. Its leakage to public in any manner could lead to derailment of
the examination system and affect the life and future of millions of
candidates. Sharing this policy/document to anyone, publishing in any
magazine and printing in Newspaper/Website etc. may invite action
under various rules of the Board and IPC.”
Evaluation is to be done as per instructions provided in the Marking Scheme. It should not
be done according to one’s own interpretation or any other consideration. Marking
Scheme should be strictly adhered to and religiously followed. However, while
evaluating, answers which are based on latest information or knowledge
and/or are innovative, they may be assessed for their correctness otherwise
and due marks be awarded to them. In class-X, while evaluating two
competency-based questions, please try to understand given answer and
even if reply is not from marking scheme but correct competency is
enumerated by the candidate, due marks should be
awarded.
The Marking Scheme carries only suggested value points for the answers. These
are in the nature of Guidelines only and do not constitute the complete answer. The
students can have their own expression and if the expression is correct, the due
marks should be awarded accordingly.
The Head-Examiner must go through the first five answer books evaluated by each evaluator
on the first day, to ensure that evaluation has been carried out as per the instructions
given in the Marking Scheme. If there is any variation, the same should be zero after
delibration and discussion. The remaining answer books meant for
evaluation shall be given only after ensuring that there is no significant variation in the
marking of individual evaluators.
Evaluators will mark ( √ ) wherever answer is correct. For wrong answer CROSS ‘X’ be
marked. Evaluators will not put right (✓) while evaluating which gives an impression
that answer is correct and no marks are awarded. This is most
common mistake which evaluators are committing.
If a question has parts, please award marks on the right-hand side for each part. Marks
awarded for different parts of the question should then be totaled up and written in
the left-hand margin and encircled. This may be followed strictly.

MS_X_Artificial Intelligence_402_89/S Page 1 of 11

 8. If a question does not have any parts, marks must be awarded in the left-hand
margin and encircled. This may also be followed strictly.
9. If a student has attempted an extra question, answer of the question deserving more
marks should be retained and the other answer scored out with a note “Extra
Question”.
10. No marks to be deducted for the cumulative effect of an error. It should be penalized
only once.
11. A full scale of marks (example 0 to 80/70/60/50/40/30 marks as given in
Question Paper) has to be used. Please do not hesitate to award full marks if the
answer deserves it.
12. Every examiner has to necessarily do evaluation work for full working hours i.e.,
8 hours every day and evaluate 20 answer books per day in main subjects and 25
answer books per day in other subjects (Details are given in Spot Guidelines).This
is in view of the reduced syllabus and number of questions in question paper.
13. Ensure that you do not make the following common types of errors committed by
the Examiner in the past:-
● Leaving answer or part thereof unassessed in an answer book.
● Giving more marks for an answer than assigned to it.
● Wrong totaling of marks awarded on an answer.
● Wrong transfer of marks from the inside pages of the answer book to the title
page.
● Wrong question wise totaling on the title page.
● Wrong totaling of marks of the two columns on the title page.
● Wrong grand total.
● Marks in words and figures not tallying/not same.
● Wrong transfer of marks from the answer book to online award list.
● Answers marked as correct, but marks not awarded. (Ensure that the right
tick mark is correctly and clearly indicated. It should merely be a line. Same is
with the X for incorrect answer.)
● Half or a part of answer marked correct and the rest as wrong, but no marks
awarded.
14. While evaluating the answer books if the answer is found to be totally incorrect, it
should be marked as cross (X) and awarded zero (0) Marks.
15. Any unassessed portion, non-carrying over of marks to the title page, or totaling
error detected by the candidate shall damage the prestige of all the personnel
engaged in the evaluation work as also of the Board. Hence, in order to uphold the
prestige of all concerned, it is again reiterated that the instructions be followed
meticulously and judiciously.
16. The Examiners should acquaint themselves with the guidelines given in the
“Guidelines for Spot Evaluation” before starting the actual evaluation.
17. Every Examiner shall also ensure that all the answers are evaluated, marks carried
over to the title page correctly totaled and written in figures and words.
18. The candidates are entitled to obtain photocopy of the Answer Book on request on
payment of the prescribed processing fee. All Examiners/Additional Head
Examiners/Head Examiners are once again reminded that they must ensure that
evaluation is carried out strictly as per value points for each answer as given in the
Marking Scheme.

MS_X_Infornation Tech._402_89/S Page 2 of 11

 MARKING SCHEME
INFORMATION TECHNOLOGY (SUB. CODE-402)
General Instructions :
1. Please read the instructions carefully.

2. This Question Paper consists of 21 questions in two sections : Section-A &

Section-B.

3. Section-A has Objective type questions whereas Section-B contains Subjective

type questions.

4. Out of the given (5 + 16 =) 21 questions, a candidate has to answer

(5 + 10 =) 15 questions in the allotted (maximum) time of 2 hours.

5. All questions of a particular section must be attempted in the correct order.

6. SECTION-A : OBJECTIVE TYPE QUESTIONS (24 MARKS) :

(i) This section has 05 questions.
(ii) Marks allotted are mentioned against each question/part.
(iii) There is no negative marking.
(iv) Do as per the instructions given.

7. SECTION-B : SUBJECTIVE TYPE QUESTIONS (26 MARKS) :

(i) This section has 16 questions.
(ii) A candidate has to do 10 questions.
(iii) Do as per the instructions given.
(iv) Marks allotted are mentioned against each question/part.

MS_X_Infornation Tech._402_89/S Page 3 of 11

 SECTION – A : OBJECTIVE TYPE QUESTIONS

1. Answer any 4 out of the given 6 questions on Employability Skills :

(1  4 = 4 marks)
(i) (B) To acknowledge and respond to the message. 1
(1 mark for correct answer)
(ii) (D) Maintaining a balance between life, work, and relaxation.
1
(1 mark for correct answer)
(iii) (B) An accountant working at a bank. 1
(1 mark for correct answer)
(iv) (C) Specific 1
(1 mark for correct answer)
(v) (A)To meet current needs without harming future generations' ability
to meet their needs. 1
(1 mark for correct answer)
(vi) (C) Operating System 1
(1 mark for correct answer)

2. Answer any 5 out of the given 6 questions : (1  5 = 5 marks)

(i) (B) Style 1
(1 mark for correct answer)
(ii) (A) Image 1
(1 mark for correct answer)
(iii) (C) Table of content 1
(1 mark for correct answer)
(iv) (B) Edit 1
(1 mark for correct answer)
(v) (D) Text Wrapping 1
(1 mark for correct answer)
(vi) (D) 7 1
(1 mark for correct answer)
MS_X_Infornation Tech._402_89/S Page 4 of 11
3. Answer any 5 out of the given 6 questions : (1  5 = 5 marks)
(i) (B) Subtotal 1
(1 mark for correct answer)
(ii) (A) Consolidate 1
(1 mark for correct answer)
(iii) (D) Comment 1
(1 mark for correct answer)
(iv) (D) $ 1
(1 mark for correct answer)
(v) (B) Goal Seek 1
(1 mark for correct answer)
(vi) (A) Record Changes 1
(1 mark for correct answer)

4. Answer any 5 out of the given 6 questions : (1  5 = 5 marks)

(i) (B) Form 1
(1 mark for correct answer)
(ii) (C) Datasheet 1
(1 mark for correct answer)
(iii) (D) Redundancy 1
(1 mark for correct answer)
(iv) (B) It is free and open source software 1
(1 mark for correct answer)
(v) (C) Charts 1
(1 mark for correct answer)
(vi) (B) Primary 1
(1 mark for correct answer)

MS_X_Infornation Tech._402_89/S Page 5 of 11

5. Answer any 5 out of the given 6 questions : (1  5 = 5 marks)
(i) (B) Something that can cause harm to people. 1
(1 mark for correct answer)
(ii) (D) Wear loose clothing or jewellery when working with machines 1
(1 mark for correct answer)
(iii) (C) Class C material 1
(1 mark for correct answer)
(iv) (B) Spending long hours on computers without breaks 1
(1 mark for correct answer)
(v) (B) Cleanliness of the workplace 1
(1 mark for correct answer)
(vi) (A) Physical hazard 1
(1 mark for correct answer)

SECTION – B : SUBJECTIVE TYPE QUESTIONS

Answer any 3 out of the given 5 questions on Employability Skills
(2  3 = 6 marks)
Answer each question in 20 – 30 words.
6. Non-verbal communication is the expression or exchange of information or
messages without using any spoken or written word.

2
Examples of non-verbal communication are Gestures, Expressions

(1 mark for correct definition + 1 mark for example)

7. Any four qualities of a successful entrepreneur are as follows : 2

(a) They are confident.
(b) They are hard working.
(c) They are patient.

MS_X_Infornation Tech._402_89/S Page 6 of 11

 (d) They are creative.
( ½ mark each for any four correct point)

MS_X_Infornation Tech._402_89/S Page 7 of 11

8. A computer can be protected against viruses by installing anti-virus
software and firewall, as anti-virus software and firewall monitor the
data coming in and going out of a computer and prevent the virus from
entering.
Anti-viruses can also detect a clean virus that may have entered a
computer. 2
(2 marks for the correct answers.)

9. Four simple stress management techniques are as follows : 2

(a) Time Management
(b) Physical exercise and fresh air
(c) Healthy diet
(d) Positivity
(½ mark for each correct technique.)

10. Importance of Sustainable Development

Economic development is using up resources of the world so quickly that
our future generations, the young people of the world, would have serious
environmental problems, much worse than those that we are facing at
present. With increasing population and income, the consumption of goods
is increasing day by day. This has led to increase in production and
utilisation of natural resources, which are required for producing goods.
Since most of the natural resources are scarce, therefore, careful utilization
of resource is necessary. 2
Society must thus change its development strategy to a new form where
development will not destroy the environment i.e. through sustainable
development. So sustainable development is extremely important to protect
the resources for future generations.
(2 marks for correct answer)

Answer any 4 out of the given 6 questions in 20 – 30 words each :

(2  4 = 8 Marks)
11. A template is a preset layout that helps to create professional and/or formal
documents easily. 2
In a template we can create and save defined headings, text formats, styles,
page numbers, headers and footers.
MS_X_Infornation Tech._402_89/S Page 8 of 11
 (1 mark for correct definition + 1 mark for correct explanation)

MS_X_Infornation Tech._402_89/S Page 9 of 11

12. An accident is an unplanned, uncontrolled, or unforeseen event resulting
in injury or harm to people and damages to goods. For example, a person
falling down and getting injured or a glassware item that broke upon being
knocked over. 2
Emergency is a serious or crisis situation that needs immediate attention
and action. For example, a customer having a heart attack or sudden
outbreak of fire in your organisation needs immediate attention.
(2 marks for correct difference)

13. A shared spreadsheet is a same sheet that can be accessed by more than
one user and can allow them to make changes simultaneously on it.
Advantages are : 2
 It saves the trouble of keeping track of multiple copies of the same
spreadsheet.
 Sharing allows working in collaboration so that everyone can
contribute, make changes and view it.
(1 mark for correct definition + ½ mark each for any two advantages)

14. An absolute hyperlink stores the complete location where the file is
stored. So, if the file is removed from the location, absolute hyperlink will
not work.
For example : C:\Users\ADMlN\ Downloads\[Link] is an absolute link as
it defines the complete path of the file. 2
A relative hyperlink stores the location with respect to the current location.
For example : Admin\Downloads\ [Link] is a relative hyperlink as it is
dependent on the current location and thus the folder admin is searched
where the active spreadsheet is being stored. If the complete folder
containing the active spreadsheet is moved the relative link will still be
accessible as it is bound to the source folder where the active
spreadsheet is stored.
(1 mark for correct definition of each)
MS_X_Infornation Tech._402_89/S Page 10 of 11
15. Data in a table can be arranged in ascending or descending order. This
process of arranging the records in particular order on any field is called
sorting. 2
There are two types of Sorting :
 Sort Ascending
 Sort Descending
(1 mark for correct definition + 1 mark for correct types)

16.  All things must be arranged properly. 2

 Any spilt liquid, food or other items such as paints must be
immediately cleaned to avoid any accidents.
 Make sure there is proper lighting and all damaged equipment,
stairways and light fixtures are repaired immediately.
(2 marks for any two ways)

Answer any 3 out of the given 5 questions in 50-80 words each :

(4  3 = 12 marks)
17. (a) Anchoring acts as a reference point for image or drawing. Anchoring
allows an image to retain its position to a page, paragraph, character
or frame whereas in Overlapping objects arrangement determines
the
position of the current drawing with respect to other drawings or text. 4

(b) Inverts the colour values of coloured images. In case the image is gray-
scale then its brightness is inverted.
(c) LibreOffice Writer allows grouping these different shapes, to behave
as a single entity without affecting their size and position. Once
grouped, all shapes belonging to that group become its member and
a change applied on one member works on all.
(2 marks for Anchoring and Arrangement)
(1 mark for Invert definition)
(1 mark for Grouping Drawing objects – definition)
MS_X_Infornation Tech._402_89/S Page 11 of 11
18. (a) A macro is a single instruction that executes a set of instructions.
These sets of instructions can be a sequence of commands or
keystrokes that can be used for any number of times later. 4
(b) The Rules for naming a Macro are :
(i) Begin with a letter
(ii) Not contain spaces
(iii) Not contain special characters except for _ (underscore)
(c) Steps 1  Click on Tools > Macros > Record Macro option.
Steps 2  Now start taking actions that will be recorded.
Steps 3  Once done, click on “Stop recording” button to stop the
recording of actions.
Step 4  Click on save button after selecting the object where the
macro to be saved.
(1 mark for Macro-definition)
(1 mark for any two rules)
(2 marks for Macro steps)

19. (a) The most important prerequisite for setting a relationship is that
there must be a common field(s) between the two tables to create a
relationship.

4
(b) Primarily three types of relationships can be set up between two tables
in a relational database.
(i) One-to-One
(ii) One-to-many
(iii) Many-to-Many
(c) In that case, LibreOffice base will display an error message and will
not allow to set the relationship between the two tables.
(1 mark for most important prerequisite)
(1 mark for number of types)
(1 mark for naming any two)
MS_X_Infornation Tech._402_89/S Page 12 of 11
 (1 mark for correct answer of c)

MS_X_Infornation Tech._402_89/S Page 13 of 11

20. (a) Ergonomics is the science concerned with designing and arranging
things so that people can use them easily and safely. Applying
ergonomics can reduce the potential for accidents, injury to improve
performance and productivity. 4
(b) To avoid this problem,
(i) Rest eyes periodically.
(ii) Do simple eye exercises
(c) Occupational overuse syndrome, also known as Repetition Strain
Injury (RSI), is a collective term for a range of conditions,
characterised by discomfort or persistent pain in muscles, tendons and
other soft tissues, with or without physical manifestations.
(1 mark for ergonomics definition)
(2 marks for any two ergonomically correct measures)
(1 mark for occupational overuse syndrome definition)

21. (a) The candidate keys are BID and NAME. 4

(b) The attribute BID can be used as the primary key as it can be used to
uniquely identify the records.

(c) The field PRICE should be currency data type as it indicates the
monetary values and can be stored using currencies of various
countries.

(d) In Boolean data type there can be only two values – True or False.

This also can be given in multiple formats like Yes/No, True/False,

On/Off. (1 mark for correct identification of Candidate Key)

(1 mark for correct identification of Primary Key)

(1 mark for correct explanation)

(1 mark for correct datatype definition)

MS_X_Infornation Tech._402_89/S Page 14 of 11