Practicing the CBSE Sample Papers for Class 10 Information Technology Set 7 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 7 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 can make the communication difficult to be understood? [1]
(a) Entrepreneur
(b) Noise
(c) Feedback
(d) Planning
Answer:
(b) Noise
(ii) Which term means walking in the local park or a similar activity?
(a) Nature walk
(b) Motivation
(c) Regulation
(d) None of these
Answer:
(a) Nature walk
(iii) ……………. basically helps in arrangement of data in the correct order.
(a) Filtering
(b) Copying
(c) Sorting
(d) Pasting
Answer:
(c) Sorting
(iv) A/An ……………… creates new needs and new means to satisfy them.
(a) leadership
(b) innovation
(c) entrepreneur
(d) None of these
Answer:
(c) entrepreneur
(v) An entrepreneur has become the ……………. of modem global economy.
(a) balancing wheel
(b) goal-oriented
(c) optimistic
(d) None of these
Answer:
(a) balancing wheel
(vi) Sustainable development minimises the …………… of natural resources.
(a) personal attitude
(b) depletion
(c) diversity
(d) resources
Answer:
(b) depletion
Question 2.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) ……….. is a form of electronic commerce where customers can buy or sell goods over the Internet. [1]
(a) Online shopping
(b) E-Reservation
(c) Email
(d) E-banking
Answer:
(a) Online shopping
(ii) Facilities offered by databases are [1]
(a) the ability to store a large amount of data in a structured format, easy update, sort query, production of reports.
(b) easy edition, spell check, perform calculations, library of mathematical functions, replication.
(c) the ability to rotate images, copy and paste, fill scale.
(d) None of the above
Answer:
(a) the ability to store a large amount of data in a structured format, easy update, sort query, production of reports.
(iii) Computer based record keeping system is known as [1]
(a) Data Manipulation System
(b) Computerised Data System
(c) Computerised Record Keeping System
(d) DBMS
Answer:
(d) DBMS
(iv) Which of the following is a spreadsheet software? [1]
(a) Lotus 1-2-3
(b) VisiCalc
(c) Both ‘a’ and ‘b’
(d) None of these
Answer:
(c) Both ‘a’ and ‘b’
(v) A template is a model that you use to create …………. [1]
(a) images
(b) other documents
(c) design
(d) DBMS
Answer:
(b) other documents
(vi) Database servers are referred to as [1]
(a) front-ends
(b) back-ends
(c) clients
(d) model
Answer:
(b) back-ends
Question 3.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(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) A computer ………… controls access between networks. [1]
(a) Firewall
(b) Virus
(c) Spyware
(d) Antivirus
Answer:
(a) Firewall
(ii) In a document, is used to apply a style to many different areas quickly without having to go back to the Styles and Formatting window and double click every time. [1]
(a) Fill format mode
(b) Formatting window
(c) Painter mode
(d) Text wrapping
Answer:
(a) Fill format mode
(iii) When you define a field for a table, are the names given to column in a table. [1]
(a) Field Name
(b) Field Size
(c) Data Type
(d) Description
Answer:
(a) Field Name
(iv) ……………… program(s) also offer real-time protection monitoring your computer for any changes by malware software. [1]
(a) Antivirus
(b) Antispyware
(c) Both (a) and (b)
(d) None of these
Answer:
(c) Both (a) and (b)
(v) The ……………… feature creates a summarized outline of data in a worksheet. [1]
(a) Subtotal
(b) Solver
(c) Goal Seek
(d) Scenario
Answer:
(a) Subtotal
(vi) Raj has created a worksheet where he has added all the information of his employees. He wants every employee to go through the worksheet and update their address and phone number, if required. He also would like to know the changes done by his employees. Which feature of spreadsheet he should enable to see the changes made by his employees? [1]
(a) Macro
(b) Link workbook
(c) Change worksheet
(d) Track changes
Answer:
(d) Track changes
Question 5.
Answer any 5 out of the given 6 questions [ 1 × 5 = 5 Marks]
(i) Which of the following commands is not a Data manipulation language?
(a) Select
(b) Insert
(c) Update
(d) Alter
Answer:
(d) Alter
(ii) The action of sharing your opinions contents on a blog is termed as
(a) Blogger
(b) Blogging
(c) Tweeting
(d) Commenting
Answer:
(b) Blogging
(iii) Which data type helps you to handle an input column that is in boolean format?
(a) OLE Object
(b) Attachment
(c) Yes/No
(d) None of these
Answer:
(c) Yes/No
(iv) If you are continually working with the same range, then you may give a name to the range using …………. option under Data Menu. [1]
(a) Define data
(b) Define range
(c) Define reference
(d) Define address
Answer:
(b) Define range
(v) In a document, ……….. refers to the vertical or horizontal placement of a graphic in relation to the chosen anchor point. [1]
(a) arrangement
(b) alignment
(c) identation
(d) margin
Answer:
(b) alignment
(vi) A ……………. is a location or a place of employment, where someone works to earn his living.
(a) Workplace
(b) Home
(c) Society
(d) Industry
Answer:
(a) Workplace
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.
Write the advantages of non-verbal communication. [2]
Answer:
Following are the advantages of non-verbal communication:
- It conveys clear and precise meaning to the receiver.
- It is presentable through visuals, audio-visual and silent means.
- This type of communication serves as a substitute for verbal communication.
- It is helpful in communicating with illiterate people.
- It is attractive in nature as pictures, graphs etc. attract everybody’s attention.
- It is very impactful as visuals greatly affect minds of people.
Question 7.
What do you mean by internal stress? [2]
Answer:
Internal stress generates within the humans regarding unreasonable matters. This internal stress is one of the most important kinds of stress to understand and manage because it keeps on building up as time passes. For example, some people become used to the kind of hurried, tense, lifestyle of persons living in large cities.
They even look for stressful situations and feel stress about matters which may not be stressful at all. This stress affects our work performance adversely. Internal stress is a result of unexpressed worries.
Question 8.
What are the facilities provided by operating system? [2]
Answer:
The facilities provided by operating system are:
- Easy interaction between humans and computers.
- Starting computer automatically when power is turned on.
- Loading and scheduling users’ programs along with necessary compilers.
- Controlling Input and Output.
Question 9.
Explain innovativeness as a quality of 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 combination of innovation for example, a new product delivered in a new way with a new message.
Question 10.
Give the short term solutions for sustainable development. [2]
Answer:
Short term solutions for sustainable development are:
- Illegal deforestation and smuggling of forest resources should be stopped.
- Proper balance ought to be maintained between deforestation and afforestation.
- Planning and building of industrial zones to manage and process are types of wastes.
Answer any 4 out of the given 6 questions in 20-30 words each. [2 × 4 = 8 Marks]
Question 11.
Explain the role of template in word processor? [2]
Answer:
In word processor, templates are a special type of document that can hold text, styles, macros, keyboard shortcuts, custom toolbars, QAT and ribbon modifications and building blocks including Auto Text entries.
Question 12.
What is the difference between a workbook and a worksheet? [2]
Answer:
Differences between workbook and worksheet are as follows:
| Workbook | Worksheet |
| A workbook is an Excel file with one or more worksheets | A worksheet is a single spreadsheet of data. |
| A workbook would be the entire binder, with everything in it. | A worksheet would be like one section in that binder. |
Question 13.
Write down the significance of electronic spreadsheets. [2]
Answer:
Using electronic spreadsheets, large volume of data can be stored in worksheets. Worksheets can be managed, edited, viewed, retrieved and printed easily in desired format. Electronic spreadsheets support charts, which represent data pictorically.
Question 14.
When is Memo data type is preferred over Text data type for a field? [2]
Answer:
Text data type is not capable to store the project description because its length cannot be more than 255 characters so. Memo data type is preferred over Text data type.
Question 15.
Write the steps to create a form using split form command. [2]
Answer:
To create a form using a Split Form command, follow the given steps:
- Step 1 First, select the table for which you want to create a form.
- Step 2 Click the Create tab in the ribbon.
- Step 3 Select Split Form option from the Forms group.
After this, form will be shown in the upper part and lower part will show the datasheet view.
Question 16.
Define router as network device. [2]
Answer:
Router is a network device designed to take incoming packets, analyse the packets, move the packets to another network, convert the packets to another network interface, diop the packets, direct packets to the appropriate locations, etc. A router functions similar to a bridge. However, unlike a bridge, a router passes data packets from one network to another network based on their IP addresses not MAC addresses.
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.
Write one example of each field for which you would use
(i) Text data type
(ii) Memo data type
Answer:
(i) Text data type It allows to store text or combination of text and numbers as well as numbers that don’t require calculations such as phone number. This data type allows maximum 255 characters to store, e.g. If Employee is a table and EmpJNo, Name and Description are fields, then name will be a Text field. Because, Name is a character entry field.
(ii) Memo data type It allows long blocks of text that uses text formatting, e.g. In the Employee table, the field Description will be of Memo data type, because the length of uescription of employee may be large.
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 less than or equal to 16000.
(ii) Display details of employees who are getting commission of? 300 or greater.
(iii) Display all the details of the employee profile ‘CLERK’.
Answer:
(a) There are 8 fields and 6 records in the table Employee.
(b) (i) SELECT E_name, Salary FROM Employee
WHERE Salary < = 16000;
(ii) SELECT* FROM Employee WHERE Commission >= 300;
(iii) SELECT *FROM EMPLOYEE WHERE Profile=”CLERK’;
Question 20.
Ajay is learning about the different terms and commands of a database. He came across the following terms . Tell him the definition of the following [4]
(i) Insert command
(ii) Select command
(iii) Delete command
(iv) DCL command
Answer:
(i) Insert Command It is used to add a single record or multiple records into a table.
Syntax
Insert into <table_name> (coll, col2) values (vail, val2);
(ii) Select Command It is used to query or retrieve data from a table in the database.
Syntax
Select column_list from table_name;
(iii) Delete Command To discard unwanted data from a database, the delete command is used.
Syntax
Delete from <table_name> WHERE <conditior ;
(iv) DCL Command These commands are used to assign security levels in database which involves multiple user setups. They are used to grant defined role and access privileges to the users.
Question 21.
Sonia had heard about the various types of ISPs. She had some doubts. Answer to 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 satellite?
Answer:
(a) An Internet Service Provider (ISP) is an organisation which 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 the 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 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.