Class IX Information Technology (Code 402)

Learning Objectives

After completing this lesson, students will be able to:

• Understand the purpose of charts.
• Create charts using LibreOffice Calc.
• Differentiate between various chart types.
• Select the appropriate chart for different types of data.
• Format charts professionally.

Prerequisite Knowledge

• Entering data into worksheets.
• Using formulas and functions.
• Formatting worksheets.
• Understanding cell references.

What is a Chart?

A Chart is a graphical representation of data. Charts help users understand, compare and analyse information quickly by converting numerical values into visual forms.

Advantages of Charts

• Easy to understand.
• Visually attractive.
• Makes comparisons simple.
• Helps identify trends.
• Supports decision making.
• Improves presentations and reports.

Common Types of Charts

Elements of a Chart

Steps to Create a Chart

1. Enter data into the worksheet.
2. Select the required data range.
3. Click Insert → Chart.
4. Select the required chart type.
5. Choose the data range and data series.
6. Add Chart Title and Axis Titles.
7. Display Legend if required.
8. Click Finish.

Sample Data

Choosing the Correct Chart

Formatting Charts

• Add a meaningful chart title.
• Label both axes.
• Display legend when multiple data series exist.
• Choose suitable colours.
• Keep charts simple and readable.
• Avoid unnecessary visual effects.

Classroom Activity

1. Create the sample marksheet.
2. Create a Column Chart.
3. Create a Pie Chart using the same data.
4. Compare both charts.
5. Identify which chart is more suitable for comparing student marks.

Practical Activity

Create a worksheet containing the monthly sales of a stationery shop.

Create:

• Column Chart
• Line Chart

Add a suitable title, axis labels and legend.

Points to Remember

• Charts convert data into visual form.
• Select the correct chart according to the data.
• Always give a meaningful title.
• Label the axes clearly.
• Keep charts neat and easy to read.

Quick Check

1. What is a chart?
2. Why are charts useful?
3. Which chart is best for comparing student marks?
4. Which chart shows trends over time?
5. Which chart shows percentage distribution?
6. Name any four elements of a chart.

Homework

1. Create a worksheet showing your monthly pocket expenses.
2. Prepare:
   • A Pie Chart showing the expense distribution.
   • A Column Chart comparing expenses across categories.
3. Add a chart title, legend and data labels.
4. Save the file as Pocket_Expenses.ods.

Assessment

Summary