Students can access the CBSE Sample Papers for Class 10 IT with Solutions and marking scheme Set 1 will help students in understanding the difficulty level of the exam.
CBSE Sample Papers for Class 10 IT Set 1 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) Wahida runs a boutique. She buys cloth material from a local market. But recently she came in contact with a cloth manufacturer and discovered that there was quite a big difference in rates of same cloth material if bought from the manufacturer. She decided to purchase the material from the manufacturer. Which of the fallowing function of entrepreneurship is she performing? [1]
(a) Planning
(b) Controlling
(c) Production and operations
(d) Finance and accounting
Answer:
(c) Production and operations
Explanation:
Managing production and operations include sourcing of raw materials, checking functioning of machinery, utilizing maximum capacity etc.
(B) For self-motivation, self-awareness is a very important factor. The feeling of self-awareness enhances our …………….. [1]
(a) Self-confidence
(b) Self-monitoring
(c) Self-regulation
(d) Self-discipline
Answer:
(a) Self-confidence
Explanation:
Self-awareness is the ability to be aware of one’s own life, emotions, thoughts, behaviours, preferences, goals etc. It is a self-management skill which helps to become better decision-makers which build up self-confidence.
Self-management involves following skills:
(i) Stress management
(ii) Self-awareness
(iii) Self-motivation
(iv) Set goals
(v) Time management
(C) The extension of a notepad file is …………….. [1]
(a) doc
(b) docx
(c) txt
(d) xlsx
Answer:
(c) txt
Explanation:
Notepad is a simple text editor for Windows. It creates and edits plain text documents. The default extension given to files created in Notepad is txt.
docx and doc are the extensions given to the document files created in word processor. Spreadsheets made in Excel are stored with extension xlsx.
(D) Which of the following practice will protect computer from security threats? [1]
(a) Using antivirus
(b) Using Firewall
(c) Use of strong passwords
(d) All of these
Answer:
(d) All of these
Explanation:
Antivirus are the type of software detects and removes viruses and other malicious software from the computer.
Firewall is a network security system that monitors and controls incoming and outgoing network traffic and permits or blocks data packets based on set of security rules Strong passwords are created using the mix of character types, including numbers and special symbols. It has a sufficient length. The purpose of strong password is to ensure that the access is permitted only to authorized users.
(E) Rashmi was doing well in her job and was getting a handsome salary. But suddenly she made up her mind for starting her own business. Which one of the following is an advantage of entrepreneurship? [1]
(a) Can work for their passion
(b) Can make money with less effort
(c) Working hours are long
(d) All of these
Answer:
(a) Can work for their passion
Explanation:
Entrepreneurship has some advantages which includes the choice of work. They can choose their passion as a work. E.g. if cooking is a passion of any person then he/ she can open his own food corner or restaurant.
Entrepreneurship also has some disadvantages that are listed below:
(i) There are no fixed working hours.
(ii) Initially there will be very less or no income.
(iii) Finding investors that are interested in particular business, is very difficult
(iv) Risk factor is always there with any business.
(F) Physical exercise is a technique to …………….. [1]
(a) Relieve stress
(b) Manage time
(c) Boost self confidence
(d) All of these
Answer:
(a) Relieve stress
Explanation:
Physical exercise is a technique of stress management to relieve stress. It also boosts self-esteem, stabilizes mood, and induces good sleep.
Question 2.
Answer any 5 out of the given 6 questions: (1 × 5 = 5 Marks)
(i) A ………… is an application software that processes text and is used to create, modify, format and print documents.
(a) Open Office Calc
(b) Open office impress
(c) Open office writer
(d) None of these
Answer:
(c) Open office writer
(ii) …………… is a horizontal bar present at the bottom of the Windows 7 desktop.
(a) Status bar
(b) menu bar
(c) taskbar
(d) recycle bin
Answer:
(c) taskbar
(iii) …………… serves as an interface between the user and the computer.
(a) Hardware
(b) Software
(c) Internet
(d) Operating System
Answer:
(d) Operating System
(iv) Complete the assignment ………….. 1 hour.
(a) at
(b) in
(c) by
(d) under
Answer:
(b) in
(v) Sound sentry is designed to help users with ……………. impairments.
(a) vision
(b) auditory
(c) both (a) and (b)
(d) none of these
Answer:
(b) auditory
(vi) The term ISP stands for ……………
(a) Internet Security Protocol
(b) Internet Service Protocol
(c) Internet Service Provider
(d) Internet Security Provider
Answer:
(c) Internet Service Provider
Question 3.
Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(i) Select _______ → Track changes →
Record from the menu bar. Thereafter, every change you record on the spreadsheet will have a red border around it. (1)
(a) File
(b) Edit
(c) Format
(d) Layout
Answer:
(b) Edit
(ii) Calc considers any data that it does not recognize as a number, date, time, or formula, as: (1)
(a) Expression
(b) Equation
(c) Text
(d) Function
Answer:
(c) Text
(iii) In _______ topology, each node is connected to two and only two neighbouring nodes. (1)
(a) star
(b) ring
(c) mesh
(d) tree
Answer:
(b) ring
(iv) State True or False.
‘Goal seek in Calc, helps us to find the desired result by adjusting an input value.’ (1)
(a) True
(b) False
Answer:
(a) True
(v) Rajiv was asked to highlight the cells with green colour where the value entered is either greater than or equal to 120 in the worksheet containing thousands of data entries. Which feature of Calc should he use to get this work done within seconds? (1)
(a) Conditional formatting
(b) Filtering
(c) Sorting
(d) Simple formatting
Answer:
(a) Conditional formatting
(vi) Which of the following tools will help Swati, if she wants to arrange the height of students in her class in ascending order? (1)
(a) Ordering data
(b) Sorting data
(c) Presenting data
(d) Referring data
Answer:
(b) Sorting data
Question 4.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) ………….. are generally prepared for presenting the data in hard copy by using printers.
(a) Form
(b) Query
(c) Report
(d) Table
Answer:
(c) Report
(ii) The extension of Libre Offices preadsheet file is ………….
(a) .ODS
(b) .ODT
(c) .ODP
(d) .ODD
Answer:
(a) .ODS
(iii) Data can be organized in a database in mainly ……………. types.
(a) Four
(b) Six
(c) Three
(d) Two
Answer:
(d) Two
(iv) Relational Database is a collection of ………………
(a) Tables
(b) Values
(c) Records
(d) None of the above
Answer:
(a) Tables
(v) Which website is used for online booking of train tickets?
(a) Amazon
(b) IRCTC
(c) Flipkart
(d) Trivago
Answer:
(b) IRCTC
(vi) In which menu Share Spreadsheet option is available?
(a) Tools
(b) Data
(c) Styles
(d) Format
Answer:
(a) Tools
Question 5.
Answer any 5 out of the given 6 questions.
(A) Which of the following is an example of data consolidation? [1]
(a) Collecting budget data from different departments and making overall company budget from them.
(b) Collecting mark sheets of students and creating report card out of them
(c) Using sales data of different cities to find out overall sales of a company
(d) All of these
Answer:
(d) All of these
Explanation:
Data consolidation is a process of collecting or considering data of multiple worksheets and consolidate them into one single worksheet or summary report. It is used to combine similar types of data stored in different sheets of a workbook.
Formulas like sum, count average, min. max are used while combining data and making a report
(B) While recording a macro the keystrokes are converted into …………….. [1]
(a) Links
(b) Code
(c) Formula
(d) Function
Answer:
(b) Code
Explanation:
In a spreadsheet the keystrokes recorded for macro are converted into an internal code that can be used later to perform the same task muLtiple number of times.
Macros are the recorded sequence of keystrokes that are saved for later use
(C) Which of the following cannot be done using Table Design view? [1]
(a) Adding fields
(b) Moving fields
(c) Adding data
(d) Changing field properties
Answer:
(c) Adding data
Explanation:
The Table Design view allows to edit the table design. Following actions can be performed in this view:
(i) Adding fields
(ii) Moving fields
(iii) Deleting fields
(iv) Changing field properties
The Table Design view shows the structure of a table. It shows the details of table such as Field name, Reid type and description.
(D) The …………….. constraint ensures that all values in a column satisfies certain condition. [1]
(a) Check
(b) Primary key
(c) Not null
(d) Default
Answer:
(a) Check
Explanation:
The CHECK constraint is used with CREATE TABLE command to verify that the value in a column satisfies certain condition. This constraint is totally optional, e.g. CREATE TABLE student CHECK (Stuld>0), Name varchar (30)
By default a column left blank stores NULL value. The NOT NULL constraint ensures that column does not have NULL value. The DEFAULT constraint provides a default value to a column.
The PRIMARY KEY is used to store unique values in a column.
(E) Which of the following feature are not helpful for people with hearing impairments? [1]
(a) Sound volume
(b) Closed captions
(c) Presentation tools
(d) None of these
Answer:
(c) Presentation tools
Explanation:
Presentation tools are helpful for the people with speech impairment Power Point is one such visual presentation tooL
Messaging tools and text-to- speech feature is also helpful for the people with speech impairment
(F) Which of the following does not allows e-ticketing [1]
(a) For watching movies
(b) For travelling by air
(c) Travelling by train
(d) Booking a bed in hospital
Answer:
(d) Booking a bed in hospital
Explanation:
E-ticketing refers to the online booking of tickets. It is a digital form of ticket.
The following requirements are to be fulfilled for e-ticketing:
(i) Access to the Internet
(ii) Online payment facility
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.
What is fatigue-related stress? Why is it difficult to avoid? (2)
Answer:
Fatigue-related stress builds up over a long time and can take a heavy toll on our bodies. It is caused 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, you will become a victim of fatigue-related stress. It is difficult to avoid because many people feel that it is out of their control.
Question 7.
Suhas is ready with his startup plan for pearl farming. He has a big vision regarding his business but does not have enough money to give it a start. Help him by suggesting the financing options for his startup. [2]
Answer:
There are majorly three different ways to finance a startup. These are as follows:
- Equity Financing: it means raising funds for a startup against equity. The financer becomes co-owner of the startup with some percentage of the share.
- Debt Financing: This means the funds are raised through debts from different financial institutes. E.g. loan from a bank.
- Government grant and Support: If the owner is ready with maximum funds then he can go for grants and loans available through different government schemes. E.g. Startup India
Question 8.
Rohan’s father told him that they need to attach a modem for internet connection on their computer explain the meaning and function of modem to Rohan.
Answer:
The word modem is derived from its function modulator/demodulator. The modem is a device that converts digital computer signals into analog signals that can travel over telephone lines. It also reconverts the analog signal to digital signals at the receiving end.
Question 9.
How can individuals acquire green skills? (2)
Answer:
Individuals can acquire green skills through education and training programs focused on sustainability, attending workshops, gaining practical experience, and staying updated with environmental developments.
Question 10.
What are the measures to increase the performance of a computer system?
Answer:
The performance of a computer can be increased by removing any extra files such as temporary files and images. We can use some disk cleaner software, which helps us clean up the unnecessary files.
Answer any 4 out of the given 6 questions in 20 – 30 words each.
Question 11.
Discuss the advantages of a template. [2]
Answer:
Templates are useful for the following reasons:
(i) Templates simplify the process of document creation.
(ii) Templates can ease our workload and also increase efficiency.
(iii) Templates increase the attention of the audience.
(iv) They also help in saving time and money.
(v) Templates improve clarity and ensure that all documents have the same layout.
Question 12.
What is the difference between absolute and relative hyperlinks as used in Calc? (2)
Answer:
Hyperlinks can be stored within your file as either relative or absolute. An absolute link will stop working only if the target is moved. A relative link will stop working only if the start and target locations change relative to each other. For instance, if you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will not break but an absolute link will break.
Question 13.
What do you understand by relationships in DBMS? How many types of relationships are there? [2]
Answer:
In a DBMS relationships are defined links that associate two tables through a common field. A relationship joins the two tables virtually forming one large table. There are three types of relationships:
(i) One-to-one
(ii) One-to-many
(iii) Many-to-many
Question 14.
What is the use of the consolidated data tool in calc?
Answer:
Data consolidation is a feature that allows you to collect data from different worksheets to one single sheet in the same workbook. This feature also allows the user to perform operations like sum, average, max, min, product, etc on the data to be consolidated.
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 the 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.
Define the following terms.
(i) P2P (ii) DBMS
(iii) Primary Key (iv) Foreign Key
Answer:
(i) Peer to Peer (P2P) architecture Network in which all the computers have an equal status is called peer to peer network. Generally, in such a network, each terminal has an equally competent CPU.
(ii) DBMS – Database Management System is a computerized record-keeping system that enables to create, store, modify, and extract information from a database.
(iii) Primary Key – A primary key is a unique value that identifies a row in a table. A primary key is indexed in the database making it faster for the database to search for a record.
(iv) Foreign Key – The foreign key identifies a column or set of columns in one table that refers to a column in another table. In other words, we can say that the primary key field of one table is also often present in the second table and so it becomes the foreign key of the main table.
Answer any 3 out of the given 5 questions in 50- 80 words each. (4 × 3 = 12)
Question 17.
How can a macro be created, and executed, and what are two advantages of using macros in spreadsheet software? [4]
Answer:
(1) Steps to create a macro are as follows:
(i) Click Tools -> Macros -> Record Macro.
(ii) Start recording of actions in a macro and display Record Macro toolbar with one icon on it to Stop Recording.
(iii) Now start performing the actions you want to include in a macro.
(iv) Click Stop Recording button after completing the actions.
(v) Now type the name of the macro in the Macro Name box and click on Save.
(2) Steps to run a macro are as follows:
(i) Open the worksheet in which you want to run a macro.
(ii) Click Tools -> Macros -> Run Macro
(iii) Select the name of the macro from the list of macros and click on Run button.
(3) Advantages of macros are as follows:
(i) It automates the keystrokes and tasks that are done repeatedly.
(ii) It reduces the time spent on repetitive computing tasks.
Question 18.
Riddhima wants to know about mailing labels in a word processor. Help her to find the answers to the given questions. (4)
(a) What is a mailing label?
(b) What are the ways to prepare and print mailing labels?
Answer:
(a) Mailing labels are usually pieces of paper with adhesive on the back that can be affixed to packages or envelopes to identify the name and address of a recipient. They may also indicate the name and address of the person sending the mail. Mailing labels are extremely useful and time-saving for the people who must send out a large volume of mail.
(b) Mailing labels can be created in two ways:
- Printing multiple copies of a single label
- Printing address lists where each label contains a different address
Question 19.
Given below is the structure of a table namely Books:
| Book ID | Integer |
| Name | Varchar (40) |
| Author | Varchar (25) |
| Price | Decimal |
(A) Explain the use of Varchar.
(B) Write SQL queries to:
(i) Create the table Books with Book ID as primary key.
(ii) Insert record with given details (‘12091’, “Panchtantra”, “Vishnu Sharma”, ‘250.00’)
(iii) Change the column Name to Book Name. [4]
Answer:
(A) Varchar is a datatype in SQL that is used to store character strings of variable length in a database. The size parameter specifies the maximum length of the string field.
(B) SQL Commands:
(i)
CREATE TABLE BOOKS (Book ID Integer PRIMARY KEY,
Name Varchar (40),
Author Varchar (25),
Price Decimal):
(ii) INSERT INTO Books VALUES (12091, “Panchtantra”, “Vishnu Sharma”, 250.00);
(iii) ALTER TABLE Books RENAME Name TO Book Name;
Question 20.
Given the following Spreadsheet, Write the appropriate Formula/Expression/Function to be used for the following- [CBSE 2020]
(a) Write the formula to calculate the Total Sales of North Zone.
(b) Write the feature used for arranging the sales from Lowest to the Highest
(c) Write the formula to find the Maximum Sales in East Zone in cell G5.
(d) Write the formula to find the Average Sales in Jan-Mar in cell C7.
(e) Write the formula to find the difference between the sales in the East Zone and the West Zone in April-Jun in cell H5.
Answer:
(a) =Sum(B3:E3)
(b) Sort
(c) =MAX(B5:E5)
(d) =AVERAGE(B3:B6)
(e) =C5-C4
Question 21.
Rahul has purchased some stationary items from an online site. He has to make online payment for the items to complete the transaction. Help him by answering the following queries: (4)
(i) Suggest any two options that he can use to make payment of his bill on the online shopping website.
(ii) Name any 2 situations where online shopping could be useful.
(iii) Name any 2 popular online shopping websites.
(iv) Write the full form of COD about online shopping.
Answer:
(i) Credit, debit card, Internet banking, etc are the options that he can use to make payment of his bill on the online shopping website.
(ii) (a) They offer huge discounts on goods and services.
(b) Online shopping saves time and effort to buy products of one’s choice.
(iii) Flipkart and Amazon are two popular online shopping websites.
(iv) COD stands for Cash On Delivery. Cash on delivery is the sale of goods by mail order where payment is made at the time of delivery rather than in advance.