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
Paper.VIINTRODUCTION TO COMPUTERS AND INFORMATION SYSTEM (New Course * Admission of 2004 onwards)
Time . IV2 Hours (For Part A) Maximum Marks : 35
A
Time : IV2 Hours (For Part B or C) Maximum Marks : 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
( 2 ) 6006
() List, some of the advantages and disadvantages of using E-mail. 7
() What is a news group ?
(c) What is Telnet 9 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 ?
*1
Or
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
(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 quti <>1fl<< I
(?) jrt t ? 3tf?r|i <n*f 3 % jrt h41h fat; f ?
Or
() 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 % ?
(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
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
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 ?.
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|
(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 9
(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 ?
=tiul HtI Jl TJj-TtR 31FI faT
? T??> I5<.ul W'i ftf I
(iv) TTfe ET TTT 3y4lJl 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
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
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
() 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 9
(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 1 c+nr-m I
(w) t ? rt 'srrafos cbt %it fn
a, -3? 3*cTTOi I
(u) cii?q4 t ? wr gq;
jc
6006
12
Attachment: |
Earning: Approval pending. |