TyBcom.com Logo  
 Home >>
 
 
Computer Systems and Applications

Time: 3 Hours

March – 2003

Marks: 100

 

N.B.

(1)

Attempt either PART A or PART B. Question No. 1 is compulsory.

 
 

(2)

In Section I, attempt any two questions from question Nos. 2 to 5.

 
 

(3)

In Section II, attempt any two questions from question Nos. 6 to 9.

 
 

(4)

All answers should be written the same answer book.

 
 

(5)

Figures to the right indicate maximum marks. All questions carry equal marks.

 
       
    PART A  

Q.1.

a)

Answer the following in one sentence: - ­

(i)

What is the purpose of control unit?

(ii)

Give an advantage of hard disk over CD-ROM.

(iii)

Give full form of ISP.

3
 

b)

Answer the following in C:­

(i)

What is the difference between putc( ) & puts( ) ?

(ii)

Mention different types of storage classes in C?

(iii)

What is the use of continue statement?

 221
 

c)

State whether the following are true or false:

(i)

ROM is a volatile memory.

(ii)

In MS- WORD, page numbers are automatically inserted.

(iii)

In MS-WORD, break option is in VIEW menu.

3
 

d)

Answer the following in FoxPro :

(i)

Explain the use of:

(I) LEFT()          (II) TRIM()            (III) STR()­

(ii)

Explain the following:

(I) CREATE        (II) SET EXACT ON/OFF

 3 2 
       
    Section I  
       

Q.2.

a)

Explain briefly about the following : -

(i) MODEM        (ii) UNIX     (iii) email

6
 

b)

What is the output of the following C program : -

main()

{  int a=2,s=0,j=l;

    for(;a<10;a+=3j++)

        { s+=a*a*a;

           printf("\na=%d j=%d",a,j);

        }

    printf("\nj=%d a=%d s=%d"j,a,s); }

4
 

c)

Write a program in C to input 10 numbers & then calculate, print the mean and standard deviation of these numbers. Use the formula

6
       

Q.3.

a)

Answer in one or two lines the uses of:

(i) SPIKEGUARD     (ii) LAN     (iii) Bulletin Board Service

6
 

b)

What docs the following C program print?

main()

{

     int a(int);

     int i=3.kj;

     k=++i;

     j=a (i++);

     printf("\ni=%d k=%d j=%d",i,k,j);

}

a(int p)

{

     ++p;

     return (p); }

4
 

c)

Write a program in C to input bill number (bill), sale value (sv). Calculate the sales tax as

Sales

Tax Rate

First 10,000 4%
Next 25,000 8%
Next 8,000 10%
Excess 11.5%

Print bill number, sales amount as well as tax with proper heading.

6
       

Q.4.

a)

State whether the following are true or false:

(i)

An operating system is software.

(ii)

Windows is a Graphic User Interface program.

(iii)

Laser printers are impact printers.

(iv)

Telnet is a network, which shares news articles.

(v)

WAN system allows the user to share software, hardware & data.

(vi)

DOS allows us network facility.

6
 

b)

What is the output of the following C program:

#define f(x) x>=0? "real" : "complex"

main()

{

int a=2,b=7,c=7,d;

d=(b*b-4*a*c);

printf("\n d is a %s value", f(d));

4
 

c)

Write a C program in C to accept 50 numbers, arrange them in ascending / descending order & print only the largest & the smallest value.

6
       

Q.5. 

a)

Explain briefly about the following:

(i) Floppy Disk      (ii) LAN       (iii) SEARCH ENGINES

6
 

b)

Write a program to find and print the sum of 2/32 + 4/52 + 6/72 + ……. + 20/212

4
 

c)

Write a C program to generate first 50 prime numbers.

6
       
 
 
PART B

Q.1.

a)

Answer the following in one sentence: - ­

(i)

What is the purpose of control unit?

(ii)

Give an advantage of hard disk over CD-ROM.

(iii)

Give full form of ISP.

3
       
 

b)

Answer the following in MS-EXCEL:­

