Grade IX Information Technology Lab Manual

Aim

To perform calculations in a spreadsheet using formulas and functions and represent the data visually using charts.

Learning Outcomes

• Create and edit spreadsheets.
• Use mathematical formulas.
• Apply SUM and AVERAGE functions.
• Calculate percentages.
• Create charts for data analysis.
• Format spreadsheet professionally.

Software Required

• LibreOffice Calc
• Windows / Linux Computer

Previous Knowledge

• How to open LibreOffice Calc.
• Rows, columns and cells.
• Basic data entry.

Problem Statement

Prepare a marksheet of five students, calculate their Total, Average and Percentage, then create a chart showing their total marks.

Sample Data

Procedure

1. Open LibreOffice Calc.
2. Enter the sample data.
3. Create three new columns: Total, Average, Percentage.
4. Calculate Total using:

=SUM(B2:F2)

5. Calculate Average using:

=AVERAGE(B2:F2)

6. Calculate Percentage using:

=SUM(B2:F2)/500*100

7. Copy formulas for all students.
8. Format Percentage column to two decimal places.
9. Apply borders and cell colours.
10. Select Name and Total columns.
11. Click Insert → Chart.
12. Select a Column Chart.
13. Add:
    • Chart Title
    • X-axis Title
    • Y-axis Title
14. Save as: Student_Marksheet.ods

Expected Spreadsheet

Chart Activity

Create a Column Chart showing the Total Marks obtained by each student.

Observation

Spreadsheet formulas perform calculations automatically, while charts help compare data visually.

Result

The spreadsheet successfully calculated totals, averages and percentages and displayed the results using a column chart.

Lab Viva Questions

1. What is a spreadsheet?
2. What is the purpose of the SUM() function?
3. What does the AVERAGE() function return?
4. How is percentage calculated?
5. Name any two types of charts.
6. Why are charts useful?

Extension Activity

Teacher Assessment Rubric