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) Ananya is attending a workshop on communication skills. The instructor emphasizes that communication is not just about expressing ideas but also about understanding others, which requires a combination of skills. Effective communication involves_______
(a) Speaking only
(b) Listening only
(c) Speaking and listening
(d) Writing and reading
(ii) Aman, a new entrepreneur, is working to expand his business by finding a suitable market. He focuses on promoting his products through advertisements and publicity while appointing selling agents to ensure better market reach. To find a suitable market an entrepreneur performs the functions of_____
(a) advertisement and publicity
(b) appointment of selling agents
(c) new organisation structure
(d) Both (a) and (b)
(iii) Riya is organizing her files and notices each has a name and extension, like .docx or .pdf, indicating the type of information stored. What is a file?
(a) A file is a section of main storage used to store data
(b) A file is a collection of information that has been given a name and have an extension
(c) A file is the part of a program that is used to describe what the program should do
(d) A file can be saved only in CDs.
(iv) In _____ , we change from our normal activities to silence.
(a) meditation
(b) stress
(c) worries
(d) survival
(v) Sustainable development ensures current needs are met without harming future generations. It balances economic growth, social progress, and environmental protection. What is the meaning of sustainable development?
(a) Development that focuses on economic growth only
(b) Development that meets the needs of the present without compromising future generations.
(c) Development that prioritizes social progress over environmental protection
(d) Development that relies solely on renewable energy sources
(vi) When danger arises, humans and animals instinctively react with heightened alertness and energy. This response, known as “fight or flight,” ensures safety and survival._____ is a common response to danger in all people and animals.
(a) Internal stress
(b) Environmental stress
(c) Survival stress
(d) Fatigue related stress
2. Answer any 5 out of the given 6 questions.
(i) When you define a field for a table, in which of the following parameters do access always considered optional?
(a) Field name
(b) Data type
(c) Field size
(d) Description
(ii) Akshat wants to store a huge amount of information about his firm in a database. Which type of table organisation would be most suitable for this purpose?
(a) Relational
(b) Flat file
(c) Either relational or flat file
(d) Hierarchical
(iii) _____ include fonts, alignment, borders, background, number formats (for example, currency, date, number) and cell protection in document.
(a) Cell style
(b) Numbering style
(c) Paragraph style
(d) Character style
(iv) A _____ is a language that enables users to access and manipulate data in a database.
(a) DML
(b) DCL
(c) TCL
(d) DDL
(v) When you apply a _____, you apply a group of formatting effects together in one single step.
(a) effect
(b) template
(c) style
(d) format
(vi) Safari is a web browser developed by _____.
(a) Google
(b) Microsoft
(c) Apple
(d) None of these
3. Answer any 5 out of the given 6 questions.
(i) Calc considers any data that it does not recognise as a number, date, time or formula, as:
(a) Expression
(b) Equation
(c) Text
(d) Function
(ii) State True or False.
‘Goal seek in Calc, helps us to find the desired result by adjusting an input value.’
(a) True
(b) False
(iii) Which of the following tools will help Swati, if she wants to arrange the height of students in her class in ascending order ?
(a) Ordering data
(b) Sorting data
(c) Presenting data
(d) Referring data
(iv) In ____ topology each node is connected to two and only two neighbouring nodes.
(a) star
(b) ring
(c) mesh
(d) tree
(v) Rajiv was asked to highlight the cells with green colour where the value entered is either greater than or equals to 120 in the worksheet containing thousands of data entries. Which feature of Calc should he use to get this work done within seconds?
(a) Conditional formatting
(b) Filtering
(c) Sorting
(d) Simple formatting
(vi) Select _____ ” Track changes ” Record from the menu bar. Thereafter, every change you record on the spreadsheet will have a red border around it.
(a) File
(b) Edit
(c) Format
(d) Layout
4. Answer any 5 out of the given 6 questions.
(i) What dialog box opens on choosing File ” Templates ” Manage Templates in Writer?
(a) The File dialog box
(b) The Manage Templates dialog box
(c) The Templates dialog box
(d) The Record Template dialog box
(ii) Which shortcut key is used to make the selected text italic?
(a) Ctrl + I
(b) Shift + I
(c) F1 + I
(d) None of these
(iii)_____ are the ways to produce the data stored in databases and tables in a printed form.
(a) Forms
(b) Queries
(c) Reports
(d) Data
(iv) Tamanna wants to know the name of the kind of software which seems useful in the beginning, but will cause damage to the computer once installed. What is such kind of software called?
(a) Trojan horse
(b) Worm
(c) Malware
(d) Virus
(v) In URL, http : //www.freejobalert.com/index.htm, which component identifies the path of a web page?
(a) http
(b) www.freejobalert.com
(c) /index. htm
(d) All of the above
vi) Arnab learnt about a software which gets installed on the computer without the user’s knowledge. Help him to find the name of the same.
(a) Spyware
(b) Malware
(c) Adware
(d) None of these
5. Answer any 5 out of the given 6 questions.
(i) Rinky wants to know about the Number data type in Calc. Which of the following statement(s) is/are
TRUE about it?
(a) Numbers are generally raw numbers or dates.
(b) Numbers can be started with a dollar sign ($) or with some other currency symbols to display as currency.
(c) By default, number and date data is aligned to the right in Calc.
(d) All of the above
(ii) If the two departments (HR and IT) access the data simultaneously then only one department will see the updates by the other department. DBMS solves this issue. Thus, DBMS helps to avoid _____ which means if a single database is used by multiple users then it also ensures that the same data is present for all the users.
(a) Data redundancy
(b) Data inconsistency
(c) Data piracy
(d) Data modification
(iii) _____ is a form of electronic commerce that allows customers to directly buy goods or services from a seller on the Internet.
(a) E-Shopping
(b) E-ticketing
(c) E-buying
(d) E-Delivery
(iv) Line or paragraph spacing is measured in terms of lines or points, which is referred as _____
(a) text wrapping
(b) PDF
(c) XPS
(d) leading
(v) Which tab is used to create Table of Contents in a document?
(a) File tab
(b) Format tab
(c) Insert tab
(d) Styles tab
(vi) How much space does the DATE/TIME data type hold in Base?
(a) 2 bytes
(b) 4 bytes
(c) 8 bytes
(d) 10 bytes
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. Ravi launched a digital platform with AI-driven tools to help small businesses manage their online presence affordably. His unique features quickly attracted local entrepreneurs Explain innovativeness as a quality of entrepreneur.
7. During a job interview, Swati explained that employers value qualities like communication, problem-solving, adaptability, and teamwork in candidates, along with a positive attitude and leadership potential. When interviewing job candidates, what qualities do employers find impressive?
8. What are the facilities provided by operating system?
9. A country launched a “Green Skills Initiative” with vocational courses in renewable energy and waste
management, subsidies for green jobs, and environmental education. What policies can support the development of green skills?
10. What do you mean by internal stress?
Direction for Q 11-Q 16 : Answer any 4 out of the given 6 questions in 20-30 words each.
11. Define router as network device.
12. What is the purpose of a primary key in a database management system?
13. When is Memo data type is preferred over Text data type for a field?
14. Ravi, a financial analyst, uses electronic spreadsheets to manage large volumes of financial data. He stores, edits, and retrieves data efficiently while also using charts to present data visually for better analysis and reporting. Write down the significance of electronic spreadsheets.
15. Explain the role of template in word processor.
16. What are slipping and tripping hazards?
Direction for Q 17-Q 21 : Answer any 3 out of the given 5 questions in 50-80 words each.
17. Nodia stationery keeps stock of various stationeries in his shop. The proprietor wants to maintain a stock value and reorder level for following items as given in a spreadsheet. Write formulas for the operation.
(i) To calculate the Stock Value as product of ‘Quantity in Stock’ and ‘Rate’ for each item present in the
spreadsheet.
(ii) To calculate the ‘Quantity to Order’ as ‘Minimum Stock Quantity’- ‘Quantity in Stock’ for each item.
(iii) To calculate the ‘Order Value’ as product of ‘Quantity to Order’ and ‘Rate’ for the items if ‘Quantity
to Order’ > = 0, else assign the value as 0.
(iv) Proprietor wants to graphically represent his stationery stock. Suggest him the most appropriate feature of MS-Excel.
18. How can a document’s style be changed? Explain with proper steps.
19. Ajay is learning about the different terms and commands of a database. He came across the following terms.
Tell him the definition of the following-
(i) Insert command
(ii) Select command
(iii) Delete command
(iv) DCL command
20. Consider the following table: Employee.
(a) How many fields and records are there in the table Employee?
(b) Write the SQL queries for the following:
(i) Display E_name and salary of those employees whose Salary is less than or equal to 16000.
(ii) Display details of employees who are getting commission of `300 or greater.
(iii) Display all the details of the employee profile ‘CLERK’.
21. Sonia had heard about the various types of ISPs. She had some doubts. Answer to her queries to clear her doubts.
(a) What is an ISP?
(b) Name any two ISPs of India.
(c) Name any two connection types that home users use.
(d) What is satellite?
