Why isn’t the Spelling Diagnostic Results Template calculating a Comparison Range for me?
If the Comparison Range is not automatically being calculated, it may be due to one of the following:
American date format
Your version of Excel is set to the American format for date notation (MM/DD/YYYY) instead of the Australian format (DD/MM/YYYY). Either adjust your settings or enter your date data (i.e. students’ birthdates and date of test) in the American format.
Age group out of range
You’re trying to calculate a Comparison Range for an age group that is outside the ranges of our sample sets. For the Lower Years test you can obtain a Comparison Range for students aged from 5yrs and 6mths to 9yrs and 5mths. For the Upper Years test you can obtain a Comparison Range for students aged from 8yrs and 6mths to 12yrs and 5mths.
If neither of these reasons apply to you, please contact us.