Class 10 IT 402 Sample Question Paper 2024

Information Technology (SUBJECT CODE – 402)

Sample Question Paper for Class X (Session 2023-2024)

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

1. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)

i) When it is difficult to communicate with someone who is not willing to talk or express their feelings and views it means there is a/an ____________

a) Culture Barrier

b) Interpersonal Barrier

c) Physical Barrier

d) Language Barrier

 

ii) Kartik’s Computer was running very slow, hangs and often restarts. He is very confused and tensed as he was working on a very important assignment. Kartik’s friend gave him the following suggestions. Identify who has given him a genuine suggestion.

a) Radha : Restart your machine

b) Ishan : Install reliable antivirus software and update

c) Amar : Don’t use Pendrive

d) Sam : Install free antivirus from net

 

iii) _________ refers to focusing human efforts for maintaining a healthy body and mind capable of better withstanding stressful situations.

a) Self-Motivation

b) Stress Management

c) Self-Awareness

d) Self-Regulation

 

iv) High expectations from self can leave with chronic anxiety and stress, thus leading to _____________  stress.

a) Physical

b) Emotional

c) Mental

d) Financial

 

v) Which of the following is/are a myth about Entrepreneurship ?

a) Need a lot of Money

b) Must have a great Idea

c) Should know everything about business

d) All of these

 

vi) Name the organization that has the Sustainable Development Goals ?

a) UNICEF

b) League of Nations

c) United Nations

d) World Health Organization

 

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

i) Which one is not the tab of the insert/index Table window of Writer Document?

a) Entries

b) Background

c) Style

d) Row

 

ii) In the custom styles, each __________ field on the Structure line represents a blank space in a document.

a) Black

b) White

c) Blue

d) Yellow

 

iii) Saurabh has made an advertisement in Digital Document. He is facing difficulty in positioning the images within the text. Suggest him how he can adjust the image?

a) Wrap text

b) Crop

c) Alignment

d) Layout

 

iv) A ___________ is a collection of records that store data in Mail merge.

a) Data Source

b) Main Document

c) Document

d) Merge Field

 

v) To increases the contrast of an image, ____________ option is used in a document.

a) Smooth

b) Sharpen

c) Aging

d) mosaic

 

vi) _____ provide Internet access by transmitting digital data over wires of a local telephone network.

a) ISP

b) DSL

c) Dial-up connection

d) Modem

 

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

i) ___________ is specifically designed to minimize the results according to a set rules that we define in a spreadsheet.

a) Goal Seek

b) Scenario

c) solver

d) Subtotal

 

ii) Sahil and his partners have created a list of their company employees in one of the spreadsheets in the office. Now the rest of the task they want to complete from home. Which option they should use to access the same Spreadsheet from home?

a) Consolidate Worksheet

b) Link Worksheet

c) Merge Worksheet

d) Lock Worksheet

 

iii)  ____________ can help to clarify the relation between cells while using “Multiple Operations”.

a) Detective

b) Solver

c) Navigation

d) Hyperlink

 

iv) Identify the part of a Spreadsheet using which a user can manage multiple sheets.

a) Status Bar

b) Sheet Tab

c) Formula Bar

d) Worksheet Area

 

v) Spreadsheet software can find the changes by ___________ sheets.

a) Changing

b) Comparing

c) Renaming

d) Editing

 

vi) At the bottom of each worksheet, left tab indicates the ____________ of the worksheet in a workbook.

a) Size

b) 3 Type

c) Name

d) Color

 

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

i) It enables users to view, enter, and change data directly in database objects.

a) Report

b) Query

c) Form

d) Database

 

ii) There are _______ types of Relationships in a table of a database.

a) One

b) 3

c) 4

d) Many

 

iii) A Relational database uses ________ commands which is a standard user application that provides an easy programming interface for database interaction.

a) Access

b) Python

c) SQL

d) Protocol

 

iv) Suraj wants to create a database for his clients. For this purpose, she needs to store the Email IDs of his clients. Which datatype should he use to accomplish this purpose?

a) Numeric

b) Varchar

c) Binary

d) Boolean

 

v) Geet has written a SQL query in SQL view. But he doesn’t know how to execute the query using keyboard keys. Suggest him the shortcut key to complete the task.

a) Enter

b) Ctrl + E

c) Space bar

d) F5

 

vi) A table can have only _________ primary key in a database.

a) 1

b) 2

c) 3

d) Many

 

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

i) __________ key is an accessibility feature that assists people having difficulty in using keyboard and mouse.

a) Guide

b) Sticky

c) Serial

d) Home

 

ii) Anaisha is a wildlife photographer. She wants to create her website where she can update the pictures and discuss about different events, reviews, announcements, news etc. Suggest her a suitable option to complete the task.

a) Blog

b) E-Mail

c) Instant Messaging

d) Mail Merge

 

iii) Which of the following is not a web browser?

a) Safari

b) Internet Explorer

c) Google

d) Firefox

 

iv) Which out of the following is the best example of a strong password?

a) 9412356789

b) 14Hd{]$_Sb10

c) HarryPotterSeries

d) 14Oct2004

 

v) Bharat has set up his company with 20 computers in a building. He wants to connect all the computers together. Which type of Network will be the best suitable for this purpose?

a) LAN

b) WAN

c) PAN

d) MAN

 

vi) IP stands for _______________ .

a) International Protocol

b) Internet Protocol

