TyBcom.com Logo  
 Home >> University Papers >> Old Papers
Navigation
 
Sponsors

 
Search
Google

Web TyBcom.com
  Old Papers
 
Computer Systems & Applications
Time : 3 Hrs.
April 1997
Total Marks : 100
 

SECTION I
PART A

Q.1. a) Answer the following in one or two sentences :
6
    i) Give two examples of secondary storage devices ?
 
    ii) What is the use of TYPE command in DOS ?
 
    iii) What is a BYTE ?
 
    iv) Give two examples of peripheral devices ?
 
    v) What is an Interpreter ?
 
    vi) What is the function of ALU ?
 
  b) Distinguish between DOT metrics and Letter quality printer.
4
  c) Answer in COBOL :
4
    Explain the use of DATA DIVISION in a COBOL program.
 
  d) Explain with an example the purpose of the following functions in LOTUS 1-2-3 .
4
    i) IRR
 
    ii) LOG (X)
 
Q.2. a) State whether the following are true or false.
6
    i) During the first generation of computers operating system concept was used.
 
    ii) COPY command in DOS allows us to copy more than one file at a time.
 
    iii) TIME command in DOS allows us to change the time.
 
    iv) Logical errors in the program can be identified by a compiler.
 
    v) A Hard Disk can store more data than 31/2 mini disk.
 
    vi) Read/Write head touches the surface of floppy disk as well as Hard Disk.
 
  b) Write short note on :
4
    i) Application Software
 
    ii) Primary Memory.
 
  c) Answer in COBOL :
4
    i) What is the use of LEVEL NUMBERS ?
 
    ii) Name 2 sections of ENVIRONMENT DIVISION.
 
  d) Answer in LOTUS 1-2-3
4
    i) To delete the current row.
 
    ii) Save the current worksheet.
 
    iii) To print the current worksheet.
 
    iv) What can be the maximum column width.
 
Q.3. a) Mention any two differences between the following :
6
    i) Lower level and Higher level languages.
 
    ii) DOS and UNIX.
 
    iii) Second Generation and Third Generation computers.
 
  b) Write short note on :
4
    i) Keyboard
 
    ii) Floppy Disk
 
  c) Answer in COBOL :
 
    Rewrite the following COBOL statements after correcting errors if may.
 
    i) COMPUTE A = L*B ROUNDED
 
    ii) OPEN PAY-FILE FOR INPUT
 
    iii) DIVIDE A BY B.
 
    iv) IF BPAY > 3000 BONUS = 1000 ELSE BONUS = 1200.
4
  d) Answer in LOTUS 1-2-3Following the data is stored in a worksheet.
4
   
 
  A B C D E
1
CITY NAME      
2
MUMBAI RAKESH      
3
SIMLA RAJIV      
4
SIMLA ASLAM      
5
MUMBAI ALOK      
6
MUMBAI GEETA      
7
OOTY SUMA      
8
         

Give commands to rearrange the above data according to CITY and in CITY alphabetical order of Names and then give the output.

 
Q.4. a) Write short note on :
6
    i) Electronic spread sheet
 
    ii) Hard Disk
 
  b) Explain the use of the following DOS commands :
4
    i) REN   ii)  CLS        iii)  DIR/P    iv)  DATE
 
  c) Answer in COBOL : State whether the following statements are true or false.
4
    i) READ statement appears in PROCEDURE DIVISION.
 
    ii) Level number 77 can be used to describe group items.
 
    iii) Picture character V is an edit character.
 
    iv) PERFORM PARA-1 TO PARA-4 is a valid statement.
 
  d) Answer in LOTUS 1-2-3
4
    i) What is the difference between VALUE and LABEL mode ?
 
    ii) What is the use of Xtract option in the file menu ?
 
    iii) How do you change the width of a column to 12 ?
 
    iv) Can you save graph and worksheet under the same name.
 
Q.5. a) Answer any one of the following in COBOL :
 
    i) There is a COBOL file called RESULT-FILE whose record is RESULT-REC contains data items Name (S-NAME), Marks in 3 subjects (MK-1, MK-2, MK-3). Write PROCEDURE DIVISION Statements to open this file and read one record at a time and then calculate average marks . If average marks are 40 or more than display name, average marks and a comment "PASS" otherwise display name, average marks and a comment "FAIL". When and of file is reached then close the file and stop the programme.
 
    ii) There is COBOL file called PAY-FILE whose record is PAY-REC contains data items Name (E-NAME), Monthly basic pay (BASIC-PAY) and number of days absent during a month (ABS-DAYS). Write PROCEDURE DIVISION statement to open this file and read one month. Display Name and proportional basic pay. When end of file is reached then close the file and stop the program.
 
  b) Answer any one of the following in LOTUS 1-2-3 :
 
    i) Consider the following worksheet
 
 
