1. JOSEPH’S COLLEGE OF COMMERCE (AUTONOMOUS)

END SEMESTER EXAMINATION – APRIL 2013

B.Com – II Semester

Computer Applications and MIS

 

Time: 2 hours                                                                                Max Marks: 60

SECTION – A

 

1. Answer the following questions briefly in two or three sentence    (5×2=10)

 

1. What do you mean by Macros in Ms-Word?
2. What is Cybercrime?
3. List four components of a database
4. Distinguish between data and information.
5. What is Network? What are the types of Network?

 

SECTION – B

 

1. Answer any FIVE questions from the following.                     (5×5=25)

 

6. What is DBMS? Explain different types of DBMS models.
7. What do you mean by mail-merging? What are the benefits of this facility?
8. What is a Tag in HTML? Explain the various types of tags with syntax in

HTML?

9. What is ERP? Explain the basic features of ERP.
10. Explain Biometric system with a neat diagram.
11. Give the syntax of any FIVE Financial functions.

 

SECTION – C

 

III.       Answer any ONE question from the following:                             (1×10=10)

 

12. Explain between Data Mining and Data warehouse.

 

13. What do you mean by network topologies? Explain with diagram the four

different types of topologies?

 

SECTION – D

1. IV) Explain the following                                                                       (1 x 15=15)

 

14. Discuss the Impact of Information Technology on society. Explain the

positive and negative aspects.

                                    *********************************

1. JOSEPH’S COLLEGE OF COMMERCE (AUTONOMOUS)

END SEMESTER EXAMINATION – MARCH/APRIL 2014

B.COM (TRAVEL & TOURISM) – II SEMESTER

COMPUTER APPLICATIONS AND MIS

Time: 2 hours                                                                                                Max Marks: 60

SECTION-A

I ) Answer ALL the following questions.  Each carries 2 marks.                  (5X2=10)

1. What is Mail Merge?
2. What is Microsoft Excel?What is cell?
3. What is Denial of Service Attack?
4. What is Network?
5. What are the types of datamodels is DBMS?

SECTION-B

1. II) Answer any FIVE Each carries 5 marks.                                     (5X5=25)
2. What is table? Explain Table feature in MS-Word?
3. Write commands based on the following MS-Excel sheet:

		A	B	C	D	E	F	G
				Sales	Report
	Empid	Name	Qtr1	Qtr2	Qtr3	Qtr3	Total	Avg/SalesPerson
1	1001	Rahul	50	30	35	48
2	1002	Amit	48	44	40	80
3	1003	Mahesh	33	30	34	90
4	1004	Salim	10	20	13	98
5	Max Sales in Qtr
6	Min Sales in Qtr

State the required cell formulas, to find the following:

1. Calculate the total. (Qtr1+Qtr2+Qtr3+Qtr4)
2. Calculate Maximum Sales in each Qtr
3. Calculate Minimum Sales in each Qtr
4. Calculate Average Sales per Sales person
5. Explain ERP. What are the advantages of using ERP in company?
6. Explain Data Mining?
7. What do you mean by Macros in MS- Word? How to set macros in MS – Word?
8. What is tally? What are the different types of vouchers?

SECTION-C

III) Answer any ONE question.  Each carries 10 marks.                                  (1X10=10)

12. Explain about various topologies in networks?
13. Explain the different  html  tags with example?

 

             SECTION – D

1. IV) Compulsory question.          (1X15=15)
2. Write short note on the following:
   a)  Cyber Law 2000
   b)  Biometric security
   c)  Encryption

(5+5+5)
 

St. Joseph’s College of Commerce (Autonomous)

End Semester Examination –MARCH/APRIL 2014

B.COM – II SEMESTER

COMPUTER APPLICATIONS AND MIS

Time: 2 hours                                                                                            Max Marks: 60

SECTION – A

 

1. I) Answer all the following questions. Each carries 2 marks.              (5×2=10)

 

1. What do you mean by template in MS-Word?
2. What is the purpose of what-if analysis?
3. What is the use of web browsers?
4. How to delete a voucher which is created in TALLY?
5. Write the meaning of field and Record in Data Base?

 

SECTION – B

 

1. II) Answer any five Each carries 5 marks.                            (5×5=25)

 

6. Explain OLE in MS-Word.
7. Assume that you want to purchase a two wheeler. You want to take a loan of Rs.50000, which is available at a rate of 8% compound interest. You have to repay it in 10 months. Calculate the payment for this loan based on constant payment and constant interest rate. Write the syntax required using MS-Excel.
8. Explain data filtering and data validation.
9. How can you prepare a source document in HTML? Explain with an example.
10. Explain Data Mining.
11. What do you know about OOD methodology of developing the system?

 

 

SECTION – C

 

III)      Answer any one question from the following.  Each carries 10 marks.                                                                                                                                 (1×10 =10)

12. Explain briefly the following vouchers in Tally with an example of a Journal Entry:

• Contra Voucher
• Payment Voucher
• Receipt Voucher
• Journal Voucher

 

13. What are the major benefits of ERP system to firms?

P.T.O…….

 

 

 

 

 

SECTION – D

1. IV) Compulsory question. (1×15=15)

 

14. Explain the following

 

What are the advantages of DBMS over file processing system? Compare Hierarchical, Relational and Network model of DBMS.