Check out CBSE Board Class 10 Sample Paper Information Technology (402),If you are a student of CBSE Board Class 10 and Information Technology is your additional subject, then this post is very important for you. Through this post, you can prepare for your exams very effectively, as we are providing you CBSE Board Class 10 Sample Paper Information Technology that have been Made by experts. If you prepare well using these sample papers, we are confident that you can achieve good marks in your examination.
CBSE Board Class 10 Sample Paper Information Technology
Class – 10th
Session – 2024 – 25
Subject – Information Technology (402)
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.
SECTION – A
Objective Type Questions
1. Answer any 4 out of the given 6 questions based on Employability Skills.
(i) Priya, a student under exam pressure, feels irritable, struggles with sleep, and is often tired. However, she shows no signs of fever. Which of the following is not a symptom of stress?
(a) Irritability
(b) Insomnia
(c) Fatigue
(d) Fever
(ii) Ravi is learning about various types of entrepreneurship like social, agricultural, and women focused.
However, he wonders if leadership is considered a type of entrepreneurship. Which of the following is not a type of entrepreneurship activities?
(a) Social
(b) Agricultural
(c) Women
(d) Leader
(iii) Ramesh turned on his computer to complete an assignment. As the computer started, the operating system loaded into the main memory from the hard disk, enabling him to use the system. What is this process called?
(a) uploading
(b) booting
(c) starting
(d) downloading
(iv) The drive within you that compels you to complete tasks is—-
(a) self-motivation
(b) self-regulation
(c) self-awareness
(d) self-sufficient
(v) A manager is addressing his team about a new project. During the discussion, some team members struggle to understand because the manager uses complex jargon and technical terms. However, other factors like clear messaging and active listening help the team grasp some aspects. Which of the following is a barrier to effective communication?
(a) Use of jargon and technical terms
(b) Clear and concise messaging
(c) Active listening
(d) Mutual understanding
(vi) What is the role of green skills in waste management?
(a) Encouraging unsustainable disposal methods
(b) Promoting recycling and composting practices
(c) Increasing landfills and waste accumulation
(d) Disregarding the concept of resource conservation
2. Answer any 5 out of the given 6 questions
(i) Template includes placeholder text that is surrounded by _____.
(a) arrow
(b) brackets
(c) data source
(d) commas
(ii) Which of the following is an attribute whose value is derived from the primary key of some other table?
(a) Primary key
(b) Foreign key
(c) Alternate key
(d) None of these
(iii) Do not use the elevator in times of fire in the building. Always use _____ for such emergencies.
(a) office space
(b) staircase
(c) washroom
(d) None of these
(iv) Solve option under Tools menu amounts to a more elaborate form of _____. The difference is that the Solver deals with equations with multiple _____.
(a) unknown variables, goals seek
(b) variables, equation
(c) goal seek, unknown variables
(d) subtotal, goal seek
(v) In a computer class, students learn that databases store large amounts of data, allow easy updates, sorting, querying, and generate reports, unlike other tools like spreadsheets or graphic editors. What is a key ability of databases?
(a) store a large amount of data in a structured format, easy update, sort query, production of reports.
(b) spell check, perform calculations, library of mathematical functions, replication.
(c) rotate images, copy and paste, fill scale.
(d) None of the above
(vi) In the Load Style dialog box, option loads the paragraph and the character styles from the selected document into the current document.
(a) Page
(b) Paragraph
(c) Overwrite
(d) Text
3. Answer any 5 out of the given 6 questions.
(i) Editing Custom Shapes feature allows _____ of small segments of a drawing.
(a) shaping
(b) reshaping
(c) rehearse
(d) None of these
(ii) Which tab is used to share the worksheet data?
(a) Home
(b) Review
(c) Insert
(d) Layout
(iii) Rahul is working on a project that requires transferring large files between computers on the same network. His teacher explains that there is a specific protocol designed for this purpose, making file transfer efficient and reliable. What is used to transfer files between computers on a network?
(a) Web server
(b) FTP
(c) Multimedia
(d) Web browser
(iv) A tuple in RDBMS is referred to _____of a table.
(a) record
(b) field
(c) table
(d) key
(v) Which of the following is not a spreadsheet software?
(a) VisiCalc
(b) MS-Excel
(c) Writer
(d) Lotus 1-2-3
(vi) _____ function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.
(a) Summation
(b) Data Consolidation
(c) Data Format
(d) Data Chart
4. Answer any 5 out of the given 6 questions.
(i) By dragging any _____ handle you can increase or decrease the _____ of the image diagonally.
(a) corner, size
(b) side, quality
(c) top, depth
(d) corner, quality
(ii) Wireless broadband can be_______
(a) mobile
(b) fixed
(c) Both (a) and (b)
(d) None of these
(iii) _____ can deal with multiple variables as the goal seek is used to manipulate one variable cell.
(a) Solver
(b) Goal Seek
(c) Scenario
(d) what-if
(iv) _____ ensure that all the documents have a standard layout, look and feel.
(a) Graphics
(b) Layout
(c) Properties
(d) Templates
(v) To join the Internet, the computer has to be connected to a_______
(a) Internet Architecture Board
(b) Internet society
(c) Internet Service Provider
(d) None of these
(vi) A relational database is a collection of______
(a) attributes
(b) tables
(c) records
(d) fields
5. Answer any 5 out of the given 6 questions.
(i) Which of the following is an AutoShape?
(a) Line
(b) Circle
(c) Curve
(d) All of these
(ii) _____ determines the range of field values.
(a) Field Name
(b) Data Type
(c) Field Size
(d) Description
(iii) Which type of hazard can cause skin irritation, illness or breathing problems?
(a) Chemical hazard
(b) Biological hazard
(c) Slipping hazard
(d) None of the above
(iv) If you have unsafe and unhealthy workplace, there will be higher days lost and will have higher___
(a) employee satisfaction
(b) productivity
(c) stress levels
(d) None of these
(v) Which of the following is/are TCL commands?
(a) COMMIT
(b) SAVE POINT
(c) ROLL BACK
(d) All of the above
(vi) Rajat has received a spreadsheet, which is reviewed by his subordinates Puneet, Kavya and Aman, who made some corrections in it. Before Rajat shared the spreadsheet with his subordinates, he has activated the track changes feature. Which of the following option he should use now to keep some of the changes made by them?
(a) Accept and reject changes
(b) Overwrite and keep changes
(c) Both (a) and (b)
(d) None of the above
SECTION – B
Subjective Type Questions
Direction for Q 6-Q 10 : Answer any 3 out of the given 5 questions on Employability skills. Answer each question in 20-30 words.
6. Aman recently purchased a new laptop but noticed it could not function without specific software that manages hardware and software resources. His friend explained that this software acts as an essential interface between the user and the computer, allowing the system to operate effectively. What is the software mentioned in the paragraph, and what does it do?
7. What is fatigue related stress? Why is it difficult to avoid?
8. What is the contribution of the entrepreneurs in the execution of Government policies?
9. Ravi’s team meeting lacked preparation, leading to confusion and unclear messaging about their roles. In what way does inadequate planning hinder effective communication?
10. How can individuals acquire green skills?
Direction for Q 11-Q 16 : Answer any 4 out of the given 6 questions in 20-30 words each.
11. What is the difference between absolute and relative hyperlinks as used in Calc?
12. What do you mean by template?
13. Elucidate the following terms:
(i) PAN
(ii) WiMAX
14. During a database design session, Priya learns that certain keys help maintain relationships between tables.
The teacher explains that one specific key enforces referential integrity by linking data across different tables. What is the role of a foreign key in a database management system (DBMS)?
15. State any two practices for internet security.
16. Write the steps to insert a record in a Datasheet View.
Direction for Q 17-Q 21 :Answer any 3 out of the given 5 questions in 50-80 words each.
17. Riddhima is working on a project that involves sending letters to multiple recipients. She wants to use a word processor to create mailing labels for each recipient efficiently. She seeks answers to understand the concept and the steps involved in preparing and printing these labels.
(a) What is a mailing label?
(b) What are the ways to prepare and print mailing labels?
18. Shubham is a student learning about database management systems (DBMS). He wants to understand the purpose of DBMS and its practical uses in real-world applications. He wants to know about the following:
(a) The purpose of DBMS
(b) Any two uses of DBMS
19. Shreya is analyzing a database table. The table contains information about various products, their quantities, costs, and the cities where they are available. She needs to perform certain tasks based on this table:
(i) How many fields and records are there in PRODUCT table?
(ii) Write SQL queries for the following:
(a) Display all Products whose Qty is between 100 and 400.
(b) Display S_Name, P_Name, Cost for all the Products whose Qty is less than 300.
(c) Display all the records alphabetically by S_Name.
20. Rita is working in spreadsheet. She wants to know about the use of the following terms:
(a) Quick Sort
(b) Filtering Data
21. Rahul has purchased some stationary items from an online site. He has to make online payment for the items to complete the transaction. Help him by answering the following queries :
(i) Suggest any two options that he can use to make payment of his bill on the online shopping website.
(ii) Name any 2 situations where online shopping could be useful.
(iii) Name any 2 popular online shopping websites.
(iv) Write full form of COD in reference to online shopping.
