Information Technology and Its Application in Business
2019 (November)
Commerce
Course: 304: Information Technology and Its Application in Business)
Full Marks: 80
Pass Marks: 24
The figures in the margin indicate full marks for the questions.
a)
Write True or False:
1)
Tuples are the horizontal rows of information in
a database.
2)
210 MB equals 1 gigabyte.
3)
Device drivers are software that is responsible
for proper functioning of the CPU.
4)
More pixels per square inch mean better
resolution.
b)
Fill in the blanks: 1x4=4
1)
Insertion of rows and columns in a worksheet is
known as ______.
2)
ICT stands for ______.
3)
ASCII stands for ______.
4)
MAN stands for ______.
2.
Answer the following briefly: 4x4=16
a)
Write the differences between compiler and
interpreter.
b)
Differentiate between ROM and RAM.
c)
Differentiate between application software and
system software.
d)
State the meaning of CD-ROM, WORM, rewritable
and multifunction.
3.
(a) Discuss the impact of information technology in education and health
sector. 14
Or
(b) Explain EDI with its different advantages and disadvantages.
14
4.
(a) Discuss different types of software with example. 14
Or
(b) Write the differences between memory and storage.
Explain different types of storage devices with their relative advantages and
disadvantages. 14
5.
(a) What is mail merge? Write down the steps involved in mail merging in
MS-Word. How can formulas be entered in Worksheet? Write down the steps in
creating charts in an Excel sheet. 1+6+1+6=14
Or
(b) (1) State the differences between formula and function
in MS-Excel.
(2) What is meant by cell referencing in MS-Excel? Describe
the different cell references available in MS-Excel.
(3) Give the uses syntax of the following functions: 2+6+6=14
a)
Round()
b)
Sum()
c)
Count()
6.
(a) What is ERP? What are the limitations of conventional ERPs? Discuss some of
the features of Tally. 2+5+7=14
Or
(b) What is group? Write the steps for creating, displaying
and altering single/multiple group using Tally.
3+11=14
(OLD COURSE)
(INFORMATION
TECHNOLOGY AND ITS APPLICATION IN BUSINESS)
Full Marks: 80
Pass Marks: 32
Time: 3 hours
1.
Write the full forms of the following: 1x8=8
a)
ERP.
b)
EDP.
c)
EPROM.
d)
EBCDIC.
e)
OCR.
f)
RTGS.
g)
MICR.
h)
NEFT.
2.
Write briefly on the following: 4x4=16
a)
Spell-check functions in MS-Word.
b)
Optical storage device.
c)
Functions of MS-Excel.
d)
Validation and sorting in MS-Excel.
3.
(a) Discuss different features of IT. Explain the impact of IT on business. 14
Or
(b) Define EDI. Discuss the advantages and working
principles of EDI. 14
4.
(a) Differentiate between primary memory and secondary memory. Describe some of
the storage devices used in computer. 4+10=14
Or
(b) How is software useful in smooth functioning of
computer hardware? 14
5.
(a) (1) What is meant by protecting a document and how can it be done in
MS-Word? 3
Or
(2) How can the case of a particular word be changed in
MS-Word? 3
(3) Write the steps for inserting a table in MS-Word
document. 4
(4) Write the steps for finding and replacing text in a
MS-Word document. 4
Or
(b) Write the use and syntax of the following MS-Excel
functions: 2x7=14
1)
Count()
2)
Count A()
3)
Countblank()
4)
Sum()
5)
Sumif()
6)
Countif()
7)
Round()
6.
(a) Explain different features of Tally with its relative advantages and
disadvantages. 14
Or
(b) Discuss different keys and voucher entries available in
Tally. 14
***
Post a Comment
Kindly give your valuable feedback to improve this website.