Scribd Logo
Upload

Welcome to Scribd!

  • 30 views

    Student Grade Finder: Student Last Name Midterm Final Q1M Equiv Q2M Equiv Midterm Gradeq1F Equiv Anderson

    Uploaded by

    Kris Wuthrich Batario
    The document describes a student grade finder tool that allows instructors to look up student grades by last name. It provides instructions on how to complete the class record table to calculate student grades for midterm and final terms using formulas. The class record table shows example student data like assignment, exam and equivalent grades that are calculated based on a provided grading scale.

    Copyright:

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

    Student Grade Finder: Student Last Name Midterm Final Q1M Equiv Q2M Equiv Midterm Gradeq1F Equiv Anderson

    Uploaded by

    Kris Wuthrich Batario
    30 views3 pages
    The document describes a student grade finder tool that allows instructors to look up student grades by last name. It provides instructions on how to complete the class record table to calculate student grades for midterm and final terms using formulas. The class record table shows example student data like assignment, exam and equivalent grades that are calculated based on a provided grading scale.

    Original Title

    it era lab

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes a student grade finder tool that allows instructors to look up student grades by last name. It provides instructions on how to complete the class record table to calculate student grades for midterm and final terms using formulas. The class record table shows example student data like assignment, exam and equivalent grades that are calculated based on a provided grading scale.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    30 views3 pages

    Student Grade Finder: Student Last Name Midterm Final Q1M Equiv Q2M Equiv Midterm Gradeq1F Equiv Anderson

    Uploaded by

    Kris Wuthrich Batario
    The document describes a student grade finder tool that allows instructors to look up student grades by last name. It provides instructions on how to complete the class record table to calculate student grades for midterm and final terms using formulas. The class record table shows example student data like assignment, exam and equivalent grades that are calculated based on a provided grading scale.

    Copyright:

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

    The Student Grade Finder below lets an Instructor look up a student's records for Midterm and Final terms by

    simply typing in their last name. When the last name is entered, cells G14 to L14 should display the
    corresponding grades for the student.

    STUDENT GRADE FINDER


    MIDTERM FINAL
    STUDENT LAST NAME
    Q1M EQUIV Q2M EQUIV MIDTERM GRADEQ1F EQUIV
    ANDERSON

    INSTRUCTIONS:
    1. To enable the Student Grade Finder, you must complete first the Class Record table in the right.

    2. To complete the table, write the formulas in their respective columns per student to compute for the following:
    AVE = average of five Assignments (e.g., 6-10, 11-15)
    Q1M Raw = equal to AVE
    Q2M Raw = equal to MIDTERM EXAM
    Q1M EQUIV = equal to the evaluated Q1M RAW (see #3)
    Q2M EQUIV = equal to the evaluated Q2M RAW (see #3)
    MIDTERM GRADE = average of Q1M EQUIV and Q2M EQUIV
    Q1F Raw = equal to AVE
    Q2F Raw = equal to FINAL EXAM
    Q1F EQUIV = equal to the evaluated Q1F RAW (see #3)
    Q2F EQUIV = equal to the evaluated Q2F RAW (see #3)
    FINAL GRADE = average of Q1F EQUIV and Q2F EQUIV

    3. To compute for the evaluated Q1M/Q1F RAW and Q2M/Q2F RAW, use the following grading equivalent:
    0-20 =20
    21-40 =40
    41-60 =60
    61-80 =80
    81-90 =90
    91-100 =100

    4. Lastly, add conditional formatting to Student Grade Finder cells of MIDTERM GRADE and FINAL
    GRADE if the grade is less than or equal to 75:
    Italicized text
    Orange fill
    Black text color
    CLASS RECORD
    Assignments MIDTERM Q1M Q1M Q2M Q2M
    LAST NAME
    6 7 8 9 10 AVE EXAM RAW EQUIV RAW EQUIV
    Anderson 90 75 90 85 100 88 95 88 90 95 100
    Beesly 50 75 60 50 50 57 90 57 60 90 90
    Bernard 100 75 100 85 100 92 100 92 100 100 100
    Bertram 75 80 100 90 75 84 75 84 90 75 80
    Bratton 90 75 100 95 75 87 75 87 90 75 80
    California 85 75 100 100 75 87 75 87 90 75 80
    Flax 0 0 0 90 0 18 0 18 20 0 20
    Flenderson 100 75 100 100 75 90 95 90 90 95 100
    or the following: Green 100 75 100 90 100 93 65 93 100 65 80
    Halpert 90 75 100 100 75 88 100 88 90 100 100
    Hannon 90 100 100 90 75 91 75 91 100 75 80
    Howard 75 75 100 95 75 84 75 84 90 75 80
    Hudson 90 0 0 0 0 18 85 18 20 85 90
    Javier 95 100 66 90 100 90.2 100 90.2 90 100 100
    Kapoor 85 100 100 100 75 92 100 92 100 100 100
    Lee 100 100 0 95 75 74 95 74 80 95 100
    Levinson 100 0 20 100 75 59 95 59 60 95 100
    Lewis 70 100 10 100 100 76 100 76 80 100 100
    Malone 100 75 100 100 75 90 100 90 90 100 100
    Martin 85 100 100 95 75 91 20 91 100 20 20
    Martinez 100 100 100 100 75 95 75 95 100 75 80
    equivalent: Miller 100 100 100 90 75 93 95 93 100 95 100
    Palmer 90 100 74 90 75 85.8 100 85.8 90 100 100
    Park 100 95 100 100 100 99 75 99 100 75 80
    Philbin 10 35 0 0 0 9 25 9 20 25 40
    Rodrigo 95 100 100 95 100 98 100 98 100 100 100
    Schrute 100 100 100 95 75 94 95 94 100 95 100
    Scott 95 100 100 100 75 94 100 94 100 100 100
    Smith 15 100 55 90 75 67 45 67 80 45 60
    Vance 100 100 100 90 75 93 100 93 100 100 100
    CLASS RECORD
    MIDTERM Assignments FINAL Q1F Q1F Q2F Q2F FINAL
    GRADE 11 12 13 14 15 AVE EXAM RAW EQUIV RAW EQUIV GRADE
    95 100 75 85 50 100 82 10 82 90 10 20 55
    45 50 0 50 30 50 36 75 36 40 75 80
    50 100 50 35 0 0 37 75 37 40 75 80
    37.5 100 95 100 100 100 99 80 99 100 80 80
    37.5 100 95 100 50 100 89 75 89 90 75 80
    37.5 100 0 100 0 0 40 75 40 40 75 80
    0 50 0 0 0 0 10 0 10 20 0 20
    47.5 100 90 100 50 100 88 75 88 90 75 80
    32.5 100 75 100 100 100 95 25 95 100 25 40
    50 100 90 100 50 100 88 75 88 90 75 80
    37.5 100 95 100 100 100 99 100 99 100 100 100
    37.5 45 90 75 100 100 82 75 82 90 75 80
    42.5 100 90 100 50 100 88 100 88 90 100 100
    50 100 95 100 100 100 99 80 99 100 80 80
    50 100 50 95 50 100 79 100 79 80 100 100
    47.5 100 75 0 50 100 65 100 65 80 100 100
    47.5 50 95 100 100 100 89 30 89 90 30 40
    50 100 90 70 0 50 62 100 62 80 100 100
    50 100 75 95 50 100 84 75 84 90 75 80
    10 100 85 95 50 100 86 100 86 90 100 100
    37.5 45 95 100 50 100 78 70 78 80 70 80
    47.5 100 100 100 100 100 100 60 100 100 60 60
    50 50 95 100 100 100 89 50 89 90 50 60
    37.5 100 75 100 50 100 85 95 85 90 95 100
    12.5 100 90 100 50 100 88 85 88 90 85 90
    50 100 90 70 50 100 82 100 82 90 100 100
    47.5 100 85 100 50 100 87 50 87 90 50 60
    50 100 90 100 50 100 88 55 88 90 55 60
    22.5 40 90 100 50 100 76 100 76 80 100 100
    50 100 90 100 50 100 88 30 88 90 30 40

    You might also like