NIOS Class 10th Data Entry English Medium Solve Assignment (TMA) 2021

 Data Entry Operations (229)

Tutor Marked Assignment

Max.Marks: 20

New TMA- NIOS Class 10th Data English TMA 2021-22

1. Answer any one of the following questions in about 40-60 words.

(a) Differentiate between system software and application software.

Ans-

2. Answer any one of the following questions in about 40-60 words.

(a) Write the shortcut keys of the following.

Find, Format Painter, Subscript, Change case

Ans-

Find : Ctrl + F

Format painter : Alt + H + F + P

Subscript : Ctrl + Shift + +

Change case : SHIFT + F3

3. Answer any one of the following questions in about 40-60 words.

(a) What are the main features of MS Excel?

Ans- Main features of MS Excel?

1. Add Header and Footer

MS Excel allows us to keep the header and footer in our spreadsheet Document.

2. Find and Replace Command

MS Excel allows us to find the needed data (text and numbers) in the workbook and also replace the existing data with a new one.

3. Password Protection

It allows the user to protect their workbooks by using a password from unauthorized access to their information.

4. Data Filtering

Filtering is a quick and easy way to find and work with a subset of data In a range. A filtered range displays only the rows that meet the criteria You specify for a column. MS Excel provides two commands for filtering Ranges:

• AutoFilter; which includes a filter by the selection, for simple criteria
• Advanced Filter; for more complex criteria

5. Data Sorting

Data sorting is the process of arranging data in some logical order. MS Excel allows us to sort data either in ascending or descending order.

6. Built-in formulae

MS Excel has got many built-in formulae for sum, average, minimum, etc. We can use those formulae as per our needs.

7. Create different charts (Pivot Table Report)

MS Excel allows us to create different charts such as bar graphs, pie charts, line graphs, etc. This helps us to analyze and compare data very easily.

8. Automatically edits the result

MS Excel automatically edits the result if any changes are made in any of The cells.

9. Formula Auditing

Using formula auditing we can graphically display or trace the relationships between cells and formulas with blue arrows. We can trace the precedents (the cells that provide data to a specific cell) or the dependents (the cells that depend on the value in a specific cell).

4. Answer any one of the following questions in about 100-150 words.

(b) Define chart. Name the different types of charts. Explain any three types of charts.

Ans- Charts are pictorial representations of worksheet data.

The different types of charts were

1. Pie

2. Column

3. Bar

4. Area

5. Surface

6. Line

Explain three types of charts were :

1 Pie Chart - A type of graph in which a circle is divided into sectors that each represent a proportion of the whole.

Excel uses the row heading (series identifier) for the chart title and displays the data as proportional slices of a pie (1st image below). One can customize the design of the pie chart so either numeric values or their percentages display on top of the slices of pie.

The legend can be moved to the top, bottom, left, right, or top right (“corner” in older versions) of the chart. Legend names can be changed by changing the column headings in the sheet or editing the chart directly in new Excel versions.

2 Column Chart: A column chart is a graphic representation of data. Column charts display vertical bars going across the chart horizontally with the vues axis being displayed on the left side of the Chart.

Because Excel uses a different color for each data series, it’s easy to see how a single series changes over time, or compare multiple series over a given time period. The Clustered Column Chart is especially popular.

3 Bar Chart - A diagram in which the numerical values of variables are represented by the height or length of lines or rectangles of equal width.

When to use a Bar Chart versus a Column Chart depends on the type of data and user

preference. Sometimes it is worth the time to create both charts and compare the results. However, Bar Charts do tend to display and compare a large number of series better than the other chart types.

All Bar Charts are available in 2-D and 3-D formats.

5. Answer anyone out of the following questions in about 100 to 150 words.
(a) Write short notes on smart art graphics. Write different steps to create smart art.
Ans- a SmartArt graphic can be created and added to the document. SmartArt is a way to turn ordinary text into something more visually appealing. It can be used to draw attention to important information or to make information easier to interpret and understand. SmartArt can be used to create an organizational chart, a decision tree, a pyramid or matrix structure, illustrate steps in a process, or display events in a timeline. To create SmartArt, click on the
Insert tab in the toolbar, then click on the SmartArt icon, as shown in the image.

Different steps to create smart art:

Create a SmartArt graphic to quickly and easily make a visual representation of your
information. You can choose from among many different layouts, to effectively communicate your message or ideas. SmartArt graphics can be created in Excel, Outlook, PowerPoint, and Word, and they can be used throughout Office.

For an overview of SmartArt graphics, including considerations for Choosing the best graphic and layout type to display your data or convey A concept, see Choose a SmartArt graphic.

Insert a SmartArt graphic and add text to it

1. On the Insert tab, in the Illustrations group, click SmartArt.

2. In the Choose a SmartArt Graphic dialog box, click the type and layout that you want.

3. Enter your text by doing one of the following:

4. Click [Text] in the Text pane, and then type your text.

5. Copy text from another location or program, click [Text] in the Text pane, and then paste your text.

6. Click in a box in the SmartArt graphic, and then type your text. For best results, use this option after you add all of the boxes that you want.

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

(b) Create a PowerPoint presentation on "Importance of Health". It must include the following.

(one slide each)

(i) What is Health?

(ii) Mental Health and Physical Health

(iii) Healthy Food Habits

(iv) Role of Physical activities in maintaining Health

Ans- A PowerPoint presentation on "Importance of health" can be created in the following way with each slide on the given topic.

(i) Health can be defined as a state of social, mental, and physical well-being and not only without any infirmity or disease.

(ii) Mental health and physical health are synonymous with each other. A mentally healthy person will always tend to have good physical health and vice versa. Regular exercise can keep our physical and mental health in good stead.

(iii) Healthy food habits include consuming all types of food items in a proper and regulated manner so that there is a proper balance of all nutrients and vitamins and there is no deficiency of any type in the body.

(iv) Physical activity is very important to maintain proper health.

They can help in keeping the blood pressure, sugar levels, and other important parameters in check.

Additionally, physical activities also help in having a calm and attentive mind.