| Computer Systems and Applications |
| Time: 3 Hours |
March – 2003 |
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) |
What is the purpose of control unit? |
| (ii) |
Give an advantage of hard disk over CD-ROM. |
| (iii) |
Give full form of ISP. |
|
3 |
| |
b) |
Answer the following in C:
| (i) |
What is the difference between putc( ) & puts( ) ? |
| (ii) |
Mention different types of storage classes in C? |
| (iii) |
What is the use of continue statement? |
|
221 |
| |
c) |
State whether the following are true or false:
| (i) |
ROM is a volatile memory. |
| (ii) |
In MS- WORD, page numbers are automatically inserted. |
| (iii) |
In MS-WORD, break option is in VIEW menu. |
|
3 |
| |
d) |
Answer the following in FoxPro :
| (i) |
Explain the use of:
(I) LEFT() (II) TRIM() (III) STR() |
| (ii) |
Explain the following:
(I) CREATE (II) SET EXACT ON/OFF |
|
3 2 |
| |
|
|
|
| |
|
Section I |
|
| |
|
|
|
| Q.2. |
a) |
Explain briefly about the following : -
(i) MODEM (ii) UNIX (iii) email |
6 |
| |
b) |
What is the output of the following C program : -
main()
{ int a=2,s=0,j=l;
for(;a<10;a+=3j++)
{ s+=a*a*a;
printf("\na=%d j=%d",a,j);
}
printf("\nj=%d a=%d s=%d"j,a,s); } |
4 |
| |
c) |
Write a program in C to input 10 numbers & then calculate, print the mean and standard deviation of these numbers. Use the formula
 |
