PRE BOARD EXAMINATION (2024-25)

SUBJECT -INFORMATION TECHNOLOGY (402)

CLASS X
Max. Time: 2 Hours Max. Marks: 50

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. All questions of a particular section must be attempted in the correct order.
5. SECTION A- OBJECTIVE TYPE QUESTIONS (24 MARKS):
(i) This section has 05 questions each with sub parts.
(ii) Marks allotted are mentioned against each question/part.
6. SECTION B- SUBJECTIVE TYPE QUESTIONS (26 MARKS):
(i) This section has 16 questions.
(ii) A student has to do 10 questions.
(iii) Marks allotted are mentioned against each question/part.

SECTION A- OBJECTIVE TYPE QUESTION

Q.1 Answer any 4 out of the given 6 questions on Employability Skills (1*4=4 marks)

i. There are many reasons why interpersonal communications may fail. While communicating,
the message may not be received exactly the way the sender intended and therefore it is
important that the communicator seeks........... to check that their message is clearly understood.
a. Description​ ​ b. Feedback​ ​ c. Channel​ ​ d. Sign

ii.................refers to focusing human efforts for maintain a healthy body and mind, capable of
withstanding stressful situations.
a. Artificial Intelligence​ ​ ​ b. Stress management ​ ​ ​ ​
c. Motivation ​ ​ ​ ​ ​ d. Emotional Intelligence

iii. Which of the following is not true for entrepreneurs

a. They create needs and demands ​​ b. They provide raw materials
c. They do not create jobs ​ ​ d. They help society by supporting infrastructure development

iv. Which of the following is not a barrier to effective communication?

a. Physical barrier ​ ​ ​ ​ b. Linguistic barrier
c. Interpersonal barrier ​ ​ ​ d. Subjective barrier

V. A computer automatically runs a basic program called........... as soon as it is switched on or

the power button is pushed on.
a. BIOS(Basic Input/Output System) ​ b. IOS(Input/Output System)
c. BOSS(Basic on System Startup) ​ ​ d. POS(Power On System)
vi Give any one method that we can adopt to promote Sustainable Development.

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

i. The styles created to affect numbered lists and bulleted lists are…….styles
a. List style ​ ​ b. Paragraph style ​ ​ c. Frame style ​ d. Character style

ii. How many levels of headings does Open Office evaluate to build the Table of Contents?
a. 8 ​ ​ ​ b. 9 ​ ​ ​ ​ c. 10 ​ ​ ​ d. 12

iii. In writer,..............refers to reference point for the graphics. This point could be the page or
frame where the object is, a paragraph or even a character.
a. Arrangement ​ ​ b. Anchoring ​ ​ c. Framing ​ ​ [Link] wrapping

iv. Which feature allows you to jump to a different document, spreadsheet, or website from
within a document?
a. Bookmark​ ​ ​ b. Page Break ​ c. Hyperlink ​ ​ d. Format Painter

v. Which mode is used to apply a style to many different areas of a document quickly without
going back to styles and formatting window in writer? ……………………..

vi. Writer creates a new document, unless specified otherwise, using a ………..template.
a. Default ​ ​ ​ ​ ​ ​ ​ b. Last saved ​​ ​ ​
c. Template stored in a special directory ​ ​ ​ d. None of these

Q.3 Answer any 5 out of the given 6 questions (1*5=5 marks)

i...............function takes data from a series of worksheets or workbooks and summaries it into a
single worksheet that you can update easily.
a. Summation ​​ b. Data consolidation ​​ c. Data Format ​ d. Data Chart

ii.............can be used in Calc to jump to a different location from within a spreadsheet and can
lead to other parts of the current file, to different files or even to websites.
a. Tables ​ ​ b. Goal Seek ​ ​ ​ c. Auto Sum ​ ​ d. Hyperlinks

iii Usually, you run a formula to calculate a result based upon existing values. By contrast,
using ........... , you can discover what values will produce the result that you want.
a. Subtotal ​ ​ b. Scenario ​ ​ ​ c. Sort Lists ​ ​ d. Goal Seek

