TYBCOM Sem 6 Computer Question Paper
TYBCOM Sem 6 Computer Question Paper

TYBCOM Sem 6 Computer Question Paper

April 2019

[2 Hours] [Total Marks: 75]

Note:
1) All questions carry equal marks and are compulsory.
2) Figures to the right indicate maximum marks for a question.

Q1. (A) Attempt any two sub-questions from a), b),and c) in MS- EXCEL (True or False) : (2 MARKS).

a) The result of a logical formula is a numeric value.
b) The Trim( ) function removes all blank spaces from the string argument.
c) Solver problems are limited to a single changing cell.

(B) Attempt any two sub-questions from d), e) and f) in VISUAL BASIC (Multiple Choice) : (2 MARKS)

d) Double clicking on the command button icon in the tool box will____________.
A) Do nothing.
B) Highlight it.
C) Place it on the form.
D) Delete it.

e) ___________ is the final keyword used to indicate the end of a sub procedure.
A) Exit Sub.
B)End Sub.
C) Exit .
D) Quit.

f) The full form of VBP is___________.
A) Visual Binary Project.
B) Visual Basic Project.
C) Very Basic Project .
D) Visual Basic Parameter.

C) Attempt any six sub-questions from g), h), i), j), k), b. m), n), o) in E-Commerce. (True Or False) : (6 MARKS)

g) Transaction broker earns money in the form of commission-each time a transaction occurs.
h) Richness refers to the total amount of information that is available to all the stakeholder.
i) Content provider is one of the major B2B model.
j) In SET the customer’s credit card number is never seen by the merchant.
k) Integrity refers to the ability to determine the origin of the message received over the Internet.

I) The cost of the products sold through E-Commerce is very high.
m) In SSL, encryption is based on session key which is unique and is different for each session.
n) M-Commerce means buying and selling of goods and services using a laptop.
o) Digital signature is used to authenticate the identity of a person involved in E-commerce.

D) Attempt any five sub-questions from p), q), r), s), t), u), v), w) in E-Commerce. (Multiple Choice) : (5 MARKS)

p) Yahoo is a__________.
A)Portal.
B)E-Tailer.
C) Transaction Broker.
D) None of these.

q) In___________ E-Commerce one business makes deals with another Business.
A) C2C.
B) B2C.
C) B2B.
D) C2B.

r) The model in E-Commerce where companies earn revenue by referring users to other websites providing products/services is called___________ model.
A) Advertising.
B) Affiliation.
C) Sales.
D) Transaction.

s) The full form of SET in E-Commerce is____________.
A) Secure Electronic Tax.
B) Secure Electronic Transaction.
C) Secure Electronic Territory.
D) Secure Electronic Tunnel.

t) Conversion of coded data into readable data is called___________.
A) De-conversion.
B)Decryption.
C)Encryption.
D)Password.

u) The sender and receiver will have the same key in___________ Key encryption
A) Symmetric.
B) Asymmetric.
C) Public.
D)Private.

v)__________ are sites that create a digital online environment where people with similar interest can do transaction.
A) Community Provider.
B) Market Creator.
C) Portal.
D) Service Provider.

w) A Computer to Computer exchange of business transaction is called___________.
A) E-Business.
B)Super Market.
C)EDI.
D)E-Market.

Q2. (A) Answer any one sub-question from a) and b) in E-Commerce : (8 MARKS)
a) Explain the features of E-Commerce.
b) Explain the following B2C models in E-commerce.
(i) E-Tailer.
(ii) Content Provider.
(iii) Transaction Broker.

(B) Answer any one sub-question from c) and d) in E-Commerce : (7 MARKS)
c) What is M-commerce? What are its applications?
d) Explain SET protocol.

Q3. (A) Answer any one sub-question from a) and b) in MS-EXCEL : (8 MARKS)
a) Consider the following worksheet.

ABCDE
1NAMETOTAL SALESCOMMISSIONBONUSTOTAL EARNING
2KARAN85,000
3ANITHA63,000
4SHARAN248,000
5MEGHA125,000
6PRATHAM260,000
7SUHAS75,000

Write steps to :
i) Calculate Commission in column C using the following Commission Policy.

SALES AMOUNT RATE OF COMMISSION
FIRST 50,0008%
NEXT 75,000 10%
EXCESS 12%

ii) Calculate Bonus as 4% of the total sales whenever the sales is above Rs.2, 00, 000 otherwise no bonus is given.
iii) Calculate Total Earning where Total Earning = Commission + Bonus.

b) Consider the following worksheet. Write steps to compute Grade and the Division for next year in Column C and D respectively using HLOOKUP function. Policy table to be referred for finding Grade and Division for next year is given in the range G1:J3.

ABCDEFGHIJ
1RNO MARKS GRADE DIVMARKS 0 407080
22386GRADEFDAO
33274DIVFAILDIV CDIV BDIV A
44334
55644
66779
77098
88777


(B) Answer any one sub-question from c) and d) in MS-EXCEL : (7 MARKS)
c) Consider the following worksheet

ABCDEF
1NAMEBASIC SALARYCITYDAHRAGROSS
2ANITA 18,650MUMBAI
3SACHIN29,300PUNE
4SUNIL61,000HYDERABAD
5NIRMAL50,500MUMBAI
6ALPA40,000PUNE

Write steps to compute the following :-
i) DA as 125% of basic salary whenever the basic salary is 30,000 or less otherwise as 135% of the basic salary.
ii) HRA is 25,000 for “Mumbai” city and 18,000 for other cities.
iii) Gross = Basic Salary + DA + HRA.

