OUR OWN HIGH SCHOOL, DUBAI
INFORMATION TECHNOLOGY
CLASS X SAMPLE PAPER TERM2 2024-2025
Max. Time Allowed: 2 Hour Max. Marks: 50
Date: -
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 must 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.
SECTION A - OBJECTIVE TYPE QUESTIONS (24 MARKS):
1. This section has 05 questions.
2. Marks allotted are mentioned against each question/part.
3. There is no negative marking.
4. Do as per the instructions given.
SECTION B – SUBJECTIVE TYPE QUESTIONS (26 MARKS):
1. This section has 16 questions.
2. A candidate has to do 10 questions.
3. Do as per the instructions given.
4. Marks allotted are mentioned against each question/part.
SECTION A: OBJECTIVE TYPE QUESTIONS
Q. 1 Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)
i. Which organization has made the Sustainable Development Goals. 1
(a) United Nations
(b) League of Nations
(c) UNICEF
(d) World Health Organization
ii. According to the concept of sustainable development, the environment and 1
development are _________issues.
a) Inseparable b) Separate c) Independent d) None of these
iii. How can an anti-virus protect your device? 1
(a) It can protect it from over-heating.
(b) It can increase its performance.
Page 1 of 6
(c) It can prevent data from getting corrupt.
(d) It can backup data.
iv. From the following statements, which one is not correct about the Qualities of 1
an Entrepreneur?
a. Successful entrepreneurs adapt the habit of hard work from a very early stage.
b. Entrepreneur should not think optimistically about the future of the business.
c. Confident entrepreneur must not deviate from his/her decisions too early in
case success is delayed.
d. Entrepreneurs like to function at their own will and rules.
v. Srishti is a young woman who makes earrings. She buys jute from a farmer and 1
makes earrings from that. She sees that most women in her village do not work. So,
she hires two women to help her. As her orders increase, she hires three more
women to work for her. How was she helping her village grow?
(a) By selling earrings to women without a job
(b) By purchasing earrings from the local market
(c) By buying jute from the local farmer and by providing jobs to local women
(d) By attracting the women in her village with her creative earrings
vi. According to the concept of sustainable development, the environment and 1
development are _________issues.
a) Inseparable b) Separate c) Independent d) None of these
Q. 2 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. ….……….. controls all aspects of a paragraph's appearance, such as text alignment, 1
tab stops, line spacing, and borders, and can include character formatting.
(a) Page Style (b) Character Style (c) Frame Style (d) Paragraph Style
ii. Krish and Kritika have done a survey of age wise literacy rates of their locality as a 1
school project, which they have created in a Spreadsheet. They both want to work
simultaneously to complete it on time. Which option they should use to access the
same Spreadsheet to speed up their work.
Page 2 of 6
a) Consolidate Worksheet b) Shared Worksheet
c) Link Worksheet d) Lock Worksheet
iii. Arguments passed to a Macro from calc are always ____________ 1
a. strings b. references c. numbers d. values
iv. Which type of relationship exists between a student and the subjects they study in 1
a database?
a. One to one b. One to Many c. Many to Many d. All of the above
v. Aditya wants to create a connection between two or more tables. Suggest her the 1
option to accomplish the task.
a) Table b) Form c) Relationships d) Sorting
vi. In Calc, You can use a cell reference in one or several formulas to refer to: 1
a) Data from one or more contiguous cells on the worksheet
b) Data contained in any Software
c) Data contained in format in database
d) Images in picture gallery
Q. 3 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. ……………. feature of Calc helps to track what data was changed, when the change 1
was made, who made the change and in which cell the change has occurred.
(a) Record Changes b) Edit record (c) Change record (d) Macro
ii. Richard needs to set up a network for his office where he wants to save all the data 1
in a centralized system and other computers will take the services from the
centralized system. Which architecture will be the best suitable for him?
a) Peer to Peer b) Client-Server
c) Point to Point d) Ring
iii. __________is specifically designed to minimize or maximize the result according to 1
a set of rules that you define in a spreadsheet.
a) Goal Seek b) Scenario
c) Solver d) Subtotal
Page 3 of 6
iv. Rohit scored 25 out of 30 in English, 22 out of 30 in Maths. He wants to calculate the
score in IT he needs to achieve 85 percent in aggregate. Suggest him the suitable
1
option out of the following to do so.
a)Macro b) Solver c) Goal Seek d) Sub Total
v. The details associated with an entity is called __________ 1
(a) Table (b) Attribute (c) Records (d) Primary Key
vi. In Calc, you can use a cell reference in one or several formulas to refer 1
a) Data from one or more contiguous cells on the worksheet.
b) Data contained in any Software.
c) Data contained in any format in databases
d) Images in picture gallery
Q. 4 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. ___________ can be set for a field if the user doesn't provide any value while 1
entering the values in the table.
a) Required b) Default c) Primary Key d) Format
ii. Reviewers and authors can add their ______ to explain their changes in the cell of 1
Spreadsheet.
a. Comments b. Worksheet
c. Hyperlink d. Macros
iii. In database _________ helps us to retrieve the filtered data based upon some 1
conditions.
a) Forms b) Reports c) Queries d) Table
iv. Rohan has Rs.50,000 that he wants to invest in two mutual funds for one year. 1
Fund A is a low risk fund with 18% interest rate and Fund B is a higher risk fund
with 21% interest rate. Which feature of spreadsheets (Calc) will be help him to
decide?
a) Solver b) subtotal c) Linking sheets d) Macros
v. A ____ is a model that you use to create other documents. 1
a) Styles b) Template c) Wizard d) Sample
vi. …………….. clause can be used with the SELECT statement in SQL to specify which 1
rows to retrieve from the table.
(a) WHERE b) GROUP (c) SAME (d) SIMILAR
Q. 5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. A ______ hyperlink contains the full address of the destination file or web page. 1
a. Relative b. Absolute c. Mixed d. Address
Page 4 of 6
ii. It refers to a cell or a range of cells on a worksheet and can be used to find the 1
values or data that you want formula to calculate.
a. Row b. Column
c. Auto sum d. Cell Reference
iii. Networks in which certain computers have special dedicated tasks, providing 1
services to other computers (in the network) are called _____ network.
a. hierarchical b. dedicated server c. peer to peer d. client serer
iv. Which of the following options can be used to add images to a document? 1
a. Libre Office Gallery b) Insert an Image from file c) Scanner d) All of
the above
v. When you apply a ____________, you apply a group of formatting effects together in 1
one single step.
a. Effect b. Style
c. Template d. Format
vi. In a document, __________ refers to the vertical or horizontal placement of a 1
graphic in relation to the chosen anchor point.
a. Arrangement b. Anchoring
c. Alignment d. Text Wrapping
SECTION B: SUBJECTIVE TYPE QUESTIONS
Answer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6 marks)
Answer each question in 20 – 30 words.
Q6 List any two factors causing ecological balance 2
Q7 Differentiate between files and folders 2
Q8 Mention any two misconceptions about the Entrepreneurship 2
Q9 In our daily life we can contribute to create a Sustainable Society by following 4R’s 2
and 1U of Sustainability. Explain any one term out of 4Rs’ and 1U.
Q10 Give any two promotional functions of an entrepreneur. 2
Answer any 4 out of the given 6 questions in 20 – 30 words each (2 x 4 = 8 marks)
Q11 Differentiate Forms and Report 2
Q12 What is Referential Integrity? Explain its two(any) purposes. 2
Q13 What are the four settings control the positioning of an image. Explain each. 2
Q14 Explain What-if Scenarios spreadsheets. 2
Q15 Why do we need to merge worksheets? 2
Page 5 of 6
Q16 Explain the options available when accepting or rejecting changes in Libre Office 2
Calc.
Answer any 3 out of the given 5 questions in 50– 80 words each (4 x 3 = 12 marks)
Q17 What do you mean by Hyperlinks in Spreadsheets? Explain 4 types of Hyperlinks 4
that can be applied in spreadsheets.
Q18 Explain any 4 image filters in Libre office writer. 4
Q19 What do you understand by custom styles in LibreOffice writer? 4
Q20 Distinguish between the following with respect to spreadsheets: 4
a) Relative and absolute hyperlink b). Internet hyperlink and Document Hyperlink
Q21 a) Consider the following table: 4
B) Consider the following table. Product
(a) You are tasked with designing a new product database for your company. Based
on the given table structure, identify the fields that would be necessary to store
key information about each product.
(b) As a database administrator, you need to ensure each product has a unique
identifier. Which field in the table would you choose as the primary key, and why?
(c) During a review of the product database, you realize there could be another
field apart from the primary key that can uniquely identify a record. Identify the
field and justify why it could serve as an alternate key.
(d) You are integrating the product table with another table that stores company
details. Explain how you would use the primary key from the product table and a
foreign key in the company table to establish a relationship between the two
tables. Illustrate with an example.
Page 6 of 6