Problems Displaying Data

[Trickster]

I think my main problem is I know so little about excel I don't even know
the right questions to ask. But here goes:

I have a grade sheet for 4 classes I teach, on 4 different sheets. The
first column in each sheet contains the student name, each column after
contains that student's scores on various essays/quizzes, etc The column
headers contain: 1st row, the "week"; 2nd row, the date; 3rd row, the
assignment name; 4th row the total points that assignment is worth. under
that in each column begins the scores for each student.

| Week 1 | Week 2
| ......
| Date Date Date | Date Date Date
| .....
| Assmnt Assmnt Assmnt | Assmnt ....
| Points Points Points | Points ....
Total Points possible
Student 1 | Points Points Points | Points ....
students Totals Final grade etc
Student 2 | Points Points Points | Points ....


What I WANT to do is generate a report (is that the term I want? ... or do I
want to filter?) so that I end up with a table/report that looks something
like this:

Students name

Assignment 1 (total points) Student's points
Assignment 2 (total points) Student's points
Assignment 3 (total points) Student's points
.........
total total percent of
total points grade

I already have it calculating midterm grades, final grades, assigning
appropriate letter grades and flagging 'F's and 'D's in red and other
helpful things... I just can't figure out how to generate a %&#* report for
each individual student.


Many thanks for any help anyone can give

Ed T

 

[Guest]

Have you tried to the info in the file into a pivot table?

 

[Trickster]

I tried that. I get the error: "The Pivot Table field name is not valid. ...
you must use data that is organized as a list with labeled columns .."
Since I have labeled columns, I am not sure what I am doing wrong there.
I've read the help on 'lists' and I suspect I don't have the table set up
right to do a pivot table, but heck if I can figure out from help whats
wrong about it, or how to fix it. It occured to me this morning that hiding
the top two rows (the week, which is combined cells covering three or 4
days) and the date (which I really don't need for my report/table) might
leave the "assignment" row as a valid column label .... apparently I was
wrong. LOL.

Any suggestions?

 

[Dave Peterson]

You need one row of headers in your table. Each of those header cells cannot be
empty.

Make sure you don't have any empty cells in that header row.