Must Know Excel functions that solve 80% of your work: How to use Excel as gradebook

Must Know Excel functions that solve 80% of your work: How to use Excel as gradebook

September 17, 2020

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.
aaa
Like this?
aaa
Or, this?

Wait! Before you actually do that, why not keep reading to find out the best solution with WPS college.
aaa

4-2

Calculation of the toal- Summation

Let's keep using in class quiz as an example 👉

  • Step 1: Prepare the table in advance

5-2

Record the score during the competation.
6-1

  • Step 2: Using excel formula to quickly calculate the Total
  1. Select the total columns of first team
  2. Enter "=sum()"
  3. Select all 6 socres for team 1
  4. Press 'Return' on keyboard

7-1

Then you will have the total score for the first team!

8-1

  • Double click and drag the plus arrow down the list to find total scores for all groups

9-2
4-3

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
  1. Find Data under the top menu bar
  2. Select the option 'Sort'

10-1

  • Step 2: Select correct parameter on the opration interface
  1. For this example specifically, choose columnn P(The total column)
  2. Select option 'Largest to smallest'

11

  • Step 3: Enter rankings
Done!

12

4-4
17-1
Thank you for staying with WPS. Hope to see you in a bit!

aaa

About Author

International operations department for WPS Office.