(i)

Explain the use of the following functions

(I) WEEKDAY()      (II) COUNT()

(ii)

How do you change the height of a row, without knowing any numeric value for it?

(iii)

Explain how to insert a column after column D.

 2 2 1
       
 

c)

State whether the following are true or false:

(i)

ROM is a volatile memory.

(ii)

In MS- WORD, page numbers are automatically inserted.

(iii)

In MS-WORD, break option is in VIEW menu.

3
       
 

d)

Answer the following in FoxPro :

(i)

Explain the use of:

(I) LEFT()          (II) TRIM()            (III) STR()­

(ii)

Explain the following:

(I) CREATE        (II) SET EXACT ON/OFF

 3 2
       
    Section I  
       

Q.2.

a)

Explain briefly about the following : -

(i) MODEM        (ii) UNIX     (iii) email

6
 

b)

Answer the following in MS-EXCEL :

The following data has been entered in a worksheet:

  A B C D

1

ROLL NO MARKS GRADE  

2

120

85

   

3

122

40

   

4

125

80

   

5

130

74

   

6

135

59

   

7

140

90

   

Write steps to compute GRADE as follows:

Marks

Grade

Between 35 & 50

C

Between 50 & 60

B

Above 60

A

4
 

c)

Answer the following in MS-EXCEL

Given the worksheet as follows

  A B C D

1

X Y    

2

15

15

   

3

17

20

   

4

18

18

   

5

16

17

   

6

20

25

   

7

24

17

   

Explain the procedure to calculate coefficient of correlation in cell A10. Use the formula

6
       

Q.3.

a)

Answer in one or two lines the uses of:

(i) SPIKE GUARD     (ii) LAN     (iii) Bulletin Board Service

6
 

b)

Answer the following in MS-EXCEL.

       What is a pivot table? Where it is used?

4
 

c)

Answer the following in MS-EXCEL.

         The following data has been entered in a worksheet

  A B C D

1

AGE(x) No. of persons(f) fx fx2

2

18

17

   

3

20

26

   

4

24

30

   

5

27

24

   

6

30

20

   

7

35

16

   

Explain procedure to find the mean in cell A10 and standard deviation in cell A12 showing the computations of fx & fx2. Use the formula

Mean = Sfx / Sf                     SD = ÖSfx2 / Sf – (mean*mean)

6
       

Q.4.

a)

State whether the following are true or false:

(i)

An operating system is software.

(ii)

Windows is a Graphic User Interface program.

(iii)

Laser printers are impact printers.

(iv)

Telnet is a network, which shares news articles.

(v)

WAN system allows the user to share software, hardware & data.

(vi)

DOS allows us network facility.

6
 

b)

Answer the following in MS-EXCEL   ­

Explain the procedure to remove password from protection password box.

4
 

c)

Answer the following in MS-EXCEL

The following data has been entered in a worksheet

  A B C D

1

ITEM NO 1980 1985 1990

2

410

375

400

300

3

100

150

200

100

4

110

200

250

170

5

109

175

200

155

Write the steps

(i)

To calculate the total in B6, C6 & D6.

(ii)

To construct 3-D Bar diagram.

(iii)

To construct Pie - Chart for the totals.

6
       

Q.5.

a)

Explain briefly about the following:

(i) Floppy Disk      (ii) LAN       (iii) SEARCH ENGINES

6
 

b)

Answer the following in MS-EXCEL

    State whether the following are true or false :-

(i)

Pivot charts cannot be created along with pivot tables.

(ii)

A function cannot contain another function in its argument.

(iii)

Queries can be answered using filter.

(iv)

Cell names and range names can be used in place of cell references in formula.

4
 

c)

Answer the following in MS-EXCEL

       The following data has been entered.

  A B C D

1

CNO CNAME PHONE BALANCE

2

4

KELKAR A.

25624111

40000

3

101

DATE V.

24721742

20500

4

112

KALE A.

25872462

10000

5

88

LIMAYE P.

25671029

35000

