PALLADIUM SCHOOL

PRE BOARD-1 EXAMINATION (2024-25)

SUBJECT: INFORMATION TECHNOLOGY GRADE – X
Date:28.12.2024 Max. Marks: - 50
Name of Student: - Duration: 2 Hours

General Instructions:
1.​ This Question Paper consists of 21 questions in two sections: Section A & Section B.
2.​ Section A has Objective type questions whereas Section B contains Subjective type questions.
3.​ All questions of a particular section must be attempted in the correct order.
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. When it is difficult to communicate with someone who is not willing to talk or 1

express their feelings and views, it means there is a/an ___________________.
a.​ Cultural Barrier b. Interpersonal Barrier
c. Physical Barrier d. Language Barrier

ii. ______________ is the driving force that pushes us to achieve our goals, feel happy 1
and improve our quality of life.
a.​ Stress Management​ b. Self awareness
c. Self-growth d. Self-motivation

iii. The filename and filename extension are separated by a _______________. 1

a.​ Dollar ( $ )​ b. underscore ( _ ) ​ c. Dot (.)​ d. Hash (#)

iv. Which of the following is not an essential quality to become a successful 1

entrepreneur?
a.​ Confidence b. Creativity c. Patience d. Wealthy

v. Which organization has adopted the Sustainable Development Goals. 1

a. UNICEF b. League of Nations
c. United Nations d. World Health Organization

vi. A _____________ operating system is a computing environment that reacts to input 1

within a specific period of time.
a.​ Single-user​ b. Real time
c. Multi-user d. Distribute

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

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

ii _____________ is particularly useful when creating a watermark or when wrapping 1

the image in the background in a document.
a.​ Transparency b. Fill c. Filters d. Crop

iii A ________________ is a model that you use to create other documents.

a.​ Document b. Copy-Paste c. Design d. Template
 iv What is the shortcut key of Style and Formatting option in writer window?
a.​ F2​ b. F5 c. F11 d. F8

v _________________ controls how graphics are stacked upon each other or relative to
the text.
a.​ Arrangement b. Alignment c. Anchoring d. Wrapping

vi TOC contains all the entries as ____________.

a.​ Objects b. Hyperlinks c. Labels d. Items

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

i. Which of the following is a more elaborate form of Goal seek? 1

a.​ Subtotal b. Scenario c. Solver d. Consolidate

ii. To ________________ the comment, hover the mouse pointer over the cell that has 1
the comment.
a.​ Edit b. View c. Hide d. None

iii. What is the benefit of inserting an image as a link in a document? 1

(a) It reduces the document size by storing only the reference to the image.
(b) It enhances the image quality.
(c) It allows for automatic image editing within the document.
(d) It removes the need for image captions.

iv. Which step should you follow before using the Subtotal command? 1
a.​ Consolidate Data b. Sort Data
c. Filter Data d. Auto fill Data

v. In a formula in Calc , = SUM( Total Sale!B4:D4) ____________ indicates the source 1

sheet.
a.​ SUM​ b. B4​ c. D4​ d. Total Sale

vi. Radha is planning a school event and wants to decide how much money to allocate for 1
different activities, like games, food, and decorations. She creates several different
budget plans to see how changing the amount for each category affects the total
expenses. How can Radha efficiently compare the different budget plans for her
school event in the same spreadsheet?
(a) By writing down each budget on paper
(b) By using the What-if scenario feature in the spreadsheet to create and analyze
different budget options
(c) By asking her friends to guess the costs
(d) By using the Filter function to look at one category at a time

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

i. A foreign key is a reference of the __________ key in another table. 1

a.​ Alternate b. Primary c. Candidate d. All of these

ii. Geetha wants to know the basic building blocks of the database. Suggest the 1
appropriate option.
a. Forms b. Queries c. Tables d. Report
iii. Kalpesh wants to store city names in one of the fields for his table in the database. 1
Which of the following data types will be useful for him?
a. Boolean b. Integer c. Varchar d. Binary

iv. Which of the following dialog boxes appears when the Query Design window is 1
opened for the first time to design a query?
(a) Add Table (b) Add Query (c) Add Report (d) Add Form

v. Write the full forms of: 1. SQL 2. RDBMS 1

vi. A teacher is entering data to maintain records of each student. There are many fields 1
for which values can be entered later as these fields are not required to be filled
urgently. Whereas Admission number and student name are mandatory fields.
Therefore teachers want to apply a property so that during data entry, these two fields
must be necessarily filled in before moving to the next record entry. Which field
property has to be set?
a.​ Default​ b. Entry Required
c. Format d. Primary Key

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

i. A school has a network connecting all the computer labs for sharing Printer and file 1
transfers. Which type of network are they using?
a.​ PAN b. WAN c. MAN d. LAN

ii. Which of these is a type of emergency that requires evacuation? 1

a.​ Fire b. Explosion c Floods d. All of these

iii. Which of the following is a recommended way to manage stress at work? 1

(a) Engage in aggressive conflicts with colleagues
(b) Work longer hours without breaks
(c) Seek conflict resolution strategies with colleagues
(d) Avoid hobbies that promote relaxation

iv. Which of the following can cause hazards while using computers? 1
a.​ Poor sitting posture or excessive duration of sitting in one position
b.​ Lifting heavy objects
c.​ Mishandling of tools and equipment
d.​ Improper handling of office equipment

v To provide a healthy and safe working environment, every organisation must have 1
__________________.
a.​ Cleanliness b. Filtered Water c. Clean wash-room d. All of the above

vi A _______________ is an unplanned event that may happen all of a sudden and may 1
lead to unwanted or unexpected results.
a.​ Emergency b. Hazard c. Accident d. Illness
 SECTION B: SUBJECTIVE TYPE QUESTIONS

Answer any 3 out of the given 5 questions (2 x 3 = 6 marks)

Answer each question in 20 – 30 words.
Q. 6 What are two primary ways in which written feedback helps to facilitate learning? 2

Q. 7 Very often we hear about spam mails / spam calls. Explain what these are and what 2
should be done with such mails / calls?

Q. 8 During a team meeting, Sarah is explaining a complex project idea to her 2

colleagues. She speaks too quickly, uses jargon, and doesn’t pause for questions.
As a result, her team seems confused, and the project isn’t fully understood. What
can Sarah do to improve her verbal communication skills?

Q. 9 Give any two promotional functions of an entrepreneur. 2

Q. 10 What is the difference between development and sustainable development? 2

Answer any 4 out of the given 6 questions in 20 – 30 words each (2 x 4 = 8 marks)

Q. 11 In Open Office Writer, what are the styles? List two Open Office Writer style 2
options.

Q. 12 In a database, why is it important to create relationships between the tables? Write 2

steps to create a relationship between two tables.

Q. 13 Guneet has completed his assessments in four subjects and received the following 2
marks: 75 in Math, 68 in Science, 82 in English, and 70 in History. The student
needs to achieve an overall aggregate of 75% across all five subjects to meet his
academic goals. He still has to take the exam in the fifth subject, which is
Geography. Which Calc tool and menu option can he use to check how many
marks he has to score in the 5th subject to get the required percentage?

Q. 14 Riya, a Class X student, feels stressed with her exam preparation, extracurricular 2
activities, and family commitments. How can tracking time help her?

Q. 15 Define the term First-Aid. Also provide some first aid tips. 2

Q. 16 What is TOC? List characteristics of a good TOC in writer. 2

Answer any 3 out of the given 5 questions in 50– 80 words each (4 x 3 = 12 marks)
Q. 17 Anshita is preparing some notes for her Term Exam. Help her to write short note on 4
the following:
i. Scenarios ii. Find and replace
iii. Grouping of objects iv. Subtotal
Q. 18 A Class X student is participating in a school competition where they need to analyse
the performance of different sports teams based on match scores and statistics. The
student has collected data over several matches and needs to calculate averages,
determine rankings, and generate charts for a presentation.
a) How are Macros in Calc helpful to him?
b) How to enable Macro in Calc?
c) Is solution*word a valid macro name? Justify
d) Mention any one operation which cannot be recorded by macro.

