Practicing the CBSE Sample Papers for Class 10 Information Technology Set 3 allows you to get rid of exam fear and be confident to appear for the exam.
CBSE Sample Papers for Class 10 Information Technology Set 3 with Solutions
Time: 2 hrs
Max. Marks: 50
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
(Objective Type Questions)
Question 1.
Answer any 4 out of the given 6 questions on Employability Skills [1 x 4 = 4 Marks]
(i) _____ operating system enables multiple users to work on the same computer at different times or simultaneously. [1]
(a) A multi-programming
(b) Multi-processors
(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. [1]
(a) Meditation
(b) Nature Walk
(c) Yoga
(d) Physical
Answer:
(c) Yoga
(iii) From the following statements, which one is not correct about the qualities of an entrepreneur? [1]
(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. [1]
(a) #temp#
(b) %temp%
(c) e $temp%
(d) &temp&
Answer:
(b) %temp%
(v) _____ is not the quality of self-confident people. [1]
(a) Dependent
(b) Hard Working
(c) Positive Attitude
(d) Commitment
Answer:
(a) Dependent
(vi) From the following statements, which one is not the positive impact of Entrepreneurship on society? [1]
(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 × 5 = 5 Marks]
(i) _____ key is used to reduce repetitive strain. [1]
(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. [1]
(a) Filtering
(b) Sorting
(c) Report
(d) Forms
Answer:
(a) Filtering
(iii) Which of the following application is not appropriate to store data about ABC Bank customers? [1]
(a) Open Office Base
(b) MS Access
(c) Open Office Writer
(d) MS Excel
Answer:
(c) 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. [1]
(a) Sheet 1
(b) Untitled 1
(c) Worksheet 1
(d) New Sheet
Answer:
(a) Sheet 1
(v) In a word processor, _____ option is selected for a scaled resizing of an image. [1]
(a) Original Size
(b) Keep ratio
(c) Image Size
(d) Relative
Answer:
(b) Keep ratio
(vi) Multiple copies of the same file leads to _____. [1]
(a) Data Inconsistency
(b) Data consistency
(c) Data Redundancy
(d) Foreign Key
Answer:
(c) 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. [1]
(a) Wrap Text
(b) Alignment
(c) Anchoring
(d) Bookmark
Answer:
(c) Anchoring
(ii) Identify the property which help to set the number of characters in text/ varchar type field of a table in DBMS. [1]
(a) Entry Required
(b) Default Value
(c) Size
(d) Length
Answer:
(d) Length
(iii) _____ is designed to help users with auditory impairments. [1]
(a) Sound Sentry
(b) High Contrast
(c) Serial Key
(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”. [1]
(a) True
(b) False
Answer:
(b) False
(v) Reviewers and authors can add their _____ to explain their changes in the cell of Spreadsheet. [1]
(a) Comments
(b) Hyperlink
(c) Worksheet
(d) Macros
Answer:
(a) Comments
(vi) In Calc, Arguments passed to a macro from Calc are always _____. [1]
(a) Cell Reference
(b) Value
(c) Both (a) and (b)
(d) Sheet Reference
Answer:
(b) 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. [1]
(a) Blogdesk
(b) Qumana
(c) WordPress
(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. [1]
(a) Tables
(b) Mail Merge
(c) Columns
(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. [1]
(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: [1]
(a) healthy eating habits
(b) stress management
(c) physical activities
(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. [1]
(a) browser
(b) hyperlink
(c) internet
(d) mail and news
Answer:
(c) 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. [1]
(a) cell reference
(b) block
(c) sheet reference
(d) autofill
Answer:
(a) cell reference
Question 5.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Identify the mode, where we can modify in the structure of table?
(a) Datasheet view
(b) Structure view
(c) Design view
(d) All of these
Answer:
(c) 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. [1]
(a) Data Combination
(b) Data Merging
(c) Data Consolidation
(d) Data Concatenation
Answer:
(c) Data Consolidation
(iv) _____ store data in a single table which is suitable to store less amount of data. [1]
(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. [1]
(a) 3
(b) 7
(c) 10
(d) 12
Answer:
(c) 10
(vi) In _____ networks, all computers have an equal status and each terminal has an equally competent CPU. [1]
(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? [2]
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 organisations, groups and nations at large.
- Working independently ensures creativity and satisfaction among individuals.
Question 7.
Name the stress causal agents. [2]
Answer:
The agents that are primary causes of stress are
(i) Mental
(ii) Social
(iii) Physical
(iv) Financial
Question 8.
What do you mean by disk defragmentation? [2]
Answer:
Disk defragmentation removes all the unnecessary and irrelevant information that slows down a computer. Disks should regularly defragmented, so that the disc space can be utilized at optimal level.
Question 9.
Explain any two myths about entrepreneurship. [2]
Answer:
Two myths about entrepreneurship are
(i) Every business idea should be unique or special Each entrepreneur knows about the need and demands of customers, so he/she can take an existing business idea and do something different with it.
(ii) A lot of money is required to start a business It is not necessary that every business requires a lot of capital. There are enterprises which could be started with less capital and can later be developed with the earned amount.
Question 10.
Write any four roles of entrepreneurs.
Answer:
The four roles of entrepreneurs are
(i) Organiser of Society’s Productive Resources An entrepreneur is the one who assembles the unused natural, physical and human resources of the society and makes the economy dynamic by combining them.
(ii) Increases Employment Opportunities An entrepreneur creates maximum employment opportunities in the society.
(iii) Development of New Production Techniques An entrepreneur finds new ways to save time, labor and capital in production.
(iv) Risk Taking Ability An entrepreneur being the owner of an enterprise is the biggest risk taker as he facilitates the capital for his idea and is accountable for his failures.
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. [2]
Answer:
The two purposes of using Templates in a Word Document are
(i) Templates save time
(ii) There is no need to think about formatting while using Templates as they are predesigned.
Question 12.
Mention any two operations that can be performed using macros in a spreadsheet. [2]
Answer:
Macros can be used for the following operations:
(i) If formatting settings need to be applied repeatedly in a Spreadsheet then, macros can be used.
(ii) Macros can be used to sort data and to apply mathematical functions or formulas.
Question 13.
What do you mean by hyperlinks in spreadsheets? Give the two different types of hyperlinks that can be used in spreadsheets. [2]
Answer:
In Spreadsheets, Hyperlinks can be used in Calc to jump to a different location from within a Spreadsheet and can leads the other parts of the current file, to different files. Hyperlinks can be absolute and relative. An absolute URL contains all the information necessary to locate a resource. A relative URL locates a resource using an absolute URL as a starting point.
Question 14.
List numeric and alphanumeric Datatypes in Open Office Base. [2]
Answer:
Numeric data types are: Tinylnt, Smalllnt, Integer, Biglnt, Decimal, Real, Float, Double and Boolean. Alphanumeric data types are: Char (fix), Varchar, Varchar-ignore case and Long Varchar (Memo).
Questions 15.
Differentiate between Filter keys and Toggle keys in Microsoft Windows. [2]
Answer:
| Filter Keys | Toggle Keys |
| (i) It is an accessibility function that tells the keyboard to ignore brief or repeated keystokes. | It is an accessibility function in which when the Toggle keys are turned on, the computer emits sound cues when the locking keys (Caps Lock, Num Lock) are pressed. |
| (ii) This makes typing easier for users with hand tremors. | It helps people with vision impairment and cognitive disabilities. |
Question 16.
In which situations online shopping could be useful? Write any two popular E-commerce websites. [2]
Answer:
Online shopping is useful when:
(i) A customer does not have sufficient time to visit stores.
(ii) The product that one is looking for is available at low cost online.
Two popular E-commerce websites are:
(i) Flipkart, an online portal to buy consumer products.
(ii) Amazon, a multinational E-commerce company that provides various consumer goods.
Answer any 3 out of the given 5 questions in 50-80 words each. [4 × 3 = 12 Marks]
Question 17.
Anshita is preparing spreadsheet notes for her term exam. Help her to write short note on the following: [4]
(i) Scenarios
(ii) Goal Seek
(iii) Solver
(iv) Subtotal
Answer:
(i) Scenarios Scenarios are 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 values for calculations. We can easily switch between these sets using the Navigator or a Drop-down list which can be shown beside the changing cells.
(ii) 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 produces the result that we want.
(iii) Solver It is an 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 defined by us.
(iv) Subtotal It is a function listed under the Mathematical category when we use the Function Wizard (Insert > Function). Because of its utility, the function has a graphical interface.
SUBTOTAL, gets the total/adds the data arranged in array-that is, a group of cells with labels for columrts and/or rows. For increasing the efficiency, we can choose up to three groups of arrays to which the function can be applied.
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. [4]
(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 the one where we wants to insert some information from a data source into a main
document. Merge fields appear with chenrons (< < > >).
(ii) Data Source Data source is the file that contains the names, addresses and any other information that varies with each version of a mail-merge document.
(iii) Main Document It is the document which contains text and graphics. It may be formal or an official letter.
(iv) The two types of data on which mail merge can be applied are letters and labels.
Question 19.
Consider the following table: Sales
Sales [4]
| Sale_Id | Prod_Name | Price | Discount |
| 1101 | Laptop | 65000 | 2500 |
| 1103 | Pentab | 29500 | 1000 |
| 1105 | Desktop | 50000 | 1550 |
| 1106 | Printer | 12000 | 2000 |
(a) How many fields and records are there in Sales table?
(b) Write SQL commands for the following:
(i) Display Sale_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) There are four fields and four records in the given Sales table.
(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 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. [4]
(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 helps organisations in conveniently develop databases for various applications.
(b) Two database programs useful for creating tables and storing required data are (i) Microsoft Access (ii) MySQL
(c) Id field can be set as the primary Key.
(d) Yes, we can make more than one column as a Primary Key in the table. It would be 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. [4]
(a) What do you mean by Internet Service Provider?
(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) Internet Service Provider (ISP) is a company that provides Internet connections and services to organisations and individuals through dial-up or direct or wireless connection. They may also provide software packages (such as browsers), e-mail accounts and a personal website or home page.
(b) (i) WAP: Wireless Access Point
(ii) W3 : World Wide Web
(c) Two advantages of Networking are
(i) Data Sharing Networking allows the sharing of data easily.
(ii) File Transfer Networking helps users to send text files, spreadsheets, documents, audio files etc.
(d) A blog is a discussion platform/site where technical (or non-technical) users create personal web pages. They are similar to online personal diary. They can be used to express opinions, share content etc. TVvo online blogs are; wordpress.com, www.weebly.com.