SAMPLE PAPER -I
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOLOGY (SUBJECT CODE - 402)
Sample Question Paper –I for Class X (Session 2022-2023)
Max. Time: 2 Hours Max.
Marks: 50
General
Instructions:
1. Please
read the 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 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.
7.
SECTION B – SUBJECTIVE 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
|
Q. 1 |
Answer any 4 out of the
given 6 questions on Employability Skills (1 x 4 = 4 marks) |
|
|
i. |
For
self-motivation, self-awareness is a very importance factor. The feeling of
self-awareness enhances our …………. a.
Self-discipline b.
Self-confidences c.
Self-regulation d.
Self-monitoring |
1 |
|
ii. |
What are the
types of words we should use for verbal communication? (a) Acronyms (b) Simple (c) Technical (d) Jargons |
1 |
|
iii. |
Identify the
indirect object in the sentence, ‘The band played music for the audience.’ (a) The band (b) played (c) music (d)
audience |
1 |
|
iv. |
Here are the
steps that take place when starting a computer. Rearrange the steps in the
correct order. (a) Desktop
appears after login (b) Login screen
appears (c) Power on
Self-Test (POST) starts (d) Operating
system starts (e)
Welcome screen appears |
1 |
|
v. |
Ravi’s customer
comes to his store and starts shouting at him. He does not get angry. He
listens to what his customer is saying. He is ____________. (a) hardworking (b) confident (c) patient (d) prying new ideas |
1 |
|
vi. |
Which of the
following is a valid file extension for Notepad file? (a) .jpg (b) .doc (c) .text (d) .txt |
1 |
|
Q. 2 |
Answer any 5 out of the
given 6 questions on Employability Skills (1 x 5 = 5 marks) |
|
|
i. |
The
final document produced after mail merge is called ____________. a.
Data Source b. Main
Document c. Address list d. Merged document |
1 |
|
ii. |
Text
wrapping means (a)
Placing text inside an image (b)
Placing text around an image (c)
Placing text behind an image (d)
Placing text adjacent to the image |
1 |
|
iii. |
SELECT
command of SQL is a type of command. (a)
DDL (b)
DML (c)
TCL (d)
All of the above |
1 |
|
iv. |
Duplication
of data is called: (a)
Redundancy (b)
Inconsistency (c)
Consistency (d)
Foreign key |
1 |
|
v. |
Digital
order and digital receipt are a part of (a)
E-ticketing (b)
Online transaction (c)
Both (a) and (b) (d)
None of these |
1 |
|
vi. |
Which
function cannot be performed through Subtotal in a Spreadsheet? a.
Sum b.
Product c.
Average d.
Percentage |
1 |
|
Q.
3 |
Answer
any 5 out of the given 6 questions on Employability Skills (1 x 5 = 5 marks) |
|
|
i. |
What
is the shortcut key for style and formatting option? a.
F7 b. F9 c. F12 d. F11 |
1 |
|
ii. |
Which of the following is not appropriate to set as primary key? (a) Employee's Identification Number (b) Price of book (c) Product code (d) Admission number of student |
1 |
|
iii. |
To
perform subtotals in a worksheet, the field on which you want to perform
subtotal is defined by ___________ option. (a)
Data > Consolidate
(b) Data -> Subtotal (c)
Home > AutoSum
(d) Data -> Group |
1 |
|
iv. |
Suresh has created a macro in her worksheet to simplify some of the
tasks that she has to perform very frequently. To execute that macro she has
to use the Run Macro command. How can she use macro directly without giving
the command? (a) By saving macro in the worksheet (b) By making function of the macro (c) By recording the macro (d) All of these |
1 |
|
v. |
In
the office of a finance company there are 7 computers. They all are connected
to a network. These computers act as server as per the need. Which type of
network is established there? (a)
Peer-to-peer network (b)
Client Server Network (c)
Common Network (d)
Metropolitan Area Network |
1 |
|
vi. |
___________
refers to a range of cells. a.
Column b.
Formula c.
Row d.
Cell reference |
1 |
|
Q.
4 |
Answer
any 5 out of the given 6 questions on Employability Skills (1 x 5 = 5 marks) |
|
|
i. |
Which of the following cannot be done using Forms in database? (a) Adding records (b) Deleting records (c) Editing records (d)
Modify table design |
1 |
|
ii. |
Geeta
is a poet. She wants her poems to reach the right people. For this she wants
to start writing a blog. Which of the following sites can be used for the
same? (a)
Blogger (b)
WordPress (c)
Notepad (d)
None of these |
1 |
|
iii. |
Linux
is an example of. a.
Operating system b.
DBMS c.
RDBMS d.
Antivirus |
1 |
|
iv. |
Which
is a model that you use to create other documents? a.
Style b. Formatting c. Template d. None of these |
1 |
|
v. |
The
description column in Table Design view is used to (a)
Define data type for each field. (b)
Describe data to be stored in each field. (c)
Describe criteria for storing data in the field (d)
None of these |
1 |
|
vi. |
A
URL with HTTP symbol is considered as connection. (a)
Secure (b)
Protected (c)
Insecure
(d) Virus free |
1 |
|
Q. 5 |
Answer any 5 out of the given 6 questions on Employability Skills (1 x 5 = 5 marks) |
|
|
i. |
Which
option Increases the contrast of an image? a.
Sharpen b. Remove noise c. Smooth d. Solarization |
1 |
|
ii. |
Which
of the following What-If analysis tool deals with multiple unknown variables? a.
Goal Seek b.
Scenario c.
Solver d.
All of these |
1 |
|
iii. |
The posts in a blog are arranged in-order. (a) Chronological (b) Reverse chronological (c) Alphabetical (d) Numerical |
1 |
|
iv. |
In a worksheet, while performing consolidation, if same data range is
selected from multiple worksheets, then consolidation is done by (a) Applying Average function on the range. (b) Copying data below the selected range (c) Replacing data from the selected range. (d) Applying Sum function on the range. |
1 |
|
v. |
To
insert a downloaded image from Google into a document option of word
processor is used. (a)
Drawing objects (b)
Pictures (c)
Any of these (d)
None of these |
1 |
|
vi. |
______________
is a shortcut key to create a new database. (a)
Ctrl + O (c)
Ctrl + E (b)
Ctrl + N (d)
Ctrl + D |
1 |
SECTION B:
SUBJECTIVE TYPE QUESTIONS
Answer
any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6 marks)
Answer
each question in 20 – 30 words.
|
Q.
6 |
How
can you manage intelligence? |
2 |
|
Q.
7 |
List
the ways in which an entrepreneur affects a society. |
2 |
|
Q.
8 |
List
the various ways you can use to protect your data. |
2 |
|
Q.
9 |
How
can tracking your time help you? |
2 |
|
Q.
10 |
How
can you increase the performance of a computer? |
2 |
Answer any 4 out
of the given 6 questions in 20 – 30 words each (2 x 4 = 8 marks)
|
Q.
11 |
What
is electronic spreadsheet? Give any 2 example. |
2 |
|
Q.
12 |
What
is DBMS? Write the use of DBMS. |
2 |
|
Q.
13 |
What
is an online truncation? Give any 2 example. |
2 |
|
Q.
14 |
What
is document hyperlink in a Calc? |
2 |
|
Q.
15 |
What
is the purpose of adding comments in Calc? |
2 |
|
Q.
16 |
List
any three methods of inserting images in a text document. |
2 |
Answer any 3 out
of the given 5 questions in 50– 80 words each (4 x 3 = 12 marks)
|
Q.
17 |
Bharti uses Internet for his School Project but he
is not aware of security issues regarding the Internet. Help him by solving
the following queries. (A) What is a secure connection? (B) How you can recognize a secured connection? (C) Suggest any two security measures to ensure
safety from online threats. (D) What is Firewall? |
4 |
||||||||||||||||||||||||||||||||||||
|
Q.
18 |
Bhanu is creating flowcharts in word processor by
using symbols provided in it. (A) Which feature of word processor can help him to
accomplish the task? (B) Write a short note on that feature. (C) The flowchart consists of many symbols and text
along with the symbols. Bhanu wants to change the size of the symbols but
selecting each of them together is very difficult. What can he do to select
them together on a single click? (D) He wants to change one or two symbols. How can he revert the changes made by him previous step? |
4 |
||||||||||||||||||||||||||||||||||||
|
Q.
19 |
Following table displays a part of information of
student’s marks in different subjects.
(A) How many fields and records are there in Items
table? (B) Write commands of SQL to: (a) Modify the marks of Vikash Joshi as Sub1=80,
Sub2=88, Sub3=90, Sub4=70. (b) Change the column names Sub1, Sub2, Sub3, Sub4
with Hindi, Eng, Math and IT respectively. (c) Add a new record with given details
("10007", "Ranu Vaishnav", "55",
"87", "84", "65"). |
4 |
||||||||||||||||||||||||||||||||||||
|
Q.
20 |
Prem Narayan is an owner of a Call Center. He wants
to store a huge amount of information about all his employees and clients in a database. (A) Which type of table organisation would be most
suitable for this purpose? (B) What is the difference between both types of
data organisation? (C) Mention any two advantages of database software. (D) Name the software used to work on databases. |
4 |
||||||||||||||||||||||||||||||||||||
|
Q.
21 |
Saurabh and his three more classmates are working on
a school project in which they have to collect data of families and their
income sources. They all want to work simultaneously to complete the project
in time. (A) Which option in the spreadsheet will help them
to achieve their purpose? (B) Saurabh himself is checking the changes done in
the sheet by his friends. Which option should he use to check the changes
done by them? (C) Is it possible for Gaurav to decide which
changes to apply or not in the sheet? (D) Write a short note on the feature used in (B). |
4 |
------------------------------------------
THE END ------------------------------------------
0 Comments
Post a Comment