Students can access the CBSE Sample Papers for Class 10 IT with Solutions and marking scheme Set 2 will help students in understanding the difficulty level of the exam.
CBSE Sample Papers for Class 10 IT Set 2 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
- 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 (24 marks)
Question 1.
Answer any 4 out of the given 6 questions on Employability Skills.
(A) Which of the following is not a managerial function in Entrepreneurship? [1]
(a) Planning
(b) Financing
(c) Motivating
(d) Staffing
Answer:
(b) Financing
Explanation:
Financing is a promotional function in entrepreneurship. The managerial function includes Planning, Organizing, Staffing, Supervising, Motivation, Co-ordination, Controlling, and Negotiation etc.
(B)_________ operating system is used to control machinery, scientific instruments, etc. [1]
(a) Real Time
(b) Distributed
(c) Single User
(d) Multi User
Answer:
(a) Real time
Explanation:
A real time operating system is a computing environment in which the computer manages the resources in a way that any particular operation is executed in the same amount of time, every time it is executed.
(C) Kartik is a Front Office Manager in a Hotel He is also preparing for Banking exams. He gives 3 to 4 hours to his studies. Today he has been studying for more than an hour but he realizes that he is hungry and his phone is also buzzing with some message notifications. All this is distracting him from his studies. What do you suggest him to do now? [1]
(a) Take a small nap
(b) Go to kitchen and prepare something for him
(c) Take a quick break to get a snack and check the messages before going back to studying
(d) Both (a) and (b)
Answer:
(c) Take a quick break to get a snack and check the messages before going back to studying.
Explanation:
To manage your time effectively some tips are as follows:
- Stick to schedule.
- Do one thing at a time.
- Plan for unexpected.
- Do not multitask
In the given case hunger and notifications are two unexpected hindrances in his studies. And if he checks phone while studying then also it will create distraction. So it would be better to stick to one task at a time and then focus on what he has planned.
For effective time management one should follow the four steps given below.
- Plan out your time in advance.
- Prioritize your tasks as per urgency and importance.
- Monitor how the tasks are carried out as per the planning.
- Track the time spent on tasks.
(D) In SMART goal setting method M stands for_________ [1]
(a) Must
(b) Measurable
(c) Monitoring
(d) Mindful
Answer:
(b) Measurable
Explanation:
The term Measurable refers that goals should have specific criteria to measure the progress towards their accomplishments.
SMART is an acronym that stands for Specific, Measurable, Achievable, Realistic and Timely. It consists of all these criteria to help focus your efforts in achieving the goals.
(E) State whether true or false: “Entrepreneurs who do not have an innovative idea cannot succeed”. [1]
(a) True
(b) False
Answer:
(a) True
Explanation:
An entrepreneur is also an innovator or creator. An entrepreneur without an innovative idea finds difficult to succeed. For a successful entrepreneurship a good idea with strong planning is required.
(F) To select the text, one has to press and hold the mouse button and move the cursor. Which of the given terms is most appropriate for this process? [1]
(a) Highlighting
(b) Selecting
(c) Moving
(d) Dragging
Answer:
(d) Dragging
Explanation:
Dragging refers to moving the mouse pointer while holding its button. Dragging helps in selecting and moving text. You can drag and drop the objects, files etc. to move them from one location to another.
Question 2.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) …………….. is not an instant messaging service.
(a) Skype
(b) Yahoo Messenger
(c) Firefox
(d) WhatsApp
Answer:
(c) Firefox
(ii) …………….. is the process of emptying the place in case of an emergency.
(a) Disaster
(b) Evacuation
(c) Accident
(d) Hazard
Answer:
(b) Evacuation
(iii) …………….. is a device that converts digital computer signals into a form analog signals that can travel over phone lines and vice-versa.
(a) Repeater
(b) Switch
(c) Router
(d) Modem
Answer:
(d) Modem
(iv) In which of the following architecture the whole data is saved at centralised system and other computers will take the services from the centralised system.
(a) Client-server
(b) Peer to peer
(c) Point to point
(d) Ring
Answer:
(a) Client-server
(v) Which of the following is not an offline blog editor?
(a) Qumana
(b) Word press
(c) Blog Desk
(d) None of these
Answer:
(b) Word press
(vi) A/An …………….. software is a program that detects prevents from malicious programs such as viruses.
(a) Anti-virus
(b) Disc cleanup
(c) Spam
(d) Worm
Answer:
(a) Anti-virus
Question 3.
Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(i) Grouping drawing object can be used for which of the following? (1)
(a) Combining drawing objects as one
(b) Resizing
(c) Adding more drawing objects
(d) None of these
Answer:
(a) Combining drawing objects as one
(ii) Aanya is making a table in a Database to store data of all the employees working in her organization. She has decided on the various information that she needs to store on that table. She also has to have a field in which unique data can be entered. Out of the given fields suggest the best field suitable that can be used as a primary key, so that it can accept unique data. (1)
(a) Emp_name
(b) Emp_dept
(c) Emp_number
(d) Emp_DOB
Answer:
(c) Emp_number
(iii) Computer connected with LAN (1)
(a) can work fast
(b) can go online
(c) can E-mail
(d) can share information or peripheral devices
Answer:
(d) can share information or peripheral devices
(iv) State True or False. (1)
“A custom style displays user-defined styles.”
(a) True
(b) False
Answer:
(a) True
(v) According to OpenOffice Calc which of the following is not a What-if analysis tool? (1)
(a) Conditional formatting
(b) Goal seek
(c) Scenarios
(d) Solver
Answer:
(a) Conditional formatting
(vi) ________ allows multiple users to view, edit and change in a spreadsheet. (1)
(a) Opening
(b) Reviewing
(c) Sharing
(d) Collaborating
Answer:
(c) Sharing
Question 4.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) Cells hold the individual elements as ……………..
(a) Text
(b) Numbers
(c) Formulas
(d) All of these
Answer:
(d) All of these
(ii) …………….. is a mathematical expression to perform calculations on data in cells.
(a) Goal Seek
(b) Macro
(c) Formula
(d) None of these
Answer:
(c) Formula
(iii) …………….. tab is used to create a scenario.
(a) Tools
(b) View
(c) Format
(d) None of the above
Answer:
(a) Tools
(iv) To perform an online transaction you need is a ……………..
(a) Web browser
(b) Internet connection
(c) both (a) and (b)
(d) None of the above
Answer:
(c) both (a) and (b)
(v) …………….. is a set of data values of one type arranged vertically.
(a) Row
(b) Column
(c) Cell
(d) Table
Answer:
(b) Column
(vi) Types of DML commands are ……………..
(a) Procedural
(b) Non-Procedural
(c) Both (a) and (b)
(d) None of the above
Answer:
(c) Both (a) and (b)
Question 5.
Answer any 5 out of the given 6 questions.
(A) Which of the following toolbar offers the tools to draw shapes in MS Word? [1]
(a) Home
(b) 3D settings
(c) Drawing
(d) Standard
Answer:
(c) Drawing
Explanation:
The drawing toolbar in MS Word is a collection of many tools to draw and colour shapes, add text effects, create text boxes, and add graphics with colours within a document.
(B) Which of the following fields of Student database can act as primary key? [1]
(a) Admission_no
(b) Stu_name
(c) Phone_no
(d) Father_name
Answer:
(a) Admission_no
Explanation:
A primary key is a type of field which is unique for all the records in a table. A primary key field is also used to related data from one table to another.
(C) Sahil has a little knowledge of MS Access. He wants to create the table by typing the field names, their data types and some other settings. Which of the following methods you would suggest for him to create the table from scratch? [1]
(a) Create table using Table Wizard
(b) Create Table using Design view
(c) Create Table using Data Sheet view
(d) All of these
Answer:
(b) Create Table using Design view
Explanation:
The Design View displays the structure of a table by showing the details like Field name, Field type, Description etc. It also shows the settings for each field. The user can create the structure of table by providing all the details of various fieLds of the table.
You can also create tables using Table Wizard. It is a fast way to create tables. The wizard allows you to create a table automatically by asking you a series of questions about the types of fields you want to include in your table.
(D) Grouping the functions is also called _________ functions. [1]
(a) Aggregate
(b) Summary
(c) Both (a) and (b)
(d) Queries
Answer:
(c) Both (a) and (b)
Explanation:
Aggregate functions are also known as Summary functions. These are used to aggregate the group of records. They produce a single value from the group of values.
Most common aggregate functions in a DBMS are Count, Sum, Average, Minimum and Maximum,
(E) _________ is used to retrieve information from the web. [1]
(a) Server
(b) Windows
(c) Client
(d) Browser
Answer:
(d) Browser
Explanation:
A browser is a specialised program or software on a client computer that retrieves information from the web.
Example: Google Chrome, and Mozilla Firefox etc.
(F) __________ ae the values passed to macros as functions. [1]
(a) Values
(b) Arguments
(c) Data
(d) Information
Answer:
(b) Arguments
Explanation:
An Excel macro is an action or a set of actions that can be recorded, named, saved and executed as many times as required and whenever desired. Macros can also be created to behave like functions. These macros accepts values or arguments to perform the function associated with them.
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.
Why is self-regulation important in life? (2)
Answer:
Self-regulation is important in life for to following reasons:
- Self-regulation allows you to keep a tab on your own emotions.
- Self-regulation enables to development of the idea of ‘what is appropriate behaviour’ and ‘what is inappropriate behaviour’ in a given social condition.
- It helps in controlling negative impulses and reciprocating emotions for actualizing set goals.
Question 7.
Define any two stress management techniques. [2]
Answer:
Following are two most common stress management techniques:
- Meditation: Meditation calms our mind and body by clearing all our thoughts. It reduces our mental and physical stress.
- Taking breaks and good sleep: Taking breaks from usual routine lowers the stress. Sleep relaxes and recharges the brain and makes it ready to work again the next day.
Question 8.
How can individuals contribute to Sustainable Development Goals?
Answer:
Sustainable development can happen only when each one of us works towards it. One has to become a responsible environmental citizen who can protect the environment through our efforts, who can help others to get quality education, by reducing inequalities in the society, etc.
Question 9.
What role do green skills play in addressing climate change? (2)
Answer:
Green skills are essential for developing and implementing climate change mitigation and adaptation strategies, including renewable energy deployment, energy efficiency improvements, and sustainable land use practices.
Question 10.
How can we overcome barriers of cultural influence?
Answer:
Cultural barriers arise due to ethnic, religious, and social differences which often create misunderstandings during the process of communication. These differences can also affect one’s perception and create confusion while understanding the message. For overcoming cultural barriers both the parties involved in the communication must get familiar with each other’s culture and respect their culture, religion, and ethics.
Answer any 4 out of the given 6 questions in 20-30 words each.
Question 11.
What do you understand by cropping an image? [2]
Answer:
Cropping refers to removing or trimming an unwanted area from an image starting from its edges. In a word processor cropping hides the unwanted part of an image.
Question 12.
What is the use of the Consolidate option in Calc? (2)
Answer:
Data → Consolidate provides a way to combine data from two or more ranges of cells into a new range while running one of the several functions (such as Sum or Average) on the data. During consolidation, the contents of cells from several sheets can be combined into one place. The effect is that copies of the identified ranges are stacked with their top left corners at the specified result position, and the selected operation is used in each cell to calculate the result value.
Question 13.
What is a form? Define the uses of forms. [2]
Answer:
A form is an object use to create a user interface for a database application. The uses of forms are as follows:
- It provides user friendly interface to insert data.
- Data can be modified and viewed using forms.
- Forms are also helpful in searching and deleting records.
Question 14.
Write short notes on-
(a) Web server (b) Dial-up
Answer:
(a) Web Server – It is a computer that stores websites and their related files and other computers connected to it through the internet can access these files.
(b) Dial-up – This kind of internet access uses the facilities of the Public Switched Telephone Network (PSTN) to establish a connection to an ISP for accessing the internet. Dial-up connections are extremely slow so hardly used nowadays.
Question 15.
What is Referential Integrity? Explain its purposes. (2)
Answer:
Referential Integrity is a property of data stating that all its references are valid. In the context of relational databases, it is required that if a value of one attribute of a relation references a value of another attribute, then the referenced value must exist. Referential integrity is a database concept that is used to build and maintain logical relationships between two tables. It helps to maintain the accuracy and consistency of data in RDMS.
Question 16.
How to insert an image in the file?
Answer:
To insert an image in the document follow the given steps-
- Click in the document where you want the image to appear.
- Choose Insert > Image from the Menu Bar.
- In the Insert Image dialogue box as shown in the figure given below, navigate to the file to be inserted then select it and click on Open.
- At the bottom of the dialogue box there is an option called Link. Select Link for inserting the image into your document as a link.
Answer any 3 out of the given 5 questions in 50-80 words each.
Question 17.
What are macros, how are they useful, how can you record a macro in Calc, and what are two other spreadsheet programs besides Calc? [4]
Answer:
- A macro refers to a named and recorded sequence of commands or keystrokes that are saved in the spreadsheet for later use. These can be reused any number of times.
- Sometimes you have tasks in the spreadsheet that you do repeatedly or frequently. Macros can automate such common and repetitive tasks. By reducing the number of keystrokes, macros speed up the work and also reduce the time to complete the task.
- To record a macro in Calc click command Tools -> Macros -> Record Macro.
- MS Excel and Lotus Symphony are examples of spreadsheet programs.
Question 18.
Samarjit wants to know about the template. Tell him the definition of the template and also the steps to create a document using it. (4)
Answer:
A template is a document model that you use to create other documents. For example, you can create a template for business reports that have your company’s logo on the first page. New documents created from this template will all have your company’s logo on the first page. Templates can contain anything that regular documents can contain, such as text, graphics, a set of styles, and user-specific setup information such as measurement units, language, the default printer, toolbar, and menu customization. To use a template to create a document:
- From the main menu, choose File → New → Templates and Documents. The Templates and Documents dialog box will open.
- In the box on the left, click the Templates icon if it is not already selected. A list of template folders appears in the center box.
- Double-click the folder that contains the template that you want to use. A list of all the templates contained in that folder appears in the center box.
- Select the template that you want to use. You can preview the selected template or view the template’s properties:
- To preview the template, click the Preview icon. A preview of the template appears in the box on the right.
- To view the template’s properties, Click the Document Properties icon. (For the location of the Document Properties icon) The template’s properties appear in the box on the right.
- Click Open. The Templates and Documents dialog box closes and a new document based on the selected template opens in Writer. You can then edit and save the new document just as you would any other document.
Question 19.
The following table displays a part of information on student’s marks in different subjects. [4]
Table: Marks
| StulD | StuName | Marks1 | Marks2 | Marks3 |
| 1001 | Samarth Sharma | 85 | 88 | 89 |
| 1005 | Vikas Gupta | 76 | 75 | 66 |
| 1010 | Nidhi Singh | 98 | 87 | 89 |
| 1004 | Gayitri Chauhan | 67 | 65 | 68 |
(A) Define the structure of the given table.
Answer:
| StulD | Integer |
| StuName | Char (20) |
| Marksl | Integer |
| Marks2 | Integer |
| Marks3 | Integer |
(B) Write commands of SQL to:
- Add a new record with given details (“1009”, “Divya Sharma”, “77”, “56”, and “67”).
- Modify the marks of Nidhi Singh as Marksl=97, Marks2=89, Marks3=84.
Answer:
SQL Commands:
- INSERT INTO marks VALUES (1009, “Divya Sharma”, 77, 56, 67).
- UPDATE marks SET marksl=97, marks2=89, marks3=84 WHERE StuName= “Nidhi Singh”.
(C) Change the column names Marksl, Marks2, Marks3 with Eng, Math and IT respectively.
Answer:
ALTER TABLE marks RENAME COLUMN marks1 TO Eng, RENAME COLUMN marks2 TO Math, RENAME COLUMN marks3 TO IT.
Question 20.
Given the following Spreadsheet, Write the appropriate Formula/Expression/Function to be used for (a) to (d) :
(a) To calculate the Total Rainfall in cell F2
(b) To calculate the Average Rainfall in cell G2
(c) To find the Maximum Rainfall in July in Cell C7
(d) To find the Minimum Rainfall in Aug in Cell D7
Answer:
(a) =SUM(C2:E2)
(b) =AVERAGE(C2:E2)
(c) =MAX(C2:C6)
(d) =MIN(D2:D6)
Question 21.
Rahul and Amit are working on a school project assigned to them by their teacher. They have to send instant messages to each other and also do video conferencing after school hours to complete the project on time. Tell the use of the following devices used for video conferencing. (4)
(a) Microphone
(b) Web camera
(c) Speakers
(d) Headsets
Answer:
(a) Using a microphone, the speaker can convey their messages.
(b) A web camera is used to have a real-life image of the person.
(c) Speakers are used to listen to the words of the speaker.
(d) Headsets are used to listen to the speaker without disturbing anyone nearby.