ICT Task - Score Analysis using Numbers

by Mr johari

This is how the final table should look like.
It should contain the following information:

1. Table of values (score, Percentage, Grade)
2. Analysis (that automatically counts the number of students getting the various grades from A1 to F9) (the table in yellow highlights the category of score from A1 - F9)
3. mean subject grade (MSG), mean marks from column 2, Total number of candidates, Highest Score and Lowest Score - tabulated from column 2)
4. Visual representation in the form of a bar chart.

Your task: 

complete the table and the following students please post a link to your table.

index # 5, #10, #15, #20.