TyBcom.com Logo  
 Home >>
 
 
Computer Systems and Applications

Time: 3 Hours

October – 2003 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 use of an index hole in a floppy disk?

(ii)

Name any two output devices

(iii)

Give full form of HTTP.

5
 

b)

Answer the following in C:­

(i)

What are the uses of gets and puts? 2

(ii)

Mention the difference between break and continue statement. 2

(iii)

Name any one escape sequence.

1
3
 

c)

State whether the following are True or False:

(i)

The modem is used to connect the computer to the Internet.

(ii)

In MS-WORD, we can save a file with password protection.

(iii)

In MS-WORD, we cannot open more than one document at a time.

3
 

d)

Answer the following in FoxPro :

(i)

Explain the use of:

(i) CTOD()     (ii) LOWER()     (iii) RECNO()

3

(ii)

Explain the following:

(I) INPUT        (II) SET ESCAPE ON/OFF

2
5
       
    Section I  
       

Q.2.

a)

Explain briefly about the following : -

(i) Non Impact Printers        (ii) LAN     (iii) Browsers

6
 

b)

What is the output of the following C program : -

main()
{
int i=200,j=3509;
float x=198.73546,y=-201.8892
printf(“\n%5d%+-5d”,i,j);
printf(“\n%5.3f%+-10.2f”,x,y);
}

4
 

c)

Write a program in C to input cost of machinery (cost) and rate of depreciation (rate). Calculate and print a table that displays year, depreciation and depreciated value for the first ten years. 6
       

Q.3.

a)

Answer in one or two lines the uses of:

(i) CD-ROM     (ii) MS-DOS     (iii) Web site

6
 

b)

What does the following C program print?

#define ISLP(y) ((y%100!=0 && y%4==0)) (y%400==0)

main()

{

    int y = 1904;

    if(ISLP(y))

    printf("\n Live and let live");

    else

    printf("\n World is at sea");

}

4
 

c)

Write a program in C to input bill number (bno)and sales amount(sales). Calculate Tax as follows:

Sales

Tax

First 3,500

2.5%

Next 500

3.75%

Next 750

4.25%

Excess

5%
6
       

Q.4.

a)

State whether the following are true or false:

(i)

A floppy disk can store same amount of data in each sector.

(ii)

A hard disk is necessary for a computer to operate.

(iii)

Unix is a single user operating system.

(iv)

WAN connects computers situated in two different countries.

(v)

Yahoo is an Internet browser.

(vi)

Usenet is a service on the Internet that allows to login one computer to another as a distant terminal.
6
 

b)

What is the output of the following C program:
main()
{
    int x=10,y,z;
    y=x;
    z=y;
    y-=x--;
    x-=--x-x--;
    printf("x=%dy=%dz=%d",x,y,z);
    printf("x+y+z=%d",x+y+z);
}
4
 

c)

Write a C program to accept 15 numbers, arrange these numbers in ascending order, display the median of the same. 6
       

Q.5. 

a)

Explain briefly about the following:

(i) CPU      (ii) WINDOWS-95       (iii) POP

6
 

b)

Write a C program to find and print the sum of 22.5 + 32.6 + 42.7 ……… + 322.35

4
 

c)

Write a C program to input a positive integer. Check whether the number is a prime or not. Display appropriate message.

6
 
PART B

Q.1.

a)

Answer the following in one sentence: - ­

(i)

What is the use of an index hole in a floppy disk?

(ii)

Name any two output devices

(iii)

Give full form of HTTP.

3
 

b)

Answer the following in MS-Excel:­

(i)

Explain the use of the following functions:

(I) time value()          (II) length()

2

(ii)

Explain briefly what-if analysis. 2

(iii)

How will you open a workbook?

1
5
 

c)

State whether the following are True or False:

(i)

The modem is used to connect the computer to the Internet.

(ii)

In MS-WORD, we can save a file with password protection.

(iii)

In MS-WORD, we cannot open more than one document at a time.
3
 

d)

Answer the following in FoxPro :

(i)

Explain the use of:

(i) CTOD()     (ii) LOWER()     (iii) RECNO()

3

(ii)

Explain the following:

(I) INPUT        (II) SET ESCAPE ON/OFF

2
5
       
    Section I  
       

Q.2.

a)

Explain briefly about the following : -

(i) Non Impact Printers        (ii) LAN     (iii) Browsers

6
 

b)

Answer the following in MS-EXCEL :Explain how data can be shared between the workbooks. 4
 

c)

Answer the following in MS-EXCELValue of an article is entered in cell A3, rate of depreciation is entered in cell B3. Explain how you will create an Excel table showing Year, Depreciation amount, Depreciated value. Use reducing balance method. 6
       

Q.3.

a)

Answer in one or two lines the uses of:

(i) CD-ROM     (ii) MS-DOS     (iii) Web site

6
 

b)

Answer the following in MS-EXCEL.

What is a macro? Explain how to create a macro of title "UNIVERSITY" with Times font & size 18.

4
 

c)

Answer the following in MS-EXCEL.The following data has been entered in a worksheet.
  A B C D
1 PRICE DEMAND    
2 23 124    
3 20 179    
4 34 145    
5 56 180    
6 12 124    
7 11 187    
8 19 138    
9 24 150    

