Scribd
Upload
66 views1 page

First Quarter Student Grades Report

This document summarizes the class records of 10 students for the first quarter. It includes each student's name, gender, scores on written works, physical training, exams and overall grade which is calculated as a weighted average. The students' grades are ranked and it is noted whether they passed or failed. Aggregate data is also provided including the total number of students, females and males as well as the highest, lowest grades achieved and number of students who passed and failed.

Uploaded by

10A NAWAF A. GUMAGA
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
66 views1 page

First Quarter Student Grades Report

This document summarizes the class records of 10 students for the first quarter. It includes each student's name, gender, scores on written works, physical training, exams and overall grade which is calculated as a weighted average. The students' grades are ranked and it is noted whether they passed or failed. Aggregate data is also provided including the total number of students, females and males as well as the highest, lowest grades achieved and number of students who passed and failed.

Uploaded by

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

First Quarter Class Record

# Written Works PT Exam Transmuted


Student
Gender A1 A2 A3 Q1 Q2 Q3 Total Initial Grade Grade Remarks Rank
25% 50% 25%
(LASTNAME, Firstname M.I.) 10 10 10 20 20 20 =SUM(D5:I5) 100 100 60-Base
1 A M 8 9 7 18 15 15 =SUM(D6:I6) =J6/$J$5*$K$4 89 =L6/$L$5*$M$4 90 =N6/$N$5*$O$4 =K6+M6+O6 =P6*100*0.4+60 =IF(Q6<74.5,"Failed","Passed") =RANK(Q6,$Q$6:$Q$15,0)
2 B M 8 9 6 12 15 15 =SUM(D7:I7) =J7/$J$5*$K$4 75 =L7/$L$5*$M$4 87 =N7/$N$5*$O$4 =K7+M7+O7 =P7*100*0.4+60 =IF(Q7<74.5,"Failed","Passed") =RANK(Q7,$Q$6:$Q$15,0)
3 C F 8 9 6 12 15 15 =SUM(D8:I8) =J8/$J$5*$K$4 75 =L8/$L$5*$M$4 54 =N8/$N$5*$O$4 =K8+M8+O8 =P8*100*0.4+60 =IF(Q8<74.5,"Failed","Passed") =RANK(Q8,$Q$6:$Q$15,0)
4 D F 8 9 6 12 15 15 =SUM(D9:I9) =J9/$J$5*$K$4 75 =L9/$L$5*$M$4 67 =N9/$N$5*$O$4 =K9+M9+O9 =P9*100*0.4+60 =IF(Q9<74.5,"Failed","Passed") =RANK(Q9,$Q$6:$Q$15,0)
5 E F 7 9 6 9 15 15 =SUM(D10:I10) =J10/$J$5*$K$4 70 =L10/$L$5*$M$4 55 =N10/$N$5*$O$4 =K10+M10+O10 =P10*100*0.4+60 =IF(Q10<74.5,"Failed","Passed") =RANK(Q10,$Q$6:$Q$15,0)
6 F F 7 9 6 9 15 15 =SUM(D11:I11) =J11/$J$5*$K$4 90 =L11/$L$5*$M$4 34 =N11/$N$5*$O$4 =K11+M11+O11 =P11*100*0.4+60 =IF(Q11<74.5,"Failed","Passed") =RANK(Q11,$Q$6:$Q$15,0)
7 G F 7 9 6 9 15 15 =SUM(D12:I12) =J12/$J$5*$K$4 91 =L12/$L$5*$M$4 15 =N12/$N$5*$O$4 =K12+M12+O12 =P12*100*0.4+60 =IF(Q12<74.5,"Failed","Passed") =RANK(Q12,$Q$6:$Q$15,0)
8 H F 8 9 6 12 15 15 =SUM(D13:I13) =J13/$J$5*$K$4 65 =L13/$L$5*$M$4 28 =N13/$N$5*$O$4 =K13+M13+O13 =P13*100*0.4+60 =IF(Q13<74.5,"Failed","Passed") =RANK(Q13,$Q$6:$Q$15,0)
9 I F 5 9 6 15 15 15 =SUM(D14:I14) =J14/$J$5*$K$4 60 =L14/$L$5*$M$4 67 =N14/$N$5*$O$4 =K14+M14+O14 =P14*100*0.4+60 =IF(Q14<74.5,"Failed","Passed") =RANK(Q14,$Q$6:$Q$15,0)
10 J M 1 0 1 10 10 10 =SUM(D15:I15) =J15/$J$5*$K$4 20 =L15/$L$5*$M$4 10 =N15/$N$5*$O$4 =K14+M14+O15 =P15*100*0.4+60 =IF(Q15<74.5,"Failed","Passed") =RANK(Q15,$Q$6:$Q$15,0)

Total =COUNT(A6:A15) Highest Grade =MAX(Q6:Q15)


Total Female =COUNTIF(C6:C15,"M") Lowest Grade =MIN(Q6:Q15)
Total Male =COUNTIF(C6:C15,"F") Total Passed =COUNTIF(R6:R15,"Passed")
Total Failed =COUNTIF(R6:R15,"Failed")

You might also like