Class 10 IT 402 Previous Year Question Paper 2023 – Compartment

by

Series ΨYZXW/C
Question Paper Code 89 Set 4

INFORMATION TECHNOLOGY (COMPARTMENT)
(Session 2022-23)

Time allowed : 2 hours
Maximum Marks : 50

General Instructions :

  1. Read the following 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 alloted (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)
    • This section has 5 questions.
    • There is no negative marking.
    • Do as per instructions given.
    • Marks alloted are mentioned against each question/part.
  7. Section – B : Subjective Type Questions (26 Marks)
    • This section has 16 questions.
    • A candidate has to do 10 questions.
    • Do as per instructions given.
    • Marks alloted are mentioned against each question/part.

Section A – Objective Type Questions (24 Marks)

1. Answer any 4 out of the given 6 questions on Employability Skills. (4×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. (5X1=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. (5X1=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. (5X1=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. (5X1=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. (3X2=6)

6. Explain any two benefits of stress management.

7. What is the difference between yoga and meditation ?

8. What is an operating system ? Give two examples.

9. Give any two functions of an entrepreneur.

10. Give any two misconceptions about an entrepreneur.

Answer any 4 out of the given 6 questions in 20-30 words each. (4X2=8)

11. Differentiate between Aging and Posterize graphic filters.

12. Give any two uses of creating hyperlinks in a spreadsheet.

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.

14. Differentiate between data organized in a flat file and a relational form.

15. Expand and explain the term www.

16. (a) Arrange the following network in decreasing order of speed : DSL, 3G, 5G
(b) Give any two examples of instant messaging software.

Answer any 3 out of the given 5 questions in 50-80 words each. (3X4=12)

17. Give two areas where Mail Merge can be used. Also give names of any two softwares that can be used to store the data list.

18. Explain the following w.r.t. spreadsheets :
(a) Scenario
(b) Goalseek

19. Write any four numeric data types in DBMS.

20. (a) The structure of a table "SUPPLIER" is given below. Suggest suitable data type of each column.
Class-10-IT-C-402-Previous-Year-Question-Paper-2023-Q-20
(b) Consider the table "SUPPLIER" given in (a).
Write queries to :
(i) Display the supplier name of all suppliers from Delhi
(ii) Display details of suppliers whose amount is greater than 50000.

Class 10 Information Technology Previous Year Question Papers

Class 10 Information Technology Previous Year Question Papers Solution

Class 10 Information Technology Previous Year Compartment Question Papers

Class 10 Information Technology Previous Year Compartment Question Papers Solution

Leave a Comment