Students can access the CBSE Sample Papers for Class 10 IT with Solutions and marking scheme Set 5 will help students in understanding the difficulty level of the exam.
CBSE Sample Papers for Class 10 IT Set 5 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) Which of the following is not a type of feedback? [1]
(a) Positive feedback
(b) Negative feedback
(c) No feedback
(d) None of the above
Answer:
(d) None of the above
Explanation:
Feedback is important in letting your employees know how they are doing. There are three types of feedback: positive, negative and no feedback.
No feedback is technically not a type of feedback, as it is the absence of feedback.
(B) In SMART goals, what does “A” stands for? [1]
(a) Artificial
(b) Aim
(c) Alignment
(d) Achievable
Answer:
(d) Achievable
Explanation:
SMART is an acronym that stands for specific, measurable, achievable, realistic, and time bound. The goals should be achievable in a specific time frame.
(C) Neha works hard to get the best student award at the end of the year. What type of motivation is this? [1]
(a) Internal
(b) External
(c) Both (Internal & External)
(d) None of the above
Answer:
(b) External
Explanation:
The motivation which is attained from the source outside yourself is called external motivation. Punishment, reward, promotion, and criticism are examples of external motivation.
Love, joy, fear, and passion, are examples of internal motivation.
(D) Which of the following shortcut keys is used to select all content of a file? [1]
(a) Ctrl + A
(b) Ctrl + X
(c) Ctrl + V
(d) Ctrl + Y
Answer:
(a) Ctrl+A
Explanation:
Ctrl+A when pressed together, selects all the context of a file or document.
The keyboard shortcut for copying is Ctrl+C, for cutting is Ctrl+X and for pasting is Ctrl+V.
(E) __________ means a product or service that people want. [1]
Answer:
Demand
Explanation:
Entrepreneurs identify the need or demand of the market and build a product or service for it.
(F) Full form of SDGs is _________. [1]
Answer:
Sustainable Development Goals.
Explanation:
The Sustainable Development Goals (SDGs) are a universal call to action to end poverty, protect the planet, and ensure that all people enjoy peace and prosperity.
Question 2.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) …………….. is not a type of style in word processor.
(a) Text style
(b) Character style
(c) Paragraph style
(d) Frame style
Answer:
(a) Text style
(ii) Aradhya wants to invest some money. Her financial advisor has suggested some investment plans. She wants to check what return she would get from all the suggested plans. Which of the following What-lf analysis can help her to accomplish the task?
(a) Scenario
(b) Goal Seek
(c) Solver
(d) All of these
Answer:
(a) Scenario
(iii) Each record in a database is made up of ……………..
(a) Tables
(b) Fields
(c) Criteria
(d) Forms
Answer:
(b) Fields
(iv) …………….. configures the Windows 10 Accessibility options.
(a) Start menu
(b) Ease of Access
(c) Role Explorer
(d) All Programs
Answer:
(b) Ease of Access
(v) Which of the following is not an advantage of a blog?
(a) It enables to write your thoughts.
(b) Available to everyone.
(c) Quick to add and update new posts.
(d) People can leave comments on blogs.
Answer:
(b) Available to everyone
(vi) Cropping means the area from an image.
(a) Adding
(b) Removing
(c) Enhancing
(d) Grouping
Answer:
(b) Removing
Question 3.
Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(i) In a document, you can insert __________ (1)
(a) Pictures
(b) ClipArts
(c) Shapes
(d) All of these
Answer:
(d) All of these
(ii) Which of the following is not the main building block of a database? (1)
(a) Lists
(b) Queries
(c) Reports
(d) Forms
Answer:
(a) Lists
(iii) __________ is a computer program that provides services to other computer programs. (1)
(a) Server
(b) Client
(c) Network
(d) None of these
Answer:
(a) Server
(iv) State True or False.
ClipArt object includes effects such as shadows, outlines, colors, gradients, and 3D effects. (1)
(a) True
(b) False
Answer:
(b) False
(v) To group sheets, while holding the __________ key, click on the Sheets tab you want to group. (1)
(a) Alt
(b) Shift
(c) Ctrl
(d) Tab
Answer:
(c) Ctrl
(vi) If a table has to be created which tab and group should be used? (1)
(a) Insert tab → Tables group
(b) Home tab → Tables group
(c) Design tab → Tables group
(d) None of the above
Answer:
(c) Design tab → Tables group
Question 4.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) In Mail Merge, the main document consists of
(a) Letter only
(b) Letter and fields
(c) Addresses and fields
(d) Reids only
Answer:
(b) Letter and fields
(ii) Rajendra is an office assistant in a school He maintains the records of students in a spreadsheet He wants every class teacher to check the records of students their own class. He also wants to know the changes made by teachers. Which feature’ of the spreadsheet can help him to accomplish the task?
(a) Linking
(b) Macro
(c) Review changes
(d) Track Changes
Answer:
(d) Track changes
(iii) A key in a database is used to link tables together.
(a) Foreign
(b) Primary
(c) Shortcut
(d) Relational
Answer:
(a) Foreign
(iv) In Calc, the field for subtotal is specified through …………….. option.
(a) Group By
(b) Subtotal
(c) Solver
(d) Scenario
Answer:
(b) Group By
(v) Select the incorrect statement about the Alternate key.
(a) It has a unique value.
(b) It is not selected as the Primary key.
(c) It is the other name given to the primary key.
(d) None of these
Answer:
(c) It is the other name given to the primary key.
(vi) A page hosted on the Internet is called
(a) Website
(b) Web client
(c) Web page
(d) Home page
Answer:
(c) Webpage
Question 5.
Answer any 5 out of the given 6 questions.
(A)_________ is an accessibility feature that assists people that have difficulty using a keyboard or a mouse (or both). [1]
(a) Toggle key
(b) Filter key
(c) Sticky key
(d) Serial key
Answer:
(d) Serial key
Explanation:
The serial key accessibility feature allows user to use special devices such as sip, puff, and breath switches to provide input to the computer through serial ports.
(B) __________ is an accessibility function which is designed for people who have vision impairment or cognitive disabilities. [1]
(a) Toggle key
(b) Filter key
(c) Sticky, key
(d) Serial key
Answer:
(a) Toggle key
Explanation:
Toggle key accessibility feature which is designed for visually impaired people. When toggle keys are on, the computer provides sound cues, when the locking keys Capslock, Numlock or Scrolllock are pressed.
(C) Full form of ISP is __________. [1]
Answer:
Internet Service Provider.
Explanation:
An internet service provider (ISP) is an organization that provides services for accessing, using, managing, or participating in the Internet.
BSNL AirteL MTNC, and Reliance are some examples of ISP.
(D) Which of the following is not a wireless technology? [1]
(a) DSL
(b) 3G
(c) WiMAX
(d) WiFi
Answer:
(a) DSL
Explanation:
DSL is a network technology that user existing telephone lines to transit high bandwidth data. The subscribers has to use modern to connect their computer to this type of network.
(E) Mouse key is an accessibility feature that assists people who have difficulty using a mouse. (True/False) [1]
Answer:
True
Explanation:
Mouse key is an accessibility feature that uses the keyboard’s numeric keypad as a pointing device. It replaces the mouse as a pointing device for people who have difficulty in using the mouse.
(F) To create a strong password, we should use numbers, capital and small letters and some symbols (if allowed). (True/False) [1]
Answer:
True
Explanation:
It is always recommended to secure your online accounts and data with a good password. A good password is longer and is a mix of uppercase, and lowercase letters with numbers and other symbols.
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 happens during meditation that makes it a useful technique for managing stress? (2)
Answer:
During meditation, we change from our normal activities to silence. We go beyond the noisy thoughts in the mind and enter a state of restful alertness, thus reducing stress. At this time, although we are in a state of deep rest, our mind is fully alert and awake. Thus, the body experiences many healing effects which are the reverse of the ‘fight-or-flight’ response, such as decreased heart rate, normalization of blood pressure, deeper breathing, reduced production of stress hormones, higher immunity, more efficient use of oxygen by the body, and reduced inflammation. All these changes in body function help in managing stress effectively.
Question 7.
What is ‘self-motivation’? [2]
Answer:
Self-motivation is referred to as an inner drive that leads us to take action towards a goal. It is the ability to do things on your own.
Question 8.
How can you manage emotional intelligence?
Answer:
Emotional intelligence is managed by following the three steps:
- Understand your Emotions : This is done by observing oneself behaviour and by working on things that needs to be changed.
- Rationalise: One’s behaviour should be rationalised. One should take decisions reasonably.
- Practice to keep oneself calm : Keeping the body and mind calm can be practised by yoga and meditation.
Question 9.
Explain the role and significance of entrepreneurs. (2)
Answer:
The role and significance of entrepreneurs are discussed below:
- Organiser of Society’s Productive Resources: He assembles the unused natural, physical, and human resources of the society, combines them properly, establishes effective coordination between them, and makes the economic activities dynamic.
- Helpful in Capital Formation: An entrepreneur is helpful in capital formation as we know that an increase in the rate of capital formation is quite essential for the economic development of any country.
- Increase in Employment Opportunities: An entrepreneur creates maximum employment opportunities in society by way of establishing new industries, developing and expanding existing industries, and undertaking innovative activities.
Question 10.
Write the steps that takes place when starting a computer.
Answer:
After you switch ON the Power button, following steps are performed by the computer:
1. POST (Power OnSelf Test) starts- It is an operation initiated by the computer after it is turned ON but before the operating system is loaded into memory.
2. Operating System Starts : After performing POST, the computer starts the process of booting up the operating system.
3. Welcome Screen Appears : After the booting process is complete, the monitor shows the Welcome screen of the operating system in your computer.
4. Login Screen Appears : The login screen asks for the user name or ID and its password to login into the computer.
5. Desktop Appears : After entering the correct ID and password, computer displays the desktop of the operating system and allows the user To work on the computer.
Answer any 4 out of the given 6 questions in 20 – 30 words each.
Question 11.
What do you understand by styles? [2]
Answer:
Style is a set of formatting characteristics that you can apply on different text components of a word processor such as tables, paragraphs, lists etc. Usually, a word processor has following types of styles: (a) Character style (b) paragraph style (c) frame style (d) page style (e) list styles
Question 12.
Mention any two operations that can be performed using macros in a spreadsheet. (2)
Answer:
Macros can be used for the following operations:
- If formatting settings need to be applied repeatedly in a spreadsheet then, macros can be used.
- Macros can be used to sort data and apply mathematical functions or formulas.
Question 13.
Differentiate between relative and absolute hyperlinks. [2]
Answer:
| Relative Hyperlink | Absolute hyperlink |
| A relative hyperlink defines path of a document respect to the current or active document. | An absolute hyperlink path of the file from the topmost folder |
| If the file is moved this link will not break. | It will stop working if the target is moved. |
Question 14.
Define the following terms:
(a) Web client (b) web portal
Answer:
(a) Web Client – A web client is a program on the client side of the network. It requests and uses services provided by a web server. A web browser is an example of web client.
(b) Web Portal – A web portal is a specially designed website that provides information from diverse sources such as email, online forums, search engines, etc. MSN, Yahoo, and India Times are some examples of web portals.
Question 15.
List any two advantages associated with networking. (2)
Answer:
Two advantages of networking are as follows:
- User Communication Network allows users to communicate using emails, social networking sites, video conferencing, etc.
- File Sharing By using networking, data or information can be shared or transferred from one computer to another.
Question 16.
Differentiate between goal seek and solver.
Answer:
| Goal Seek | Solver |
| Goal seek is used on single variable. | Solver can solve equations that use multiple variables. |
| It allows to vary the values only in one cell. | It allows values to vary in 200 cells. |
Answer any 3 out of the given 5 questions in 50 – 80 word each.
Question 17.
Write down the process for resizing an image. [4]
Answer:
Steps to resize an image in a word processor are as follows:
- Select the image by clicking on it. The image will be selected with sizing handles around it.
- Position the pointer over any one of the sizing handle. The pointer shape will change to a double headed arrow.
- Drag the sizing handles to increase/decrease the image size.
- Release the mouse button when desired size is achieved.
Question 18.
Ojas had prepared a Table of Contents of the project work he had done in a word processor application. (4)
(a) Tell him the different steps to update the TOC
(b) Tell him the different steps to delete the TOC
Answer:
(a) To update a table of contents when changes are made to the document:
- Right-click anywhere in the TOC
- From the pop-up menu, choose Update IndexYTable. The writer updates the table of contents to reflect the changes in the document.
You can also update the index from the Navigator by right-clicking on Indexes → Table of Contents1 and choosing Index → Update from the pop-up menu.
(b) To delete the table of contents from a document:
- Right-click anywhere in the TOC.
- From the pop-up menu, choose Delete Index/Table. The writer deletes the table of contents.
Question 19.
What do you mean by relationship? Explain the different types of relationships. [4]
Answer:
In DBMS, relationships refer to the connection between one or more tables through a common field. Three types of relationships can be formed in a database. These are as follows:
- One-to-One: In this type of relationship, each record in the first table can have only one matching record in the second table, and in the second table each record can have only one matching record in the first table.
- One-to-Many: In this type of relationship, a record in the first table can have many matching records in the second table, however a record in the second table can have only one matching record in the first table.
- Many-to-Many: In this type of relationship, each record in the first table has many matching records in the second table and a record in the second table can have many matching records in the first table.
Question 20.
Amit Kohli is the owner of a Call Center. He wants to store a huge amount of information about all his employees and clients in a database.
(A) Which type of table organization would be most suitable for this purpose?
(B) What is the difference between both types of data organization?
(C) Mention any two advantages of database software.
(D) Name the software used to work on databases.
Answer:
(A) He can create either a relational or Flat table.
(B) A flat file database stores data in a single table structure. A relational database uses multiple table structures and cross-referencing records between tables. Tables in both organize records in rows, with each column containing a single piece of data in the record.
(C) Database software has the following advantages:
- It reduces data redundancy i.e. duplication of data.
- It facilitates the sharing of data among multiple users.
(D) My SQL Oracle, MS SQL IBM DB2 are some of the commonly used database software.
Question 21.
Manya is studying the different topologies available in networking. Tell her the difference between Star topology and Bus topology with the help of a suitable diagram. (4)
Answer:
Differences between star topology and bus topology are as follows:
| Star topology | Bus topology |
| (i) All the nodes are directly connected with the central node or server | (i) There is a single length of transmission medium, on which various nodes are attached and the server can be anywhere in the transmission cable. |
| (ii) Faults can be easily detected. | (ii) Faults cannot be easily detected. |
| (iii) It has a fast transmission speed.
|
(iii) It becomes slow as the number of nodes increases.
|
