Ability And Achievement Tool

Compare potential and performance with the Ability x Achievement Tool.

The Ability x Achievement Tool enables educators to combine the power of CogAT insights with any set of achievement data. Use this tool to answer questions like:

- What is the general trend in my students’ CogAT and achievement performance? Are there sub-populations of students falling above or below the general trend line?
- Which students demonstrate high potential in their cognitive abilities but may not be performing at or above their potential in reading and/or math?
- What can we estimate about students’ future achievement performance using their CogAT data?

Ready to level-up with CogAT insights?

Learn how to use the tool with our video and written instructions, plus practice with a sample data set!

The Ability x Achievement Tool is compatible with Excel 365 and Excel 2021 or newer.

Extend the impact of this strategy by implementing the Ability x Achievement Analysis Protocol!

Learn how one district increased equity through this approach in our case study, Using a Strengths-Based Approach to Understanding Students’ Aptitude.

Step 1

Watch the Video Demos

Video 1: Overview

~2 minute watch

Video 2: Download the Files

~3 minute watch

Video 3: Load Data into the Tool

~8 minute watch

Video 4: Using the Trend Line

~7 minute watch

Video 5: Using the Actual vs. Expected Score

~5 minute watch

Video 6: Viewing Score Distributions

~8 minute watch

Step 2

View the Visual Guides

Guide 1: Overview

Guide 2: CogAT Data Export

Guide 3: Load Data into the Tool

Guide 4: Use the Tool

Step 3

Download the Tool & Practice with Sample Data Sets

Tool 1: Achievement Template

Tool 2: Ability x Achievement

Data Set 1: CogAT Sample

Data Set 2: Achievement Sample