Friday, January 17, 2020

NIOS Free Solved Assignments (2019 - 2020): DATA ENTRY OPERATIONS 336 ENGLISH MEDIUM


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.

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.

https://play.google.com/store/apps/details?id=com.dynamic.tutorialshttps://play.google.com/store/apps/details?id=com.dynamic.tutorials

No comments:

Post a Comment

Kindly give your valuable feedback to improve this website.

Popular Posts for the Day