Note 1: The value entered must be numeric and dot only. Do not include commas (,). Note 2: Enter all scores you want to calculate, with a space between each score (e.g. 99.58 90 87.25) or a new line. Note 3: If you already have an MS Excel file (or another table file) that holds the scores. You can copy all the scores from your file and paste them into the input box above. EXAMPLE
Please enter scores first...
Step 2 Select a grade calculation option.
Step 3 Select a grade option.
Step 4 Specify additional information.
Please select a grade calculation option and/or select a grade option first!!
Full Score
SD Range
The more value, the more scores will be in the middle grade range.
Grade Range Width
The Highest Grade
score greater than/equal to
The Lowest Grade
score less than
Middle of Grade
The default value is 50.
Note: If the configuration of the grade range width, the highest/lowest grade scores unreasonable, the system will change automatically based on the full score.
*Recommend printing via Google Chrome.
*When the print window opens, you can save PDF files instead of printing them.
Note: If you already have an MS Excel file (or another table file) that holds the scores.
You can copy this formula
First, find the percentile of all scores in your MS Excel file (or another table file). By...
1) find out the score ranking (In ascending order) with RANK.EQ or RANK formulas, such as =RANK(A1, $A$1:$A$5, 1)
2) find the percentile by taking result 1) divided by the total number of students and then multiplied by 100, such as
=(B1 / COUNT($A$1:$A$5)) * 100
Done, copy this formula
(or modify the formula to suit your program) and paste it into your file to calculate the grade.
EXAMPLEEXAMPLE
