Practicing the CBSE Sample Papers for Class 10 Information Technology Set 10 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 10 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) ………… barriers are created in the mind by none other than ourselves, through preconceived notions and the stereotyping of people. [1]
(a) Imaginative
(b) Perceptual
(c) Language
(d) Cultural
(ii) Regular exercise helps pep up your mood and can take your mind off a lot of worry and negativity which are the main feed of stress. Which of the following activity is not considered as exercise? [1]
(a) Walking
(b) Jogging
(c) Swimming
(d) Talking
(iii) Moving a folder or a file means ………… it from its original location and placing it at another location. [1]
(a) Removing
(b) Leaving
(c) Pointing
(d) None of these
(iv) Which of the following sentences is in passive voice? [1]
(a) By whom was the mess cleaned?
(b) The birds were being fed by my sister.
(c) Uncle Rakesh teaches my brother.
(d) Both (a) and (b)
(v) Kaspersky McAfee are examples of popular ………… [1]
(a) image editing software
(b) anti-virus software
(c) word-processing software
(d) DBMS
(vi) ………. builds up over a period of time and takes a toll on the body due to overwork. [1]
(a) Fatigue
(b) Depression
(c) Irritability
(d) None of these
Question 2.
Answer any 5 out of the given 6 questions [1 x 5 = 5 Marks]
(i) A person who writes a blog or a weblog is known as …………… [1]
(a) program
(b) user
(c) blogger
(d) None of these
(ii) The …………. command is used to modify the existing rows in a table. [1]
(a) UPDATE
(b) SELECT
(c) INSERT
(d) REVIEW
(iii) A …………. is a database element that is used to view, enter and edit records in a table. [1]
(a) Form
(b) Report
(c) Query
(d) None of these
(iv) Neeta is planning to take a car loan to buy a new car. But she is not sure about the payback time, i.e. whether to pay it back in 5 or 6 years considering that her monthly fuel cost will also increase. In such cases, which of the following features of spreadsheet can she use to get an idea about it? [1]
(a) Consolidation
(b) Macros
(c) Templates
(d) What-if analysis
(v) ………… styles are used to format graphics and text frames, including text wrap, borders, backgrounds and columns. [1]
(a) Border
(b) Frame
(c) Table
(d) Text
(vi) A …………… language is a portion of a DML involving information retrieval only. [1]
(a) DCL
(b) Query
(c) TCL
(d) None of these
Question 3.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) This is a type of hyperlink available in Hyperlink dialog box, which creates a new worksheet.
(a) New document
(b) New file
(c) New worksheet
(d) New data
(ii) The processed form of data is known as ………….
(a) value
(b) information
(c) knowledge
(d) None of these
(iii) …………. service can integrate both video calling and instant messaging abilities. [1]
(a) Web conferencing
(b) Web browser
(c) Web page
(d) None of these
(iv) ………. is a list, usually found on a page before the start of a written work, of its chapter or section titles or brief descriptions with their commencing page numbers. [1]
(a) Preface
(b) Table of contents
(c) Acknowledgements
(d) Page title
(v) For sorting through macro, the selected cell range must be ……………. [1]
(a) identical
(b) different
(c) Both (a) and (b)
(d) formatted
(vi) To add a new image to the Gallery, you can click on the ……….. button. [1]
(a) New image
(b) Add image
(c) New theme
(d) Add theme
Question 4.
Answer any 5 out of the given 6 questions [1 x 5 = 5 Marks]
(i) A collection of web pages linked together in a random order is …………… [1]
(a) a website
(b) a web server
(c) a search engine
(d) a web browser
(ii) …………… are descriptions about the changes made in cells during record changes mode. [1]
(a) Tips
(b) Comments
(c) Messages
(d) None of these
(iii) State whether True or False. Duplicate values can be entered in column marked as primary key. [1]
(a) True
(b) False
(iv) ……….. are used for transmitting data across networks. [1]
(a) Circuit switching
(b) Switching techniques
(c) Channel
(d) None of these
(v) The speed of a network is measured in ………………. [1]
(a) mbps
(b) bytes
(c) kHz
(d) None of these
(vi) Which of the following is not a required information for Label set-up? [1]
(a) Height
(b) Number
(c) Vertical pitch
(d) Column
Question 5.
Answer any 5 out of the given 6 questions [1 × 5 = 5 Marks]
(i) What data type should be chosen for a zipcode field in a table? [1]
(a) Tat
(b) Number
(c) Memo
(d) All of these
(ii) Wireless broadband can be …………… [1]
(a) mobile
(b) fixed
(c) Both (a) and (b)
(d) None of these
(iii) The candidate key, which is not used as primary key is called ……….. key. [1]
(a) primary
(b) foreign
(c) alternate
(d) super
(iv) A table in a relational database is also called as ……………. [1]
(a) tuple
(b) records
(c) results
(d) relation
(v) A …………… can also be a quick way to take a list of people’s mailing addresses and generate labels or envelopes with the address for a different person on each label or envelope. [1]
(a) data source
(b) database
(c) mail merge
(d) E-mail
(vi) ………… is the formation of networks. [1]
(a) Server
(b) Networking
(c) Client
(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.
What do you mean by non-verbal communication? [2]
Question 7.
Explain the term self-motivation. [2]
Question 8.
Define multi-processing and multi-user operating system. [2]
Question 9.
What do you mean by the term entrepreneur? [2]
Question 10.
What is the importance and need of sustainable development? [2]
Answer any 4 out of the given 6 questions in 20-30 words each. [2 × 4 = 8 Marks]
Question 11.
Describe the significance of using templates in your documents. [2]
Question 12.
State the use of Consolidating Data in a spreadsheet. [2]
Question 13.
Explain the Text and Memo data types. [2]
Question 14.
Explain the term table used in database. [2]
Question 15.
Distinguish between repeater and switch. [2]
Question 16.
What are the steps to apply first aid roller bandage to a wound? [2]
Answer any 3 out of the given 5 questions in 50-80 words each. [4 × 3 = 12 Marks]
Question 17.
Harmanpreet had inserted an image in a word processor application. Now, she wants to know the use of the following terms. Tell her the correct answer. [4]
(i) Alignment
(ii) Anchoring
(iii) Rotating
(iv) Resizing
Question 18.
Samiksha wants to know the use of the following terms. Describe them for her.
(i) Goal Seek
(ii) Scenario
(iii) Subtotal
(iv) Solver
Question 19.
Consider the following table APPLICANTS [4]
TABLE: APPLICANTS
| NAME | FEE | GENDER | C_ID | JOINYEAR |
| Amandeep | 30000 | M | A01 | 2012 |
| Avisha | 25000 | F | A02 | 2009 |
| Ekant | 30000 | M | A02 | 2011 |
| Arun | 30000 | M | A03 | 2009 |
| Amber | 40000 | M | A02 | 2011 |
(i) How many records and fields are there in the table APPLICANTS.
(ii) Write the SQL queries to:
(a) Display NAME, FEE, GENDER, JOINYEAR about the APPLICANTS, who have joined before 2010.
(b) Display the NAMES of all APPLICANTS in ascending order of their JOINYEAR.
(c) Display the NAMES of all APPLICANTS in ascending order of their JOINYEAR.
Question 20.
Prashant wants to know about Data Manipulation language commands. Solve the following queries for him. [4]
(i) What is DML?
(ii) Write the use of any three DML commands.
Question 21.
Chetanya wants to know the functions of the following terms. Tell him the correct answer. [4]
(i) Modem
(ii) Web page
(iii) Wi-fi
(iv) GPS