I rarely give a test out of a 100 points. This Percentage and Letter Grade Calculator helps me to find the percentage of a test so I'll provide it to my students to help them sense where they stand.
This file provides you with a quick way to calculate the Percentage and Letter Grade associated with any given assessment. All what you need to enter are the following:
• Exam Total Points
• Test #
The Grade Calculator file will calculate:
• The percentage associated with any grade (integer value grade)
• The letter grade associated with that percentage
This file uses the standard conventional letter grade system which associates:
• A 90% and up
• B 80% to below 90%
• C 70% to below 80%
• D 60% to below 70%
• F below 60%
(If you wish to change these percentages, please email me at: firstname.lastname@example.org and I'll be more than happy to adjust the file and email it to you)
In the file itself, there are 3 pages.
• Page 1 (the most used) has 120 data entry
• Page 2 has 240 data entry
• Page 3 has 480 possible entry (could be used to calculate projects of 1000 points)
Save the file to your flash, email, or re-download whenever you wish.
1. Select the appropriate Grade Calculator Sheet from the bottom of the file
2. Only type in the yellow boxes:
- Type in your Subject in the yellow subject box
- Type in the test number in the yellow test box
- Type in the date in the yellow date box
- TYPE IN THE TEST TOTAL AVAILABLE POINTS IN THE YELLOW TEST POINTS
3. Relax, set, and watch as the Grade Calculator gives the letter and percentage associated with every student's test grade
Simply go to File and choose print
If you type in anything in the wrong place, just hit the "UNDO" button on the top. Worse comes to worse and you mess up the formulas of this file, just go back to "NEVER GIVE UP ON MATH" and re-download it again for FREE.
I have attached a video showing how to operate the file.I really hope that you find this free Grade Calculator Excel File beneficial. ☺I Would love to hear your feedback☺. Please don't forget to come back and rate this product when you have a chance. You will also earn TPT credits. Enjoy and I ☺thank you☺ for visiting my ☺Never Give Up On Math☺ store!!!