BCom TY BCom Sem 6 BCom Sem 6 (2018 2019) April 2019 COMPUTER SYSTEM AND APPLICATIONS Question Paper - Mumbai University | munotes

Questions asked in this paper

• 2) Figures to the right indicate maximum marks for a question

1. Q1 (A) Attempt any two sub-questions from a), b) and c) in MS-EXCEL (True or False) 2 marks
   • a) The logical function AND returns the value TRUE only if all the conditions in it are TRUE
   • b) Achart cannot be moved around ona worksheet
   • c) Filter means getting only those records which are satisfying a given
   • (B) Attempt any two sub-questions from d), e) and f) in VISUAL BASIC 2
   • d) Various controls such as Textbox, Command Button and Option Button can be selected from
   • e) Visual Basic projects are identified by a suffix
   • f) is the final key word used to indicate the end of a sub
   • A) End Do B) End Sub C) End D) Exit Sub
   • (C) Attempt any six sub-questions from g), h), i), j), k), 1), m),n), 0) in E-Commerce. (True Or False) 6
   • g) E-Commerce helps us to buy products from global sellers
   • h) apart of E-Commerce
   • i) Ubiquity refers to Universal Standards
   • j) are focused around a particular market segment
   • k) major drawback of E-Commerce is Security Authentication ensures that the message is not read by others
   • m) customer credit card number is never seen by the merchant
   • n) Encryption means converting readable text into cipher text
   • o) and receiver have the same key in Symmetric Key Encryption
   • (D) Attempt any five sub-questions from p), S), t), u), in E- Pp) segment of E-commerce focuses consumers dealing with each 5
   • q) In revenue model, revenue is generated from sales of goods, information or services Paper Subject Code: 11119/ Computer Systems and Applications
   • r) The full form of SSL is
   • s) SET ensures
   • A) B) D)None
   • t) Sites that process transactions for consumers are
   • u) The percentage of persons who visit a website and buy something is
   • v) is an online retail store
   • w) type of technology scrambles the contents of files sent via the
2. Q2 (A) Answer any one sub-question from a) and b) in E-Commerce. 8 marks
   • a) Explain the following B2C models in E-commerce
   • b) Explain the Security issues in E-commerce
   • (B) Answer any from c) and d) in E-Commerce. 7
   • c) Explain Encryption and Decryption. What is Private and Public key
   • d) is M-commerce? Explain its applications
3. Q3 (A) Answer any one sub-question from a) and b) in MS-EXCEL 8 marks
   • a) The following data has been entered in a worksheet Write the steps to obtain
   • i) DA as 125% of the Basic if Basic is more than 40,000 otherwise 110% of the Paper Subject Code: 11119/ Computer Systems and Applications
   • ii) HRA as 24% of the Basic whenever Basic is below 30,000 otherwise 20% of the Basic in column E
   • iii) Find number of cells where the Basic is above in cell C10
   • b) The following data has been entered in a worksheet NAME MATHS |SP | TOTAL MARKS | RESULT Write steps to
   • i) Find the Total Marks in column E
   • ii) Result in column F where Result is ‘PASS’ if student gets 40 or more in each subject otherwise ‘FAIL’
   • (B) Answer any one sub-question from c) and d) in MS-EXCEL 7
   • c) Consider the following worksheet Write steps to calculate Annual Income in column C and Income Tax in column D where Income-Tax is calculated as follows Also find the total number of people whose monthly salary is less than Paper Subject Code: 11119/ Computer Systems and Applications
   • d) The following data has been entered in a worksheet Write steps to find the CLASS and TA in column C and D respectively using HLOOKUP function. Policy table to be referred for finding the CLASS and TA is given in the range
4. Q4 (A) Answer any one sub-question from a) and b) in MS-EXCEL 8 marks
   • a) The following data regarding marks of students is entered ina Write the steps to
   • i) Find the total marks for each student in the cells E2, E3, E4 and E5
   • ii) Create 3-D Bar chart for the data
   • iii) Create a Pie chart for marks of the student ‘RAVI’
   • iv) Create a Line diagram for the marks in M1 and M2 The following Excel Sheet shows the most likely scenario of monthly expenses and income Write steps to find Total Expenditure in B10 and saving in E5 respectively. Explain steps to create Best and Worst Scenario by changing the values of cells B3 to Paper Subject Code: 11119/ Computer Systems and Applications For Best Scenario change B3 to 15000, B5 to 24000 and B8 to 4000 For Worst Scenario change B3 to 30000, B4 to 7000, B6 to 5000 and then display the summary
5. Q4 (B) Answer any one sub-question from c) and d) in MS-EXCEL 7 marks
   • c) The following data has been entered in a worksheet Write steps to do the following:
   • i) Display only those rows where the Marks are more than 60
   • ii) Display only those rows where the Marks are above average
   • iii) Display only those rows where name contains “N” as second
   • d) Explain the following functions in MS-EXCEL
6. Q5 (A) Answer any one sub-question from a) in VISUAL BASIC Write a project in VB to design a suitable form which allows the user to enter Product name, Quantity sold and Unit Price of a product and calculate and display the Amount ( quantity * Price) correct up to 2 decimal places 8 marks
   • b) a project in VB to design a suitable form which allows the user to enter three numbers and calculate and display the average of these numbers
   • (B) Answer any one sub-question from c) and d) in VISUAL BASIC 7
   • c) Write a project in VB to design a suitable form that allows the user to enter name of the student and the total marks obtained. Display the result as “PASS” if the total marks are more than or equal to 280 otherwise “FAIL”
   • d) Write a project in VB to compute and display the sum of the series

Read from the scan above, so a character or two may differ. The scan is the original.