M
Marie1uk
Hi there,
I am a teacher and need to analyse my results for review and targe
setting purposes.
I need the spreadsheet to generate results for the following:
Number of pupils scoring 5 grades (or higher) A* - C
% of pupils scoring 5 grades (or higher) A* - C
Number of pupils scoring 5 grades (or higher) A* - G
% of pupils scoring 5 grades (or higher) A* - G
Number of pupils scoring 1 (or higher) grade A*-G
% of pupils scoring 1 grade (or higher) grade A* - G
Number & % of pupils who were absent
In column A will be the pupil's first name, column B will be thei
surname, C their gender and in columns D - O will be where I will inpu
their grades (not all cells D - O will necessarily be used). Using thi
format what is the best formula for obtaining the necessary results?
Many thanks for your consideration,
Marie
I am a teacher and need to analyse my results for review and targe
setting purposes.
I need the spreadsheet to generate results for the following:
Number of pupils scoring 5 grades (or higher) A* - C
% of pupils scoring 5 grades (or higher) A* - C
Number of pupils scoring 5 grades (or higher) A* - G
% of pupils scoring 5 grades (or higher) A* - G
Number of pupils scoring 1 (or higher) grade A*-G
% of pupils scoring 1 grade (or higher) grade A* - G
Number & % of pupils who were absent
In column A will be the pupil's first name, column B will be thei
surname, C their gender and in columns D - O will be where I will inpu
their grades (not all cells D - O will necessarily be used). Using thi
format what is the best formula for obtaining the necessary results?
Many thanks for your consideration,
Marie