Standardized Test Score Import Types

Overview

Schools are able to import Standardized Test Scores for their students through the Veracross Data Importer. To access the Data Importer, please insert your school name into the following URL:

https://import.veracross.com/school_name/uploads

On the Data Import homepage, click on the “New Data Import” button and then select the type of data (test type) that you would like to import from the drop down menu.

To add them, run the “Enable/Disable Import Type” Action menu item on a standardized test detail screen. 

Once a selection is made, the CSV Template for the test type you selected will be available. You can then view the list of required columns and download the CSV template.

Note: To ensure the importer will upload the test score data successfully, please use the Veracross template instead of constructing your own.

Changing the Template

Standardized Test Types (ACT, SAT (basic), PSAT, SSAT, etc.)

To review your school’s test type list, click on the Standardized Test Type link that is located under the Other section of the Configuration column on the System Homepage in Axiom.

If you wish to modify the test types that are currently displaying on the Importer, please contact your account manager so that the test type list can be customized to meet the needs of your school. Please note: The Enabled flag for the Standardized Test Type will also need to be checked off in order to enable the test type on the Importer. 

When the test types have been added to the Importer, repeat the steps above within the Importer and download the CSV template for the new test type.

Adding Test Types

If there is a necessary test type that does not appear in the list within the system, you can add additional types by hovering over the  button on the System homepage and selecting “Standardized Test Types.” To enable this new standardized test type in the importer tool:

  • Navigate to the detail screen for your new standardized test type
  • Click the Action menu
  • Run the "Enable/Disable Import Type" procedure

When the necessary test types have been added to the Importer, repeat the steps above within the Importer and download the CSV template for the new test type.

Standardized Test Score Types (ACT English, ERB Math, SAT Writing, etc.)

The test type on the Importer will display score columns based upon the configuration of the Standardized Test Score Types within Veracross. To review your school’s test score type list, click on the Standardized Test Score Type link that is located under the Other section within the Configuration column on the System Homepage in Axiom.

Configuration for Standardized Test Score Types

Each test score type should be tied to a test type within the system using the Test Type column on the Standardized Test Score Type query.

Additionally, the test score type should be set to Enabled. This tells the Importer to include this test score as a column within the test type for the test type that was selected.

If there is a necessary test score column that does not appear within the CSV Template, please ensure the Enabled flag is checked off on the list of test score types.

Adding Test Score Types

You can add additional test score types as needed by hovering over the  button on the System homepage and selecting “Standardized Test Score Types.” The Enabled flag will be checked by default.

Once you have added the necessary test score types, repeat the steps above within the importer and download the CSV template again. The CSV template should then include the additional column (test score type).

Uploading the Template

When you are ready to upload and import the test data, you can click “Browse” under the Select Your File heading on the importer to access and select the data file you would like to upload.

Advanced Options

Before you import your CSV template, you can indicate how you would like duplicate rows to be handled via the Advanced Options drop down. We define duplicates as two rows that contain the same student name, test date and exact test scores.

The following options are available:

  • Allow duplicates to be inserted – All duplicate information will be imported into Veracross. These duplicates may then be managed manually within Axiom.
  • Automatically eliminate duplicates – If the information is the same for 2 rows within the template, the importer will remove one of the rows prior to importing the data.
  • Fail on duplicates – If there is a duplicate row detected, the importer will throw an error message and will not import the data.

Required Columns and Fields

It is important to check that the template is in the correct format, with the proper column titles at the top of each column, with required fields filled in. Each type of test has different columns that are necessary for the process of importing to function correctly. Each column name should have no spaces, with words being separated by underscores. Listed below are the default settings for the five standard tests enabled to appear in the Importer drop-down menu.
Note: The only fields that are required to be populated for each test are the person_fk field and the test_date field. Despite this, it is strongly recommended that the various fields for test scores are populated, as well.

TOEFL

