- JOSEPH’S COLLEGE OF COMMERCE ( AUTONOMOUS)
End Semester ExamINATION –APRIL 2013
B.Com – II Semester (TRAVEL & TOURISM)
Computer Applications and MIS
Time: 2 hours Max Marks: 60
SECTION – A
- I) Answer the following questions briefly in two or three sentence. (5X2=10)
- What is DBMS?
- What do you mean by network?
- How to organise text in a web page?
- What is Templates in MS- Word?
- What is Computer Monitoring?
SECTION – B
- Answer any five questions from the following. (5X5=25)
- What do you mean by mail merging? How will you prepare Mail merge in
MS-Word.
- Write commands based on the following MS-Excel sheet:
| A | B | C | D | E | F | G | |
| Name | English(50) | Maths(50) | Accounts(50) | Total | Percentage | Grade | |
| 1 | Ram | 30 | 30 | 35 | |||
| 2 | Ashwin | 48 | 44 | 40 | |||
| 3 | Rohit | 33 | 30 | 34 | |||
| 4 | Vijay | 10 | 20 | 13 |
Assign the values to appropriate cell location addresses and answer the following:
a .Calculate the total. (English+Maths+Accounts)
- Calculate Percentage.
- Calculate Grade P.T.O…..
Rules for Grading
| Percentage | Grade |
| More than 70 | Distinction |
| More than 60 | First Class |
| More than 50 | Second class |
| More than 40 | Pass |
| Less than 40 | fail |
- Explain the Mesh and Star Network topology with diagram.
- Explain the following
Relational Database Model
Hierarchical Data base Model
Network Data Base Model
- Explain Biometric security with a neat diagram.
- Explain Data Warehouse
SECTION-C
III Answer any one question from the following: (1×10=10)
- Explain any five MS-Excel financial functions with example.
- .Explain any 10 important features of MS WORD.
SECTION – D
- IV) Compulsory question. (15makrs)
- Explain the following
SET (5 Marks)
Firewall (5 Marks)
Cryptography (5 Marks)