TyBcom.com Logo  
 Home >>
 
 
Computer Systems and Applications

Time: 3 Hours

March – 2004 Marks: 80
 

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 Arithmetic Logic unit?

(ii)

Give an advantage of hard disk over CD-ROM.

(iii)

Give full form of URL.

3
 

b)

Answer the following in C:­

(i)

What is the difference between %c & %s ? 2

(ii)

What is the conditional operator? Give an example.

2

(iii)

What is the use of main() in C-program?

1
 

c)

State whether the following are True or False:

(i)

An operating system is a hardware.

(ii)

In MS- WORD, page numbers are automatically inserted.

(iii)

In MS-WORD, Bullets option is available in TOOLS menu.

3
 

d)

Answer the following in FoxPro :

(i)

Explain the use of:(I) MAX()          (II) DATE()            (III) UPPER()­ 3

(ii)

Explain the following:
(I) SEEK        (II) SET DECIMAL TO

2
       
   

Section I

 
       

Q.2.

a)

Explain briefly about the following : -

(i) CPU        (ii) LAN     (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+=3,j++)
{
    
s+=a*a;
    
printf("\na=%d j=%d";,a,j);
}
printf("\n j=%d a=%d s=%d";j,a,s); 
4
 

c)

Write a program in C to input phone numbers of 10 of your friends and print the list with proper heading such that the numbers appear in the ascending order.

6
       

Q.3.

a)

Answer in one or two lines the uses of:

(i) SPIKEGUARD     (ii) WAN     (iii) HTML

6
 

b)

What does the following C program print?

 main()

int i=1s=;
while(
i<10)
    { 
        if((
i%2) = 0)
            
s+=i;
        else
        {
            
printf("\n s=%d"s);
            continue;
        }
        ++
i;
    }
}
4
 

c)

Write a program in C to input the roll number (rno)and marks(mks) of 10 students and print the result as follows:

Marks

Class

>=60 I
<60 and >=50 II
<50 and >=35 III
6
       

Q.4.

a)

State whether the following are true or false:

(i)

An operating system is an application software.

(ii)

Windows is a Graphic User Interface program.

(iii)

Telnet is a network, which shares news articles.

(iv)

Every computer requires a modem.

(v)

A website contains information about an organization.

(vi)

Impact printers are faster than non-impact printers.

6
 

b)

What is the output of the following C program:

 main()
{
    
int f[10];
    
F[0]=1;
    
f[1]=1;
    
i=2,;
    While (
i<5)
    {
        
f[i]=f[i-1]+f[i-2];
        
i++;
    }
    for(
i=0;i<5;i++)
    {
        
printf("%d",f[i];
    }
4
 

c)

Write a C program in C to accept 10 numbers, calculate & print the mean and mean deviation from mean(md). Use the formula

Mean = Sx / n , md = Sd/n , Where d = | x –mean |

6
       

Q.5. 

a)

Explain briefly about the following:

(i) Impact Printers      (ii) Hard Disk       (iii) Search Engines

6
 

b)

Write a program to find and print the sum of 2/3 + 4/5 + 6/7 + ……. + 20/21

4
 

c)

Write a C program to input 5 pairs of values for x & y, calculate & print the regression coefficient of y on x using the following formula:

byx =

S xy- S x S y/n

S x2-( S x)2/n

6
 

PART B

Q.1.

a)

Answer the following in one sentence: - ­

(i)

What is the purpose of Arithmetic Logic unit?

(ii)

Give an advantage of hard disk over CD-ROM.

(iii)

Give full form of URL.

3
 

b)

Answer the following in MS-Excel:­

(i)

Explain the use of the following functions:
(I) COUNT()          (II) IF()

2

(ii)

Write steps to open a protected file.

2

(iii)

What is the use of Autofill handle?

1
 

c)

State whether the following are True or False:

(i)

An operating system is a hardware.

(ii)

In MS- WORD, page numbers are automatically inserted.

(iii)

In MS-WORD, Bullets option is available in TOOLS menu.

3
 

d)

Answer the following in FoxPro :

(i)

Explain the use of:(I) MAX()          (II) DATE()            (III) UPPER()­ 3

(ii)

Explain the following:
(I) SEEK        (II) SET DECIMAL TO

2
   

Section I

 

Q.2.

a)

Explain briefly about the following : -

(i) CPU        (ii) LAN     (iii) email

6
 

b)

Answer the following in MS-EXCEL :Explain the three ways of referencing the cells.

4
 

c)

Answer the following in MS-EXCEL :Name of the person is entered in the cell A, Basic Salary in B. HRA is 1200, DA is 110% of Basic, Gross = Basic + DA + HRA, tax is 20% of gross, Net is gross-tax. Explain how will you create an Excel table showing Name, basic, da, gross, tax, net. 6
       

Q.3.

a)

Answer in one or two lines the uses of:(i) SPIKE GUARD     (ii) WAN     (iii) HTML

6
 

b)

Answer the following in MS-EXCEL.       What is the difference between Data Sort and Data Filter?

4
 

c)

Answer the following in MS-EXCEL. The following data has been entered in a worksheet

  A B C D E
1 EMPNO SALARY(p.m.) SALARY(p.a.) TAX NET
2 E1 2000      
3 E2 3000      
4 E3 7000      
5 E4 5000      
6 E5 3400      