A
B
C
D
       E
1
MONTH
PRODUCTION
SALES
   
2
JAN
3500
2300
   
3
FEB
3100
2500
   
4
MAR
4500
3800
   
5
APR
3600
3100
   


Write the steps to display a pie diagram each for PRODUCTION and SALES.

 
    ii) Consider the following worksheet.
 
 
A
B
C
D
       E
1
NAME
BASIC
DA
HRA
 
2
RAGINI
3000
     
3
DHAWAL
3200
     
4
SAMIR
1200
     
5
SNEHA
4400
     
6
KAVITA
3500
     
7
SOURABH
2670
     
8
         


DA is computed at the rate of 75% of BASIC , HRA is computed at the rate of 20% of BASIC. Write the steps to calculate DA and HRA and then find GROSS PAY should be computed in cell E10 and its variance in cell E11..

 
PART B
Q.1. a) Answer the following in one or two sentences :
6
    i) Give two examples of secondary storage devices ?
 
    ii) What is the use of TYPE command in DOS ?
 
    iii) What is a BYTE ?
 
    iv) Give two examples of peripheral devices ?
 
    v) What is an Interpreter ?
 
    vi) What is the function of ALU ?
 
  b) Distinguish between DOT metrics and Letter quality printer.
4
 

c)

Answer in C :

main ( )
{
int a = 300, b= -22, c = 2345;
printf("%6d%8d\n",a,b);
printf ("%+ -8d%-8d\ n",b,c);
}

 
 

d)

Write program in C to input name, hours worked and rate and then display name and wage.

4
Q.2. a) State whether the following are true or false : 6
  i) During the first generation of computers operating system concept was used.  
  ii) COPY command in DOS allows us to change the time.  
  iii) TIME command in DOS allows us to change the time.  
  iv) Logical errors in the program can be identified by a compiler.  
  v) A Hard Disk can store more data than 3 1/2" mini disk.  
  vi) Read/Write head touches the surface of floppy disk as well as Hard Disk.  
b)
Write short note on :  
  i) Application Software  
  ii) Primary Memory 4
c)
  Answer in C:

What is the output of the following programme :

main ( )
{ int X = 1, Y = 5, t;
for (t=1; t; t++)
{ x+ = 15;
y* = 2;
printf (" %d %d/n", x,y);
if (x50) break;}}

4
d)
i) What is the difference between break and continue statement ? 4
  ii) What are the uses of gets ( ) and puts ( )  
Q.3.      a) Mention any two differences between the following : 6
  i) Lower level and Higher level languages.  
  ii) DOS and UNIX.  
  iii) Second Generation and Third Generation computers.  
b)
Write short notes on : 4
 
i) Keyboard  
 
ii) Floppy Disk  
c)
Answer in C : 4
 

What is the output of the following program :

main ( )
{ int a = 10, b = 5, c, d;
a+ b = -b* 3;
b* = 7;
c = b% a;
d = ++c + 2*b;
print (" %d %d %d/n", a,b,c,d) ;}
 

 
d)
Write a program to print numbers from 100 to 1 using do ( )/ while ( ) loop. 4
Q.4.    a) Write short note on : 6
  i) Electronic Spread Sheet  
  ii) Hard Disk  
  b) Explain the use of the following DOS command : 4
  i) REN  
  ii) CLS  
  iii) DIR/P  
  iv) DATE  
  c) Answer in C :What is the output of the following program
main ( )
{ int x, y;
for (x = 1, y=5; x<6 x++, y+ =2 )
printf ("% d %d\n",x,y) ; }
4
  d) Explain the difference between do () while () and while ()/ giving example. 4
Q.5.

Answer any two of the following in C :

14
  i) Write a program to input marks in maths of 20 students and then calculate and print mean and standard deviation of marks where -

mean

 
  ii) Write a program to enter 25 numbers and then print them in the ascending order.  
  iii) Write a program to input 2 positive integers and then print their G.C.D.  

