Data Entry Operations 336 Solved Assignment 2021-22 | NIOS Senior Secondary Solved Assignment 2021 - 22

 NIOS Senior Secondary Solved Assignment Session 2021-22
Data Entry Operations 336 Solved Assignment 2021-22
Tutor Marked Assignment
Max Marks: 20


(i) All questions are compulsory. The Marks allotted for each question are given beside the questions.

(ii) Write your name, enrollment numbers, AI name and subject on the first page of the answer sheet.

1. Answer any one of the following questions.     2

(a) Rahul is purchasing a new computer for his home. Help him with devices name and description of various hardware components. (See Lesson 1)

Ans: Answer any one questions

(b) Windows is the most usable operating system because it is easy to use. Installation of new software or hardware is also easy. Write the steps to do so. (See Lesson 2)

Ans: Windows provides a quick and easy way to install new software. Add or Remove Programs utility in Control Panel help to manage programs and components on the computer system computer.

Install Software

1. Click Start, click Control Panel,

2. Double-click Add or Remove Programs.

3. Click on Add New Programs, and then select the source where the software to be installed is located such as CD or Floppy drive

4. Follow the instructions on your screen to install the software.

डाटा एंट्री ऑपरेशन (336) | Data Entry Operations 336 NIOS Free Solved Assignment 2021 – 22 (Hindi Medium)

2. Answer any one of the following questions.      2

(a) Explain the Windows XP, Desktop Elements. (See Lesson 2)

Ans: Answer any one questions

(b) Software plays a major role in Computer System. Explain the different types of Software’s. (See Lesson 1)

Ans: Software plays a major role in Computer System. Without software, the whole computer is useless. Software is basically of two types:

1. System Software: When you switch on the computer the programs stored in ROM are executed which activates different units of our computer and makes it ready for you to work on it. This set of programs can be called system software.

2. Application Software: Application software is a set of programs, which are written to perform specific tasks, for example: An application package for managing library known as library information system is used to manage information of library such as: keeping book details, account holder details, book issue details, book return details etc.

3. Answer any one of the following questions.      2

(a) Rajesh forgot the name of the document in which he was working in MS-Word. Help him with steps to locate his file. (See Lesson 3)

Ans: Answer any one questions

(b) Write the steps to protect the worksheet. (See Lesson 6)

Ans: Steps to protect the worksheet. How to Set a password for a workbook

1.    Click the Microsoft Office Button, and then click Save As.

2.    Click Tools, and then click General Options.

3.    Do one or both of the following:

a)    If you want reviewers to enter a password before they can view the workbook, type a password in the Password to open box.

b)   If you want reviewers to enter a password before they can save changes to the workbook, type a password in the Password to modify box.

4.    If you don’t want content reviewers to accidentally modify the file, select the Read-only recommended check box. When opening the file, reviewers will be asked whether or not they want to open the file as read-only.

5.    Click OK.

6.    When prompted, retype your passwords to confirm them, and then click OK.

7.    Click Save.

8.    If prompted, click Yes to replace the existing workbook.

4. Answer any one of the following questions.          4

(i) Write the steps to add the clip art in excel worksheet. (See Lesson 8)

Ans: Clip art is a single media file, including sound, animation, art or movie. Following are the Steps to insert a Clip Art in excel worksheet:

1.    Click on Insert Tab.

2.    From Illustrations Group, Click on Clip Art

3.    Then Select a Collection and press Go Button

4.    Click on a clip from the collection

5.    Clip will be inserted in the worksheet.

6.    To edit the clip, Just click on the clip. This will display Format tab. Choose the relevant group from the ribbon of Format tab and do the necessary changes.

(ii) Write the name and description of the various slide layouts in PowerPoint. (See Lesson 9)

Ans: Answer any one questions

5. Answer any one of the following questions.       4

(a) Mr. Sharma is a Social Science teacher in a school, and he is creating some assignment for his students. He is facing some problem while creating the assignments. Help him to do so with various steps: (See Lesson 4)

(i) Adding page border to the document.

(ii) Spell check utility.

(iii) Printing the document.

Ans: Answer any one questions

(b) Write the types of data which can be entered in Excel cells. (See Lesson 6)

Ans: You can enter various kinds of data in an excel cell. Some of them are explained below:

1.    Numbers: Your numbers can be from the entire range of numeric values: whole numbers (example, 25), decimals (example, 25.67) and scientific notation (example, 0.2567E+2). Excel displays scientific notation automatically if you enter a number that is too long to be viewed in its entirety in a cell.

2.    Text: First select the cell in which data has to be entered and type the text. Press ENTER key to finish your text entry. The text will be displayed in the active cell as well as in the Formula bar.

3.    Date and Time: When you enter dates and times, Excel converts these entries into serial numbers and kept as background information. However, the dates and times will be displayed to you on the worksheet in a format opted by you.

4.    Data in Series: You can fill a range of cells either with the same value or with a series of values with the help of Auto Fill.

(c) Explain the concept of SumIf () function with help of an example. (See Lesson 8)

Ans: Answer any one questions

6. Prepare any one project of the following projects given below. 6

(a) Visit your nearest departmental store and collect the following information. (See Lesson 10)

(i) Which type of internet connection they are using?

(ii) If they are using any website, write its URL.

(iii) Write the name of the ISP.

(iv) Write the mail id which they are using for support or contact us.

Ans: Answer any one questions

(b) Create a PowerPoint presentation on “Importance of Open - Source Software”. It must include the following (one slide each): (See Lesson 9)

• What is Open - Source Software?

• Freedom of OSS

• Different types of OSS

• Importance of OSS

Ans.: Open-source software is a type of computer software in which source code is released under a license in which the copyright holder grants users the rights to study, change, and distribute the software to anyone and for any purpose. Open-source software may be developed in a collaborative public manner.

Open source software is generally free software that you can use in your business. Open source developers choose the make the source code of their software publicly available for the good of the community and to publish their software with an open source license meaning that other developers can see how it works and add to it. Examples of open source products include Open Office, the internet browser Mozilla Firefox, Wikipedia, the GNU/Linux operating system and its derivative Android, an operating system for mobile devices.

Freedom of OSS

1.    The freedom to run the program as you wish, for any purpose.

2.    The freedom to study how the program works, and change it so it does your computing as  you wish. Access to the source code is a precondition for this.

3.    The freedom to redistribute copies so you can help others .

4.    The freedom to distribute copies of your modified versions to others. By doing this you can give the whole community a chance to benefit from your changes.

Types of open source software

1.    Open source office software.

2.    Open source accounting software.

3.    Open source operating systems.

4.    Open source browsers and communication applications.

5.    Open source IT security etc.,

Importance of Open source software

By placing an open source license on an original work, a person or organization agrees to:

1.    Make the entirety of the program’s code available to the public

2.    Allow anyone to modify, enhance or re-engineer a program’s code

3.    Allow the creation of derivative works

4.    Allow the program to be utilized for any purpose the user wishes



0/Post a Comment/Comments

Kindly give your valuable feedback to improve this website.