6 |
| |
|
|
|
| Q.3. |
a) |
Answer in one or two lines the uses of:
(i) SPIKEGUARD (ii) LAN (iii) Bulletin Board Service |
6 |
| |
b) |
What docs the following C program print?
main()
{
int a(int);
int i=3.kj;
k=++i;
j=a (i++);
printf("\ni=%d k=%d j=%d",i,k,j);
}
a(int p)
{
++p;
return (p); } |
4 |
| |
c) |
Write a program in C to input bill number (bill), sale value (sv). Calculate the sales tax as
| Sales |
Tax Rate |
| First 10,000 |
4% |
| Next 25,000 |
8% |
| Next 8,000 |
10% |
| Excess |
11.5% |
Print bill number, sales amount as well as tax with proper heading. |
6 |
| |
|
|
|
| Q.4. |
a) |
State whether the following are true or false:
| (i) |
An operating system is software. |
| (ii) |
Windows is a Graphic User Interface program. |
| (iii) |
Laser printers are impact printers. |
| (iv) |
Telnet is a network, which shares news articles. |
| (v) |
WAN system allows the user to share software, hardware & data. |
| (vi) |
DOS allows us network facility. |
|
6 |
| |
b) |
What is the output of the following C program:
#define f(x) x>=0? "real" : "complex"
main()
{
int a=2,b=7,c=7,d;
d=(b*b-4*a*c);
printf("\n d is a %s value", f(d));
} |
4 |
| |
c) |
Write a C program in C to accept 50 numbers, arrange them in ascending / descending order & print only the largest & the smallest value. |
6 |
| |
|
|
|
| Q.5. |
a) |
Explain briefly about the following:
(i) Floppy Disk (ii) LAN (iii) SEARCH ENGINES |
6 |
| |
b) |
Write a program to find and print the sum of 2/32 + 4/52 + 6/72 + ……. + 20/212 |
4 |
| |
c) |
Write a C program to generate first 50 prime numbers. |
6 |
| |
|
|
|
| |
| |
| PART B |
| Q.1. |
a) |
Answer the following in one sentence: -
| (i) |
What is the purpose of control unit? |
| (ii) |
Give an advantage of hard disk over CD-ROM. |
| (iii) |
Give full form of ISP. |
|
3 |
| |
|
|
|
| |
b) |
Answer the following in MS-EXCEL:
| (i) |
Explain the use of the following functions
(I) WEEKDAY() (II) COUNT() |
| (ii) |
How do you change the height of a row, without knowing any numeric value for it? |
| (iii) |
Explain how to insert a column after column D. |
|
2 2 1 |
| |
|
|
|
| |
c) |
State whether the following are true or false:
| (i) |
ROM is a volatile memory. |
| (ii) |
In MS- WORD, page numbers are automatically inserted. |
| (iii) |
In MS-WORD, break option is in VIEW menu. |
|
3 |
| |
|
|
|
| |
d) |
Answer the following in FoxPro :
| (i) |
Explain the use of:
(I) LEFT() (II) TRIM() (III) STR() |
| (ii) |
Explain the following:
(I) CREATE (II) SET EXACT ON/OFF |
|
3 2 |
| |
|
|
|
| |
|
Section I |
|
| |
|
|
|
| Q.2. |
a) |
Explain briefly about the following : -
(i) MODEM (ii) UNIX (iii) email |
6 |
| |
b) |
Answer the following in MS-EXCEL :
The following data has been entered in a worksheet:
| |
A |
B |
C |
D |
| 1 |
ROLL NO |
MARKS |
GRADE |
|
| 2 |
120 |
85 |
|
|
| 3 |
122 |
40 |
|
|
| 4 |
125 |
80 |
|
|
| 5 |
130 |
74 |
|
|
| 6 |
135 |
59 |
|
|
| 7 |
140 |
90 |
|
|
Write steps to compute GRADE as follows:
| Marks |
Grade |
| Between 35 & 50 |
C |
| Between 50 & 60 |
B |
| Above 60 |
A |
|
4 |
| |
c) |
Answer the following in MS-EXCEL
Given the worksheet as follows
| |
A |
B |
C |
D |
| 1 |
X |
Y |
|
|
| 2 |
15 |
15 |
|
|
| 3 |
17 |
20 |
|
|
| 4 |
18 |
18 |
|
|
| 5 |
16 |
17 |
|
|
| 6 |
20 |
25 |
|
|
| 7 |
24 |
17 |
|
|
Explain the procedure to calculate coefficient of correlation in cell A10. Use the formula
|
6 |
| |
|
|
|
| Q.3. |
a) |
Answer in one or two lines the uses of:
(i) SPIKE GUARD (ii) LAN (iii) Bulletin Board Service |
6 |
| |
b) |
Answer the following in MS-EXCEL.
What is a pivot table? Where it is used? |
4 |
| |
c) |
Answer the following in MS-EXCEL.
The following data has been entered in a worksheet
| |
A |
B |
C |
D |
| 1 |
AGE(x) |
No. of persons(f) |
fx |
fx2 |
| 2 |
18 |
17 |
|
|
| 3 |
20 |
26 |
|
|
| 4 |
24 |
30 |
|
|
| 5 |
27 |
24 |
|
|
| 6 |
30 |
20 |
|
|
| 7 |
35 |
16 |
|
|
Explain procedure to find the mean in cell A10 and standard deviation in cell A12 showing the computations of fx & fx2. Use the formula
Mean = Sfx / Sf SD = ÖSfx2 / Sf – (mean*mean) |
6 |
| |
|
|
|
| Q.4. |
a) |
State whether the following are true or false:
| (i) |
An operating system is software. |
| (ii) |
Windows is a Graphic User Interface program. |
| (iii) |
Laser printers are impact printers. |
| (iv) |
Telnet is a network, which shares news articles. |
| (v) |
WAN system allows the user to share software, hardware & data. |
| (vi) |
DOS allows us network facility. |
|
6 |
| |
b) |
Answer the following in MS-EXCEL
Explain the procedure to remove password from protection password box. |
4 |
| |
c) |
Answer the following in MS-EXCEL
The following data has been entered in a worksheet
| |
A |
B |
C |
D |
| 1 |
ITEM NO |
1980 |
1985 |
1990 |
| 2 |
410 |
375 |
400 |
300 |
| 3 |
100 |
150 |
200 |
100 |
| 4 |
110 |
200 |
250 |
170 |
| 5 |
109 |
175 |
200 |
155 |
Write the steps
| (i) |
To calculate the total in B6, C6 & D6. |
| (ii) |
To construct 3-D Bar diagram. |
| (iii) |
To construct Pie - Chart for the totals. |
|
6 |
| |
|
|
|
| Q.5. |
a) |
Explain briefly about the following:
(i) Floppy Disk (ii) LAN (iii) SEARCH ENGINES |
6 |
| |
b) |
Answer the following in MS-EXCEL
State whether the following are true or false :-
| (i) |
Pivot charts cannot be created along with pivot tables. |
| (ii) |
A function cannot contain another function in its argument. |
| (iii) |
Queries can be answered using filter. |
| (iv) |
Cell names and range names can be used in place of cell references in formula. |
|
4 |
| |
c) |
Answer the following in MS-EXCEL
The following data has been entered.
| |
A |
B |
C |
D |
| 1 |
CNO |
CNAME |
PHONE |
BALANCE |
| 2 |
4 |
KELKAR A. |
25624111 |
40000 |
| 3 |
101 |
DATE V. |
24721742 |
20500 |
| 4 |
112 |
KALE A. |
25872462 |
10000 |
| 5 |
88 |
LIMAYE P. |
25671029 |
35000 |
| 6 |
49 |
EKBOTE D. |
24760023 |
32100 |
| 7 |
54 |
GORE M. |
24598001 |
49800 |
Write the steps to arrange the worksheet in descending order of phone number. |
6 |
| |
|
|
|
| |
|
Section II |
|
| |
|
|
|
| Q.6. |
a) |
What is a folder in WINDOWS 95? |
2 |
| |
b) |
What is the use of FORMAT menu in MS- WORD? Mention any three options. |
4 |
| |
c) |
Write FoxPro commands to do the following:
| (i) |
To open the file TYRESULT.dbf from C-drive. |
| (ii) |
To display a date before 15 days from today. |
| (iii) |
To change the content of field ROLL_NO of record number 10. |
| (iv) |
To arrange data as per name (NM) using index command. |
| (v) |
To remove all the records from the file currently in use. |
| (vi) |
To extract the first 3 character from the field CITY. |
| (vii) |
To get the price (PRC) of an article from the keyboard. |
| (viii) |
To store a logical value "false" to logical memory variable PASS. |
| (ix) |
To total the values of the field GROSS for all records. |
| (x) |
To find the number of records where the field BAL is more than 500. |
|
10 |
| |
|
|
|
| Q.7. |
a) |
Mention any four options available in the START menu in WINDOWS-95. |
2 |
| |
b) |
Currently you are editing a document in MS-WORD, mention the procedure to get
UNIVERSITY OF MUMBAI at the top as well as center of every page. |
4 |
| |
c) |
There exist a table called ADDRESS.dbf with the fields for name of person (NM, C, 20), address (ADR, C, 16), name of the city (CITY, C, 15). Write a program in FoxPro to print a list showing name address & name of city as per dictionary order of city with proper heading. |
4 |
| |
d) |
Explain the difference between in FoxPro:
(i) STORE…TO & =command (ii) LIST OFF & LIST FOR (iii)LOCATE & SEEK |
6 |
| |
|
|
|
| Q.8. |
a) |
Explain the procedure to search a file TIMES.doc in WINDOWS-95. |
2 |
| |
b) |
The file DETAILS.doc, in MS-WORD, contains a table with columns for name, address & phone number. Mention the procedure to arrange data as per name. |
4 |
| |
c) |
There exist a table called STOCK.dbf with fields for item number (INO, N, 4), item name (ITNM, C, 20), price of each item (PR, N, 8, 2), quantity in hand (QIH, N, 4). There exists another table SALES.dbf with fields for item number (INO, N, 4), date of sales (DTSL, date), quantity sold (QSLD, N, 4).
Write commands in FoxPro
| (i) |
To open the files in two different work areas as well as create a compound index file for both tables as per item number. |
| (ii) |
To create a new file STOTAL by combining both databases containing the fields ITNO, ITNM, DTSL, QSLD & QIH. |
|
2 2 |
| |
d) |
There exist a table FYBCOM.dbf with fields for name of student (SNM, C, 20), roll number (RN, C, 4) & marks in 3 subjects (M1, M2, M3, N, 3). Write a program in FoxPro to update by putting marks as 35 whenever it is 32 or 33 or 34 for every subject. Print the details of roll number, name, total marks for every record with proper headings. |
6 |
| |
|
|
|
| Q.9. |
a) |
Explain how you will rename a file TYBCOM.xls as MCOM.xls in WINDOWS-95. |
2 |
| |
b) |
What is the use of TOOLS menu? Mention any 3 option in the same. |
4 |
| |
c) |
Explain the following commands or functions in FoxPro :
(i) SUBSTR() (ii) SET RELATION TO (iii) SET DECIMAL TO (iv) VAL() |
4 |
| |
d) |
There exists a table SALARY.dbf with fields for employee number (EMNO, C, 5), employee name (EMNM, C, 20), basic salary (BS, N, 10, 2). Write a program in FoxPro to calculate DA as 35% of Basic Salary, HRA as 30% of Basic Salary subject to minimum of Rs. 750 and a maximum of Rs. 2000, Total salary is basic salary + DA + HRA, PF is 12% of Total earnings, Net salary is Total salary-PF. Also include the printing of all these fields in one line for each employee with proper headings. |
6 |
