- 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)
- What is Mail Merge?
- What is Microsoft Excel?What is cell?
- What is Denial of Service Attack?
- What is Network?
- What are the types of datamodels is DBMS?
SECTION-B
- II) Answer any FIVE Each carries 5 marks. (5X5=25)
- What is table? Explain Table feature in MS-Word?
- 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:
- Calculate the total. (Qtr1+Qtr2+Qtr3+Qtr4)
- Calculate Maximum Sales in each Qtr
- Calculate Minimum Sales in each Qtr
- Calculate Average Sales per Sales person
- Explain ERP. What are the advantages of using ERP in company?
- Explain Data Mining?
- What do you mean by Macros in MS- Word? How to set macros in MS – Word?
- What is tally? What are the different types of vouchers?
SECTION-C
III) Answer any ONE question. Each carries 10 marks. (1X10=10)
- Explain about various topologies in networks?
- Explain the different html tags with example?
SECTION – D
- IV) Compulsory question. (1X15=15)
- Write short note on the following:
a) Cyber Law 2000
b) Biometric security
c) Encryption
(5+5+5)
Latest Govt Job & Exam Updates: