INFORMATION TECHNOLOGY (SUBJECT CODE 402)

Answer key
PART A: SHORT ANSWER TYPE QUESTIONS ON EMPLOYABILITY SKILLS

Answer any 4 of the given 6 questions (2 x 4 =8 marks)

Q. 1 What role is played by feedback in any type of communication.
— Collection of Information Any two 1
— Completion of Entire Communication Process marks for
— Measuring the Effectiveness Of Communication each correct
— Measuring the Effectiveness Of Media answer
— Taking Proper Decision
— Problem Solving
— Identification of Improvement Area
— Better Understanding

Q. 2 Communication skills are very important for any business. Explain any two Any two 1
benefits of effective communication. marks for
each correct
1. Reduces Misunderstanding and prevents us from overlooking answer
information
2. Effective communication creates a comfortable environment where
people of same/different gender, religion, feelings and cultural
backgrounds can work together to resolve differences
3. Effective Communication initiates different people to work towards a
common goal
4. Effective Communication skill increases our self respect and our
confidence as well!
5. It also improves our overall relationship with each other

Q. 3 State the four steps for effective time management. 0.5 for each
step

Q. 4 Your friend Shyam is always stressed during exams. He is sincere and studious 1 mark for
student, but the thought of exam creates anxiety in him. What are some stress each correct
management techniques that you would suggest to help him? suggestion

• Time management: Proper time management is one of the most effective

stress-relieving techniques.
• Physical exercise and fresh air: A healthy lifestyle is essential for students.
Stress is generally lower in people who maintain a healthy routine. Doing yoga,
meditation and deep breathing exercises help in proper blood circulation and
relaxes the body. Even taking a walk or playing in the park will help you get a lot
of fresh oxygen, which will help you become more active.
• Healthy diet: Having a healthy diet will also help you reduce stress. Eating a
balanced diet, such as Dal, Roti, vegetables and fruits will give you the strength
to do your daily work efficiently.
 • Positivity: Focussing on negative aspects of life will add more stress. Instead,
learn to look at the good things and stay positive. For example, instead of
feeling upset over a scoring less in a test, try to maintain a positive attitude and
look at ways to improve the next time.
• Organising academic life; no delaying: By keeping class notes organised,
finishing in assignments on time, and keeping track of all deadlines, stress can
be reduced to a great extent.
• Sleep: We should get a good night’s sleep for at least 7 hours so that your
brain and body gets recharged to function better the next day.
• Holidays with family and friends: Going to a relative’s place, such as your
grandparents’ house or a new place during your summer vacations can help you
break from the normal routine and come back afresh.

Q. 5 Give any two necessary skills one should have to be able to work independently. Brief
description
The followings are the necessary skills that you need to have to be able to of any two
work independently: skills 1 mark
• Organizational skills each
• Multitasking ability
• Discipline
• Communication skills
• Ability to compromise
• Ability to deal with rejection and not to take it personally
Q. 6 Write some measures one should take to overcome barriers in effective Any four 0.5
communication. marks for
• Speak slowly and clearly. each correct
• Ask for clarification. answer
• Frequently check for understanding.
• Be specific.
• Choose your medium of communication effectively.
• Be patient.
• To be updated with latest technologies
• Self Motivation.
• Start by listening to others.
• Clarify if there is confusion.
• Stay calm and be positive
PART B: SHORT ANSWER TYPE SUBJECT SPECIFIC QUESTIONS
Answer any 10 of the given 12 questions (2 x 10= 20 marks)
Q. 7 What is the benefit of creating TOC in any document? What is the 1 mark for
mandatory point one has to keep in mind for successful creation of TOC in advantange_ 1
Writer? for mandatory
Advantages of using Table of Contents (TOC): point
1. It gives the reader a bird's eye view of the document.
2. It makes a document look professional.
3 It is a key organizational aid for the author.
4. It makes a document easier to discuss.
5. It gives you a learning path

To create TOC we have to make sure that the heading should be set
using built in styles