Write steps to do the following using PASTE SPECIAL:

(1)

Compute annual salary in the cells C2 to C6.

(2)

Compute tax as 20% of the annual salary in the cells D2 to D6.

(3)

Compute net in cells E2 to E6.

6
       

Q.4.

a)

State whether the following are True or False:

(i)

An operating system is an application software.

(ii)

Windows is a Graphic User Interface program.

(iii)

Telnet is a network, which shares news articles.

(iv)

Every computer requires a modem.

(v)

A website contains information about an organization.

(vi)

Impact printers are faster than non-impact printers.

6
 

b)

Answer the following in MS-EXCEL   ­

Explain the following terms/functions –
(i) mod()     (ii) day()     (iii) var()     (iv) pv()

4
 

c)

Answer the following in MS-EXCELThe following data has been entered in a worksheet

  A B C D E
1 Lim1 Lim2 F    
2 15000 20000 17    
3 20000 25000 21    
4 25000 30000 26    
5 30000 35000 18    
6 35000 40000 7    
7 Total        
Write the steps to compute median given by

l1 +

(l2-l1)(n/2-cf)

f

6
       

Q.5.

a)

Explain briefly about the following:

(i) Impact Printers      (ii) Unix       (iii) Search Engines

6
 

b)

Answer the following in MS-EXCEL    State whether the following are True or False :-

(i)

'&' is a reference operator.

(ii)

Macros can be created by chart wizard.

(iii)

Formatting can be done only through FORMAT menu.

(iv)

In the page set up there is only one margin available.

4
 

c)

Answer the following in MS-EXCEL The following data has been entered in a worksheet

  A B C D E
1 YEAR 1992 1993 1995 1996
2 I class 246 391 400 403
3 II class 309 290 102 76
4 Pass class 101 82 12 98
5 Total Pass        
Write the steps
(i)

To create a line diagram with base as years.

(ii)

To represent the data with 3D bar diagram.

(iii) Pie diagram for the year 1993.
6
       
   

Section II

 
       

Q.6.

a)

Mention two suboptions of Program option in start Button of WINDOWS 95.

2
 

b)

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

4
 

c)

Write FoxPro commands to do the following:

(i)

To display all records from record number 10 to record number 20.

(ii)

To locate a record where NAME does not have any alphabet.

(iii)

To rearrange the records alphabetically by COUNTRY and store them in another database AMEDALS.dbf.

(iv)

To view all records where the field TOPIC contains the letters "MS".

(v)

To calculate DA as twice the BASIC for all the records.

(vi)

To delete the records numbered 1, 3, 5.

(vii)

To store squareroot of X in Y.

(viii)

To print the day of week corresponding to the date August 15th 1989.

(ix)

To open existing database file PQR.dbf.

(x)

To execute the program.

10
       

Q.7.

a)

Mention the procedure to delete a file in WINDOWS 95.

2
 

b)

In MS-WORD, mention the procedure to change BOMBAY to MUMBAI in block letters in the entire file.

4
 

c)

Write a program in FoxPro to enter NAME and SALES of a salesman during program execution. Calculate the commission as follows: Commission is 6% of SALES if sales is <= 300000, 10% if SALES is between 300000 and 700000, otherwise it is 15% of SALES. Also display the name, sales & commission.

4
 

d)

Explain the difference between in FoxPro:(i) SORT & INDEX    (ii) EDIT & BROWSE     (iii) CLOSE ALL & USE 6
       

Q.8.

a)

Explain the purpose of My computer in WINDOWS 95.

2
 

b)

Explain the purpose of INSERT menu. Mention any three options.

4
 

c)

There exists a table called ATT.dbf with fields for roll number (RNO, N, 4), student name (NAME, C, 20), percentage of attendance in lectures (PER, N, 6, 2). There exists another table MARKS.dbf with fields for roll number (RNO, N, 4), marks obtained to them in tutorials of Mathematical and Statistical Techniques (M1, N, 4) and Business Communication (M2, 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 roll number.

(ii)

To combine these files to create a new file called TOG.dbf containing roll number, name of the student, attendance and marks in the two subjects.


22
 

d)

There exists a table RESULTS.dbf with fields for roll number (RNO, N, 4), name of student (SNM, C, 20), marks in 3 subjects (M1, M2, M3, N, 3). Write a program in FoxPro to add records to this file. The program should continue as long as the user wants. 6
       

Q.9.

a)

Explain how to create a shortcut on the desktop in WINDOWS 95.

2
 

b)

What is the use of Page Setup in the FILE menu in MS-WORD?

4
 

c)

Explain the following commands or functions in FoxPro :(i) EJECT()    (ii) STR()    (iii) RECALL()    (iv) INT()

4
 

d)

There exists a table EMP.dbf with fields for name (ENAME, C, 15), category [O for officer C for clerk] (CAT, C, 1), basic salary (BASIC, N, 7, 2). Write a program in FoxPro to calculate da, hra, sa, pf, gross, net where da is 75% of BASIC or Rs. 3000 which ever less, hra is 30% of BASIC, sa is 5% of BASIC for officer and 8% of BASIC for clerk, pf is 10% of BASIC or Rs. 300 whichever is more. Gross is BASIC + da + hra + sa. Net = gross - pf. Display name, category, basic, da, hra, pf, gross, net for each record one line at a time. 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.