Must Know Excel functions that solve 80% of your work: How to use Excel as gradebook
https://blog.wps.com/content/images/2020/09/lesson-4.001-2.jpg
Suppose your class is devided into groups for a impromptu quiz competation for extra credit. And you as the TA needs to keep tracking of the scores. Like this? Or, this?
Wait! Before you actually do that, why not keep reading to find out the best solution with WPS college.
Calculation of the toal- Summation Let’s keep using in class quiz as an example 👉Step 1: Prepare the table in advance
Record the score during the competation.
Step 2: Using excel formula to quickly calculate the Total Select the total columns of first team Enter “=sum()” Select all 6 socres for team 1 Press ‘Return’ on keyboard
Then you will have the total score for the first team!
Double click and drag the plus arrow down the list to find total scores for all groups
Rank Function To be able to record ranking ASAP, the easist way is to quickly sort the data based on the ‘Total’ results. And it’s so easy! Just keep on reading👉Step 1: Select the table Find Data under the top menu bar Select the option ‘Sort’
Step 2: Select correct parameter on the opration interface For this example specifically, choose columnn P(The total column) Select option ‘Largest to smallest’
Step 3: Enter rankings Done!
Thank you for staying with WPS. Hope to see you in a bit!
Continue reading