April 1997
Time: 3Hours Marks: 100
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 : (4)
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.
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..
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 : (4)
i) Application Software
ii) Primary Memory
c) Answer in C: (4)
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;}}
d) (4)
i) What is the difference between break and continue statement ?
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: (4)
main ( )
{ int x, y;
for (x = 1, y=5; x<6 x++, y+ =2 )
printf ("% d %d\n",x,y) ; }
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.
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 : (4)
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: (6)
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 :
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
No comments:
Post a Comment