mwilburn01
New Member
- Joined
- Mar 27, 2014
- Messages
- 1
Hello all,
I have a Gradebook where I enter the number of points a student earns per question on a test. The students names are in the first column and then their points follow. I have other columns such as total points, percentage, letter grade that follow but they are not part of my issue. I am simply looking for a way to list which problems they did not earn full credit on. First two Rows (after their name) list the question # and possible points. I have figured something out that kind of works but it is extremely long and I am sure there is a better way to do it.
<tbody>
</tbody>
Any help is much appreciated.
I have a Gradebook where I enter the number of points a student earns per question on a test. The students names are in the first column and then their points follow. I have other columns such as total points, percentage, letter grade that follow but they are not part of my issue. I am simply looking for a way to list which problems they did not earn full credit on. First two Rows (after their name) list the question # and possible points. I have figured something out that kind of works but it is extremely long and I am sure there is a better way to do it.
Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | WHAT I AM LOOKING FOR |
(Merged with above) | 2 | 2 | 2 | 2 | 3 | 3 | 4 | WOULD LOOK LIKE THIS |
Sue | 2 | 0 | 2 | 1 | 3 | 2 | 4 | 2, 4, 6 |
Jimmy | 2 | 2 | 2 | 2 | 2 | 3 | 4 | 5 |
Sally | 1 | 0 | 0 | 0 | 3 | 0 | 0 | 1, 2, 3, 4, 6 |
<tbody>
</tbody>
Any help is much appreciated.