Practicing the CBSE Sample Papers for Class 10 Information Technology Set 2 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 2 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) Smriti is a brilliant student. She studies well, has joined many extra-curricular activity groups, learns swimming etc. You can say that she has too much on her plate. What type of stress she might suffer from? [1]
(a) Survival stress
(b) Internal stress
(c) Fatigue related stress
(d) Environmental stress
Answer:
(c) Fatigue related stress
* To boost the confidence at last moment, students are advised to attempt this sample paper only a day before the exam.
(ii) Anamika never resents others because she is pretty clear about her ambitions, emotions, abilities, interests etc. She also makes conscious efforts to learn more about her own beliefs, likes and dislikes. This is called _____ [1]
(a) stress
(b) self-awareness
(c) self-motivation
(d) self-regulation
Answer:
(b) self awareness
(iii) Sunaina wants to replace some data in her word document. Which shortcut keys could she use? [1]
(a) Ctrl + F
(b) Ctrl + V
(c) Ctrl + Z
(d) Ctrl + H
Answer:
(d) Ctrl + H
(iv) Rohan makes numerous mistakes while typing. Which feature should he enable to correct his mistakes automatically? [1]
(a) Spell check
(b) Auto-correct
(c) Review
(d) Dictionary
Answer:
(b) Auto-correct
(v) Ram wants to have his own business and become an entrepreneur. His father warned him about one disadvantage of this career. What it might be? [1]
(a) Independence
(b) Ambition fulfillment
(c) Uncertainty
(d) None of these
Answer:
(c) Uncertainty
(vi) Swati always selects the best option for her enterprise. She has a good budget and other resources but she is not achieving success and according to her, her staff is incompetent. This statement means that _____ [1]
(a) The staff is not experienced and qualified
(b) The staff is qualified
(c) The staff is experienced
(d) All of the above
Answer:
(a) The staff is not experienced and qualified.
Question 2.
Answer any 5 out of the given 6 questions. [1 × 5 = 5 Marks]
(i) A _____ is a model that you use to create other documents. [1]
(a) template
(b) document
(c) design
(d) copy paste
Answer:
(a) template
(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) In a document, _____ refers to the vertical or horizontal placement of a graphic in relation to the chosen anchor point. [1]
(a) arrangement
(b) anchoring
(c) alignment
(d) text wrapping
Answer:
(c) alignment
(iv) Tanu explained his class that to apply an existing style, except for ______, position the insertion point in the paragraph, frame or page and then double-click on the name of the style in one of these lists. [1]
(a) Window style
(b) Character style
(c) Paragraph style
(d) Cell style
Answer:
(a) Window style
(v) Symbol option is available under ______ group in the Insert tab. [1]
(a) Symbols
(b) Font
(c) Header
(d) Footer
Answer:
(a) Symbols
(vi) After selecting the text you need to click the _____ in the font group to make the font size larger than the current font size. [1]
(a) Text size
(b) Font size
(c) Font type
(d) Capital letters
Answer:
(b) Font size
Question 3.
Answer any 5 out of the given 6 questions. [1 × 5 = 5 Marks]
(i) Arguments passed to a macro from Calc are always _____ [1]
(a) strings
(b) references
(c) numbers
(d) values
Answer:
(d) values
(ii) _____ function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily. [1]
(a) Summation
(b) Data Consolidation
(c) Data Format
(d) Data Chart
Answer:
(b) Data Consolidation
(iii) Auto Sum option is available in [1]
(a) Home tab
(b) View tab
(c) Insert tab
(d) Layout tab
Answer:
(a) Home tab
(iv) Which of the following component provides additional information in the chart? [1]
(a) Legend
(b) Gridlines
(c) Data label
(d) Plot area
Answer:
(c) Data label
(v) Which function cannot be performed through Subtotal in a Spreadsheet? [1]
(a) Sum
(b) Product
(c) Average
(d) Percentage
Answer:
(d) Percentage
(vi) For enter the current time in Calc, you need to press [1]
(a) Ctrl + Alt +;
(b) Shift + Alt +;
(c) Ctrl + Shift + ;
(d) None of these
Answer:
(c) Ctrl + Shift + ;
Question 4.
Answer any 5 out of the given 6 questions. [1 × 5 = 5 Marks]
(i) The _____ has evolved since the 1960s to ease increasing difficulties in designing, building and maintaining complex information systems. [1]
(a) Knowledge concept
(b) Formula concept
(c) Database concept
(d) Forms concept
Answer:
(c) Database concept
(ii) Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required? [1]
(a) Age in years
(b) Date of birth
(c) Age in days
(d) Age in months
Answer:
(b) Date of birth
(iii) Malini wants to store a huge amount of information about her zone in a database. Her friend Gargi explained to her about various benefits of storing data in RDBMS. It helps in preventing/controlling duplication of data. which of the following terms is used to refer to duplication data? [1]
(a) Data sharing
(b) Data Privacy
(c) Data redundancy
(d) Data integrity
Answer:
(c) Data redundancy
(iv) For what, Memo data type is used?
(a) To add table
(b) To store objects Created in other programs
(c) For long text entries
(d) For short text entries
Answer:
(c) For long text entries
(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) _____ command is used to retrieve data from a database. [1]
(a) SELECT
(b) COPY
(c) OPEN
(d) RETRIEVE
Answer:
(a) SELECT
Question 5.
Answer any 5 out of the given 6 questions. [1 × 5 = 5 Marks]
(i) The first network was [1]
(a) ARPANET
(b) Internet
(c) NSFnet
(d) NET
Answer:
(a) The Advanced Research Projects Agency NETwork (ARPANET)
(ii) Which of these services will not be provided by a typical Internet Service Provider (ISP)? [1]
(a) An E-mail address
(b) Modem
(c) A connection to the Internet
(d) Technical help
Answer:
(a) An E-mail address
(iii) _____ is an example of text-based browser which provides access to the Internet in the text-only mode. [1]
(a) Mozilla Firefox
(b) Lynx
(c) Internet Explorer
(d) All of these
Answer:
(b) Lynx
(iv) Nick connects to the Internet at home using a laptop computer with a wireless connection. Nick is going to change to a desktop computer using a 1 Gbps ethernet cable connection.Which of these should be the result of making the changes? [1]
(a) Increased portability and decreased speed
(b) Decreased portability and increased speed
(c) Increased portability and increased speed
(d) Decreased portability and decreased speed
Answer:
(b) Decreased portability and increased speed
(v) Which of the following websites is used for booking train tickets? [1]
(a) Nykaa
(b) IRCTC
(c) RedBus
(d) Myntra
Answer:
(b) IRCTC (Indian Railway Catering and Tourism Corporation)
(vi) Qumana is an offline blog editor which is used for _____ operating system(s). [1]
(a) Windows
(b) Mac
(c) Both (a) and (b)
(d) None of these
Answer:
(c) Both (a) and (b)
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.
Tanmay recently scored first rank in his class. His marks were very good but still he was stressed. How can good and bad experiences cause stress? [2]
Answer:
Stress can be caused by both good and bad experiences like when people feel stressed by something going on around them, their bodies react by releasing chemicals into the blood. These chemicals give more energy and strength, which can be a good thing if their stress is caused by physical danger but it can also be a bad thing, if the stress is in response to something emotional and there is no outlet for this extra energy and strength. The good stress is called eustress, whereas the bad stress is termed as distress.
Question 7.
It is important to be in charge of your own self and not be charge of your own self and not be dependent on anyone else in life. List any two reasons for which self-regulation is a must? [2]
Answer:
Self-regulation is important in life due to following reasons:
(i) Self-regulation allows you to keep a tab on your own emotions.
(ii) Self-regulation enables to develop the idea about ‘what is appropriate behaviour’ and ‘what is inappropriate behaviour’ in a given social condition.
Question 8.
Write about the significance of text editing in word processor. [2]
Answer:
Text editing plays a significant role in word processor as it has the ability to change the text by adding, deleting, rearranging letters, sentences and paragraphs. Text editing is the main feature that users perform in word processor which typically also handle graphics and multimedia files.
Question 9.
Charul wishes to be an entrepreneur. List any two qualities she should possess to be a successful entrepreneur. [2]
Answer:
The characteristics of successful entrepreneurs are as follows
(i) Leadership An entrepreneur must posses 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.
(ii) Innovativeness With the changing needs and requirements of customers production should meet requirements with the help in innovative ideas. An entrepreneur does not have to restrict itself to just one innovation rather he must use combination of innovation.
Question 10.
Write about any two myths and their truth regarding entrepreneurship. [2]
Answer:
The common set of myths of entrepreneurship are explained below :
- Talent is More Important than Industry This is not true as the nature of industry an entrepreneur chooses greatly effects the success and growth of business.
- Most Start up’s are Successful Mostly in the developing countries start-up’s fail as they could not manage to earn high profits.
Answer any 4 out the given 6 questions in 20-30 words each. [2 × 4 = 8 Marks]
Question 11.
Differentiate between the Save and Save As options. [2]
Answer:
‘ Save’ means the file gets saved under its current name, in whatever folder it was saved before or in the default folder of that computer, whereas ‘Save As’ gives you the opportunity to save the file under a different name and in another folder. ‘Save As’ allows you to name the updated version with a new name and at the same time preserving the old version.
Question 12.
What makes a workbook different from a worksheet? [2]
Answer:
| 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.
What is the use of cell reference? [2]
Answer:
In order to avoid writing the data again and again for calculating purpose, cell reference is used. When you write any formula, for specific function, you need to direct Excel the specific location of that data. This location is referred as, cell reference. So, everytime a new value added to the cell, the cell will calculate according to the reference cell formula.
Question 14.
Describe the significance of primary key in a database. [2]
Answer:
Primary key is used to uniquely identify the record in a database. It can be a column or a set of columns in the table. Main features of primary key are as follows :
(i) It must contain a unique value for each record of table.
(ii) It does not contain null values.
Question 15.
Elucidate the following terms: [2]
(i) PAN
(ii) WIMAX
Answer:
(i) PAN It stands for Personal Area Network. It is a computer network used for communication among computer and different technological devices close to it.
(ii) WiMAX It stands for Worldwide Interoperability for Microwave Access. It is a wireless transmission of data using a variety of transmission modes.
Question 16.
Why is it important to secure internet? What are the used of it? [2]
Answer:
Your passwords are the most common way to prove your identity when using website, e-mail accounts and your computer itself. The use of strong password is therefore essential in order to protect your security and identity.
Answer any 3 out the given 5 questions in 50-80 words each. [4 × 3 = 12 Marks]
Question 17.
Elaborate the use of Section Break in a document. Blow to insert a Section Break in OpenOffice? [4]
Answer:
Section Break It partitions both the body text of the document as well as partition page margins, headers and footers, page numbers etc.
To create a section
(i) Place the cursor at the point in your document where you want to insert the new section. Or, select the text that you want to place in the new section.
(ii) From the main menu, choose Insert → Section.
Question 18.
Elucidate the following with examples. [4]
(i) Goal seek
(ii) Scenario
Answer:
(i) Goal seek It refers to the act of determining your input value based on a previously determined output value. The method entails the use of a certain operator in a formula to that may be calculated with computer software, eg. Set Cell This specifies the cell whose value will be changed to the desired value after the Goal seek operation is completed.
(ii) Scenario Scenarios are a tool to text “What-if” questions. Each scenario is given a unique name which can be changed and presented independently. Only the content of the currently active scenario is printed when print the spreadsheet. It is a set of saved values that we may use in four calculations and using the Navigator or a drop down list displayed beside the changing cells, we may simply switch between these sets.
Question 19.
Write SQL queries for the questions from (a) to (e) on the basis of table Class.
| Name | Stipend | Subject | AvgMark | Grade |
| Vikas | 1200 | Medical | 67 | B |
| Boby | 1400 | Humanities | 78.4 | B |
| Tarun | 1000 | Medical | 64.8 | C |
| Varun | 1600 | Non-medical | 84 | A |
| Atul | 1800 | Non-medical | 92 | A |
(a) Select all the non-medical stream students from the class table.
(b) List the names that have grade A sorted by stipend.
(c) Arrange the records of class name wise.
(d) List the records whose grade is B or C.
(e) Insert the new row with the following data. (06, ‘Jack’, 2800, ‘Humanities’, 98, ‘A’)
Answer:
(a) mysql> SELECT * FROM Class WHERE Subjects ‘Non-medical’;
(b) mysql> SELECT Name FROM Class WHERE Grade=‘A’ ORDER BY Stipend;
(c) mysql> SELECT * FROM Class ORDER BY Name;
(d) mysql > SELECT * FROM Class WHERE Grade IS CB’, ‘ C ’);
(e) mysql> INSERT INTO Class VALUES (06, ‘Jack’, 2800, ‘Humanities’, 98, ‘A’);
Question 20.
Discuss the components of a database. [4]
Answer:
A database consists of several components. Each component plays an important role in the database system environment. The major components of database are as follows:
(i) Data It is raw numbers, characters or facts represented by value. Most of the organisations generate, store and process large amount 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.
(ii) Software It is a set of programs that lies between theVored data and the users of database. It is used to control and manage the overall computerised database. It uses different types of software such as MySQL, Oracle etc.
(iii) Hardware It is the physical aspect of computer, telecommunication and database, which consists of the secondary storage devices such as magnetic disks, optical discs etc., on which data is stored.
Question 21.
What is network topology? Also, discuss the different types of topologies. [4]
Answer:
The network topology refers to the arrangement or pattern of computers, which are interconnected in a network. Commonly used network topologies are as follows:
Bus Topology It is a type of network in which the computers and the peripheral devices are connected to a common ‘ single length data line. All the computers or devices are directly connected to the data line. The data is transmitted in small blocks, known as packets.
Ring or Circular Topology In this type of topology, each node is connected to two and only two neighbouring nodes. The data travels in one direction only from one node
to another node around the ring. After passing through each node, the data returns to the sending node.
Star Topology In this topology, there persists a central node called server or hub, which is connected to the nodes directly. If a node has to take information from other node, then the data is taken from that node through the central node or server.
Mesh Topology In this topology, each node is connected to more than one node, so that it provides alternative route, in case, if the host is either down or busy. It is also called a completely interconnected network. We can also call it as a extension to P2P network.
Tree Topology It is an extension and variation of bus topology. Its basic structure is like an inverted tree, where the root acts as a server. In tree topology, the node is interlinked in the form of tree. If one node fails, then the node following that node gets detached from the main tree topology.