Tilak Maharashtra University

Bachelor of Computer Applications (B.C.A)

Communication Skills

 

 

 

Assignment No. 1

 

Q.1 Read the following passage carefully and answer the questions given below.

 

The aim of education is to draw out all the faculties of the boy on every side of his nature, to develop in him every intellectual and moral power and to strengthen him physically, mentally, spiritually that he may turn out at the end of his educational career a useful, patriotic, pious gentleman, who respects himself and respects those around him. Education is a failure when it is simply cramming the boy's head with a lots of disjointed facts poured into his head as poured into a basket, to be emptied out again in the world. It is not good education which, when a boy has passed his examination, leaves him a nervous wreck exhausted in his body and overstrained in his brain. When a boy goes out of his school or his college, he should be full of energy and full of delight in his young life to take up the burden of the work of the world.

 

  1. What is the theme of this passage?                                                                     1
  2. What is the aim of education?                                                                             2
  3. How does education develop man's personality?                                       2
  4. When education is called a failure?                                                                      2
  5. What is the effect of good education on a boy?                                                     2
  6. Give a suitable heading to the passage.                                                   1

 

Q.2   Use the correct form of the tense.                                                                           5

 

  1. Every day last week my aunt ..........a plate.  (break)
  2. By this time next year, Prakash ......... his university degree.(take)
  3. she ......... her chores very quickly today.(finish)
  4. I ........ this letter  a week ago.(receive)
  5. He .......... tea every morning.  (drink)

 

Q. 3 (A) Give synonyms.                                                                                                2

 

1. refuse        2 norm    3 ancient   4. pact

 

 

Q.3 (B) Fill in the blanks using appropriate alternatives from the brackets.                           3

1. He was ...... monitor of the class. (maid, made)

2. Ram is the .......... of his father's property. (hare, heir)

3. There are lots of ....... in this forest. (deer, dear)

 

 

 

 

 

 

 

 

 

 

 

 

Assignment  No. 2.

 

Q.1 Write a letter. (Any one.)                                                                                          7

 

  1. Write a letter to a book seller complaining against the supply of wrong books.
  2. Write a letter to your father who is away from home for 6 months. Tell him the news on your home front.

 

Q.2 (A) Give   Antonyms.                                                                                                2

 

1. rough     2. deep    3.entry.   4 virtue 

 

Q.2 (B) Change the voice.                                                                                               3

 

  1. Did you not understand my meaning?
  2. Finish the work at once.
  3. I saw him opening the box.

 

Q.3 (A)   Change direct into indirect speech.                                                                    2

 

  1. The mother said to the daughter,''why did you hit your brother?''
  2. The old man said to his sons,''When I am dead,do not quarrel amongst yourselves,

but remain united. Then your enemies will not be able to harm you.''

 

Q.3 (B) Draw a simple bar graph to represent the following yearly profit by a

      Sugar cultivator.                                                                                           6

 

Year

1996

1997

1998

1999

2000

2001

2002

Amt of Profit

(Rs in Lakhs)

32

45

16

23

72

74

65

 

Assignment  No. 3

 

Q.1 Write an essay.                                                                                                       10

 

1.       A Stitch In A Time Saves Nine.

2.       Effects of Science on Our Daily Life.

3.       Childhood..... The Best Period in Our Life.

 

Q.2 Write a report.  (Any one.)                                                                                          7

 

  1. Write a brief report of an accident occurred due to the cloud burst in Asam.
  2. Write a brief report of   the Traditional Day in your college.

 

Q.3   Change the following affirmative sentences to negative or negative to affirmative

         without changing the meaning .                                                                                             3

 

  1. She is a shy girl.
  2. As soon as we entered the hall, the music started.  
  3. He speaks too fast to be understood.

 

 

 

 

 

 

 

Tilak Maharashtra University

Bachelor of Computer Applications

Maths & Stat assignments

Marks: 60 (20 for Each Assignment)

 

Assignment No 1

20 Marks

 

  1. Prove that (A ∩ B)’ = A’ U B’ with DeMorgans’ principles and by sets concepts.

 

  1. Define the function f : R →  R by y = f (x)=x2  X€R complete the following table by using definition. What is Domain and Range of this function?

x          -4   -2  -1   0  1     2    3     4

 

y = f(x) = x2

 

        3.     The function if defined by

1-x                   x<0              

                        1                      x=0                 

fx = x + 1                     x>0     

 

Draw the graph of   f(x).

 

4..Prove that AH = G2. Find A.M, G.M, H.M., if two numbers are 3  & 8.

 

5.Find the sum of n terms of the series whose nth  term is n (n-3)

 

6. Explain the following terms with illustrations :-

                                                  I.      Attribute

                                               II.      Variable

                                             III.      Class limits

                                            IV.      Class marks

                                               V.      Class frequency

 

 