Q. 8 What are blogs? Name any two website which can be used to create free 1 mark for
blogs. definition 0.5
A blog is a discussion style site used by non-technical (or technical users) for each
users for creating personal web pages. Blogs are similar to an online correct
personal diary and simple to use. website name
 • [Link]
• [Link]
• [Link]
• [Link]
• [Link]

Q. 9 What is the need to create reference between the multiple worksheets of a 2

workbook?
Every workbook contains at least one worksheet by default. When
working with a large amount of data, you can create multiple worksheets
to help organize your workbook and make it easier to find content. We
can further refer to data of multiple sheers by creating reference in one
worksheet. example we can have the total sales of each month in one
sheet by creating reference
Richard needs to set up a network for his office where he wants to save all 1 mark for the
the data in a centralized system and other computers will take the services correct
from the centralized system. Which architecture will be the best suitable for architecture
him? Write benefit of this type of architecture? identification
+1 mark for
Client server architecture mentioning
Q. 10
the correct
Improved Data Sharing benifit
Integration of Services
Shared Resources Amongst Different Platforms
Easy Maintenance
Security
What is the benefit of creating Macros in a Spreadsheet? 1 mark for
Benefits of using Macros each correct
Efficiency and Accuracy: A process can be repeated many times without the benifit
Q. 11 need to re-enter commands and parameters into instruction input fields. ...
Repeatability: Operations may be repeated many times with variations in
particular parameters.

Q. 12 What is Data Definition Language? Give example. 1 mark for

definition 1 for
DDL- DDL or Data Definition Language actually consists of the SQL example
commands that can be used to define the database structure. It is
used to create and modify the structure of database objects in the
database.
• CREATE – Create an object. ...
• DROP – This SQL DDL command helps to delete objects. ...
• ALTER – Used to alter the existing database or its object
structures.

What is the main factor that makes WiMAX different from Wi-fi? 2 marks for
Wifi and WiMax are used to create wireless network correct
connections. difference
Wifi is used to create small networks and used to connect
Q. 13
printers, conmputers, gaming consoles.
WiMax uses spectrum to deliver connection to network.
WiMax is used to provide internet services such as Mobile Data
and hotspots.
Mr Ben is a manager. He wants to calculate number of employees in each I mark for
Q. 14 department. He has a worksheet that contains department names, correct
employee names in each department and designations of employees. Which identification
 of the following he can choose to achieve his task? Which menu contains 1 mark for
that option? correct menu
Subtotal: Excel SUBTOTAL function returns an aggregate result for supplied
values.
Data >Subtotal
Why it is recommended to format the documents using in built styles? 1 mark each
for correct
• EFFICIENCY AND CONSISTENCY It saves time as a group of advantage
formatting attributes are saved as a style so that they can be applied
multiple times throughout the document. It also helps to keep formatting
consistent in the document.
• EASIER TO MODIFY When formatting attributes need to be altered,
you only need to update the style once, the changes will apply to all the
Q. 15 text formatted with that style.
• TABLE OF CONTENTS Using Writer's built‐in styles, you can quickly
create and update a table of contents.
• SMALLER FILE SIZE Writer is a style‐based program. It reads the
components of underlying styles first, before working on others.
Therefore, a lengthy manually formatted document is more sluggish (and
bigger) than one in which styles have been applied, because Writer has to
work harder to run it.

How to create a new template? Write steps. 0.5 marks for

each correct
Creating template in OO Writer answer
Step 1. Start OO Writer and create new file.
Step 2. Apply desired styles and formatting for the template.
Q.16
Step 3. Click on File → Templates → Save option.
Step 4. Type desired filename, choose category of template and click on
save button.
Note: The default extension of OO Writer is .ott (ODF Text Document
Template)
What do you understand by tables in database and why they are called building Definition
blocks of database? 1mark

Table : A table is a collection of related data held in a table format within

a database. ... In relational databases, and flat file databases, a table is a set of
data elements (values) using a model of vertical columns (identifiable by name) and
Q.17 horizontal rows, the cell being the unit where a row and column intersect.

Building block explanation 1mark