Write steps to calculate regression equation of the form y = a + bx where x is the price, y is demand and a = mean of y – b * mean of x

b is the regression coefficient given by

6
       

Q.4.

a)

State whether the following are True or False:

(i)

A floppy disk can store same amount of data in each sector.

(ii)

A hard disk is necessary for a computer to operate.

(iii)

Unix is a single user operating system.

(iv)

WAN connects computers situated in two different countries.

(v)

Yahoo is an Internet browser.

(vi)

Usenet is a service on the Internet that allows to login one computer to another as a distant terminal.
6
 

b)

Answer the following in MS-EXCEL   ­

Explain the following terms/functions –

(i) abs()     (ii) fv()     (iii) var()     (iv) mid()

4
 

c)

Answer the following in MS-EXCELThe following data has been entered in a worksheet
  A B C D E
1

SALES FOR THE YEAR 1998

2 QUARTER BRANCH 1 BRANCH 2 BRANCH 3  
3 FIRST 2500 2600 2400  
4 SECOND 2300 2500 2100  
5 THIRD 2109 2205 2500  
6 FOURTH 2309 2207 2150  
7 Total        
Write the steps:
(i)

To find total sale of each branch.

(ii)

To construct 3-D pie for total of each quarter.

(iii)

To construct Bar diagram for total of each branch.

6
       

Q.5.

a)

Explain briefly about the following:

(i) CPU      (ii) WINDOWS-95       (iii) POP

6
 

b)

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

'&' is a reference operator.

(ii)

Autofilter option is available in the Data menu, which allows us to extract records.

(iii)

Chart gets affected whenever changes are made in the worksheet.

(iv)

Macro is used to customize the EXCEL.

4
 

c)

Answer the following in MS-EXCEL       The following data has been entered in a worksheet
  A B C D
1 NAME DATE FO BIRTH    
2 SAM 15-09-1979    
3 JACK 20-11-1980    
4 JUNE 21-12-1976    
5 SAGAR 17-10-1977    
6 AKASH 10-10-1981    
Write the steps
(i)

Prepare the list of names as per the seniority.

(ii)

Prepare the list as per the dictionary order of name.

6
       
    Section II  
       

Q.6.

a)

What is the purpose of task bar in Windows 95?

2
 

b)

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

4
 

c)

Write FoxPro commands to do the following:

(i)

To make changes in the fields of the file in use.

(ii)

To add a single blank record after 4th record of the file in use.

(iii)

To decrease PRICE by Rs. 114 in all records.

(iv)

To view all records that are not marked for deletion.

(v)

To go to last record of the file in use.

(vi)

To round off a number X to its nearest 100.

(vii)

To display contents of numeric variable N using 20 columns and correct upto 2 decimal places.

(viii)

To make drive A as currently active.

(ix)

To display a date 20 days from today.

(x)

To close currently open FoxPro file.
10
       

Q.7.

a)

Mention the procedure to create a folder in WINDOWS-95.

2
 

b)

Currently you are editing a document, which has 10 pages, in MS-WORD. Mention the procedure to change the font & its size. Also mention how will you underline the first line of the file in use. 4
 

c)

There exist a table called LIBRARY.dbf with the fields for book number (BKNUM,C,4), book name (BKNAM,N,15), number of pages (PG,N,4), price of book(PR,N, 9,2). Write a program in FoxPro to print a list showing name of the book, number of page and price of the book as per the descending order of number of pages. All the names must appear in uppercase. 4
 

d)

Explain the difference between in FoxPro:(i) ACCEPT & INPUT    (ii) CREATE & USE     (iii) ? & ?? 6
       

Q.8.

a)

Explain the purpose of Programs suboption in the start menu of WINDOWS-95. 2
 

b)

Explain the use of EDIT menu. Mention any three options.

4
 

c)

There exist a table called BANK.dbf with fields for savings account number (SAC,N,10), customer name(CTNM,C,20), balance (BAL,N,10,2).There exists another table TRANSAC.dbf with fields for savings account number (SAC,N, 10), amount withdrawn (AWD,N, 10,2), amount deposited (ADE,N,10,2).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)

Update balance in BANK.dbf using amount withdrawn & amount deposited in TRANSAC.dbf.
22
 

d)

There exist a table ITAX.dbf with fields for name of employee name (ENM,C,20), total salary in Rs. (INCOME,N,10,2). Write a program in FoxPro to calculate  income tax as per the following schedule:
Income Tax Rate
First Rs. 25,000 20%
Next Rs. 14,000 35%
Next Rs. 15,000 47%
Excess 50%
Also include the printing of name of employee, total salary, income tax with proper headings.
6
       

Q.9.

a)

Explain how you will retrieve a file RESUME.doc from the recycle bin 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) EXIT    (ii) DTOC()    (iii) RETURN    (iv) LOWER() 4
 

d)

There exists a table RESULT.dbf with fields for seat number (STNO,C,6), students name (STNAME,C,15), marks in 3 subjects (M1, M2, M3, N, 3). Write an interactive program in FoxPro asking the user to enter the seat number from the keyboard. Program should search whether this seat number exists, if so, display "SEAT NUMBER already entered". If it does not exist the program must allow the user to add this as a new record. The program should continue as long as user wants. 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.