Class 10 IT 402 Previous Year Question Paper 2023

by

Series YZXW
Question Paper Code 89 Set 4

INFORMATION TECHNOLOGY
(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.
    • Marks alloted are mentioned against each question/part.
    • There is no negative marking.
    • Do as per instructions given.
  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)

1. Answer any 4 questions out of the given 6 questions on Employability Skills : (1X4=4)

(i) _____________ refers to focusing human efforts for maintaining a healthy body and mind., capable of withstanding stressful situations.
(a) Artificial Intelligence
(b) Stress Management
(c) Motivation
(d) Emotional Intelligence

(ii) Which of the following is not the benefit of stress management?
a) Boosts Immunity
b) Reduces Efficiency
c) Improves Mood
d) Prevent Behavioral Problems

(iii) _____ are computer programs that can damage the data and software programs or steal the information stored on a computer.
(a) Spam
(b) Viruses
(c) Junk Mail
(d) BIOS

(iv) ____ is a horizontal bar present at bottom of the Windows desktop.
(a) Status Bar
(b) Menu Bar
(c) Task Bar
(d) Recycle Bin

(v) State whether the following statement is a myth or reality: “Entrepreneurs are born a certain way.”

(vi) Which of the following is not true for entrepreneurs?
(a) They create needs and demands
(b) They provide raw materials
(c) They do not create jobs
(d) They help society by supporting infrastructure development

2. Answer any 5 out of the given 6 questions (1X5=5)

(i) ____ controls all aspects of a paragraph’s appearance, such as text alignment, tab stops, line spacing, and borders, and can include character formatting.
(a) Page Style
(b) Character Style
(c) Cell Style
(d) Paragraph Style

(ii) How many levels of headings does Open Office Writer evaluate to build the Table of contents?
(a) 8
(b) 9
(c) 10
(d) 12

(iii) Reema has created a pamphlet on ‘Tour to West India’. She has inserted mani images to make it more presentable but the size of the images is occupying a lot of space. Her friend has suggested her to reduce the size of the images. Which of the following options will help her in doing the task without losing any content of the images?
(a) Recolor
(b) Docking
(c) Resize
(d) Rotate

(iv) Which of the graphic filter is used to increase the contrast of an image in a document?
(a) Smooth
(b) Sharpen
(c) Remove Noise
(d) Invert

(v) Which of the following is not used when creating a mail-merge document?
(a) Spreadsheet
(b) Document
(c) Paint
(d) Database

(vi) Which mode is used to apply a style to many different areas of a document quickly without going back and formatting window in a writer?

3. Answer any 5 out of the given 6 questions (1X5=5)

(i) A colored border, with ____, appears around a cell where changes are made in a shared worksheet.
(a) a dot in the upper left-hand corner
(b) a dot in the lower left-hand corner
(c) a cross in the upper left-hand corner
(d) a cross in the upper right-hand corner

(ii) ____ feature adds data arranged in a group of cells in Calc with labels for columns and/or rows.
(a) Average
(b) Subtotal
(c) Goal Seek
(d) Solver

(iii) A ____ refers to a cell or range of cells on a worksheet whose data values can be used in a formula.
(a) sheet
(b) cell
(c) cell reference
(d) cell data

(iv) ____ feature of Calc is used to test ‘what-if’ questions.
(a) Solver
(b) Goal Seek
(c) Scenario
(d) Styles

(v) Macros are especially useful to ____ the same way over and over again.
(a) repeat a task
(b) reject a task
(c) report a task
(d) comment a task

(vi) ____ feature of Calc helps to track what data was changed, when the change was made, who made the change and in which cell the change occured.
(a) Record Changes
(b) Edit Record
(c) Change Record
(d) Macro

4. Answer any 5 out of the given 6 questions (1X5=5)

(i) Which of the following is not an example of DBMS?
(a) PostgreSQL
(b) SQLite
(c) FoxPro
(d) Imperss