Q. 19 Differentiate between: 4
1.​ Relative and Absolute Hyperlink
2.​ Column and Table Constraints
3.​ Form and Report
4.​ Candidate Key and Alternate Key

Q. 20 a.​ What is the difference between a low-risk and high-risk workplace? 2

b.​ Mention any 4 tips for healthy living of working people. 2

Q. 21 David is working in a renowned software company as a trainee. He is handling a 4

database containing a table named Employee. Data stored in the table is as follows:

ID NAME DESIGNATION DOB SALARY

EP20132 Neha Aggarwal Manager 12/14/1980 52000

EP20133 Deepak Kaushik Manager 10/4/1982 50000

EP20134 Meenakshi Accountant 9/5/1985 35000

Malhotra

EP20135 Arvind Kumar Editor 3/30/1978 30000

EP20136 Rahul Singh Executive 9/20/1990 25000

Help him in doing the following tasks (Write SQL Commands):

a.​ He wants to find the employee’s name whose ‘SALARY ‘ is equal to 50000
or more. help him in writing the query to get the same record.
b.​ He is trying to calculate the yearly salary of an employee whose ‘SALARY’
is 25000. Help him in writing the query to do so.
c.​ He wants to display ‘ID’, ‘NAME’, and ‘DESIGNATION’ of the employees
to ‘Chief Editor’ whose current designation is ‘Editor’.
d.​ Write the no. of tuples and attributes of table Employee.

