Ravi Tutorials Provide Project Training

FYBCA-ASSIGNMENT-SEM-1




FYBCA-ASSIGNMENT-SEM-1









Assignment – 1                                                     Assignment Date: 21/8/2017
Subject: CPPM                                                     Submission Date:

Questions:
1. Write a C program to interchange value of two numbers using third variable.
2. Write a C program to convert degree to radians. (Formula: degree=Ï€/180)
3. Write a C program to input quantity and price of an item and display total Rs.
on screen. Also input discount (%) and display final payment Rs on screen.
4. Write a C program to input a three digit number from user and calculate sum
of first and last digit.
6. Write a C program to find largest of three numbers using ternary operator.
7. If cost price and selling price of an item are input through the keyboard, write
a C program to determine whether the seller has made profit or loss and
evaluate it.
8. Write a program to read two integer values m and n and to decide and print
whether m is multiple of n.


Download Cppm Assignment sem 1

CPPM Assignment 1

Or
Copy blow link and paste in url.

https://drive.google.com/open?id=0B1qUbNCjnK7Abk81XzFhLU9nMGM

FYBCA OAT ASSIGNMENT SEM 1

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.

Download OAT Assignment sem 1

OFFICE AUTOMATION TOOL ASSIGNMENT 

Assignment – 2

Assignment Date: 05/9/2017

Subject: CPPM

Submission Date:




Questions:
1. Write a C program to find factorial value of any number.
2. Write a C program to generate multiplication table of any inputted number.
3. Write a C program to find all divisors of a inputted number.
4. Write a C program to add first seven terms of following series using for loop
          
5. Write a C program to print Fibonacci series.
          1 1 2 3 5 8 …….
6. Write a C program to print the following pattern
          1
          0 1
          0 1 0
          1 0 1 0
          1 0 1 0 1

7. Write a program to calculate value of square, cube and factorial of all integers from 1 to 7. Print in following format
Number
Square
Cube
Factorial
1
1
1
1
2
4
8
2
3
9
27
6

8. Write a program to sort an integer array in descending order.
9. Write a program to print transpose of a 3x3 matrix.
10. Write a program to add two 3x3 matrix.
11. Write a program to convert upper case string to lower case and lower case to uppercase.
12. Write a program to count number of words, characters, blanks and lines in a multiline string.
13. Write a program to reverse a string.
14. Write a program to swap even positioned character with odd positioned character.

          Eg. computer -> ocpmture