Computer Fundamentals and Applications 2018

Group B

Attempt any SIX questions. [6×5 = 30]

11. Define Computer. Explain the anatomy of a digital computer with a block diagram.

12. Define Operating System. Explain the functions of an Operating System.

13. Define DBMS. Explain the different database models with their merits and demerits.

14. Explain the different types of LAN topologies with their advantages and disadvantages.

15. What is WWW? Differentiate between intranet, extranet, and internet with an example.

16. What are contemporary technologies? Explain any two contemporary technologies with roles.

17. Write the DOS commands to complete the following tasks:

• a) Create a subdirectory theory and a practical inside d:\exam
• b) Create the file name marks.txt inside theory writing the content, "Theory marks in CFA".
• c) Rename the file name marks.txt with CFAmarks.txt.
• d) Make hidden the file CFAmarks.txt.
• e) Search all the files with .pdf extension.

Group C

Attempt any TWO questions. [2×10 = 20]

18. i) You are provided with the following data:

Bageswori Secondary School

Mark - Ledger

Write the formula in a spreadsheet package to calculate the following based on given conditions:

• i) Calculate Total marks. [1]
• ii) Calculate Percentage. [1]
• iii) Mark the student with either "PASS" or "FAIL" (Pass Marks 35). [1.5]
• iv) Calculate the division (If percentage >=60 then First, if percentage >=45 and percentage <60 then Second, if percentage >=35 and percentage <45 then Third otherwise "xxx"). [1.5]

ii) Explain the features of font control tools in word processing package.

19. i) Define computer peripherals. Differentiate between impact and non-impact printers. [1+4]

ii) Define Presentation. Write the features of a good presentation package. [5]

20. Define CMYK color model. Explain the basic tools and transforms available in Photoshop. [2+5+3]