SECTION A: OBJECTIVE TYPE QUESTIONS

Q. 1 Answer any 4out of the given 6questions on Employability Skills (1x4 =4 marks)
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. Culture Barrier b. Interpersonal Barrier c. Physical Barrier d. Language
Barrier
ii.
Kartik's Computer was running very slow, hangs and often restarts. He is very 1
confused and tensed as he was working on a very important assignment. Kartilk's
friend gave him the following suggestions. Identify who has given him a genuine
suggestion.

a. Radha : Restart your machine

b. Ishan : Install reliable antivirus software and update
c. Amar: Don't use Pendrive
d. Sam: Install free antivirus from net
ii. refers to focusing human efforts for maintaining a healthy body and mind 1
capable of better withstanding stressful situations.

a. Self-Motivation b. Stress Management c. Self-Awareness d. Self-Regulation

iv. High expectations from self can leave with chronic anxiety and stress, thus leading
to stress.

a. Physical b. Emotional c. Mental d. Financial

V. Which of the following is/are a myth about Entrepreneurship ? 1

a. Need a lot of Money b. Must have a great ldea

c. Should know everything about business d. Allof these
vi. Name the organization that has the Sustainable Development Goals ? 1

a. UNICEF b. League of Nations

c. United Nations d. World Health Organization

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

i. Which one is not the tab of the insert/index Table window of Writer Document? 1

a. Entries b. Background c. Style d. Row

ii In the custom styles, each field on the Structure line represents a
blank space in a document.

a. Black b. White c. Blue d. Yellow

iii. Saurabh has made an advertisement in Digital [Link] is facing difficulty in 1
positioning the images within the text. Suggest him how he can adjust the image?
a. Wrap text b. Crop C. Alignment d. Layout

402 -Information Technology -Class X Page 3 of 6

iv. is a collection of records that store data in Mail merge. 1

a. Data Source b. Main Document c. Document d. Merge Field

To increases the contrast of an image, option is used in a document. 1

a. Smooth b. Sharpen c. Aging d. mosaic

vi. provide Internet access by transmitting digital data over wires of a local 1
telephone network.
a) ISP b) DSL c) Dial-up connection d) Modem

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

i. is specifically designed to minimize the results according to a set rules 1
that we define in a spreadsheet.

a. Goal Seek b. Scenario C. solver d. Subtotal

Sahil and his partners have created a list of their company employees in one of the
spreadsheets in the office. Now the rest of the task they want to complete from
home. Which option they should use to access the same Spreadsheet from home?
a. Consolidate Worksheet b. Link Worksheet
c. Merge Worksheet d. Lock Worksheet
iii can help to clarify the relation between cells while using "Multiple 1
Operations".

a. Detective [Link] c. Navigation d. Hyperlink

ldentify the part of a Spreadsheet using which a user can manage multiple sheets. 1

a. Status Bar [Link] Tab c. Formula Bar d. Worksheet Area

V.
Spreadsheet software can find the changes by sheets. 1

a. Changing b. Comparing C. Renaming d. Editing

vi. Atthe bottom of each worksheet, left tab indicates the of the 1
worksheet in a workbook.

a. Size b. 3 Type c. Name d. Color

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

i. It enables Users to view, enter, and change data directly in database objects. 1

a. Report b. Query C. Form d. Database

ii. There are types of Relationships in a table of a database. 1

a, One b. 3 C. 4 d. Many
ARelational database uses commands which is astandard user 1
application that provides an easy programming interface for database interaction.
a. Access b. Python C. SQL d. Protocol

402 - Information Technology - Class X Page 4 of 6

 iv.
Surajwants to create a data base for his clients. For this purpose, she needs to 1

store the Email lDs of his clients. Which datatype should he use to accomplish this
purpose?

a. Numeric b. Varchar c. Binary d. Boolean

V.
Geet has written aSQL guery inSQL view. But he doesn't know how to execute the 1
query using keyboard keys. Suggest him the shortcut key to complete the task.
a. Enter b. Ctrl +E c. Space bar d. F5
vi. A
table can have only primary key in adatabase. 1

a. 1 b. 2 C. 3 d. Many

Q. 5 Answer any5 out of the given 6 questions (1 x5=5 marks)

key is an accessibility feature that assists people having difficulty in 1

using keyboard and mouse.

