excel equations for teachers
 

I'm trying to put together a spreadsheet to do my grading and I can't figure
out how to do a percentage column for each student. For example, for each
student I can get a sum for the rows like - A3:AA3, but I can't figure out
how to get the percentage based off the total points possible. HELP!

excel equations for teachers
 

Try adding a student that has a perfect score and base the % formula off of
that student's score - Name the student with a bunch of A's in the name so it
sorts to the top.

Assume row A3 is the perfect student - the percentage formula would be Real
Student Total Cell/$a$3 (total cell of start student)


"Marie" wrote:

I'm trying to put together a spreadsheet to do my grading and I can't figure
out how to do a percentage column for each student. For example, for each
student I can get a sum for the rows like - A3:AA3, but I can't figure out
how to get the percentage based off the total points possible. HELP!

excel equations for teachers
 

"Marie" wrote in message
...
I'm trying to put together a spreadsheet to do my grading and I can't
figure
out how to do a percentage column for each student. For example, for each
student I can get a sum for the rows like - A3:AA3, but I can't figure out
how to get the percentage based off the total points possible. HELP!

Below is an example.

Test1 Test2 ......................Test 10
Total Percentage
Test Marks 25 15 20 265
(say) <= Sum Total for all tests
Tim 18 12 ......................... 17
212 (say) 212/265%
Jane 20 7 .......................... 15
198 (say) 198/265z%

excel equations for teachers
 

"Tom" wrote in message
...
"Marie" wrote in message
...
I'm trying to put together a spreadsheet to do my grading and I can't
figure
out how to do a percentage column for each student. For example, for each
student I can get a sum for the rows like - A3:AA3, but I can't figure
out
how to get the percentage based off the total points possible. HELP!

Sorry. My formatting got mangled up by internet exp.
Hope the next attempt is better, else I give up.

Below is an example.

Test1 Test2 ...Test10 Total Percentage
Test Marks 25 15 ..... 20 265(say)
Tim 18 12 .... 17 212(say) 212/265%
Jane 20 7 ..... 15 198 (say) 198/265z%

Where 265 is total for all tests

excel equations for teachers
 

Marie,
If I understand the problem:
I would put student's Names in column A3:AA3, Insert a ROW at A3 Possible
points. Count over the number of columns for grades(ie say 26 columns for
assignments and tests). In the next column use it for grades-to-date.
First Student Name in A4, so grade is "=SUM((B4:X4)/SUM(A4:X4))" where X is
equal to the column of the latest grade.Total points earned divided by total
points possible.

"Tom" wrote:

"Tom" wrote in message
...
"Marie" wrote in message
...
I'm trying to put together a spreadsheet to do my grading and I can't
figure
out how to do a percentage column for each student. For example, for each
student I can get a sum for the rows like - A3:AA3, but I can't figure
out
how to get the percentage based off the total points possible. HELP!

Sorry. My formatting got mangled up by internet exp.
Hope the next attempt is better, else I give up.

Below is an example.

Test1 Test2 ...Test10 Total Percentage
Test Marks 25 15 ..... 20 265(say)
Tim 18 12 .... 17 212(say) 212/265%
Jane 20 7 ..... 15 198 (say) 198/265z%

Where 265 is total for all tests