iv. In Calc, to create the reference with the mouse:

a. Both spreadsheets need not to be open ​ ​ ​ c. Cell reference is not required​
b. Select the cell in which the formula is going to be entered d. there is no need of ‘=’ symbol ​

v. Macros are especially useful to ……………. same way over and over again.
a. repeat a task ​ ​ b. reject a task ​ c. report a task​ d. comment a task
vi............... feature of Calc helps to track what data was changed, when the change was made,
who made the change and in which cell the change has occurred.
a. Record changes ​ ​ b. Edit record ​​ c. Change record ​ [Link]

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

I. A row that represents a single, data item in a table is known as ________________

ii. When primary key constraint is applied on one or more columns then it is known as ________

[Link] of the following is the default extension of the database file?

a. Odb ​ ​ b. Ods​​ ​ c. docx ​ ​ ​ d. odt

iv. Identify which of the following is a programming Language?

(a) Calc ​ ​ (b) BASIC ​ ​ (c) Writer ​ ​ (d) Macro.

v. Which of the following is the default name of the Macro

(a) Default ​ ​ (b) Main ​ ​ (c) Macro1 ​ ​ (d) Main_Macro

vi. Which of the following statements are true about primary key in a database?
a. It is a field that can have duplicate values ​ b. It uniquely identifies each record in a table
c. It can have null values ​ ​ ​ d. It is an optional field in a database table

Q5. Answer any 5 out of the given 6 True/False questions (1*5=5 marks)

i. A table can be created without a primary key.

ii. Two tables can be related in a network data model.
iii. We can insert data from a table created on a web page into a spreadsheet.
iv. Table of Contents can be inserted even if the section headings are not styled.
v. Consolidate function cannot be used to view and compare data.
vi. All documents in Writer are based upon templates.

SECTION B: SUBJECTIVE TYPE QUESTIONS

Answer any 3 out of the given 5 questions on Employability Skills: (2*3=6 marks)
Q6. Define any 4 elements of communications. (2 Marks)
Q7. Why has United Nations had made the 17 Sustainable Development Goals? (2 Marks)
Q8. What are the functions of Entrepreneurs? (2 Marks)
Q9. Define any 2 threats to computer. (2 Marks)
Q10. What are some stress management techniques? (2 Marks)

Answer any 4 out of the given 6 questions: (2*4=8 marks)

Q11. What do you mean by customization of TOC? (2 Marks)
Q12. What is the purpose of consolidating data in spreadsheets? Explain briefly. (2 Marks)
Q13. Give one point of difference between (2 Marks)
(a) Data and Information,
(b) Form and Query,
Q14. Explain the term sorting. (2 Marks)
Q 15. What are the two parts of a cell reference while referencing data on other sheets? Explain
with an example. (2 Marks)
Q 16. How is linking of an image different from embedding? Give a situation in which you would
prefer to link an image. (2 Marks)

Answer any 3 out of the given 5 questions: (4*3=12 marks)

Q17. Write advantages of using Style over manual formatting for designing a document. (4
Marks)
Q18. Anshita is preparing spreadsheet notes for her Term Exam. Help her to write short note
on the following: (4 Marks)
i. Scenarios​ ii. Goal Seek ​​ iii. Solver​ ​ iv. Subtotal
Q19. How is fill format useful for applying styles. (4 Marks)
Q20. Explain characteristics of RDBMS. (4 Marks)

[Link] the table given below and answer the questions that follow:

Book_id Book name Author_Name Price Publisher

F001 Pride and Jane Austen 550 ABC

Prejudice

SOO4 Amazing [Link] 1050 ABC

Astromony

COO5 IT and Mankind MHA Diwan 2500 HYM

a. Name the fields in the given table. (1 Marks)

b. Which fields should be made the primary key? (0.5 Marks)
c. Is there any alternate key in the table? (0.5 Marks)
d. How is primary key different from foreign key? Explain with example. (2 Marks)