CBSE Class 10 Information Technology Question Paper 2023 Compartment with Answer Key, Download Now!

Class 10 – Information Technology Code 402 | CBSE Skill Education

CBSE Board Question Paper 2023 Compartment with Answer Key

QP Code 089/1/4

INFORMATION TECHNOLOGY

Time allowed: 2 hours
Maximum Marks: 50

General Instructions:

• 1) Please read the instructions carefully.
• 2) This question paper consists of 21 questions in two sections: Section A, and 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.
• Section – B: Objective 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.

SECTION – A
(Objective-Type Questions)

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

(i) _____ is the ability to work independently.
(a) Motivation
(b) Self-awareness
(c) Self-reliance
(d) Adaptability

(ii) Identify the situation/thing which leads to mental stress among children.
(a) Stress due to change of Principal of school
(b) Stress due to examination grades
(c) Stress due to problems in friend’s family
(d) Stress due to waking up in the morning

(iii) _______ is a type of operating system that runs on a set of computers that are interconnected by a network.
(a) Multi-user
(b) DOS
(c) Single
(d) Distributed

(iv) Which keys do you press to copy a file or a folder?
(a) Ctrl + X
(b) Ctrl + C
(c) Ctrl + Z
(d) Ctrl + Y

(v) State whether the following statement is True or False:
“There is a direct relationship between entrepreneurship and society.”

(vi) Which of the following is an example of entrepreneurship?
(a) A cook working in a restaurant
(b) A mechanic who owns a garage for repairing vehicles
(c) A doctor working in a hospital
(d) A teacher teaching in a school

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

(i) ______ includes margins, headers and footers, borders, and backgrounds.
(a) Character Style
(b) Page Style
(c) Numbering Style
(d) Frame Style

(ii) Pushkar has created a drawing using multiple shapes that are arranged in a particular position and manner in his document. Suggest a feature that can be used to let the objects remain set as a collection.
(a) Transparency
(b) Posterize
(c) Grouping drawing objects
(d) Ordering drawing objects

(iii) Mehul has inserted images in his document report “Travel My State” to make it more descriptive. Some of the images are having some extra part that needs to be removed. Which of the following option is suitable to do the task?
(a) Resize
(b) Crop
(c) Recolor
(d) Rotate

(iv) Suresh has been assigned a task to create multiple documents such that the first page of every document contains the company’s name and logo in a particular style. Which feature of word processor can be used to complete the task quickly?
(a) Cell styles
(b) Image
(c) Template
(d) Table of Contents

(v) Writer’s ________ feature lets you build an automated index from the headings in your document.
(a) Header
(b) Styles
(c) Table of Contents
(d) Template

(vi) To protect the table of contents from being changed accidentally, check the _ check box.
(a) Protected against manual changes
(b) Allow only manual changes
(c) Manual changes
(d) Password

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

(i) A statistical formula can be applied to a selected array of cells using __.
(a) Consolidate
(b) Goal seek
(c) Subtotal
(d) Autosum

(ii) Which of the following term refers to a cell or range of cells that can be used in a formula?

(a) Cell Reference
(b) Cell Formula
(c) Formula Reference
(d) Linked Cells

(iii) How many sheets are provided by default in spreadsheets in a workbook?

(iv) Give an example of statistical function in Calc.

(v) Record changes feature of Calc marks a deleted column or row in a worksheet by a _____.

(a) red border over the cell
(b) green border over the cell
(c) red shade in the cell
(d) heavy colored bar

(vi) _ is a saved sequence of commands or keystrokes that are stored for later use.

(a) Record Changes
(b) Compare Changes
(c) Merge
(d) Macro

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

(i) A _ is a database object that provides a systematic way to accept data from the user and store it in a table of a database.

(a) Query
(b) Form
(c) Report
(d) Table

(ii) Primary Keys are also _ in the database, making it faster for the database to search for a record.

(a) indexed
(b) defined
(c) duplicated
(d) replicated

