PRACTICE PAPER - I (2019-20)

INFORMATION TECHNOLOGY (402)

CLASS: X [Set A]
DURATION: 2 Hours MM: 50

Name of Student…………….. Sign of Invigilator................

___________________________________________________________________________
GENERAL INSTRUCTIONS:
 Read the paper thoroughly and answer all the parts of a question.
 Write all the answers in neat handwriting.
 Draw margins on both sides of the Answer sheet
__________________________________________________________________________
Q1. Multiple choice questions: (Attempt any 10) 1X10=[10]
i) The systems in a network at an equal hierarchy are called ______
a) LAN
b) MAN
c) Peer to Peer
d) Client Server
ii) With reference to MS Word, footer option is available under the
group_______
a) Symbol
b) Text
c) Header & Footer
d) Link
iii) File extension of template document is______.
a) .docx
b) .pptx
c) .rtf
d) None
iv) Format option in Excel is available under the group_____
a) Font
b) Style
c) Cells
d) Clipboard
v) When you freeze a row ______ remains constant.
a) Header
b) Sort
c) Chart
d) Print
vi) The ______ option is used to print only text component of a presentation.
a) Outline
b) Sorter
c) Handout
d) None
vii) Which Outlook function is similar to using Sticky Notes?
a) Journal
b) Notes
c) Calendar
d) Tasks
viii) A database is a complex type of_____________
a) Application
b) Database Structure
c) Manager
d) None
ix) Which of the following is a toggle key?
a) Shift Key
b) Ctrl Key
c) Alt Key
d) Caps Lock Key
x) The process of arranging the contents of a column in some sequence is
_____.
a) Autofill
b) Sorting
c) Filtering
d) Arrange
xi) ________ was one of the irst IM program launched in 1996.
a) Hangouts
b) Orkut
c) GTalk
d) ICQ
xii) Hanging indent, indents the first line of a paragraph. (True/False)
Q2. Which of the two sets of words should be typed in search engines to get more [1]
appropriate results? Give reason.
a) Fastest train
b) Which train has the highest speed?

Short Answer Question. (Attempt any 7)

Q3. Seema wants to give identical designs to all the slides and handouts, she is going to [2]
print from her presentation.

a) Which two methods can she use to accomplish her work?

b) Compare the two methods and in list their differences.

Ans- She could use a template provided by the presentation software she is planning
to use. There are usually a large number of templates to choose from to fit her needs.
Using a premade template will make her presentation seem professional and cohesive.
This would also be the easier option. The other option would be to format each slide
one at a time with similar colors and traits. This would take longer but it would also
give her more design options.
Q4. Define DSL. Explain its relevance in internet based communication. [2]

Ans-DSL(Digital Subscriber Line) provide Internet access by transmitting digital data

over wires of a local telephone network.

Q5. What is Google Hangout? Mention the features which have made the app popular. [2]

Ans- Google hangouts is one such platform, its an app from Google. Some of the
common features which makes it so popular include the follwoing :

Instant Messaging

HD Video calls

Intelligent muting

Auto screen focus

Built-in screen sharing

HD Group Conferencing

Compatible with different computer devices

Compatible with iOS, Android and Windows

Q6. Differentiate between internet and intranet. [2]

Ans- Internet
1. Internet is wide network of computers and is open for all.

2. Internet itself contains a large number of intranets.

3. The number of users who use internet is Unlimited.

4. The Visitors traffic is unlimited.

5. Internet contains different source of information and is available for all.

Intranet

1. Intranet is also a network of computers designed for a specific group of

users.

2. Intranet can be accessed from Internet but with restrictions.

3. The number of users is limited.

4. The traffic allowed is also limited.

5. Intranet contains only specific group information.

Q7. What is a Contact Form? [2]

Ans- Contact Form allows the blog visitors to get in touch with the blogger through
their suggestions, feedback, and comments.

Q8. State the purpose of creating a blog. [2]

Ans- The purpose of writing blogs could be promotion of a product or service,

