University of Mumbai 2006 B.A Economics Computer Systems and Applications - Question Paper

elaborate one-input and two-input tables?
Using Data, Table command discuss how to prepare a one-input table to display simple interest values for a principal amount of Rs.20000 for a period of three years when the rate of interest varies as 4.5%, 5%, 6%, 6.5%, 8% per annum. Use your own cell addresses.
(c) ans the subsequent in MS-EXCEL six The subsequent data has been entered in a worksheet
A B C
1 Name Dept. Salary
2 RAJAN STORES 12,000
3 SUMA ACCOUNTS 15,500
4 KIRAN PRODUCTION 18,000
5 JAYESH ACCOUNTS 9,600
5 AMIT PRODUCTION 22,000
5 ARTI STORES 11,600

Based on these values, write steps to
(i) organize the data in the order of Dept and further in the order of Name.
(ii)To display only those rows where salary is above Rs. 15000.
(iii)To display all the rows other than the 'STORES' dept.
Q.5 (a) discuss briefly about following: - six
(i) Non -impact Printer (ii) TCP/IP protocol (iii) UNIX
(b) ans the subsequent in MS-EXCEL four
State whether the subsequent are actual or false: -
(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.
(ii) In order to change a cell contents with a various entry, it is needed to clear the cell first.
(iii) Macro's can be created using Tools Menu,
iv) A work book can contain at most 3 worksheets.
(c) ans the subsequent in MS-EXCEL four
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? two
(b) What is the use of File menu in MS-WORD? Mention any 3 choices. four
(c) Write FoxPro commands to do the following: 10
(i) To make modifications in record number 15.
(ii) To round off contents of a memory variable R to it's closest 10.
(iii) To display the second third 4thand fifth characters of a character memory variable MVL.
(iv) To obtain total number of records where field BASIC is less than 5000 and store it in R.
(v) To display "FIBONACCI SERIES" beginning from the fifth row &10th column of the screen.
(vi) To delete record numbers from six to 10.
(vii) To display contents of character memory variable NM after removing the leading blank spaces.
(viii) To accept a date from the keyboard to a memory variable DOB from tenth row and 15th column.
(ix) To sort the table in use according to date of birth (DOB) field to a different file DSORT.dbf.
(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? two
(b) discuss the use of Tools menu in MS-WORD? Mention any 3 choices. four
(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. four

(d) discuss the difference ranging from the subsequent in FoxPro: six
(i) SORT & INDEX (ii)? & DISPLAY (iii) SET CONFIRM ON & SET CONFIRM OFF
Q.8 (a) What is taskbar in Windows-95. two
(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. four

(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. two

(ii) To calculate and store bonus at a new rate of 70% of basic pay. two
(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. six

Q.9 (a) What is the use of Recycle Bin in Windows-95. two
(b) What is the use of Format menu? Mention any three choices in the identical. four
(c) discuss the subsequent commands or functions in FoxPro: four
(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.