Home 
About
Blog
Who is a database administrator? Explain the major roles and responsibilities of DBA.
Define operating system. Explain the open-source operating system.
What is an ergonomic keyboard? Explain the working mechanism of a keyboard.
Explain different types of computers on the basis of size and power.
What is DBMS? Explain the Relational database model with a suitable diagram.
Prepare a specification of a personal computer which you want to purchase.
Explain any five DOS commands with suitable examples..
Attempt any TWO questions
[2x10=20]Prepare the following spreadsheet:
| Student Marks Record | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | H | G | H |
| SN | Name | CFA | Logic | Math | So Tech | English | Total | Per | Result | Grade | Rank | Remarks |
| 1 | Ram | 45 | 56 | 54 | 44 | 45 | ? | ? | ? | ? | ? | ? |
| 2 | Sham | 50 | 45 | 53 | 45 | 45 | ? | ? | ? | ? | ? | ? |
| 3 | Hari | 46 | 44 | 45 | 46 | 45 | ? | ? | ? | ? | ? | ? |
Conditions:
a) Write an appropriate formula to find the total marks of each student.
b) Write a formula to find out the percentage of each student.
c) Result is "Passed" if the student scores at least 40% marks in each subject.
d) Write a formula to calculate the grade of the student based on percentage:
- A for ≥90%
- B for ≥80%
- C for ≥70%
- D for ≥60%
- E for ≥40%
e) Write a formula to find the rank of individual students who have passed.
f) Write remarks based on the following conditions:
- "Excellent" for Grade A
- "Good" for Grade B
- "Fair" for Grade C
- "Moderate" for Grade D
- "Satisfactory" for Grade E
a) What is mail merge? Explain the major functions available in the Review tab of a Word document.
b) What is Photoshop? Write the steps to create an MRP-sized photograph in JPEG format.
Define Computer Network. Explain the OSI model in detail.