Need Help Adjusting Weighted Grade Calculator for Multiple Assessments
Hi everyone,
I'm struggling with setting up a grade calculator to accurately reflect the weighted impact of different assessments in my course. Currently, my setup doesn't seem to correctly adjust the overall grade based on the individual weight of quizzes, assignments, and exams.
For instance, I have a system where quizzes are supposed to count for 25%, assignments for 50%, and exams for 25% of the final grade. However, when I input the scores, the final grade doesn't seem to align with these percentages.
Does anyone have experience with or a template for a grade calculator that can handle multiple weighted categories effectively? Any advice or guidance would be greatly appreciated!
Thanks in advance!
I'm struggling with setting up a grade calculator to accurately reflect the weighted impact of different assessments in my course. Currently, my setup doesn't seem to correctly adjust the overall grade based on the individual weight of quizzes, assignments, and exams.
For instance, I have a system where quizzes are supposed to count for 25%, assignments for 50%, and exams for 25% of the final grade. However, when I input the scores, the final grade doesn't seem to align with these percentages.
Does anyone have experience with or a template for a grade calculator that can handle multiple weighted categories effectively? Any advice or guidance would be greatly appreciated!
Thanks in advance!
(edited 1 year ago)
Reply 1
It should take about 2 minutes to set this up on Excel / Google Sheets.
Where is the discrepancy? Put in some made up data where it is obvious what the final output should be - that should help you pinpoint it.
Where is the discrepancy? Put in some made up data where it is obvious what the final output should be - that should help you pinpoint it.
Reply 2
Hi,
I used a online Grade calculator and was able to select the weight for each assignment, module and year.
I used this one : https://www.thecalculatorsite.com/education/uni-grade-calculator.php
After using it I would pop the results on an excel spreadsheet so I could keep track of everything. I found that it was pretty much 100% accurate across my entire undergraduate degree and was correct in my overall degree classification, when I imputed all my results.
I hope this helps and good luck!
Suzan - Student Ambassador
I used a online Grade calculator and was able to select the weight for each assignment, module and year.
I used this one : https://www.thecalculatorsite.com/education/uni-grade-calculator.php
After using it I would pop the results on an excel spreadsheet so I could keep track of everything. I found that it was pretty much 100% accurate across my entire undergraduate degree and was correct in my overall degree classification, when I imputed all my results.
I hope this helps and good luck!
Suzan - Student Ambassador
Quick Reply
Related discussions
- help pls-urgent maths question!
- Does King's 1st year count?
- Degree Classification
- Aberystwyth University Cascade Calculator
- gcse maths specification edxcel
- BCU degree classification help
- Oxford Law Weightings
- 2:2 to 2:1
- Classification
- LLB Final grade?
- 69.61% in Masters Cognitive Neuroscience
- GCSE
- How do I work out what I need in my final year?
- Failed 3rd attempt by 0.01% of a mark
- Appropriate weight for 17 year old male
- Best way to lose weight fast
- Overall degree classification
- Final degree classification!!
- 80% in final year
- Maintenance loan
Latest
Trending
Last reply 2 days ago
Commuter Student, No friends & Burnt Out - Feeling Stuck and Alone at UniLast reply 1 week ago
I might be loosing my honours degree over a 10 minute presentationLast reply 3 weeks ago
1st Years: what's been the biggest surprise about university life so far?Last reply 3 weeks ago
Does anyone else feel they're constantly making the wrong decision/FOMO?Last reply 3 weeks ago
Can i use AI NOT to write but to assist with essay writing? Reasons are....
