CBSE Sample Paper Information Technology Class 10 For 2024-25 A Comprehensive Guide | TutorialAICSIP

CBSE Sample Paper Information Technology Class 10 for 2024-25 has been released by CBSE on its official website. The board has released SQP for 2024-25 for skill courses. So let us discuss CBSE Sample Paper Information Technology Class 10 for 2024-25. Here we begin!

CBSE Sample Paper Information Technology Class 10 for 2024-25

If you are studying in class in 10 and searching for CBSE Sample Paper Information Technology Class 10 for 2024-25, you are landing on the right page. Here I will discuss CBSE Sample Paper Information Technology Class 10 for 2024-25 in detail.

CBSE Sample Paper Information Technology Class 10 curriculum is divided into two parts:

• Part A – Employability Skills – 10 Marks
• Part B – Subject Specific Skills – 40 Marks

Part A Employability skills unit wise weightage

The unit wise marks distributions are as follows:

Part B Subject Specific Skills Unit Wise weightage

Now let us see the general instructions for CBSE Sample Paper Information Technology Class 10 for 2024-25. Here it is!

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.

Now let’s begin the discussion of CBSE Sample Paper Information Technology Class 10 for 2024-25. Here we go!

Section A Objective Type Questions – CBSE Sample Paper Information Technology Class 10 for 2024-25

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

i. What is the importance of effective communication in a workplace?

(a) Reducing office expenses

(b) Enhancing team collaboration and productivity

(c) Increasing employee vacation days

(d) Improving office aesthetics

Ans.: (b) Enhancing team collaboration and productivity
(a) Reducing office expense, (c) Increasing employee vacation days and (d) Improving office aesthetics are irrelevant options.

ii. High expectations from self can leave with chronic anxiety and stress, thus leading to ____________ stress.
(a) Physical

(b) Emotional

(c) Social

(d) Financial

Ans.: (b) Emotional
(a) Physical Stress related to body and related problems such as aches and pains, digestive issues, sleeping problems, sexual problems, high BP etc.
(c) Social Stress rises from a person’s relationships with others or from the social environment as a whole
(d) Financial stress arises due to financial problems such as money problems, debt, expenses or loses.

iii. John notices that the cost of raw materials is lower in a different supplier’s location compared to his current supplier. He decides to switch to the new supplier to save money. Which function that the entrepreneur is doing?
(a) Makes decisions
(b) Divides income
(c) Takes risk
(d) Innovation

Ans.: (a) Make Decisions
He is making decisions over here.
(b) Divide income function is related to divide the income received from business into different categories
(c) Takes risk function involves performing some actions where loss or some other problems may occur
(d) Innovation refers

iv. Imagine you are working on a challenging project for your studies, and you have a tight deadline. No one is around to cheer you on or offer encouragement, but you need to push through and complete the work. What will make you complete work without others cheering you?
(a) Self-confidence
(b) Communication
(c) Self-motivation
(d) Self-esteem

Ans.: (c) Self Motivation
(a) Self Confidence refers to the belief that can a person can accomplish that what he/she want to do.
(b) Communication refers to exchanging ideas, opinions etc.
(d) Self-esteem refers to how a person feels about herself/himself based beliefs and opinions

v. Which organization has adopted the Sustainable Development Goals.
(a) UNICEF

(b) League of Nations

(c) United Nations

(d) World Health Organization

Ans.: (c) United Nations

vi. What should you do to ensure secure online transactions?
(a) Lock your computer
(b) Give credit card or bank details only on safe websites
(c) Use anti-virus
(d) Do not use pirated software

Ans.: (b) Give credit card or bank details only on safe websites

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

i. What is a style in LibreOffice Writer?
a) A method of typing

b) A collection of all formatting information
c) A tool for drawing shapes

d) A spell-check feature

Ans.: (b) A collecetion of all formatting information
A style is a set of formatting in word processing software

ii. Which of the following is an example for absolute cell referencing?
(a) C5