7. Construct subdivided bar diagram for the following data

 

Year                 Import              Export

1980                   25                    23

1981                   35                    37

1982                   31                    30

1983                   28                    32

1984                   32                    30

 

Assignment No 2

20 Marks

 

 

1          If nC8    =          nC2                   find nC2

2          Determine n if

            2n C2                 :           nC2       = 12 : 1

            2n C3     :           nC3       = 11 : 1

3          In how many ways can the letters of the word PERMUTATIONS be arranged if the

a.                   Words starts with P and ends with S

b.                  Vowels are all together

c.                   There are always four letters between P and S

 

4                    Solve the following system of equations,  -

x + y + z = 2

2x + 2z – 3 y = -6

3x  - 2 y + 3z = -4

 

5.                  Obtain the set of non – zero solution

 X + 2y + 3z = 0

2x +   y -   z = 0

3x + 3y + 2z = 0

 

6.                  if 14C5 + 14C6+ 15C7 + 16C8= 17Cr   find r.

 

7.                  Define Mean, Mode and Median.

Calculate Mean Mode, Median for monthly expenditure (in Rs.) of 10 families given below.

 700, 750, 700, 800, 775, 800, 750,  720, 750

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Assignment No 3         

20 Marks

1.                  Find the value of k in each of the following-

10x2 -29x +K+4=0

i)                    The sum of roots is zero.

ii)                   The product of roots is zero.

iii)                 One root is reciprocal of other.

iv)                 Both roots one equal.

v)                  Roots are complex conjugate of each other.

 

2                    Find the modulus of following numbers .

i)                    (2 + 1) (3 – 5 i)

ii)                    7 + i

1 – i

 

3                    Two dice are thrown and sum of the numbers which come up on the dice is noted.

 

            A         :           the sum is even

            B          :           the sum is multiple of 3’

            C         :           the sum is less than 4’

            D         :           the sum is greater than 11’

            Which pair of these events are mutually exclusive?

 

4                    Let Q + be a set of positive Rational as. A, b € Q+, then

i)                     Define binary operation a * b = ab

                                                                           2

           

ii)                   Check < Q +, *> is abelian group.

Double Brace: A,b,c

5          what is composition of relations and find Msor if A = and let R and          S be a relations on A whose matrices are as follows

 

                              1    0      1

               Mr =       1    1       1

                              0     1      0

                       

 

                            1       0          0

            Ms =        0       1          1

                            1       0          1                    

           

                                                             

 

 

6.                  For a group of 10 observation on X

                                                             

            ∑   X = 452 and  ∑ X 2= 24270

            Find  standard deviation.

 

7          The first four raw moments of a distribution are 1, 6, 7 and 64 respectively. Obtain the co – efficient of kurtosis and comment on it.

                                                       

 

 

 

 

 

           

Tilak Maharashtra University

Bachelor of Computer Applications

Office Automation Marks: 60 (20 for Each Assignment)

 

Assignment No: 1

Q.1

   Create a Folder “TMV”.

 In “TMV” folder create “First Semester”

 Go to the Folder “First Semester”; create three files, namely ‘Stud1.txt’, ‘Stud2.txt’ and ‘Stud3.txt’.

 

Q.2

1. Open Ms-Word, type the text from your book then follow the instructions as listed below:

a)      Set the headings as “Information about Ms-Word”; make it bold, font size as 16, underline the text and Font Face “Courier New”.

b)      For rest of the text apply font size as 14, font face as ARIAL BLACK and color as MAROON

c)      Align heading to the center and rest of the text justified.

d)      Save the document.

   2. Create one document file, and then apply your name as header and page number as footer to the pages. Save the same file with your name.

   3. Draw one table of 3 columns and 6 rows. Columns are SRNO, NAME

 and CLASS and fill 5 records. Apply auto formatting to the table. Save the changes.

4. Prepare a letter to invite your 5 guests for inauguration of your shop

   (Hint: use Mail merge)

 

Assignment No: 2

Q1. Prepare PowerPoint presentation, which shows information about “Tilak Maharashtra Vidyapeeth”. This show has to contain at least 7 slides containing slide transition and custom animation effect on mouse click.

Q.2

 1. Create one table of the headings SRNO, Roll No, Name, Mark1, Mark2 and Mark3. Set at least 5 rows with correct detail.

  a) Apply Functions to above table – SUM, AVERAGE, COUNT

  b) Calculate Percentage.

c)      Again add another column as “Grade”, find out these using nested if formula Range for grades are:

A+: Above 75 and less than 100

A: Between 60 and 75

B: Between 50 and 60

C: Between 40 and 50

Fail:  Below 40

 

   Assignment 3

 

Q.1 Create one table as SRNO, Name, Quantity taken, product produced. These are the data, which shows quantity taken by cadets to produce product. So fill up at least 10 records. Using this table, place at sheet no three ‘Line Chart’.

 