person_fkRequired. Numeric field. This is the Person ID number.
test_dateRequired. Test date. Must be in the MM/DD/YYYY format.
test_yearRequired. Numeric field. The year in which the test took place.
test_administered_byText field. Name of the person who administered the test.
grade_levelRequired. Numeric field. The grade level the student who took the test was in at the time the test was administered.
notesText field. Will populate the Notes section of the Test Score record.
toefl_listeningNumeric field. TOEFL score for the Listening section.
toefl_readingNumeric field. TOEFL score for the Reading section.
toefl_speakingNumeric field. TOEFL score for the Speaking section.
toefl_writingNumeric field. TOEFL score for the Writing section.
toefl_writingNumeric field. The total TOEFL score.
toefl_structure_(old)Numeric field. TOEFL score for the Structure section of the test. Note that this section is no longer used in the current TOEFL test.
toefl_total_(old)Numeric field. TOEFL score of the Structure section.
toefl_pbt_test_of_written_english_Numeric field. TOEFL score if taking the Paper-based Test (PBT) instead of the standard Internet-based Test (iBT).

SAT (basic)

person_fkRequired. Numeric field. This is the Person ID number.
test_dateRequired. Test date. Must be in the MM/DD/YYYY format.
test_yearRequired. Numeric field. The year in which the test took place.
test_administered_byText field. The name of the person who administered the test.
grade_levelRequired. Numeric field. The grade level the student who took the test was in at the time the test was administered.
notesText field. Will populate the Notes section of the Test Score record.
sat_mathNumeric field. SAT score for the Math section of the test.
sat_totalNumeric field. The total SAT score.
sat_verbal/readingNumeric field. SAT score for the Verbal/Reading section of the test.
sat_writingNumeric field. SAT score for the Writing section of the test.
sat_writing_essayNumeric field. SAT score for the essay portion of the Writing section of the test.
sat_writing_multiple_choiceNumeric field. SAT score for the multiple choice portion of the Writing section of the test.

PSAT

person_fkRequired. Numeric field. This is the Person ID number.
test_dateRequired. Test date. Must be in the MM/DD/YYYY format.
test_yearRequired. Numeric field. This is the year in which the test took place.
test_administered_byText field. The name of the person who administered the test.
grade_levelRequired. Numeric field. The grade level the student who took the test was in at the time the test was administered.
notesText field. Will populate the Notes section of the Test Score record.
psat_verbal/readingNumeric field. PSAT score for the Verbal/Reading section of the test.
psat_mathNumeric field. PSAT score for the Math section of the test.
psat_writingNumeric field. PSAT score for the Writing section of the test.
psat_writing_multiple_choiceNumeric field. PSAT score for the multiple choice portion of the Writing section of the test.
psat_writing_essayNumeric field. PSAT score for the essay potion of the Writing section of the test.
psat_totalNumeric field. The total PSAT score.

ACT

person_fkRequired. Numeric field. This is the Person ID number.
test_dateRequired. Test date. Must be in the MM/DD/YYYY format.
test_yearRequired. Numeric field. This is the year in which the test took place.
test_administered_byText field. The name of the person who administered the test.
grade_levelRequired. Numeric field. The grade level the student who took the test was in at the time the test was administered.
notesText field. Will populate the Notes section of the Test Score record.
act_englishNumeric field. Average score of all subsections in the English section of the ACT.
act_english_rhetoricNumeric field. Score on the rhetoric subsection of the English section of the ACT.
act_english_usageNumeric field. Score on the usage subsection of the English section of the ACT.
act_english_writing_combinedNumeric field. English score plus the optional Writing score of the ACT.
act_mathNumeric field. Average score of all subsections in the Math section of the ACT.
act_math_1Numeric field. Score on the Pre-Algebra/Elementary Algebra subsection of the Math section of the ACT.
act_math_2Numeric field. Score on the Intermediate Algebra/Coordinate Geometry subsection of the Math section of the ACT.
act_math_3Numeric field. Score on the Plane Geometry/Trigonometry subsection of the Math section of the ACT.
act_readingNumeric field. Average score of all subsections in the Reading section of the ACT.
act_reading_1Numeric field. Score on subsection one of the Reading section of the ACT.
act_reading_2Numeric field. Score on subsection two of the Reading section of the ACT.
act_scienceNumeric field. Score on the Science section of the ACT.
act_compositeNumeric field. Average score on all sections of the ACT.
act_writingNumeric field. Score on the optional Writing subsection of the English section of the ACT.
act_social_scienceNumeric field. Score on the Social Science subsection of the Reading section of the ACT.

