CBSE IT-402 Sample question Paper 2020-2021 Class 10

 INFORMATION TECHNOLOGY(402)

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 (05 + 16 =) 21 questions, you have to answer (5 + 10 =) 15 questions in the allotted (maximum) time of 2 hours.

5. All questions of a particular part/section must be attempted in the correct order.

6. SECTION A - OBJECTIVE TYPE QUESTIONS (30 QUESTIONS; 24 MARKS):

i. Each question carries 1 mark.

ii. There is no negative marking.

7. SECTION B – SUBJECTIVE TYPE QUESTIONS (16 QUESTIONS; 26 MARKS):

i. This section has 16 questions in three parts viz. Part A, Part B & Part C.

ii. A candidate has to do 10 questions (3 questions from Part A, 4 questions from Part B and 3 questions from Part C).

iii. Part A has 05 questions on Employability Skills. Do any 03 questions. Answer these questions in 20 – 30 words each. Each question carries 2 marks. (2 x 3 = 6 Marks)

iv. Part B has 06 subject specific questions. Do any 04 questions. Answer these questions in 20 – 30 words each. Each question carries 2 marks. (2 x 4 = 8 Marks)

v. Part C has 05 subject specific questions. Do any 03 questions. Answer these questions in 50-80 words each. Each question carries 4 marks. (4 x 3 = 12 Marks)

Page 3 of 6

SECTION A: OBJECTIVE TYPE QUESTIONS

Q. 1

Answer any 4 of the given 6 questions (1 x 4 = 4 marks)

i.Karan lives at a hostel in Shimla. He calls his mother who lives in Delhi, to get her approval for robotics class which is going to start in his school next week onwards. However due to disruption in the phone line, his mother could not understand and reply to him. He got very upset. Which other medium can he use to get immediate approval of his mother?

a) E-mail 

b) Letter 

c) Message through Friend 

d) Fax

ii.Trisha is always tensed during exam time. She is a sincere and studious student, but the thought of exams creates anxiety in her. Which stress management technique that you would suggest to help her?

a) Yoga 

b) Exercise 

c) Vacation with Family 

d) All of these

iii.______________ Ability of a person to do the things that need to be done without someone or something influencing us.

a) Self-Motivation 

b) Self Awareness 

c) Self Discipline

d) Self-Regulation

iv.According to the concept of sustainable development, the environment and development are _________issues.

a) Inseparable 

b) Separate 

c) Independent 

d) None of these

v.The cleaning of software installed in the computer cannot be achieved by ____________.

a) Disk cleanup 

b) backup

c) Cleaning CPU cabinet 

d) Installing antivirus software

vi.Entrepreneurship has a crucial role in the ____________ of the society.

a) Evolution 

b) Planning 

c) Functioning 

d) None of these

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

i_______________ is not an instant messaging service.

a) Skype 

b) Yahoo! Messenger 

c) Firefox 

d) Whatsapp

ii______ is the process of emptying a place in case of an emergency, disaster.

a) Accident 

b) Evacuation 

c) Hazards 

d) Exiting

iii.Richard needs to set up a network for his office where he wants to save all the data in a centralized system and other computers will take the services from the centralized system. Which architecture will be the best suitable for him?

a) Peer to Peer 

b) Client-Server 

c) Point to Point 

d) Ring

iv.Á _________ is a device that converts digital computer signals into a form (analog signals) that can travel over phone lines and vice versa.

a) Repeater 

b) Switch 

c) Router 

d) Modem

v.__________is specifically designed to minimize or maximize the result according to a set of rules that you define in a spreadsheet.

a) Goal Seek 

b) Scenario 

c) Solver 

d) Subtotal

vi.Mr. Venkat wants to insert his company logo at the top of every page in his long document. Which option will you suggest to him to fulfill his task?

a) Header 

b) Footer 

c) Margin 

d) Headings

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

i.Krishna wants to make a flowchart for his programs in a Word document. Which option should he use to accomplish this task efficiently?

a) Shapes 

b) Symbols 

c) Pictures 

d) All of these

ii.Fatima has inserted a picture in a document. But she wants to cut off a part of the picture. Which option she should use to accomplish the task?

a) Cut 

b) Copy 

c) Crop 

d) Layout

iii.The intersection point between a row and column is called _______.

a) Row 

b) Column 

c) Table 

d) Cell

iv.Amrita is celebrating her 14th birthday. She wants to invite her friends and family members for the party. Which feature will she use to send the same invite to a number of people with different addresses without typing it again and again?

a) Mail Merge 

b) Letter wizard 

c) Document Type 

d) None of these

v.A ____ is a model that you use to create other documents.

a) Styles 

b) template 

c) Wizard 

d) Sample

vi.Formulas in a Spreadsheet must begin with a __________ sign.

a) $ 

b) @ 

c) # 

d) =

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

i___________ is a tool to test “what-if” questions.

a) Scenario 

b) Solver 

c) Macro 

d) Average

ii.To write a mathematical expression, choose the Equation option from the _________tab in a Spreadsheet.

a) Home 

b) Insert 

c) Data 

d) Review

iii.Hyperlink option is available in ____________ group of Insert tab in a Spreadsheets.

a) Illustrations 

b) Add-Ins 

c) Links 

d) Filter

iv.______________ uses the keyboard as a pointing device instead of a mouse.

a) Mouse Key 

b) Toggle key 

c) Filter key 

d) Sticky key

v.Krish and Kritika have done a survey of age wise literacy rates of their locality as a school project, which they have created in a Spreadsheet. They both want to work simultaneously to complete it on time. Which option they should use to access the same Spreadsheet to speed up their work.

a) Consolidate Workbook 

b) Share Workbook

c) Link Workbook 

d) Combine Workbook

vi.___________ database is a type of database that stores data in several tables.

a) Flat 

b) Relational 

c) both (a) and (b) 

c) None of them

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

i.In database _________ helps us to retrieve the filtered data based upon some conditions.

a) Forms 

b) Reports 

c) Queries 

d) Table

ii.A table can have multiple ___________ keys.

a) Candidate key 

b) Alternate key 

c) Primary key 

d) both (a) and (b)

iii.Which one is not a DML type of command?

a) insert into 

b) delete 

c) update 

d) alter table

iv.A _____ is one which connects computers and devices in a limited geographical area such as home, school, computer laboratory, office building, or closely positioned group of buildings.

a) LAN 

b) WAN 

c) MAN 

d) PAN

v.Ishita wants to create a query from the scratch. Suggest her the option to accomplish the task.

a) Datasheet View 

b) Form View 

c) Design View 

d) Layout View

vi._____________ data type takes the values in the form of 0 and 1.

a) Integer 

b) Text 

c) Boolean 

d) Memo

SECTION B: SUBJECTIVE TYPE QUESTIONS

PART A: SHORT ANSWER TYPE QUESTIONS ON EMPLOYABILITY SKILLS

Answer any 3 of the given 5 questions (2 x 3 = 6 marks)

Q. 6Communication skills are very important for any business. Explain any two elements of a communication process.                                                                    2

Q. 7Mention any two misconceptions about the Entrepreneurship.                        2

Q. 8Goal setting is a very essential factor in your personal life. List all the SMART methods to set the goals. Explain ‘A’ in brief.                                                        2

Q. 9What are the measures to increase the performance of a computer system?    2

Q. 10How can an individual contribute towards Sustainable Development Goals?    2

PART B: SHORT ANSWER TYPE SUBJECT SPECIFIC QUESTIONS

Answer any 4 of the given 6 questions (2 x 4 = 8 marks)

Q. 11What is the need to create reference between the multiple worksheets of a workbook? Give an example.                                                                                    2

Q. 12What is the utility of text wrapping in a document?                                    2

Q. 13What is the use of Macros in a Spreadsheet?                                        2

Q. 14Write any two advantages of online shopping.                                        2

Q. 15Differentiate between Primary key and Foreign key.                                2

Q. 16Define the following Hot spots:-

a) WIMAX

b) Wi-Fi                                                                                    2

PART C: DESCRIPTIVE/ LONG ANSWER TYPE SUBJECT SPECIFIC QUESTIONS

Answer any 3 of the given 5 questions (4 x 3 = 12 marks)

Q. 17Elaborate four different types of indentation which can be provided in a Word Processor. 4

Q. 18Define the following:

a) Goal Seek

b) Consolidating Data                                                                            4

Q. 19What precautions must be taken to improve online security?                            4

Q. 20List any two advantages and disadvantages of DBMS.                                4

Q. 21a) Create the following table items.                                            2+2

a) Consider the following table Item and write the queries (i) and (ii).

i. Write a command to insert a new record with the following values :

(66, ‘Gel’, 150, 70).

ii. Write a query to display all the record of table Item whose price is in the range of 100 and 300.

or

Write a query to display all the records of a table in descending order of quantity.

2+