I got a TABLE in Excel format like:
This is a STEN TABLE containing
Each Factor is like a separate test.
Each Factor i.e. Factor A has a
[Raw Score] and a
Supposing Factor A, had a question like:
Why do humans have Eyes?
The answer options could be like:
a) To Watch movies = [Raw Score] -> 10,
b) To Read Novels = [Raw Score] -> 5,
c) To close them while sleeping = [Raw Score] ->0
So if they Chose a) then, the system will go to the
STEN TABLE to get the
STEN Equivalent under
Factor A, in this case, the sten equivalent will be
(See Factor A->Row score 10-> Sten column)
What could be the most practical way to have this STEN TABLE with Factors and their Raw Scores and Stens created?
**STEN TABLE** | | **FACTORS (A,B,C,D...)** / \ / \ / \ / \ / \ **[Raw Score] [Sten]**
To See a larger image, please click here: http://ctrlv.in/459785
Please note that, the
stens are not equal for all Factors, though the
Raw Scores are the same. i.e. in Factor A,
[Raw Score]->3 = [sten]->2 but in Factor C
[Raw Score]->3 = [sten]->1 and in Factor F
[Raw Score]->1 [sten]->2 whereas in Factor E
[Raw Score]->1 = [sten]->1.
Any Suggestion is highly honored.