TyBcom.com Logo  
 Home >>
 
 
Computer Systems and Applications
Time: 3 Hours October - 2004 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)

Give one feature of impact printer.

(ii)

What is the purpose of control unit?

(iii)

Give full form of HTML.

3

 

b)

Answer the following in C:­

(i)

State any two rules for naming an identifier.

(ii)

Mention  the difference between do… while() and while().

(iii)

What is the difference between x=0 and x==0?

2

2

1

 

c)

State whether the following are true or false:

(i)

LAN is an operating system

(ii)

In MS- WORD, save as option allows you to save a file under some other file name.

(iii)

In MS-WORD, a file normally has an extension .TXT.

3

 

d)

Answer the following in FoxPro :

(i)

Explain the use of:

(I) EOF()          (II) SQRT()            (III) DAY()­

(ii)

Explain the following:

(I) MODIFY COMMAND       (II) SET DEFAULT TO

3

2

       
    Section I  
       

Q.2.

a)

Explain briefly about the following : -

(i) Hard Disk      (ii) Use of Internet     (iii) WAN

6

 

b)

What is the output of the following C program : -

main()

{  int x=5, y=10;

    x=x++;

    Y+=++x;

    y--;

    x-=3;

    printf (“%d%d\n”,x,y);}

4

 

c)

Write a program in C to input 15 numbers from the keyboard, arrange and display them in descending order of magnitude.

6

       

Q.3.

a)

Answer in one or two lines the uses of:

(i) Memory Unit  (ii) MS-DOS     (iii) FTP.

6

 

b)

What docs the following C program print?

main()

{int a,b,c;

  for (a=5; a<10; a+=5)

       { for (b=3; b<6; b+=3)

                c=a*b

                Printf (“%d%d%d\n”,a,b,c);} }

4

 

c)

Write a program in C to input the gross income (gi). The rate of income tax (itax) is as per following schedule

Gross Income

Rate of income tax

Less than 60,000

Nil

Next 50,000

10%

Next 50,000

15%

Above 1,60,000

20%

6

   

Calculate and print income and net income (ni) with appropriate message, where net income = gross income - income tax

 

Q.4.

a)

State whether the following are true or false:

(i)

Floppy disk is secondary storage device.

(ii)

The output can be displayed in computer modem

(iii)

Both sides of CD-ROM can be used for data storage.

(iv)

Windows explorer is web browser.

(v)

In LAN, atleast one computer has to be server.

(vi)

Viruses can spread through email.

6

 

b)

What is the output of the following C program:

main()

{ int i=0, x=0;

   for (i=1; i<10; i++)

         {  if (i%2==1)

                x++;

             else

                x--;

         printf (“%d\n”, x);

         break;

         } 

         printf (“x=%d\n”,x);

}

4

 

c)

Write a C program to accept 25 pairs of numbers in x and y, calculate and print the regression of x on y for these numbers. Use the formula.

6

   

byx =

nSxy - SxSy

nSy2 – (Sy)2

 

Q.5. 

a)

Explain briefly about the following:

(i) Laser Printers      (ii) Unix      (iii) Telnet.

6

 

b)

Write a C program to find and print the sum of 1.3 + 3.5 + 5.7……….+19.21

4

 

c)

Write a C program to input 10 positive integers from the keyboard. Find and print the mean and standard deviation of the same. Use the formula

Mean =

Sx

n

 

6

   

 

 
 
 
PART B

Q.1.

a)

Answer the following in one sentence: - ­

(i)

Give one feature of impact printer.

(ii)

What is the purpose of control unit?

(iii)

Give full form of HTML.

3

       
 

b)

Answer the following in C:­

(i)

Explain the use of the following functions

(I) IF()      (II) PROPER()

(ii)

Give steps to create a custom list.

(iii)

How will you insert  two columns between column B and column C?

2

2

1

       
 

c)

State whether the following are true or false:

(i)

LAN is an operating system

(ii)

In MS- WORD, save as option allows you to save a file under some other file name.

(iii)

In MS-WORD, a file normally has an extension .TXT.

3

       
 

d)

Answer the following in FoxPro :

(i)

Explain the use of:

(I) EOF()          (II) SQRT()            (III) DAY()­

(ii)

Explain the following:

(I) MODIFY COMMAND       (II) SET DEFAULT TO

3

2

       
   

Section I

 
       

Q.2.

a)

Explain briefly about the following : -

(i) Hard Disk      (ii) Use of Internet     (iii) WAN

6

 

b)

Answer the following in MS-EXCEL :

Calculate total, average for the following worksheet

 

A

B

C

1

Item name

Jan

Feb

2

Mouse

1200

1250

3

Monitor

25

30

4

Keyboard

45

40

5

Printer

20

25

6

Floppy Disk

1500

1550

7

Total

   

8

Average

   

4

 

c)

Answer the following in MS-EXCEL

Given the worksheet as follows

 

A

B

C

D

E

F

1

EMPNO

BASIC

HRA

DA

PF

NET

2

E001

5000

       

3

E002

2000

       

4

E003

8000

       

5

           

6

           

Explain the procedure to calculate (i) HRA as 20 % of BASIC (ii) DA as 25% of BASIC (iii) PF as %% of BASIC (iv) NET as BASIC + HRA +DA – PF. Fill the entire worksheet.

6

       

Q.3.

a)

Answer in one or two lines the uses of:

(i) Memory Unit      (ii) MS-DOS     (iii) FTP

6

 

b)

Answer the following in MS-EXCEL.

       Explain the following terms/functions:

(i)EXP () (ii) DAYS360 () (iii) UPPER () (iv) NPV()

4

 

c)

Answer the following in MS-EXCEL.

         The following data has been entered in a worksheet

 

A

B

C

D

E

F

G

1

RNO

NAME

ACCOUNTS

ECONOMICS

COMPUTER

AVERAGE

GRADE

2

101

ASHISH

55

40

60

   

3

103

NIKITA

80

65

63

   

4

104

SWATI

35

50

45

   

5

102

KIRAN

42

54

66

   

6

             

Explain procedure to compute AVERAGE MARKS  and grade as per the following criteria, fill the entire cell.

Average

Grade

>=75

DISTINCTION

<75 but >=60

FIRST CLAS

<60 but >=45

SECOND CLASS

<45 but >=35

PASS CLASS

<35

FAIL

6

       

Q.4.

a)

State whether the following are true or false:

(i)

Floppy disk is secondary storage device.

(ii)

The output can be displayed in computer modem

(iii)

Both sides of CD-ROM can be used for data storage.

(iv)

Windows explorer is web browser.

(v)

In LAN, atleast one computer has to be server.

(vi)

Viruses can spread through email.

6

 

b)

Answer the following in MS-EXCEL   ­

What is difference between Auto filter and Advance filter?

4

 

c)

Answer the following in MS-EXCEL

The following data has been entered in a worksheet

 

A

B

C

D

E

1

NAME

TEST 1

TEST 2

TEST 3

 

2

Sachin

101

80

150

 

3

Agarkar

60

20

100

 

4

Yuvraj

121

50

55

 

5

Saurav

91

70

111

 

6

Rahul

70

10

80

 

Write the steps to construct

(i)

Bar chart

(ii)

Line chart

(iii)

Column chart

6

       

Q.5.

a)

Explain briefly about the following:

(i) Laser Printers      (ii) UNIX       (iii) Telnet.

6

 

b)

Answer the following in MS-EXCEL

    State whether the following are true or false :-

(i)

Graphs cannot be edited once they are created.

(ii)

To use fill handle it is always necessary to create custom list.

(iii)

The source file sheet name is placed in square brackets in a formula.

(iv)

Once the subtotals are inserted in a list you cannot remove them.

4

 

c)

Answer the following in MS-EXCEL

       The following data has been entered.

 

A

B

C

D

1

NAME

DEPARTMENT

SALARY

 

