Class IX – Information Technology (Code 402)

Learning Outcomes

• Understand the purpose of charts.
• Identify different types of charts.
• Select an appropriate chart for different types of data.
• Create charts using LibreOffice Calc.
• Format charts with titles, legends and axis labels.

Section A : Multiple Choice Questions (1 × 5 = 5 Marks)

1. A chart is used to:
   1. Delete data
   2. Represent data graphically
   3. Format cells
   4. Rename worksheets
2. Which chart is best for comparing students' marks?
   1. Pie Chart
   2. Column Chart
   3. Line Chart
   4. Scatter Chart
3. Which chart is most suitable for showing percentage distribution?
   1. Bar Chart
   2. Pie Chart
   3. Column Chart
   4. Line Chart
4. Which chart is generally used to show trends over time?
   1. Line Chart
   2. Pie Chart
   3. Scatter Chart
   4. Column Chart
5. Which menu is used to create a chart in LibreOffice Calc?
   1. File
   2. Edit
   3. Insert
   4. Tools

Section B : Fill in the Blanks (1 × 5 = 5 Marks)

1. A chart is a __________________ representation of data.
2. A __________________ Chart is best for showing trends over time.
3. A __________________ Chart is best for showing percentage distribution.
4. The __________________ identifies different data series in a chart.
5. The __________________ displays categories and values in a chart.

Section C : True or False (1 × 5 = 5 Marks)

1. Charts help compare data easily. ________
2. A Pie Chart is suitable for showing parts of a whole. ________
3. A Line Chart is used to show changes over time. ________
4. Every chart should have a meaningful title. ________
5. Legends are never required in charts. ________

Section D : Match the Following (5 Marks)

Section E : Short Answer Questions (2 × 5 = 10 Marks)

1. What is a chart?
2. Write any four advantages of charts.
3. Differentiate between a Column Chart and a Pie Chart.
4. Name the main elements of a chart.
5. Why is it important to choose the correct chart type?

Section F : Practical Activity (10 Marks)

Create the following worksheet in LibreOffice Calc.

Tasks:

• Create a Column Chart to compare students' marks.
• Create a Pie Chart using the same data.
• Add a chart title.
• Add axis titles (where applicable).
• Display the legend.
• Save the file as Student_Charts.ods.

Section G : HOTS (Higher Order Thinking Skills) (5 Marks)

1. Why is a Column Chart more suitable than a Pie Chart for comparing students' marks?


2. A school wants to display the monthly attendance percentage of a class throughout the year. Which chart would you recommend and why?

Section H : Activity

Create the following worksheet showing the monthly sales of a stationery shop.

Activity:

• Create a Column Chart.
• Create a Line Chart.
• Compare both charts and write which one better represents the sales trend.

Teacher's Assessment

Self Reflection

Tick (✓) the statements that apply to you.

☐ I can identify different types of charts.

☐ I can choose the correct chart for different data.

☐ I can create charts in LibreOffice Calc.

☐ I can add chart titles, legends and axis labels.

☐ I need more practice in creating and formatting charts.