Computer Practical Set-5
1. Type within 5 minutes:
प्रविधि
आधुनिक मानव जीवनको अभिन्न अंग बनेको छ। आजको युगलाई विज्ञान र प्रविधिको युग
भनिन्छ। प्रविधिले मानिसको जीवनलाई सरल, सहज, छिटो
र सुविधाजनक बनाएको छ। कम्प्युटर, मोबाइल
फोन, इन्टरनेट, टेलिभिजन, रोबोट र कृत्रिम बुद्धिमत्ता आधुनिक
प्रविधिका उदाहरण हुन्।
प्रविधिको विकासले
शिक्षा, स्वास्थ्य, कृषि, उद्योग, व्यापार र सञ्चार क्षेत्रमा ठूलो
परिवर्तन ल्याएको छ। विद्यार्थीहरूले इन्टरनेटको माध्यमबाट घरमै बसेर विभिन्न
विषयको अध्ययन गर्न सक्छन्। अनलाइन कक्षा, डिजिटल पुस्तकालय र शैक्षिक वेबसाइटहरूले सिकाइलाई प्रभावकारी
बनाएका छन्। स्वास्थ्य क्षेत्रमा आधुनिक उपकरणको प्रयोगबाट रोग पत्ता लगाउन र
उपचार गर्न सजिलो भएको छ। त्यस्तै, किसानहरूले
आधुनिक कृषि प्रविधिको प्रयोग गरी उत्पादन बढाउन सक्छन्।
प्रविधिले
संसारलाई एउटा सानो गाउँजस्तै बनाएको छ। मोबाइल फोन र इन्टरनेटको माध्यमबाट
संसारको जुनसुकै ठाउँमा रहेका मानिससँग सजिलै कुराकानी गर्न सकिन्छ। अनलाइन बैंकिङ,
डिजिटल भुक्तानी र विद्युतीय सेवाले
मानिसको समय र श्रम बचाएका छन्। तर प्रविधिका केही
नकारात्मक पक्ष पनि छन्। यसको दुरुपयोगले साइबर अपराध, गलत सूचना, गोपनीयताको जोखिम र सामाजिक सञ्जालको लत
बढाउन सक्छ। अत्यधिक मोबाइल तथा कम्प्युटर प्रयोगले स्वास्थ्यमा समेत नकारात्मक
असर पार्न सक्छ। त्यसैले प्रविधिको सही र सुरक्षित
प्रयोग गर्नुपर्छ। विद्यार्थीहरूले प्रविधिलाई मनोरञ्जनका लागि मात्र नभई ज्ञान र
सीप हासिल गर्न प्रयोग गर्नुपर्छ। प्रविधिको उचित उपयोगले देशको आर्थिक, सामाजिक तथा शैक्षिक विकासमा
महत्त्वपूर्ण योगदान पुर्याउँछ। वास्तवमा, प्रविधि मानव विकासको महत्त्वपूर्ण आधार
हो।
2. Type given English text within 5 minutes:
A computer is one of the most important
inventions of modern science and technology. It has become an essential part of
our daily life. A computer is an electronic device that accepts data, processes
it, stores information and produces meaningful results. It helps people perform
different tasks quickly and accurately. Computers are widely used in schools,
colleges, offices, banks, hospitals, industries and business organizations. In
the education sector, students and teachers use computers for learning,
teaching, preparing documents and conducting online classes. In offices,
computers are used to prepare letters, reports, notices and other important
documents. Banks use computers to maintain customer accounts and perform
financial transactions.
The internet has made computers more useful.
People can communicate with others through email, video calls and social media.
They can also search for information, watch educational videos, attend online
meetings and make digital payments. Computers are also used in scientific
research, weather forecasting, designing, entertainment and space exploration. There
are different types of computers, such as supercomputers, mainframe computers,
minicomputers and microcomputers. A desktop computer, laptop, tablet and
smartphone are common examples of computing devices. Although computers have
many advantages, they also have some disadvantages. Excessive use of computers
may cause eye strain, health problems and addiction. Cybercrime, data theft and
computer viruses are other major risks.
Therefore, we should use computers wisely and
safely. Computer knowledge is essential in today's digital world. It helps
people improve their knowledge, skills and productivity. In conclusion,
computers have made human life easier, faster and more comfortable.
3. Paste the Q.2 Text and do the following
activities:
a. Set page size to A4 and margins
to 1 inch.
b. Create a cover page with title,
subtitle and date.
c. Apply Heading 1, Heading 2 and
Normal styles.
d. Insert an automatic Table of
Contents.
e. Insert a 5 × 5 table containing
project details.
f. Insert a chart showing project
expenditure.
g. Insert two relevant pictures
with text wrapping.
h. Add captions to pictures and the
table.
i. Insert a footnote and endnote.
j. Create different headers and
footers using section breaks.
k. Insert automatic page numbers.
l. Apply a page border and
watermark.
m. Insert hyperlinks to relevant
websites.
4. Prepare the
following table and calculate the achievement percentage.
|
Office |
Target |
Actual |
Achievement |
|
Office A |
5,000 |
4,500 |
? |
|
Office B |
6,000 |
6,600 |
? |
|
Office C |
8,000 |
7,200 |
? |
|
Office D |
10,000 |
11,000 |
? |
Perform the
following tasks:
1. Calculate Achievement Percentage using
the formula:
Achievement = (Actual / Target) × 100
2. Apply Percentage formatting to the
Achievement column.
3. Apply All Borders to both tables.
4. Make the heading rows Bold and apply
suitable background shading.
5. Sort the employee records according to
Net Salary in descending order.
6. Sort the office records according to
Achievement in descending order.
7. Create a suitable chart to compare
Target and Actual values of all offices.
8. Save the workbook as
Employee_Salary.xlsx.
5. Assume a
table named Employee contains the following fields:
EmployeeID,
EmployeeName, DepartmentID, Salary
Create and
execute the following queries using Query Design or SQL View:
1. Display all employees.
2. Display employees earning more than Rs.
30,000.
3. Sort employees according to Salary from
highest to lowest.
4. Count the total number of employees.
5. Display employees belonging to a
specified department (e.g., DepartmentID = 1).
6. Save each query with a meaningful name.
Required SQL
Queries:
i. Display all
employees
ii. Employees
earning more than Rs. 30,000
iii. Sort
salary in descending order
iv. Count total
employees
v. Display
employees from Department 1
Save the
database as CompanyDB.accdb.
6. Create an
HTML webpage displaying the following information using Ordered Lists and
Unordered Lists.
1. Generations
of Computers
a. First
Generation of Computer
- Vacuum Tube
b. Second
Generation of Computer
- Transistor
c. Third
Generation of Computer
- Integrated
Circuit
d. Fourth
Generation of Computer
-
Microprocessor
e. Fifth
Generation of Computer
- Biochip
Instructions:
- Use appropriate <ol>,
<ul> and <li> tags.
- Maintain proper numbering and
indentation.
- Apply suitable heading formatting.