Exam Details
| Subject | software for data management | |
| Paper | ||
| Exam / Course | commerce | |
| Department | ||
| Organization | Mar Ivanios College | |
| Position | ||
| Exam Date | November, 2016 | |
| City, State | kerala, thiruvananthapuram |
Question Paper
(Pages 1496
P.T.O.
MAR IVANIOS COLLEGE (AUTONOMOUS)
THIRUVANANTHAPURAM
Reg. No. :.………………… Name :.………………….
Fifth Semester B.Com. Degree Examination, November 2016
First Degree Programme under CBCSS
Elective Course: Commerce III (Stream
AUCO591.a: Software for Data Management
Time: 3 Hours Max. Marks: 80
SECTION A
Answer ALL questions in one or two sentences.
1. What is Real time processing
2. What are Contextual tabs
3. What is Cell Referencing
4. What is a Legend
5. What is Macro
6. What is Ratio Scale
7. What is Discrete Data
8. Name any four RDBMS programme.
9. What is Primary Key
10. What is an Action query
(10 × 1 10 Marks)
SECTION B
Answer any EIGHT questions, each in a short paragraph not exceeding 50 words.
11. What are the features of Information
12. Explain the procedure in inserting and deleting rows in excel worksheet.
13. What is absolute cell referencing
14. What is a Pivot Table
1496
2
15. List some financial functions in excel
16. What are elements of SPSS variable view
17. What is ANOVA
18. What is Database Management System
19. What is Navigation Pane
20. What are the table views available in Access
21. What is axis title How to add axis title in Excel
22. What is an Independent variable
× 2 16 Marks)
SECTION C
Answer any SIX questions, each in a paragraph not exceeding 120 words.
23. What are the stages in Data Life Cycle
24. Distinguish between Data and Information.
25. What are the types of operators in Excel
26. What is an electronic spreadsheet What are its advantages
27. Explain the TPMT function in Excel.
28. What are the types of Missing Values in SPSS
29. What is Descriptive Statistics
30. Explain the different types of queries.
31. What is the procedure for creating relationships in Access tables
× 4 24 Marks)
SECTION D
Answer any TWO questions, not exceeding four pages.
32. What is Data processing Explain the methods and types of data processing.
33. Explain the Financial, Logical and Statistical functions in Excel using examples.
34. What is SPSS Explain the layout of SPSS.
35. What is a Database Briefly explain the objects in MS Access.
× 15 30 Marks)
P.T.O.
MAR IVANIOS COLLEGE (AUTONOMOUS)
THIRUVANANTHAPURAM
Reg. No. :.………………… Name :.………………….
Fifth Semester B.Com. Degree Examination, November 2016
First Degree Programme under CBCSS
Elective Course: Commerce III (Stream
AUCO591.a: Software for Data Management
Time: 3 Hours Max. Marks: 80
SECTION A
Answer ALL questions in one or two sentences.
1. What is Real time processing
2. What are Contextual tabs
3. What is Cell Referencing
4. What is a Legend
5. What is Macro
6. What is Ratio Scale
7. What is Discrete Data
8. Name any four RDBMS programme.
9. What is Primary Key
10. What is an Action query
(10 × 1 10 Marks)
SECTION B
Answer any EIGHT questions, each in a short paragraph not exceeding 50 words.
11. What are the features of Information
12. Explain the procedure in inserting and deleting rows in excel worksheet.
13. What is absolute cell referencing
14. What is a Pivot Table
1496
2
15. List some financial functions in excel
16. What are elements of SPSS variable view
17. What is ANOVA
18. What is Database Management System
19. What is Navigation Pane
20. What are the table views available in Access
21. What is axis title How to add axis title in Excel
22. What is an Independent variable
× 2 16 Marks)
SECTION C
Answer any SIX questions, each in a paragraph not exceeding 120 words.
23. What are the stages in Data Life Cycle
24. Distinguish between Data and Information.
25. What are the types of operators in Excel
26. What is an electronic spreadsheet What are its advantages
27. Explain the TPMT function in Excel.
28. What are the types of Missing Values in SPSS
29. What is Descriptive Statistics
30. Explain the different types of queries.
31. What is the procedure for creating relationships in Access tables
× 4 24 Marks)
SECTION D
Answer any TWO questions, not exceeding four pages.
32. What is Data processing Explain the methods and types of data processing.
33. Explain the Financial, Logical and Statistical functions in Excel using examples.
34. What is SPSS Explain the layout of SPSS.
35. What is a Database Briefly explain the objects in MS Access.
× 15 30 Marks)
Other Question Papers
Subjects
- accounting for specialised institutions
- applied costing
- auditing
- banking theory & practice
- business communication and office management
- business regulatory framework
- business statistics
- capital market
- co – operative legal system
- co – operative management & administration
- co-operative accounting
- company administration
- computer application for publications
- computerised accounting
- core methodology and perspectives of business education
- corporate accounting
- cost accounting
- entrepreneurship development
- environmental studies
- financial accounting
- financial management
- financial markets and services
- functional application of management
- fundamentals of financial accounting
- fundamentals of income tax
- income tax law and accounts
- informatics and cyber laws
- information technology in business
- management accounting
- management of foreign trade
- managerial economics
- methodology and perspectives of business education
- principles of co – operation
- project finance
- software for data management
- web designing & production for business