Appletcollection Vertical Menu java applet, Copyright 2003 GD

Excel versions require Microsoft™ Excel (version 3.0 or higher). These templates do not perform score lookups. They complete the statistical analysis necessary for determining strengths and weaknesses and for actuarial analysis of the scores.

All Templates are protected to prevent users from over-writing the formulae in the cells.  Please do not ask for the password. 

All Templates are set to manual calculation.  Use your TAB key to move from cell to cell.  You can only enter data at appropriate cells.  Once all entries are made, use Function 9 (F9) on an IBM machine or Apple = (Apple and = keys simultaneously).  This will calculate the template.

Normal Curve Graphing

WJ III 

Differential Ability Scales (DAS) Differential Ability Scales (DAS) published by the Psychological Corporation

Differential Ability Scales (DAS) Excel version

Wechsler Intelligence Scale For Children - Third Edition (WISC-III) Full version

Wechsler Intelligence Scale For Children - Third Edition (WISC-III) Wechsler Intelligence Scale For Children - Third Edition (WISC-III) Brief version

Wechsler Adult Intelligence Scale - Third Edition (WAIS-III)

Kaufman Adult and Adolescent Intelligence Test (KAIT)

Cognitive Assessment System (CAS)  My thanks to Tim McCarthy for his help in creating this template.

Severe discrepancy     A template for determining severe discrepancy between scores.

WISC-III Groupings

Score to Z score converter Given the score, mean, and standard deviation of any test, this simple program converts the scores to z scores and then into standard scores. Example below:

Replace the numbers in the first three columns with your data.
Score	Mean	s.d.	z	z (rounded)	Wechsler Standard Score	Wechsler Scaled Score	SB: FE Area SAS	SB: FE Subtest SAS	T Score	NCE	Stanine
12	10.73	1.34	0.947761	0.95	114	13	115	58	59	70	7
5	10.73	1.34	-4.27612	-4.28	36	-3	32	16	7	-40	-3

Score to other score converter Do you have a score, know the mean sand standard deviation, but want it converted into a number of other common scores?  Example below:

	Input a score
Standard Score (m=100, sd=16)				Input one of the 6 possible scores and the program
Standard Score (m=100, sd=15)				will automatically convert the score to the others.
T Score (m=50, sd=10)
scaled score (m=10, sd=3)				To calculate a different type of score,
z	1			be sure to delete any other scores.
Percentile
	Score conversions
Standard Score (m=100, sd=16)	116
Standard Score (m=100, sd=15)	115
T Score (m=50, sd=10)	60
scaled score (m=10, sd=3)	13
z	1.00
Percentile	84

AGS Chronological Age Calculator. The Age Calculator computes chronological age by subtracting the child's birth date from the test date. Use the calculator on-line at http://www.agsnet.com/calc/ or download a free Windows or Macintosh version to run on your desktop. (Note: If you use the download version, you may also want to download WinZip from www.download.com)

Self-Esteem  Description of self esteem and a Form for evaluating the self esteem of a child.

Content on these pages is copyrighted  by Dumont/Willis © (2001) unless otherwise noted.