Students must start practicing the questions from CBSE Sample Papers for Class 10 Information Technology with Solutions Set 5 are designed as per the revised syllabus.
CBSE Sample Papers for Class 10 IT Set 5 with Solutions
Max. Time : 2 Hours
Max. Marks: 50
Section A
Objective Type Questions
Question 1.
Answer any 4 out of the given 6 questions on Employability Skills. (1 × 4 = 4 Marks)
(i) Self management skills refers to
(a) Controlling your happiness.
(b) Managing your belongings.
(c) Controlling your anger.
(d) Motivating oneself and setting goals.
Answer:
(d) Motivating oneself and setting goals.
(ii) Which of the following is not a role of an entrepreneur?
(a) Team building
(b) Avoiding risks
(c) Cashflow management
(d) Decision making
Answer:
(b) Avoiding risks
(iii) …………….. is not a step of computer maintenance.
(a) Cleaning dust
(b) Copying files from hard drive to pen drive
(c) Removing junk files
(d) Updating software
Answer:
(b) Copying files from hard drive to pen drive.
(iv) Punishment is a …………….. type of self motivation.
(a) Extrinsic
(b) Intrinsic
(c) Both (a) and (b)
(d) None of these
Answer:
(a) Extrinsic
(v) Linux is an example of
(a) Operating system
(b) DBMS
(c) Antivirus
(d) Word processor
Answer:
(a) Operating system
(vi) Which of the following statement is incorrect about the impact of an entrepreneur in the society?
(a) Entrepreneurship creates jobs.
(b) The price of the product goes high.
(c) Contribute growth to overall economy.
(d) None of these
Answer:
(b) The price of the product goes high
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. (1 × 5 = 5 Marks)
(i) To create figure and shapes in a document …………….. feature of word processor is used.
(a) Images
(b) Drawing objects
(c) WordArt
(d) ClipArt
Answer:
(b) Drawing objects
(ii) In a spreadsheet the cell reference from B5 to E15 will be represented as
(a) B5 – E15
(b) B5 : E15
(c) B5 ; E15
(d) B5 = E15
Answer:
(b) B5:E15
(iii) …………….. is a shortcut key to create a new database.
(a) Ctrl + O
(b) Ctrl + N
(c) Ctrl + E
(d) Ctrl + D
Answer:
(b) Ctrl + N
(iv) …………….. helps to keep the Ctrl, Shift and Alt keys pressed until next key is pressed.
(a) Toggle keys
(b) Sticky keys
(c) Function keys
(d) Filter keys
Answer:
(b) Sticky Keys
(v) A query consists of ……………..
(a) Condition
(b) Reid
(c) Value
(d) All of these
Answer:
(d) All of these
(vi) Digital order and digital receipt are a part of ……………..
(a) E-ticketing
(b) Online transaction
(c) Both (a) and (b)
(d) None of these
Answer:
(b) Online transaction
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) key in a database is used to link tables together.
(a) Foreign
(b) Primary
(c) Short cut
(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 Alternate key.
(a) It has unique value.
(b) It is not selected as 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 Internet is called
(a) Web site
(b) Web client
(c) Web page
(d) Home page
Answer:
(c) Webpage
Question 5.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) Kavita wants to apply for a job. She needs a resume to submit in different companies. She knows what to write in a resume but does not know how to format it Which of the following features of a word processor can help her for the same?
(a) Style
(b) Template
(c) Table of contents
(d) None of these
Answer:
(b) Template
(ii) Which of the following is not an advantage of macros?
(a) Automates repetitive keystrokes.
(b) Reduces the possibility of human error.
(c) Reduces time spent in repetitive tasks.
(d) Makes tasks complex.
Answer:
(d) Makes tasks complex
(iii) To specify a condition of Bal_Stock between 25 and 50 the Criterion row in Query Design View should contain:
(a) > = 25 and < = 50
(b) > = 50 and < = 25
(c) > = 25 and < = 50 in the column BaL Stock
(d) Between 25 and 50 in the column Bal_Stock
Answer:
(c) > = 25 and < = 50 in the column BalStock
(iv) In the office of a finance company there are 7 computers. They all are connected to a network. These computers act as server as per the need. Which type of network is established there?
(a) Peer-to-peer network
(b) Client Server Network
(c) Common Network
(d) Metropolitan Area Network
Answer:
(a) Peer-to-peer network
(v) Forms shows …………….. records at a time.
(a) 1
(b) 2
(c) 3
(d) As many as you want.
Answer:
(a) 1
(vi) State whether true or false. In Calc, a sheet can be added only from Insert menu.
(a) True
(b) False
Answer:
(b) False
Section B
Subjective Type Questions
Answer any 3 out of the given 5 questions on Employability Skills (2 × 3 = 6 Marks)
Answer each question in 20 – 30 words.
Question 6.
Explain innovation as the characteristic of an Entrepreneur.
Answer:
The production of any product should be according the needs of customers, which keeps on changing from time to time. Thus an entrepreneur has to be innovative. An entrepreneur always strives to fulfill the demands or needs of the customers by exploring new products, ideas and innovative creations.
Question 7.
What does ‘S’ stands for in SMART goals? Explain.
Answer:
In SMART, ‘S’ stands for specific. It means that goals should be well defined, clear and unambiguous. It should clearly specify what is to be achieved and accomplished. The specific goals have greater chance of being achieved. To make a goal specific, The six “W” questions must be taken into consideration:
- What: What do I want to accomplish?
- Who : Who is involved to achieve goal?
- When : When should the goal be achieved?
- Why : Why do I want to achieve the goal?
- Where : Where is this goal to be achieved?
- Which : Which are the requirements to achieve the goal?
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.
How does an entrepreneur benefit a society?
Answer:
Entrepreneurs can change the way of living and work. Their ventures not only create jobs but also conditions,, for making a wealthy society. Given below are some of the contributions that entrepreneurs make for the society:
- Entrepreneurship creates jobs.
- They use their creativity and finances to introduce innovative ideas and technologies.
- It helps in raising the standards of living by uplifting the earning power of people.
- Successful entrepreneurs set up a role model and inspire many more for entrepreneurship. Thus, the cycle of economic upliftment continues.
- Entrepreneurs invest in community projects and social causes like public health and education etc.
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 (2 × 4 = 8 Marks)
Question 11.
Explain the meaning of hierarchy of headings.
Answer:
Headings are very important in any document. Headings organise the document and increase its readability. A document may have headings and its sub headings or a sub- sub heading, i.e., a document can have various levels of headings called heading hierarchy. This hierarchy of headings specify the relationship between main heading and sub headings. It also describes the importance of information written under different levels of headings.
Question 12.
Why multiple sheets are used in a workbook?
Answer:
In every spreadsheet, by default a workbook consists of at least one worksheet. You can add new worksheets in the same workbook. Multiple worksheets are required when you are working on large amount of data. Multiple worksheets help in organising your workbook and make it easier to find data.
Question 13.
Write some of the advantages of databases?
Answer:
Advantages of databases are as follows:
- Databases reduce data redundancy, i.e., duplication of data.
- It controls data inconsistency which means multiple mismatching copies of same data.
- It facilitates sharing of data.
- It ensures that the data stored should follow the applicable standards.
- It ensures data security and privacy.
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 the diverse sources such as email, online forums, search engines etc. MSN, Yahoo, India times are some examples of web portals.
Question 15.
List some of the disadvantages of blogs.
Answer:
Disadvantages of blog are as follows:
- Information given in personal blogs may be biased or inaccurate.
- Blogs can be time consuming.
- The comments written on blogs may be rude or inaccurate.
- Whatever is published in blog is available to all.
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. |
Question 17.
Shanaya is a teacher in a school. She use to create marks lists of all the students in her diary. But this time she wants to create the marks lists in a spreadsheet.
(A) How can Spreadsheet help her? Enlist any two points.
(B) List any two disadvantages of Spreadsheet
(C) She wants to rename the sheets with class name on them. Give her the easiest option to rename the sheets.
(D) She started teaching one more class. How can she add one more sheet for her new class?
Answer:
(A) It provides functions, which can be used to create formulas to perform complex calculations on data.
- It has Macros, for recording and executing repetitive tasks.
(B) Spreadsheets are customisable so they are not user friendly and secure. Anyone can share the worksheet by sending a simple mail to any other person.
- Data visualisation is difficult especially when there is large number of records then scrolling up and down makes the working diffcult and time consuming.
(C) To rename a sheet double click on the sheet tab and replace the existing name.
(D) To add one more sheet right click on the sheet tab and click on Insert Sheet from the pop-up menu.
Question 18.
Priyanka works as an editor in leading magazine office. A magazine usually contains more than 100 pages. : to change the indentation and font size of all the paragraphs, fonts and colour of all headings in complete magazine.
(A) Explain the feature of word processor she should use to get this work done easily.
(B) What are the various categories of this feature?
(C) Mention any two advantages of this tool
(D) What is template?
Answer:
(A) She can use Style feature of a word processor to make her work easy. A style is a named collection of various formatting options. It is a set of formats that can be applied to pages, text, frames and other elements of the document to quickly change their appearance.
(B) Style can be categorised as follows:
- Character style – formats a single character, word or a phrase.
- Paragraph style – formats paragraphs including font type and size
- Frame style – formats text and graphic frames
- Page style – Organizes the structure of the document and adds page numbers
- List syle – formats numbered or bulleted lists
(C) The advantages of Style are:
- It maintains consistent formatting in a document.
- Major formatting changes can be easily applied to multiple objects of same style.
(D) Template is a special type of document that contains formatting features like styles, headers, footers, etc. It is used to create new documents on the basis of these formatting features. It is like a blue print used to create new documents.
Question 19.
Following table displays a part of information of Menu items in a restaurant.
Table: Items
Item-No | Item Name | Price |
110 | Cold Drink | 45 |
112 | Tea | 25 |
115 | Coffee | 75 |
(A) Which of the given fields can be set as a Primary key and why?
(B) Write SQL queries to:
(i) Display the price of Cold Drink
(ii) Add a new record with details (“116”, “Cold Coffee”, “115”)
(iii) Change the price of all items by adding Rs. 25 to each.
Answer:
(A) ItemNo field can be set as a primary key.
The reason is that the item number is a unique data for each item in the table and the items can be searched, viewed o the basis of the item number.
(B) (i) SELECT price FROM items WHERE ItemName = “Cold Drink”
(ii) INSERT INTO items VALUES (“1163 , “Cold Coffee”, “115”)
(iii) UPDATE items SET price = price + 25
Question 20.
Amit Kohli is an 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 organisation would be most suitable for this purpose?
(B) What is the difference between both types of data organisation?
(C) Mention any two advantages of database software.
(D) Name the software used to work on databases.
Answer:
(A) He can create either relational or Flat table.
(B) A flat file database stores data in a single table structure. A relational database uses multiple table structures, cross-referencing records between tables. Tables in both organise records in rows, with each column containing a single piece of data in the record.
(C) Database software has following advantages:
- It reduces data redundancy i.e. duplication of data.
- It facilitates sharing of data among multiple users.
(D) My SQL Oracle, MS SQL IBM DB2 are some of the commonly used database software.
Question 21.
Rajat and Saksham are friends from school time and they are still in contact with each other. They often message each other or chat whenever one finds the other one online.
(A) What is instant messaging?
(B) Name of the commonly used applications used for instant messaging. –
(C) Mention any two key features of instant messaging.
(D) Write any one difference between email and instant messaging.
Answer:
(A) Instant messaging technology is a type of online chat that allows its users to exchange
messages over internet in real time. It is done with the help of some application programs specially developed for and known as instant messengers.
(B) Some popularly known instant messaging applications are Google Hangout, Snap Chat Skype, Facebook Messenger and WhatsApp.
(C) The key features of Instant Messaging are:
- It is available 24 × 7.
- It can store and take backup of unlimited chat history.
(D) In Instant messaging service the messages are delivered instantly and it needs the users to be logged on to the same server. In email the mails can be sent from one mail server to another and the users do not need to logged on same time. The mails are stored on the server and can be downloaded later.