Students can access the IT Sample Papers Class 10 CBSE with Solutions and marking scheme Set 5 will help students in understanding the difficulty level of the exam.
Computer IT Sample Paper Class 10 Set 5 for Practice
Time: 2 hrs
Max. Marks: 50
General 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 5 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
1. Answer any 4 out of the given 6 questions based on Employability Skills (1 × 4 = 4)
(i) …… allow you to communicate your message clearly and easily to a large audience.
(a) Good writing skills
(b) Communication
(c) Document
(d) None of these
Answer:
(a) Good writing skills
(ii) The feeling of self-awareness enhances our ……..
(a) mediation
(b) stress
(c) self-confidence
(d) clarity
Answer:
(c) self-confidence
(iii) In …. filter, detailed rules are specified as a part of spreadsheet cells.
(a) Normal
(b) Advanced
(c) Both (a) and (b)
(d) None of these
Answer:
(b) Advanced
(iv) …… is the process of identifying opportunities in the market place.
(a) Decisionmaker
(b) Management
(c) Entrepreneurship
(d) None of these
Answer:
(c) Entrepreneurship
(v) The ecology can be protected through imposition of ……. and afforestation.
(a) forestation
(b) deforestation
(c) Both (a) and (b)
(d) None of these
Answer:
(b) deforestation
(vi) consists of a main clause and sometimes one or more subordinate clauses. (1)
(a) Paragraph
(b) Noun
(c) Sentence
(d) All of these
Answer:
(c) Sentence
2. Answer any 5 out of the given 6 questions (1 × 5 = 5)
(i) Which of the following run horizontally in a worksheet and are identified by a number in the row header?
(a) Column letter
(b) Row number
(c) Name box
(d) Formula bar
Answer:
(b) Row number
(ii) Picture Shape option comes under ….. tab.
(a) Picture Format
(b) Tools Format
(c) Picture Tools Format
(d) None of these
Answer:
(c) Picture Tools Format
(iii) Table is also known as ….
(a) file
(b) record
(c) field
(d) sheet
Answer:
(a) file
(iv) Web based type of software is accessed using ……
(a) web server
(b) web browsers
(c) web client
(d) None of these
Answer:
(b) web browsers
(v) In ….. topology, each node is connected to two and only too neighbouring nodes.
(a) ring
(b) tree
(c) mesh
(d) star
Answer:
(a) ring
(vi) Which of the following is a boundary that specifies that cell is active at particular moment?
(a) Formula
(b) Cell pointer
(c) Cell address
(d) None of these
Answer:
(b) Cell pointer
3. Answer any 5 out of the given 6 questions (1 × 5 = 5)
(i) Which of the following options are available in Office button?
(a) New
(b) Open
(c) Save
(d) All of these
Answer:
(d) All of these
(ii) Which of the following offers a blog services?
(a) Drupal
(b) Joomla
(c) WordPress
(d) All of these
Answer:
(d) All of these
(iii) shortcut key is used to make the selected text underline.
(a) Alt + I
(b) Ctrl + I
(c) Ctrl + U
(d) Alt + U
Answer:
(c) Ctrl + U
(iv) Which of the following is the oldest spreadsheet package?
(a) MS-Excel
(b) Quattro-Pro
(c) VisiCalc
(d) All of these
Answer:
(c) VisiCalc
(v) …. view is a simple view of data arranged in rows and columns.
(a) Datasheet
(b) Design
(c) Table
(d) None of these
Answer:
(a) Datasheet
(vi) … is a multi-port network device, that provides access to computers.
(a) Switch
(b) Hub
(c) Gateway
(d) Bridge
Answer:
(b) Hub
4. Answer any 5 out of the given 6 questions (1 × 5 = 5)
(i) After selecting the text you need to click the … in the font group to make the font size larger than the current font size.
(a) size
(b) font size
(c) font
(d) font-style
Answer:
(b) font size
(ii) Hide and Unhide option is available in …. tab in MS-Excel.
(a) Edit
(b) Format
(c) Home
(d) Insert
Answer:
(c) Home
(iii) Database is a combination of …….
(a) hardware
(b) software
(c) Both (a) and (b)
(d) None of these
(c) Both (a) and (b)
Answer:
(iv) A computer connected to a network is known as …..
(a) host
(b) data
(c) node
(d) Both (a) and (c)
Answer:
(d) Both (a) and (c)
(v) Database is made up of all the following components except ….
(a) tables
(b) queries
(c) forms
(d) formula bar
Answer:
(d) formula bar
(vi) The ….. establishes an intelligent connection between a local network and external networks.
(a) bridge
(b) router
(c) gateway
(d) hub
Answer:
(c) gateway
5. Answer any 5 out of the given 6 questions (1 × 5 = 5)
(i) While entering a formula, cell address B $ 5 represents ……
(a) relative referencing
(b) mixed referencing
(c) absolute referencing
(d) None of these
Answer:
(b) mixed referencing
(ii) are the tools which are used to produce own drawings.
(a) Drawings tools
(b) Picture tools
(c) Both (a) and (b)
(d) None of these
Answer:
(a) Drawings tools
(iii) Facilities offered by database are
(a) the ability to store a large amount of data in a structured format, easy update, sort query, production of reports
(b) easy edition, spell check, perform calculations, library of mathematical functions, replication
(c) the ability to rotate images, copy and paste, fill scale
(d) None of the above
Answer:
(a) the ability to store a large amount of data in a structured format, easy update, sort query, production of reports
(iv) web browser supports only graphics information.
(a) Text-based
(b) Graphical
(c) Both (a) and (b)
(d) None of these
Answer:
(b) Graphical
(v) Formula for adding values of cell A1 to A5 would be …..
(a) SUM (A1 : A5)
(b) = SUM (A1 : A5)
(c) = TOTAL (A 1 : A 5)
(d) = SUM (A 1 + A 5)
Answer:
(b) = SUM (A1 : A5)
(vi) Computers connected to a LAN can share information through a common …..
(a) printer
(b) data
(c) network
(d) None of these
Answer:
(a) printer
SECTION B: Subjective Type Questions
Answer any 3 out of the given 5 questions based on Employability Skills. Answer each question in 20-30 words (2 × 3 = 6)
Question 6.
Explain the types of barriers to communicate.
Answer:
Question 7.
Explain the four kinds of self-awareness.
Answer:
Question 8.
Write the steps to save a document.
Answer:
Question 9.
What are the advantages of entrepreneurship?
Answer:
Question 10.
Define the solutions for sustainable development.
Answer any 4 out of the given 6 questions in 20-30 words each (2 × 4 = 8)
Question 11.
Write the steps to modify a style in a document.
Answer:
Question 12.
How to change the layout of the chart?
Answer:
Question 13.
What do you mean by filtering data?
Answer:
Question 14.
Explain the term report in a database.
Answer:
Question 15.
Distinguish between circuit switching and packet switching.
Answer:
Question 16.
Describe the following in a document:
(i) Ruler
(ii) Scroll bar
Answer:
Answer any 3 out of the given 5 questions in 50-80 words each (4 × 3 = 12)
Question 17.
Describe all methods for saving a document in MS-Word.
Answer:
Question 18.
Define the following
(i) Blog
(ii) Mesh topology
Answer:
Question 19.
What do you mean by mixed referencing?
Answer:
Question 20.
How to rename a field into a table in a database?
Answer:
Question 21.
(i) Create the table SHOP with the following fields:
| Column Name | Data Type |
| S_No | Varchar(5) |
| P_Name | Char(20) |
| S_Name | Char(20) |
| Qty | Int |
| Cost | Float |
| City | Char(20) |
(ii) Consider the following table CUSTOMER and write the queries (a) and (b).
| CID | CNAME | GENDER | SID | AREA |
| 1001 | R SHARMA | FEMALE | 101 | NORTH |
| 1002 | M R TIWARY | MALE | 102 | SOUTH |
| 1003 | M K KHAN | MALE | 103 | EAST |
| 1004 | A K SINGH | MALE | 102 | EAST |
| 1005 | S SEN | FEMALE | 101 | WEST |
| 1006 | R DUBEY | MALE | 104 | NORTH |
(a) To display CNAME, AREA of all female customers from CUSTOMER table.
(b) To display the details of all the CUSTOMER in ascending order of CNAME within SID.
Answer: