CBSE Sample Papers for Class 10 IT Set 7 with Solutions

Students must start practicing the questions from CBSE Sample Papers for Class 10 IT with Solutions Set 7 are designed as per the revised syllabus.

CBSE Sample Papers for Class 10 IT Set 7 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) Which of the following is not an OS? [1]
(a) Android
(b) Windows
(c) AVG
(d) Linux
Answer:
(c) AVG

Explanation:
AVG is an Antivirus Software. An antivirus software is a computer program that is used to prevent, detect and remove virus and other malware programs.

Related Theory: Android is mobile operating system whereas Windows and Linux are operating systems for PCs and laptop.

(B) Self confidence is a quality which develops due to …………………….. [1]
(a) Self-monitoring
(b) Self-Regulation
(c) Self-awareness
(d) All of the above
Answer:
(c) Self-awareness

Explanation:
Self-awareness is all about knowing your emotions, your personal strengths and weaknesses. Being more clear about where we are strong helps in boosting confidence because it helps us in focusing on doing what we’re good at, which increases our overall sense of confidence.

(C) Suhas works as an app developer in an IT company. His manager appreciates his work and always keeps on telling him that he has one quality which can make him a good entrepreneur. Which among the following can be that quality? [1]
(a) Innovative and open minded
(b) Good looking
(c) Well Educated
(d) All of these
Answer:
(a) Innovative and open minded

Explanation:
Entrepreneurs are creative or innovative and are always open to new ideas. In addition, they are risk taking, self- motivated and committed towards their work.

(D) Rajendra Singh is a Sub Inspector in UP Police. His job forces him to deal with various types of criminals on regular basis. Sometimes he is very stressed out from his routine work. What among the following can be done to release his stress? [1]
(a) Healthy diet and life style
(b) Meditation
(c) Positive thinking and outlook
(d) All of these
Answer:
(d) All of these

Explanation:
All the-given options are the techniques of stress management. Physical exercises like yoga, taking a sound sleep and spending a vacation are also forms of stress management.

Related theory: Stress is a reaction of our body in the situations when we feel under pressure. Stress can be both good and bad.

(E) The shortcut key used to create a duplicate copy of file is …………………….. [1]
(a) Ctrl + X
(b) Ctrl + C
(c) Ctrl + V
(d) Ctrl + U
Answer:
(b) Ctrl + C

Explanation:
Copy means to create a duplicate copy of a file in the same or in another folder. To copy one or more files first select the file (s) and then click on Copy command. Alternatively, you can press a shortcut key Ctrl + C from the keyboard.

(F) Ramesh owns a showroom of electronic items. Sharad, his friend, owns a small shop of home appliances. Sharad does not call himself an entrepreneur. What type of misconception is this? [1]
(a) Every business idea needs to be unique or special.
(b) Entrepreneurs are born, not made.
(c) A person needs to have a big business ‘to be called an entrepreneur.
(d) It is not a misconception
Answer:
(c) A person needs to have a big business to be called an entrepreneur.

Explanation:
It is a misconception that for being an entrepreneur, a person needs to have a big business. But the fact is that no business is big or small. If a person is running a business to fulfil a customer need, they are called an entrepreneur.

Question 2.
Answer any 5 out of the given 6 questions.
(A) …………………….. styles impact the structure of the document. [1]
(a) Character
(b) Page
(c) Paragraph
(d) Frame
Answer:
(b) Page

Explanation:
Page styles are used to organize the structure of the document, adds page numbers etc.

Caution:
Frame style is not used to change the structure of the document. It formats text and graphic frames.

(B) A template is a blue print to create …………………….. [1]
(a) Table
(b) Table of contents
(c) Styles
(d) Another document
Answer:
(d) Another document

Explanation:
A template is a blue print or model document containing pre defined formatting features like headers, footers, styles, bullets etc. You can use a template to create as many documents as you.want.

(C) …………………….. refers to a range of cells. [1]
(a) Row
(b) Column
(c) Cell reference
(d) Formula
Answer:
(c) Cell reference

Explanation:
A cell reference refers to a cell or range of cells that are used in formulas for calculations and other operations. E.g. = Sum(Al:B7)

Related theory:
A cell reference may include reference from same worksheet or from another worksheet of same workbook.

(D) …………………….. is a storage container which stores data that belongs to a simple object, subject or purpose. [1]
(a) Database
(b) Table
(c) Record
(d) Field
Answer:
(b) Table

