CBSE Sample Papers for Class 10 Information Technology Set 12 For Practice

Practicing the CBSE Sample Papers for Class 10 Information Technology Set 12 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 12 For Practice

Time: 2 hrs
Max. Marks: 50

Instructions:

  1. Please read the instructions carefully
  2. This Question Paper consists of 21 questions in two sections: Section A & Section B.
  3. Section A has Objective type questions whereas Section B contains Subjective type questions.
  4. 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.
  5. All questions of a particular section must be attempted in the correct order.
  6. 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.
  7. 7. 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 an effective method to learn the art of freely interacting with people, at the same time boosting your self-confidence. [1]
(a) Listening
(b) Public speaking
(c) Playing
(d) Working out

(ii) Which of the following is not a symptom of stress? [1]
(a) Irritability
(b) Insomnia
(c) Fatigue
(d) Fever

CBSE Sample Papers for Class 10 Information Technology Set 12 with Solutions

(iii) When you start a computer, the operating system gets loaded into the main memory from the hard disk. This is called …………… [1]
(a) uploading
(b) booting
(c) starting
(d) downloading

(iv) Unless the students are clear about their learning target, _____ is irrelevant. [1]
(a) feedback
(b) solution
(c) Both (a) and (b)
(d) None of these

(v) _____ is a windows utility that consolidates fragmented files and folders on your computer’s hard disk. [1]
(a) Disk cleanup
(b) Disk consolidation
(c) Disk defragmenter
(d) None of these

(vi) The drive within you that compels you to complete tasks is [1]
(a) self-motivation
(b) self-regulation
(c) self-awareness
(d) self-sufficient

Question 2.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]

(i) Do not use the elevator in times of fire in the building. Always use _____ for such emergencies. [1]
(a) office space
(b) staircase
(c) washroom
(d) None of these

(ii) Databases have the ability to [1]
(a) store a large amount of data in a structured format, easy update, sort query, production of reports.
(b) spell check, perform calculations, library of mathematical functions, replication.
(c) rotate images, copy and paste, fill scale.
(d) None of the above

(iii) Solve option under Tools menu amounts to a more elaborate form of _____. The difference is that the Solver deals with equations with multiple _____. [1]
(a) unknown variables, goals seek
(b) variables, equation
(c) goal seek, unknown variables
(d) subtotal, goal seek

(iv) Template includes _____ text that is surrounded by brackets. [1]
(a) margin
(b) placeholder
(c) data source
(d) track changes

CBSE Sample Papers for Class 10 Information Technology Set 12 with Solutions

(v) In the Load Style dialog box, option loads the paragraph and the character styles from the selected document into the current document. [1]
(a) Page
(b) Paragraph
(c) Overwrite
(d) Text

(vi) Which of the following is an attribute whose value is derived from the primary key of some other table? [1]
(a) Primary key
(b) Foreign key
(c) Alternate key
(d) None of these

Question 3.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]

(i) The status of your document like current page number and number of pages are given by _____ [1]
(a) Formatting toolbar
(b) Status bar
(c) Standard toolbar
(d) None of these

(ii) A tuple in RDBMS is referred to _____ of a table. [1]
(a) record
(b) field
(c) table
(d) key

(iii) Which client software is used to request and display web pages? _____ is used to transfer files between computers on a network. [1]
(a) Web server
(b) FTP
(c) Multimedia
(d) Web browser

(iv) Editing Custom Shapes feature allows _____ of small segments of a drawing. [1]
(a) shaping
(b) reshaping
(c) rehearse
(d) None of these

(v) _____ function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily. [1]
(a) Summation
(b) Data Consolidation
(c) Data Format
(d) Data Chart

(vi) Which tab is used to share the worksheet data? [1]
(a) Home
(b) Review
(c) Insert
(d) Layout

CBSE Sample Papers for Class 10 Information Technology Set 12 with Solutions

Question 4.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]

(i) To join the Internet, the computer has to be connected to a [1]
(a) Internet Architecture Board
(b) Internet society
(c) Internet Service Provider
(d) None of these

(ii) By dragging any _____ handle you can increase or decrease the _____ of the image diagonally. [1]
(a) comer, size
(b) side, quality
(c) top, depth
(d) comer, quality

