TYBCOM Sem 6 Computer Question Paper | Download free pdf

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.

	A	B	C	D	E
1	NAME	TOTAL SALES	COMMISSION	BONUS	TOTAL EARNING
2	KARAN	85,000
3	ANITHA	63,000
4	SHARAN	248,000
5	MEGHA	125,000
6	PRATHAM	260,000
7	SUHAS	75,000

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

SALES AMOUNT	RATE OF COMMISSION
FIRST 50,000	8%
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.

	A	B	C	D	E	F	G	H	I	J
1	RNO	MARKS	GRADE	DIV		MARKS	0	40	70	80
2	23	86				GRADE	F	D	A	O
3	32	74				DIV	FAIL	DIV C	DIV B	DIV A
4	43	34
5	56	44
6	67	79
7	70	98
8	87	77

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

	A	B	C	D	E	F
1	NAME	BASIC SALARY	CITY	DA	HRA	GROSS
2	ANITA	18,650	MUMBAI
3	SACHIN	29,300	PUNE
4	SUNIL	61,000	HYDERABAD
5	NIRMAL	50,500	MUMBAI
6	ALPA	40,000	PUNE

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.

	A	B	C	D	E	F	G	H	I
1	FLAT	UNITS	RATE	UNIT CONSUMPTION CHARGES	FIXED	BILL		UNITS	RATE
2	101	50			65			0	2.60
3	102	120			90			100	5.62
4	201	600			300			300	7.20
5	201	340			150			500	8.95
6	301	245			90
7	302	700			300
8	401	45			65

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.

	A	B	C	D	E
1	PRODUCT	2015	2016	2017	2018
2	DESKTOP	113.6	103.3	97.8	94.4
3	LAPTOPS	163.1	156.8	161.6	162.3
4	TABLETS	208	174.9	163.7	150.3
5	TOTAL

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.

	A	B	C	D
1	PRODUCT NAME	PRICE	QUANTITY	TOTAL SALES
2	PEN DRIVE	450	100
3	CHARGER	500	125
4	MOUSE	650	250
5	GRAND 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.

	A	B	C	D	E
1	NAME	GENDER	AGE	CITY	SALES
2	MUKUND	M	25	SURAT	498,000
3	RAVEENA	F	23	NASIK	575,000
4	SNEHA	F	26	CHENNAI	378,000
5	PRAVEEN	M	29	NASIK	600,000
6	VILAS	M	32	KOLKOTA	645,000
7	ANIKET	M	27	NAGPUR	792,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.