Dibrugarh University Question Papers: Information Technology and Its Practice and Applications in Business

2015 (November)
Course: 304
The figures in the margin indicate full marks for the questions
Full Marks: 80
Pass Marks: 24
Time: 3 hours

1. (a) Select the correct alternatives:                                                                                       1x4=4
                                 i.            The main distinguishing feature of fifth-generation computers is
1)      Extremely low cost.
2)      Artificial intelligence.
3)      Versatility.
4)      Liberal use of microprocessors.
                               ii.            The memory that requires constant refreshing to retain its contents is known as
1)      Cache memory.
2)      Static RAM.
3)      Read-only memory.
4)      Dynamic RAM.

                              iii.            The program or software which acts as a mediator between the user and the hardware is known as
1)      Compiler.
2)      Device driver.
3)      Operating system.
4)      System utility
                             iv.            To advance to the next cell in a table in MS-Word, user is required to press
1)      Enter key.
2)      Tab key.
3)      End key.
4)      Insert key.
(b) Write True or False:                                                                                                             1x4=4
                                 i.            Primary memory and main memory are synonymous.
                               ii.            Less pixels per square inch means better resolution.
                              iii.            Device drivers are system software which are responsible for proper functioning of the CPU.
                             iv.            The cell that denotes the current position of the insertion point is known as the active cell in a worksheet.

2. Write briefly:                                                                                     4x4=16
a)      Application of IT in manufacturing industry.
b)      Steps to be followed in creating a company using Tally.
c)       Difference between a worksheet and a workbook.
d)      Difference between Static RAM and Dynamic RAM.

3. Answer either [ (a) and (b)] or (c):
a)     What is meant by Information Technology? What are its components?                2+2=4
b)  “Today’s business cannot grow without the application of Information Technology.” Explain. 10
c)  Discuss the role of Information Technology in education sector and manufacturing industry.  14

4. (a) What is software? Discuss the role of software in a computer system. Describe the functions of an operating system.                                                                                                                                                                 2+4+8=14
(b) What is meant by EDI? Discuss different ways by which business data are transmitted from one trading partner to another trading partner. Discuss the importance of EDI standards.        2+8+4=14

5. (a) (i) What is meant by protecting a document and how can it be done in MS-Word?                                 4
(ii) What is mail merge? Write the steps followed in mail merging documents.                         5
(iii) How can bullets and numbers be added to a portion of text in a document?                      3
(iv) Differentiate between copy-paste and cut-paste.                                                                  2
(b) (i) What is meant by cell referencing in MS-Excel? How many types of cell referencing are there in MS-Excel?     3
(ii) State the differences between formula and function in MS-Excel.                                3
(iii) Write the general forms (syntaxes) for the following functions:                                   4
                                 i.            Round()
                               ii.            Max()
(iv) What is macro and how can it be created in MS-Excel?                                         4

6. (a) What is computerized accounting? Discuss its advantages over manual accounting.                               2+12=14
(b) What is group? Write the steps for creating, displaying and altering single/multiple groups using Tally.                                                                                                                  2+12=14

Full Marks: 80
Pass Marks: 32
Time: 3 hours

1. (a) Write True or False:                                                                                                             1x4=4
                                 i.            Number of tuples in a relation is known as cardinality.
                               ii.            Operating system is an application software.
                              iii.            Scanner is an input device.
                             iv.            RAM is nonvolatile in nature.
    (b) Write the full form of the following:                                                                             1x4=4
                                 i.            RAM.
                               ii.            DBMS.
                              iii.            IP.
                             iv.            EPROM.
2. Write short notes on the following:                                                                                    4x4=16
a)      Utility software.
b)      Worksheet.
c)       Spell-check function.
d)      Utilities of different charts in MS-Excel.

3. (a) What is meant by Information Technology? Discuss the basic features of IT.                3+8=11
(b) What are different components of IT? Discuss the impact of IT on business environment.                      3+8=11

4. (a) State the relationship between software and hardware. Discuss about the different categories of software briefly.                                                                                 3+8=11
(b) What is EDI? Write a note on EDI standards.                              2+9=11

5. (a) Write the steps for performing the following in MS-Word:     2+(3x3)=11
                                 i.            Cutting, copying and pasting.
                               ii.            Using bullets and numbering in a document.
                              iii.            Justification of text.
(b) Discuss the importance of MS-Access in business.                                                     11

6. (a) State the difference between formula and function in MS-Excel and explain the auto sum features of them with example.                                                                             (2 ½ +2 ½)+6=11
(b) Discuss MS-Excel and its application in business in detail.                                        11

7. (a) Answer either [(a) and (b)] or [(c) and (d)]:
a)  Explain briefly how Tally has changed the accounting process in business sector.                     6
b) Discuss different protocols used in Internet.                                                                    6
c) Explain briefly the essential steps in creating a company using Tally.                           6
d)      Explain the following terms:                                                                                        3+3=6
                                 i.            Downloading and uploading.
                               ii.            Uniform resource locator.

Full Marks: 80
Pass Marks: 24
Time: 3 hours

1. Write the full form of the following:                                                                                   1x8=8
a)      ICT.
b)      CPU.
c)       OOK.
d)      ASCII.
e)      DBMS.
f)       WAN.
g)      WWW.
h)      EDI.
2. Write short notes on:                                                                                                                5x4=20
a)      Information revolution.
b)      Radio as a toll of IT.
c)       ROM and RAM.
d)      Local area network.

3. (a) “Today’s business is dependent on Information Technology.” Explain the statement with examples.           13
(b) Distinguish between IT and ICT. Discuss the importance of ICT in business.                13

4. (a) Discuss the role of telephone in developing business in India.                                    13
(b) What do you mean by media convergence? Discuss the importance of media convergence in business.          13

5. (a) What is data management? Discuss the areas where data management has been used. 3+10=13
(b) What is binary system? Discuss the significance of binary system in computer.               3+10=13

6. (a) What do you mean by electronic data interchange? Discuss the advantages of electronic data interchange.                                                               13
(b) Discuss the growth of Internet. Do you think that growth of Internet in India is satisfactory? Discuss.         6+7=13

Full Marks: 80
Pass Marks: 32
Time: 3 hours

1. Write the full form of the following:                          1x4=4
a)      ICT.
b)      EDP.
c)       ASCH.
d)      EDI.

2. Fill in the blanks:                                                       1x4=4
a)      Intersection of row and column in a worksheet is known as ____.
b)      1055 kB = ____ bytes.
c)       Joystick is a ____ device.
d)      FTP stands for ____.

3. Write short notes on the following:                             4x4=16
a)      Communication.
b)      Printing press.
c)       Fifth-generation computer.
d)      Computer network.

4. (a) “Today’s business is not fully dependent on Information Technology.” Justify and comment on the statement. 11
(b) Explain the impact of Information Technology on manufacturing industry.                    11

5. (a) What is operating system? Discuss various functions of an operating system.             11
(b) Discuss briefly about different categories of software. What are utility software’s? Discuss their functions.                   11

6. Write short notes on (any three):                                                      4x3=12
a)      Number system.
b)      American standard code.
c)       Data.
d)      Information.
e)      Joystick.

7. (a) Discuss the advantages and disadvantages of fifth-generation computers.                 11
(b) Explain with reasons: “Computer programs are prepared for specific task.”

8. (a) What is meant by Internet Protocol? Discuss different protocols used in Internet.         11

(b) What is EDI standard? Discuss different EDI standards followed by trading partners in transmitting business data.          11