TyBcom.com Logo  
 Home >>
 
 
Computer Systems and Applications

Time: 3 Hours

March 2002 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)

Mention one important features of CD-ROM.

(ii)

What is the function of ALU?

(iii)

What is full form of AOL?

3
 

b)

Answer the following in C:­

(i)

What is the difference between if( ) & switch( ) ?

(ii)

What are identifiers? Give an example.

(iii)

What is the purpose of break statement?

2+2+1
 

c)

State whether the following are true or false:

(i)

DOS is a multi-programming operating system.

(ii)

In MS- WORD, Insert table option is available in Insert menu.

(iii)

In MS-WORD, we can change case using Format menu.

3
 

d)

Answer the following in FoxPro :

(i)

Explain the use of:(I) SUBSTR()          (II) DAY()            (III) MOD()­

(ii)

Explain the use of:

(I) SET TALK ON/OFF        (II) COUNT

32
       
    Section I  
       

Q.2.

a)

Explain briefly about the following : -

(i) UNIX        (ii) Floppy Disk     (iii) Working of Internet.

6
 

b)

What is the output of the following C program : -

main()

int a=1450,b=-987;
float x=176.34762, y=-196.7621;
printf(“%7d%+-d”,a,b);
printf("\n %-8.3f%9.3f”,x,y);
}

4
 

c)

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

Q.2 C

6
       

Q.3.

a)

Answer in one or two lines the uses of:

(i) ROM     (ii) E-mail     (iii) Hypertext Protocol

6
 

b)

What is the output of following C program

main()
{
int i, j, k=0;
for (i=1; i<=5; c++)
  {
    for (j=1; j<=4; ++j)
      {
        k= k+i-j;
      };
    if (i>j)
    {
    break; 
    printf(“%d”, k);
    } 
  }
printf(“\n k = %d”, k);
}
4
 

c)

Write a C program to input 13 numbers and display the lowest & highest of these by sorting.

6
       

Q.4.

a)

State whether the following are true or false:

(i)

Usenet is a network which shares news articles.

(ii)

Domain names are easy to remember than IP address.

(iii)

To send same message to multiple recipients, the message needs to be sent that many times.

(iv)

The mouse is a device which connects the computer to internet.

(v)

RAM is a non- volatile memory.

(vi)

Dot matrix printer is an impact printer.

6
 

b)

What is the output of the following C program:

main()
{
int x=1462, m, y=0;
do

m=x%10;
y=y*10+m;
x/=10;
}
while(x!=0);
printf(“\n %d”,y);
}
4
 

c)

Write a C program to input 2 positive integers calculate & display the GCD of the same.

6
       

Q.5. 

a)

Explain briefly about the following:

(i) Non impact printers      (ii) MS DOS       (iii) SEARCH ENGINES

6
 

b)

Write a program in C to find and display the sum of 2*5+5*9+8*13+11*17+….

4
 

c)

Write a program in C to accept sales from the keyboard. Calculate & display sales tax as per the following:-

Sales

Sales Tax

Upto Rs. 5000

5% of sales

Between Rs.5000 and Rs. 9000

10% of sales

Over Rs.9000

12% of sales

6
       
 
 
PART B

Q.1.

a)

Answer the following in one sentence: - ­

(i)

Mention one important features of CD-ROM.

(ii)

What is the function of ALU?

(iii)

What is full form of AOL?

3
       
 

b)

Answer the following in MS-EXCEL:­

(i)

What is the purpose of minimize button?

(ii)

Describe the Excel application window.

(iii)

What is the purpose of title bar?

2+2+1
       
 

c)

State whether the following are true or false:

(i)

DOS is a multi-programming operating system.

(ii)

In MS- WORD, Insert table option is available in Insert menu.

(iii)

In MS-WORD, we can change case using Format menu.

3
       
 

d)

Answer the following in FoxPro :

(i)

Explain the use of:(I) SUBSTR()          (II) DAY()            (III) MOD()­

(ii)

Explain the use of:

(I) SET TALK ON/OFF        (II) COUNT

3+2
       
    Section I  
       

Q.2.

a)

Explain briefly about the following : -

(i) UNIX        (ii) Floppy Disk     (iii) Working of Internet.

6
 

b)

Answer the following in MS-EXCEL :The worksheet below gives Roll no., marks, Scored in test 1 and test 2 (out of 100):
A B C D E F
1 ROLL Test 1 Test 2    
2 61 49 35    
3 62 52 42    
4 63 36 67    
5 64 50 64    
Write steps to 1.      Convert marks in Test 1 to marks out of 30 in Column D2.      Convert marks in Test 2 to marks out of 70 in Column E
4
 

c)

Answer the following in MS-EXCELConsider the following worksheet showing the basic salary of four persons:-
  A B C D E F
1 Name Basic HRA DA TAX GROSS
2 Anita 8650        
3 Sachin 9300        
4 Sunil 11000        
5 Nirmal 5500        
Mention steps for writing the formula to complete the following:-1.      HRA as 30% of basic salary.2.      DA as 110% of basic salalry.3.      Tax as 20% of Gross.
6
       

Q.3.

a)

Answer in one or two lines the uses of:

(i) ROM     (ii) E-mail     (iii) Hypertext Protocol

6
 

b)

Answer the following in MS-EXCEL.Explain the use of Auto-filter command. 4
 

c)

Answer the following in MS-EXCEL.Explain the procedure to compute correlation co-efficient between X & Y. where X is Height & Y is Weight.
  A B C D E F