(iii) Record uniqueness in a table helps to avoid accidental _ of records caused by user or computer error.

(a) duplication
(b) key
(c) deletion
(d) removal

(iv) Data in RDBMS is organized in _.

(a) files
(b) tables
(c) text related only
(d) linked through network

(v) Binary data types are used for storing data in _.

(a) integer format
(b) character format
(c) text format
(d) binary format

(vi) _ means that the query uses criteria you provide to hide some data and present only what you want to see.

(a) Indexing
(b) Sorting
(c) Filtering
(d) Relating

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

(i) _ is an accessibility function that tells the keyboard to ignore brief or repeated keystrokes, making typing easier for people with hand tremors.

(a) Sticky keys
(b) Filter keys
(c) Toggle keys
(d) Insert key

(ii) A _______ is a collection of computers and other hardware components interconnected by communication channels (cables or satellites) that allow sharing of resources and information.
(a) Computer
(b) Computer network
(c) Client
(d) Server

(iii) WiFi devices such as personal computer, smartphones, video game console, etc. can connect to a network resource such as Internet through a device called the ______.

(a) PSTN
(b) DSL
(c) WiMax
(d) WAP

(iv) OLTP stands for ______.
(a) Online Transaction Protocol
(b) On Line Transfer Protocol
(c) Online Transaction Processing
(d) OverLine Transaction Protocol

(v) Which one of the following is not a part of healthy lifestyle?
(a) Physical activities
(b) Sound sleep
(c) Healthy eating habits
(d) Watching television for long hours

(vi) Any unexpected situation that needs immediate attention and action is called _____.

(a) SDGs
(b) emergency
(c) loss
(d) profit

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 x 2 = 6

6. Explain any two benefits of stress management.
   
   Show Answer
   
   
   Answer: Benefits of stress management are –
   • Improves mood.
   • Boosts immune system.
   • Promotes longevity.
   • Increases efficiency and effectiveness.
   (You can write any two)
   
   
7. What is the difference between yoga and meditation?
   
   Show Answer
   
   
   Answer: Yoga is a school of Hindu philosophy that reduces stress. Yoga includes a series of postures and breathing exercises practiced achieving control of body and mind.
   Meditation is a practice where an individual is supposed to focus his/her mind on a particular object, thought or activity to achieve a calm mental state reducing stress.
   
   
8. What is an operating system? Give two examples.
   
   Show Answer
   
   
   Answer: An operating system is a software that serves as an interface between the user and the computer.
   
   Example: Windows 10/11, Linux, Unix, MacOS, Android, IOS, etc.
   
   
9. Give any two functions of an entrepreneur.
   
   Show Answer
   
   
   Answer: Two functions of Entrepreneur are –
   • Entrepreneurial Functions
   • Promotional Functions
   • Managerial Functions
   • Commercial Functions
   
   
10. Give any two misconceptions about an entrepreneur.
    
    Show Answer
    
    
    Answer: Misconceptions or Myths about an entrepreneur are –
    • Entrepreneurs are born a certain way.
    • Great ideas are what makes entrepreneurs.
    • Entrepreneurs have to take a lot of risk.
    • A lot of money is required to start any business.
    • One must know everything before starting a business.
    • Businesses either skyrocket or fail.
    
    

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

11. Differentiate between Aging and Posterize graphic filters.
    Show Answer
    
    
    Answer: Aging: Simulates the effects of time on a picture. Can be applied several times.
    Posterize: Posterize makes a picture appear like a painting by reducing the number of colours used.
    
    
12. Give any two uses of creating hyperlinks in a spreadsheet.
    Show Answer
    
    
    Answer: Hyperlinks can be used in Calc
    • to jump to a different location from within a spreadsheet and
    • can lead to other parts of the current file, to different files or even to web sites.
    
    