(iii) Key field is a unique identifier for each record. It is defined in the form of [1]
(a) rows
(b) columns
(c) tree
(d) query

(iv) Wireless broadband can be [1]
(a) mobile
(b) fixed
(c) Both (a) and (b)
(d) None of these

(v) A relational database is a collection of [1]
(a) attributes
(b) tables
(c) records
(d) fields

(vi) _____ ensure that all the documents have a standard layout, look and feel. [1]
(a) Graphics
(b) Layout
(c) Properties
(d) Templates

Question 5.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]

(i) _____ determines the range of field values. [1]
(a) Field Name
(b) Data Type
(c) Field Size
(d) Description

(ii) Rajat has received a spreadsheet, which is reviewed by his subordinates Puneet, Kavya and Aman, who made some corrections in it. Before Rajat shared the spreadsheet with his subordinates, he has activated the track changes feature. Which of the following option he should use now to keep some of the changes made by them? [1]
(a) Accept and reject changes
(b) Overwrite and keep changes
(c) Both (a) and (b)
(d) None of these

(iii) Computer based record keeping system is known as [1]
(a) Data Manipulation System
(b) Computerised Data System
(c) Computerised Record Keeping System
(d) DBMS

(iv) Which of the following is an AutoShape? [1]
(a) Line
(b) Circle
(c) Curve
(d) All of these

(v) Which type of hazard can cause skin irritation, illness or breathing problems? [1]
(a) Chemical hazard
(b) Biological hazard
(c) Slipping hazard
(d) None of these

(vi) If you have unsafe and unhealthy workplace, there will be higher days lost and will have higher [1]
(a) employee satisfaction
(b) productivity
(c) stress levels
(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.
Why is communication important? What are its types? How can you deal with it? [2]

Question 7.
What do you mean by survival stress? [2]

Question 8.
Explain the use of Disk Defragmenter. [2]

Question 9.
Name two basic elements of entrepreneurship. [2]

Question 10.
Sustainable forest management was developed in Europe during which centuries? [2]

Answer any 4 out of the given 6 questions in 20-30 words each. [2 × 4 = 8 Marks]

Question 11.
How to add a comment in a word processor application? [2]

Question 12.
Write the steps to sort the data in a worksheet. [2]

Question 13.
Mention any two string data types in database. [2]

Question 14.
Mention any two components of a database. [2]

Question 15.
When the computer network uses telephone lines as communication channel, then MODEM is used as a data communication device. Now, explain the working of MODEM. [2]

CBSE Sample Papers for Class 10 Information Technology Set 12 with Solutions

Question 16.
Define the following : [2]
(i) Peer-to-Peer architecture
(ii) Internet

Answer any 3 out of the given 5 questions in 50-80 words each. [4 × 3 = 12 Marks]

Question 17.
Manisha had created a Table of Contents of the project done by her. Tell her the different steps to do the following: [4]
(a) Creating a TOC
(b) Deleting a TOC

Question 18.
Simran wants to add macro in a spreadsheet application. Tell her the different steps involved in adding a macro. [4]

Question 19.
Consider the following table ITEM NAMES : [4]

P_Name S_Name Qty Cost City
Biscuit Priyagold 120 12.00 Delhi
Bread Britannia 200 25.00 Mumbai
Chocolate Cadbury 350 40.00 Mumbai
Sauce Kissan 400 45.00 Chennai

(i) How many records and fields in the table ITEM NAMES?
(ii) Write the SQL queries for
(a) Display all the products whose quantity in between 100 and 350.
(b) Display the data for all products sorted by their quantity.
(c) To list S_Name, P_Name, Cost for all the products whose quantity is less than 400.

Question 20.
Answer the following questions regarding database: [4]
(i) Mention any two databases.
(ii) Define different forms of a database.
(iii) What is an attribute whose value is derived from the primary key of some other table?
(iv) Define the SELECT command.

Questions 21.
Riya is a student of class X. She had heard about network devices. She had some queries. Help her by answering her queries. [4]
(i) What is network device?
(ii) Name any two network devices.
(iii) Which device is used as proxy server?
(iv) What is the basic function of repeater?