1 X Y        
2 155.4 56        
3 155.7 59        
4 150 48        
5 152 51        
Use the formula
Q.3 C
6
       

Q.4.

a)

State whether the following are true or false:

(i)

Usenet is a network which shares news articles.

(ii)

Domain names are easy to remember than IP address.

(iii)

To send same message to multiple recipients, the message needs to be sent that many times.

(iv)

The mouse is a device which connects the computer to internet.

(v)

RAM is a non- volatile memory.

(vi)

Dot matrix printer is an impact printer.

6
 

b)

Answer the following in MS-EXCEL   ­

How the workbooks are updated if there is a link between the workbooks?

4
 

c)

Answer the following in MS-EXCELCost of machinery is entered in cell A4, estimated life is entered in cell A6 no salvage is given. Explain how will you create an excel worksheet showing your, depreciation, use reducing balancing method. 6
       

Q.5.

a)

Explain briefly about the following:

(i) Non impact printers      (ii) MS DOS       (iii) SEARCH ENGINES

6
 

b)

Answer the following in MS-EXCEL. State whether the following are true or false :-
(i) Once chart is created, it cannot be modified.
(ii) Excel automatically updates the pivot table.
(iii) + is a reference operator.
(iv) Cut demand deletes the contents of the cell.
4
 

c)

Answer the following in MS-EXCEL       Given the following worksheet
  A B C D
1 Player Test1 Test 2 Test 3
2 Saurav 65 77 33
3 Sachin 67 89 56
4 Sehwag 23 56 45
5 Anil 15 70 43
Write the steps to create charts:-1.      Line diagram for each player for each match.Consider players on X- axis and scores on Y- axis.2.      3-D pie chart for the score of Sachin. 3.      2-D pie chart for Test 3.
6
       
    Section II  
       

Q.6.

a)

What is the use of My computer icon  in WINDOWS 95? 2
 

b)

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

4
 

c)

Write FoxPro commands for the following:

(i)

To display a date after 20 days from today.

(ii)

To enter name of friend from Keyboard.

(iii)

To change the content of field CITY to all capital records for all records.

(iv)

To display record no.7, so as to make changes in it.

(v)

To extract the first 5 characters of the field NAME, for the 5th record.

(vi)

To remove those records where AGE is between 25 and 50.

(vii)

To display nearest 100 of a Numeric value M.

(viii)

To find the length of character variable SONG .

(ix)

To move the record pointer to first record.

(x)

To end session in FOXPRO.

10
       

Q.7.

a)

Explain how to remove a folder in WINDOWS-95.

2
 

b)

Currently you are editing a document in MS-WORD, having 5 pages. Mention the procedure to get a copy of first paragraph of first page in the fifth page. Also mention how to underline the copied paragraph entered. 4
 

c)

There exist a table called RUPEE.dbf with the fields for name of items (ITNAME, C, 20), quantity brought (QTBT, N, 5, 0), price of each article (PRICE, N, 8, 2) and amount (AMT, N, 10, 2). Write a foxpro program to calculate amount for each item and print the list. 4
 

d)

Explain the difference between in FoxPro:

(i)  LIST & LIST OFF      (ii) SKIP & NEXT  (iii) CTOD() & DTOC()

6
       

Q.8.

a)

What is the use of ‘document’ sub-option in start menu of WINDOWS 95

2
 

b)

In MS WORD, explain how will you change CALCUTTA to KOLKATTA in block letters in the entire document. 4
 

c)

There is a table called HSC.dbf with fields for name (NM, C, 20), roll number(RN, C, 4), optional subject(OPSUB, C, 5). There is another table called HSCADD.dbf with  fields for roll number(RNI, C, 4), address of student (ADDSTU, C, 15), and date of birth (DDT, DATE).Write commands in FoxPro
(i) To open both files in two different work areas as well as create a compound index file for both tables as per roll number.
(ii) To display roll number, name, date of birth of those reports where optional subject is “S.P”.
22
 

d)

There is a table called RESULT.dbf with fields for student name (SNM, C, 30), roll number (RN, C, 4) & marks OF 4 subjects (M1, M2, M3, M4, all numeric, 3), Total (TOT, N , 4) and average (AVG, N , 6, 2). Write a foxpro program to calculate total and average for each student. Print a list showing result as “ PASS” or “FAIL”. Result is PASS only if the student gets 35 or more in each subject otherwise result is “FAIL”. 6
       

Q.9.

a)

Explain how to retrieve a file that was deleted earlier in WINDOWS 95.

2
 

b)

In MS WORD, explain the procedure to create a table with 3 columns and 8 rows. How will you arrange these data in ascending order of first column . 4
 

c)

Explain the use of following commands or functions in FoxPro :(i) MIN()    (ii) MODIFY COMMAND    (iii) SQRT()    (iv) SET TALK ON / OFF 4
 

d)

There is a table called EMPLOYEE.dbf with fields for employee number (ENUM, C, 4), gross income for the month (GROSS, N, 10, 2), tax (TAX, N, 10, 2) and net salary( NET, N, 10, 2)Calculate tax as under:-
Yearly Gross Tax Rate
Upto Rs. 20,000 NIL
Next Rs. 5,000 15 % in excess
Next Rs. 3,000 20 % in excess
Over Rs. 28,000 30 % in excess
Calculate net salary as Gross tax. Print the list showing employee number, tax and net salary.
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.