Skip to content

saras025/Student-Report-Card-Generator

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 

Repository files navigation

Student-Report-Card-Generator

📝 Description This Excel project automatically calculates the total marks the students achieved and with the totals average marks is calculated to assign them grades accordingly

#🧠 Features Calculates Total, Average, and Grade Ranks students based on total marks Uses: SUM, AVERAGE, IF

#calculating total marks obtained by each student in each subject by summing the marks = sum (marks )

Screenshot 2025-06-02 184030

#calculate average from totals average marks = total sum of marks in all subjects / number of subjects = average (cell)

Screenshot 2025-06-02 184045

#using ifs formula to calculate the grade = IFS(F2>=80,"A",F2>=60,"B",F2>=40,"C",F2<=40,"F")

*conditional formating mark the students with A grade by GREEN i.e top and RED for students who got F grade i.e failed Screenshot 2025-06-02 184059

About

student report card generator using Ms Excel

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published