INFORMATION TECHNOLOGY (SUBJECT CODE-402)

Sample Question Paper 1

Class X (Session 2020-2021)
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):
PS 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.
KI
iii. Do as per the instructions given.
iv. Marks allotted are mentioned against each question/part.

© Kips Learning Pvt. Ltd. 2020 Page 1 of 6

 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. Divya is not able to work on his computer system due to the decreased speed of it. 1
Also, the extension of some of his files has been changed. Which software should he
use to prevent such type of errors?
a) Malware b) Spyware c) Antivirus d) Application
ii. Aman is a sales manager. Which method of communication should he follow to 1
deal with his customers to maintain a healthy relationship?
a) Oral Communication b) Written Communication
c) Verbal Communication d) All of these
iii. .................................. refers to words that shows the relationship of a noun, noun 1
phrase, or pronoun to another word.
a) Prepositions b) Adverbs c) Adjectives d) Verbs

iv. .................................. refers to the various techniques that enable a person to cope 1
with the psychological stress.
a) Destressing b) Dis-stress c) Stress Management
d) Disaster Management
v.
PS Entrepreneurs play a crucial role in …………………………….. the standard of living in a 1
society.
a) Decreasing b) Increasing c) Declining d) None of these

vi. ........................... means being aware of your personality including the strengths and 1
weaknesses.
a) Personality Management b) Self-awareness c) Strength Management
d) All of these

Q. 2 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

i A ……………….........…... is used to apply a group of formatting effects together to the 1
text, paragraphs or headings.
KI
a) Style b) Variant c) Formatting d) None of these
ii The ………………………………………………….. consists of headings and sub-headings of a 1
book or document.
a) Hierarchy b) Table of Contents c) List d) None of these
iii Richa is trying to create a document with the predefined layout so that she can use 1
the sample content, themes, colours, font styles, background styles, etc., given in it.
Which feature of a document can she use to create it?
a) Design layout b) Template c) Theme d) Structure

iv Reema wants to celebrate her 16th birthday with her family and friends. She has 1
designed a birthday invitation card which she wants to send to multiple recipients.
Which feature in documentation can she use to do so?
a) Letter Wizard b) Template c) Document Wizard d) Mail Merge
v Shalini has inserted a picture in her document, but she wants to keep only a portion 1
of it. Which feature should she use to remove the unwanted part of the image?
a) Trimming b) Cutting c) Cropping d) Deleting

vi A merged document is created by merging the main document with the 1

………………………………………. fields.
a) List b) Data Source c) Document d) Table

© Kips Learning Pvt. Ltd. 2020 Page 2 of 6

Q. 3 Answer any 5out of the given 6 questions (1 x 5 = 5 marks)
i A ………………………………… is an important tool of a spreadsheet used to test the 1
‘What-If’ questions.
a) Solver b) Average c) Calculator d) Scenario

ii Raima and Prateek has conducted a survey regarding the daily wages of the 1
labourers in their respective areas, in a spreadsheet. They need to work on the
spreadsheet simultaneously. Which feature should they use to work on the
spreadsheet in order to complete their work in time.
a) Share Worksheet b) Consolidate Worksheet
c) Merge Worksheet d) None of these
iii Which feature in a spreadsheet can store a series of commands? 1
a) Goal Seek b) Subtotals c) Macros d) Charts

iv ……………….........…... is used to find the required data to get a particular result. 1

a) Macros b) Charts c) Subtotals d) Goal seek
v ……………………………….. spreadsheet data enables you to keep the information 1
updated without editing in multiple locations.
a) Referencing b) Linking c) Updating d) None of these
PS vi Raman is a Sales Manager at a showroom of an automobile company. He wants to 1
calculate the subtotal of the sales done by each member in his team. Which feature
of the spreadsheet can he use to calculate the same?
a) Consolidate b) Goal Seek c) Subtotals d) References

