Students can access the CBSE Sample Papers for Class 10 IT with Solutions and marking scheme Set 3 will help students in understanding the difficulty level of the exam.
CBSE Sample Papers for Class 10 IT Set 3 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) …………………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 of the given 6 questions. (1 x 5 = 5 marks)
(i) A key is used to reduce repetitive strain.
(a) Sticky
(b) Serial
(c) Mouse
(d) Toggle
Answer:
(a) Sticky
(ii) ………….. means that the query uses criteria you provide to hide some data and display only required data.
(a) Filtering
(b) Report
(c) Sorting
(d) Forms
Answer:
(a) Filtering
(iii) Which of the following application is not appropriate to store data about ABC Bank customers?
(a) Open Office Base
(b) Open Office Writer
(c) MS Access
(d) MS Excel
Answer:
(b) Open Office Writer
(iv) When you open a new spreadsheet, by default, it has a sheet named ………….. which is managed using tabs at the bottom of the spreadsheet.
(a) Sheet 1
(b) Worksheet 1
(c) Untitled 1
(d) New Sheet 1
Answer:
(a) Sheet 1
(v) In a word processor, ………….. option is selected for a scaled resizing of an image.
(a) Original Size
(b) Image Size
(c) Keep Ratio
(d) Relative
Answer:
(c) Keep Ratio
(vi) Multiple copies of the same file leads to …………..
(a) Data Inconsistency
(b) Data Redundancy
(c) Data Consistency
(d) Foreign Key
Answer:
(b) Data Redundancy
Question 3.
Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(i) Which of the following is a set of formats consisting of such things as fonts, colors, etc? (1)
(a) Style
(b) Margin
(c) Indent
(d) Leading
Answer:
(a) Style
(ii) Which of the following is not a data type? (1)
(a) Picture/Graphic
(b) Date/Time
(c) Text
(d) Number
Answer:
(a) Picture/Graphic
(iii) _________ is a Malware which is designed to spy on the victim’s computer. (1)
(a) Virus
(b) Spyware
(c) Worms
(d) Trojan horse
Answer:
(b) Spyware
(iv) Pictures can be added to Word documents and they cannot be formatted in various ways. (1)
(a) True
(b) False
Answer:
(b) False
(v) Which function cannot be performed through Subtotal in a Spreadsheet? (1)
(a) Sum
(b) Product
(c) Average
(d) Percentage
Answer:
(d) Percentage
(vi) It refers to a cell or a range of cells on a worksheet and can be used to find a formula. (1)
(a) Row
(b) Column
(c) Autosum
(d) Cell reference
Answer:
(d) Cell reference
Question 4.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) Identify the website that offers offline blog service for free.
(a) Blogdesk
(b) Qumana
(c) Word Press
(d) both (a) and (b)
Answer:
(d) both (a) and (b)
(ii) John has written a book consisting of fifteen chapters. He wanted to make the index of the book. Suggest him the option used to create the index automatically in a word processor.
(a) Tables
(b) Columns
(c) Mail Merge
(d) Table of Content
Answer:
(d) Table of Content
(iii) The length of the field value of text data type is ………….. characters by default in DBMS.
(a) 10
(b) 25
(c) 20
(d) 50
Answer:
(d) 50
(iv) A healthy lifestyle helps to keep and improve people’s health and well-being. It does not include:
(a) Healthy eating habits
(b) Physical activities
(c) Stress management
(d) Less sleep
Answer:
(d) Less sleep
(v) In a spreadsheet using to create a hyperlink to a web FTP or Telnet, click on the icon available in Hyperlink dialog box.
(a) browser
(b) Internet
(c) hyperlink
(d) mail & news
Answer:
(b) Internet
(vi) A refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate.
(a) Cell Reference
(b) Sheet Reference
(c) Block
(d) Autofill
Answer:
(a) Cell Reference
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.
Questions 6.
When interviewing job candidates, what qualities do employers find impressive? (2)
Answer:
During a personal interview, employers are impressed by a job candidate with the qualities of answering questions with more than one-word answers, demonstrating that he is listening and sharing ad information and ideas by asking questions for clarification and follow-up.
Question 7.
Give one example of each of the 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 assignments according to deadlines. High expectations from the self also lead 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.
What do you mean by Disk Defragmentation?
Answer:
A disk defragmentation removes all unnecessary information that slows down the computer. It should be done at regular intervals which helps the disc space to be used at an optimal level.
Questions 9.
Explain innovativeness as a quality of the entrepreneur. (2)
Answer:
With the changing needs and requirements of customers, production should meet requirements with the help of innovative ideas. An entrepreneurial venture does not have to restrict itself to just one innovation or even one type of innovation. Success can be built on a combination of innovation, for example, a new product delivered in a new way with a new message.
Question 10.
Write any four roles of Entrepreneurs.
Answer:
The roles of Entrepreneurs are:
- Coordinating role
- Agent’s role
- Innovator’s Role
- Risk assumption role
- Imitating role
- Capital formation role:
- Employment Generation role
Answer any 4 out of the 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 an enlarged image (for positive cropping values), shrunk image (for negative cropping values), or a distorted image so that the image size remains constant.
Questions 12.
What is the purpose of a primary key in a database management system? (2)
Answer:
The primary key in a DBMS uniquely identifies each record in a table and ensures data integrity. It enforces data integrity by preventing duplicate and null values. Also, it facilitates efficient data retrieval and serves as a reference for establishing relationships between tables.
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 of merging worksheets to view all of their changes at once and address them by accepting or rejecting them.
Question 14.
List Numeric and Alphanumeric Datatypes in OpenOffice Base.
Answer:
Numeric datatypes are Tinylnt, Small, and Integer. Biglnt, Decimal, Real, Float, Double and Boolean.
Alphanumeric Datatypes are Char(fix), Varchar, Varcharignorecase, and Long varchar(Memo).
Questions 15.
What are slipping and tripping hazards? (2)
Answer:
You slip when you lose your footing whereas you trip when you catch your foot on or in something and you fall when you come down suddenly on wet or oily surfaces, occasional spills, flooring that does not have the same degree of fraction in all areas, etc common causes of slips whereas trip occurs due to wrinkled carpeting, poor lighting, obstructed view, uncovered cables, ladders, etc.
Question 16.
In which situations Online shopping could be useful? Write any two popular e-commerce websites.
Answer:
Online shopping could be useful in situations when:
- A customer does not have sufficient time to visit stores.
- Visiting a store is more expensive than purchasing a product online.
- Two popular online transaction websites are:
Flipkart is an online shopping portal for buying consumer products.
EBay, is an online portal for buying and selling goods.
Answer any 3 out of the given 5 questions in 50 – 80 words each.
Question 17.
Explain the following terms concerning 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.
Arihant stationery keeps stock of various stationery in his shop. The proprietor wants to maintain a stock value and reorder level for the following items as given in a spreadsheet. Write formulas for the operation (i) to (iii) and answer question (iv) based on the spreadsheet given below along with the relevant cell address. (4)
(i) To calculate the Stock Value as a product of ‘Quantity in Stock’ and ‘Rate’ for each item present in the spreadsheet.
(ii) To calculate the ‘Quantity to Order’ as ‘Minimum Stock Quantity’-‘Quantity in Stock’ for each item.
(iii) To calculate the ‘Order Value’ as a product of ‘Quantity to Order’ and ‘Rate’ for the items if ‘Quantity to Order’ > = 0, else assign the value as 0.
(iv) The Proprietor wants to graphically represent his stationery stock. Suggest to him the most appropriate feature of MS Excel.
Answer:
(i) At cell F2, type = D2*E2 and then copy this formula using Fill handle in range F3 : F5.
(ii) At cell G2, type = C2-D2 and then copy this formula using fill handle in range G3 : G5.
(iii) At cell H2, type = IF (G2 > = 0, G2*E2, 0) and copy this formula using the Fill handle in the range H3 : H5.
(iv) Fie should create a chart of any type to graphically represent his data.
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.
Your friend owns a chemist shop, he needs to keep records of the medicines with their id’s, date of purchase, expiry date, price, etc. in a database program. But he does not have any knowledge about the database. Explain to him the following to get a better understanding of the DBMS concepts.
(A) What is DBMS? Explain in brief.
(B) Name any two database programs which can be used to create a table and store the data as per the requirement.
(C) Which field can be set as a Primary Key?
(D) Is it possible to make more than one field as a primary key in your table? (Yes/No). Justify your answer.
Answer:
(A) A database management system is a software package with computer programs that controls the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications.
(B) Two databases are:
(a) Microsoft Access
(b) MySQL
(c) Open Office Base
(C) Id field will be suitable for Primary Key.
(D) Yes. we can make more than one column as a primary key in a table and it is known as Composite Primary Key.
Question 21.
Sonia had heard about the various types of ISPs. She had some doubts. Answer her queries to clear her doubts. (4)
(a) What is an ISP?
(b) Name any two ISPs of India.
(c) Name any two connection types that home users use.
(d) What is a satellite?
Answer:
(a) An Internet Service Provider (ISP) is an organization that provides you with access to the Internet via wired or wireless connection. To use the Internet, you need an Internet connection.
(b) Internet connections are provided by Internet Service Providers (ISPs) such as Bharat Sanchar Nigam Limited (BSNL), MTNL, Airtel, Vodafone, Reliance, Tata Indicom, etc.
(c) The home users use cable modem(type of broadband connection) and Wi-Fi(Wireless Fidelity). It is a popular technology that allows an electronic device such as a computer or mobile phone to exchange data wirelessly over a network.
(d) Satellites orbit around the Earth and provide necessary links for telephone and television services.