Tables are the core primary building blocks of a database. A Table is very much
like a data table or spreadsheet containing rows (records) arranged in different
columns (fields). At the intersection of field and a row is the individual bit of data for
a particular record, called a cell.
Give one point of difference between 1 mark for
a) Datasheet and design view of table each correct
b) Forms and reports difference
a) Datasheet view shows the data in the database. It also allows
you to enter and edit the data. It does not let you change the
format of the database, other than minor changes (such as
Q.18 displayed column widths). Design view allows you to create or
change the table, form, or other database object, and configure
the fields.
b) Forms allow you to both add data to tables and view data that
already exists. Reports present data from tables and also from
queries, which then search for and analyse data within these
same tables
PART C: DESCRIPTIVE/ LONG ANSWER TYPE SUBJECT SPECIFIC QUESTIONS Answer any 3 of
the given 5 questions (4 x 3 = 12 marks)
Q. Explain the purpose of any four tabs which appear when you double 1mark for
19 click the inserted picture in OO Writer. each correct
explanation

Type: setting of picture height and width

Options: setting up the alternative text to image
Wrap: setting of text with image
Hyperlink: setting up linking with image
Picture: Flipping image vertically or horizontally
Crop: Scaling or cropping the image size
Borders: change the background colour of the image
Background: for inserting background picture
Q. Answer the question in context to Internet security 1mark for
20 a. What makes a secure password? each correct
12-14 characters answer
Combination is capital small letters numbers and special
characters
No easy to guess
b. What is the purpose of anti-virus software?
To protect system from any threat of malwares
c. How do you know that website is secure?
By seeing https or lock sign
d. State any one preventive measure to keep your system safe
while using internet.
Backup, antivirus, antispyware, firewalls

Q. Answer the following in context with spreadsheet software’s A)1+1

21 a. What are document hyperlinks? How are they useful? B)2 marks for
Hyperlinks are very useful when additional information is also correct
required along with the document. In that case, rather than adding explanation
contents of additional information, a hyperlink to separate
document can be provided.
Hyperlink offer these advantages:
i. A document does not become very large with lot of
information.
ii. Additional information is also available by clicking at the
hyperlinks.
iii. Hyperlinks make documentation reader friendly.

b. Three users are working on the same shared document. But

two of them are working on common overlapping ranges.
What will happen when you try to save such document?

As there are overlapping ranges, it means they will be

changes to common cells giving rise to conflicts. With
conflicting changes, if we try to save the document the
resolve conflicts dialog is shown where we must decide for
each conflict which version to keep. When all conflicts are
resolved, the document is saved.
Q. a) Write the SQL command to create the table with the given A) 0.5 for
22 structure each
correct
defining of
field
B) 1 mark for
correct
syntax of
insert
statement

Create table Item

(
PRODUCTno Number Primary key ,
pname Varchar (15),
Price Number,
Quantity Number );

b)

Insert into product values (66, ‘Carom board’, 150, 70).

Or
Insert into product (productno, pname ,Price, Quantity) values
(66, ‘Gel’, 150, 70).

Insert into product (“productno”, “pname” ,’Price’, ‘Quantity’)

values (66, ‘Gel’, 150, 70).

Q. Consider the following table Games and write the queries 1 mark for
23 GCode Game Numb Prize Schedule each correct
Name er Money Date query
101 Carom 3 5000 23-Jan-
Board 2004
102 Badmint 2 12000 12-Dec-
on 2003
103 Table 4 8000 14-Feb-
Tennis 2004
105 Chess 1 9000 01-Jan-
2004
108 Lawn 4 25000 19-Mar-
Tennis 2004
[Link] display all the record of table Games whose price is in the
range of 10000 and 25300.
Select *
from product
where price between 10000 and 25300
Or
Select *
From product
where price>=10000 and price<=25300;
[Link] display all the records of a table in descending order of
Schedule date.
Select * from product
order by [Schedule date] desc;
III. Increase the number by 2 for games starting with ‘C’
 Update product
set Number=Number+2
where name like ‘C*’;
[Link] the Game name and price money of the games having
number two or more
Select Gname ,price
from PRODUCT
where number>=2;