Dyal Singh Public School D S Colony, Karnal

Pre Board Examination (2022-23)

Class X Subject Information

Technology

Roll Number Maximum Marks 50

Date of Exam 21 January, 2023 Maximum Time 2 Hours

Number of printed pages - 6

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.

Page 1 of 6
 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. What are the ABC of stress Management? 1
(a) Avertible, Belief, Consequences
(b) Adversarial, Being, Control
(c) Adversity, Belief, Consequences
(d) Adversity, Belief, Control
ii. Which of the below is not a step of Effective Time Management 1
(a) Organize
(b) Prioritize
(c) Control
(d) Remember
iii. Things we need a mouse for 1
(a) Hover, Point and click, turn on, Typing
(b) Roll over, Drop and Drag, Double click, Typing
(c) Drop and Drag, Hover, Turn on, Double Click
(d) Hover, Point and click, Drag and Drop, Double Click
iv. Akash wanted to build his shoe business. He doesn’t have money, so he borrowed money 1
from his family and the bank. After 2 years, he paid off all the debts. He is
(a) Diligent
(b) Decisive
(c) Composed
(d) All of the above
v. Name the two types of employment 1
(i) Self-Employment (ii) Individual Employment
(iii) Wage Employment (iv) Group Employment
(a) Both i and iii
(b) Both ii and iii
(c) Both ii and iv
(d) Both I and iv
vi. An operating system is a software that serves as an interface between 1
(a) user and computers
(b) server and computer
(c) computer and network
(d) computer without CPU

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

i. Name the device that converts digital signal to analog that can travel over phone lines. 1
a. Router
b. Server
c. TP-Link
d. MODEM
ii. Mention any two integer data types of a table field in database. 1
a. TINYINT
b. BIGINT
c. LARGEINT
d. LITTLEINT

Page 2 of 6
 iii. Name the relationship in which one column of the primary key table is associated with all the 1
columns of the associated table and vice versa.
a. One to Many or Many to one
b. Many to Many or All to Many
c. Many to all All to Many
d. One to all or All to One
iv. A is a what if Analysis tool that allows you to substitute set of values 1
automatically in a worksheet?

a. Navigator c. Scenario
b. Subtotal d. Goal Seek
v. Which category of styles will you click to set the font size and size of text in a 1
paragraph.
a. Format Style c. Character Style
b. Paragraph style d. List Style
vi. TOC contains all the entries as 1
a. Objects c. Item
b. Combined d. Blank

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

i. controls how graphics are stacked upon each other or relative to the text. 1
a. Arrangement c. Alignment
b. Anchoring d. Wrapping
ii. A is the formatted result of database queries and contains useful data for 1
decision –making and analysis.
a. Query c. Report
b. Database d. Forms
iii. key is an accessibility function which is designed for people who have 1
vision impairment or cognitive disabilities.
a. Filter Key c. Total Key
b. Sticky Key d. Toggle Key
iv. To repeat the graphic across the entire background area, we need to select option in 1
word processor.
a. Tile c. position
b. stretch d. area
v. function takes data from a series of worksheets or workbooks and 1
summaries it into a single worksheet that you can update easily.
a. Scenario c. Data format
b. Data Consolidation d. Data chart
vi. Which of the following is more elaborate form of Goal Seek? 1
a. Subtotal c. Scenario
b. Solver d. Consolidate

Page 3 of 6
Q. 4 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. Networks in which certain computers have special dedicated tasks, providing services to 1
other computers (in the network) are called networks
a. Peer-to-Peer
b. Client/Server
c. Server
d. Client
ii. It is possible to customize Table of Content 1
a. True
b. False
iii. When a primary key is applied to one or more columns, then it is known as 1
a. Foreign Key c. Candidate Key
b. Composite Key d. Alternate key
iv. is an accessibility feature, which can be used to change the size and color of 1
fonts and the background for ease of viewing.
a. Sticky Keys c. Show Sound
b. High Contrast d. Toggle Keys
v. The cell reference in a spreadsheet for cell range B2 to F15 is 1
a. B2:F15 c. B2.F15
b. B2;F15 d. B2-F15
vi. A hyperlink in a spreadsheet can be 1
a. Text c. Both a and b
b. Picture d. None of these

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

i. In which mode we can change the structure of the table 1
a. Datasheet view c. Structure view
b. Design view d. All of these
ii. Which of the following is an offline blog editor developed by Microsoft? 1
a. BlogDesk
b. Qumana
c. Windows Live Writer
d. Marsedit
iii. In a spreadsheet, comments can be added to the cells by clicking on 1
a . Insert>Comment c. Review>New Comment
b. View>Add Comment d. None of these
iv. represent a single data item in a table. 1
a. Tuples c. Databse
b. Attributes d. All of these
v. The image can directly be inserted into a Writer document if is 1
connected to the computer.
a. printer c. mouse
b. OSR d. scanner
vi. Which of the following is a threat to the Internet security? 1

