Students can access the IT Sample Papers Class 10 CBSE with Solutions and marking scheme Set 4 will help students in understanding the difficulty level of the exam.
Computer IT Sample Paper Class 10 Set 4 for Practice
Time: 2 hrs
Maximum 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
Answer any 4 out of the given 6 questions based on Employability Skills (1 × 4 = 4)
(i) _______ skills are essential for working in an organisation.
(a) Stress
(b) Communication
(c) Good communication
(d) None of these
Answer:
(c) Good communication
(ii) Awareness about our _______ is not a kind of self-awareness.
(a) Biases
(b) Yoga
(c) Mediation
(d) None of these
Answer:
(a) Biases
(iii) The shortcut key for printing the presentation is _______
(a) Alt + P
(b) Ctrl + P
(c) Shift+ P
(d) Ctrl + A
Answer:
(b) Ctrl + P
(iv) A/An _____ has a good vision towards the achievement of his goals.
(a) entrepreneur
(b) self-confident
(c) goal-oriented
(d) None of these
Answer:
(a) entrepreneur
(v) ______ is a word for a person, place, thing or idea.
(a) Pronoun
(b) Noun
(c) Article
(d) Paragraph
Answer:
(b) 20th and 21th
(vi) Sustainable Forest Management which were developed in Europe during the ______ centuries.
(a) 18th and 16th
(b) 20th and 21th
(c) 17th and 18th
(d) None of these
Answer:
(c) 17th and 18th
2. Answer any 5 out of the given 6 questions (1 × 5 = 5)
(i) Which is the descriptive text aimed at helping user to identify the chart?
(a) Chart title
(b) Plot area
(c) Chart area
(d) Gridlines
Answer:
(a) Chart title
(ii) A document is a paper with written contents and the process of preparing a document is called _______
(a) Page break
(b) Work area
(c) Documentation
(d) None of these
Answer:
(c) Documentation
(iii) The processed form of data is known as ______
(a) value
(b) information
(c) knowledge
(d) None of these
Answer:
(b) information
(iv) Quemana works with a variety of ______ platforms.
(a) Blog
(b) WordPress
(c) Hub
(d) None of these
Answer:
(a) Blog
(v) The backbone of the www is made up of files called ______
(a) web browser
(b) web pages
(c) server
(d) client
Answer:
(b) web pages
(vi) To insert a ______ page break, select the row below where you want to insert the page break.
(a) vertical
(b) ruler
(c) horizontal
(d) None of these
Answer:
(c) horizontal
3. Answer any 5 out of the given 6 questions (1 × 5 = 5)
(i) Full form of OLE is _______
(a) Object Link and Embed
(b) Object Linking and Embedding
(c) Object Linker and Embedding
(d) Objective Linking and Embedding
Answer:
(b) Object Linking and Embedding
(ii) HTML is used to create
(a) browser
(b) server
(c) webpages
(d) None of these
Answer:
(c) webpages
(iii) ______ option allows a user to edit picture.
(a) Edit
(b) Crop
(c) Paste
(d) Format
Answer:
(b) Crop
(iv) Each worksheet contains
(a) 1048576 rows
(b) 16384 columns
(c) Both (a) and (b)
(d) None of these
Answer:
(c) Both (a) and (b)
(v) Multiple mismatching copies of the same data is known as _______
(a) data inconsistency
(b) data redundancy
(c) data integrity
(d) None of these
Answer:
(a) data inconsistency
(vi) With most LAN’s cables, ______ is used for their connectivity.
(a PIC
(b) NIC
(c) NIP
(d) None of these
Answer:
(b) NIC
4. Answer any 5 out of the given 6 questions (1 × 5 = 5)
(i) _______ is a section of the document that appears at the bottom margin of the page.
(a) Footer
(b) Header
(c) Top
(d) Center
Answer:
(a) Footer
(ii) _______ is located on left of the formula bar.
(a) Formula bar
(b) Name box
(c) Active cell
(d) Ruler
Answer:
(b) Name box
(iii) A/An _______ language is a portion of a DML involving information retrieval only.
(a) DCL
(b) TCL
(c) Query
(d) None of these
Answer:
(c) Query
(iv) Internet security prevents attacks targeted at ________
(a) browsers
(b) operating system
(c) network
(d) All of these
Answer:
(d) All of these
(v) A field or a set of fields that uniquely identify each record in a table is known as a ________
(a) primary key
(b) alternate key
(c) candidate key
(d) foreign key
Answer:
(a) primary key
(vi) ______ are web based instant messaging softwares.
(a) WeChat
(b) Skype
(c) Viber
(d) All of these
Answer:
(d) All of these
5. Answer any 5 out of the given 6 questions (1 × 5 = 5)
(i) _______ displays worksheets as they would appear if you printed them out.
(a) Layout
(b) Page layout
(c) Page break
(d) None of these
Answer:
(b) Page layout
(ii) Alignments buttons are available on the ______ tab.
(a) Home
(b) Insert
(c) Format
(d) File
Answer:
(a) Home
(iii) Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required?
(a) Age in years
(b) Date of birth
(c) Age in days
(d) Age in months
Answer:
(b) Date of birth
(iv) The main advantage of circuit switching is ________
(a) delivery
(b) guaranteed delivery
(c) power band
(d) None of these
Answer:
(b) guaranteed delivery
(v) The contents of a cell can be changed by pressing _______ key on keyboard.
(a) F5
(b) F3
(c) F2
(d) None of these
Answer:
(a) F5
(vi) MAN provides communication services upto _______
(a) 100 m
(b) 100 km
(c) 10 km
(d) None of these
Answer:
(b) 100 km
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.
What do you mean by non-verbal communication?
Answer:
Question 7.
Explain the term self-motivation.
Answer:
Question 8.
How can you create new worksheet in MS-Excel?
Answer:
Question 9.
What do you mean by entrepreneur?
Answer:
Question 10.
What are the importance of sustainable development?
Answer:
Answer any 4 out of the given 6 questions in 20-30 words each (2 × 4 = 8)
Question 11.
How to create a new blank document in MS-Word?
Answer:
Question 12.
What do you mean by paragraph alignment?
Answer:
Question 13.
How to unfreeze the rows and columns in workbook?
Answer:
Question 14.
Explain the term table used in database.
Answer:
Question 15.
Distinguish between repeater and switch.
Answer:
Question 16.
Define the following:
(i) AutoSum function
(ii) Full screen workbook view
Answer:
Answer any 3 out of the given 5 questions in 50-80 words each (4 × 3 = 12)
Question 17.
What is absolute cell referencing?
Answer:
Question 18.
Explain the following :
(i) Modem
(ii) Web page
Answer:
Question 19.
Describe three data manipulation language commands.
Answer:
Question 20.
What is header and footer? How to insert Date/Time into Header/Footer?
Answer:
Question 21.
(i) Create the table SummerCamp with the following fields:
|
Column Name |
Data Type |
| ChildID | Varchar(5) |
| FirstName | Char(20) |
| LastName | Char(20) |
| DOB | Date |
| Gender | Char(2) |
| Group | Varchar(5) |
(ii) Consider the following table APPLICANTS and write the queries (a) and (b).
TABLE:APPLICANTS
| No. | NAME | FEE | GENDER | C_ID | JOINYEAR |
| 1012 | Amandeep | 30000 | M | A01 | 2012 |
| 1102 | Avisha | 25000 | F | A02 | 2009 |
| 1103 | Ekant | 30000 | M | A02 | 2011 |
| 1049 | Arun | 30000 | M | A03 | 2009 |
| 1025 | Amber | 40000 | M | A02 | 2011 |
(a) To display NAME, FEE, GENDER, JOINYEAR about the APPLICANTS, who have joined before 2010.
(b) To display the names of all applicants in ascending order of their JOINYEAR.
Answer: