December 2005 PC SOFTWARE SKILLS

IGNOU BCA CS-612: PC SOFTWARE SKILLS - DECEMBER 2005 QUESTION PAPER

---

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
December, 2005
CS-612 (S): PC SOFTWARE SKILLS

Time : 2 Hours

Max. Marks : 75

---

Note : Question number 1 is compulsory. Answer any three questions from the rest.

---

1. (a) A boatman must ferry across a river a wolf, a sheep and a bundle of fodder. His boat is too small to carry more than hmmself and one of the passengers at a time. He cannot leave the wolf alone with the sheep. or the sheep alone with the fodder. Show how he can cross without any detriment to either sheep or fodder by labelling all the states on the left and right banks of the river. (7)

(b) If you have twelve coins, one of which is different from the rest (heavier), how will you pick it out in three weighings ? Show the steps using a Decision tree. (5)

(c) Explain the following terms : (10)
(i) Auto format
(ii) Auto fill
(iii) Font
(iv) WYSIWYG
(v) Page setup

(d) What is a 'Browser' ? Explain any two differences between the two basic categories of Browsers. (4)

(e) Explain the functioning of any four worksheet controls. (4)

2. (a) Explain any five fields of an email message composition window. (5)

(b) Explain 'Usenet' & 'Newsgroups' and their significance on the Internet. (5)

(c) What is a Domain Name System (DNS) ? What are the different bases for classifying DNS ? Explain with two examples each. (5)

3. (a) What is FTP ? Explain the procedure of transferring files using FTP, with a diagram. (5)

(b) What is a function ? Explain any two functions with syntax; of the following categories : (10)
(i) Arithmetic
(ii) Lookup & References

4. (a) What is "filtering a database" ? Explain two ways to filter a database. (5)

(b) What is a Pivot table ? Explain the process of adding and removing pivot table data. (5)

(c) Prove that the product of our consecutive natural numbers cannot be the square of an integer. (5)

5. (a) Explain the processes involved in restricting access to a workbook. (5)

(b) Explain the following terms : (6)
(i) Telnet
(ii) Internet Service Provider
(iii) www

(c) What are "Macros" ? Explain the steps to run a Macro. (4)