a. Spamming b. Hacking c. Phishing d. All of these

Page 4 of 6
 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.
Q. 6 All people look forward to vacations for de-stressing and rejuvenation. State any other two 2
ways by which people can manage stress.
Ways for stress management(any two):
i. Physical exercise - Physical exercise in the form of walking, skipping or any sports
relieves stress by stabilizing mood, improving self -esteem and inducing sleep.
ii. Yoga - Yoga includes a series of postures and breathing exercises practiced to achieve
control of body and mind.
iii. Meditation – By meditation, an individual is able to focus his/her mind to achieve a
calm mental state reducing stress.
iv. Enjoying - Recreational activities such as watching movies, attending concerts, playing
games singing, dancing, sketching etc help individuals transcend to a happier mental
state and help manage stress.
Nature walks - Taking nature walks brings us a calmness by allowing our over stimulated
minds a chance to relax and helps us to relax ( ½ mark for point, ½ for explanation)
Q. 7 How the ‘Ability to work independently’ can be enhanced. Give any two reasons 2
Self-Awareness Having conscious knowledge of your own self, capabilities, feelings and
one’s own character
Self-Motivation Individuals have an inner urge to do something, achieve their goals without
any external pressure.
Self-Regulation Self-regulation guides independent individuals as it helps them consider
long term consequences .any 2
Q. 8 How can a file/folder be copied using keyboard? 2
A file/ folder can be copied using keyboard by following the given steps:
a. Select the file or the folder.
b. Press Ctrl + C to copy the file or the folder.
c. Open the destination folder.
d. Press Ctrl + V to paste the copied file.
Q. 9 Discuss the role of entrepreneurs as ‘Innovators‘ and as ‘Agents’. 2
Innovators - Entrepreneurs innovate by bringing unique and new products and services into
the market. In many cases, these are improved versions of existing products or services
available. Innovation fuels economic growth and helps to boost global presence of products
and services.
Agents - Entrepreneurs act as ‘Agents of Change’ as they identify opportunities, solve
problems, offer effective solutions, establish enterprises, set up industries and bring positive
change for the economy.
Q. 10 Give any two reasons as to why an individual should strive for becoming a job creator 2
instead of a job-seeker and opt for entrepreneurship as his/her career.
Significance of Entrepreneurship as career: (any two points)
i. Nurtures development of entrepreneurial skills and capabilities.
ii. Enables application of an entrepreneurial mindset.
iii. Develops the ability to handle failure and ambiguity.
iv. Enhances critical thinking and problem solving ability.
v. Provides early exposure to the real world.
Inspires to think about one’s career differently vii. Leads to creating difference in
society.

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

Q. 11 Define the following: 2
a. Anchoring
Anchoring refers to the reference point for the graphics. This point could be page, or
frame where the object is, a paragraph, or even a character.
Page 5 of 6
 b. Text Wrapping
Text wrapping is making the text reflow along the boundaries of the frame or the object.
The text flows around the image.

Q. 12 What are Macros? How can we record a Macro? 2

Macros are small programs that record our actions as we perform a task in spreadsheet
software. When we run the Macro later, it repeats the keystrokes and thus actions. Macros
are stored in the same workbook in which it was created.

It helps in saving time in cases when same set of tasks are to be done repeatedly like
formatting or applying similar formula in similar range of data

To record macro follow the following points:

● Tools>Macros>Record Macro. Will start a macro recorder. The RecordMacro
Dialog box appears with a stop recording button.
● When done with, Click Stop Recording to stop macro recorder.

Q. 13 Differentiate between relative and absolute hyperlink. 2

● Relative Hyperlink: A relative hyperlink contains a partial address, which is relative
to the address of the destination file. Relative linking is only possible when both the
source and destination files are on the same drive or location. Example: \Rose.jpg
● Absolute Hyperlink: An absolute hyperlink is a hyperlink that contains the full
address of the destination file or web page. Example: C:\Users\IT\Rose.jpg

