Class 10 Information Technology 402 Board Paper with Answer Key

Here is Class 10 Information Technology 402 Board Paper which was held in Board Examination 2024. Series #CD** Set-4 Q.P.Code 89 dated 13 March 2024. The Solution of question paper is given at the end.

Information Technology 

Time Allowed: 2 Hours

Maximum Marks: 50

General Instructions:

(i) Please read the instructions carefully.

(ii) This question paper consists of 21 questions in two Sections: Section A and Section B.

(iii) Section A has Objective Type questions, whereas Section B contains Subjective type questions.

(iv) 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.

(v) All questions of a particular section must be attempted in the correct order.

(vi) Section A: Objective Type Questions (24 marks):

(a) This section has 5 questions.

(b) There is no negative marking.

(c) Do as per the instructions given.

(d) Marks allotted are mentioned against each question/part.

(vii) Section B: Subjective Type Questions (26 marks):

(a) This section has 16 questions.

(b) A candidate has to do 10 questions.

(c) Do as per the instructions given.

(d) Marks allotted are mentioned against each question/part.

Class 10 Information Technology 402 Board Paper

Section A

(Objective Type Questions) (24 Marks)

1. Answer any 4 out of the given 6 questions on Employability Skills. 4×1=4

(i) The filename and filename extension are separated by a_________

(A) Dollar ($)

(B) Dot (.)

(C) Underscore (_)

(D) Hash (#)

 

(ii) Which of the following type of communication involves interchanging messages only through images or pictures?

(A) Verbal

(B) Gesture

(C) Visual

(D) Facial

 

iii) ______ is the ability to identify and manage one’s own emotions, as well as the emotions of others.

(A) Self-Awareness

(B) Emotional Intelligence

(C) Stress Management

(D) Emotional Barrier

 

(iv) _________ is the driving force that pushes us to achieve our goals, feel happy and improve our quality of life.

(A) Stress Management

(B) Self-Awareness

(C) Self-Growth

(D) Self-Motivation

 

(v) Which of the following is not an essential quality to become a successful entrepreneur ?

(A) Confidence

(B) Creativity

(C) Patience

(D) Wealthy

 

(vi) In total, how many SDGs were adopted by the United Nations in 2015 as a universal call to action to end poverty, protect the planet, and ensure that by 2030 all people enjoy peace and prosperity?

(A) 13

(B) 11

(C) 17

(D) 19

 

2. Answer any 5 out of the given 6 questions. 5×1=5

(i) Which of the following features allows one to apply a group of formats at the same time?

(A) Fill

(B) Styles

(C) Images

(D) Drag and Drop

 

(ii) In Writer, styles and formatting option is available under ______menu.

(A) Insert

(B) Tools

(C) Format

(D) Window

 

(iii) Gaurav is creating a report in Writer. The image gets embedded in his document whenever he drags and drops the image and the document size increases. Suggest a way to link the image file instead of embedding it.

(A) Drag and drop the image.

(B) Hold down the Ctrl key while dragging.

(C) Hold down the Shift key while dragging the image.

(D) Hold down the Ctrl and Shift key while dragging and dropping the image.

 

(iv) Resizing a ______ may badly affect the resolution of an image.

(A) Vector Image

(B) Raster Image

(C) CAD Image

(D) Coloured Image

 

(v) In Writer, you can create your own template in _________ way(s).

(A) One

(B) Two

(C) Three

(D) Four

 

(vi) In Writer, ________ function key is used to see the databases while implementing mail merge.

(A) F1

(B) F2

(C) F3

(D) F4

 

3. Answer any 5 out of the given 6 questions. 5×1=5

(i) While consolidating data, a cell range can be named using _________ option.

(A) Name range

(B) Define range

(C) Consolidate name

(D) Define name

 

(ii) Kawal and his friends are working on a Spreadsheet for entering data and updating records. They wish to keep a track of changes. Which of the following options will help in knowing who made the changes and what changes were done in the spreadsheet?

(A) View changes

(B) Record changes

(C) Store changes

(D) Track changes

 

(iii) _______ is a more elaborate form of Goal Seek.

(A) Database

(C) Report

(B) Hyperlink

(D) Solver

 

(iv) Macro functions can be written to behave as regular functions by writing a/an ________.

(A) Void

(B) Return

(C) Add-In

(D) Dim

 

(v) ________ option of Calc helps in viewing the changes made to a worksheet using original and edited worksheet.

