Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 33 views

    Simple Class Record Formulas

    Uploaded by

    10A NAWAF A. GUMAGA
    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.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Simple Class Record Formulas

    Uploaded by

    10A NAWAF A. GUMAGA
    33 views1 page
    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.

    Original Title

    Simple-Class-Record-Formulas

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    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.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    33 views1 page

    Simple Class Record Formulas

    Uploaded by

    10A NAWAF A. GUMAGA
    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.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 1

    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