Students must start practicing the questions from CBSE Sample Papers for Class 10 Information Technology with Solutions Set 3 are designed as per the revised syllabus.
CBSE Sample Papers for Class 10 IT Set 3 with Solutions
Max. Time : 2 Hours
Max. Marks: 50
Section A
Objective Type Questions
Question 1.
Answer any 4 out of the given 6 questions on Employability Skills. (1 × 4 = 4 Marks)
(i) ………….. operating system enables multiple users to work on the same computer at different times or simultaneously.
(a) Multiprogramming.
(b) Multiprocessors.
(c) Multi-user
(d) Multi-tasking
Answer:
(c) Multi-user
(ii) ………….. is a series of postures and breathing exercises practiced to achieve control of body and mind.
(a) Meditation
(b) Nature Walk
(c) Yoga
(d) Physical Exercise
Answer:
(c) Yoga
(iii) From the following statements, which one is not correct about the Qualities of an entrepreneur …………..
(a) Successful entrepreneurs adapt the habit of hard work from a very early stage.
(b) Entrepreneur should not think optimistically about the future of the business.
(c) Confident entrepreneur must not deviate from his/her decisions too early in case success is delayed.
(d) Entrepreneurs like to function at their own will and rules.
Answer:
(b) Entrepreneur should not think optimistically about the future of the business.
(iv) To remove the files of temporary folder, we type in Run dialog box after pressing “Windows button + R” on the keyboard.
(a) #temp#
(b) %temp%
(c) e $temp%
(d) &temp&
Answer:
(b) %temp%
(v) ………….. is not the quality of self-confident people.
(a) Dependent
(b) Positive Attitude
(c) Hard Working
(d) Commitment
Answer:
(a) Dependent
(vi) From the following statements, which one is not the positive impact of Entrepreneurship on society:
(a) Stimulates Innovation and Efficiency
(b) Creates Jobs and Employment Opportunities
(c) Solves the problems of the society
(d) Discourages welfare of the society
Answer:
(d) Discourages welfare of the society
Question 2.
Answer any 5 out of the given 6 questions. (1 x 5 = 5 marks)
(i) A key is used to reduce repetitive strain.
(a) Sticky
(b) Serial
(c) Mouse
(d) Toggle
Answer:
(a) Sticky
(ii) ………….. means that the query uses criteria you provide to hide some data and display only required data.
(a) Filtering
(b) Report
(c) Sorting
(d) Forms
Answer:
(a) Filtering
(iii) Which of the following application is not appropriate to store data about ABC Bank customers?
(a) Open Office Base
(b) Open Office Writer
(c) MS Access
(d) MS Excel
Answer:
(b) Open Office Writer
(iv) When you open a new spreadsheet, by default, it has a sheet named ………….. which is managed using tabs at the bottom of the spreadsheet.
(a) Sheet 1
(b) Worksheet 1
(c) Untitled 1
(d) New Sheet 1
Answer:
(a) Sheet 1
(v) In a word processor, ………….. option is selected for a scaled resizing of an image.
(a) Original Size
(b) Image Size
(c) Keep Ratio
(d) Relative
Answer:
(c) Keep Ratio
(vi) Multiple copies of the same file leads to …………..
(a) Data Inconsistency
(b) Data Redundancy
(c) Data Consistency
(d) Foreign Key
Answer:
(b) Data Redundancy
Question 3.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) It is a reference point for the graphics which is created while positioning any image. This point could be the page, or frame where the object is either a paragraph, or even a character in a word processor.
(a) Wrap Text
(b) Anchoring
(c) Alignment
(d) Book Mark
Answer:
(b) Anchoring
(ii) Identify the property which help to set the number of characters in text/varchar type field of a table in DBMS.
(a) Entry Required
(b) Size
(c) Default Value
(d) Length
Answer:
(d) Length
(iii) ………….. is designed to help users with auditory impairments.
(a) Sound Sentry
(b) Serial Key
(c) High Contrast
(d) Show Sounds
Answer:
(a) Sound Sentry
(iv) State whether True or False
“It is not possible to create a default template in a Word processor”
(a) True
(b) False
Answer:
(b) False
(v) Reviewers and authors can add their ………….. to explain their changes in the cell of Spreadsheet
(a) Comments
(b) Worksheet
(c) Hyperlink
(d) Macros
Answer:
(a) Comments
(vi) In Calc, Arguments passed to a macro from Calc are always
(a) Cell Reference
(b) Both (a) and (b)
(c) Value
(d) Sheet Reference
Answer:
(c) Value
Question 4.
Answer any 5 out of the given 6 questions. (1 × 5 = 5 Marks)
(i) Identify the website that offers offline blog service for free.
(a) Blogdesk
(b) Qumana
(c) Word Press
(d) both (a) and (b)
Answer:
(d) both (a) and (b)
(ii) John has written a book consisting of fifteen chapters. He wanted to make the index of the book. Suggest him the option used to create the index automatically in a word processor.
(a) Tables
(b) Columns
(c) Mail Merge
(d) Table of Content
Answer:
(d) Table of Content
(iii) The length of the field value of text data type is ………….. characters by default in DBMS.
(a) 10
(b) 25
(c) 20
(d) 50
Answer:
(d) 50
(iv) A healthy lifestyle helps to keep and improve people’s health and well-being. It does not include:
(a) Healthy eating habits
(b) Physical activities
(c) Stress management
(d) Less sleep
Answer:
(d) Less sleep
(v) In a spreadsheet using to create a hyperlink to a web FTP or Telnet, click on the icon available in Hyperlink dialog box.
(a) browser
(b) Internet
(c) hyperlink
(d) mail & news
Answer:
(b) Internet
(vi) A refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate.
(a) Cell Reference
(b) Sheet Reference
(c) Block
(d) Autofill
Answer:
(a) Cell Reference
Question 5.
Answer any 5 out of the given 6 questions. (1 × 5 = 5)
(i) ………….. identify the mode, where we can modify in the structure of table?
(a) Datasheet view
(b) Design view
(c) Structure view
(d) All of these
Answer:
(b) Design view
(ii) BSNL stands for …………..
(a) Bihar Sanchar Nigam Limited
(b) Bharat Samachar Nigam Limited
(c) Bharat Sanchar Nigam Limited
(d) None of these
Answer:
(c) Bharat Sanchar Nigam Limited
(iii) ………….. function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.
(a) Data Combination
(b) Data Consolidation
(c) Data Merging
(d) Data Concatenation
Answer:
(b) Data Consolidation
(iv) ………….. store data in a single table which is suitable to store less amount of Data.
(a) Flat File
(b) Relational
(c) Mini File
(d) Single File
Answer:
(a) Flat File
(v) In a word processor, by default, evaluates ………….. levels of headings when it builds the table of contents.
(a) 2
(b) 10
(c) 1
(d) 12
Answer:
(b) 10
(vi) In ………….. Networks, all computers have an equal status and each terminal has an equally competent CPU.
(a) MAN
(b) WAN
(c) Client Server
(d) P2P
Answer:
(d) P2P
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.
What are the advantages of the ability to Work Independently?
Answer:
The advantages of the ability to Work Independently:
- Ensures greater learning.
- Individuals feel more empowered and responsible.
- It provides flexibility to choose and define working hours and working mechanisms.
- Failure and success of the task assigned are accounted by individuals.
- Individuals become assets to organizations, groups and nations at large.
- It ensures creativity and satisfaction amongst individuals.
Question 7.
Name the Stress causal agents.
Answer:
The causal agents of stress are:
- Mental: Mental stress may occur due to conflicts, frustration, internal or social pressure etc.
- Physical: Physical stress occurs due to overexertion, some kind of illness or failure to get enough sleep
- Social stress is caused due to external factors such as disturbed relationships, conflicts with others, death or illness in family etc.
- Financial : Financial stress occurs due to money problems.
Question 8.
What do you mean by Disk Defragmentation?
Answer:
A disk defragmentation removes all unnecessary information that slows down the computer. It should be done at regular intervals which helps the disc space to be used at an optimal level.
Question 9.
Explain any two Myths about Entrepreneurship.
Answer:
Myths about Entrepreneurship are:
1. The misconception is that every business idea needs to be unique or special : Each entrepreneur saw customer demand and brought a new idea into their business. A person can take an idea that is already there in the market and do something different with it.
2. The misconception we have is that a person needs a lot of money to start a business : Every business does not need a lot of capital to start. Depending on how much more, you have or can borrow, you can put that into business with that much money. Once you make more money, you can put that into your business to make it bigger.
3. A misconception we have is that only a person having a big business is an entrepreneur : No business is big or small. If a person is running a business to fulfill a customer’s need, they are an entrepreneur. Most businesses start small. It becomes big with hard work and creativity.
4. A misconception we have is that entrepreneurs are born, not made : Only some people have the talent for doing business. An entrepreneur is a person who does whatever it takes to make the business successful.
Being an entrepreneur starts with a way of thinking. You must believe that anything is possible and it shall be achieved. It starts with thinking of an idea that you want to work on, making it different: (Any two out of four Myths can be explained)
Question 10.
Write any four roles of Entrepreneurs.
Answer:
Roles of Entrepreneurs are:
- Coordinating role
- Agent’s role
- Innovator’s Role
- Risk assumption role
- Imitating role
- Capital formation role:
- Employment Generation role
Answer any 4 out of the given 6 questions in 20-30 words each (2 × 4 = 8 Marks)
Question 11.
State any two purposes of using Templates in a word document.
Answer:
A template is a model document that is used to create other documents. The templates are used to create documents due to following reasons:
- It saves time and effort required for formatting.
- It increases the attention of the audience by providing preformatted documents.
Question 12.
Mention any two operations that can be performed using Macros in a spreadsheet.
Answer:
Macros are used to perform different types of operations in a Spread sheet:
- Formatting settings to be applied repeatedly in a spreadsheet
- Sorting Data
- Applying any Mathemaiical functions/formulas
Question 13.
What do you mean by Hyperlinks in Spreadsheets? Give the two different types of Hyperlinks, that can be used in Spreadsheets.
Answer:
Hyperlinks can be used in Calc to jump to a ‘different location from within a spreadsheet: and can lead to other parts of the current file, to different files. It can be stored wthin a file as either Relative or Absolute hyperlinks.
Question 14.
List Numeric and Alphanumeric Datatypes in OpenOffice Base.
Answer:
Numeric datatypes are: Tinylnt, Smalllnt, Integer. Biglnt, Decimal, Real, Float, Double and Boolean.
Alphanumeric Datatypes are: Char(fix), Varchar, Varcharignorecase and Long varchar(Memo).
Question 15.
Differentiate between Filter keys and Toggle keys in Microsoft Windows?
Answer:
Filter Keys is an accessibility function that tells the keyboard to ignore brief or repeated keystrokes, making typing easier for people with hand tremors.
ToggleKeys is an accessibility function which is designed for people who have vision < impairment or cognitive disabilities. When ToggleKeys is turned on computer emits sound cues when the locking keys (Caps Lock, Num Lock, or Scroll Lock) are pressed.
Question 16.
In which situations Online shopping could be useful? Write any two popular e-commerce websites.
Answer:
Online shopping could be useful in situations when:
- A customer does not have sufficient time to visit stores.
- Visiting a store is more expensive than purchasing a product online.
- Two popular online transaction websites are:
Flipkart an online shopping portal for buying consumer products.
EBay, an online portal for buying and selling goods.
Answer any 3 out of the given 5 questions in 50-80 words each (4 x 3 = 12 Marks)
Question 17.
Anshita is preparing spreadsheet notes for her Term Exam. Help her to write short note on the following:-
1. Scenarios
2. Goal Seek
3. Solver
4. Subtotal
Answer:
1. Scenarios : Scenarios is a tool to test ‘what- if’ questions. Each scenario is named, and can be edited and formatted separately. It is essentially a saved set of cell values for your Calculations. You can easily switch between these sets using the Navigator or a drop¬down list which can be shown beside the changing cells.
2. Goal Seek : It is used to calculate a result based upon existing values. Using Goal Seek option under Tools menu, we can discover what values will produce the result that we want.
3. Solver : It is more elaborated form of Goal Seek The difference is that the Solver deals with equations with multiple unknown variables. It is specifically designed to minimize or maximize the result according to a set of rules that we define.
4. Subtotal: SUBTOTAL is a function listed under the Mathematical category when you use the function Wizard (Insert > function). Because of its usefulness, the function has a graphical interface.
SUBTOTAL totals/adds data arranged in an array that is, a group of cells with labels for columns and/or rows. Using the Subtotals dialog, you can select arrays, and then choose a statistical function to apply to them. For efficiency, you can choose up to three groups of arrays to which to apply a function.
Question 18.
Tanmay is a Class X student. He has learnt Mail Merge option of a Word Processor in his computer period. But he is confused with few terms used to merge documents.
Explain the following briefly, which will help Tanmay better understand the Mail Merge options.
(i) Merge Field (ii) Data Source (iii) Main Document
(iv) Mention two types of data on which mail merge can be applied.
Answer:
(i) Merge Field : A merge field is where you want to insert the information from a data source into a main document. Merge fields appear with chevrons (« »).
(ii) Data Source : Data source is a file that contains the names and addresses or any other information that vary with each version of a mail-merge document.
(iii) Main Document: Main document is the document which contains text and graphics. It may be a formal or an official letter.
(iv) Two types of data on which mail merge can be applied are Labels and Letters.
Question 19.
Consider the following table : Sales
Tablee 1
(A) How many fields and records are there in Sales table?
(B) Write SQL commands for the following:
(i) Display Sales ID and price of all products whose discount is more than 1000.
(ii) Display the details alphabetically by product name.
(iii) Display product name and sales price after deducting the discount from the price.
Note : Sales price can be calculated as (price-discount)
Answer:
(A) Four fields and four records are there in table Sales.
(B) SQL commands:
(i) select Sale_Id, Price from Sales where Discount > 1000;
(ii) select * from Sales order by Prod_Name;
(iii) select Prod_Name, Price-Discount as sales price from Sales;
Question 20.
Your friend owns a chemist shop, he needs to keep records of the medicines with their id’s, date of purchase, expiry date, price, etc. in a database program. But he does not have any knowledge about the database. Explain to him the following to get a better understanding of the DBMS concepts.
(A) What is DBMS? Explain in brief.
(B) Name any two database programs which can be used to create a table and store the data as per the requirement.
(C) Which field can be set as a Primary Key?
(D) Is it possible to make more than one field as a primary key in your table? (Yes/No). Justify your answer.
Answer:
(A) A database management system is a software package with computer programs that controls the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications.
(B) Two databases are:
(a) Microsoft Access
(b) MySQL
(c) Open Office Base
(C) Id field will be suitable for Primary Key.
(D) Yes. we can make more than one column as a primary key in a table and it is known as Composite Primary Key.
Question 21.
Vicky is a student of class X. He used to get the work based on internet surfing, But he is not aware of the internet and its terminology. Being a friend of Vicky, help him in finding the answers of the following questions.
(A) What do you mean by P2P?
(B) Expand the following terms:
(i) WAP (ii) W3
(C) Mention any two advantages of Networking.
(D) What is a Blog? Name any two Online Blogs.
Answer:
(A) Networks in which all computers have an equal status are called peer to peer networks whereas in which certain computers have special dedicated tasks, providing services to other computers (in the network) are called client server networks.
(B) Expand the following terms:
(i) Wireless Access Point
(ii) WWW (World Wide Web)
(C) Advantages of Networking are:
Data Sharing : One of the most important uses of networking is to allow the sharing of data.
Files Transfer : Users can send text files, spread sheets, documents, presentations, audio files, video files, etc. to other users.
Hardware Sharing : Hardware components such as printers, scanners, etc. can also be shared. For example, instead of purchasing 10 printers for each user, one printer can be purchased and shared among multiple users thus saving cost.
Internet Access Sharing : You can purchase a single Internet connection and share it among other computers in a network, instead of purchasing multiple Internet connection for each computer. This is very commonly found in Internet cafe (browsing centres), schools, colleges, companies, etc.
Usage of network based applications : Such as web browsers, email clients, chat application, audio & video calling, etc. is another advantage. .
(D) A blog is a discussion style site used by non-technical or technical users for creating personal web pages. Blogs are similar to an online personal diary and simple to use. The advantage of offline blog is, it can be created first and later publish the content when an active internet connection is available.