Scribd
Upload
13 views2 pages

Student Marks Analysis in Spreadsheets

The document outlines a procedure for using spreadsheet software to analyze student marks, including calculations for total and average scores. It provides a step-by-step guide on entering data, applying formulas, formatting the table, and creating visual representations like bar charts. The final step involves saving the completed spreadsheet for further analysis.

Uploaded by

Harshadha Army
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
13 views2 pages

Student Marks Analysis in Spreadsheets

The document outlines a procedure for using spreadsheet software to analyze student marks, including calculations for total and average scores. It provides a step-by-step guide on entering data, applying formulas, formatting the table, and creating visual representations like bar charts. The final step involves saving the completed spreadsheet for further analysis.

Uploaded by

Harshadha Army
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Ex 2: Spreadsheets for Calculations and Data Visualization

AIM:
To use spreadsheet software (MS Excel /LibreOffice Calc) for performing
calculations, analysing data and creating virtual representations (charts, graphs).
Algorithm:
[Link] spreadsheet software.
2. Enter tabular data (e.g. Student marks, sales figures).
3. Apply for calculations (SUM, AVERAGE, MAX, MIN, IF).
[Link] the data (borders, colours, alignment).
5. Select data ->Insert chart (Bar, Line, Pie, etc).
[Link] and analyze results.
Procedure:
1. Open MS Excel/Calc
2. Enter students marks in columns
 Column A: Students Names
 Columns B-D: Marks in Subjects
3. In Column E, calculate Total using formula
=SUM (B2:D2)
4. In Column Calculate Average:
=AVERAGE (B2:D2)
5. Highlight data -> Go to Insert -> Chart.
6. Choose a Bar Chart for comparison or Pie Chart for percentage distribution.
7. Save the file as [Link].
Example
 Data: Marks of 5 students in 3 subjects
 Formulas: =SUM (B2:D2) for total, =AVERAGE (B2:D2) for average.
 Visualization: A Bar Chart showing student -wise total marks.
Example Chosen
Topic: Student Marks Analysis
We will enter student marks in different subjects, calculate the Total and Average and
visualize the data using a Bar Chart.
Procedure (Step-Step):
Step 1: Open Spreadsheet Applications
 Start MS Excel or LibreOffice Calc.
Step 2: Enter Data
Type the following data into the cells:

STUDENT NAME MARK 1 MARK 2 MARK 3


ARJUN 78 85 90
PRIYA 88 92 95
KARTHIK 70 68 75
MEENA 82 80 85
RAHUL 60 72 65

Step 3: Calculate Total Marks


In Column E,type the formula for each student:
For Arjun (Row 2):
=SUM (B2:D2)
Drag Down to apply for all students
Step 4: Calculate Average Marks
In Column F, type the formula for each student:
For Arjun (Row 2):
=AVERAGE (B2:D2)
Drag Down to apply for all students
Step 5: Format the table
 Apply bold headings, enter align and add borders.
 Highlight top scorer using Conditional Formatting.
Step 6: Create a Chart
 Select Student Names + Total Marks
 Goto Insert→Chart
 Choose Bar Chart (or Column Chart).
 Add Chart title: “Student Performance”
Step 7: Save the file

You might also like