Q. 14 Identify the columns and data types of a table: Airlines. Mention at least four columns with 2
data type
Columns Data type
Flight No Text
No.of Passengers Integer
Airlines Text
Arrival Time Date/Time
Departure Time Date/Time
Fares Float
Q. 15 Mahima was bored after class X board exam, she thought of chatting with her friend 2
Rehman. What kind of messaging service will you suggest her? Suggest her 3 rules and
etiquettes to be followed while chatting online.
She should use Instant Message Sevices for chatting with he r friend.
Some rules and etiquettes to be followed while chatting.
● Message should be short and to the point.
● Always introduce yourself by name.
● Always ask if the other person has time to chat first.
● In a business environment, know exactly what you want to discuss.
● Typing your messages in uppercase is extremely rude.
● Give people time to respond.
● Wherever possible, give the person you are communicating with your undivided
attention.
● It's important to properly end and IM conversation. (any three)
Q. 16 Rahul has purchased some stationary items from an online site. He has to make online 2
payment for the items to complete the transaction. Help by answering his following queries.
a. Suggest any two options that he can use to make payment of his bill on the online
shopping website.
b. Name any 2 popular online transaction websites.
a. credit, debit card or by internet banking etc
b. Flipkart , amazon, Myntra etc
Page 6 of 6
Answer any 3 out of the given 5 questions in 50– 80 words each (4 x 3 = 12 marks)
Q. 17 Rishita a new to spreadsheet software. She was unable to some calculations, help her 4
by guiding her the following:
a. What is the use of subtotals feature?
Subtotal is a function listed under Mathematical category. It is used for generating
subtotals to summarise data. It helps to manage, analyse, and extract specific information
from the rows of selected data.
Or
Subtotal feature generates a total of the rows of related data.
b. How to open subtotals feature in Openoffice calc?
Data>Subtotal.
c. What is difference between sum and autosum feature?
Sum can calculate the sum of contiguous and non-contiguous cells whereas Auto
sum can calculate the sum of only contiguous cells.
d. Name two common functions available in subtotal dialog box?
Sum, Max, Min, Count, Average, Product, etc (any two)
Q. 18 Consider the following table: Payroll 4
Emp_Id Name Department Salary

E001 Shweta Accounts 45000

E002 Sonali Sales 48500

E003 Uday Sharma Accounts 35000

E004 Krishna Sales 0

1. Display name and department of employees with salary more than 40,000
Select Name, Department from Payroll where salary>40000;
2. Update the salary of the employee with id E004 as 35000
Update Payroll set Salary = 35000 where Emp_Id = ‘E004’;
3. Display the name, salary and bonus of all employees. The bonus is calculated as
10% of the salary
Select Name, Salary, Bonus(Salary*10%) from Payroll;
4. What will be the primary key of the table
Emp_id
Q. 19 Explain main steps of Mail Merge in digital documentation. How is it useful inprinting 4
mailing labels?
1. In a blank document, Click on the Mailing tab and in the Start Mail Merge group click
Start Mail Merge.
2. Click Step-by-Step Mail Merge Wizard.
3. The first step is Select the starting document(We will select Letter)
4. Second step of the Wizard is Select Recipients(We will create a new database)
5. Third step is to write the letter and add custom field.
6. Fourth step is Click Preview Your Letter.
7. Fifth step is Complete Nerge.
8. And the last step is click Print or Edit Individual Letter.

Mail merge is useful in printing mailing labels as it saves time and efforts. As once the
data source is saved than that can be easily used when and where required. Producing
mass mailing labels in much simplified way, especially compared to the process of
preparing individual labels for so many people.
Page 7 of 6
Q. 20 Sudheer is not clear about the use of a database. Explain him the following 4
to give him a better understanding of the DBMS concepts.
a. Describe any four advantages of DBMS.
1. Improved data sharing
2. Improved data security
3. Increase consistency
4. Data is more reliable
5. Increase data integration
6. Reduce data redundancy
7. Increased Privacy
8. Backup and recovery of data(any four)
b. Define the following:
i) ISP
ISP stands for Internet Service Provider. It is an organization that
provides services to access the Internet via dial –up, direct or wireless
conncection.
ii) Hotspot
It is a place from where we can use internet. These places can be
restaurants, hotels, airports, railways, etc. It can be free or sometimes fee-
based.
Q. 21 Rahul and Amit are working on a school project assigned to them by their teacher. They have 4
to send instant messages to each other and also do video conferencing after school hours in
order to complete the project on time.
a. Suggest any 4 good instant messaging software that they can use.
b. Apart from computers, list 4 hardwares that Rahul and Amit need for videoconferencing.
a. Google Talk , Yahoo! Messenger , Skype , Windows Live Messenger , Rediff Bol, MS-
Teams, ZOOM etc.
b. Headphone/Speaker ,Microphone, Web Camera, Internet connection/MODEM

Page 8 of 6