(b) $C$5

(c) $C

(d) #C

Ans.: (b) $C$5

iii. Which of the following tabs is by default active when the Table of Contents, Entries or Bibliography dialog box is opened?
(a) Entries
(b) Background
(c) Styles
(d) Type

Ans.: (d) Type

iv. Which of the following is true about Track Changes feature of Writer?
(a) You cannot record a change made in the document.
(b) A comment of a particular author only can be deleted
(c) Any change made to the document is permanent.
(d) None of the above

Ans.: (b) A comment of a particular author only can be deleted

v. Imagine you are a financial analyst tasked with analyzing quarterly sales data for a multinational corporation. The data is stored in separate sheets within an Excel workbook, each representing sales figures from different regions (e.g., North Zone, East Zone, South Zone). How can you efficiently view and compare quarterly sales data from multiple regions in a single spreadsheet to identify trends and relationships?
(a) By creating separate charts for each region’s data.
(b) By using the Consolidate function to combine information from all regional sheets into one summary sheet.
(c) By manually copying and pasting data from each region’s sheet into a new sheet.
(d) By deleting unnecessary data from each region’s sheet.

Ans.: (b) By using consolidate function to combine information from all regional sheets into one summary sheet.

vi. Sore lower back is caused due to _____.
(a) reaching forward frequently
(b) no lumbar support
(c) no upper back support from chair
(d) reaching forward for long periods

Ans.: (b) no lumbar support

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

i. What is the extension of spreadsheet file in Calc?
(a) .odb

(b) .odt

(c) .odg

(d) .ods

Ans.: (d) .ods

ii. Which of the following is the shortcut key to open the Templates dialog box?
(a) Ctrl+Alt+N

(b) Ctrl+Shift+N

(c) Ctrl+Alt+T

(d) Shift+Alt+T

Ans.: (b) Ctrl + Shift + N

iii. Which style category would you use to format a section containing text, graphics, and lists?
a) Page Style

b) Paragraph Style

c) Character Style

d) Frame Style

Ans.: (d) Frame Style

iv. It is a reference point for the graphics which is created while positioning any image. This point could be the page, or frame where the object is either a paragraph, or even a character in a word processor.
(a) Wrap Text

(b) Anchoring

(c) Alignment

(d) BookMark

Ans.: (b) Anchoring

v. Which of the following is an invalid Macro Name?
(a) 1formatword
(b) format word
(c) format*word
(d) Format_word

Ans.: (C) format*word

vi. A fresh food cafeteria helps to maintain the ________________________ of the employee.
(a) Health

(b) Morale

(c) Productivity

(d) Engagement

Ans.: (a) Health

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

i. Which of the following feature is used to jump to a different spreadsheet from the current spreadsheet in LibreOffice Calc?
(a) Macro
(b) Hyperlink
(c) connect
(d) Copy

Ans.: (b) Hyperlink

ii. Which of the following operations cannot be performed using LibreOffice Calc?
(a) Store and manipulate data
(b) Create graphical representation of data
(c) Analysis of data
(d) Mail merge

Ans.: (d) Mail merge

iii. The details associated with an entity are called _____________
(a) Table
(b) Attributes
(c) Records

(d) Primary key

Ans.: (b) Arributes

iv. The _________________ data is a combination of letters, numbers or special characters.
(a) Structured

(b) Unstructured

(c) Semi-structured

(d) Alphanumeric

Ans.: (d) Alphanumeric

v. Which kind of hazards can occur in IT industry?
(a) Biological
(b) Chemical
(c) Physical
(d) Ergonomic

Ans.: (d) Ergonomic

vi. In a Query Design wizard, which of the following buttons is clicked to move a field from ‘Available fields’ list box to ‘Fields in the query‘ list box?
(a) >

(b) <9

(c) ∨

(d) ∧

Ans.: (d)>

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

i. Identify the mode, where we can modify in the structure of table?
a. Datasheet view

