Students can access the CBSE Sample Papers for Class 10 IT with Solutions and marking scheme Set 8 will help students in understanding the difficulty level of the exam.
CBSE Sample Papers for Class 10 IT Set 8 With Solutions
Time Allowed: 2 Hours
Maximum Marks: 50
General 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.
- Maries 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 (24 marks)
Question 1.
Answer any 4 out of the given 6 questions on Employability Skills.
(A) Self management skills refers to …………….. [1]
(a) Controlling your happiness.
(b) Managing your belongings.
(c) Controlling your anger.
(d) Motivating oneself and setting goals.
Answer:
(d) Motivating oneself and setting goals.
Explanation:
Self management is a skill to that refers to stress management, self awareness, self regulation, self motivation and self confidence. By working on these skills one can find its own weaknesses and strengths which helps in setting and achieving goals for the person itself.
Visual forms of communication is done via pictures, logos, maps, posters etc.
(B) Which of the following is not a role of an entrepreneur? [1]
(a) Team building
(b) Avoiding risks
(c) Cashflow management
(d) Decision making
Answer:
(b) Avoiding risks
Explanation:
There are certain risks involved in any entrepreneur venture. An entrepreneur should understand the risks and should be able to bear them too. Taking risks needs a farsightedness and planning in advance so that risks could be taken.
Some of the roles of an entrepreneur are as follows:
- An entrepreneur is a developer who creates a new product.
- They have to play multiple roles for which time management has to be done.
- They should be good decision makers.
- Delegating tasks and getting output is based on people’s skills, which an entrepreneur must know.
(C) …………….. is not a step of computer maintenance. [1]
(a) Cleaning dust
(b) Copying files from hard drive to pen drive.
(c) Removing junk files
(d) Updating software
Answer:
(b) Copying files from hard drive to pen drive.
Explanation:
For internal cleaning one should remove junk files, empty recycle bin, use cleaning programs to remove unwanted files and folders. In addition to all this you can also run the defragmenter utility in a month or two.
(D) Punishment is a …………….. type of self motivation. [1]
(a) Extrinsic
(b) Intrinsic
(c) Both (a) and (b)
(d) None of these
Answer:
(a) Extrinsic
Explanation:
Extrinsic motivation is one in which external factors are responsible for motivation. E.g. incentives, promotions, criticism etc.
Intrinsic motivation depends upon internal factors such as joy, fear, love etc
(E) Linux is an example of …………….. [1]
(a) Operating system
(b) DBMS
(c) Antivirus
(d) Word processor
Answer:
(a) Operating system
Explanation:
Linux is an operating system. It is an open source software which is freely available on the Internet. Anyone can download and use it.
Some other commonly used Operating systems are Windows, BOSS, Solaris.
Android and Apple iOS are popular mobile operating systems.
(F) Which of the following statement is incorrect about the impact of an entrepreneur in the society? [1]
(a) Entrepreneurship creates jobs.
(b) The price of the product goes high.
(c) Contribute growth to overall economy.
(d) None of these
Answer:
(b) The price of the product goes high
Explanation:
More entrepreneurs sell same product and to make them at low cost they purchase local materiaL Thus, entrepreneurship lowers the rates of product.
A communication barrier is a problem in communication that prevents us from receiving and understanding that the messages others use to convey their information, ideas and thoughts.
Question 2.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) ……………… styles impact the structure of the document.
(a) Character
(b) Page
(c) Paragraph
(d) Frame
Answer:
(b) Page
(ii) A template is a blueprint to create ………………
(a) Table
(b) Table of contents
(c) Styles
(d) Another document
Answer:
(d) Another document
(iii) ……………… refers to a range of cells.
(a) Row
(b) Column
(c) Cell reference
(d) Formula
Answer:
(c) Cell reference
(iv) ………….. is a storage container that stores data that belongs to a simple object, subject, or purpose.
(a) Database
(b) Table
(c) Record
(d) Field
Answer:
(b) Table
(v) ……………… option in Windows 10 is used to turn off animations and background images.
(a) Narrator
(b) Closed captioning
(c) Magnifier
(d) Other options
Answer:
(d) Other options
(vi) ……………… is a group of computers that are connected in small area with the help of some cables.
(a) LAN
(b) WAN
(c) VAN
(d) RCN
Answer:
(a) LAN
Question 3.
Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(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 summarizes 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) AutoSum 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 components 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) To 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) Why Styles are used in the document?
(a) It maintains consistent formatting
(b) Formatting changes in complete document is easy
(c) The formatting is done very fast
(d) All of these
Answer:
(d) All of these
(ii) In a worksheet, while performing consolidation, if same data range is selected from multiple worksheets, then consolidation is done by
(a) Applying Average function on the range.
(b) Copying data below the selected range.
(c) Replacing data from the selected range.
(d) Applying Sum function on the range.
Answer:
(d) Applying Sum function on the range.
(iii) While creating a table in DBMS, which of the following is considered optional?
(a) Field Name
(b) Description
(c) Data Type
(d) Field size
Answer:
(b) Description
(iv) The structure of a table, once created, can be changed using ……………… SQL command.
(a) UPDATE
(b) SET
(c) MODIFY
(d) ALTER TABLE
Answer:
(d) ALTER TABLE
(v) Which of the following is not a type of blog?
(a) Macro
(b) News and views
(c) Personal
(d) Company
Answer:
(a) Macro
(vi) Saumya wants to use network banking for some transactions. She forgot the site address and searched it on Google. The search list is showing three websites with different starting symbols. Which of the following symbol should be in the beginning of URL?
(a) HTTPS
(b) FTP
(c) HTTP
(d) Any of these
Answer:
(a) HTTPS
Question 5.
Answer any 5 out of the given 6 questions.
(A) Kavita wants to apply for a job. She needs a resume to submit in different companies. She knows what to write in a resume but does not know how to format it. Which of the following features of a word processor can help her for the same? [1]
(a) Style
(b) Template
(c) Table of contents
(d) None of these
Answer:
(b) Template
Explanation:
A template is a special type of empty document with all formatting features stored in it. Using a document template many documents can be created which will have same formatting features as defined in the template.
(B) Which of the following is not an advantage of macros? [1]
(a) Automates repetitive keystrokes.
(b) Reduces the possibility of human error.
(c) Reduces time spent in repetitive tasks.
(d) Makes tasks complex.
Answer:
(d) Makes tasks complex
Explanation:
Macros make complex computations easier to perform by storing them in a name, which can be re-run to perform the complex tasks repetitively.
(C) To specify a condition of BaLStock between 25 and 50 the Criterion row in Query Design View should contain: [1]
(a) >=25 and <=50
(b) >=50 and <=25
(c) >=25 and <=50 in the column Bal_ Stock
(d) Between 25 and 50 in the column Bal_ Stock
Answer:
(c) >=25 and <=50 in the column Bal_ Stock
Explanation:
To specify multiple conditions with an AND condition all criteria must hold To join criteria for a single field with AND, type them into the Criteria line of the grid with AND between them. The above query will show records with values less than or equal to 50 as well as those greater than or equal to 25 in column Bal_ Stock
(D) In the office of a finance company there are 7 computers. They all are connected to a network. These computers act as server as per the need. Which type of network is established there? [1]
(a) Peer-to-peer network
(b) Client Server Network
(c) Common Network
(d) Metropolitan Area Network
Answer:
(a) Peer-to-peer network
Explanation:
A Peer-to-peer network is created when two or more PCs are connected and share resources without going through a separate server computer. The computers in this network work independently and can switch role as and when required.
(E) Forms shows …………….. records at a time. [1]
(a) 1
(b) 2
(c) 3
(d) As many as you want.
Answer:
(a) 1
Explanation:
A form in database can display only one record at a time. They can display fields from multiple tables.
(F) State whether true or false.
In Calc, a sheet can be added only from Insert menu. [1]
(a) True
(b) False
Answer:
(b) False
Explanation:
In Calc a sheet can be added by three different methods
- Click Insert -> Sheet, Or
- Right click on tab and select Insert Sheet, Or
- Click on empty space at the end of Sheet tabs.
Section – B (26 Marks)
Answer any 3 out of the given 5 questions on Employability Skills
Answer each question in 20 – 30 words.
Question 6.
How can one adapt their communication style to different audiences? (2)
Answer:
Adapting communication style involves understanding the audience’s needs, preferences, and cultural background. It requires using appropriate language, tone, and examples to ensure the message is understood and well-received.
Question 7.
What does ‘S’ stands for in SMART goals? Explain. [2]
Answer:
In SMART, ‘S’ stands for specific. It means that goals should be well defined, clear and unambiguous. It should clearly specify what is to be achieved and accomplished. The specific goals have greater chance of being achieved. To make a goal specific, The six “W” questions must be taken into consideration:
(i) What: What do I want to accomplish?
(ii) Who: Who is involved to achieve goal?
(iii) When: When should the goal be achieved?
(iv) Why: Why do I want to achieve the goal?
(v) Where: Where is this goal to be achieved?
(vi) Which: Which are the requirements to achieve the goal?
Question 8.
Explain ‘M’ in SMART.
Answer:
SMART is an acronym in which M stands for Measurable which means that the goals should have clear criteria for measuring the progress towards the achievement of goals. The measure of an objective can be qualitative and quantitative. Measuring the goals makes it easier to track the progress.
Question 9.
Can green skills help in achieving the Sustainable Development Goals (SDGs)? (2)
Answer:
Yes, green skills are essential for achieving the SDGs, as they contribute to goals related to clean energy, sustainable cities, responsible consumption and production,’climate action, and life below water and on land.
Question 10.
Write about any two myths and their truth regarding entrepreneurship. (2)
Answer:
The common set of myths of entrepreneurship is explained below:
- Talent is More Important than Industry: This is not true as the nature of the industry an entrepreneur chooses greatly affects the success and growth of the business.
- Most Start-ups are Successful: Mostly in developing countries start-ups fail as they cannot manage to earn high profits.
Question 10.
Briefly explain the terms:
(A) Worms
(B) Trojan Horse
Answer:
(A) Worms: Worms are a type of computer virus that does not modify the program like a virus does. Its main objective is to eat the system’s resources. It replicates itself more and more and slows down the computer system.
(B) Trojan: A Trojan Horse is also a type of malware that uses fake names to mislead users from their true intent and execute them. Trojan Horses generally get installed on the system as legitimate and useful software and give unauthorized access and control of the system to the hackers.
Answer any 4 out of the given 6 questions in 20-30 words.
Question 11.
Explain the meaning of hierarchy of headings. [2]
Answer:
Headings are very important in any document. Headings organise the document and increase its readability. A document may have headings and its sub headings or a sub- sub heading i.e., a document can have various levels of headings called heading hierarchy. This hierarchy of headings specify the relationship between main heading and sub headings. It also describes the importance of information written under different levels of headings.
Question 12.
What, makes a workbook different from a worksheet? (2)
Answer:
Differences between the 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 some of the advantages of databases. [2]
Answer:
Advantages of databases are as follows:
(i) Databases reduce data redundancy i.e. duplication of data.
(ii) It controls data inconsistency which means multiple mismatching copies of same data.
(iii) It facilitates sharing of data.
(iv) It ensures that the data stored should follow the applicable standards.
(v) It ensures data security and privacy.
Question 14.
Write differences between a flat file database and a relational database.
Answer:
| Flat File Database | Relational Database |
| In flat file database all data is stored in a single table. | In relational database the data is stored in multiple tables. |
| There is no linking between data. | The data in one table is linked to data in another table. |
| Cannot avoid data redundancy. | Data redundancy does not take place in RDBMS |
Question 15.
Elucidate the following terms: (2)
- PAN
- WIMAX
Answer:
- PAN: It stands for Personal Area Network. It is a computer network used for communication among computers 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.
Differentiate between goal seek and solver.
Answer:
| Goal Seek | Solver |
| Goal seek is used on single variable. | Solver can solve equations that use multiple variables. |
| It allows to vary the values only in one cell. | It allows values to vary in 200 cells. |
Answer any 3 out of the given 5 questions in 50-80 words. (4 × 3 = 12)
Question 17.
How can a spreadsheet assist a teacher in creating marks lists for students, and what are two potential disadvantages of using a spreadsheet for this purpose? [4]
Answer:
Spreadsheets provides functions, which can be used to create formulas to perform complex calculations on data.
It has Macros, for recording and executing repetitive tasks.
Following are the disadvantages of using spreadsheet
(i) Spreadsheets are customisable so they are not user friendly and secure. Anyone can share the worksheet by sending a simple mail to any other person.
(ii) Data visualisation is diffculte specially when there is Large number of records then scrolling up and down makes the working diffcult and time-consuming.
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 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 printing 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.
The following table displays a part of the information on Menu items in a restaurant. [4]
Table: Items
| ItemNo | ItemName | Price |
| 110 | Cold Drink | 45 |
| 112 | Tea | 25 |
| 115 | Coffee | 25 |
(A) Which of the given fields can be set as a Primary key and why?
(B) Write SQL queries to:
(i) Display the price of Cold Drink
(ii)Add a new record with details (“116”, “Cold Coffee”, “115”)
(iii) Change the price of all items by adding Rs. 25 to each.
Answer:
(A) ItemNo field can be set as a primary key.
The reason is that the item number is a unique data for each item in the table and the items can be searched, and viewed based on the item number.
(B) SELECT price FROM items WHERE ItemName = “Cold Drink”
(i) INSERT INTO items VALUES (“116”, “Cold Coffee”, “115”)
(ii) UPDATE items SET price = price + 25
(iii) DELETE FROM items WHERE ItemName = “Tea”.
Question 20.
Mohan is a shoe manufacturer and also runs his factory outlets. The company uses databases to maintain the sales records of its products. The data operator who enters the records of daily sales does not know how to work on tables in the datasheet view.
(A) What can be the other way to enter and modify the records in the database?
(B) The manager of the company wants to see the sales of last month. Which feature will be helpful to view records for the same?
(C) The manager wants the hard copy of sales for the present month. Name the feature to perform this.
(D) What is the difference between a Query and a Report?
Answer:
(a) Form view can also be used to enter and modify records in the database. It is an interactive
screen which allows user to work on single record at a time.
(b) To view records based on a particular condition, queries are used in the database.
(c) To print the records, the database provides Reports feature. Reports are an effective way to print records in formal and formatted way.
(d) A query is a question which is defined and sent to the table or data source to retrieve the data, whereas, a report is an organized and formatted view of the data retrieved by a query. A report is generally a printed form of a query.
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 neighboring nodes. the data transferred direction only from one node to another node around the ring. After passing through each node the data returns to the sensing node.
Star Topology:
In this topology, there persists a central node called a server or hub, which is connected to the nodes directly. If a node has to take information from another ncce 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 an alternative route, in case, the host is either down or busy. It is also called a completely interconnected network. We can also call it an extension to the 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 a tree. If one node fails, then the node following that node gets detached from the main tree topology.