a. Guide b. Sticky c. Serial d. Home

ii. Anaisha is awildlife photographer. She wants to create her website where she can
update the pictures and discuss about different events, reviews, announcements,
news etc. Suggest her a suitable option to complete the task.

a. Blog b. E-Mail c. Instant Messaging d. Mail Merge

iii. Which of the following is not a web browser? 1

a. Safari b. Internet Explorer c. Google d. FirefoX

Which out of the following is the best example of a strong password? 1

a. 9412356789 b. 14Hd{$ Sb10 c. HarryPotterSeries d. 140ct2004

V.
Bharat has set up his company with 20 computers in a building. He wants to
connect allthe computers together. Which type of Network will be the best
suitable for this purpose?

a. LAN b. WAN c. PAN d. MAN

vi. IP stands for

a. International Protocol b. Internet Protocol

c. Intranet Protocol d. Interpersonal Protocol

SECTION B: SUBIECTIVE 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 What are the learning objectives of communication?
Q. 7 Why do we say that an entrepreneur should be open-minded? 2
Q. 8 How is self-regulation connected to the ability to work independently? 2

402 - Information Technology - Class X Page 5 of 6

0.9 How we can prevent computer against attack by viruses. 2
Q. 10 "Green economy promotes sustainable development". Justify the statement. 2

Answer any 4 out of the given 6 guestions in 20- 30 words each (2 x4 =8marks)
Q. 11 What do you understand by Anchoring in Word Processor? 2
Q. 12 What do you mean by Sorting in a Spreadsheet? 2
Q. 13 State any four etiquettes to be followed while chatting on the internet. 2
Q. 14 How is Goal Seek different from Solver in a Spreadsheet? 2
Q. 15 Differentiate between a Primary key and Foreign key. 2
Q. 16 What is the importance of healthy lifestyle? Give any four points related to it. 2

Answer any 3 out of the given 5 questions in 50-80 words each (4 x 3 = 12 marks)
Q. 17 What do youunderstand bythe term Table of Contents? List the characteristics of a
good 'Table of content' in a word processor.
Q. 18 Explain the term 'Scenarios' in relation to the Spreadsheets with example. 4
Q. 19 Explain different kinds of online threats. 4
Q. 20 Explain the term "Referential Integrity". Why is it important in a database?
0. 21 Consider the following Vendor table and write the queries for the following:

Table Datesheet
Sub_code Sub_Name DateofExam Days
E001 English 11-03-2021 Monday
HO02 Hindi 15-03-2021 Friday
SO03 Social Sci. 18-03-2021 Monday
SO04 Science 21-03-2021 Thursday

i. Write a SQL command to display the records in ascending order by date of exam.
ii. Write aquery to display the above date sheet.
iii. Write a query to display the subject name and date of the exam held on 'Monday'
iv. Write a SQL command to display the date of exam and Sub Name of Science
subject.

For visually impaired candidates.

Write a short note on the following:

i) DBMS
ii) Database Server
ii) Data Integrity
iv)Record

402- Information Technology - Class X Page 6 of 6

 CBSE DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOL0GY (SUBJECT CODE- 402)
MARKINGSCHEME FOR CLASS X(SESSION 2024-2025)
Max. Marks: 50
Max. Time: 2 Hours
General Instructions:
1. Please read the instructions carefully.
questions in two sections - Section A&Section B.
2 This Question Paper consists of 21
Section Bcontains Subjective type questions.
3. Section Ahas Objective type questions whereas 10 =) 15 questions in the
4 given (5 + 16 =) 21 questions, a candidate has to answer (5 +
Out of the
allotted (maximum) time of 2 hours.
must be attempted in the correct order.
5 Allquestions of a particular section
QUESTIONS (24 MARKS):
6. SECTION A - OBJECTIVE TYPE
This section has 05 questions.
ii There is no negative marking.
Do as per the instructions
given.
ii
against each question/part.
ivMarks allotted are mentioned
(26 MARKS):
7 SECTIONB- SUBJECTIVE TYPEQUESTIONS
questions.
i This section contains 16
Acandidate has to do 10 questions.
given.
ii Do as per the instructions
mentioned against each question/part.
iv Marks allotted are

QUESTIONS
SECTION A: OBJECTIVE TYPE
Marks
QUESTION
No.
1
Q. 1
collaboration and productivity.
(b) Enhancing team 1

ii. (b)Emotional
1

(a) Makes decisions 1

iv. (c) Self-motivation 1

V
(c) United Nations 1
details only on safe websites
Vi. (b)Give credit card or bank
1
0.2
formatting information
i. (b) Acollection of all
1

1
ii. (b) $c$5
1
(c) Type deleted
particular author only can be
(b)A comment of a from all regional sheets 1
function to combine information
iv
V (b) By using the Consolidate
into one summary sheet. 1
vi. (b)no lumbar support
1
Q,3
Page 1 of 5
d).ods
 i. (b) Ctrl+Shift+N 1

