University of Delhi 2010-1st Year B.Com (Hon.) Marketing Management (HONS) COMPUTERS AND INFORMATION SYSTEM UNIVERSITY - Question Paper

COMPUTER AND info SYSTEM PAPER

This question paper contains 8+4 printed pages]

Your Roll No.......................

3TNcf?T djjshijicfe.........................

6006

B.Com. (Hons.yi    J'

Paper.VIINTRODUCTION TO COMPUTERS AND INFORMATION SYSTEM (New Course * Admission of 2004 onwards)

Time . IV2 Hours (For Part A)    Maximum Marks : 35

Wt : 1 s (WT %TT)    Tjnfcp : 35

A

Time : IV2 Hours (For Part B or C)    Maximum Marks : 40

: VA (WT    V fera;)    'jpifa : 40

Note - The maximum marks printed on the question paper are applicable for the candidates registered with the School of Open Learning These marks will, however, be scaled down proportionately in respect of the students of regular colleges, at the time of posting of awards for compilation of result

(Write your Roll No. on the top immediately on receipt of this question paper.)

fa?# W fctT Tm;froffal *S![R TR 3TW SFpPRFJT fafarr I)

'Note : Answers may be written either in English or in Hindi; but the same medium should be used throughout the paper.

W '5TT-^TT 3TT diK    IJT Upft

All questions are compulsory. Part A is compulsory for all the students. Attempt any of the Part B or Part C on separate Answer-Sheet, wft uiR    i     fcnj; 3tPt5[t4 t i

IPT 13    'TR ^<TT 3    MFI    rR-fW'+l 3 +1 I

P.T.O.

( 2 ) 6006

   Part A

(wn *0

(Introduction to Computers)

()    List, some of the advantages and disadvantages of using E-mail. 7

()    What is a news group ?

.

(c)    What is Telnet ⁹ How does it work ?

(d)    Ways to get connected to internet.    ,

()    eft -gq#! eft Cgg        I C) -gq 3    t ?

(*0 arrerc t ? faro tot ?n t ?

(E?)    3 *ft <Rft sIW!; I

*1

Or

(3rasa)

Define the following terms with respect to the Internet :    7

()    File Transfer Protocol (FTP)

()    Internet Search Engines

(c)    Hypertext Transfer Protocol (HTTP)

(d)    Proxy Server

tft ij fHHfdfisicl 3>t MRMlfNd    : OS)    WIMK

(13)    f5H

(T) SlfcT MlcWil -(JMMMiUi TT3R (TR)    yReleh I '

2.    (a) The operating system acts as the manager of the various resources

of computer system. Discuss the statement.    7

(6) Write the difference between Custom Tailored and Standardized Application Packages.    7

I i    i

(i)    fWn <mi    <f srtc to

i

Or

(m*0

(a)    Bring out the differences between traditional file system and databases

approach. Explain with the help of an example.    7

i

(6) Explain in brief the need for an efficient information system. 7

O) mkmR+ yNcbi Trrncft ctn afcgr otw if f*Frai3if

I 3?lg<u|    W    I

, () TWflft    cfit 3 we    i

1 *

3.    (a) What is meant by network topology ? Describe three commonly

used network topologies with their relative advantages and disadvantages.    7

(b)    What are modems ? What purpose do they serve in data communication

r

systems ?    7

( 4 )    6006

(J)    3    % ? tffr -Hmi-Mti: TPffiT    1

sHi    clW-Slinfl -tnfsa q^uti <>1fl<< I

(?) jrt t ? 3tf?r|i <n*f 3 % jrt h41h fat; f ?

Or

(3TO8T)

()    What is an Intranet ? Explain the differences and similarities between Internet and Intranet.    7

()    What is a Java-enabled browser ? In what manner is it better than conventional graphical browsers ?    7

(cr)    3    t ? wdz a?K    sfa wmmaif we    i

(ts) im    9H33R qi t ? w    i* faro wr

%5cR % ?

Part B (*jft r)

(Computer Based Information System)

4. What is Financial Information System ? What are the various sources of Financial Information ? What are the outputs Financial Information System ?    13

<n?q*f I ? farfa $ ftftR <f?t t ? f=rfa farfcl TT tfjf    I ?

Or

(3TOTC0

What is Management Information System ? Why is it important for MIS managers to continuously track the technology developments in IT area ? Justify your answer.    13

cfc 3 tfdlpMi'k srenl    qrjof % ? 3T< -3rR

3WT fog    I

I 1

5 What is a Decision Support System ? What are the components of Decision Support System ? Name various tools of Decision Support System. 13

ftufa <br 3 *bh t ? frfa era    I ?

tigiqc| fsrfR    HIHkttai    I

Or

(aroraO

What is Office Automation System ? What are the components of Office Automation System ? Is there any limitation of Office Automation System ? If yes, then explain.    13

chr wn t ?    *1 *    f ?

*fit    w-=n<rn| cm -qfeftw t ?    1

P.T.O.

6.    What is an expert system ? How does it differ from DSS ? What are the advantages of an expert system ? What are the disadvantages of using an expert system ?     14

TPm# 3 JRT | ?     ftlTO WT

f ?    Tmrat r#r aram f ?.

Or

(3Tsrar)

What is Database Approach to manage crucial Business Information ? Explam the advantages of Database Approach. Identify the business areas in which it can be used.    14

oqcrcnq eri w? $ afajfi to ww 3 spn % ?

3#FT     cITO    I ~51 oqcim    3TfTlH%lf<Ti|

fn *n f i

Part C

(mm *0

(Introduction to Essential Tools)

7.    Attempt any three of the following in relation to MS-Word .    3x3

(i) What is Header and Footer ? Can we have different Header for pages in the document ? Justify your answer.

(ii)    Differentiate between Page Break and Section Break. What are the advantages of using Section Break ⁹

(iii)    Is it possible to calculate sum of a column in a table ? If yes, then How ?

I

(iu) What are the ways to secure our crucial business information in MS-Word ?

WI if pHHfdRsId if fsp#        :

(i)    ak -qrfRi ir ?rt t ? srt ii 1; ti t ? srtf '3tr    fas    i

(ii)     sfa argwT facd? if afcrc tw    i aqwi crt m t ?

(Hi) cpfl     %T uRcbRrid cfRTIT t ?

TOT ?

(w) T3C*T.    if 3T*Rt    oJ|m TJRT    cfi SRT cffrfr f ?

8. Attempt any four of the following in relation to MS-Excel    4x3

(i)    Give purpose, syntax and application of IF function.

(ii)    Give purpose, syntax and application of AND function. How does it differ

t

from OR function ?

( 8 ) 6006 (ui) Which function would you use to compute the cumulative principal paid on a loan between two periods when the loan amount is repaid in equated instalments ? Explain with the help of an example.

(iv) Give purpose, syntax and application of HOUND function. How does it differ from ROUNDUP and ROUNDDOWN functions ?

(u) Give purpose, syntax and application of PMT function. How does it differ from IPMT and PPMT functions ?

3 faf rrc <5rR    :

to    cim    3g5I%T    I

(ii) WIT    U%3R, *TOT    I

3 3JcFR t ?

(ui) m     fasif 3    tr,    

=ti^ul HtI Jl TJj-TtR     31FI faT

? T??> I5<.^ul W'i ftf I

(iv)    TTfe    ET    TTT 3y4l^Jl    I 'iriSWr'

<I4S'3I<M Rf 3 fa?? IRiR    t ?

(

(v)    'ft. ttjt. wi    trt afk    i '3TTt. ift. TT. A Tft. TJR. 3 fa* TRRR

glen I ?

You are given the following payroll Information of ABC Ltd., in an Excel Worksheet format :

Column	Type of Information
B	Name of Employee
C	Designation of Employee
D	Whether HRA is Payable or not
E	Basic Salary
F	Grade Pay (GP)

The Dearness Allowance (DA) is payable at 27% of (Basic Salary + Grade Pay)

The HRA is Payable @ 30% of (Basic Salary + GP) to all those having "Yes in Column D

The Travelling Allowance (TA) is payable on the following bases :

Grade Pay	TA Payable
Upto Rs. 4,199	600 + DA thereon at the rate given above
From Rs. 4,200 to Rs. .5,399	1,600 + DA thereon at the rate given above
Rs. 5,400 and Above / /	3,200 + DA thereon at the rate given above

You are required to write a suitable formula to compute any three of the following :

(a)    Amount of DA Payable in Column H

(b)    Amount of HRA Payable in Column I

(c)    Amount of TA Payable in Column J

{d) Total amount of TA Paid to Employees in the Grade Pay of Rs. 6,000.

(e) Total amount of DA Paid to all the Employees whose basic Salary is upto Rs 10,000.    3x3

3     fHHfcfed -qpPF

t :

	qmt w
B	'm
C	cf>[
D	-rr (*<11 *fttt t
E	*|cl
F

m OjeT tcR + Tts %=f) 27% V. | I

1R5BH ftwrar MtIT (ip + Ttf 3<R) 3(94 I    *<m D    % I

Tjrar sTffl PfHfdfisra 3TOR( tr t :

is	rar *rar
4,199	600 + -CR <J,IH T\ TR *Rn
4,200 3 5,399 *	1,600 + TR <J>>K 'nf TR H(N| Rn
5,400 cTn srftw	3,200 + 'TO TR <J)IR R HfN4 W

3fiWt fHHfdfed 3 $ fe# tfrT 3rf*RH     fe@RI t :

W H if Rfnif *T% lf?T I

(19)    I if 'TH ftiOT *1% e?ft Xlfin I

(t) isfir j if 'irai Tiftr i

() 6,000 Tts 3?R    TxT *IRJ    eT Tfftl I

O) 10,000 rW 3>T TJj W?T Hft 4i4lP<4i 1 *#Tl| Mrt fft [<?T Tlf?T I

O

10. Attempt any four of the following in relation to MS-Access :    4x2V6

(i) Explain the concept of referential integrity in relation to MS-Access. What is the purpose of Cascade Update Related Fields ⁹

(u) List out the various data types available in MS-AccesS:

*

(in) Differentiate between "One to One and One to Many Relationship Types

(iv) What is Primary Key ? Is it possible to create a table without assigning a primary key ? If yes, state the disadvantages ?

(u) What is meant by Queries ? Explain the procedure for constructing * Queries with the help of an example.

Wi if PiMtdfisKH    TT ^:3xR <{11*1 :

(i)    TJTR.-3rfWT    Tf pT?7tkHch Wm\\    We

|    SIcR    3I#3R TT | ?

in)    I

(in)    3 ¹    c+nr-m I

(w)        t ? rt 'srrafos cbt %it fn

a, -3? 3*cTTOi    I

(u)     cii?q4 t ? wr gq;    

jc

12,000

6006

12

A

• «
•  Start 
•  Prev 
•  1 
•  2 
•  Next 
•  End 
• »

Unable to read this question paper?

Attachment: university-of-delhi-2010-b-com--hon---marketing-management-35178-1.pdf

• 1
• 2
• 3
• 4
• 5

( 0 Votes )

Add comment

Name (required)

E-mail (required, but will not display)

Notify me of follow-up comments

Refresh

Send

Cancel

JComments

Earning:   Approval pending.