2

Ankita

Production

5000

 

3

Priyanka

Export

6000

 

4

Sonal

Stores

8000

 

5

Ajit

Production

5500

 

6

Bharat

Accounts

4000

 

7

Suniti

Export

8500

 

Write the steps to (i) arrange the data as per salary. (ii) display only those names where names start with “S”.

6

       
    Section II  
       

Q.6.

a)

Explain how will you copy a file from a folder in windows to a floppy disk?

2

 

b)

What is the use of FILE menu in MS- WORD? Mention any three options.

4

 

c)

Write FoxPro commands to do the following:

(i)

File STUDENT. Dbf is in use, arrange the records of this file on the basis of name (SNAME) and store it in NMST.dbf.

(ii)

To add new record at the end of the file in use.

(iii)

To cancel the deletion of all the records which are marked for deletion.

(iv)

To display “Enter first no.” on the screen and to get the value through the keyboard to X.

(v)

To permanently delete all the records from record number 5 onwards.

(vi)

To increase basic salary (BS) by Rs. 800 in all records.

(vii)

To find whether the value stored in X is divisible by value stored in Y.

(viii)

To view record numbers 2,3,4,5 and 6 from the file in use.

(ix)

To update SALARY.dbf by adding a field B_SAL.

(x)

Exit to Windows.

10

       

Q.7.

a)

State the difference between file and folder in WINDOWS-95.

2

 

b)

Currently you are editing a document in MS-WORD, mention the procedure to (i) check the spelling and (ii) count the lines in the document.

4

 

c)

There exist a table called FY.dbf with the fields of roll number(RNO, N, 4), name of student (NM, C, 20), marks in 4 subjects (M1, M2, M3, M4, N, 3). Write a program in FoxPro to print a list showing roll number, name of student, marks in all 4 subjects, total marks and the grade, where grade is B if marks is less than 50 in atleast one subject otherwise grade A.

4

 

d)

Explain the difference between in FoxPro:

(i) LIST & LIST FOR     (ii) RECALL & PACK   (iii).. SAY …GET …READ & INPUT …TO.

6

       

Q.8.

a)

Explain the step by step procedure to shut down a computer running WINDOWS-95.

2

 

b)

Mention any four applications of MS-WORD.

4

 

c)

There exist a table called EMP.dbf with fields for employee  number (ENO, N, 4), employee name (ENAME, C, 20), basic pay (BPAY, N, 10, 2) and department number (DEPTNO, N, 4). There exists another table DEPT.dbf with fields for department number (DEPTNO, N, 4), department name (DEPNM, C, 20), location (LOC, C, 20).

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 department number.

(ii)

To create a new database EMPDEPT.dbf combing above two files.

2

2

 

d)

There exist a table CUSTOMER.dbf with fields for customer numer (CNO, N, 4), customer name (CNAME, C, 20), city (CITY, C, 15) and phone number (PNO, N, 10).  Write a program in FoxPro to add more records to this file, while adding records take care that customer number is not duplicated.

6

       

Q.9.

a)

What is the use of status bar in WINDOWS-95.

2

 

b)

Explain where formatting toolbar is displayed and what it contains..

4

 

c)

Explain the following commands or functions in FoxPro :

(i) LOCATE    (ii) TRIM    (iii) CREATE   (iv) DO TEXT ….. ENDTEXT.

4

 

d)

There exists a table TRADE.dbf with fields for company’s class (CLASS, C, 3), bill number (INO, C, 6), and sales amount (SAMT, N, 6). Write a program in FoxPro to print company’s class, bill number, sales amount, sales tax, additional sales tax and total amount, where total amount = sales tax + sales + additional sales tax. Sales tax is calculated as

Sales

Sales Tax

First Rs. 20,000

Nil

Next Rs. 20,000

5%

Next Rs. 15,000

10%

Excess

15%

6

    Additional Sales tax is

Company’s class

Additional sales tax

A

40% of sales amount

B

20% of sales amount

C

5% of sales amount

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.