i. (d) Frame Style 1

iv. (a)Anchoring 1
V. c) format*word 1

vi. (a) Health 1

Q.4
1
|i. (b) Hyperlink
ii. (d) Mail merge 1
1
ii. (a) Joint Photographic Experts Group
1
iv. (b) Attributes
1
v. (d) Ergonomic
1
vi (a)>
Q.5
1
(c) Design view
1
(c) To retrieve specific data
1
ii (d) It can accept only fixed number of records
1
iv. (a) liabilities
1
V. (d)space heaters 1
vi. (a) Keeping emergency exits clear

SECTION B: SUBIECTIVE TYPE QUESTIONS

QUESTION Marks
0. No.
0.6 Feedback helps you understand if your work aligns with group expectations, identifies areas 2
for improvement, and ensures the project meets its goals effectively.
0.7 Entrepreneurs run their businesses in a market. The market has people who buy products 2
land services and people who sell them also. When people are buying and selling from each
other, it is helpful for everyone because everyone involved makes money. This is how
entrepreneurs help in growing the area and society they live in.
0.8 If we have been using acomputer for a long time we have a lot of unnecessary files and data, 2
such as temporary files and images. When they use too much hard-disk space, the
performance of the computer goes down. It is important that we keep cleaning by removing
any extra files. We can use some disk cleaner software, which help us clean up the
unnecessary files.
0.9 Some steps to manage emotional intelligence are as given below. 2
Understand your emotions: Observe your behaviour and note the things you need to
work on. Youcan then work on the things you need to improve.
Rationalise: Do not take decisions abruptly; be rational in your thinking.
Practise: Do meditation and yoga to keep yourself calm.
Q.10 Individuals can contribute to a sustainable future by reducing waste, conserving energy,
supporting eco-friendly products, recycling, using sustainable transportation, and spreading
lawarenessabout environmental issues topromote responsible consumption and
conservation of resources.
Q.11 Following steps for Creating a Custom Style Named 'myStylel' Using Drag-and
Drop:
i. Open the Styles and Formatting sidebar in LibreOffice Writer.
ii. Right-click on an existing style that is similar to the desired 'myStylel' or start
with the default style.
ii. Modify the formatting (.g, font, size, color) using the toolbar or sidcbar options.
iv. Drag and drop the modified style onto the Styles and Formatting sidebar under
402 -Information Technology -Class X
Page 2 of 5
 the Custom Styles' section to crcate 'myStylel".
Q.12 i. Slips, Trips, and Falls: Caused by wet floors. loose cables, or cluttercd
walkways.
i. Electrical Hazards: aulty wiring, overloaded circuits, or exposed electrical
components.
ii. Manual Handling Injuries: Strains and sprains from lifting heavy objects
improperly or without assistancc.
(Mention any two)
Q.13 It is used to explore and compare various altermatives depending on changing 2

conditions. It can be used in the beginning of any project to optimise the output. This
tool is used to predict the output while changing the inputs which reflects the output
and thus one can choose the best plan of action based on it.
2
Q.14 Merging Spreadsheets combines data from multiple spreadsheets into asingle sheet,
often consolidating or integrating information.
Comparing Spreadsheets involves analyzing differences between two spreadsheets,
highlighting discrepancies in data or structure.
Q.15 Referential Integrity ensures that relationships between tables in a database remain
consistent. It means that a foreign key in one table must match aprimary key in
lanother table. or be null, to maintain accurate and valid links between related data.
2
0.16 Potential Cause:Glares from overhead lights or windows eye glasses not correct
need vision check
Precaution: Re-orient your desk and computer so light is not directly behind or in
front of you.
Q.17 Imagine you are preparing a series of school reports that need to include your school's 4
logo, apicture of your project, and a standard footer with your name and class. Instead
of adding and formatting these clements individually in cach report, you usc
LibreOffice Writer templates to simplify this process.
[Link] can we apply the template from the available template list?
Ans:
1. Go to File > Templates > Manage Templates.
2. In the Templates dialog box, you will see a list of available templates.
3. Select the desired template, (say T1) and click Open button. The new document
(with name as Untitled) will be opened with the same content, appearance and
formatting effects as the saved template
[Link] the desired changes and save the file.

[Link] is exporting of templates useful?

Ans: Exporting templates is useful when you want to:
Share Templates: Exporting allows you to share templates with colleagues
or others who may need to use the same document formats, styles, or
layouts.
Backup Templates:Creating backups of templates ensures you have
copies in case of software updates, changes, or data loss.
Transfer Templates: Exporting templates allows you to transfer them
between different computers or installations of LibreOffice,ensuring
consistency across multiple devices or users.

Q.18 Imagine you are a student organizing a fundraising event for your school club. You
have a spreadsheet in LibreOffice Calc that lists donations from different sponsors.
Each sponsor has contributcd multiple times, andyou nced to summarize the total
402- Information Technology-Class X Page 3 of 5
 amount donated by each sponsor.
a. Which tool in Calc can be used to create the group automatically?
Ans: In LibreOffice Calc, the tool that can be used to create groups
automatically is Subtotals
b. Which functions can be applied to the grouped data?
Ans: The Subtotal tool in Cale creates the group automatically and applies
common functions like sum, average on the grouped data.
c. Which menu option is used to apply this Tool?
Ans: Data>Subtotals
d. What is purpose of e (-)or (+) signs on grouped data?
Ans + sign to expand and - sign to collapse the data.
Q.19 A database can be designed in different ways depending on the data being stored. This 4

data
structure of database is known as data model that describes the manner in which
components for describing the
will be stored and retrieved. A data model consists of
data, relationships among them and the constraints that hold data.
There are different data models such as:
Hierarchical Data Model In this model the data is organized into a tree like structure
same master file. It
Network Data Model In this model, multiple records are linked to
inverted tree where master is present in the bottom of the tree
is also considered as an
and the branches contain information linked to the master.

Relational Data Model This data model is based on the The principle of setting
two or more tables of the same database. data elements are
relationships between
different tables
stored in different tables made up of rows and columns. The data in
fields. So, relations are set between tables
are related through the use of common relational database
That is why this model is termed as
based on common fields.
model 4
Q.20 Approaching the accident
"Never rush into an accident situation.
"Call 108 as soonas possible.
Approach the accident place cautiously.
Examining the scene
" Visually examine victims to determine if they are in contact with energised conductors.
" Metal surfaces, objects near the victim itself may be energised.
" Do not touch the victim or conductive surfaces while they are energised.
" Switch off the electrical circuits if possible.
Hazards and solutions
" Be alert for hazards, such as heated surfaces and fire.
In case you cannot switch off the power Source, take extreme care.
Ensure that your hands and feet are dry.
Wear protective equipment, such as gloves and shoes. Stand on a clean dry surface.
Use non-conductive materialto remove a victim from the conductor
High voltage rescue
"Special training is required for rescues if high voltage is present.
Protective equipment, such as gloves and shoes must be worn.
Apply First Aid
" Give CPR if required
olf the victim is breathing and has a heartbeat, give first aid for injuries and treat for shock.
" Ensure the victim gets medical care as soon as possible.
Physician attending thevictim must havedetailed information to properly diagnose and
care for the victim.
Q.21 Consider the following table: Employee
402-Information Technology -Class X Page 4 of 5
 Emp id Name Salary Designation
E01 Kajal 78000 Manager
E02 Rahul S0000 Sales Executive
EO3 Tarun 55000 Clerk

a. Ans: Emp id, Name,Salary, Designation

b. Ans: Emp id
C. Ans :Combination of Emp id and Name
d. Primary Key: Unique identifier for each row in a table, cannot be NULL.

Example: Emp_id in Employees.

Foreign Key: Links to a primary key in another table, establishing
relationships.
Example: Emp_id in Orders referencing Emp_ id in Employees