FYBCA OAT ASSIGNMENT SEM 1

FYBCA  ASSIGNMENT

Q1	Write 3 Paragraphs on Internet in MS Word and Do Following.
	1)   Apply Page Border. 2)   Apply 1.5 line spacing in all paragraph. 3)   Split 3rd Paragraph in to 3 columns. 4)   Apply Drop Cap effect in second paragraph. 5)   Insert Image behind the First Paragraph. 6)   Apply Header and Footer. 7)   Apply Protection to your document. 8)   Apply proper water mark.
Q2	Perform the following a)   The first document displays FYBCA students information as Seat No., Name, Father Name, Address, City, Phone, Email( Input data at least 5 records) Apply proper formatting. Use Table to store data. Apply link on student Seat No with his/ her mark sheet in the second document. b)   In the second document, prepare all students mark sheet for FYBCA using table      Apply proper formatting Each mark sheet must be on individual on second document. c)   Protect both the documents.
Q3	Create an Interview Call letter for the post of lecturer in BCA and send it to the 5 candidates using Mail Merge
Q4	Prepare letter for parents meeting for college students send it to 10 parents using mail merge.
Q5	Calculate Salary Statement based on the Criteria.
	EmpID EName Basic Salary 101 Ramesh Patel 50000 ----- ------------------- ---------
	1)   Calculate DA based on following criteria:
	a.    If Basic Salary < 20000 then DA is 20% of Basic Salary.
	b.    If Basic Salary >= 20000 &<=40000 then DA is 40% of Basic Salary.
	c.    Else DA is 50% of Basic Salary.
	2)   Calculate HRA that is 25% of Basic.
	3)   MA is fixed for all employees that are 5000.
	4)   PF is 25% Basic Salary.
	5)   Calculate Net Salary i.e. (Basic Salary + HRA + DA + MA) – PF
	6)   Retrieve record of Employee whose Net Salary is between 40000 & 80000
	7)   Display EmpID & EName for those employees getting minimum Basic Salary 20000.
	8)   Apply Auto Format to Database.
Q6	Calculate Student Mark sheet based on the Criteria.
	SID SName I.C. Mathematics C.S. CPPM OAT ------ ---------- ------- ---------------- ------ ---------- ---------
	Note: Passing marks is 28 and maximum marks are 70.
	1)   Validate all 5 subject marks column with minimum of value 0 and maximum of 70.
	2)   Give conditional formatting on all subject marks column. a.    Apply RED font color for marks < 28. b.    Apply Green font color for marks >=28.
	3)   Calculate Total & Percentage.
	4)   Give Class (Distinction, First Class, Second Class, Pass Class & Fail).
	5)   Get Record of Top Student.
	6)   Obtain total number of Pass and Total number of Fail Students.
	7)   Draw column chart of SName v/s. Percentage (SName on X – axis and Percentage on Y - axis).
	8)   Apply Auto Format to Database.
Q7	Create Presentation with at least five slides on Impact of Social Networking Sites.
Q8	Create Presentation with at least five slides on your Temple of Gujarat.
Q9	Record a macro of above Question-1 using keyboard as well as button.
Q10	Create a student mark sheet using a table with following formatting: a)   Apply proper border and shading to table. b)   The table should be fit to content. c)   The alignment of the table should be center left. d)   Apply proper table style. e)   Calculate the total marks of student using formula in table.