Previously we had discussed on how to download a section-wise test report from your admin dashboard
That report was in the below format
But, what if you wanted a report that shows average score of your students across all sections like the one below?
You can do this using a pivot table function. If you don’t know how to, let us see how we can do it.
First, download the section-wise reports from the admin dashboard. Check the post on how to download the section-wise report to know how to do this.
Combine the data from your section-wise reports into a single excel sheet. (Let us name it as master report)
Press Control+a to select the entire sheet. Now, click Insert option and select Pivot Table
Select the table within the pivot table
Inside the pivot table, drag and drop the following into the quadrants on the right side
- Name - Drag it into ROWS section
- Section Name - Drag it into Columns section
- Score (Or any value that you want to see) - Drag it into the Values section
To view the average scores, Go to the values section, select the pointer in the Sum of Scores.
Change the sum to average
Now you have a report that has the values and sections you are looking for
Change the Column Labels title to something like: Avg Score by Students per Section.
To change the look and feel of your table, go to Home. Select → Format as table option and choose a suitable format.
Here is how my final table looks after formatting