d) Consider the following worksheet showing the electricity consumption in a building.

ABCDEFGHI
1FLAT UNITSRATEUNIT CONSUMPTION CHARGESFIXEDBILLUNITSRATE
2101506502.60
3102120901005.62
42016003003007.20
52013401505008.95
630124590
7302700300
84014565

Write steps to compute the following :
i) Find Rate using VLOOKUP function. Policy table to be referred is in the range H2:15.
ii) Calculate Unit Consumption Charges in column D where Unit Consumption.
Charges = Units * rate
ii) Bill = Unit Consumption Charges + fixed charges.

Q4. (A) Answer any one sub-question from a) and b) in MS-EXCEL : (8 MARKS)

a) The following table shows the shipment forecast of tablets, laptops and Desktop PCs worldwide for the year 2015, 2016, 2017 and 2018.

ABCDE
1PRODUCT2015201620172018
2DESKTOP113.6103.397.894.4
3LAPTOPS163.1156.8161.6162.3
4TABLETS208174.9163.7150.3
5TOTAL

Write the steps to :
i) Find the total product shipped in the year 2015, 2016, 2017, 2018 in the cells B4, C4, D4 and E4.
ii) Create 3-D Bar chart for the above data.
iii) Create a Line diagram for the year 2015 and 2018.
iv) Create a Pie chart for the year 2017.

b) The following worksheet contains the Price Per Unit and quantity sold of some products in a year. Write steps to calculate Total Sales in column D and Grand Total Sales in D5.
For the company to break even, it has to achieve a Grand Total Sales of Rs. 18, 00, 000 in a year. Using solver, find out the number of units of each of these three products that should be sold in order to meet the desired target sale.
Where Total Sales=Price*Quantity and Grand Total Sales=Sum of D2 to D4.

ABCD
1PRODUCT NAMEPRICEQUANTITYTOTAL SALES
2PEN DRIVE450100
3CHARGER500125
4MOUSE650250
5GRAND TOTAL


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 Excel worksheet.

ABCDE
1NAMEGENDERAGECITYSALES
2MUKUNDM25SURAT498,000
3RAVEENAF23NASIK575,000
4SNEHAF26CHENNAI378,000
5PRAVEENM29NASIK600,000
6VILASM32KOLKOTA645,000
7ANIKETM27NAGPUR792,565

Write steps to :
(i) Display only those rows where the sales is less than 40,000.
(ii) Display only those rows where the gender is “M”.
(iii) Display only those rows where the city name starts with “N”.

d) Explain the following functions in MS-EXCEL.
1) DAY( )
2) NOW( )
3) YEAR( )
4) DAYS360( )
5) CORREL( )
6) COUNTA( )
7)LARGE( ).

Q5. (A) Answer any one sub-question from a) and b) in VISUAL BASIC : (8 MARKS)

a) Write a project in VB to design a suitable form which allows the user to enter Amount in Dollars and Rate of Conversion to Rupees and then calculate and display equivalent amount in Rupees.

b) Write a project in VB to design a suitable form which allows the user to enter Name and Basic Salary and calculate DA as 95% of Basic Salary
whenever basic salary is less than 45,000 otherwise 110% of Basic Salary using a ‘Calculate’ button and display the result.

Q5. (B) Answer any one sub-question from c) and d) in VISUAL BASIC : (7 MARKS)
c) Write a project in VB to design a suitable form which allows the user to enter Product Name, Quantity Sold and Price per Unit of a product and then calculates and displays the Total Cost (Total Cost = Quantity Sold * Price per Unit)

d) Write a project in VB to design a suitable form which allows the user to enter an integer and calculate and display the factorial of that integer when the “Calculate” button is clicked (Factorial of N= 1*2*3———*N).

TYBCOM Sem 6 Computer Question Papers 2019 pdf

TYBCOM Sem 6 Question Papers 2019

Related Posts :
FYBCOM Subjects
SYBCOM Subjects
TYBCOM Subjects
FYBCOM Syllabus
SYBCOM Syllabus
TYBCOM Syllabus

Tips to score good marks in TYBCOM Exam

  1. Don’t wait until the last minute to start studying: begin early. You’ll have more time to learn the topic and solve questions, the earlier you start.
  2. Remain arranged: Plan a study schedule and stick to it. Take time to rest and refresh during breaks.
  3. Regularly review your notes: Regularly reviewing back your notes will help you keep the content in your memory.
  4. Practice, practice, practice: By working through sample problems and completing sample tests, you can identify your areas of weakness and become familiar with the exam’s format.
  5. Ask for assistance if you need it: If you’re having trouble with the subject, don’t be shy to ask for assistance. You can seek advice from your teacher, a classmate, or a tutor.
  6. Get a good night’s sleep: The night before the exam, be sure to get lots of rest. A mind that has got enough sleep is better prepared to memorize and recall information.
  7. Arrive early on exam day: Arrive early on the day of the exam to give yourself time to settle your worries and mentally prepare.
  8. Stay focused during the exam: Avoid being distracted during the exam by remaining focused. Take a deep breath and return your attention to the activity at hand if you realize that your mind is roaming.
  9. Don’t waste too much time on any one question: keep an eye on the time. If you start to struggle, leave it and return to it later.
  10. Review your exam after you’re done: After you’re finished, review your paper for a while. By doing this, you’ll be able to correct any mistakes you may have made and provide any answers you’re not sure about.