6

49

EKBOTE D.

24760023

32100

7

54

GORE M.

24598001

49800

Write the steps to arrange the worksheet in descending order of phone number.

6
       
    Section II  
       

Q.6.

a)

What is a folder in WINDOWS 95?

2
 

b)

What is the use of FORMAT menu in MS- WORD? Mention any three options.

4
 

c)

Write FoxPro commands to do the following:

(i)

To open the file TYRESULT.dbf from C-drive.

(ii)

To display a date before 15 days from today.

(iii)

To change the content of field ROLL_NO of record number 10.

(iv)

To arrange data as per name (NM) using index command.

(v)

To remove all the records from the file currently in use.

(vi)

To extract the first 3 character from the field CITY.

(vii)

To get the price (PRC) of an article from the keyboard.

(viii)

To store a logical value "false" to logical memory variable PASS.

(ix)

To total the values of the field GROSS for all records.

(x)

To find the number of records where the field BAL is more than 500.

10
       

Q.7.

a)

Mention any four options available in the START menu in WINDOWS-95.

2
 

b)

Currently you are editing a document in MS-WORD, mention the procedure to get

UNIVERSITY OF MUMBAI at the top as well as center of every page.

4
 

c)

There exist a table called ADDRESS.dbf with the fields for name of person (NM, C, 20), address (ADR, C, 16), name of the city (CITY, C, 15). Write a program in FoxPro to print a list showing name address & name of city as per dictionary order of city with proper heading.

4
 

d)

Explain the difference between in FoxPro:

(i) STORE…TO & =command    (ii) LIST OFF & LIST FOR     (iii)LOCATE & SEEK

6
       

Q.8.

a)

Explain the procedure to search a file TIMES.doc in WINDOWS-95.

2
 

b)

The file DETAILS.doc, in MS-WORD, contains a table with columns for name, address & phone number. Mention the procedure to arrange data as per name.

4
 

c)

There exist a table called STOCK.dbf with fields for item number (INO, N, 4), item name (ITNM, C, 20), price of each item (PR, N, 8, 2), quantity in hand (QIH, N, 4). There exists another table SALES.dbf with fields for item number (INO, N, 4), date of sales (DTSL, date), quantity sold (QSLD, N, 4).

Write commands in FoxPro

(i)

To open the files in two different work areas as well as create a compound index file for both tables as per item number.

(ii)

To create a new file STOTAL by combining both databases containing the fields ITNO, ITNM, DTSL, QSLD & QIH.

     2 2
 

d)

There exist a table FYBCOM.dbf with fields for name of student (SNM, C, 20), roll number (RN, C, 4) & marks in 3 subjects (M1, M2, M3, N, 3). Write a program in FoxPro to update by putting marks as 35 whenever it is 32 or 33 or 34 for every subject. Print the details of roll number, name, total marks for every record with proper headings.

6
       

Q.9.

a)

Explain how you will rename a file TYBCOM.xls as MCOM.xls in WINDOWS-95.

2
 

b)

What is the use of TOOLS menu? Mention any 3 option in the same.

4
 

c)

Explain the following commands or functions in FoxPro :

(i) SUBSTR()    (ii) SET RELATION TO    (iii) SET DECIMAL TO    (iv) VAL()

4
 

d)

There exists a table SALARY.dbf with fields for employee number (EMNO, C, 5), employee name (EMNM, C, 20), basic salary (BS, N, 10, 2). Write a program in FoxPro to calculate DA as 35% of Basic Salary, HRA as 30% of Basic Salary subject to minimum of Rs. 750 and a maximum of Rs. 2000, Total salary is basic salary + DA + HRA, PF is 12% of Total earnings, Net salary is Total salary-PF. Also include the printing of all these fields in one line for each employee with proper headings. 

6
Top
Concept & Design : Web1 
- Home - Notes N' Tips - University Papers - Notice Board - Discussion Forums - Career Options - Express It - Contact Us -
Copyright © 2017 TyBcom.com. All Rights Reserved.