Explanation:
A table is a collection of related data stored in a tabular format within a database. It consists of columns and rows known as fields and records respectively.

(E) …………………….. option in Windows 10 is used to turn off animations and background images. [1]
(a) Narrator
(b) Closed captioning
(c) Magnifier
(d) Other options
Answer:
(d) Other options

Explanation:
Clicking on Ease of Access → Other options will show some options, from where you can turn off animations and background images.

Related Theory:
With animations and background the PC seems to work a bit slow. If you would like an instant response, you can disable the animations for a snappier desktop experience.

(F) …………………….. is a group of computers that are connected in small area with the help of some cables. [1]
(a) LAN
(b) WAN
(c) VAN
(d) RCN
Answer:
(a) LAN

Explanation:
Local Area Network (LAN) is a small computer network built in localised area only. E.g. an office building, a shopping mall computer lab of school etc.

Related Theory:
A Value Added Network (VAN) is a private, hosted service that that focuses On offering network services such as secure email, message encryption and management reporting. It provfdes a convenient way for ecommerce businesses to securely communicate and share data.

Question 3.
Answer any 5 out of the given 6 questions.
(A) Which function cannot be performed through Subtotal in a Spreadsheet? [1]
(a) Sum
(b) Product
(c) Average
(d) Percentage
Answer:
(d) Percentage

Explanation:
The Subtotal function is used to summarise the values according to groups. It can perform functions like Sum, average, max, min, count etc.
It cannot use Product function.

(B) Sarita is a poet. She wants her poems to reach the right people . For this she wants to start writing a blog. Which of the following sites can be used for the same? [1]
(a) Blogger
(b) WordPress
(c) TypePad
(d) All of the above
Answer:
(d) All of the above

Explanation:
All the given are free online blogging sites that allow users to write blogs.

Related Theory:
Some blogging sites provide offline blog editor that lets blogger create blog posts without an Internet connection. Some popular offline blogging. sites are BlogDesk, BlogJet Windows Live Writer etc.

(C) The description column in Table Design view is used to …………………….. [1]
(a) Define data type for each field.
(b) Describe data to be stored in each field.
(c) Describe criteria for storing data in the field
(d) None of these
Answer:
(b) Describe data to be stored in each field

(D) Consider the hyperlink- D:\Users\ Documents\mysheetxlsx. Identify the type of this document hyperlink. [1]
(a) Absolute
(b) Relative
(c) Fixed
(d) None of these
Answer:
(a) Absolute

Explanation: An absolute hyperlink is one which tells the complete path to reach a document starting from the top most folder.

Related Theory:
The hyperlink that tells the path of o document from active location is called relative hyperlink.

(E) The final document produced after mail merge is called …………………….. [1]
(a) Main document
(b) Data source
(c) Merged document
(d) Merge field
Answer:
(c) Merged document

Explanation:
The main document is the document that consists of Letter and merge fields whereas data source is the document that consists of name and other data of recipients.
Both the files are used for merging and the final letter is called merged document.

(F) Rohit has created 6 worksheets, in a single workbook, for each month for the sale of products in his shop. To check the half yearly sales, he needs to prepare a single worksheet. Which out of the following features will be helpful for him? [1]
(a) Goal Seek
(b) Consolidate
(c) Solver
(d) Macro
Answer:
(b) Consolidate

Explanation:
With the consolidate feature he can integrate all the sheets and can also add the values of all the sheets to get the final sheet with the summary of values into the new sheet.

