The information provided in this document can be referenced to import the Cognitive Abilities Test (CogAT) scores.
Focus Version
12.0.75 and later
Supported File Formats
Fixed-width, Comma-delimited
Supported Test Parts
Main Domains: Verbal, Quantitative, Non-verbal (V, Q, N)
Partial Composites: VQ, VN, QN
Complete Test Composites: VQN
Supported Score Types
Number 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).
Provider
Riverside Insights
Select Import Settings
- Navigate to Imports in the Setup menu, then start the process by uploading your file.
- 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 pull-down, select the Cognitive Abilities Test (CogAT) - Student Results File Converter - Effective Fall 2017 option.
- Click Continue.
- If the uploaded data does not contain a header row, uncheck the box.
- Click Next.
- In the Select Tool step click the Import File card to enter the import settings:
- Select the Test History from the Import Tool pull-down.
- Select the desired Import Method.
- Select the appropriate CogAT test from the Standardized Test pull-down, or leave blank.
- Select the Parse File check box and then select one of the following options from the pull-down:
- All States: Cognitive Abilities Test (CogAT) - Comprehensive
- The Scores Layout pull-down 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.
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.
Map Fields and Validate
Once back in the Select Tool step:
- Click Next.
- In the Mapping Template step:
- Choose an existing template, or
- Manually map the available fields.
- Click the Validate button.
- Check the validation results and review errors, if any.
- To complete the process, click Import.