Students can access the CBSE Sample Papers for Class 10 IT with Solutions and marking scheme Set 2 will help students in understanding the difficulty level of the exam.
CBSE Sample Papers for Class 10 IT Set 2 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
- Marks 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) …………………refers to focussing human efforts for maintaining a healthy body and mind, capable of withstanding stressful situations. [1]
(a) Artificial Intelligence
(b) Stress management
(c) Motivation
(d) Emotional intelligence
Answer:
(b) Stress management
Explanation:
Stress management refers to the techniques and strategies designed to help individuals to handle and reduce the negative effects of stress on their physical, emotional, and mental well-being. It involves identifying stress creating factors, implementing effective methods to handle them, and adapting with circumstances responsible for stress resulting in relaxation to maintain a healthy balance in one’s life.
(B) Which of the following is not the benefit of stress management? [1]
(a) Boosts immunity
(b) Reduces efficiency
(c) Improves mood
(d) Prevents behavioural problems
Answer:
(b) reduces efficiency
Explanation:
Stress management removes the negative impact of stress on physical and mental well-being which results in increased efficiency.
(C) …………………are computer programs that can damage the data and software programs or steal the information stored on a computer. [1]
(a) Spam
(b) Viruses
(c) Junk mail
(d) BIOS
Answer:
(b) Viruses
Explanation:
Virus stands for Vital Information Resources under Siege. It refers to the type of malicious software or malware that can cause damage to your data, files, and software through replication.
Spam refers to the unwanted or unsolicited mail that are sent in bulk by the companies usually for promotional purposes. Junk mail refers to unsolicited mail that companies, charities, political parties, and other entities send. The official differentiation between the two is that spam is unsolicited mail, whereas junk is solicited mail.
(D) …………………is a horizontal bar present at bottom of the Windows 7 desktop. [1]
(a) Status Bar
(b) Menu Bar
(c) Task Bar
(d) Recycle bin
Answer:
(c) Taskbar
Explanation:
The Windows Taskbar lets you access frequently used and currently open apps. Typically, the taskbar appears as a single row at the bottom of your desktop; however, you can change its position.
Windows Taskbar consists of Start button, Taskbar icon i.e., programs that are pinned on Taskbar, system tray which consists of icon for notification, and clock.
(E) State whether the following statement is a myth or reality: [1]
Entrepreneurs are born a certain way.
Answer:
Myth
Explanation:
Entrepreneurial skills is not a born talent. It can be Learned, polished and developed by anyone who wants to be an entrepreneur.
(F) Which one of the following is not true for entrepreneurs? [1]
(a) They create needs and demands.
(b) They provide raw materials.
(c) They do not create jobs.
(d) They help society by supporting infrastructure development.
Answer:
(c) they do not create jobs
Explanation:
As their business grows, entrepreneurs look for more people to help them. They buy raw material, they need people for manufacturing, promoting and selling their products. They hire both skilled and unskilled people, hence creates jobs.
Question 2.
Answer any 5 out ofthe given 6 questions.
(A) …………………controls all aspects of a paragraph’s appearance, such as text alignment, tab stops, line spacing, and borders, and can include character formatting. [1]
(a) Page Style
(b) Character Style
(c) Cell Style
(d) Paragraph Style
Answer:
(d) paragraph style
Explanation:
Paragraph styles control all aspects of a paragraph’s appearance, such as text alignment, tab stops, Line spacing, borders and can include character formatting.
- Cell style defines the appearance of a cell or a group of cells, including aspects like fonts, colors, borders, alignment, and number formats in a worksheet.
- Character styles are a feature commonly found in word processing. It allow you to apply a similar type of formatting attributes to individual characters or a specific range of text within a document. Page styles include margins, headers and footers, borders and backgrounds.
(B) How many levels of headings does Open Office Writer evaluate to build the Table of contents? [1]
(a) 8
(c) 10
(b) 9
(d) 12
Answer:
(c) 10
A table of contents (TOC) is an organized list of the document’s headings or sections along with their corresponding page numbers.
(C) Reema has created a pamphlet on ‘Tour to West India’. She has inserted many images to make it more presentable but the size of images is occupying a lot of space. Her friend has suggested her to reduce the size of images. Which of the following options will help her in doing the task without losing any content of the image? [1]
(a) Recolor
(c) Resize
(b) Docking
(d) Rotate
Answer:
(c) resize
Explanation:
Resizing refers to the action of changing the dimensions or size of various elements within a document, such as text, images, or objects.
In OpenOffice Writer, docking refers to the ability to attach or “dock” various toolbars, panels, or windows to different sides of the application’s main window. This feature allows you to customize the layout of your workspace according to your choices. You can dock items like the toolbar, formatting toolbar, styles and formatting panel, navigator, and more to the top, bottom, left, or right sides of the application window.
(D) Which of the following Graphic filter is used to increase the contrast of an image in a document? [1]
(a) Smooth
(b) Sharpen
(c) Remove Noise
(d) Invert
Answer:
(b) sharpen
Smooth: It reduces the contrast between neighboring pixels and produces a slight lack of sharpness.
Remove Noise: Removing noise from images is a process of reducing or eliminating unwanted and random variations in pixel values that can distort or degrade the quality of an image.
Invert: The colors of an image will be inverted or reversed so that it appears as a color negative of the image.
(E) Which of the following is not used when creating a mail-merge document ? [1]
(a) Spreadsheet
(b) Document
(c) Paint
(d) Database
Answer:
(c) paint
Explanation:
Paint is an application software that allows users to draw and colour images. It is not used in mail merge process.
(F) Which mode is used to apply a style to many different areas of a document quickly without going back to styles and formatting window in Writer? [1]
Answer:
Fill Format mode
Explanation:
The Fill Format mode is activated from the sixth icon at the top of the Styles and Formatting window. This method is useful for formatting different paragraphs, words, or other items with the same style, and it may be easier to use than making multiple selections first and then applying a style to all of them.
Question 3.
Answer any 5 out of the given 6 questions.
(A) A colored border, with …………………, appears around a cell where changes are made in a shared worksheet. [1]
(a) a dot in the upper left-hand comer
(b) a dot in the lower left-hand corner
(c) a cross in the upper left-hand corner
(d) a cross in the upper right-hand corner
Answer:
(a) a dot in the upper left-hand comer
Explanation:
A shared Excel worksheet allows multiple users to access and edit the same worksheet simultaneously. There are chances of accidently overwriting each other’s changes. To prevent this, Excel displays a colored border around the cell or range of cells where changes are made by another user.
(B) ………………… feature adds data arranged in a group of cells in Calc, with labels for columns and/or rows. [1]
(a) Average
(b) Subtotal
(c) Goal seek
(d) Solver
Answer:
(b) Subtotal
Explanation:
The Subtotal command in Calc automatically creates groups and is used to summarise data by applying common functions like SUM, AVERAGE, COUNT, etc.
(C) A ………………… refers to a cell or a range of cells on a worksheet whose data values can be used in a formula. [1]
(a) sheet
(b) cell
(c) cell reference
(d) cell data
Answer:
(c) Cell reference
Explanation:
A cell reference refers to a cell or a range of cells on a worksheet. It is used to specify which cell’s data or contents are being used in a formula, displayed in a cell, or referenced in some way,
(D) …………………….feature of Calc is used to test ‘what-if’ questions. [1]
(a) Solver
(b) Goal seek
(c) Scenario
(d) Styles
Answer:
(c) Scenario
Explanation:
A scenario manager in a worksheet is a collection of digital tools that allow a user to create, analyze and compare data results in different business situations. It is a way to store and manage multiple sets of input values or assumptions for a what if analysis.
Goal seek in worksheet, refers to the process to find out the input value based on an already known output value.
(E) Macros are especially useful to ………………… the same way over and over again. [1]
(a) repeat a task
(b) reject a task
(c) report a task
(d) comment a task
Answer:
(a) repeat a task
Explanation:
In a spreadsheet, macros are sets of pre-recorded instructions or commands that can be created and run to perform specific tasks or actions within the spreadsheet. Macros are used to automate repetitive tasks.
(F) ……………………. feature of Calc helps to track what data was changed, when the change was made, who made the change and in which cell the change has occurred. [1]
(a) Record Changes
(b) Edit record
(c) Change record
(d) Macro
Answer:
(a) Record changes
Explanation:
If you work with a spreadsheet that needs to be updated or reviewed by other people, the option to record changes is very useful. It keeps record of all the changes made by different reviewers. You can also use it when you’re updating a file and need to keep a track of all the changes you do yourself.
Question 4.
Answer any 5 out of the given 6 questions.
(A) Which one of the following is not an example of DBMS? [1]
(a) PostgreSQL
(b) SQLite
(c) FoxPro
(d) Impress
Answer:
(d) Impress
Explanation:
Impress from OpenOffice is used to make multimedia presentations.
(B) A …………………. is an interface in a user specified layout that lets users to view, enter, and change data directly in database objects such as tables. [1]
(a) frame
(b) form
(c) relation
(d) report
Answer:
(b)Form
Explanation:
In database, a form refers to a user interface component used to input, view, edit, or manipulate data within a database system. Forms are designed to provide a user-friendly way to interact with the database, enter new data, modify existing records, or retrieve information.
(C) Which of the following is expanded form of SQL? [1]
(a) Systematic Query Language
(b) Structured Query Language
(c) Software Query Language
(d) Structural Query Language
Answer:
(b) Structured Query Language
Explanation:
SQL is a standard language for database creation and manipulation. It is used to interact with RDBMS
SQL is a standardized computer language that was originally developed by IBM for querying, altering and defining relational databases, using declarative statements
(D) …………………. is usually suitable for less amount of data. (Relational/Flat file) [1]
Answer:
Flat file
Explanation:
A flat file is a type of data storage format that stores data in a plain, tabular, or text-based structure. It typically consists of a single table or data structure where all data is stored in a single file.
A relational database is a more complex and structured way to store data. It consists of multiple tables that are related to each other through primary or foreign keys.
(E) Binary data types in a database can be using for storing …………………. [1]
(a) photos, music files, etc.
(b) integer values
(c) only image files
(d) only video files
Answer:
(a) photos, music files, etc.
Explanation:
The Binary data type in SQL is used to store non-textual data such as images, audios and videos. It can be used in two variations: BINARY(n), which specifies a fixed-length binary string of n bytes, and VARBINAY(n), which specifies a variable length binary string with a maximum length of n bytes.
Some other commonly used data types in SQL are INT, FLOAT, CHAR, VARCHAR TEXT, DATE and BOOLEAN.
(F) …………………. clause can be used with the SELECT statement in SQL to specify which rows to retrieve from the table. [1]
(a) WHERE
(b) GROUP
(c) SAME
(d) SIMILAR
Answer:
(a) WHERE
Explanation:
The SQL SELECT statement is used to retrieve data from a database table. The basic syntax of a SELECT statement is:
SELECT column1, column2, …
FROM table_name WHERE condition;
column1, column2, …: This is a comma separated list of the columns you want to retrieve data from. You can use * to select all columns.
table_name: This is the name of the table from which you want to retrieve data.
WHERE condition: This is an optional clause that allows you to specify conditions to filter the rows you want to retrieve. Rows that satisfy the condition will be included in the result set.
Question 5.
Answer any 5 out of the given 6 questions.
(A) …………………. is an accessibility function which is designed for people who have vision impairment or cognitive disabilities. [1]
(a) Filter Keys
(b) Sound Kay
(c) Toggle Keys
(d) Sticky Keys
Answer:
(c) Toggle Keys
Explanation:
When Toggle Keys is turned on, the computer will provide sound cues when the locking keys (Caps Lock, Num Lock , or Scroll Lock) are pressed. To activate Toggle Keys – Press and hold the Num Lock key for 5 seconds. A tone sounds and the Toggle Keys dialog appears. Click on Yes button to turn On the toggle keys
(B) Networks in which certain computers have special dedicated tasks, providing services to other computers (in the network) are called …………………. networks. [1]
(a) hierarchical
(b) dedicated server
(c) peer to peer
(d) client server
Answer:
(d) Client server
Explanation:
Client-server architecture is a network computing model that defines the relationship and interaction between two types of computer – clients and servers. The client is a computer that requests services, resources, or information from a server, whereas the server is a computer that provides services, resources, or information to clients.
(C) ………………… provides Internet access by transmitting digital data over wires of a local telephone network. [1]
(a) HSDPA
(b) P2P
(c) DSL
(d) Modem
Answer:
(c) DSL
Explanation:
DSL stands for Digital Subscriber Line. It is a network technology that uses existing telephone lines to transmit high bandwidth data. The subscribers have to use modern to connect their computer to this type of network.
(D) ………………… is an unplanned event that may happen all of a sudden and may lead to unwanted or unprecedented results/outcomes. [1]
(a) emergency
(b) hazard
(c) accident
(d) illness
Answer:
(c) accident
Explanation:
An accident can be defined as an unfortunate incident that occurs unintentionally and causes hazardous results.
(E) A ………………… worker will always perform to the best to his ability. [1]
(a) fast working
(b) highly educated.
(c) happy and healthy
(d) stressed
Answer:
(c) happy and healthy
Explanation:
A happy and healthy worker will perform well at work. When an employee is personally and professionally satisfied, they are likely to be more engaged, motivated, and productive. A healthy worker will not require any sick leave, which will improve overall efficiency and productivity.
(F) ………………… is the process of emptying a place in case of an emergency, disaster. [1]
(a) Emergency
(b) Accident
(c) Drill
(d) Evacuation
Answer:
(d) Evacuation
Explanation:
An evacuation route is a way to get out of a building if there is an emergency, such as a fire.
Drill is a practice exercise to prepare individuals for a potential emergency. It is a procedure that involves the simulation’ of emergency circumstances, such as fre, earthquake, lockdowns, or active shooter incidents, to train individuals to respond in a real-life scenario.
Emergency refers to an unexpected situation that needs immediate attention and action.
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 is self-awareness? Also give any two benefits of self-awareness. [2]
Answer:
Self awareness is the ability to recognise one’s mental state, including thoughts, feelings, challenges, and strengths and how it affects one’s behavior and decisions. It can be viewed as knowledge of self or being aware of oneself.
Benefits of self-awareness are:
- It helps in making better.
- Improves communication skills.
- Enable a person to manage and regulate their emotions. A note should be added here, because only two benefits are asked.
so we can write a note as:
[Note: Write any of the two benefits]
Question 7.
Give one example each of following stress causal agents for students: [2]
(A) Mental
(B) Social
Answer:
(A) Mental: Students feel anxiety and fear during exams and when they are unable to complete their assignment according to deadlines. High expectations from self also leads to anxiety and stress.
(B) Social: relationships amongst family members, peer pressure due to over expectations from the children to achieve something for status show off may lead to stress at times.
Question 8.
Differentiate between files and folders. [2]
Answer:
File | Folder |
Files usually have extensions. | Folders do not have extensions. |
A file cannot contain another file/folder. | A folder can contain any number of file and folders. |
A file has its own size and memory consumption. | A folder has no size of its own. It size depends on files stored in it. |
Files cannot be shared on network on their own. | Folders can be shared on network. |
Question 9.
Give any two qualities of a successful entrepreneur. [2]
Answer:
A successful entrepreneur must have following qualities:
- Willpower and Focused: This quality is key to success for an entrepreneur. It takes a long time to achieve success. Despite the failures, an entrepreneur must not lose will and focus to achieve.
- Management: It is the ability to make plans, devise targets, and then execute. An entrepreneur should be a good manager to perform alL these tasks successfully.
Question 10.
Give any two promotional functions of an entrepreneur. [2]
Answer:
An entrepreneur’s role is diversified and promotional function is one of them. It includes the following:
- Discovery of idea: The success of a startup lies in the idea behind it. Before initiating any business an entrepreneur comes up with an idea and find ways to implement it. This process usually involves study of marker needs and finding out profit potential in that idea, and so on.
- Detailed Investigation: Generating an idea is not a difficult process. However, implementation ofthe idea and to find that it has the potential to turn into a viable business venture is more difficult. For this, an entrepreneur conducts market survey, evaluates the profit and loss in the idea considering various factors and estimates the total demand for a new product or service.
Answer any 4 out ofthe given 6 questions in 20-30 words each.
Question 11.
Differentiate between Keep scale and Keep image size options while cropping an image in a document. [2]
Answer:
The ‘Keep scale’ option does not change the scale of the picture while cropping it. Whereas, ‘Keep image size’ option produces enlarged image (for positive cropping values), shrinked image (for negative cropping values), or distorted image so that the image size remains constant.
Question 12.
Give any two characteristics ofa template in Open Office Writer. [2]
Answer:
A template has following characteristics:
(A) Templates simplify the creation of documents.
(B) Templates increase efficiency by reducing our workload and make us feel less stressed.
Question 13.
Why do we need to merge worksheets? [2]
Answer:
When multiple users collaborate on the same shared worksheets and mark their reviews on it, you can use the feature ofmerging worksheets to view all oftheir changes at once and address them by accepting or rejecting them.
Question 14.
What is a Primary Key? How is it different from foreign key? [2]
Answer:
A primary key is a column in database that stores unique values whereas a foreign key is a column or group of columns in a relational database table that provides a link between data in two tables.
Question 15.
Expand and explain the term WAN. [2]
Answer:
WAN stands for Wide Area Network. It is the technology that connects your offices, data centers, cloud applications, and cloud storage together. This network spans beyond a single building or large campus to include multiple locations spread across metropolitan, regional, or national boundaries.
Question 16.
(A) Identify the following network / Internet connectivities as wired or wireless:
(i) Dial-up
(ii) WiMax
(B) Give any one feature of Instant messaging ………………… [2]
Answer:
(A)
(i) Dial-up: Wired network
(ii) WiMax: Wireless network
(B) The instant messaging software allows users to share audio, video, images, documents along with text to individuals or in groups.
Answer any 3 out of the given 5 questions in 50-80 words each.
Question 17.
Explain the following terms with respect to positioning the graphics in a document: [4]
(A) Arrangement
(B) Text Wrapping
Answer:
(A) Arrangement refers to the placement of graphics stacked upon each other or relative to the text.
(B) Text wrapping refers to the way text flows around or interacts with inserted images or graphics within a document. Text wrapping options allow you to control how the text and graphics coexist on the page.
Question 18.
Distinguish between the following with respect to spreadsheets: [4]
(A) Relative and Absolute hyperlink.
(B) Internet hyperlink and Document hyperlink.
Answer:
(A) Relative Hyperlink
- A relative hyperlink defines path of a document with respect to the current or active document.
- If the file is moved this link will not break. It will stop working only if the start and target locations change relative to each other.
Absolute hyperlink
- An absolute hyperlink defines path of the file from the topmost folder.
- It will stop working if the target is moved.
(B) Internet Hyperlinks: The hyperlink points to a web address, normally starting with http:// or https:// is known as internet hyperlink. Internet hyperlinks connect content across the global network of the World Wide Web.
Document Hyperlinks: The hyperlink points to a place in either the current worksheet or another existing worksheet document hyperlink Document hyperlinks are used to connect content within a specific document or on a local network.
Question 19.
Explain any four data types of DBMS. [4]
Answer:
The different datatypes in a database management system:
Numeric Data Type: Numeric data types are used for storing numeric values for the field used in a table. This data types can be used for storing information such as mobile number, roll number, year of birth, etc.
Alphanumeric Types: The data types char, varchar. long varcharare called alphanumeric datatypes and are used to store the text.
Binary Types: Binary data types are used for storing data in binary formats. It can be used for storing photos, music files, etc.
DATE/ TIME: Date/ time data types are used for describing date and time values for the field used in the table. It can be used for storing information such as date of birth, date of admission, date of product sale, etc.
Question 20.
(A) Structure of a table “Orders” is given below. Suggest suitable data type of each column
Table: Orders
Order_ID | Order_date | Customer_ID | Amount |
A_101 | 12/12/19 | C3445 | 1200.00 |
A_202 | 11/09/19 | C1245 | 3456.00 |
A_402 | 09/07/19 | C2121 | 2312.00 |
(B) Consider the following table “Books”.
BkID | BkName | Author | Qty | Price |
B_101 | Learning with Fun | Jacobins | 5 | 355.00 |
B_103 | How I Live Now | Meg Rosoff | 4 | 400.00 |
B_104 | I Capture the Castle | Dodie Smith | 5 | 520.00 |
B.106 | Mortal Engines | Philip Reeve | 4 | 260.00 |
B_110 | The Kite Rider | Geraldine McCaughrean | 3 | 270.00 |
Write SQL queries to
(i) Display data ofall books whose quantity is more than 3.
(ii) Display total amount of all books whose price is less than 500.
(Hint: amount = Qty x Price) [4]
Answer:
(A) The data types for all the fields are given:
Order ID – Char
Customer ID – Char
Amount – Float
(B)
(i) SELECT * FROM Books WHEREQty>3
(ii) SELECTQty*Price “Total Amount” FROM Books Price < 500
Question 21.
(A) Give two best practices for internet safety.
(B) Give any two Falls and Slips Safety rules. [4]
Answer:
(A) To ensure safety while working on Internet follow the given practices:
- Get the latest anti-virus and firewall software.
- Use a strong and easy-to-remember password.
- Change the password frequently.
- Do not share personal information with unknowns and on unsecured sites.
(B) The safety rules for falls and slips are:
- Keep the walking area clean and clutter free.
- Wear non slippery footwear.
- Floors must be clean and dry.
- Oil’ spills, dust must be immediately cleaned.