Excel Math for The Grading and Whatnot

An-D

So, I'm banging out final grades for my students, and I can't remember anything about my excel math.

Basically, I have three columns for each student: Attendance, Assignments, Final Exam.

Attendance is worth 50%
Assignments is worth 30%
Final Exam is worth 20%


Solve for column 4.


Its been ages since I've done this, and I'm bad at math to begin with (good thing I'm teaching English in China).

Any help?

Casually Hardcore

Lets say they got 50% in attendance, 80% in assignments, and 70% on their final exam.

Then you can have something like

.5(50)
.8(30)
.7(20)

add it all up and it'll give you their overall percentage. (63% in this example)

So basically you fourth column can be something ike

= (a1(50) + a2(30) + a3(20))

assuming your three columns are in percentages.

Then you can click and drag and it should auto fill.

schuss

or just do
=(grade1*.5)+(grade2*.3)+(grade3*.2)

Sir Headless VII

wait what do you wan tin the 4th column? do you just want a sum of the other columns? are the other columns not percentage values and you want them that way? if you just need a sum put in =sum(a1:c1) where a1 to c1 are the columns. If they are just marks out of some total you would want something like =(a1/max_for_a)*.5+(b1/max_for_b)*.3+(c1/max_for_c)*.2 which will give you their final % mark.

An-D

Boom!


Thank you, good sir! Thanks you, all but one of my students passed and I'm not blaming that on your timely grading rescue.

It was his fault.

And only coming to class twice in a class where attendance was 50% of the grade.

Chinese college students are kind of dumb.

An-D

Wait, I did this wrong.

All the grades are in whole numbers. So if a kid didn't miss class, his attendance score is 100.

In the 4th column, I want their final grade.

Casually Hardcore

Wait, it wouldn't matter, because then you would just be multiplying 50 by 1 and they'll get the full 50% of the attendance worth.

Ruckus

An-D wrote: »

Wait, I did this wrong.

All the grades are in whole numbers. So if a kid didn't miss class, his attendance score is 100.

In the 4th column, I want their final grade.

=SUM(A1*0.5,B1*0.3,C1*0.2)

Satsumomo

Yeah you need to assign a value to how many attendances equal how many points. Or that's what I believe you''re missing.

Ruckus

Satsumomo wrote: »

Yeah you need to assign a value to how many attendances equal how many points. Or that's what I believe you''re missing.

=attendances/classes*100

You'd need a new column to track the number of classes each student attended, and then a spot somewhere else to fill your total number of classes offered.

On my test sheet it's

=A2/$J$3*100 //Where A1 is the location of that student's number of attended classes, J3 is the location of the total classes (with the $ before the J and 3 making the location fixed rather than relative to the formula location, so even if you drag/fill the formula it will always reference J3)

An-D

Ruckus wrote: »

An-D wrote: »

Wait, I did this wrong.

All the grades are in whole numbers. So if a kid didn't miss class, his attendance score is 100.

In the 4th column, I want their final grade.

=SUM(A1*0.5,B1*0.3,C1*0.2)

This worked. Wow, I'm dumb. Thanks a lot!

An-D

Ruckus wrote: »

Satsumomo wrote: »

Yeah you need to assign a value to how many attendances equal how many points. Or that's what I believe you''re missing.

=attendances/classes*100

You'd need a new column to track the number of classes each student attended, and then a spot somewhere else to fill your total number of classes offered.

On my test sheet it's

=A2/$J$3*100 //Where A1 is the location of that student's number of attended classes, J3 is the location of the total classes (with the $ before the J and 3 making the location fixed rather than relative to the formula location, so even if you drag/fill the formula it will always reference J3)

I already did the math for all the attendances...manually, because I'm old fashioned like that. Also, technology frightens me. So, the formula Ruckus gave me worked fine.