(ii) A ____ is an interface in a user-specified layout that lets users to view, enter, and changes data directly in database objects such as tables.
(a) frame
(b) form
(c) relation
(d) report

(iii) Which of the following is expanded form of SQL?
(a) Systematic Query Language
(b) Structured Query Language
(c) Software Query Language
(d) Structural Query Language

(iv) ____ is usually suitable for less amount of data. (Relational/Flat File)

(v) Binary data types in a database can be using for storing _____
(a) photos, music files, etc.
(b) integer values,
(c) only images files
(d) only video files

(vi) ____ clause can be used with the SELECT statement in SQL to specify which rows to retrieve from the table.
(a) WHERE
(b) GROUP
(c) SAME
(d) SIMILAR

5. Answer any 5 out of the given 6 questions (1X5=5)

(i) ____ is an accessibility function which is designed for people who have vision impairment or cognitive disabilities.
(a) Filter Keys
(b) Sound Key
(c) Toggle Keys
(d) Sticky Keys

(ii) Networks in which certain computers have special dedicated tasks providing services to other computers (in the network) are called ____
(a) hierarchical
(b) dedicated server
(c) peer to peer
(d) client server

(iii) ____ provides Internet access by transmitting digital data over wires of a local telephone network.
(a) HSPDA
(b) P2P
(c) DSL
(d) Modem

(iv) A ____ is an unplanned event that may happen all of a sudden and may lead to unwanted or unprecedented results/outcomes.
(a) emergency
(b) hazard
(c) accident
(d) illness

(v) A ____ worker will always perform to the post to his ability.
(a) fast working
(b) highly educated
(c) happy and healthy
(d) stressed

(vi) _____ is the process of emptying a place in case of an emregency.
(a) Emergency
(b) Accident
(c) Drill
(d) Evacuation

SECTION B (Subjective Type Questions)

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

6. What is self-awareness? Also give any two benefits of self-awareness.

7. Give one example of each of the following stress causal agents for students:
a) Mental
b) Social

8. Differentiate between files and folders.

9. Given any two qualities of an entrepreneur.

10. Give any two promotional functions of an entrepreneur.

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

11. Difference between keep scale and keep image size options while cropping an image in a document.
12. Give any two characteristics of a template in Open Office Writer.
13. Why do we need to merge worksheets?
14. What is primary key? How is it different from foreign key?
15. Expand and Explain the term WAN.
16 a) Identify the following network/internet connectivities as wired or wireless:
i) Dial-Up
ii) WiMAX
b) Give any one feature of Instant messaging.

Answer any 3 out of the given 5 questions in 50– 80 words each (4X3=12)

17. Expand the following terms with resepct to positioning the graphics in a document:
a) Arrangement
b) Text Wrapping

18. Distinguish between the following with respect to spreadsheets:
a) Relative and Absolute Hyperlinks
b) Internet hyperlinks and document hyperlinks

19. Explain any four data types of DBMS.

20. a) Structure of a table ‘Orders’ is given below. Suggest suitable data type of each column

Table: Orders

Order_IDOrder_dateCustomer_IDAmount
A_10112/12/19C34451200.00
A_20211/09/19C12453456.00
A_40209/07/19C21212312.00

(b) Consider the following table “Books”.

BkIDBkNameAuthorQtyPrice
B_101Learning with FunJacobins5355.00
B_103How I Live NowMeg Rosoff4400.00
B_104I Capture the CastleDodie Smith5520.00
B_106Mortal EnginesPhilip Reeve4260.00
B_110The Kite RiderGeraldine McCaughrean3270.00

Write SQL queries to
i) Display Data of all books whose quantity is more than 3.
ii) Display total amount of all books whose price is less than 500.
(Hint: amount=Qty*Price)

21. a) Give two best practices for internet safety.
b) Give any two Falls and Slips Safety rules.

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