Hello,
Shown below is a simple table showing a list of students and their grades for tests they periodically take. I send the results to them so that they can see how everyone is performing without knowing each others scores. I would like to automatically anonymise the columns each time I send the results so that the students won't be in the same position as last time. I need some advice on how to approach this. Thank you.
Andy
<colgroup><col><col span="9"></colgroup><tbody>
</tbody>
Desired Result to be able to change the column order each time I send the report out
Shown below is a simple table showing a list of students and their grades for tests they periodically take. I send the results to them so that they can see how everyone is performing without knowing each others scores. I would like to automatically anonymise the columns each time I send the results so that the students won't be in the same position as last time. I need some advice on how to approach this. Thank you.
Andy
Share the table with out the first row with the group initially | |||||||||
Actual Name | Andy | Brian | Jane | Mike | Sue | Tom | |||
Identifier # | 1 | 2 | 3 | 4 | 5 | 6 | |||
Test 1 | 85 | 98 | 100 | 73 | 88 | 95 | |||
Test 2 | 90 | 91 | 100 | 84 | 85 | 89 | |||
Test 3 | 90 | 100 | 100 | 87 | 92 | 87 | |||
Average | 88.3 | 96.3 | 100.0 | 81.3 | 88.3 | 90.3 | |||
Share the table except for the first row with the group subsequently with column order changed | |||||||||
Actual Name | Brian | Jane | Andy | Sue | Mike | Tom | |||
Identifier # | 1 | 2 | 3 | 4 | 5 | 6 | |||
Test 1 | 98 | 100 | 85 | 88 | 73 | 95 | |||
Test 2 | 91 | 100 | 90 | 85 | 84 | 89 | |||
Test 3 | 100 | 100 | 90 | 92 | 87 | 87 | |||
Average | 96.3 | 100.0 | 88.3 | 88.3 | 81.3 | 90.3 | |||
<colgroup><col><col span="9"></colgroup><tbody>
</tbody>
Desired Result to be able to change the column order each time I send the report out