Practicing the CBSE Sample Papers for Class 10 Information Technology Set 11 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 11 For Practice
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 based on Employability Skills [1 × 4 = 4 Marks]
(i) _____ is the first screen that is displayed after switching on the Windows. [1]
(a) My computer
(b) Desktop
(c) Windows
(d) Login
(ii) Coherent is one of the 7 C’s of effecting communication. It means, the communication should be smooth and ………… [1]
(a) logical
(b) long
(c) short
(d) specific
(iii) Stress management infuses a sense of ………….. and accomplishment. [1]
(a) pressure
(b) control
(c) threat
(d) None of these
(iv) A ……………. is a network security device that monitors incoming and outgoing network. It restricts access to unwanted sites. [1]
(a) firewall
(b) anti-virus
(c) block sites
(d) None of these
Answer:
(v) _____ are the people who are too focused on what others think and they fail to focus on their internal matters. [1]
(a) Seekers
(b) Introspectors
(c) Gold diggers
(d) Pleasers
(vi) Please pass me the sauce. This sentence is a type of _____ sentence. [1]
(a) assertive
(b) interrogative
(c) imperative
(d) exclamatory
Question 2.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) abc@mnc.co.in represents an ………… [1]
(a) MAC address
(b) URL
(c) E-mail address
(d) None of these
(ii) Which of the following fields will not make a suitable primary key? [1]
(a) A customer’s account number
(b) A date-field
(c) An auto number field
(d) A student’s admission number
(iii) A _____ allows you to present data retrieved from one or more tables so that, it can be analysed and printed, if required. [1]
(a) report
(b) form
(c) table
(d) query
(iv) Goal Seek is also called as _____ is one of the What-if analysis tools that is available in Calc. [1]
(a) back-solving
(b) solver
(c) forward-solving
(d) result analysis
(v) If you choose styles, and then change the base style then all the _____ styles will change as well. [1]
(a) linked
(b) edited
(c) copied
(d) None of these
(vi) Which one of the following is an example of RDBMS ? [1]
(a) MongoDB
(b) Windows registry
(c) Publisher
(d) Oracle
Question 3.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Which tab of writer contains the Hyperlink option? [1]
(a) File
(b) Format
(c) Insert
(d) Tools
(ii) To insert a symbol like © (copyright), you need to click on the _____ option of the Insert tab. [1]
(a) Special Character
(b) Character
(c) Equation
(d) Header
(iii) Digital information is converted into analog information by the modem at [1]
(a) destination computer
(b) source computer
(c) Both (a) and (b)
(d) Neither (a) nor (b)
(iv) To delete a template, _____ on a template in the Templates window and select delete. [1]
(a) Right-click
(b) Left-click
(c) Double-click
(d) None of these
(v) If you see #### in place of data in a cell, it means you need to _____ the cell width. [l]
(a) increase
(b) decrease
(c) Both (a) and (b)
(d) None of these
(vi) When a user inserts a new worksheet in spreadsheet software, the new worksheet will be inserted _____ [1]
(a) at the end of sheet tab
(b) in the beginning of sheet tab
(c) next to active sheet
(d) None of these
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) A group of computers connected together with the help of cables within an office building is called [1]
(a) PAN
(b) MAN
(c) WAN
(d) LAN
(ii) Which of the following is not a style type in Writer? [1]
(a) Frame style
(b) Image style
(c) List style
(d) Character style
(iii) A primary key field cannot be null, which also means that it cannot be _____ [1]
(a) invalid
(b) positive
(c) alphanumeric
(d) empty
(iv) Which of the following websites is used for booking train tickets? [1]
(a) Nykaa
(b) IRCTC
(c) RedBus
(d) Myntra
(v) Which of the following is an application based instant messaging software? [1]
(a) Google Talk
(b) eBuddy
(c) Meebo
(d) MSN Web Messenger
(vi) In the given formula, identify the type of reference and the cells that are passed as arguments.= Average! $A$5, $B$5) [1]
(a) Absolute reference; cells are-A5 and B5
(b) Relative reference; cells are-A5 and B5
(c) Relative reference; cells are-A5 to B5
(d) Absolute reference; cells are-A5 to B5
Questions 5.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) Information is the processed form of …………
(a) words
(b) data
(c) sentence
(d) records
(ii) ………….. is the act of posting content on a blog.
(a) Edublog
(b) Posting
(c) Blogging
(d) Blogger
(iii) DBMS provides various key fields as
(a) primary key and candidate key
(b) alternate key and foreign key
(c) Both (a) and (b)
(d) None of these
(iv) In order to use data from a worksheet, you need to use its name. [1]
(a) alias
(b) representative
(c) qualified
(d) quantified
(v) You can move a dockable window to a convenient position on the screen by holding down the key and drag it by the title bar to where you want it docked. [1]
(a) Ctrl
(b) Alt
(c) Shift
(d) Windows
(vi) Instant messaging service accepts instant messages from [1]
(a) external sites
(b) internal sites
(c) Both (a) and (b)
(d) None of these
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.
Explain the parts of speech. [2]
Question 7.
What do you mean by survival stress? [2]
Question 8.
Explain the use of Antivirus for the protection of the computer system. [2]
Question 9.
Describe the role of entrepreneurs. [2]
Question 10.
What are the uses of sustainable development? [2]
Answer any 4 out of the given 6 questions in 20-30 words each. [2 × 4 = 8 Marks]
Question 11.
Mention the steps to be followed choose a style for a Word document? [2]
Question 12.
Write the steps to freeze the columns. [2]
Question 13.
What do you mean by relative cell referencing? [2]
Question 14.
Describe various transaction control commands of SQL. [2]
Question 15.
Explain the working of message switching technique. [2]
Question 16.
Define the following : [2]
(i) Accident in workplace
(ii) Hazard
Answer any 3 out of the given 5 questions in 50-80 words each. [4 × 3 = 12Marks]
Question 17.
Tanisha had created a Table of Contents of the project done by her. Tell her the different steps to do the following: [4]
(a) Editing a TOC
(b) Updating a TOC
Question 18.
Simran wants to add comments in a spreadsheet application. Tell her the different steps involved of adding and editing comments. [4]
Question 19.
Consider the following table ITEMS : [4]
TABLE: ITEMS
| Code | IName | Qty | Price | Company | TCode |
| 1001 | DIGITAL PAD 121 | 120 | 11000 | XENITA | T01 |
| 1006 | LED SCREEN 40 | 70 | 38000 | SANTORA | T02 |
| 1004 | CAR GPS SYSTEM | 50 | 2150 | GEOKNOW | T01 |
| 1003 | DIGITAL CAMERA 12X | 160 | 8000 | DIGICLICK | T02 |
| 1005 | PEN DRIVE 32 GB | 600 | 1200 | STOREHOME | T03 |
(a) How many fields and records are there in the table ITEMS?
(b) Write the SQL queries to:
(i) Display the detail of all the items in ascending order of item names (i.e., IName)
(ii) Display IName and Price of all those items, whose price is in the range of 10000 and 22000.
(iii) Display all the information of the items having price less than 10000.
Question 20.
Nupur wants to know the differences between the following: [4]
(a) Fields and tuples
(b) Data and information
Question 21.
Lakshit wants to know the definitions of the following terms. Answer to his query: [4]
(i) Web based instant messaging software
(ii) Cable modem.