Q. 2

Create Database for Maharashtra Bank

Create table Loan. In table Loan following are the fields: LoanNo, BranchName, Amount;

Create form to accept input for the above table.

      Write SQL queries for the following criteria

a)      Find the names of all branches in the loan relation.

b)      Find all the records from Loan , display loan amounts greater than 1000.

c)      Find all loan numbers for loans made at the ‘Aundh’ branch with loan amounts greater than 1200.

d)      Find the loan number of those loans with loan amounts between 90,000 and 1, 00,000.

e)      Find the loan numbers and loan amount for all loans at the ‘Aundh’ branch.

f)        Find the average account balance at each branch.

 

Tilak Maharashtra Vidyapeeth, Pune

Bachelor of Computer Applications (BCA)

Internal Assignment

                                                Subject: Office Automation – Theory                                  

 

Assignment No 1.                                                                                           20 marks

 

Q.1) Answer the following                                         5 Marks

What are different views available in word?

 

 

Q.2) Answer the Following.                                       15 Marks

1.      What is Clipboard?

2.      Explain different options available in page setup menu.

3.      Explain the tools available in formatting toolbar.

4.      Explain the tools available in drawing bar.

5.      Explain different options available in font menu.

 

 

 

Assignment No 2.                                                                                           20 marks

 

Q.1) Answer the following.

1.      What is mail merge? Explain in details.                    

2.      What is function? Name some commonly used functions.

3.      What is conditional formatting?                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                

4.      Explain the steps to create the chart.

 

 

 

 

Assignment No 3.                                                                                           20 marks

 

Q.1) Answer the following.

 

1.      Explain different views in PowerPoint.

2.      What is master slide?

3.      What are the different effects that you can give using animation?

4.      Explain different data types in Access?

 

 

 

 

Tilak Maharashtra University

Bachelor of Computer Applications

Introduction to Computer And Operating System (44112)

Marks: 60 (20 for Each Assignment)                                           

 

Assignment No:    1

 

A]        Fill in the blanks and rewrite                                                                  [5]

  1. _______ actually executes the instructions and performs all the calculations and decisions.
  2.  The Father of Modern Digital Computer is ___________.
  3. Personal computer was introduced for use in office, home and schools in 1981 by___________.
  4. The first transistorized computer was PC-AT.
  5. The __________ uses a hard sphere to control cursor movement.

 

 

C]      Answer the following                                                            [15]

1.      Explain the organization of Computer System.

2.      Explain the classification of computer.

3.      Define: Peripheral Devices, Input Devices, and Output Devices.

4.      What are non-impact printers? Describe any two types.

5.      Write short notes on: Voice recognition System, Computer Output Microfilm (COM) and 4th Generation of Computers.

 

 

Assignment No:    2

 

A]        Fill in the blanks and rewrite                                                                  [5]

  1. EPROM is __________
  2. Secondary storage is also called ________
  3. The assembly languages use the _____ in place of operation codes.
  4. A __________ is a pictorial representation of the algorithm.
  5. C was designed and developed at _______

 

 

C]      Answer the Following                                                           [15]

  1. Write a note on Primary Storage.
  2. Write note on Sequential Access, Direct Access & Optical Devices.
  3. Short note on 4 GL, Assembly Language.
  4. Draw a flowchart for following: -
    1. Accept 5 numbers from user and print the Minimum amongst the both.
    2. Accept 5 numbers from user, one at a time and print their average.
    3. Find the area & Perimeter of a Rectangle with sides S1 & S2.

 

Assignment No:    3

 

A]        Fill in the blanks and rewrite                                                                  [5]

1.      The _______ is a program in execution.

2.      In ________ systems, two or more CPUs are connected together.

3.      In _________, it is possible to run more than one application at a time.

4.      Central computer is also called the _________

5.      The geometrical arrangement of nodes in the network is known as ______

 

B]      True or False                                                                             [5]

1.      The operating system acts as an interface between the user and the computer.

2.      The total amount of work performed by the operating system over a period of time is known as response time.

3.      Spooling means Simultaneous Peripheral Output On Line.

4.      In a star network a number of computers and devices are connected to each other in a closed loop arrangement.

5.      Digital signal is converted into an analog signal for transmission is known as demodulation.

 

C]      Answer the following                                                            [5]

1.      Explain functions of Operating system.

2.      What is multiprogramming

3.      What is Character map?

4.      What are the advantages of Windows operating system over dos?

5.      What is Multiprocessing?

 

D]      Match the following                                                              [5]

 

Column A                                            Column B

1.                  Network layer              a) Non essential network services

2.                  Application Layer         b) is between the physical and network layer.

3.                  Presentation Layer        c) Includes physical elements i.e. hardware

4.                  Physical Layer              d) Provides services for the end user

5.                  The Data link layer        e) determines the route between source and destination.