NIOS
Senior Secondary Solved Assignment Session 2021-22
Data Entry Operations 336 Solved Assignment 2021-22
Tutor Marked Assignment
Max
Marks: 20
Note:
(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.
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
***
Post a Comment
Kindly give your valuable feedback to improve this website.