********************
Answers:
Q 1.
i. b. Interpersonal Barrier
ii. d. Self-motivation
iii. c. Dot (.)​
iv. d. Wealthy
v. c. United Nations
vi. b. Real time

Q 2.
1 c. 10
2 a. Transparency
3 d. Template
4 c. F11
5 d. Wrapping / a. Arrangement
6 b. Hyperlinks

Q3.
1 c. Solver
2 b. View
3 a) It reduces the document size by storing only the reference to the image.
4 b. Sort Data
5 d. Total Sale
6 b) By using the What-if scenario feature in the spreadsheet to create and analyze different budget options

Q 4.
1 b. Primary
2 c. Tables
3 c. Varchar
4 (a) Add Table
5 Structured Query Language, Relational Database Management System
6 b. Entry Required

Q5.
1 d. LAN
2 d. All of these
3 (c) Seek conflict resolution strategies with colleagues
4 a. Poor sitting posture or excessive duration of sitting in one position
5 d. All of the above
6 c. accident
Q 6. The two primary ways in which written feedback helps to facilitate learning are as follows:
(i) Written feedback provides concrete explanations for grades received. The person gets on opportunity
to reflect on and understand the specific reason for their current level of achievement.
(ii) It provides a bridge from current performances to future performance by understanding how they are
performing now, and how they can improve their performance in their next assessment, whether in the
same course or different course.
Q 7. Sometimes, we get mails from companies who are advertising a product or trying to attract us to their
website. Such mails are called spam mails. We should do the following actions with such mails:
(i) We should never respond to spam mails and delete them on a regular basis.
(ii) We should set filters to prevent spam from entering the mail box in the settings. Most e-mail software
have a spam folder which automatically put all such emails into this folder.
Q 8. Think Before You Speak • Think about your topic. • Think about the most effective ways to make
your listeners understand the topic. • Write or note down whatever you plan to say. Concise and Clear •
Speak clearly, loudly and at moderate speed. • Be sure the information you want to share is to the point. •
Do not repeat the same sentences. Confidence and Body Language • Be confident. • Maintain eye contact,
stand straight and be attentive. • Be friendly
Q9. Promotional functions of an entrepreneur are as follows: ​
(i)​ Discovery of Idea: The first and foremost function of entrepreneur is idea generation. Ideas can be
generated through several ways like own experience and exposure. of entrepreneur, keen observation of
environment, education, training, market survey and so on. ​
(ii)​ Detailed Investigation: Entrepreneur should investigate commercial feasibility of the product
proposed to be produced and conduct market study to ascertain the potential demand for the product.
Q10. pic
Q11. A Style is a collection of all formatting information, which you want to save and then apply on the
document. Writer provides six Style categories – Page, Paragraph, Character, Frame, List and
Table.(Mention any two)
Q 12 While working with multiple tables, you need to check the redundancy and inconsistency of data. The
record for a particular entity should neither be repeated nor different data values should appear for a single
entity in the database. This is done by setting relationships between the tables of a database.
Q13. Tools > Goal Seek
Q14. Tracking time helps to: ● Identify time-wasting activities and unproductive habits ● Improve time
management for studies and tasks ● Balance academics with extracurriculars and personal time ● Allocate
time for relaxation and self-care ● Achieve academic goals more efficiently and reduce stress before exams
Q15. First aid is the immediate and basic assistance provided to the injured person to save life and
minimise health loss till the proper medical aid/ facility is provided. Some first aid tips are as follows: (i)
Reassure the injured so that they remain calm and do not panic. (ii) Keep the injured warm and comfortable
if they are under shock.
Q16. . The Table of Contents is a snapshot of the headings and page numbers in our document and does not
automatically updates itself as we make changes. It acts as a map for the users. A good Table of Contents
has the following characteristics: (i) It should be easy to read and simple to use. (ii) It should be organised
and formatted properly. (iii) It must be accurate and easily accessible. (iv) It should be given after the title
and copyright page.

Q 17 a) Repetitive tasks like calculating average scores, ranking teams based on performance, and
generating graphs could be done with macros. It will save time and effort.
b) Tools > Options > LibreOffice > Advanced. Observe the Optional Features. Two options are not check
marked. Put the checkmark on the option “Enable macro recording”
c) No, solution*word is not a valid macro name. Macro names cannot include special characters such as
asterisks (*) or spaces. Valid characters typically include letters, numbers, and underscores.
d) Opening or switching of windows