T
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
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