CBSC 10th Information Technology Sample Paper 07 Page 1
Sample Paper 07
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) Riya is preparing a presentation on sustainable development for her school project. She is researching
solutions that align with the principles of sustainability and comes across some practices that do not
support this goal. Which of the following is not a solution for sustainable development?
(a) Education and awareness programs (b) Sustainable agriculture practices
(c) Deforestation and habitat destruction (d) Green technology advancements
(ii) Aarav is a student who constantly sets high expectations for himself to excel in academics and
extracurricular activities. Over time, he begins to experience chronic anxiety and stress due to his
self-imposed pressure. High expectations from self can leave one with chronic anxiety and stress, thus
leading to _____ stress.
(a) physical (b) emotional
(c) mental (d) financial
(iii) Meera is preparing for a presentation on communication skills. While researching, she learns about
different forms of communication, including non-verbal methods like gestures and facial expressions.
Non-verbal communication includes
(a) Written messages (b) Facial expressions
(c) Email communication (d) Phone calls
Install NODIA App to See the Solutions.
Click Here To Install
Page 2 Sample Paper 07 NODIA
(iv) Which term means walking in the local park or a similar activity?
(a) Nature walk (b) Motivation
(c) Regulation (d) None of these
(v) A/An _____ creates new needs and new means to satisfy them.
(a) leadership (b) innovation
(c) entrepreneur (d) None of these
(vi) Rohan is learning about computer interfaces in his IT class. His teacher explains different elements of
the screen, including small graphical representations used to open files or applications. It is a picture or
graphic representation of an application or a file.
(a) Icon (b) Taskbar
(c) Status bar (d) Desktop
2. Answer any 5 out of the given 6 questions
(i) Computer based record keeping system is known as
(a) Data Manipulation System (b) Computerised Data System
(c) Computerised Record Keeping System (d) DBMS
(ii) Facilities offered by databases are
(a) the ability to store a large amount of data in a structured format, easy update, sort query, production
of reports.
(b) easy edition, spell check, perform calculations, library of mathematical functions, replication.
(c) the ability to rotate images, copy and paste, fill scale.
(d) None of the above
(iii) Which of the following is a spreadsheet software?
(a) Lotus 1-2-3 (b) VisiCalc
(c) Both ‘a’ and ‘b’ (d) None of these
(iv) _____ is a form of electronic commerce where customers can buy or sell goods over the Internet.
(a) Online shopping (b) E-Reservation
(c) Email (d) E-banking
(v) Kavya is studying the architecture of databases in her IT class. She learns that the main role of database
servers is to store, manage, and process data efficiently within a system. Database servers are referred
to as
(a) front-ends (b) back-ends
(c) clients (d) model
(vi) A template is a model that you use to create _____.
(a) images (b) other documents
(c) design (d) DBMS
Continue on next page.....
Install NODIA App to See the Solutions.
Click Here To Install
CBSC 10th Information Technology Sample Paper 07 Page 3
3. Answer any 5 out of the given 6 questions
(i) It refers to a cell or a range of cells on a worksheet and can be used to find a formula.
(a) Row (b) Column
(c) Autosum (d) Cell reference
(ii) _____ is a Malware which is designed to spy on the victim’s computer.
(a) Virus (b) Spyware
(c) Worms (d) Trojan horse
(iii) Which of the following is a set of formats consisting of such things as fonts, colors etc?
(a) Style (b) Margin
(c) Indent (d) Leading
(iv) Which of the following is not a data type?
(a) Picture/Graphic (b) Date/Time
(c) Text (d) Number
(v) Which function cannot be performed through Subtotal in a Spreadsheet?
(a) Sum (b) Product
(c) Average (d) Percentage
(vi) Pictures can be added to Word documents and they cannot be formatted in various ways.
(a) True (b) False
4. Answer any 5 out of the given 6 questions
(i) In a document, _____ is used to apply a style to many different areas quickly without having to go
back to the Styles and Formatting window and double click every time.
(a) Fill format mode (b) Formatting window
(c) Painter mode (d) Text wrapping
(ii) A computer _____ controls access between networks.
(a) Firewall (b) Virus
(c) Spyware (d) Antivirus
(iii) When you define a field for a table, _____ are the names given to column in a table.
(a) Field Name (b) Field Size
(c) Data Type (d) Description
(iv) The _____ feature creates a summarized outline of data in a worksheet.
(a) Subtotal (b) Solver
(c) Goal Seek (d) Scenario
Install NODIA App to See the Solutions.
Click Here To Install
Page 4 Sample Paper 07 NODIA
(v) Raj has created a worksheet where he has added all the information of his employees. He wants every
employee to go through the worksheet and update their address and phone number, if required. He also
would like to know the changes done by his employees. Which feature of spreadsheet he should enable
to see the changes made by his employees?
(a) Macro (b) Link workbook
(c) Change worksheet (d) Track changes
(vi) _____ program(s) also offer real-time protection monitoring your computer for any changes by
malware software.
(a) Antivirus (b) Antispyware
(c) Both (a) and (b) (d) None of these
5. Answer any 5 out of the given 6 questions
(i) In a document, _____ refers to the vertical or horizontal placement of a graphic in relation to the
chosen anchor point.
(a) arrangement (b) alignment
(c) identation (d) margin
(ii) The action of sharing your opinions contents on a blog is termed as _____.
(a) Blogger (b) Blogging
(c) Tweeting (d) Commenting
(iii) Tanu explained his class that to apply an existing style, except for _____, position the insertion point
in the paragraph, frame or page and then double-click on the name of the style in one of these lists.
(a) Window style (b) Character style
(c) Paragraph style (d) Cell style
(iv) To copy a formula from one cell to another
(a) Drag the autofill handle (b) Cut the cell
(c) Both (a) and (b) (d) None of the above
(v) A _____ is a location or a place of employment, where someone works to earn his living.
(a) Workplace (b) Home
(c) Society (d) Industry
(vi) Which of the following commands is not a Data manipulation language?
(a) Select (b) Insert
(c) Update (d) Alter
Continue on next page.....
Install NODIA App to See the Solutions.
Click Here To Install
CBSC 10th Information Technology Sample Paper 07 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. Ravi is passionate about protecting the environment and is exploring ways to contribute to sustainable
development. He wants to understand how acquiring green skills can benefit individuals and society. What
are the benefits of acquiring green skills?
7. How can empathy enhance communication skills?
8. What are the responsibilities of an operating system with respect to file management?
9. Priya is preparing for a workshop on personal development. She wants to identify six key skills required for
independent working. What are the skills necessary for independent working? List any six.
10. What are the disadvantages of entrepreneurship?
Direction for Q 11-Q 16 : Answer any 4 out of the given 6 questions in 20-30 words each.
11. What is the role of key fields in a database? Name the keys in a DBMS.
12. What is a macro?
13. How does a router help in maintaining a network ?
14. Rohan is creating a large number of invitation letters for an event. He wants to personalize each letter with
unique names and addresses efficiently. How can Mail Merge help Rohan in managing his task effectively?
15. How can you prepare for emergencies?
16. Define the following terms:
(i) Active Cell
(ii) Sheet Tab
Direction for Q 17-Q 21 : Answer any 3 out of the given 5 questions in 50-80 words each.
17. Meera is designing a project in a word processor where she wants to make her document visually appealing
by fitting text inside various shapes. She is exploring the steps and options for this feature. Write the steps
for text fitting inside a shape in a word processor document. Also, describe its options.
Continue
on next page.....
Install NODIA App to See the Solutions.
Click Here To Install
Page 6 Sample Paper 07 NODIA
18. Ishita is a teacher. She had entered the marks of all the students and also calculated the total of the
students. Now, she wants to sort the data so that she can find the names of the students according to their
marks in descending order. Tell her the different steps to sort the data.
19. What do you mean by data control language? Also, give its types.
20. Rahul is working on an SQL project where he needs to analyze the EmployeeSalary table. He is tasked with
identifying the number of fields and records, and writing specific SQL queries based on the data.
Table : EmployeeSalary
Last Name First Name Dept Payroll Number Salary (`) Job Title
Shen James Finance A621 19500 Payroll Clerk
Gupta Shruthi Finance M502 35000 Accountant
Bedi Reeta Human Resource M421 18500 Secretary
Walker Tia Sales W815 24000 Sales Represen-tative
Shafia Ahmed Factory H219 39000 Factory Manager
Mittal Chavi Purchasing M134 20000 Purchasing Clerk
(i) How many fields and records are there in the table EmployeeSalary?
(ii) Write the SQL queries for the following:
(a) List all data of table EmployeeSalary.
(b) Display all the records whose salary is less than 25000.
(c) Display the FirstName and JobTitle of employees having Dept ‘Finance’.
21. Aman frequently uses the Mozilla Firefox browser and wants to maintain his privacy by regularly clearing
his web history. He is looking for the steps to perform this action. How to clear web history on the Mozilla
Firefox browser?
******
Install NODIA App to See the Solutions.
Click Here To Install
