Practicing the CBSE Sample Papers for Class 10 Information Technology Set 4 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 4 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) …………… is the means by which a message is sent between devices. [1]
(a) Data
(b) Channel
(c) Receiver
(d) None of these
Answer:
(b) Channel
(ii) ………….. stree is a result of body’s response to deal with a dangerous situation or escape from it. [1]
(a) Internal
(b) Environmental
(c) External
(d) Survival
Answer:
(d) Survival
(iii) An operating system that manages a group of independent computers and makes them appear to be a single computer is known as a …………. operating system. [1]
(a) real-time
(b) Graphical
(c) distributed
(d) Multi-user
Answer:
(c) distributed
(iv) An entrepreneur must form contacts with the …………. to analyse the market. [1]
(a) Planning
(b) Competitors
(c) neighbours
(d) None of these
Answer:
(b) Competitors
(v) ………….. brings about changes in people’s knowledge, attitude and skills. [1]
(a) Sustainable development
(b) Natural resources
(c) Both (a) and (b)
(d) None of these
Answer:
(a) Sustainable development
(vi) …………….. plays a major role in reaction to stress. [1]
(a) Personality
(b) Positive attitude
(c) Behaviour
(d) None of these
Answer:
(a) Personality
Question 2.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Which client software is used to request and display web pages? [1]
(a) Web server
(b) FTP
(c) Multimedia
(d) Web browser
Answer:
(d) Web browser
(ii) The default data type for a field is …………. [1]
(a) char
(b) int
(c) text
(d) None of these
Answer:
(c) text
(iii) Alpana has made four spreadsheets containing marks of 5 subjects of all the students of her class. She has to prepare a sheet that contains the total marks of all the students of her class. Name the option that can be used to perform this task. [1]
(a) Subtotal
(b) Average
(c) Goal Seek
(d) Scenario
Answer:
(a) Subtotal
(iv) Field is the individual sub component of one …………. [1]
(a) record
(b) column
(c) data
(d) None of these
Answer:
(a) record
(v) In the Mail Merge dialog box, you can select the …………. option if you want to save the merged documents. [1]
(a) File
(b) Edit
(c) View
(d) Format
Answer:
(a) File
(vi) You create a table in MS-Access. You decided to create two fields RollNo and Date of Birth, what will be the data type of Date-of-Birth column? [1]
(a) Number
(b) Yes/No
(c) Text
(d) Date/Time
Answer:
(d) Date/Time
Question 3.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Prerna is a student of class X. Her teacher has asked her to create a document on ‘Women Empowerment’. She has written the text and also added relevant images in her document using Writer. But she has realised that the paragraph will look better if the images are placed around the text. Name the feature of writer she can use to get the desired result.
(a) Placing image
(b) Positioning image
(c) Wrap text
(d) Closing text
Answer:
(c) Wrap text
(ii) Linked data is stored in the …………… [1]
(a) destination file
(b) web file
(c) source file
(d) domain file
Answer:
(c) source file
(iii) Internet is a network of ………….. [1]
(a) networks
(b) data
(c) value
(d) pages
Answer:
(a) networks
(iv) The grey colour in the TOC reminds us that the text has been generated ………… [1]
(a) manually
(b) automatically
(c) Both (a) and (b)
(d) None of these
Answer:
(b) automatically
(v) ……….. is used in between the cell reference in a formula. [1]
(a):
(b),
(c) Both (a) and (b)
(d) @
Answer:
(c) Both (a) and (b)
(vi) Internally for each recorded macro, some code is generated, which is stored inside …………… and ………. clause. [1]
(a) Sub, End Sub
(b) Section, End Section
(c) Function, End Function
(d) None of these
Answer:
(a) Sub, End Sub
Question 4.
Answer any 5 out of the given 6 questions [ 1 × 5 = 5 Marks]
(i) The first network ever developed was ………….
(a) ARPANET
(b) Internet
(c) NSFnet
(d) NET
Answer:
(a) ARPANET
(ii) Prashant is a writer. He has just completed writing his book using Writer software. Now, he wants to add a page which will contain the title of each chapter and its respective page number. Suggest the feature that can be used to do this task. [1]
(a) Mail merge
(b) Templates
(c) Styles
(d) Table of contents
Answer:
(d) Table of contents
(iii) …………. is the blank space between the worksheet data and the edges of the printed page. [1]
(a) Field space
(b) Data space
(c) Margins
(d) Description box
Answer:
(c) Margins
(iv) A/An ………. that identifies a specific computer on the Internet. [1]
(a) username
(b) domain name
(c) E-mail
(d) None of these
Answer:
(b) domain name
(v) Satellites which are orbiting around the ………….. , provide necessary links for telephone and television service. [1]
(a) space
(b) Earth
(c) station
(d) All of these
Answer:
(b) Earth
(vi) Template includes …………… text that is surrounded by brackets. [1]
(a) margin
(b) placeholder
(c) data source
(d) track changes
Answer:
(b) placeholder
Question 5.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Duplication of data is known as ……………… [1]
(a) data security
(b) data incomplete
(c) data redundancy
(d) None of these
Answer:
(c) data redundancy
(ii) The term …………. is derived from the words interconnection and networks. [1]
(a) connection
(b) Internet
(c) Both (a) and (b)
(d) None of these
Answer:
(b) Internet
(iii) To create a hyperlink to a webpage, FTP server of Telnet connection, click on the ………….. icon. [1]
(a) internet explorer
(b) Internet
(c) hyperlink
(d) document
Answer:
(b) Internet
(iv) In www, a client is called ……………….
(a) web server
(b) web page
(c) web browser
(d) None of these
Answer:
(c) web browser
(v) Priya, Ravi and Suresh are working in the accounts department of an advertising company. They handle different set of clients. Now they are collaborating to create a spreadsheet for maintaining records of all their clients combined together. Which option should they use so that they all can work simultaneously in the sheet? [1]
(a) Add document
(b) Share document
(c) Combine document
(d) None of these
Answer:
(b) Share document
(vi) A router passes data packets from one network to another network based on their …………. not MAC address. [1]
(a) IP address
(b) URL
(c) Web address
(d) None of these
Answer:
(a) IP address
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 do you mean by verbal communication? [2]
Answer:
Verbal communication means communication through spoken oral and written words. It implies use of words which make up a language. It is the ability to communicate using words in understandable language i.e. English, Hindi, French, Urdu etc. Language play a significant role in verbal communication. The effectiveness of the verbal communication depends on the tone of the speaker, clarity of speech, volume, speed, body language and the quality of words used in conversation.
Question 7.
Explain the term fatigue related stress. [2]
Answer:
Fatigue related kind of stress builds up over a long time like by working too long or too hard at our job, school or home. It can also be caused by exercising too much or too long. If you do not know how to manage your time well or how to take time out for rest and relaxation, you will become a victim of fatigue related stress. This can be one of the hardest kinds of stresses to avoid because many people feel that it is out of their control.
Question 8.
What are the responsibilities of an operating system with respect to file management? [2]
Answer:
The operating system is responsible for the following activities in connection with file management: .
- Allocating and deallocating memory space as needed.
- Creating and deleting files.
- Creating and deleting directories to organise files.
- Supporting primitives for manipulating files and directories.
- Mapping files onto secondary storage.
- Backing up files on stable (non-volatile) storage media.
Question 9.
What are the disadvantages of entrepreneurship? [2]
Answer:
Some of the disadvantages of entrepreneurship are as follows:
- Huge Amount of Time You have to dedicate a huge amount of time to your own business. Entrepreneurship is not easy and for it to be successful, you have to take a level of time commitment.
- Risk An entrepreneurship involves high risk of loss. If the business fails then it will wipe away all the personal savings.
- Hard Work An entrepreneur has to work very hard to make the new business very successful.
- Uncertain Income There is no regular or fixed income available to an entrepreneur. So, there is uncertain kind of income received by an entrepreneur.
Question 10.
Describe any two problems related to sustainable development. [2]
Answer:
Two problems related to sustainable development are as follows:
1. Poor management of natural resources combined with growing economic activities will continue to pose serious challenges to environment.
2. The most significant environmental problems are associated with resources that are renewable such as air and water. They have finite capacity to assimilate emissions and wastes but if pollution exceeds this capacity, ecosystem can deteriorate rapidly.
Answer any 4 out of the given 6 questions in 20-30 words each. [2 × 4 = 8 Marks]
Question 11.
What is Mail Merge? [2]
Answer:
Mail Merge is a very important feature of word processor. It is used to create a series of documents with same text and multiple addresses. In the process of mail merge we merge a main document (a letter or certificate etc.) with different mailing addresses to create several copies of the main document bearing addresses of different individuals. Mail merge is generally used to send invitations, letters or to print certificates for several people.
Question 12.
What is a macro? [2]
Answer:
A macro is a saved sequence of commands or keystrokes that are stored for later use. An example of a simple macro is one that “types” your address. The Libre Office macro language is very flexible, allowing automation of both simple and complex tasks. Macros are especially useful to repeat a task the same way over and over again.
Question 13.
What is the role of key fields in a database? Name the keys in a DBMS. [2]
Answer:
The key is defined as the column or the set of columns of the database table which is used to identify each record uniquely in a relation. If a table has id, name and address as the column names then each one is known as the key for that table. The key field is a unique identifier for each record. Alternate, foreign, primary and candidate are a few types of keys in a DBMS.
Question 14.
How does a router help in maintaining a network ? [2]
Answer:
A hardware device designed to take incoming packets, analyse the packets, move the packets to another network, convert the packets to another network interface, drop 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.
Question 15.
Define the following terms: [2]
(i) Active Cell
(ii) Sheet Tab
Answer:
(i) Active Cell The cell with the black outline in a spreadsheet Data is always entered into the active cell.
(ii) Sheet Tab The tab at the bottom of a worksheet tells you the name of the worksheet such as Sheet 1, Sheet 2 etc. Switching between worksheets can be done by clicking on the tab of the Sheet which you want to access.
Question 16.
How can a document’s style be changed ? Explain with proper steps. [2]
Answer:
Changing a style using the Style dialog box To change an existing style using the Style dialog, right-click on the required style in the Styles and Formatting window and select Modify from the pop-up menu.
The Style dialog displayed depends on the type of style selected. Each style dialog has several tabs. See the chapters on styles in the user guides for details.
To update a style from a selection:
Step 1 Open the Styles and Formatting dialog.
Step 2 In the document, select an item that has the format you want to adopt as a style.
Step 3 In the Styles and Formatting dialog, select the style you want to update (single-click, not double-click), then
long-click on the arrow next to the New Style from Selection icon and click on Update Style. AutoUpdate applies to paragraph and frame styles only. If the AutoUpdate option is selected on the Organizer £>age of the Paragraph Style or Frame Style dialog, applying direct formatting to a paragraph or frame using this style in your document automatically updates the style itself. You can also update styles by copying or loading them from a template or another document
Answer any 3 out of the given 5 questions in 50-80 words each. [4 × 3 = 12 Marks]
Question 17.
Ishita is a teacher. She had entered the marks of all the students and also calculated the total of the students. Now, she wants to sort the data so that she can find the names of the students according to their marks in descending order. Tell her the different steps to sort the data. [4]
Answer:
Ishita can 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 the steps for text fitting inside a shape in a word processor document. Also, describe its options. [4]
Answer:
Assume you want to create some shapes which have text in them. Some of the text might wrap within the shape.To do this,you have to right-click and choose Text and go back to the Texty Tab and check the option Word wrap Text in Shape. In this way,the text gets wrapped inside a shape.You can also resize the shape to fit text. To format the text in a shape Select the object to which text was added. Select Format > Text or right-click on the shape and select Text from the pop-up menu. The Text dialog is displayed.
Question 19.
Consider the following table : Employee Salary. [4]
Table : EmployeeSalary
| LastName | FirstName | Dept | PayrollNumber | Salary (₹) | JobTitle |
| Shen | James | Finance | A621 | 19500 | Payroll Clerk |
| Gupta | Shruthi | Finance | M502 | 35000 | Accountant |
| Bedi | Reeta | Human Resource | M421 | 18500 | Secretary |
| Walker | Tia | Sales | W815 | 24000 | Sales Represen-tative |
| Shafia | Ahmed | Factory | H219 | 39000 | Factory Manager |
| Mittal | Chavi | Purchasing | M134 | 20000 | Purchasing Clerk |
(i) How many fields and records are there in the table Employee Salary
(ii) Write the SQL queries for the following:
(a) List all data of table EmployeeSalary.
(b) Display all the records whose salary is less than 25000.
(c) Display the FirstName and JobTitle of employees having Dept ‘Finance’.
Answer:
(i) There are 6 fields and 6 records in the table EmployeeSalary.
(ii) (a) SELECT * FROM EmployeeSalary;
(b) SELECT * FROM EmployeeSalary WHERE Salary<25000;
(c) SELECT FirstName, JobTitle FROM EmployeeSalary WHERE Dept=’Finance’;
Questions 20.
What do you mean by data control language? Also, give its types. [4]
Answer:
DCL (Data Control Language) commands are used to assign security levels in database which involves multiple user setups. They are used to grant defined roles and access privileges to the users. There are two kinds of user in the schema
Step 1 Users They work with the data, but cannot change the structure of the schema. They write data manipulation language.
Step 2 Admin They can change the structure of the schema and control access to the schema objects. They write data definition language.
Step 3 Basically, the DCL component of the SQL language is used to create privileges that allow to users access and manipulation of the database.
Two types of DCL commands are;
(i) GRANT Used to give user’s access privileges to database.
(ii) REVOKE Used to withdraw access privileges given with the GRANT command.
Question 21.
How to clear web history on the Mozilla Firefox browser? [4]
Answer:
Follow the steps below to clear the web history on the Mozilla Firefox browser:
Step 1 Click on the upper right of the browser toolbar.
Step 2 Click History.
Step 3 Click Clear Recent History.
Step 4 Click the drop-down menu next to Time range to clear and select everything.
Step 5 Place a checkmark next to the following options under Details:
Step 6 Browsing and Download History • Form and Search History • Cookies
Step 7 Cache • Active Logins • Offline Website Data
Step 8 Site Preferences
Step 9 Click on clear Now button.