Practicing the CBSE Sample Papers for Class 10 Information Technology Set 8 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 8 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) Which of the following is the person or organisation to whom a message is sent to? [1]
(a) Sender
(b) Receiver
(c) Message
(d) None of these
Answer:
(b) Receiver
(ii) Which term refers to our knowledge and understanding of ourselves? [1]
(a) Self-awareness
(b) Motivation
(c) Both (a) and (b)
(d) None of these
Answer:
(a) Self-awareness
(iii) The _____ operating system was developed by Nokia for certain models of smartphones. [1]
(a) Android
(b) iOS
(c) Symbian
(d) BOSS
Answer:
(c) Symbian
(iv) …………….. shortcut key is used to add new slides in presentation. [1]
(a) Alt+M
(b) Ctrl+M
(c) Ctrl-1- N
(d) None of these
Answer:
(b) Ctrl + M
(v) ……….. is a set of activities performed by the entrepreneur. [1]
(a) Leadership
(b) Risk taking
(c) Entrepreneurship
(d) None of these
Answer:
(c) Entrepreneurship
(vi) The government should make policies against ………….. activities. [1]
(a) illegal
(b) legal
(c) Both (a) and (b)
(d) None of these
Answer:
(a) illegal
Question 2.
Answer any 5 out of the given 6 questions [1 x 5 = 5 Marks]
(i) A …………… is a temporary connection that uses the Public Switched Telephone Network (PSTN) to connect to the Internet. [1]
(a) broadband connection
(b) wireless connection
(c) dial-up connection
(d) None of these
Answer:
(c) dial-up connection
(ii) The small area network created around a bluetooth device is called …………. [1]
(a) LAN
(b) PAN
(c) WAN
(d) MAN
Answer:
(b) PAN
(iii) The ………… SQL statement is used to make a query or retrieve data from a table in a database.
(a) INSERT
(b) UPDATE
(c) SELECT
(d) REVIEW
Answer:
(c) SELECT
(iv) Which of the following allows you to reorder data? [1]
(a) Sorting
(b) Filtering
(c) Scenario
(d) Custom sorting
Answer:
(a) Sorting
(v) Which of the following is not an AutoShape?
(a) Line
(b) Circle
(c) Curve
(d) ClipArt
Answer:
(d) ClipArt
(vi) ………… is an inquiry into the database made using the SELECT statement.
(a) Query
(b) Data
(c) Equation
(d) None of these
Answer:
(a) Query
Question 3.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Editing Custom Shapes feature allows of small segments of a drawing. [1]
(a) shaping
(b) reshaping
(c) rehearse
(d) None of these
Answer:
(b) reshaping
(ii) DBMS is a program, that controls the creation, maintenance and use of a database. Here, DBMS stands for [1]
(a) Digital Base Management System
(b) Data Build Management System
(c) Database Management System
(d) Database Management Service
Answer:
(c) Database Management System
(iii) A filters data traffic at a network boundary. [1]
(a) bridge
(b) switch
(c) gateway
(d) hub
Answer:
(a) bridge
(iv) Template includes a text space that is surrounded by brackets. It is called a ……………. [1]
(a) margin
(b) placeholder
(c) data source
(d) track changes
Answer:
(b) placeholder
(v) Key field is a unique identifier for each record. It is defined in the form of …………. [1]
(a) rows
(b) columns
(c) tree
(d) query
Answer:
(b) columns
(vi) What is the name given to a combination of two cell references? [1]
(a) Relative reference
(b) Absolute reference
(c) Mixed reference
(d) None of these
Answer:
(c) Mixed reference
Question 4.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Which of the following is an application program that is stored on a remote server and delivered over the Internet? [1]
(a) Web application
(b) System application
(c) Internet application
(d) None of these
Answer:
(a) Web application
(ii) A …………….. is a document model that you use to create other documents. [1]
(a) Anchoring
(b) Alignment
(c) Template
(d) None of these
Answer:
(c) Template
(iii) l:l, l:n and n:l are examples of different types of …………. [1]
(a) Relations
(b) Databases
(c) Data
(d) Query
Answer:
(a) Relations
(iv) In packet based networks, the message gets broken into small …………. [1]
(a) data packets
(b) data frame
(c) chunk
(d) None of these
Answer:
(a) data packets
(v) Shubham wants to know the name of the function which is used to find the maximum number among the different values. Solve his query. [1]
(a) MAX( )
(b) MAXIMISE( )
(c) MAXIMUM ( )
(d) GREATER ( )
Answer:
(a) MAX( )
(vi) Which of the following allows you to display the specific data? [1]
(a) Arranging
(b) Filtering
(c) Scenario
(d) Custom sorting
Answer:
(b) Filtering
Question 5.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Which of the following is a single piece of data?
(a) Field
(b) Table
(c) Record
(d) Form
Answer:
(a) Field
(ii) URL is the …………. for a website or a web page.
(a) web address
(b) website
(c) web page
(d) Both (a) and (c)
Answer:
(a) web address
(iii) Rajiv has created an employee table and made Emp No, as the primary key, so that it can accept only unique values for each record. At the same time, he wants to have one more field that can behave like a primary key. Which of the following types of key can serve the purpose? [1]
(a) Foreign key
(b) Candidate key
(c) Unique key
(d) None of these
Answer:
(b) Candidate key
(iv) ………….. is used to define the structure of your tables and other objects in the database.
(a) DDL
(b) DML
(c) DCL
(d) None of these
Answer:
(a) DDL
(v) Suraj wants to know the sequence of steps used to open the Templates dialog. Answer to his query. [1]
(a) File> New> Text Document
(b) File> New> Templates
(c) Format> Group > Group
(d) None of these
Answer:
(b) File> New> Templates
(vi) A …………… is a series of computers linked together to form a network in a circumscribed location. [1]
(a) LAN
(b) MAN
(c) TAN
(d) WAN
Answer:
(a) LAN
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.
List the advantages of verbal communication. [2]
Answer:
Some advantages of verbal communication are as follows:
- It is quick in obtaining feedback once delivered.
- It saves time in communication.
- It is a more reliable method of communication.
- It is a cheaper way of communication and, hence saves money.
- It provides complete understanding of communication delivered and there is a chance to make it more clear in case of doubts in interpretation of words or ideas.
Question 7.
How meditation can help in managing stress?
Answer:
In meditation, we change from our normal active state to a more peaceful state. We go beyond the noisy thoughts in the mind and enter a state of restful alertness. During meditation, although we are in a state of deep rest, our mind is fully alert and awake.
At this time, the body experiences many healing effects which are the reverse of the ‘fight-or-flight’ response, such as decreased heart rate, normalisation of blood pressure, deeper breathing, reduced production of stress hormones, higher immunity, more efficient use of oxygen by the body and reduced inflammation.
Question 8.
Write the steps to protect the workbook with password. [2]
Answer:
Protection of a Sheet To write-protect all of the cells of a sheet, you have to do the following:
- Select Tools-Protect Document from the Menu Bar, if you choose Sheet, only your current sheet will be protected from writing,
- If you choose Document, your whole document (workbook) will be protected.
- You are not obliged to enter a password, you can simply click on the OK button to close the dialog window without typing anything.
- However, if you choose a password, it will be requested every time you wish to modify the cells or the sheet.
- To eliminate the protection, choose Tools-Protect Document again and deselect the Sheet or Document option, eventually typing the password you have set, when requested.
Question 9.
How entrepreneur is helpful in capital formation? [2]
Answer:
An entrepreneur is helpful in capital formation as we know that increase in the rate of capital formation is quite essential for the economic development of any country. Those nations which are not able to increase the rate of capital formation or does it nominally remain backward from industrial development’s point of view.
Question 10.
How sustainable development is important to develop the positive attitude? [2]
Answer:
Sustainable development brings about changes in people’s knowledge, attitude and skills. It awares people about the responsibility to use and preserve natural resources. It creates the feeling that natural resources are the common property of all and nobody can use the property according to his personal will. It helps to conserve natural and social environment.
Answer any 4 out of the given 6 questions in 20-30 words each. [2 × 4 = 8 Marks]
Question 11.
What is the use of grouping objects in a word processor application? [2]
Answer:
Grouping drawing objects makes it easier to handle serveral objects as a single entity, while preserving their relative sizes and positions. When objects are grouped, any editing operations carried out on that group are pllied to all members of the group. If you click on one member of the group, the whole group is selected.
Question 12.
Write the steps for text-fitting in Word document. [2]
Answer:
There are several text fitting/wrapping options in Open Office Writer.
On the main menu, click Format> Wrap. The Wrap menu options provide several possibilities:
- Alternate paragraphs and graphics, maintaining a separation between them (Wrap Off).
- Wrap text around the graphics (Page Wrap or Optimal Page Wrap).
- Put a semi-transparent graphic over the text (Wrap Through).
- Add a graphic in the background (In Background).
Often you need to insert graphics with no text around them. To set the position of an image to the Wrap Off format, follow the following steps:
(i) Select a graphic by clicking on it.
(ii) Right-click to display the context menu and move the mouse pointer to Wrap to display the various wrap modes.
(iii) Select No Wrap.
(iv) When formatting some documents, such as newsletters, you may want to put photos mixed with text or just want to
(v) When an image is inserted with the Page Wrap option, you can move it anywhere on the page. The text will be automatically adjusted around the image, like water around a sailing boat.
(vi) The Optimal Page Wrap option is similar to Page Wrap, but it maintains the text positioned beside the image. The position is decided automatically in order to optimize the relative position between text and image. The Wrap Through option lets you also insert an image overlapping the text. In this case, some part of the text will be hidden, unless you change the transparency of the image.
Question 13.
What is the use of Scenario tool? [2]
Answer:
A Scenario is a set of values that Calc saves for a group of cells. Whenever we run a scenario, Calc automatically substitutes the saved cell values into a connected formula to give us an output. By having different scenarios for a same group of cells we can get different results from the formula and compare these results to know which is the most suitable set of values for us.
Question14.
Define data, the major component of a database. [2]
Answer:
Data is raw numbers, characters or facts represented by a value. Most of the organisations generate, store and process large amounts of data. The data acts as a bridge between the hardware and the software. Data may be of different types such as User data, Metadata and Application Metadata.
Question 15.
Name any two ways of wireless connections of Internet. Ramya wants to connect all the computers of her office wirelessly in order to avoid uncoordinated cables. Which wireless technology would be best suitable for her office? [2]
Answer:
Wi-Fi and WiMax are the two ways of wireless connections of Internet. Wi-Fi technology would be best suitable for her office to avoid cabling. Because, it allows high speed Internet connections without the use of cables or wires.
Question 16.
What are the benefits of online shopping? [2]
Answer:
Some benefits of online shopping are as follows:
- Online shopping is very convenient. You can get products at home.
- Online shopping websites provide million of choices of product.
- They offer huge discounts on goods and services.
- Online shops give us the opportunity to shop 24 × 7 and also reward us with cashback.
- Sending gifts to relatives and friends is easy by online shop.
Answer any 3 out of the given 5 questions in 50-80 words each. [4 × 3 = 12 Marks]
Question 17.
What is sorting? How to use ascending or descending sort which depends on one column? [4]
Answer:
Sorting is a common spreadsheet task that allows user to easily re-order the data. The most common type of sorting is alphabetical ordering which you can do in ascending or descending order.
To use ascending or descending sort which depends on one column, follow the given steps: Highlight the cells to be sorted, then select Data > Sort to open the Sort dialog, or click the Sort Ascending or Sort Descending toolbar buttons. Using the dialog, you can sort the selected cells using up to three columns, in either ascending (A-Z, 1-9) or descending (Z-A, 9-1) order.
Question 18.
Shaurya had already created a paragraph style. Now, he wants to delete it. What are the steps required to delete the created style? [4]
Answer:
To delete the unwanted style, Shaurya has to right-click on it in the Styles and Formatting window and choose Delete on the pop-up menu.He has to confirm deleting the style by choosing yes on the pop-up.
Question 19.
Consider the following table: Employee [4]
| Emp_no | E_name | Profile | Manager | Hire_date | Salary | Commission | Dept_no |
| 8369 | SMITH | CLERK | 8902 | 1990-12-18 | 8000 | NULL | 20 |
| 8499 | ANYA | SALESMAN | 8698 | 1991-02-20 | 16000 | 300.00 | 30 |
| 8521 | ‘SETH | SALESMAN | 8698 | 1991-02-22 | 12500 | 500.00 | 30 |
| 8566 | MAHADEVAN | MANAGER | 8839 | 1991-04-02 | 29850 | NULL | 20 |
| 8654 | MOMIN | SALESMAN | 8698 | 1991-09-28 | 12500 | 1400.00 | 30 |
| 8698 | BINA | MANAGER | 8839 | 1991-05-01 | 28500 | NULL | 30 |
(a) How many fields and records are there in the table Employee?
(b) Write the SQL queries for the following:
(i) Display E name and Salary of those employees whose Salary is greater than or equal to 22000.
(ii) Display details of employees those are not getting Commission.
(iii) Display all the details of the employee profile ‘SALESMAN’.
Answer:
(a) There are 8 fields and 6 records in the table Employee.
(b) (i) SELECT Ename, Salary FROM Employee WHERE Salary> = 22000;
(ii) SELECT* FROM Employee WHERE Commission IS NULL;
(iii) SELECT *FROM EMPLOYEE WHERE Profile=”SALESMAN’;
Question 20.
Define the following types of integrity : [4]
(i) Entity integrity
(ii) Domain integrity
(iii) Referential integrity
(iv) User defined integrity
Answer:
(i) Entity Integrity It defines the primary key of a table. Entity integrity rule on a column does not allow duplicate and null values.
(ii) Domain Integrity It defines the type, range and format of data allowed in a column. Domain integrity states that all values in a column must be of same type.
(iii) Referential Integrity It defines the foreign key concepts. Referential integrity ensures that data in related tables remains accurate and consistent before and after changes.
(iv) User Defined Integrity If there are some business requirements which do not fit any above data integrity then user can create own integrity, which is called user defined integrity.
Question 21.
Pinky had heard about the words types of networks. She had some doubts. Answer to her queries to clear her doubts. [4]
(i) What is PAN?
(ii) Define the term WAN.
(iii) Define the term MAN.
(iv) Write a disadvantage of both LAN and WAN.
Answer:
(i) A Personal Area Network (PAN) is a computer network for interconnecting electronic devices within an individual person’s workspace.
(ii) A Wide Area Network (WAN) is the one which covers a broad area. It consists of two or more local area networks. A WAN is used by government organisations and businesses.
(iii) A Metropolitan Area Network (MAN) is a computer network in which two or more computers which are geographically distributed but in the same metropolitan city are connected. Its geographic scope falls between a WAN and LAN.
(iv) Disadvantage of LAN: Even though LAN saves a lot of money in terms of resource sharing, the initial cost involved in setting up the network is quite high.
Disadvantage of WAN: It is difficult to maintain the WAN network. It requires skilled technicians and network administrators.