Acharya Nagarjuna University (ANU) 2006 Diploma Computer Applications Computer Systems and Applications - Question Paper

*
o (i) Opening a file as learn only does not prevent you from making modifications but it prevents you from saving the modifications to a file with identical name.
o (ii) In order to change a cell contents with a various entry, it is needed to clear the cell first.
o (iii) Macro's can be created using Tools Menu,
o iv) A work book can contain at most 3 worksheets.
* (c) ans the subsequent in MS-EXCEL 4
*
A worksheet contains Roll no. and marks out of 100 in four subjects entered in columns A, B, C, D, E respectively in 1st 26 rows. In the 1st row, heading is entered and in following rows data has been entered. discuss the procedure to obtain avg. and grade in columns F and G respectively. Grade is to be assigned as follows:
*

avg. Grade
75 or more A
60 or more and beneath 75 B
beneath 60 C
part II
* Q.6 (a) elaborate the main icons displayed on the desktop of Windows 95? 2
* (b) What is the use of File menu in MS-WORD? Mention any 3 choices. 4
* (c) Write FoxPro commands to do the following: 10
*
o (i) To make modifications in record number 15.
o (ii) To round off contents of a memory variable R to it's closest 10.
o (iii) To display the second third 4thand fifth characters of a character memory variable MVL.
o (iv) To obtain total number of records where field BASIC is less than 5000 and store it in R.
o (v) To display "FIBONACCI SERIES" beginning from the fifth row &10th column of the screen.
o (vi) To delete record numbers from six to 10.
o (vii) To display contents of character memory variable NM after removing the leading blank spaces.
o (viii) To accept a date from the keyboard to a memory variable DOB from tenth row and 15th column.
o (ix) To sort the table in use according to date of birth (DOB) field to a different file DSORT.dbf.
o (x) To increase the contents of a field called AGE by one in every record.
* Q.7 (a) What is use of Windows Explorer in Windows-95? 2
* (b) discuss the use of Tools menu in MS-WORD? Mention any 3 choices. 4
* (c) There is a file called learner.dbf containing fields Roll no. (RNO, N, 4, 0), Name (NAME, C, 20), marks in 4 subjects,(M1,M2,M3,M4all Numeric,3,0)write a fox pro program to print a report showing roll no., name and marks in four subjects of those who are passing in. the four subjects by scoring 35 or more. 4
*
* (d) discuss the difference ranging from the subsequent in FoxPro: 6
* (i) SORT & INDEX (ii)? & DISPLAY (iii) SET CONFIRM ON & SET CONFIRM OFF
* Q.8 (a) What is taskbar in Windows-95. 2
* (b) discuss the procedure to open a file called "HISTORY.DOC" which is in My Documents folder and reach the beginning of fifth page of this document using MS-WORD. 4
*
* (c) There are two tables 1st 1 called "WMPl.dbf' containing field's worker no.(WN,N,3,0),name (NAME,C,10) and basic pay(BPAY,N,10,2). a different table "WMP2.dbV' containing fields worker no.(WN,N,3,0), department(DEPT,C,10) and bonus (BONUS,N, 10,2). Write command in FoxPro for the subsequent.
*
* (i) To display worker no., name, basic pay, department and bonus for every record. 2
*
* (ii) To calculate and store bonus at a new rate of 70% of basic pay. 2
* (d) There is a file called PAY.dbf containing field’s employee no. (E_NO, N, 4), name (NAME, C, 20) and address (ADDR, C, 50). Write a data entry program to add new records to this file. This program must allow the user to continue on as long as user wants. 6
*
* Q.9 (a) What is the use of Recycle Bin in Windows-95. 2
* (b) What is the use of Format menu? Mention any three choices in the identical. 4
* (c) discuss the subsequent commands or functions in FoxPro: 4
o (i) SET DECIMALS TO (ii) obtained ( ) (iii) ACCEPT TO (iv) RECALL
* (d) There exists a table STOCK.dbf containing fields item number (INO, C, 6), item name (INAME, C,15), price (PRICE, N, 7, 2), volume in stock (QST, N, 3). Write a program in FoxPro requesting the user to enter item name and the program should display item no, price and volume in stock whenever it is obtained in the file otherwise display "Record Not Found". This program should allow the user to continue on as long as he wants.

Earning:   Approval pending.