Class 10 IT 402 Sample Paper Set 3
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.
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 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 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×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.
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. 4 x2=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. 3 x 4=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.
(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.
21. (a) Give examples of two Internet threats.
(b) Most of the time fire can be prevented using appropriate measures. Give any two measures.