Section II

 
Q.6. a) Write statements in dBASE for the following : 10
    i) To store tomorrow’s date in a memory variable TOMO.  
    ii) To open a file called PAR stored in drive A.  
    iii) To return the length of a character expression store in P.  
    iv) To prevent displaying of records which are marked for deletion.  
    v) To round off a number X to its nearest 10.  
    vi) To display all the records where string "KAR" appear as a part of field NAME.  
    vii) To draw a box from 2nd row and 5th column to 10th row and 50th column.  
    viii To display contents of numeric variable X using 15 columns and correct upto 2 decimal places.  
    ix) To edit the first 5 records.  
    x) To delete the last 10 records.  
  b) What is the use of ON-SCREEN MENU in WORD-STAR ? Give any two commands with their meaning. 4
  c) You are currently editing the following text-THE EVIL THAT THE MEN DO LIVES AFTER THEM THE GOOD IS OF TENTERED WITH THEIR BONES. The cursor is on the letter W of the word WITH. You want to underline the word GOOD and then you want EVIL in bold face. Explain the procedure to achieve this. 4
Q.7. a) Explain the difference between the following in DBASE. 10
    i) ? and TEXT/ENDTEXT  
    ii) SORT and INDEX  
    iii) LOCATE and SEEK  
    iv) EDIT and BROWSE  
    v) LIST and LIST OFF.  
  b)   When do you use the following commands in WORD-STAR ? 4
    i) ^ QE  
    ii) ^ KD  
    iii) ^ QC  
    iv) ^ KX  
  c) What is the use of DOT commands in WORD-STAR ? Give two examples. 4
Q.8. a) There is a DBASE file called COLLEGE whose structure is follows :
 
Field Name Type Width Dec
NAME CHARACTER 20
CLASS CHARACTER 2
ADDRESS CHARACTER 30
BIRTH DATE 8
MALE LOGICAL 1


Where class is FY, SY OR TY. Write a DBASE programme to print 3 separate roll calls showing Roll Number and name for these 3 classes. Roll numbers must begin from 1 onwards for each class and in the alphabetical order of names.

 
  b) What are the uses of WORD-STAR packages ? 4
  c) Answer in one line for the following in WORD-STAR. 4
    i) When do you issue the command ^KQ ?  
    ii) What is the default page length of a Document file ?  
    iii) How do you arrive at ON-SCREEN MENU from MAIN MENU ?  
    iv) Which command is used to pring a file and in which menu does it appear ?  
Q.9. a) Consider the following DBASE file
 
RECORD# PLAYERNO NAME RUNS
1   21 RAVI 64
2   16 SACHIN 98
3     2 TAYLOR 71
4   18 BOON 90
5     9 IMRAN 84


Write commands in DBASE for the following :

6
    i) Sort this file according to name to another file called NN and then show the listing of the file NN.  
    ii) To index this file according to the runs and then show the listing.  
  b) Explain the use of the following functions in DBASE. 5
    i) VAL  
    ii) LEN  
    iii) RECNO  
    iv) ROUND  
    v) INT ( )  
  c) Give commands in WORD-STAR for the following : 4
    i) To go to the beginning of the file.  
    ii) To delete the character where the cursor is positioned.  
    iii) To insert a file.  
    iv) To copy a marked text of a file.  
  d)   Currently you are editing a file CHEM. You want to enter the following:  3
Q.10.     Answer in DBASE (any one) : 14
  a) There is a DBASE file called INSTOCK dbf containing fields Item No. (NO, Numeric, 4), Name (NAME, character, 20), Unit Price (PRICE, Numeric, 5), Quantity in Stock (QS, Numeric, 4, 0). Write a DBASE program to add more records to this file. The program must allow the user to continue as long as he wishes. After completing the data entry the program must print stock value statement showing item number, name and value for each item in the alphabetical order of item name and also find total value.  
  b) There is a file called RESULT dbf containing fields Roll No. (RNO, Numeric, 3), Name (NAME, character, 20) and marks in 3 subjects (MK1, MK2, MK3, Numeric, 3). Write a program to update this file by putting marks equal to 35 whenever it is 33 or 34 and then write a program to print one line report showing roll no., Name, total marks and result for every record where result is pass or fail. A student is declared "PASS" only when total marks are 105 or more and not less than 35 marks in each subject otherwise he is declared

View Latest Papers - 2002 to 2005 Papers    - 1997 to 1999 Papers


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.