c) Intranet Protocol

d) Interpersonal Protocol

 

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.

6. What are the learning objectives of communication? 

7. Why do we say that an entrepreneur should be open-minded? 

8. How is self-regulation connected to the ability to work independently? 

9. How we can prevent computer against attack by viruses. 

10. “Green economy promotes sustainable development”. Justify the statement. 

 

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

11. What do you understand by Anchoring in Word Processor? 

12.What do you mean by Sorting in a Spreadsheet? 

13. State any four etiquettes to be followed while chatting on the internet. 

14. How is Goal Seek different from Solver in a Spreadsheet? 

15. Differentiate between a Primary key and Foreign key. 

16. What is the importance of healthy lifestyle? Give any four points related to it. 

 

Answer any 3 out of the given 5 questions in 50– 80 words each (4 x 3 = 12 marks)

17. What do you understand by the term Table of Contents? List the characteristics of a good ‘Table of content’ in a word processor.

18. Explain the term ‘Scenarios’ in relation to the Spreadsheets with example.

19. Explain different kinds of online threats. 

20. Explain the term “Referential Integrity”. Why is it important in a database? 

21. consider the following Vendor table and write the queries for the following:

Table Datesheet

IT 402 Sample Paper

 

i) Write a SQL command to display the records in ascending order by date of exam.

ii) Write a query to display the above date sheet.

iii) Write a query to display the subject name and date of the exam held on ‘Monday’

iv) Write a SQL command to display the date of exam and Sub_Name of Science subject.

 

 

Solution: Class 10 IT 402 Sample Question Paper 2024

Section A: Objective Type Questions

Question 1 

i) Answer: b) Interpersonal Barrier

ii) Answer: b) Ishan: Install reliable antivirus software and update

iii) Answer: b) Stress Management

iv) Answer: b) Emotional

v) Answer: d) All of these

vi) Answer: c) United Nations

 

Question 2

i) Answer: b) Background

ii) Answer: b) White

iii) Answer: c) Alignment

iv) Answer: a) Data Source

v) Answer: b) Sharpen

vi) Answer: b) DSL

 

Question 3

i) Answer: c) Solver

ii) Answer: b) Link Worksheet

iii) Answer: a) Detective

iv) Answer: b) Sheet Tab

v) Answer: b) Comparing

vi) Answer: c) Name

 

Question 4

i) Answer: c) Form

ii) Answer: b) 3

iii) Answer: c) SQL

iv) Answer: b) Varchar

v) Answer: d) F5

vi) Answer: a) 1

 

Question 5

i) Answer: b) Sticky

ii) Answer: a) Blog

iii) Answer: c) Google

iv) Answer: b) 14Hd{]$_Sb10

v) Answer: a) LAN

vi) Answer: b) Internet Protocol

Section B: Subjective Type Questions

6. Answer: The learning objectives of communication include clarity, understanding, and effective information transfer.

7. Answer: An entrepreneur should be open-minded to adapt to change, identify opportunities, and creatively solve problems.

8. Answer: Self-regulation is connected to working independently by fostering discipline, focus, and the ability to manage time effectively.

9. Answer: To prevent computer virus attacks, use reliable antivirus software, keep software updated, and avoid suspicious downloads.

10. Answer: A green economy promotes sustainable development by emphasizing eco-friendly practices, resource conservation, and environmental responsibility.

Section B: Subjective Type Questions (Short Responses)

11. Answer: Anchoring in a word processor refers to fixing a specific position for an object or text within a document.

12. Answer: Sorting in a spreadsheet organizes data in a specified order, typically alphabetically or numerically.

13. Answer: Internet chatting etiquettes include using proper language, avoiding all caps, respecting privacy, and being mindful of time zones.

14. Answer: Goal Seek adjusts one variable to achieve a specific goal, while Solver optimizes multiple variables to reach an objective in a spreadsheet.

15. Answer: A primary key uniquely identifies records in a table, while a foreign key establishes a link between tables by referencing the primary key of another table.

16. Answer: A healthy lifestyle is important for physical and mental well-being, promoting longevity, reducing disease risks, improving mood, and enhancing overall quality of life.

Section B: Subjective Type Questions (Longer Responses)

17. Answer: A Table of Contents in a word processor outlines the document’s structure. Characteristics of a good one include clear formatting, accurate page numbers, and logical organization.

18. Answer: Scenarios in spreadsheets involve creating different sets of data for analysis. For example, analyzing budget scenarios with varying income and expenses.

19. Answer: Different online threats include malware, phishing, ransomware, and identity theft, posing risks to data security and privacy.

20. Answer: Referential Integrity ensures relationships between tables in a database remain valid, preventing inconsistencies and maintaining data accuracy.

21. SQL Queries:

i) SELECT * FROM Datesheet ORDER BY DateofExam ASC;

ii) SELECT * FROM Datesheet;

iii) SELECT Sub_Name, DateofExam FROM Datesheet WHERE Days=’Monday’;

iv) SELECT DateofExam, Sub_Name FROM Datesheet WHERE Sub_Name=’Science’;

 

By cbsepython

A complete solution for the students of class 9 to 12 having subject Information Technology (402), Computer Science (083). Explore our website for all the useful content as Topic wise notes, Solved QNA, MCQs, Projects and Quiz related to the latest syllabus.

Copywrite © 2020-2024, CBSE Python,
All Rights Reserved