ASSIGNMENT
DATA ENTRY OPERATIONS
(336)
1.
Answer any one out of the following questions in about 40-60 words:
(a)
What is the role of system software? Explain any tow system software.
Ans.:- System softwares are sets of
programs, responsible for running the computer, controlling various operations
of computer system (OS) falls under this category.
An operating system is a system software
that provides an interface for a user to communicate with the computer, manages
hardware devices (disk drives, keyboard, monitor, etc),
Although operating system provides all the
features users need to use and maintain their systems, inevitably, they still
do not meet everyone’s expectations. This has led to another type of system
software called “Utilities”.
(b)
What is application software? Differentiate between generalized and customized
application software.
Ans.:- Application software is a set of
programs, which are written to perform specific tasks. For example library
information system to used to manage information of library.
Differences between Generalized and
Customized application software:
Generalized are user friendly sofwares
written to cater to user’s very general needs such as preparing documents,
drawing pictures, database to manage data/information, preparing presentations,
play games etc. on the other hand customized are the applications that are
customized (or developed) to meet the specific requirements of an
organization/institution. For example, Student information details, payroll
packages, inventory control etc.
*******************************************
ALSO READ: NIOS FREE SOLVED ASSIGNMENTS FOR 2020 - 2021 EXAM
*******************************************
1. BUSINESS STUDIES - 215 FOR SECONDARY
1. BUSINESS STUDIES - 215 FOR SECONDARY
2. Answer
any one out of the following questions in about 40-60 words:
(a)
Can we interact with a computer in which operating system is not installed?
Justify your answer.
Ans.:-We can, but our computer would stop
working because Windows is the operating system, the software that makes it
tick and provides a platform for programs, like our web browser, to run on.
Without an operating system our computer is just a box of bits that do not know
how to communicate with one another, or us.
(b)
How can files and folders be managed in your computer?
Ans.:- A file is a collection of numbers
which have been written to our computer’s hard drive. These numbers can be
converted into a picture, a sound, text, or a set of instructions for a program
to perform certain action. A clue to a file’s type is given by its Icon or by
its file extension. Folders are containers for anything on a computer including
files and other folders. A path list the folders that have to be opened to get
to the required file.
3.
Answer any one out of the following questions in about 40-60 words.
(a)
How can you protect your document from unauthorized access?
Ans.:- Folder Protect is a unique software
program that doesn’t only password protect your data but also let you set different
access levels for your data. You can lock, hide, block access and protect your
data from modification as well as accidental or intended unauthorized deletion.
We can customize security levels for our
data and choose between making our files inaccessible, hidden, write-protected
or delete-proof. With Folder Protect we can prevent unauthorized access to our
files and folders if we select ‘No Access’ type of security that will
completely deny access to our data. Follow these simple steps to prevent data
from unauthorized access:
Download and install it on your computer.
Run the program and it will ask you to set and confirm a password. Once you
have set and confirmed the password, click on ‘OK’ to log in to the application
and then click the ‘Add’ button to add files, folders, drives, program or
extensions. When you click on the ‘Add’ button, a wizard screen will appear
showing you two steps:
Step 1: Choose Protection Method
Step 2: Add Items you Wish to Protect.
(b)
Explain the three types of documents required in mail merge.
Ans.:- Mail Merge requires three types of
documents:
(a)
Main Document: In a Mail Merge
operation, the personalized document (such as, a standard letter, or envelope,
or mailing label) is known as the main document. Ti is the document containing
the text and graphics that stay the same for each version of the merged
document – for example, the return address and body of a form letter.
(b)
Data Source: Data source is a
file that contains the names and addresses or any other information that vary
with each version of a mail-merge document. For example, a list of names and
addresses for a form letter you want to send to a list of clients or other
people.
(c)
Merge Document: When you merge
the main document with data source, a third document called merge document will
be produced. The merge document can be merged to the screen to view letters
along with addresses, or directly to the printer to print the letters along
with addressees and print addresses on envelopes or labels, or save as some
other file that can be used later for printing. Inserting the data or
information from the datat source in the main document creates the merge
document.
4.
Answer any one out of the following questions in about 40-60 words.
a) Give answer using Excel formula/function on
the following table
|
Name
|
Physics
|
Chemistry
|
Math
|
|
Amit
|
88
|
68
|
86
|
|
Arav
|
66
|
68
|
68
|
|
Puneet
|
78
|
77
|
87
|
|
Seema
|
88
|
98
|
88
|
|
Pankaj
|
78
|
88
|
77
|
|
Pooja
|
95
|
97
|
77
|
.(i)
What is the average marks in Physics, Chemistry and Maths?
Ans.:-
|
Name
|
Physics
|
Chemistry
|
Math
|
|
Amit
|
88
|
68
|
86
|
|
Arav
|
66
|
68
|
68
|
|
Puneet
|
78
|
77
|
87
|
|
Seema
|
88
|
98
|
88
|
|
Pankaj
|
78
|
88
|
77
|
|
Pooja
|
95
|
97
|
77
|
|
493
|
496
|
483
|
Average marks in Physics = Total marks of
Physics / No. Of students
Total marks = B2+B3+B4+B5+B6+B7 i.e 493
No. Of Students = 6
Therefore average marks = 493/6 = 82.17
Average marks in Chemistry = Total marks of
Chemistry / No. Of students
Total marks = B2+B3+B4+B5+B6+B7 i.e 496
No. Of students = 6
Therefore average marks = 496/6 = 82.67
Average marks in Math = Total marks of Math/No.
of students
Total marks = B2+B3+B4+B5+B6+B7 i.e 483
No. Of students = 6
Therefore average marks = 483/6 = 80.5
(ii)
Display the maximum marks in Physics and Chemistry.
Ans.:- Maximum marks in Physics is of Pooja
i.e. 95
Maximum
marks in Chemistry is of Seema i.e. 98
(b)
Give answer using Excel formula/function of the following table
|
Name
|
Physics
|
Chemistry
|
Math
|
|
Amit
|
88
|
68
|
86
|
|
Arav
|
66
|
68
|
68
|
|
Puneet
|
78
|
77
|
87
|
|
Seema
|
88
|
98
|
88
|
|
Pankaj
|
78
|
88
|
77
|
|
Pooja
|
95
|
97
|
77
|
FULL ASSIGNMENT IS AVAILABLE IN OUR MOBILE APP. DOWNLOAD HERE.
Post a Comment
Kindly give your valuable feedback to improve this website.