The information provided in this document can be referenced to import the Preliminary SAT 8/9 (PSAT 8/9), Preliminary SAT 10 (PSAT 10), and Preliminary/National Merit Scholarship Qualifying Test (PSAT/NMSQT) Student results.
Focus Version
12.0.82 and later
Supported File Formats
Fixed-width, Comma-delimited
Provider
College Board
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 option that best aligns with the previously uploaded file:
- Preliminary SAT 8/9 (PSAT 8/9) - Student Results File Converter - Effective Fall 2024
- Preliminary SAT 10 (PSAT 10) and Preliminary SAT/National Merit Scholarship Qualifying Test (PSAT/NMSQT) - Student Results File Converter - Effective Fall 2024
- 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 import tool option.
- Select the desired Import Method.
- Select the appropriate ACT 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:
-
Florida
- Preliminary SAT 8/9 (PSA) - Latest PSAT Only - Effective Fall 2024
- Preliminary SAT 10 (PSAT 10) and Preliminary/National Merit Scholarship Qualifying Test (PSAT/NMSQT) (PS1) - Latest PSAT Only - Effective Fall 2024
-
All States
- Preliminary SAT 8/9 (PSAT 8/9) (Comprehensive) - Effective Fall 2024
- Preliminary SAT 10 (PSAT 10) and Preliminary/National Merit Scholarship Qualifying Test (PSAT/NMSQT) (Comprehensive) - Effective Fall 2024
-
Florida
- In the Scores Layout pull-down:
- When the selected parser is not Preliminary SAT 8/9 (PSAT 8/9) (Comprehensive) - Effective Fall 2024 or Preliminary SAT 10 (PSAT 10) and Preliminary/National Merit Scholarship Qualifying Test (PSAT/NMSQT) (Comprehensive) - Effective Fall 2024, change the option to Standard.
- Click Continue.
Selecting the Comprehensive file parser(s) will allow you to review and map all available score combinations reported by the provider. This option is most suitable when needing to include scores that are not listed in the state requirements.
Run Student Match
Once back in the Select Tool step:
- Click Student Match:
- Map the required fields: First Name, Last Name, Birth Date and Birth Date format. Mapping the School is optional.
- Click Run.
- When applicable, manually search and assign Student IDs to all remaining unmatched student records and click Continue.
The default ACT file parsers created by Focus outputs the Birth Date in the original YYYY-MM-DD format, as reported by the provider.
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.
If the Standard score layout was chosen, all the fields will be mapped automatically.