(A) Edit →Revise document

(B) Edit → Consolidate

(C) Edit → Compare document

(D) Edit → Collaborate document

 

vi) In Calc, shared workbooks allow :

(A) Merging cells

(B) Conditional formatting

(C) Inserting pictures/graphs

(D) Adding text

Class 10 Information Technology 402 Board Paper

4. Answer any 5 out of the given 6 questions. 5×1=5

(i) In OpenOffice Base, the relationship applied on the tables can be removed with the help of _____ option.

(A) Clear

(B) Remove

(C) Drop

(D) Delete

 

(ii) In SQL, the keyword to display records in ascending order is:

(A) Asce

(B) Incr

(C) Asc

(D) High

 

(iii) _________ is a numeric data type which can store Yes/No type values in the form of 0 or 1 in OpenOffice Base table.

(A) Boolean

(B) Char

(C) Binary

(D) Other Object

 

(iv) Which of the following statement retrieves zero or more rows from one or more database tables or database views?

(A) UPDATE

(B) DELETE

(C) SELECT

(D) DISPLAY

 

(v) Roshni has created a table Customer in SQL and wants to store photograph image of every customer under Cust_photo field. Suggest a suitable data type from the options given below.

(A) IMAGE

(B) PICTURE

(C) LONGVARBINARY

(D) GRAPHIC

 

(vi) By default, all the fields in OpenOffice Base will have ______ datatype.

(A) int (tiny)

(B) Boolean

(C) text (varchar)

(D) text (char)

 

5. Answer any 5 out of the given 6 questions. 5×1=5

(i) A _______ is a discussion style website similar to an online personal diary, used for creating personal web pages.

(A) WWW

(B) Web

(C) Blog

(D) Chat

 

(ii) Natasha works as floor manager. She has been assigned a task for conducting regular _______ to ensure safety of life in case of any disaster or emergency by evacuating the place of danger.

(A) Cultural assembly

(B) Open house events

(C) Evacuation drill

(D) Trips and excursions

 

(iii)________ is an accessibility feature that assists people who have difficulty using a keyboard or a mouse (or both).

(A) Sticky keys

(B) Serial key

(C) Control key

(D) Toggle keys

 

(iv) Network in which all computers have equal status is called________.

(A) Peer-to-Peer architecture

(B) Central architecture

(C) Hierarchical architecture

(D) Client-server architecture

 

(v) ________are text files with small pieces of data like a username and password.

(A) Operating System

(B) Antivirus

(C) Cookies

(D) Modem

 

(vi) DSL stands for _______

(A) Digital System Line

(C) Digital Subscriber Line

(B) Data Subscriber Line

(D) Data Service Line

Class 10 Information Technology 402 Board Paper

Section B

(Subjective Type Questions) (26 Marks)

Answer any 3 out of the given 5 questions on Employability Skills in 20 – 30 words each.3×2=6

6. How can cultural differences be a barrier to effective communication?

7. Explain any two misconceptions about entrepreneurship.

8. Briefly discuss the significance of time management skills in order to succeed in life.

9. Very often we hear about spam mails. Explain what are spam mails, and what should be done with such mails.

10. Mention any two ways to get clean and affordable energy.

 

Answer any 4 out of the given 6 questions in 20-30 words each. 4×2=8

11. Write the main steps to group drawing objects in Writer.

12. What is the purpose of consolidating data in spreadsheets? Discuss briefly.

13. Differentiate between LAN and WAN.

14. What are the two parts of a cell reference while referencing data on other sheets? Explain with an example.

15. Give any two benefits of creating relationships between tables in a database.

16. Mention any two basic fire safety rules to be followed in any organization.

 

Answer any 3 out of the given 5 questions in 50-80 words each. 3×4=12

17. What is the concept of mail merge in word processing software? Discuss in detail. Also give any two major benefits of using mail merge.

18. Explain four types of hyperlinks that can be applied in spreadsheets.

19. Internet security is of prime concern nowadays. Using strong passwords can lower the risk of security breach on the Internet. Himanshi has just created her first Internet based account. Help her by giving any four general guidelines for managing strong passwords.

20. In context of OpenOffice Base, explain the concept and significance of the following:

(a) Forms

(b) Reports

 

21. Consider the table Product and write SQL queries for the following:

Table: Product

10 IT Table

 

(a) To display names of all products whose category is “domestic”.