Question 4.
Answer any 5 out of the given 6 questions.
(A) Why Styles are used in the document? [1]
(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

Explanation:
When styles are used in a document all paragraphs will have same font size, alignment, line spacing etc. If the formatting feature of style is changed then it is applied to all the text with that style.

(B) In a worksheet, while performing consolidation, if same data range is selected from multiple worksheets, then consolidation is done by [1]
(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.

Explanation:
When multiple worksheets are used and same range is selected from all the sheets then while consolidating it will perform addition on the selected range of cells and will show the aggregate summary form.

Related Theory:
If consolidation is done by selecting different ranges from the same worksheet, it simply clubs the ranges one below another.

(C) While creating a table in DBMS, which of the following is considered optional? [1]
(a) Field Name
(b) Description
(c) Data Type
(d) Field size
Answer:
(b) Description

Explanation:
The Description column in Table Design view is used to describe the type of data stored in that specific field. It us used for documentation purpose and ‘ thus it is considered as optional.

(D) The structure of a table, once created, can be changed using …………………………. SQL command. [1]
(a) UPDATE
(b) SET
(c) MODIFY
(d) ALTER TABLE
Answer:
(d) ALTER TABLE

Explanation:
The ALTER TABLE command is used to modify the table structure according to the following syntax.
To add a new column:
ALTER TABLE <tablename> ADD
<columnname> <datatype> <size>
[<constraint name>]
To modify existing columns:
ALTER TABLE <tablename> MODIFY .
(columnname newdatatype (new size)
[FIRST/AFTER column]
To change the name of one of your columns:
ALTER TABLE <tablename> CHANGE
[COLUMN] old_column_name new_ column_name column_definition

(E) Which of the following is not a type of blog? [1]
(a) Macro
(b) News and views
(c) Personal
(d) Company
Answer:
(a) Macro

Explanation:
There are four types of blogs:

Personal blog
Company blog
News and views blog
Micro blog

(F) 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? [1]
(a) HTTPS
(b) FTP
(c) HTTP
(d) Any of these
Answer:
(a) HTTPS

Explanation:
The HTTPS in the beginning of the URL ensures that the information shared with the site will not be leaked or compromised. The URL with HTTPS are considered to be a secure connection.

Question 5.
Answer any 5 out of the given 6 questions.
(A) To insert a downloaded image from Google into a document …………………………. option of word processor is used. [1]
(a) Drawing objects
(b) Pictures
(c) Any of these
(d) None of these
Answer:
(b) Pictures

Explanation:
Pictures are graphics that are created using specific programs or are downloaded from the internet These includes bitmaps, scanned pictures, camera pictures etc.

(B) To connect the data in form of HTML page, which of the following should be done? [1]
(a) Copy and paste the data in a workbook.
(b) Create a document hyperlink for the HTML document.
(c) Create link for the required components using link to external data.
(d) All of these
Answer:
(c) Create link for the required components using link to external data.

Explanation:
In spreadsheet you can link your worksheet to external data such as components of HTML page. This can be done by clicking on Insert → Link to External data.

(C) When a primary key contains more than one field, it is called …………………………. key. [1]
(a) Alternate
(b) Foreign
(c) Candidate
(d) Composite
Answer:
(d) Composite

Explanation:
A composite key is a DBMS key having two or more fields that together can uniquely identify a record in a table. Such a key is also known as Compound Key.

Related Theory:
An alternate key is a secondary candidate key that is capable of identifying a row uniquely. However, such a key is not used as a primary key, as we have only one primary key in a table.

(D) …………………………. is arranging data in order. [1]
(a) Filtering
(b) Sorting
(c) Reporting
(d) Querying
Answer:
(b) Sorting

Explanation:
Sorting refers to the method of arranging a group of items in ascending or descending order. It helps in analysing the data more effectively.

Related Theory:
Filtering is the process that allows you to view only the data you want to See. When you create a filter, you set criteria for the data you want to display.

(E) SQL sands for …………………………. [1]
(a) Structured Query Language
(b) Simple Query Language
(c) Structured Quick Language
(d) Simple Quick Language
Answer:
(a) Structured Query Language

Explanation:
SQL is a standardized programming language that is used to manage relational databases and lets you access and manipulate databases.

(F) Which of the following impairments effects the computer usage? [1]
(a) Speech
(b) Vision
(c) Mobility
(d) All of these
Answer:
(d) All of these

Explanation:
There are numerous types of physical disabilities that impact computer usage. These include:
(i) Cognitive impairments and learning disabilities, such as dyslexia, ADHD or autism.
(ii) Visual impairment such as low-vision, complete or partial blindness, and color blindness.
(iii) Hearing impairment including deafness
(iv) Motor or dexterity impairment such as paralysis, repetitive strain injury etc.

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.
There are some myths about Entrepreneurship. Mention any four of them. [2]
Answer:
Myths regarding entrepreneurship are as follows:
1. Every business idea needs to be unique or special: A person can take an existing idea in the market and do something different with it

2. A person needs a lot of money to start a business: Entrepreneurship is about passion, commitment and execution of idea. Money related problems can be solved by funding, debts, loan, investors etc

3. Entrepreneurs are born talented: Entrepreneurship starts with thinking of an idea that you want to work on and making it different. A person who is self-aware and can develop certain qualities can become an entrepreneur.

4. It is an easy way to get rich: Entrepreneurship does not mean making quick money. It needs patience and time to make a business successful Sometimes the venture results into failure.

Question 7.
Define organisational skills. Name some of the organisational skills. [2]
Answer:
Organizational skills are the skills of using the available resources efficiently and effectively. Being organized refers to managing time, energy and workspace well and completing all the assigned tasks successfully. Organizational skills can vary depending on a particular workplace and job title, but they typically involve maintaining an orderly workspace, meeting deadlines and communicating well with the team.

Types of organizational skills are: Time management, Communication, Setting goals, Self-motivation, Decision-making and Strategic planning.

Question 8.
Explain ‘M’ in SMART. [2]
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
usier to track the progress.

Question 9.
What is the importance of time management? [2]
Answer:
Time management is important due to following benefits:

It helps us to prioritize the tasks and allot required time to complete the task.
Properly scheduling the time helps in completing the work in due time.
Good time management gives us enough time to accomplish the tasks. This helps in reducing the stress levels.
Timely accomplishment of tasks ensures the confidence and effciency of workforce.
Time management also improves the performance of workforce.

Question 10.
Briefly explain the terms:
(A) Worms
(B) Trojan Horse [2]
Answer:
(A) Worms: Worms is a type of computer virus that does not modify the program like virus does. Its main objective is to eat the system resources. It replicates itself more and more and slows down the computer system.

(B) Trojan: A Trojan Horse is also a type of malware which uses fake names to mislead users from its true intent and execute them. Trojan Horses generally gets installed on the system as legitimate and useful software and gives unauthorised access and control of the system to the hackers.

Answer any 4 out of the given 6 questions in 20 – 30 words each.

Question 11.
Differentiate between a web server and a web client. [2]
Answer:

Web Server	Web Client
A web server is a computer that serves web pages, web sites or web services.	A web client is a user program that con¬nects to a server to access a service.
It receives requests from the client computer, processes and sends the output.	It sends requests to the web server and uses the services provided by the server.

Question 12.
What do you understand by the following: [2]
(a) Magnifier
(b) Speech recognition
Answer:
(A) Magnifier: Magnifier is a tool of Windows that makes the part of computer screen or an entire computer screen bigger. Using this tool the images and words can be seen better. This tool is an accessibility feature for people with low vision impairments.

(B) Speech recognition: Speech recognition is a tool of windows that identifies the words spoken aloud and then convert them into readable text. People who are visually impaired can use this tool to type text by speaking the words and sentences to the system.

Question 13.
When would you create a link to data in external worksheet. [2]
Answer:
When you are working on multiple worksheets, there would be a situation when you would like to use data of one sheet into another. Linking will dynamically pull data from one sheet to another. It will also update the data in your destination sheet whenever you change the contents of a cell in your source sheet.

Question 14.
Write differences between a flat file database and a relational database. [2]
Answer:

Flat File Database	Relational Database
In flat fie 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 relational database.

Question 15.
What are Clip arts? List any two websites that offer free clipart. [2]
Answer:
(A) WiMax: WiMAX technology is a wireless broadband communications technology. It is an alternative to wired broadband, such as DSL and cable modem. It can provide broadband wireless access from 5 to 50 km. It requires a tower similar to a mobile base station. Internet connectivity is provided through microwaves.

(B) Wifi: Wifi refers to Wireless Fidelity which lets you connect to the internet without a direct line from your PC to ISP. Any Wifi connection requires: A broadband internet connection, A wireless router which relays internet connection from the wall mounted device to the PC, a laptop or desktop with a wireless internet card.

Question 16.
Differentiate between goal seek and solver. [2]
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 each.

Question 17.
Jaskeerat is a smart worker. He keeps on updating his knowledge and uses it to uplift his work practices. As a data entry operator, he has to perform similar tasks on a group of worksheets. [4]
(A) How will Macros help him to do his work faster?
Answer:
Macros are used to record the sequence of commands or keystrokes and save it for later use. These automate the repetitive keystrokes and tasks and thus reduces time spent in repetitive tasks and makes the work faster.

(B) Using his programming skills, he wants to make some changes in macro that he has created. How can he do it?
Answer:
To make changes in Macro he first needs to open the code of macro which he has created using the Macro dialog box. It will display the code of Macro in the editing window, where he can edit the code as needed.

(C) How can he write a macro as a function?
Answer:
To use the macro code as a function the code is written between the clauses Function and End Function.
E.g.
Function Dept()
Dept()= “Production”
End Function

(D) How are keystrokes stored in a macro?
Answer:
Calc internally creates equivalent commands for the recorded keystrokes and stores in a programming code. These codes are stored inside Sub and End Sub clauses.

Question 18.
Vinay has to prepare a sales report in which he has added some images. The size of the image is too large so he wants to resize the image?
(A) Which option of word processor will change the size of image from both the dimensions?
Answer:
You can resize an image using sizing handles. If corner sizing handles are used, then the image will be resized from both the dimensions. You can also resize the image from the menu. While resizing the image from the menu click on “Keep image size” or “Keep Ratio” option in word processor. This will maintain the ratio while changing the size of the image.

(B) Which tool he should use to keep the image in the centre of the text?
Answer:
To place the image between text, you can use Text Wrapping features. There are many options e.g. behind. After, top/ bottom etc. To place the image in the center of the text click on “Wrap through” option in Text Wrap settings.

(C) He wants to keep the image in the background with a transparent effect on it. Which tool should he use?
Answer:
The image can be made transparent and kept in the background of the text. To perform this you have to change the Color Mode of the image. By changing the Color Mode to Watermark the image will be totally transparent that and will give the background effect with text placed on it.

(D) He wants to give a title to his report. Which tool offers artistic style of text? [4]
Answer:
The decorative text can be added using Text Art/ Word Art feature of the word processor. This feature creates shadowed, skewed, rotated and stretched text in variant colours.

Question 19.
Given below is the structure of a table named Library: [4]

MemID	CHAR(7)
MemName	VARCHAR(25)
BookID	CHAR(7)
IssueDate	DATE
Return	CHAR(l)

(A) What is the difference between Char and Varchar?
Answer:
A CHAR is a fixed length string data type, while VARCHAR is variabLe length string data type. In CHAR data type if the If the length of the string is less than fixed length then it is padded with extra blanks while, in VARCHAR, If the length of the string is less than the fixed length then it will store as it is without padded with blanks.

(B) Write SQL queries to:
(a) Create the table Library with Primary key MemID and the default value of Return as “N”.
(b) Add record with given details (“M101”, “Manya Gupta”, “B1151”, “2022-09-06”, “N”)
(c) Change the value of Return as “Y” in the record of “Manya Gupta”.
Answer:
(i) CREATE TABLE Library (MemID Char(7) • PRIMARY KEY,
MemName VARCHAR(25) BooklDCHAR(7)
IssueDate DATE
Return CHAR(l) DEFAULT “N”)
(ii) INSERT INTO Library VALUES (“M101”, “Manya Gupta”, “B1151”, “2022-09¬06″, “N”)
(iii) UPDATE Library SET Return =”Y” WHERE MemName= “Manya Gupta”

Question 20.
Mohan is a shoe manufacturer and also runs his factory outlets. The company uses databases to maintain the sales records of their product. The data operator who enters the records of daily sales does not know how to work on tables in datasheet view. [4]
(A) What can be the other way to enter and modify the records in database?
Answer:
Form view can also be used to enter and modify records in database. It is an interactive screen which allows user to work on single record at a time.

(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?
Answer:
To view records based on a particular condition, queries are used in database.

(C) The manager wants the hard copy of sales for present month. Name the feature to perform this.
Answer:
To print the records, database provides Reports feature. Reports are the effective way to prin records in formal and formatted way.

(D) What is the difference between a Query and Report?
Answer:
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.
Suhail uses Internet for his School Project but he is not aware of security issues regarding the Internet. Help him by solving the following queries. [4]
(A) What is a secure connection?
Answer:
A secure connection is one that is designed to protect data sent between two computers through the internet. It ensures the confidentiality of information and also that the data is made accessible only to authorized users.

(B) How you can recognize a secured connection?
Answer:
A URL or web address that contains HTTPS and a pad lock sign is considered to be a secured connection.

Use strong passwords because strong passwords are not easy to hack and avoids unauthorisd entry to your account.
Control access to data and systems by giving authorization. This can be done by providing login ids and password to authorized users.
Put up a firewall. A firewall is a security wall in form of software that checks and prevents malicious software to enter into system.

(D) What is Firewall?
Answer:
A firewall is a software for network security that controls incoming and outgoing network traffic and permits or blocks data packets based on security.