13. Under Record changes feature, one can control the changes that appear on the screen using filters. Explain any two criteria on which these filters are based.
    Show Answer
    
    
    Answer: You can filter based on:
    • Date – Only changes made in a certain time range are displayed.
    • Author – Only changes made by a specific author are displayed. This is especially useful if you have multiple reviewers on the worksheet.
    • Range – Only changes made in a specific range of cells are displayed. This is especially useful if you have a large spreadsheet and only want to review a part of it.
    • Comment – Searches the content of the comments and only displays changes which have comments that match the search criteria.
    
    
14. Differentiate between data organized in a flat file and a relational form.
    Show Answer
    
    
    Answer: Flat File: Data is stored in a single table. Usually suitable for less amount of data.
    Relational form: Data is stored in multiple tables and the tables are linked using a common field. Relational is suitable for medium to large amount of data.
    
    
15. Expand and explain the term www.
    Show Answer
    
    
    Answer: WWW stands for World Wide Web. World Wide Web (abbreviated as WWW or W3, commonly known as the Web), is a system of interlinked hypertext documents accessed via the Internet.
    With a web browser, one can view web pages that may contain text, images, videos, and other multimedia, and navigate between them via hyperlinks.
    
    
16. (a) Arrange the following network in decreasing order of speed: DSL, 3G, 5G
    (b) Give any two examples of instant messaging software.
    Show Answer
    
    
    Answer:
    (a) 5G, DSL, 3G
    
    (b) Instant messaging software are – Yahoo! Messenger, Windows Live Messenger, Skype, Google Talk, Rediff Bol, etc.
    
    

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

17. Give two areas where Mail Merge can be used. Also give names of any two software’s that can be used to store the data list.
    Show Answer
    
    
    Answer: Mail merge can be used –
    • to take a letter you’ve written and send it to a whole bunch of people.
    • to take a list of people’s mailing addresses and generate labels or envelopes with the address for a different person on each label or envelope.
    Software’s can by used to store the data list are-
    • Ms-Excel, OpenOffice.org Calc (Spreadsheet)
    • Ms-Access, OpenOffice.org Base, dBase, MySQL,
    • Text File Data (Notepad)
    
    
18. Explain the following w.r.t. spreadsheets:
    (a) Scenario
    (b) Goalseek
    Show Answer
    
    
    Answer: (a) Scenario: Scenarios are a tool to test “what-if” questions. Each scenario is named and can be edited and formatted separately. When you print the spreadsheet, only the content of the currently active scenario is printed.
    A scenario is essentially a saved set of cell values for your calculations. You can easily switch between these sets using the Navigator or a drop-down list which can be shown beside the changing cells.
    (b) Goalseek: Goal seek is one of the tools used in “what-if analysis” on computer software programs. A what-if analysis is a process of changing values in cells to see how these changes will affect formula outcomes on the worksheet.
    
    
19. Write any four numeric data types in DBMS.
    Show Answer
    
    
    Answer: Numeric Data types in DBMS are – BOOLEAN, TINYINT, SMALLINT, INTEGER, BIGINT, NUMERIC, DECIMAL, REAL, FLOAT, DOUBLE
    
    
20. (a) The structure of a table “SUPPLIER” is given below. Suggest a suitable data type of each column.
    

(b) Consider the table “SUPPLIER” given in (a).
Write queries to:
(i) Display the supplier’s name of all suppliers from Delhi.
(ii) Display details of suppliers whose amount is greater than 50000.

21. (a) Give examples of two Internet threats.
    (b) Most of the time fire can be prevented using appropriate measures. Give any two measures.
    
    Show Answer
    
    
    Answer:
    
    (a) Internet Threats: Phishing, Email Spoofing, Chat Spoofing, Spyware, Malware, etc.
    
    (b) Most of the time fire can be prevented using appropriate measures. These measures are –
    i. Fire escape plans must be installed at proper levels.
    ii. Conduct regular drills.
    iii. Smoke alarms must be placed at proper intervals.
    iv. Keep workplace a no-smoking zone.
    v. Maintenance of safety equipment must be taken care of regularly.
    
    

To Buy Class 10 Information Technology Code 402 CBSE Question Paper 2019-2023 with Solution =>