Students can access the CBSE Sample Papers for Class 10 IT with Solutions and marking scheme Set 1 will help students in understanding the difficulty level of the exam.
CBSE Sample Papers for Class 10 IT Set 1 With Solutions
Time Allowed: 2 Hours
Maximum Marks: 50
General Instructions:
- Please read the instructions carefully.
- This Question Paper consists of 21 questions in two sections: Section A & Section B.
- Section A has Objective type questions whereas Section B contains Subjective type questions.
- 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.
- All questions of a particular section must be attempted in the correct order.
- Section A – Objective Type Questions (24 Marks):
- This section has 05 questions.
- Maries allotted are mentioned against each question/part.
- There is no negative marking.
- Do as per the instructions given.
- Section B – Subjective Type Questions (26 Marks):
- This section has 16 questions.
- A candidate has to do 10 questions.
- Do as per the instructions given.
- Marks allotted are mentioned against each question/part.
Section – A (24 marks)
Question 1.
Answer any 4 out of the given 6 questions on Employability Skills.
(A) When it is difficult to communicate with someone who is not willing to talk or express their feelings and views it means there is a/an__________ [1]
(a) Culture Barrier
(b) Interpersonal Barrier
(c) Physical Barrier
(d) Language Barrier
Answer:
(b) interpersonal Barrier
Explanation:
Interpersonal communication barriers are obstacles that hinder effective exchange of information and understanding between individuals. These can include language differences, cultural misunderstandings, emotional barriers, or physical distractions, all of which impede the smooth flow of communication in 1 interpersonal interactions.
(B) Kartik’s Computer was running very slow, hangs and often restarts. He is very confused and tensed as he was working on a very important assignment. Kartik’s friend gave him the following suggestions. Identify who has given him a genuine suggestion. [1]
(a) Radha: Restart your machine.
(b) Ishan: Install reliable antivirus software and update.
(c) Amar: Don’t use Pendrive.
(d) Sam: Install free antivirus from net.
Answer:
(b) Ishan: Install reliable antivirus software and update.
Explanation:
An antivirus software is a program designed to detect, prevent, and remove malicious software (malware) from a computer or network. It serves as a crucial tool in maintaining the security of digital systems by identifying and neutralising threats such as viruses, spyware, ransomware, and other types of malicious code.
(C)_________ refers to focusing human efforts for maintaining a healthy body and mind capable of better withstanding stressful situations. [1]
(a) Self-Motivation
(b) Stress Management
(c) Self-Awareness
(d) Self-Regulation
Answer:
(b) Stress Management.
Explanation:
Stress management refers to the set of techniques, strategies, and practices individuals employ to cope with and alleviate the negative effects of stress.
This may include making healthier lifestyle choices, engaging in relaxation methods, and practicing time management.
(D) High expectations from self can leave with chronic anxiety and stress, thus leading to_________stress. [1]
(a) Physical
(b) Emotional
(c) Mental
(d) Financial
Answer:
(c) Mental
Explanation:
Mental stress, also known simply as stress, refers to a state of mental or emotional strain resulting from challenging or adverse situations. It is the body’s natural response to perceived threats, often referred to as stressors. These stressors can be external, such as work pressures, relationship difficulties, financial problems, or environmental factors, as well as internal, like unrealistic expectations, negative self-talk, or personal insecurities.
(E) Which of the following is/are a myth about Entrepreneurship? [1]
(a) Need a lot of Money
(b) Must have a great Idea
(c) Should know everything about business
(d) All of these
Answer:
(d) All of these
Explanation:
It is a myth that entrepre-neurship requires a lot of money to get started. Some businesses may require a Large sum of money, but there are others that can be started with a small amount e.g., online businesses that needs very little money.
Another myth is that an entrepreneur must have a groundbreaking idea. Not every successful business is built on a great idea. Many successful entrepreneurs have found success by addressing existing needs, improving existing products or services, or applying a unique approach to a common problem.
The misconception that an entrepreneur must know everything about business is also not true. The primary thing that an entrepreneur needs to know is, the knowledge and experience required for the business. The business tactics can be Learnt from their experiences over the time.
(F) Name the organization that has the Sustainable Development Goals? [1]
(a) UNICEF
(b) League of Nations
(c) United Nations
(d) World Health Organization
Answer:
(c) United Nations
Explanation:
The Sustainable Development Goals (SDGs) were established by the United Nations (UN) as a universal call to action to end poverty, protect the planet, and ensure prosperity for all by 2030.
Question 2.
Answer any 5 out of the given 6 questions.
(A) Which one is not the tab of the insert/index Table window of Writer Document? [1]
(a) Entries
(b) Background
(c) Style
(d) Row
Answer:
(d) Row
Explanation:
The Insert/Index Table window includes the following five tabs:
- Index/Table: This tab to set the table’s attributes.
- Entries: This tab allows you to customize the heading structure and design.
- Styles: You can modify the formatting and header styles using this tab.
- Columns: If your table of contents or index spans multiple columns, you may find settings related to the layout and formatting through this tab.
- Background tab: It is used to add colour or a graphic to the table background.
(B) In the custom styles, each________ field on the Structure line represents a blank space in a document. [1]
(a) Black
(b) White
(c) Blue
(d) Yellow
Answer:
(a) Black
Explanation:
Each white field on the Structure line represents a blank space where you can add custom text.
(C) Saurabh has made an advertisement in Digital Document. He is facing difficulty in positioning the images within the text. Suggest him how he can adjust the image? [1]
(a) Wrap text
(b) Crop
(c) Alignment
(d) Layout
Answer:
(a) Wrap text
Explanation:
In Open Office Writer, wrap text refers to the ability to control how text flows around an object, such as an image, shape, or another embedded element. Wrapping text allows you to determine the positioning of the text in relation to the object such as image and creates a more visually appealing layout.
(D) A________is a collection of records that store data in Mail merge. [1]
(a) Data Source
(b) Main Document
(c) Document
(d) Merge Field
Answer:
(a) Data source
Explanation:
A data source is a file or database that contains the information you want to include into your merged documents. It serves as the primary storage of data that is used to personalize and customize multiple documents during the mail merge process. It includes fields or columns representing different pieces of information.
(E) To increases the contrast of an image, ________option is used in a document. [1]
(a) Smooth
(b) Sharpen
(c) Aging
(d) mosaic
Answer:
(b) Sharpen
Explanation:
Sharpen refers to the enhancement of the clarity and definition of an image or graphic within a document. It corrects softness or blurriness introduced during the image capture process or to enhance the overall visual impact of the image.
(F) ______ provide Internet access by transmitting digital data over wires of a local telephone network. [1]
(a) ISP
(b) DSL
(c) Dial-up connection
(d) Modem
Answer:
(b) DSL
Explanation:
DSL is a network technology that user existing telephone lines to transit high bandwidth data. The subscribers have to use modern to connect their computer to this type of network.
Question 3.
Answer any 5 out of the given 6 questions
(A)_______is specifically designed to minimize the results according to a set rules that we define in a spreadsheet. [1]
(a) Goal Seek
(b) Scenario
(c) Solver
(d) Subtotal
Answer:
(c) Solver
Explanation:
In CaLc, the Solver is an optimization tool that allows users to find the optimal solution to a complex problem by adjusting the values of specific cells based on given rules. It is particularly useful for problems involving maximizing or minimizing a target value depending on certain restrictions or conditions.
(B) Sahil and his partners have created a list of their company employees in one of the spreadsheets in the office. Now the rest of the task they want to complete from home. Which option they should use to access the same Spreadsheet from home? [1]
(a) Consolidate Worksheet
(b) Link Worksheet
(c) Merge Worksheet
(d) Lock Worksheet
Answer:
(b) Link Worksheet
Explanation:
They can create a Link of that worksheet This will help them in opening the same worksheet from home by clicking on that link.
(C)______ can help to clarify the relation between cells while using “Multiple Operations”. [1]
(a) Detective
(b) Solver
(c) Navigation
(d) Hyperlink
Answer:
(a) Detective
Explanation:
The “Detective” option refers to a set of tools and features designed to help users analyze and trace relationships between cells, formulas, and precedents in a spreadsheet. These tools are useful for understanding the dependencies and relationships within a complex spreadsheet, especially when dealing with large datasets or intricate formulas.
(D) Identify the part of a Spreadsheet using which a user can manage multiple sheets. [1]
(a) Status Bar
(b) Sheet Tab
(c) Formula Bar
(d) Worksheet Area
Answer:
(b) Sheet Tab
Explanation:
In Calc, the sheet tab refers to the tabs at the bottom of the Calc window that represent individual sheets within a spreadsheet document. Each sheet tab typically has a default name (like Sheetl, Sheet2, etc.) but can be renamed to reflect the content or purpose of the sheet.
(E) Spreadsheet software can find the changes by sheets. [1]
(a) Changing
(b) Comparing
(c) Renaming
(d) Editing
Answer:
(b) Comparing
Explanation:
Comparing sheets in Calc involves analyzing the differences between two or more sheets within the same spreadsheet document This can be useful when working with multiple versions of a sheet or when trying to identify changes made to a sheet over time.
(F) At the bottom of each worksheet, left tab indicates the of the worksheet in a workbook. [1]
(a) Size
(b) 3 Type
(c) Name
(d) Color
Answer:
(c) Name
Explanation:
The leftmost tab at the bottom of each worksheet is typically called the “Sheet Tab” or simply the “Sheet Name Tab.” This tab displays the name of the current worksheet and provides a way to navigate between different sheets in the same spreadsheet document.
Question 4.
Answer any 5 out of the given 6 questions.
(A) It enables users to view, enter, and change data directly in database objects. [1]
(a) Report
(b) Query
(c) Form
(d) Database
Answer:
(c) Form
Explanation:
Forms refer to a feature that allows users to create user-friendly interfaces for entering, viewing, and manipulating data stored in a database. Forms provide a way to present data in a structured and visually appealing manner, making it easier for users to interact with the database without directly working with tables or queries.
(B) There are_______ types of Relationships in a table of a database. [1]
(a) One
(b) 3
(c) 4
(d) Many
Answer:
(b) 3
Explanation:
The three types of relationships that can be formed in tables of a database are as follows:
- One-to-One: In this type of relationship, each record in first table can have only one matching record in second table and in second table each record can have only one matching record in first table.
- One-to-Many: In this type of relationship, a record in first table can have many matching records in second table, however a record in second table can have only one matching record in first table.
- Many-to-Many: In this type of relationship, each record in first table have many matching records in second table and a record in second table can have many matching records in first table.
(C) A Relational database uses _______ commands which is a standard user application that provides an easy programming interface for database interaction. [1]
(a) Access
(b) Python
(c) SQL
(d) Protocol
Answer:
(c) SQL
Explanation:
SQL stands for Structured Query Language. It is a language used for managing and manipulating relational databases. It serves as a standard interface for interacting with relational database management systems (RDBMS), allowing users to perform various operations such as querying, updating, inserting, and deleting data in a database.
(D) Suraj wants to create a database for his clients. For this purpose, she needs to store the Email IDs of his clients. Which datatype should he use to accomplish this purpose? [1]
(a) Numeric
(b) Vorchar
(c) Binary
(d) Boolean
Answer:
(b) Vorchar
Explanation: Varchar is a data type used to store variable-length character strings.lt is an indeterminate length string data type and can hold numbers, letters and special characters.
(E) Geet has written a SQL query in SQL view. But he doesn’t know how to execute the query using keyboard keys. Suggest him the shortcut key to complete the task. [1]
(a) Enter
(b) Ctrl + E
(c) Space bar
(d) F5
Answer:
(d) FS
Explanation:
F5 is used to execute the current query and Ctrl + E is used to switch between SQL View and Design View.
(F) A table can have only_________ primary key in a database. [1]
(a) 1
(b) 2
(c) 3
(d) Many
Answer:
(a) 1
Explanation:
The primary key is a unique identifier for each record in the table and is used to ensure the uniqueness of each row.
Question 5.
Answer any 5 out of the given 6 questions.
(A) _______ key is an accessibility feature that assists people having difficulty in using keyboard and mouse. [1]
(a) Guide
(b) Sticky
(c) Serial
(d) Home
Answer:
(c) Serial
Explanation:
Serial key is an accessibility features that assists people that have difficulty using a keyboard or a mouse. It enables the user to provide input using an alternate input device attached to the computer’s serial port. This feature is designed for users who are unable to use the computer’s standard keyboard and mouse.
(B) Anaisha is a wildlife photographer. She wants to create her website where she can update the pictures and discuss about different events, reviews, announcements, news etc. Suggest her a suitable option to complete the task. [1]
(a) Blog
(b) E-Mail
(c) Instant Messaging
(d) Mail Merge
Answer:
(a) Blog
Explanation:
A blog is a type of website or online platform where an individual, group, or organization regularly publishes content on various topics. They often serve as a personal diary, a platform for expressing opinions, or a means of sharing information with a wider audience.
(C) Which of the following is not a web browser? [1]
(a) Safari
(b) Internet Explorer
(c) Google
(d) Fi refox
Answer:
(c) Google
Explanation:
Google is a popular internet search engine. It scans the Web to find Web pages that are relevant to the words you have typed in the search box. It is known for its speed, relevance, and accuracy in providing search results.
(D) Which out of the following is the best example of a strong password? [1]
(a) 9412356789
(b) 14Hd{]$_SblO
(c) HarryPotterSeries
(d) 140ct2004
Answer:
(b) 14Hd{]$_SblO
Explanation:
A strong password is a password that is designed to be difficult for others to guess or crack. This type of password should be lengthy at least 10 to 12 characters long and include a mix of
uppercase and lowercase letters, numbers, and special characters (e.g., !, @, #, $, %). This complexity makes the password more resistant to brute force attacks.
(E) Bharat has set up his company with 20 computers in a building. He wants to connect all the computers together. Which type of Network will be the best suitable for this purpose? [1]
(a) LAN
(b) WAN
(c) PAN
(d) MAN
Answer:
(a) LAN
Explanation: LAN stands for Local Area Network. It refers to a network of interconnected computers, devices, and resources within a limited geographical area, such as a home, office, or campus.
(F) IP stands for __________ [1]
(a) International Protocol
(b) Internet Protocol
(c) Intranet Protocol
(d) Interpersonal Protocol
Answer:
(b) Internet Protcol
Explanation:
Internet Protocol (IP) refers to a set of rules that govern how data packets should be sent, received, and routed across networks. The Internet Protocol is a fundamental protocol of the Internet and serves as the basis for communication in computer networks.
Section – B (26 Marks)
Answer any 3 out of the given 5 questions on Employability Skills
Answer each question in 20 – 30 words.
Question 6.
What are the learning objectives of communication? [2]
Answer:
Learning objectives of Effective communication are:
- Sending, receiving and understanding the message or information.
- Development of interpersonal Skills.
- To express effectively with maximum efficiency.
Question 7.
Why do we say that an entrepreneur should be open-minded? [2]
Answer:
The smartest and most successful people welcome new ideas and diverse perspectives, allowing them to see more opportunities ahead of them and better solutions to problems. Open- minded entrepreneurs are able to strategize better because they can listen to varying and look at a problem through multiple lenses.
Question 8.
How is self-regulation connected to the ability to work independently? [2]
Answer:
The ability to work independently can be enhanced by being self-regulated. Self-regulation guides independent individuals as it help them to consider long term consequences rather than just transient feelings. It leads to a responsible and a value driven behavior, it teaches self-control and wetl-directed efforts to reach the goaL Self-regulated includes discipline that helps in consistent efforts to move towards the goal.
Question 9.
How we can prevent computer against attack by viruses. [2]
Answer:
We can prevent the computer against attack of viruses by installing proper antivirus, enabling the firewall, scan external devices before using on other computer, by avoiding emails that are suspicious or not known to us, should be very carefijl while downloading files or any programs from the internet etc
Question 10.
“Green economy promotes sustainable development”. Justify the statement. [2]
Answer:
The focus of green growth strategies is ensuring that natural assets can deliver their foil economic potential on a sustainable basis. That potential includes the provision of critical life support services – clean air and water, and the resilient biodiversity needed to support food production and human health.
Answer any 4 out of the given 6 questions in 20 – 30 words each.
Question 11.
What do you understand by Anchoring in Word Processor? [2]
Answer:
Anchoring refers to the reference point for the graphics. This point could be the page, or frame where the object is. paragraph, or even a character. An image always Has an anchor point.
Question 12.
What do you mean by Sorting in a Spreadsheet? [2]
Answer:
Sorting is the process of arranging data into meaningful order so that you can analyze it more effectively. For example, you might want . to arrange sales data by calendar month so that you can produce a graph of sales performance.
Question 13.
State any four etiquettes to be followed while chatting on the internet. [2]
Answer:
The etiquettes to be followed while chatting on the internet are:
- Message should be short and to the point.
- Always introduce yourself by name if your screen name doesn’t reflect it
- Always ask if the other person has time to chat first, regardless of how important you think what you have to say is, it’s not going to be well received if the recipient is busy.
Question 14.
How is Goal Seek different from Solver in a Spreadsheet? [2]
Answer:
Goal seek determines what values needs to be input in a cell to achieve the described result in a formula cell as it allows varying the value for one cell whereas Solver can solve equations that uses several variables, so it can be used to determine what values need to be entered in multiple-input cells to achieve the described result
Question 15.
Differentiate between a Primary key and Foreign key. [2]
Answer:
A primary key is a unique value that identifies a row in a table, whereas a foreign key identifies a column or set of columns in one (referencing) table that refers to a column or set of column in another referenced table. A table can have only Primary Key but a table can have multiple foreign keys.
Question 16.
What is the importance of a healthy lifestyle? Give any four points related to it. [2]
Answer:
A healthy lifestyle helps to keep and improve people’s health and well-being. A healthy lifestyle includes:
- Healthy eating habits.
- Physical activities.
- Stress management.
- Sound sleep.
Answer any 3 out of the given 5 questions in 50- 80 words each. (4 × 3 = 12)
Question 17.
What do you understand by the term Table of Contents? List the characteristics of a good ‘Table of content’ in a word processor. [4]
Answer:
The table of contents is a snapshot of the headings and page numbers in your document and does not automatically updates itself as you make changes. It acts as a map for the users.
A good table of content has the following characteristics:
- It should be easy to read and ample to use.
- It should be organised and formatted properly.
- It must be accurate and easily accessible.
- It should be given after the title and copyright page.
Question 18.
Explain the term ‘Scenarios’ in relation to the Spreadsheets with example. [4]
Answer:
Scenarios are a tool to test “What-if” questions. Each scenario is named and can be edited and formatted separately. When you print the spreadsheet, only the content of the currently active scenario is printed. A scenario is essentially a saved set of cell values for your calculations. You can easily switch between these sets using the navigator or a drop-down list which can be shown beside the changing cells. For example, if you wanted to’ calculate the effect of different interest rates on investment, you could add a scenario for each interest rate and quickly view the results. Formulas that rely on the values changed by your scenario are updated when the scenario is opened. If all your sources of income used scenarios, you could efficiently build a complex model of your possible income.
Question 19.
Explain different kinds of online threats. [4]
Answer:
There are different kinds of online threads:
- Phishing: Phishing attacks use fake communication, such as an email, to trick the receiver into opening it and carrying out the instructions inside, such as providing a credit card number.
- Malware: Malware is malicious software such as spyware, ransomware, viruses, and worms. Malware is activated when a user clicks on a malicious link or attachment, which leads to installing harmful software.
- Password Attacks: With the right password, a cyber attacker has access to a wealth of information. Social engineering is a type of password attack that data insider defines as “a strategy cyber attackers use that relies heavily on human interaction and often involves tricking people into breaking standard security practices.”
- Email spoofing: It is the forgery of an email header so that the message appears to have originated from someone or somewhere other than the actual source.
Question 20.
Explain the term “Referential Integrity”. Why is it important in a database? [4]
Answer:
Referential Integrity is used to maintain the accuracy and consistency of data in a relationship. In Base, data can be linked between two or more tables with the help of primary key and foreign key constraints.
Referential Integrity is important in DBMS as:
- It prevents the entry of duplicate data.
- It prevents one table from pointing to a nonexistent field in another table.
- It prevents consistency between “Partnered” tables.
- It prevents the deletion of a record that contains a value referred to by a foreign key in another table.
- It prevents the addition of a record to a table that contains a foreign key unless key unless there is primary key in the linked table.
Question 21.
Consider the following Vendor table and write the queries for the following: [4]
Sub_
code |
Sub_
Name |
Date of Exam | Days |
E001 | English | 11-03-2023 | Monday |
H002 | Hindi | 15-03-2023 | Friday |
S003 | Social | 18-03-2023 | Monday |
S004 | Science | 21-03-2023 | Thursday |
(A) Write a SQL command to display the records in ascending order by date of exam.
(B) Write a query to display the above date sheet.
(Q Write a query to display the subject name and date of the exam held on ‘Monday’
(D) Write a SQL command to display the date of exam and Sub. Name of Science subject.
Answers:
(A) Select*from Datesheet order by Date of Exam
(B) Select*from Datesheet
(C) Select Sub_Name, Date of Exam from Datasheet where Days= ‘Monday’
(D) Select Sub_Name, Date of Exam from Datasheet where Sub_Name = ‘Science’