Class 10 IT 402 Previous Year Question Paper 2023 (Compartment) – Solution

by

Series ΨYZXW/C
Question Paper Code 89 Set 4

INFORMATION TECHNOLOGY (COMPARTMENT) – SOLUTION
(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.”
Answer: True

(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 ?
Answer: Three (in upgraded versions its 1 only)

(iv) Give an example of statistical function in Calc.
Answer: SUM, COUNT, AVERAGE, MAX, MIN, PRODUCT, COUNT and many more.

(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.
Answer: Stress management offers numerous benefits for both physical and mental well-being. Here are some of the key advantages:
a) Improved Health: Managing stress reduce the risk of stress-related health issues such as heart disease, high blood pressure or weakened immune function.
b) Increased Productivity: Managing stress can enhance concentration, focus, and problem-solving skills, leading to increased productivity at work or in daily tasks.

7. What is the difference between yoga and meditation ?
Answer: Yoga and meditation are two practices often associated with each other, but they have distinct difference:
Yoga involves physical postures, movements, and exercises. It’s a holistic system that integrates physical, mental, and spiritual elements.
Meditation involves mental techniques to train and calm the mind. It’s about focusing the mind’s attention and achieving a state of deep relaxation.

8. What is an operating system ? Give two examples.
Answer: An operating system (OS) is system software that manages computer hardware, software resources, and provides various services for computer programs. It acts as an interface between users and the hardware, ensuring that different software applications can run smoothly and efficiently on the computer.
Example: a) Microsoft Windows
b) : macOS

9. Give any two functions of an entrepreneur.
Answer: Entrepreneurs play many roles and perform various functions, but two essential functions of an entrepreneur are:
a) Innovation and Creativity: Entrepreneurs come up with new ideas, products, or services that address market needs or solve problems in novel ways.
b) Risk Management: Entrepreneurs assess the potential risks and rewards associated with their ventures and make decisions accordingly. It involves uncertainty and the possibility of failure.

10. Give any two misconceptions about an entrepreneur.
Answer: Two common myths about entrepreneurs are:
a) entrepreneurs are born, not made
b) needs a lot of money

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

11. Differentiate between Aging and Posterize graphic filters.
Answer: The aging filter is used to make an image or a part of it appear older or weathered whereas posterize filter reduces the number of colors in an image, creating distinct color zones or blocks. It simplifies the color palette to create a poster-like or graphic effect.

12. Give any two uses of creating hyperlinks in a spreadsheet.
Answer: Hyperlinks in spreadsheets have various uses, but here are two common ones:
a) Navigation within the Spreadsheet: By linking specific cells to relevant parts of the spreadsheet, users can easily navigate to different sections with a simple click.
b) Accessing External Resources: Hyperlinks can be used to provide direct access to resources like websites, documents, or files.

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.
Answer: Here are two criteria on which these filters can be based:
Date and Time: You can filter changes based on the date and time they were made. This allows you to view changes made within a certain time frame.
User or Author: Filters can be applied to show changes made by a specific user or author. Each user typically has a unique identifier or username associated with their changes.

14. Differentiate between data organized in a flat file and a relational form.
Answer: Data organization in a flat file and a relational form represents two distinct approaches to managing and storing data.
In a flat file, data is stored in a single, two-dimensional table, typically as a text file, with no inherent relationships between records. It suits simple applications but often results in data redundancy, as the same information might be duplicated across multiple records.
In contrast, relational databases organize data into multiple tables, each representing a specific entity, with relationships established through keys. They are well-suited for complex data structures, support efficient data handling, and maintain data integrity (accuracy).

15. Expand and explain the term www.
Answer: The term “WWW” stands for “World Wide Web.” It refers to a global system of interconnected documents and resources, often accessed through the internet.
The WWW was invented by Sir Tim Berners-Lee in 1989

16. (a) Arrange the following network in decreasing order of speed : DSL, 3G, 5G
Answer: 5G, 3G, DSL (Digital Subscriber Line)
(b) Give any two examples of instant messaging software.
Answer: WhatsApp, Facebook Messenger, Telegram etc.

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.
Answer: Mail Merge is a valuable feature that can be used in various contexts. Here are two areas where Mail Merge is commonly applied:
a) Mail Merge is frequently used for business-related communications and companies can use it to create personalized letters, invoices, and statements for customers.
b) In marketing, Mail Merge is used to create personalized marketing materials such as emails or newsletters. Promoters can merge data from a customer list to address recipients by name, include offers and track the effectiveness of their campaigns.
Softwares that can be used to store data list are as follows:
MS Excel, OpenOffice Calc, MS Access, MySQL, Notepad, OpenOffice Base etc.

18. Explain the following w.r.t. spreadsheets :
(a) Scenario
(b) Goalseek
Answer: Scenario Manager Tool is an important tool of MS Excel, that enables you to manage and view data from different input values. For example, if you want to calculate the effect of different interest rates on an investment, you could add a scenario for each interest rate, and quickly view the results.
Goalseek Tool It is a useful data analysis tool of MS Excel software. It is used to set a goal to find the optimum (correct) value for one or more target variables, given with the certain conditions. Simply it helps you obtain the input value that results in the target value that you want.

19. Write any four numeric data types in DBMS.
Answer: Here are four common numeric data types:
Answer: a) SMALLINT
b) INTEGER
c) FLOAT
d) DECIMAL

20. The structure of a table "SUPPLIER" is given below.
Class-10-IT-C-402-Previous-Year-Question-Paper-2023-Q-20
a) Suggest suitable data type of each column.
Answer:
Class-10-IT-C-402-Previous-Year-Question-Paper-2023-solution-Q-20
b) Consider the table "SUPPLIER" given in (a) Write queries to :
(i) Display the supplier name of all suppliers from Delhi
Answer: SELECT Suppname from SUPPLIER where City="Delhi";
(ii) Display details of suppliers whose amount is greater than 50000.
Answer: SELECT * from SUPPLIER where Amount > 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