Download Question Paper of "Introduction to Computers-2" , Question Paper of BBA 2nd Semester, Subject Code : BB - 206, Paper ID C0212, Paper 9

Roll No…………..

Total No. of Questions : 07

BBA (Sem. -2nd)

INTRODUCTION TO COMPUTERS -II

SUBJECT CODE : BB - 206

Paper ID: [C02l2]

[Note: Places fill subject code and paper ID on OMR]

Time : 03 Hours

Instruction to Candidates:

l) Section - A is Compulsory.

2) Attempt any Four questions from Section - B.

Section - A

1.     

a)    What is a spreadsheet? Explain.

b)   What are different types of functions that can be applied in Excel sheet?

c)    What is MS-Outlook application used for in MS-Office?

d)   List few advantages of using internet.

e)    Name few browsers that can be used to browse the internet and briefly explain any one

f)     Write the importance of e-mail in current working scenario.

g)    List and briefly describe the different protocols available for communication over internet?

h)   What is a search engine? Name few popular commonly used search engines.

i)      What do you mean by SDN & where do we use it?

j)      What are netiquettes? List a few of them that you observe.

Section-B

     2.  Write stepwise procedure to create an Excel Sheet containing result of a particular batch of students. Each student studies five different subjects and has scored certain marks out of 60 for each subject. Write the steps to find

a)    Total marks scored by each students.

b)   Average marks in each subject

c)    Maximum marks in each subject

d)   Minimum marks in each subject

3.     Create an excel sheet containing copy of the data in question 2 and generated information for its sub-parts. Write the stepwise procedure to draw the Bar chart percentage (pass percentage can be assumed to be set at 40% of max marks).

4.    Discuss the evolution of internet and its growth over period of time. How has internet revolutionized the academic activities and its impact on the human lives? Illustrate your answer with a suitable example.

5.     Write functions and importance of MS-Outlook tool in MS-office with emphasis on following components.

a)    Calendar

b)   Appointments

c)    Tasks

d)   Address book

6.    Explain in detail different way of connecting to internet including Dial-up Broadband and ISDN. Also compare the above mentioned different ways of connection in term of parameters like convenience, speed, cost, security and reliability of connection.

    7.    Explain the different protocols used over internet for data transfer covering protocols like HTTP, FTP and TCP/IP.