CBSC 10th Information Technology Sample Paper 10 Page 1
Sample Paper 10
INFORMATION TECHNOLOGY (402)
Class X Session 2024-25
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) Meera is attending a workshop on effective communication and is learning about the role of feedback in
conversations. What is the importance of feedback in communication?
(a) It allows the speaker to dominate the conversation
(b) It helps in avoiding any further communication
(c) It facilitates understanding, clarification, and improvement
(d) It discourages active listening
(ii) Anita is studying stress management techniques in her psychology class and learned that positive stress
can motivate individuals to achieve their goals. The good stress is called _____
(a) eustress (b) emstress
(c) Both (a) and (b) (d) None of these
(iii) Ravi, a budding entrepreneur, is learning about effective leadership in his management class. He wants
to know the best approach to get work done efficiently from his team. Based on this, how can an
entrepreneur get the work done from his/her team?
(a) By creating a spirit of teamwork (b) By motivation
(c) Using harsh words and actions (d) Both (a) and (b)
Install NODIA App to See the Solutions.
Click Here To Install
Page 2 Sample Paper 10 NODIA
(iv) Windows 10 is an operating system developed by _____.
(a) MicrosoftTM (b) IBM
(c) Samsung (d) Sony
(v) What is the primary goal of green skills training?
(a) To reduce employment opportunities
(b) To promote sustainable practices and industries
(c) To prioritize economic growth over environmental concerns
(d) To discourage technological advancements
(vi) Managing stress is about making a plan to be able to cope effectively with daily pressures. Always keep
in mind the ABC of stress management. The acronym ABC stands for
(a) Ability, Burden, Concise (b) Adore; Belief, Cause
(c) Adversity, Beliefs, Consequences (d) Adapt, Balance, Cooperate
2. Answer any 5 out of the given 6 questions
(i) To start the macro recorder, which of the following command is used?
(a) Tools " Macros " Record Macro (b) Tools " Record " Record Macro
(c) Data " Macros " Record (d) None of the above
(ii) Cell referencing can be done by using a _____ as well as _____.
(a) keyboard, windows menu (b) keyboard, mouse
(c) windows menu, mouse (d) None of the above
(iii) After adding the data source, you need to specify the salutation. The selected salutation will be
displayed in the pane.
(a) salutation (b) preview
(c) display (d) None of these
(iv) We can rename a new sheet in Calc.
(a) After inserting a new sheet (b) While inserting a new sheet
(c) Both (a) and (b) (d) None of the above
(v) In case, another user is trying to save the shared worksheet and resolve conflicts, you see a message that
the shared spreadsheet file is due to a merge in progress.
(a) stopped (b) locked
(c) Both (a) and (b) (d) None of the above
(vi) Full form of OLE is _____.
(a) Object Linked and Embedded (b) Option Linking and Embedding
(c) Open Linking and Embedding (d) Object Linking and Embedding
Continue on next page.....
Install NODIA App to See the Solutions.
Click Here To Install
CBSC 10th Information Technology Sample Paper 10 Page 3
3. Answer any 5 out of the given 6 questions
(i) If a table has to be created which tab and group should be used?
(a) Insert tab " Tables group (b) Home tab " Tables group
(c) Design tab " Tables group (d) None of the above
(ii) _____ is a computer program that provides services to other computer programs.
(a) Server (b) Client
(c) Network (d) None of these
(iii) State True or False.
ClipArt object includes effects such as shadows, outlines, colors, gradients and 3D effects.
(a) True
(b) False
(iv) Which of the following is not the main building block of a database?
(a) Lists (b) Queries
(c) Reports (d) Forms
(v) Raj is working on a spreadsheet and wants to make changes to multiple sheets simultaneously. His
instructor told him about grouping sheets. Based on this, in order to group sheets, while holding the
_____ key, click on the Sheets tab you want to grou
(a) Alt (b) Shift
(c) Ctrl (d) Tab
(vi) In a document, you can insert _____.
(a) Pictures (b) ClipArts
(c) Shapes (d) All of these
4. Answer any 5 out of the given 6 questions
(i) In Calc, you can insert the data from different databases and other data sources. One such format is
(a) odd (b) .dbms
(c) .odb (d) .ods
(ii) TCL commands are used to manage _____ in database.
(a) data (b) values
(c) transactions (d) None of the above
(iii) _____ is a network architecture which separates the client from the server.
(a) Client Server Network (b) Peer - to - Peer Network
(c) Both (a) and (b) (d) None of the above
Continue on next page.....
Install NODIA App to See the Solutions.
Click Here To Install
Page 4 Sample Paper 10 NODIA
(iv) _____ is used to begin text-to-speech utility that reads what is displayed on the screen.
(a) Start Narrator (b) Web page
(c) Website (d) None of these
(v) _____ provides the physical connection between the network and computer workstation.
(a) LIC (b) NC
(c) NIC (d) None of the above
(vi) In the hierarchy of headings, the lower - level headings pertain to _____ and _____.
(a) section, sub-sections (b) headings, sub-headings
(c) Both (a) and (b) (d) None of the above
5. Answer any 5 out of the given 6 questions
(i) A web page is located using a
(a) Universal Record Linking (b) Universal Record Locator
(c) Uniform Resource Locator (d) Uniformly Reachable Links
(ii) To create the link from one document to another, both the documents should be
(a) open (b) closed
(c) Both (a) and (b) (d) None of these
(iii) Blog Desk is an offline blog editor which is used for _____ operating system.
(a) Linux (b) Unix
(c) Windows (d) None of the above
(iv) _____ is an inquiry into the database made using the SELECT statement.
(a) Query (b) Data
(c) Equation (d) None of these
(v) _____ leads to data inconsistency.
(a) Data integrity (b) Data sharing
(c) Data redundancy (d) Data recovery
(vi) Which of the following is a single piece of data?
(a) Field (b) Table
(c) Record (d) Form
Continue on next page.....
Install NODIA App to See the Solutions.
Click Here To Install
CBSC 10th Information Technology Sample Paper 10 Page 5
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. Riya, a high school student, is preparing for a motivational workshop and has come across the concept
of self-motivation. She wants to understand its significance. Based on this context, explain the term self-
motivation.
7. What is the role of green skills in mitigating climate change?
8. How can communication skills impact career success?
9. Arjun is attending a business seminar where the term entrepreneur is frequently mentioned. To complete his
understanding, he asks, “What do you mean by the term entrepreneur?”
10. Define multi-processing and multi-user operating system.
Direction for Q 11-Q 16 : Answer any 4 out of the given 6 questions in 20-30 words each.
11. State the use of Consolidating Data in a spreadsheet.
12. Explain the term table used in database.
13. Priya is learning spreadsheet formulas in her computer class. Her teacher discussed the concept of cell
reference and its importance. To clarify further, Priya asks, “What is cell reference? Also, write the use of
a cell reference in one or several formulas.”
14. What are the steps to apply first aid roller bandage to a wound?
15. Distinguish between switch and repeater.
16. Describe the significance of using templates in your documents.
Direction for Q 17-Q 21 : Answer any 3 out of the given 5 questions in 50-80 words each.
17. Samiksha is working on an advanced spreadsheet project and wants to understand the use of some key tools
in data analysis. She asks, “Describe the use of the following terms:
(i) Goal Seek
(ii) Scenario
(iii) Subtotal
(iv) Solver
Continue
on next page.....
Install NODIA App to See the Solutions.
Click Here To Install
Page 6 Sample Paper 10 NODIA
18. Prashant wants to know about Data Manipulation language commands. Solve the following queries for him.
(i) What is DML?
(ii) Explain any three DML commands.
19. Harmanpreet had inserted an image in a word processor application. Now, she wants to know the use of the
following terms. Tell her the correct answer.
(i) Alignment
(ii) Anchoring
20. Aman is analyzing a database table named APPLICANTS for his project and has come across the following
dataset:
TABLE : APPLICANTS
No. NAME FEE GENDER C_ID JOINYEAR
1012 Amandeep 30000 M A01 2012
1102 Avisha 25000 F A02 2009
1103 Ekant 30000 M A02 2011
1049 Arun 30000 M A03 2009
1025 Amber 40000 M A02 2011
(i) How many records and fields are there in the table APPLICANTS.
(ii) Write the SQL queries to:
(a) Display NAME, FEE, GENDER, JOINYEAR about the APPLICANTS, who have joined before
2010.
(b) Display the NAMES of all APPLICANTS in ascending order of their JOINYEAR.
(c) Display the details of APPLICANTS of female.
21. Chetanya is studying networking and technology for his upcoming exam. He is curious about some commonly
used terms and asks, “What are the functions of the following terms?
(i) Modem
(ii) Web page
(iii) Wi-fi
(iv) GPS
******
Install NODIA App to See the Solutions.
Click Here To Install
