Scribd
Upload
14 views2 pages

Competency: Objective

Uploaded by

Balwaniregha Ronald
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
14 views2 pages

Competency: Objective

Uploaded by

Balwaniregha Ronald
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

Competency

Objective: Students will demonstrate proficiency in using Excel for data analysis by calculating
total scores, average scores, assigning grades, creating a bar chart, and ranking students based on
their total scores.
Namutumba Seed Secondary School
Activity of Integration
Senior Three
Term II 2024

You are a data analyst at a secondary school. The principal has asked you to analyze
the performance of students across different subjects and identify areas for
improvement. You have been given a dataset containing students' scores in various
subjects for the most recent term.
Name MTC ENG SCIE HIST Total Average Grade Rank
Student Score Score
ID
001 John Doe 75 82 89 78
002 Jane Smith 88 91 85 90
003 Alice Lee 67 73 80 72
004 Bob Brown 90 85 88 92

Task use Excel to perform the following


1) Calculate Total Scores
2) Calculate Average Scores
3) Assign Grades using H look-up
4) Create a Bar Chart Using name and Total score
5) Rank the students using total score

You might also like