nav-left cat-right

Predict your Grades with Excel

Your marks going into your final exam can both motivate you to study harder or give you some well deserved peace of mind. Sometimes this can be difficult to work out, especially if you are not mathematically minded.

Thankfully this can be simplified using Microsoft Excel, and I will show you how.
First, gather all the assessment that you will have over the year and insert it in a table using the following format:
In this table the 2nd column is the percentage weight. For example, the assignment is worth 20% (or 0.2), the presentation is 30% and the final exam is 50%.

The third column shows what percentage you got in each piece of assessment – 90% in the 20% assignment.

In the fourth column, ‘Total Course Mark’ enter the following: =B1*C1, and =B2*C2. This uses excels calculator to calculate how many marks of the total course you have achieved. These can then be added together in the total mark section using =C1+C2+C3.


From this you can modify your value for ‘Your Grade’ of your final exam to see what you need to pass. In this case you only need 19% in the final exam to pass.

If you can create your excel spreadsheet at the start of the year and constantly modify it, you will always have a clear picture of where you are heading.

Share and Enjoy:
  • StumbleUpon
  • Reddit
  • Digg
  • Facebook
  • Google Bookmarks
  • RSS
  • Print

Related posts:

  1. Ultimate Pros & Cons Worksheet, a great tool to have.
  2. Student Tools: Gradefix, The easiest way to get good grades
  3. How to Balance your Time & Effort when under Great Pressure
  4. 4 Causes and Solutions for Wasting Time at Work
  5. How to Implement GTD for Students

4 Responses to “Predict your Grades with Excel”

  1. Miguel says:

    The directions after you get to the fourth column are either incorrect, or need to be clarified.

  2. Miguel says:

    Also, how do you add in extra credit?????

  3. paulette says:

    Now its easy to compute with the help of excel. I remeber the days when i use calculator and still get wrong computation.Thanks to the new technology for making computation mor simple.

  4. I used to do it as well. I used a different method though. It is really great you can check it cause it gives motivation or warns you that you should start working hard!