ERB

person_fkRequired. Numeric field. This is the Person ID number.
test_dateRequired. Test date. Must be in the MM/DD/YYYY format.
test_yearRequired. Numeric field. This is the year in which the test took place.
test_administered_byText field. The name of the person who administered the test.
grade_levelRequired. Numeric field. The grade level the student who took the test was in at the time the test was administered.
notesText field. Will populate the Notes section of the Test Score record.
erb_math_independent_normNumeric field. The Norm Number for the Math section in the year the Student took the ERB for Independent schools.
erb_math_suburban_normNumeric field. The Norm Number for the Math section in the year the Student took the ERB for Suburban schools.
erb_quantitative_abstract_independent_normNumeric field. The Norm Number for the Quantitative Abstract section in the year the Student took the ERB for Independent schools.
erb_reading_comprehension_independent_normNumeric field. The Norm Number for the Reading Comprehension section in the year the Student took the ERB for Independent schools.
erb_reading_comprehension_suburban_normNumeric field. The Norm Number for the Reading Comprehension section in the year the Student took the ERB for Suburban schools.
erb_verbal_independent_normNumeric field. The Norm Number for the Verbal section in the year the Student took the ERB for Independent schools.
erb_levelNumeric field. The ERB level of the Student.
erb_mathNumeric field. Score on the Math section of the ERB.
erb_math_national_normNumeric field. The Norm Number for the Math section in the year the Student took the ERB for all schools nationwide.
erb_quantitative_abstractNumeric field. Score on the Quantitative Abstract section of the ERB.
erb_quantitative_abstract_national_normNumeric field. The Norm Number for the Quantitative Abstract section in the year the Student took the ERB for all schools nationwide.
erb_reading_comprehensionNumeric field. Score on the Reading Comprehension section of the ERB.
erb_reading_comprehension_national_normNumeric field. The Norm Number for the Reading Comprehension section in the year the Student took the ERB for all schools nationwide.
erb_verbalNumeric field. Score on the Verbal section of the ERB.
erb_verbal_national_normNumeric field. The Norm Number for the Verbal section in the year the Student took the ERB for all schools nationwide.
erb_vocabulary_comprehensionNumeric field. Score on the Vocabulary Comprehension section of the ERB.
erb_writing_mechanicsNumeric field. Score on the Writing Mechanics section of the ERB.
erb_writing_concepts_&_skillsNumeric field. Score on the Writing Concepts & Skills section of the ERB.

Start Import

Click the “Import” button when you are ready to upload your data into Veracross.

Import Statuses

In Process

When the import is loading, the status will show as Processing Data.

Unsuccessful Load

If the importer detects a problem with one of the columns within the upload, an error message will appear indicating “The columns supplied in your spreadsheet do not match the requirements for this upload type”.

The first column will show the information you provided and the second column will show what the importer tried to match. Please review each of these columns, correct the information within the import and repeat the steps to import the data again.

Duplicates Detected

If “Fail on Duplicates” was selected when using Advanced Options and duplicates were detected within the upload, an error message will appear indicating “Duplicates were detected in the data.”

Please review the information within the import, remove the duplicate row(s) of information and repeat the steps to import the data again.

Import Complete

If the import was successful, “Import Complete” will appear on the screen along with a summary of the upload.

Access

The following security roles have access to the Data Importer for Test Scores: Division_Head_0, Division_Head_1, Division_Head_2, Division_Head_3, SysAdmin_1, SysAdmin_2, Admissions_1, Admissions_2 and Guidance_1.