b. Structure view

c. Design view

d. All of the above

Ans.: (c) Design View

ii. What is the primary purpose of a query in a database?
(a) To enter new records

(b) To create reports
(c) To retrieve specific data

(d) To design forms

Ans.: (c) To view specific data

iii. Which of the following is NOT true about forms?
(a) It is the front end for data entry
(b) It can contain text fields
(c) Graphics can be inserted on the form
(d) It can accept only fixed number of records

Ans.: (d) It can accept only fixed number of records

iv. For an organisation, the proper security procedures will reduce ____.
(a) liabilities

(b) insurance

(c) business revenue

(d) operational charges of the company

Ans.: (a) liabilities

v. Which of the following is not an example of ignition sources of open flames?
(a) Gas ovens

(b) Lighters in smoking areas

(c) Welding torches

(d) space heaters

Ans.: (d) space heaters

vi. Which action contributes to a healthy and safe working environment?
(a) Keeping emergency exits clear

(b) Leaving cables loose on the floor
(c) Ignoring safety warnings

(d) Using unapproved software

Ans.: (a) Keeping emergency clear

Section B Subjective Type Questions – CBSE Sample Paper Information Technology Class 10 for 2024-25

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 Imagine you are a high school student working on a group science project. You present your part of the project to your group, but you’re not sure if it meets the expectations or aligns with what the group needs. Why is it important for your classmates to give you feedback in this situation?

Ans.: Feedback helps you understand if your work aligns with group expectations, identifies areas for improvement, and ensures the project meets its goals effectively.
or any other relevant answer
2 marks for correct answer

Q – 7 List the ways in which an entrepreneur affects a society.

Ans.: Entrepreneurs run their businesses in a market. The market has people who buy products and services and people who sell them also. When people are buying and selling from each other, it is helpful for everyone because everyone involved makes money. This is how entrepreneurs help in growing the area and society they live in.
or any other relevant answer
2 marks for correct answer

Q – 8 Amit frequently experiences slow performance on his computer when working with large
spreadsheets and multiple applications. He notices that the system freezes and lags, especially when switching between programs.
What should Amit do to improve his computer’s performance in handling large
spreadsheets and multitasking?

Ans.: If we have been using a computer for a long time we have a lot of unnecessary files and data, such as temporary files and images. When they use too much hard-disk space, the performance of the computer goes down. It is important that we keep cleaning by removing any extra files. We can use some disk cleaner software, which help us clean up the unnecessary files.
or any other relevant answer
2 marks for correct answer

Q – 9 How can you manage emotional intelligence?

Ans.: Some steps to manage emotional intelligence are as given below.
• Understand your emotions: Observe your behaviour and note the things you need to work on. You can then work on the things you need to improve.
• Rationalise: Do not take decisions abruptly; be rational in your thinking.
• Practise: Do meditation and yoga to keep yourself calm.
2 marks for correct answer

Q – 10 How can individuals contribute to a sustainable future?

Ans.: Individuals can contribute to a sustainable future by reducing waste, conserving energy, supporting eco-friendly products, recycling, using sustainable transportation, and spreading awareness about environmental issues to promote responsible consumption and conservation of resources.
2 marks for correct answer

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

Q – 11 Describe the steps to create a custom style named ‘myStyle1’ using drag-and-drop.

Ans.: Create a custom style named ‘myStyle1’ using Drag and Drop, follow these steps:
1. Select the content which is formatted or from which the style needs to be created
2. Open Styles pane from Style > Manage Style option or press F11 or open from the side bar.
3. Now drag the selected content to the Styles window
4. It will open a new dialog box – New Style From selection.
5. Type new name “myStyle1” for the style – and click on OK button.
2 marks for correct answer

Q – 12 List and explain two common safety hazards in a workplace.