awareness about social issues, information sharing about any subject or purely
passion for writing. ... Company Blogs: Many companies manage a blog and share
about their business, products or services.

Q9. How you can search a word in document using find option? What is the [2]
shortcut key to open replace dialog box.

Ans- i) You can easily find text by hitting Ctrl + F

Q10. Some features are given in column-A and some functionalities are given in [2]
column-B. Match the features with their functionalities.
Column A Column B
i) Sort a) Orientation
ii) Filter b) Conditional Formatting
iii) Landscape c) Arranging Data
iv) Style Group d) Extracting Data
e) Symbol
f) Page/Section

Ans-
(i)-(c)
(ii)-
(iii)-(a)
(iv)-(b)

Q11. Differentiate between e-mail and instant messaging. [2]

Ans-
Email is short for electronic mail. This is a kind for mail service that works similar to
the postal service. A message is created by you on your computer and sent.

IM is short for Instant Messaging. Instant Messaging enables online real time
communication between two users logged in simultaneously. Every time a user
presses enter the message gets broken up in packets and is immediately transmitted
over the net.
Long Answer Question. (Attempt any 5)
Q12. With reference to MS-Excel, what is meant by “Cell Freezing”. Write the different [3]
options available with the feature.

Ans- Freeze panes is a feature in spreadsheet applications. It "freezes" a row or

column, so that it is always displayed, regardless of what part of the
spreadsheet is being displayed. 

Q13. What do you mean by DBMS? List 4 data types used in a DBMS along with suitable [3]
example.

Ans-Database Management System (DBMS) is a software for storing and

retrieving users' data while considering appropriate security measures. It
consists of a group of programs which manipulate the database.

1-Numeric Data Types-

(i)-Byte
(ii)-Integer
(iii)-Decimal

2-Alphanumeric/Textual Datatype –
(i)-Text
(ii)-Memo

3-Date/Time Datatype-
(i)-General Date
(ii)-Long Date
(iii)-Medium Date

4-Special/Extended Data Types-

(i)-AutoNumber
(ii)-OLE Object
(iii)-Attachment

Q14. List the key features of Instant Messaging along with examples. [3]

Ans-
Key Features of an instant messaging are as follows:
• Text Messages can be sent to one or more person (Similar to SMS)
• Audio calling and conferencing.
• Video calling and conferencing.
• File transfers (Not limited to documents, spread sheets, audio files, video
files, etc.)
• Message history (Save messages for future reference).
Q15. Briefly mention the steps to embed a spreadsheet within the MS Word document. [3]

Ans-
i)Open the word
ii)Select Insert on the ribbon.
iii)In the Text group
Click the dropdown arrow for Object ----> Select Object.
iv) Dialog box will appear
v) Select Create from File.
vi) Choose Browse and select the Excel file that you want to Embed.

Q16. Kartikay is preparing a Digital Presentation. Help him to choose the correct option to- [3]
a) Keep the same transition and sound effect to all the slides
b) Insert a movie that has already been downloaded in the slide.
c) Add notes to a particular slide
ANS-
A. Animation > Transitions to this slide > Apply to all slides
B. Insert > Media clips > Movie from file
C. View>Presentation views>Notes slide

Q17. Write a SQL query to create a table with the following structure. Which field is [3]
most likely to be primary key from the given attributes? Give reasons.
Field Type
EmpNo Char(4)
Name Varchar(25)
Salary Float
Department Varchar(15)

ANS-
i)Create table Employees Info(EmpNo Char(4), Name Varchar(25), Salary Float, Department
Varchar(15)
ii)EmpNo as all the employees will have different and unique number.
Very Long Answer Question.
Q18. What are the components of email screen? Write their use in composing an [5]
email.
ANS-Date and time received (On). The date and time the message was
received.

Reply-to. This is the Internet email address that will become the recipient of
your reply if you click the Reply button.
Recipient (To:). First/last name of email recipient, as configured by the sender.

Recipient email address. The Internet mail address of the recipient, or where

the message was actually sent.

Attachments. Files that are attached to the message.