(b) To display product name and price whose quantity is less than 50.

(c) To display price and quantity of Laptop.

(d) To display name and quantity of those products whose price is above 5000.

 

For Visually Impaired Candidates:

In the context of Database Management System, write a short note on the following:

(i) Database

(ii) Table

(iii) Field

(iv) Composite Primary Key

Class 10 Information Technology 402 Board Paper Solution

Section A: Objective Type Questions

1.

i) (B) Dot (.)

ii) (C) Visual

iii) (B) Emotional Intelligence

iv) (C) Self-Growth

v) (D) Wealthy

vi) (C) 17

2.

i) (B) Styles

ii) (C) Format

iii) (D) Hold down the Ctrl and Shift key while dragging and dropping the image.

iv) (B) Raster Image

v) (C) Three

vi) (C) F3

3.

i) (A) Name range

ii) (D) Track changes

iii) (D) Solver

iv) (C) Add-In

v) (C) Edit → Compare document

vi) (C) Inserting pictures/graphs

4.

i) (C) Drop

ii) (C) Asc

iii) (A) Boolean

iv) (C) SELECT

v) (C) LONGVARBINARY

vi) (C) text (varchar)

5.

i) (C) Blog

ii) (C) Evacuation drill

iii) (A) Sticky keys

iv) (A) Peer-to-Peer architecture

v) (C) Cookies

vi) (B) Digital Subscriber Line

Section B: Subjective Type Questions

6. Cultural differences can be a barrier to effective communication by influencing language, gestures, and norms, creating misunderstandings and hindering mutual understanding.

7. Two misconceptions about entrepreneurship are that it’s only about making money and that entrepreneurs are risk-takers without careful planning.

8. Time management skills are crucial for success as they enhance productivity, reduce stress, and allow individuals to prioritize tasks effectively.

9. Spam mails are unsolicited and often harmful emails. They should be marked as spam, not opened, and reported to the email provider.

10. Two ways to get clean and affordable energy are investing in renewable sources like solar or wind power and promoting energy efficiency in daily activities.

Answer any 4 out of the given 6 questions in 20-30 words each. 4×2=8

11. Steps to group drawing objects in Writer:

– Select objects

– Right-click, choose Group

– Use the Group option under the Format menu.

12. Consolidating data in spreadsheets combines information from multiple sources for better analysis and understanding of overall trends.

13. LAN (Local Area Network) is for limited geographic areas, while WAN (Wide Area Network) spans larger regions, connecting multiple LANs.

14. Cell reference parts:

– Sheet name

– Cell address (e.g., A1)

Example: ‘Sheet2’.B3

15. Benefits of creating relationships between tables:

– Avoid data redundancy

– Ensure data consistency and accuracy.

16. Basic fire safety rules:

– Know evacuation routes

– Use fire extinguishers responsibly

– Avoid blocking exits.

Answer any 3 out of the given 5 questions in 50-80 words each. 3×4=12

17. Mail merge in word processing combines a document with a data source for personalized content. Benefits include time-saving and reducing errors in mass communication.

18. Types of hyperlinks in spreadsheets:

– URL links

– Document links

– Email links

– Cell links.

19. Guidelines for strong passwords:

– Use a mix of letters, numbers, and symbols

– Avoid common words

– Update passwords regularly

– Use unique passwords for each account.

20. OpenOffice Base concepts:

(a) Forms: Input interface for entering data.

(b) Reports: Summarized presentation of data.

21. SQL queries for Product table:

(a) SELECT PNAME FROM Product WHERE CATEGORY=’DOMESTIC’;

(b) SELECT PNAME, PRICE FROM Product WHERE QUANTITY < 50;

(c) SELECT PRICE, QUANTITY FROM Product WHERE PNAME=’LAPTOP’;

(d) SELECT PNAME, QUANTITY FROM Product WHERE PRICE > 5000.

For Visually Impaired Candidates:

Database Management System concepts:

(i) Database: Collection of organized data.

(ii) Table: Structured representation of data.

(iii) Field: Data element within a table.

(iv) Composite Primary Key: Combination of multiple fields as the primary key.

By cbsepython

A complete solution for the students of class 9 to 12 having subject Information Technology (402), Computer Science (083). Explore our website for all the useful content as Topic wise notes, Solved QNA, MCQs, Projects and Quiz related to the latest syllabus.

Copywrite © 2020-2024, CBSE Python,
All Rights Reserved