Ans.: Common safety hazards in workplace are as follows:
i. Slips, Trips, and Falls: Caused by wet floors, loose cables, or cluttered walkways.
ii. Electrical Hazards: Faulty wiring, overloaded circuits, or exposed electrical components.
iii. Manual Handling Injuries: Strains and sprains from lifting heavy objects improperly or without assistance.
(Mention any two)
1 marks for each correct hazard

Q – 13 What is use of What-if Scenarios?

Ans.: It is used to explore and compare various alternatives depending on changing conditions. It can be used in the beginning of any project to optimise the output. This tool is used to predict the output while changing the inputs which reflects the output and thus one can choose the best plan of action based on it.
2 marks for correct answer

Q – 14 How do Merging and Comparing Spreadsheets differ in Calc?

Ans.: It is used to explore and compare various alternatives depending on changing conditions. It can be used in the beginning of any project to optimise the output. This tool is used to predict the output while changing the inputs which reflects the output and thus one can choose the best plan of action based on it.
2 marks for correct answer

Q – 15 Describe referential Integrity.

Ans.: Referential Integrity ensures that relationships between tables in a database remain consistent. It means that a foreign key in one table must match a primary key in another table, or be null, to maintain accurate and valid links between related data.

Q – 16 What causes eye strain and how to avoid it?

Ans.: Potential Cause : Glares from overhead lights or windows eye glasses not correct need vision check Precaution: Re-orient your desk and computer so light is not directly behind or in front of you.
2 marks for correct answer

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

Q -17 Imagine you are preparing a series of school reports that need to include your school’s logo,
a picture of your project, and a standard footer with your name and class. Instead of adding and formatting these elements individually in each report, you use LibreOffice Writer templates to simplify this process.
a) How can we apply the template from the available template list?
b) When is exporting of templates useful?

Q – 18 Imagine you are a student organizing a fundraising event for your school club. You have a spreadsheet in LibreOffice Calc that lists donations from different sponsors. Each sponsor has contributed multiple times, and you need to summarize the total amount donated by each sponsor.

a) Which tool in Calc can be used to create the group automatically?
b) Which functions can be applied to the grouped data?
c) Which menu option is used to apply this Tool?
d) What is purpose of e (-)or (+) signs on grouped data?

Ans.:
a) In LibreOffice Calc Subtotal option is used to create the groups automatically.
b) The sum(),avg(), count(), max(), min() etc. functions can be applied to the grouped data.
c) Data > Subtotals
d) The (+) sign is used to expand the data , and the (-) sign is used collapse the data.
1 mark for each correct answer

Q – 19 What are Data Models? Explain different types of Data models.

Q – 20 Imagine you are a safety officer overseeing electrical maintenance work at a manufacturing
plant. To spread the awareness among your team you have to conduct training on safety
measures. List out electrical rescue techniques which you will discuss with them.

Q – 21 Consider the following table: Employee
Emp_id Name Salary Designation
E01 Kajal 78000 Manager
E02 Rahul 50000 Sales Executive
E03 Tarun 55000 Clerk

(a) You are tasked with designing a new employee database for your company. Based on the given table structure, identify the fields that would be necessary to store key information about each employee.

(b) As a database administrator, you need to ensure each employee has a unique identifier. Which field in the table would you choose as the primary key, and why?
(c) During a review of the employee database, you realize there could be another field apart from the primary key that can uniquely identify a record. Identify the field and justify why it could serve as an alternate key.
(d) You are integrating the employee table with another table that stores department details. Explain how you would use the primary key from the employee table and a foreign key in the department table to establish a relationship between the two tables. Illustrate with an example.

Ans.:
a. Ans: Emp_id, Name,Salary, Designation
b. Ans: Emp_id
c. Ans : Combination of Emp_id and Name
d. Primary Key: Unique identifier for each row in a table, cannot be NULL.
Example: Emp_id in Employees. Foreign Key: Links to a primary key in another table, establishing relationships. Example: Emp_id in Orders referencing Emp_id in Employees

Follow this link for NCERT solutions and questions and answers for Information Technology all chapters.

Related