Practicing the CBSE Sample Papers for Class 10 Information Technology Set 9 allows you to get rid of exam fear and be confident to appear for the exam.
CBSE Sample Papers for Class 10 Information Technology Set 9 with Solutions
Time: 2 hrs
Max. Marks: 50
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
(Objective Type Questions)
Question 1.
Answer any 4 out of the given 6 questions based on Employability Skills [1 × 4 = 4 Marks]
(i) A ………….. is a group of sentences dealing with a particular topic.
(a) value
(b) word
(c) paragraph
(d) None of these
Answer:
(c) paragraph
(ii) In ……………., we change from our normal activities to silence. [1]
(a) meditation
(b) stress
(c) worries
(d) survival
Answer:
(a) meditation
(iii) ……………. is a common response to danger in all people and animals. [1]
(a) Internal stress
(b) Environmental stress
(c) Survival stress
(d) Fatigue-related stress
Answer:
(c) Survival stress
(iv) …………. is the arrangement of elements on the slide with which the slide is available. [1]
(a) Slide transition
(b) Slide layout
(c) Custom animation
(d) None of these
Answer:
(b) Slide layout
(v) The idea of sustainable development gained wide acceptance due to environmental concerns in the …………… [1]
(a) 19th century
(b) 20th century
(c) 21 th century
(d) 18th century
Answer:
(b) 20th century
(vi) There is no …………… income available to an entrepreneur. [1]
(a) leadership
(b) motivator
(c) regular or fixed
(d) None of these
Answer:
(c) regular or fixed
Question 2.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Safari is a web browser developed by …………. [1]
(a) Google
(b) Microsoft
(c) Apple
(d) None of these
Answer:
(c) Apple
(ii) When you define a field for a table, in which of the following parameters do access always considered optional? [1]
(a) Field name
(b) Data type
(c) Field size
(d) Description
Answer:
(d) Description
(iii) A …………….. is a language that enables users to access and manipulate data in a database. [1]
(a) DML
(b) DCL
(c) TCL
(d) DDL
Answer:
(a) DML
(iv) To copy a formula from one cell to another. [1]
(a) Drag the autofill handle
(b) Cut the cell
(c) Both (a) and (b)
(d) None of these
Answer:
(a) Drag the autofill handle
(v) When you apply a ……………, you apply a group of formatting effects together in one single step. [1]
(a) effect
(b) template
(c) style
(d) format
Answer:
(c) style
(vi) Akshat wants to store a huge amount of information about his firm in a database. Which type of table organisation would be most suitable for this purpose? [1]
(a) Relational
(b) Flat file
(c) Either relational or flat file
(d) Hierarchical
Answer:
(c) Either relational or flat file
Question 3.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Select ……………….> Track changes > Record from the menu bar. Thereafter, every change you record on the spreadsheet will have a red border around it. [1]
(a) File
(b) Edit
(c) Format
(d) Layout
Answer:
(b) Edit
(ii) Calc considers any data that it does not recognise as a number, date, time or formula, as: [1]
(a) Expression
(b) Equation
(c) Text
(d) Function
Answer:
(c) Text
(iii) In …………. topology, each node is connected to two and only two neighbouring nodes. [1]
(a) star
(b) ring
(c) mesh
(d) tree
Answer:
(b) ring
(iv) State True or False.
‘Goal seek in Calc, helps us to find the desired result by adjusting an input value.’ [1]
(a) True
(b) False
Answer:
(a) True
(v) Rajiv was asked to highlight the cells with green colour where the value entered is either greater than or equals to 120 in the worksheet containing thousands of data entries. Which feature of Calc should he use to get this work done within seconds? [1]
(a) Conditional formatting
(b) Filtering
(c) Sorting
(d) Simple formatting
Answer:
(a) Conditional formatting
(vi) Which of the following tools will help Swati, if she wants to arrange the height of students in her class in ascending order ? [1]
(a) Ordering data
(b) Sorting data
(c) Presenting data
(d) Referring data
Answer:
(b) Sorting data
Question 4.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) In URL, http : // www. arihant. com/ index, htm, which component identifies the path of a web page? [1]
(a) http
(b) www.arihant.com
(c) /index, htm
(d) All of these
Answer:
(c) /index, htm
(ii) What dialog box opens on choosing File > Templates > Manage Templates in Writer? [1]
(a) The File dialog box
(b) The Manage Templates dialog box
(c) The Templates dialog box
(d) The Record Template dialog box
Answer:
(c) The Templates dialog box
(iii) ………….. are the ways to produce the data stored in databases and tables in a printed form [1]
(a) Forms
(b) Queries
(c) Reports
(d) Data
Answer:
(c) Reports
(iv) Amab learnt about a software which gets installed on the computer without the user’s knowledge. Help him to find the name of the same. [1]
(a) Spyware
(b) Malware
(c) Adware
(d) None of these
Answer:
(a) Spyware
(v) Tamanna wants to know the name of the kind of software which seems useful in the beginning, but will cause damage to the computer once installed. What is such kind of software called? [1]
(a) Trojan horse
(b)Worm
(c) Malware
(d) Virus
Answer:
(a) Trojan Horse
(vi) ………… are pre-defined formulas in Calc. [1]
(a) Functions
(b) Autofill
(c) Solver
(d) Subtotal
Answer:
(a) Functions
Question 5.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) If the two departments (HR and IT) access the data simultaneously then only one department will see the updates by the other department. DBMS solves this issue. Thus, DBMS helps to …………. avoid which means if a single database is used by multiple users then it also ensures that the same data is present for all the users. [1]
(a) Data redundancy
(b) Data inconsistency
(c) Data piracy
(d) Data modification
Answer:
(b) Data inconsistency
(ii) A ………….. is a set of instructions used to perform a specific task or operations. [1]
(a) Software
(b) Hardware
(c) Spyware
(d) Firewall
Answer:
(a) Software
(iii) Rinky wants to know about the Number data type in Calc. Which of the following statement (s) is/are TRUE about it? [1]
(a) Numbers are generally raw numbers or dates.
(b) Numbers can be started with a dollar sign ($) or with some other currency symbols to display as currency.
(c) By default, number and date data is aligned to the right in Calc.
(d) All of the above
Answer:
(d) All of the above
(iv) How much space does the DATE / TIME data type hold in Base? [1]
(a) 2 bytes
(b) 4 bytes
(c) 8 bytes
(d) 10 bytes
Answer:
(c) 8 bytes
(v) Which tab is used to create Table of Contents in a document? [1]
(a) File tab
(b) Format tab
(c) Insert tab
(d) Styles tab
Answer:
(c) Insert tab
(vi) …………… is a form of electronic commerce that allows customers to directly buy goods or services from a seller on the Internet. [1]
(a) E-Shopping
(b) E-ticketing
(c) E-buying
(d) E-Delivery
Answer:
(a) E-Shopping
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.
What is the role of a channel in communication cycle? [2]
Answer:
The medium or channel is the means by which a message is sent. Some messages are more effective in written form, others maybe more effective on the telephone (e.g. urgent messages), while others maybe more effective if sent via electronic means such as E-mail. Communication channels have noise. Noise introduced by a communication medium is anything that interferes with communication. It may cause misunderstanding of the message or even disrupt the message completely so that it is not even received.
Question 7.
How physical exercise helps in management of stress? [2]
Answer:
Physical exercise is an activity done to achieve physical fitness and overall health. It improves blood circulation, lower blood pressure, clear the mind of worrying thoughts, improves our self-image, makes us feel better about ourselves and increases social contact. It also has some direct stress-busting benefits which pumps up endorphins the chemicals in the brain that act as a natural pain killers. It also improves the ability to sleep which in turn reduces stress.
Question 8.
Explain the presentation software in brief. [2]
Answer:
Presentation software is important for school, college or office purposes. It can animate all the elements that are a part of a slide, like the text, pictures, figures, shapes, smart art etc. Apart from this, we may perform transition from slide-to-slide, with special effects as it is the part of the software. There are some presentation softwares available and these include OpenOffice Impress, Keynote, Cor£l Presentations, SoftMakei Presentations.
Question 9.
Describe the following characteristics of entrepreneur: [2]
(i) Leadership
(ii) Risk Taking
Answer:
(i) Leadership An entrepreneur must possess the characteristics of leadership and must lead a team for achievement of goals. The leader is able to clearly articulate their ideas and has a clear vision. An entrepreneurial leader realises the importance of initiative and reactiveness and go out of their way to provide a support to the team.
(ii) Risk Taking An entrepreneur with rational planning and firm decisions bear the risks. They have differentiated approach towards risks. Good entrepreneurs are always ready to invest their i iine and money but they always have a back up for every risk they take.
Question 10.
The most significant environment problems are related to which type of resources? [2]
Answer:
The most significant environmental problems are associated with resources that are renewable such as air and water. They have a finite capacity to assimilate emissions and wastes but if pollution exceeds this capacity of ecosystem will deteriorate rapidly at a huge pace.
Answer any 4 out of the given 6 questions in 20-30 words each. [2 × 4 = 8 Marks]
Question 11.
What do you mean by template? [2]
Answer:
A template is a collection of styles that already has some formatting in place, such as fonts, logos and line spacing and can be used as a starting point for almost anything that you want to create. Microsoft Word offers hundreds of free templates, including invoices, resumes, invitations and form letters, among others.
Question 12.
What is the difference between absolute and relative hyperlinks as used in Calc? [2]
Answer:
Hyperlinks can be stored within your file as either relative or absolute. An absolute link will stop working only if the target is moved. A relative link will stop working only if the start and target locations change relative to each other. For instance, if you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will not break but an absolute link will break.
Question 13.
Explain the significance of primary and foreign keys.
Answer:
A field which uniquely identifies each record in a table known as primary key. It does not allow null values whereas a foreign key is used to establish relationship between RDBMS.
Question 14.
Write the steps to insert a record in a Datasheet View.
Answer:
Steps to insert a record in a Datasheet View are as follows:
- Step 1 When you create a table, a new blank record automatically appears in the second row of the table.
- Step 2 If you enter data in the last record, a new blank record will automatically appear at the end of the table.
- Step 3 Type data into the fields.
- Step 4 When you have finished adding records in the datasheet, save it and close it.
Question 15.
Elucidate the following terms: [2]
(i) PAN
(ii) WiMAX
Answer:
- PAN It stands for Personal Area Network. It is a computer network used for communication among the computer and different technological devices close to it.
- WiMAX It stands for Worldwide Interoperability for Microwave Access. It is a wireless transmission of data using a variety of transmission modes.
Question 16.
State any two practices for internet security. [2]
Answer:
Any two practices for internet security are:
- Use Strong Passwords A strong password is a combination of alpha-numeric and special characters. Do not use your mobile number, friends name, etc. for a password. Change your password frequently at least once in 2 or 3 weeks.
- Backup Your Data Always keep copies of your personal data in CDs, pendrive, etc. This may be helpful in a loss of data situation.
• Answer any 3 out of the given 5 questions in 50-80 words each. [4 × 3 = 12 Marks]
Question 17.
Rita is working in spreadsheet. She wants to know about the use of the following terms: [4]
(a) Quicksort
(b) Filtering Data
Answer:
(a) Quick Sort is especially useful when you add new information to a spreadsheet. When a spreadsheet is long, it is usually easier to add new information at the bottom of the sheet, rather than adding it in its correct place. After you have added information, you can sort the records to update the spreadsheet and put the information in its correct place in quick sort.
(b) When a sheet contains a large amount of data, it can be difficult to find information quickly. In that case, Filters can be used to narrow down the data in your worksheet, allowing you to view only the information you need. In other words Filters help you to ask questions to your data and retrieve only the relevant information filtering away the un-desirable data.
Question 18.
Riddhima wants to know about mailing labels in word processor. Help her to find the answers of the given questions. [4]
(a) What is a mailing label?
(b) What are the ways to prepare and print mailing labels?
Answer:
(a) Mailing labels are usually pieces of paper with adhesive on the back that can be affixed to packages or envelopes to identify the name and address of a recipient. They may also indicate the name and address of the person sending the mail. Mailing labels are extremely useful and time saving for the people who must send out a large volume of mail,
(b) Mailing labels can be created in two ways:
- Printing multiple copies of a single label
- Printing address lists where each label contains a different address
Question 19.
Consider the following table PRODUCT [4]
| S_NO | P_Name | S_Name | Qty | Cost | City |
| S1 | Biscuit | Priyagold | 120 | 12.00 | Delhi |
| S2 | Bread | Britannia | 200 | 25.00 | Mumbai |
| S3 | Chocolate | Cadbury | 350 | 40.00 | Mumbai |
| S4 | Sauce | Kissan | 400 | 45.00 | Chennai |
(i) How many fields and records are there in PRODUCT table?
(ii) Write SQL queries for the following:
(a) Display all Products whose Qty is between 100 and 400.
(b) Display S_Name, P Name, Cost for all the Products whose Qty is less than 300.
(c) Display all the records alphabetically by S_Name.
Answer:
(i) There are 6 fields and 4 records in the table PRODUCT.
(ii) (a) SELECT* FROM PRODUCT WHERE Qty BETWEEN 100 AND 400;
(b) ELECT S _Name, P _Name, Cost FROM PRODUCT WHERE Qty <300;
(c) SELECT * FROM PRODUCT ORDER BY S_Name;
Question 20.
Shubham is learning about DBMS. He wants to know about the following: [4]
(a) The purpose of DBMS
(b) Any two uses of DBMS
Answer:
(a) DBMS (Database Management System) is used to store logically related information at a centralised location. It facilitates data sharing among all the applications requiring it.
(b) Two uses of database management system are as follows :
(i) DBMS is used to store data at a centralised location.
(ii) It is used to minimise data redundancy and data inconsistency.
Question 21.
Rahul has purchased some stationary items from an online site. He has to make online payment for the items to complete the transaction. Help him by answering the following queries : [4]
(i) Suggest any two options that he can use to make payment of his bill on the online shopping website.
(ii) Name any 2 situations where online shopping could be useful.
(iii) Name any 2 popular online shopping websites.
(iv) Write full form of COD in reference to online shopping.
Answer:
(i) Credit, debit card or by Internet banking, etc are the options that he can use to make payment of his bill on the online shopping website.
(ii) (a) They offer huge discount on goods and services.
(b) Online shopping saves time and efforts in order to buy product of one’s choice.
(iii) Flipkart, Amazon are two popular online shopping websites.
(iv) COD stands for Cash On Delivery. Cash on delivery is the sale of goods by mail order where payment is made at the time of delivery rather than in advance.