excel gradebook

[Guest]

I want to be able to excuse an assignment in an excel grade book. I tried the
one suggestion that was posted and it didn't work. I want X to stand for
don't include. Anyway know how to do it?

Ms. G

 

[Guest]

Many Excel functions (like AVERAGE()) ignore blanks. Try blank instead of X.

 

[vandenberg p]

Hello:

I am not sure how you are doing the grading. But lets say
that in row 1 columns B through E you have the
possible numeric scores on the assignments so any student
that gets these scores would have 100%.

Such as:
B1: 100
C1: 30
D1: 50
E1: 100

Total possible point in F1: =SUM(B1:E1) (280 in this case)

Now in you have a student's scores starting in row 2

A2: Student name
B2: 89
C2: 29
D2: x
E2: 0
Total points for student in F2:=SUM(B2:E2) (118 in this case)
The percentage for this student in G2: =F2/($F$1-SUMIF(B2:E2,"=x",$B$1:$E$1))

What this last formula says is to compute the average
by taking total achieved by the student
and dividing it by the total possible - the sum of the
excused scores (50 points in this case). You should
be able to copy the F2 and G2 down the entire grade sheet.
You can format column G as percentage.


Pieter Vandenberg


: I want to be able to excuse an assignment in an excel grade book. I tried the
: one suggestion that was posted and it didn't work. I want X to stand for
: don't include. Anyway know how to do it?

: Ms. G