Documentation for Administrators

Cognitive Abilities Test (CogAT)

Updated on

The information provided in this document can be referenced to import the Cognitive Abilities Test (CogAT) scores.

Focus Version12.0.75 and laterSupported File FormatsFixed-width, Comma-delimitedSupported Test PartsMain Domains: Verbal, Quantitative, Non-verbal (V, Q, N)Partial Composites: VQ, VN, QNComplete Test Composites: VQNSupported Score TypesNumber Attempted (NA), Completion Criteria (CC), Raw Score (RS), Universal Scale Score (USS), Standard Age Score (SAS), Grade Percentile Rank (GPR), Age Percentile Rank (APR), Grade Stanine (GS), Age Stanine (AS).ProviderRiverside Insights
Click to copy
SELECT IMPORT SETTINGS
  1. Navigate to Imports in the Setup menu, then start the process by uploading your file.
  2. While in the File Format step, reference the Preview section to make your selections. When working with a fixed-width file format:
    • Click the Field Positions button.
    • In the template dropdown select the * Cognitive Abilities Test (CogAT) - Student Results File Converter - Effective Fall 2017 option.
    • Click Continue.
  3. If the uploaded data does not contain a header row, uncheck the box.
  4. Click Next.
  5. In the Select Tool step click the Import File card to enter the import settings:
    • Select the Test History import tool option
    • Select the desired import method
    • Select the appropriate CogAT test from the Standardized Test dropdown, or leave blank.
    • Check the Parse File box and then select one of the following options from the dropdown:

ALL STATES

    • In the Scores Layout dropdown will be automatically set to the appropriate option based on your previous selections, with "Test Part & Score Types are combined into one or more columns" as the default option.
    • Click Continue.
Selecting the Comprehensive file parser will allow you to review and map all available score combinations reported by the provider. It transforms the gradelevel to a two-character code and converts the administration date to a readable system format. It adds a column for school year, which is derived from the provided administration date.
Click to copy
MAP FIELDS AND VALIDATE

Once back in the Select Tool step:

  1. Click Next.
  2. In the Mapping Template step:
    • Choose an existing template, or
    • Manually map the available fields.
  3. Click the Validate button.
  4. Check the validation results and review errors, if any.
  5. To complete the process, click Import.
 Print Article