Q. 4 Answer any 5out of the given 6 questions (1 x 5 = 5 marks)

i A …………………………….. key is a set of one of more fields that uniquely identifies each 1
record in a table and it does not contain any duplicate data.
a) Primary b) Candidate c) Foreign d) None of these
ii A ………………………………. in a database store the complete data in a structured 1
manner, in the form of rows and columns.
a) Form b) Table c) Sheet d) Report
KI
iii Sunita wants to create a table in a database to record the data regarding her 1
classmates. Which data type should she use to store the addresses of her friends?
a) OLE b) Number c) Text d) Numeric

iv ………………………………… are used to ask questions from the database to retrieve 1

records or data based on certain criteria.
a) Forms b) Reports c) Tables d) Queries
v A ………………………………….. in a database has an attractive interface that accepts data 1
from the user and inserts it in the corresponding table or query.
a) Query b) Form c) Table d) Report

vi ………………………………………… is the process of arranging data in an ascending or 1

descending order.
a) Sorting b) Arranging c) Increasing c) Decreasing

© Kips Learning Pvt. Ltd. 2020 Page 3 of 6

Q. 5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i The …………………………………….. keyboard displays a visual keyboard with all the 1
standard keys on the screen.
a) On-screen b) Virtual c) Secondary d) Physical

ii Aditya is attending online classes these days. He has created a network at home 1
using Wi-fi technology and a laptop. Which type of network is it?
a) LAN b) WAN c) MAN d) PAN
iii Mrs Shalini is the computer teacher. She wants to communicate with her students 1
in the class in real time. Which type of the internet service can she use to do so?
a) Instant Messaging b) Email c) Both of these d) None of these
iv A ………………………… is a frequently updated, online, personal journal, or diary where 1
a person can write or post information related to his interests or activities, express
his ideas or opinions or share his knowledge through writing articles on specific
topics.
a) Online Journal b) Online Diary c) Blog d) Website
v …………………………………….. is an act of sending an email to a user; misleading him to 1
believe that it is from a trusted person or organisation.
PS vi
a) Virus b) Phishing c) Spamming d) None of these
You should install and regularly update the ………………………………… software in your
computer to prevent all kinds of malware.
a) System b) Application c) Antivirus d) All of these
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 Why should an entrepreneur be open-minded? 2
KI
Q. 7 Differentiate between moving and copying a file. 2
Q. 8 Write any two characteristics of an independent person. 2
Q. 9 What is the importance of giving feedback in effective communication? 2
Q. 10 What is the objective of the Sustainable development goals? 2

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

Q. 11 Differentiate between Forms and Reports. 2
Q. 12 What do you understand by E-commerce? 2
Q. 13 What is the use of Macros in a Spreadsheet? 2
Q. 14 What are DDL commands? Give two examples. 2
Q. 15 Explain the term Instant Messaging with an example. 2
Q. 16 List any two ways to insert an image in a document. 2

© Kips Learning Pvt. Ltd. 2020 Page 4 of 6

Answer any 3 out of the given 5 questions in 50– 80 words each (4 x 3 = 12 marks)
Q. 17 What is the use of Styles in a document? Name any two style categories. 4

Q. 18 What is the importance of linking spreadsheets? Differentiate between the absolute 4

and relative hyperlinks.
Q. 19 What is the purpose of grouping data in tables? Which function is useful for doing 4
so?
Q. 20 What is a blog? Mention any two points that you should remember while writing a 4
blog.
Q. 21 Write command and queries to create and manipulate the records of a table named 4
‘Students’ with the following fields:

PS a. Write SQL commands to create the above-given table. Set appropriate datatypes
for the fields.
b. Write a query to display the details of all the students studying in class X.
c. Write the query to change the Roll_No of the student named Aman to 106.
d. Write a query to delete the record where the value of Marks is 1.
KI

© Kips Learning Pvt. Ltd. 2020 Page 5 of 6