CAASPP Import (California)

Tool Search: CAASPP Import

The CAASPP Import tool allows users to import student scores for seven different assessments. Users have the option to import results for the California Assessment of Student Performance and Progress (CAASPP) and the English Language Proficiency Assessments for California (ELPAC Summative or ELPAC Initial).

This process is not related to the CAASPP Paperless Reporting tools.

Screenshot of the CAASPP Import tool, located at Student Information, Assessment Administration.CAASPP Import

CAASPP Import Workflow

Step Campus Tool
1.

Students take assessment.


This step is performed outside of Campus.

N/A
2.

Scores are received from ETS, usually in a caret delimited or comma delimited format.


This step is performed outside of Campus.

N/A
3. Use the Import tool to import CAASPP scores (imports all seven files) or ELPAC (imports files dependent on choices made in the report editor). CAASPP Import
4a. When parent tests are available in Campus, those test structures are located and scores are imported. Assessment Center
4b. When parent tests are not available in Campus, those test structures are created. This is only a skeletal entry of the test that includes the Date, State Code and Result. Additional setup can be done AFTER scores have been imported.
5. When the import is complete, the scores display on the Student Assessment tool and in Campus Student and Campus Parent (when assessments are selected to display on Display Options).

Student Assessment


Campus Student


Campus Parent

Report Logic

This import tool imports CAASPP assessment data for all CAASPP tests (nine different import layouts). The student's State Identification Number (SSID) is used to match data from the file to the student's record in Campus.

When a record for one of these layouts exists in the Assessment Center, scores can be imported to that record when the name of that assessment is chosen on the Import tool. For example, when importing scores for Smarter Balanced for ELA, choose that item from the dropdown list for that assessment.

Multiple records in the Assessment Center may exist for an assessment. Each of those records are listed on the editor when selecting an existing test to import results. 

Or, when a test structure record for a particular test does NOT exist in the Assessment Center, the Import tool can create a test structure in the Assessment Center with the required fields (date, score type, state code) and the scores are imported to that record. Once the import is complete, you can add additional items to the Assessment Center record (like comments or passing score values, etc.)

See the CAASPP Test Setup article for details on what is imported when no Test Detail record exists.

ELPAC

There are four ELPAC Summative Options and four ELPAC Initial Options, one for each of the last four years - 2019 through 2022. The imported tests are the same; the only difference is the layout of the test files. Verify you are selecting the appropriate Import Type when importing these files. 

The following ELPAC  tests can be imported:

ELPAC (English Language Proficiency Assessments for California) Summative (Overall) ELPAC (English Language Proficiency Assessments for California) Initial
  • ELPAC Listening
  • ELPAC Oral
  • ELPAC Reading
  • ELPAC Speaking
  • ELPAC Writing
  • ELPAC Written
  • ELPAC Listening
  • ELPAC Oral
  • ELPAC Reading
  • ELPAC Speaking
  • ELPAC Writing
  • ELPAC Written

CAASPP

The following CAASPP tests can be imported:

CAASPP (California Assessment of Student Performance and Progress) 2024-2025 CAASPP (California Assessment of Student Performance and Progress) 2023-2024
  • 01 - Smarter Balanced for ELA 2024-2025
  • 02 - Smarter Balanced for Mathematics 2024-
  • 03 - CAA for ELA 2024-
  • 04 - CAA for Mathematics 2024-
  • 05 - CAA for Science 2024-
  • 06 - California Science Test 2018-2024
  • 07 - California Spanish Assessment 2021-2024
  • 01 - Smarter Balanced for ELA 2021-2024
  • 02 - Smarter Balanced for Mathematics 2021-2024
  • 03 - CAA for ELA
  • 04 - CAA for Mathematics
  • 05 - CAA for Science 2023-2024

  • 06 - California Science Test 2018-2024
  • 07 - California Spanish Assessment 2021-2024
CAASPP (California Assessment of Student Performance and Progress) 2021-2023 CAASPP (California Assessment of Student Performance and Progress) 2019-2020
  • 01 - Smarter Balanced for ELA 2021-2024
  • 02 - Smarter Balanced for Mathematics 2021-2024
  • 03 - CAA for ELA04 - CAA for Mathematics
  • 05 - CAA for Science 2018-2023
  • 06 - California Science Test 2018-2024
  • 07 - California Spanish Assessment 2021-2024
  • 01 - Smarter Balanced for ELA 2017-2020
  • 02 - Smarter Balanced for Mathematics 2017-2020
  • 03 - CAA for ELA
  • 04 - CAA for Mathematics
  • 05 - California Science Test 2018-2019/2019-2020
CAASPP (California Assessment of Student Performance and Progress) 2018-2019CAASPP (California Assessment of Student Performance and Progress) 2017-2018
  • 01 - Smarter Balanced for ELA 2017-2020
  • 02 - Smarter Balanced for Mathematics 2017-2020
  • 03 - CAA for ELA
  • 04 - CAA for Mathematics
  • 05 - CAA for Science
  • 06 - California Science Test 2018-2019/2019-2020
  • 09 - California Spanish Assessment 2018-2019/2019-2020
  • 01 - Smarter Balanced for ELA 2017-2020
  • 02 - Smarter Balanced for Mathematics 2017-2020
  • 03 - CAA for ELA
  • 04 - CAA for Mathematics
  • 05 - CAA for Science
  • 06 - California Science Test 2017-2018
  • 08 - Standards-based Tests in Spanish (STS) for Reading/Language Arts (RLA)

Import Editor

Option Description
Import Type

Determines which assessment is imported:

  • CAASPP 2017-2018
  • CAASPP 2018-2019
  • CAASPP 2019-2021
  • CAASPP 2021-2023
  • CAASPP 2023-2024
  • CAASPP 2024-2025
  • ELPAC Summative 2019
  • ELPAC Summative 2020
  • ELPAC Summative 2021
  • ELPAC Summative 2022
  • ELPAC Summative 2023
  • ELPAC Summative 2024
  • ELPAC Initial 2018-2019
  • ELPAC Initial 2019-2020
  • ELPAC Initial 2020-2021
  • ELPAC Initial 2021-2022
  • ELPAC Initial 2022-2023
  • ELPAC Initial 2023-2024
  • ELPAC Initial 2024-2025


Work to Perform

Indicates that the process is either a Test (recommended to do this first) or an actual Import.

  • When Test is chosen, no scores are imported. This can be used to see whether things import correctly and provides the opportunity to correct any errors that might occur.
  • When Import is chosen, scores are imported and can be found on the student's Assessment record. 
Assessments to Import Based on the selected Import Type, determine whether a specific test should be imported. For each test listed, select one of the following:
  • Assessment Name (ELPAC Overall 2021, California Alternate Assessment for ELA, etc.) - scores are imported to an existing Test Detail record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed. See the section below for details on whch assessments can be imported for each Import Type. 
  • Import to newly created test setup - a new Test Detail structure record is automatically created in the Assessment Center, with the minimal items needed to import assessment data and scores to that record.
  • Do not import these assessments - scores are not imported.

Assessments to Import

For each of the following options, a selection of what to import (or not import) is needed.

ELPAC Assessment Layouts

Click here to expand...

Test  Description
ELPAC Overall

Imports student scores for the ELPAC Overall assessment. This requires the Import Type field to be set to ELPAC Summative for any available year (e.g., ELPAC Summative 2019, ELPAC Summative 2020, etc.)


Select one of the following options:

  • ELPAC 2019 Summative to ELPAC 2024 Summative. - scores are imported to an existing Test Detail record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail structure record is automatically created in the Assessment Center, with the minimal items needed to import assessment data and scores to that record.
  • Do not import these assessments - scores are not imported.
ELPAC Initial
Imports student scores for the ELPAC Overall assessment. This requires the Import Type field to be set to ELPAC Initial for any available year (e.g., ELPAC Initial 2019-2020, ELPAC Initial 2023-2024, etc.)

Select one of the following options:

  • Initial ELPAC - Overall 2018-2019 to Overall 2023-2024 - scores are imported to an existing Test Detail record in the Assessment Center tool. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data and scores to that record.
  • Do not import these assessments - scores are not imported.
Import initial ELPAC with ELA Status

This requires the Import Type field to be set to any of the ELPAC Initial options.


When marked, a student's English Learner (EL) status is imported in addition to the test scores when an existing English Learner status does not exist already in Campus.


This status displays in the English Learner (EL) toolset. See the California English Learners (EL) article for state specific information.

CAASPP Assessment Options

Click here to expand...

CAASPP 2024-2025 Assessment Options

These options require the Import Type field to be set to CAASPP 2024-2025.

Click here to expand...

TestDescription
Smarter Balanced for ELA 2024-2025

Imports student scores for the Smarter Balance for ELA assessment.


Select one of the following options:

  • Smarter Balanced for ELA - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
Smarter Balanced for Math 2024

Imports student scores for the Smarter Balanced for Math assessment.


Select one of the following options:

  • Smarter Balanced for Math - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for ELA 2024-

Imports student scores for the California Alternate Assessment for ELA.


Select one of the following options:

  • California Alternate Assessment for ELA - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for Mathematics 2024-

Imports student scores for the California Alternate Assessment for Math.


Select one of the following options:

  • California Alternate Assessment for Mathematics - scores are imported to an existing structure Test Detail record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for Science 2024-

Select one of the following options:

  • California Alternate Assessment for Mathematics - scores are imported to an existing structure Test Detail record in the  Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Science Test 2024-

Imports student scores for the California Science Test.


Select one of the following options:

  • California Science Test - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Spanish Assessment 2021-2024

Imports student scores for the California Spanish Assessment. 


Select one of the following options:

  • California Spanish Assessment - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.

Previous CAASPP Assessment Options

Click here to expand...

CAASPP 2023-2024 Assessment Options

These options require the Import Type field to be set to CAASPP 2023-2024.

Click here to expand...

Test Description
Smarter Balanced for ELA 2021-2024

Imports student scores for the Smarter Balance for ELA assessment.


Select one of the following options:

  • Smarter Balanced for ELA - scores are imported to an existing Test Detail structure record in the Test Setup tool. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
Smarter Balanced for Math 2021-2024

Imports student scores for the Smarter Balanced for Math assessment.


Select one of the following options:

  • Smarter Balanced for Math - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for ELA

Imports student scores for the California Alternate Assessment for ELA.


Select one of the following options:

  • California Alternate Assessment for ELA - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for Mathematics

Imports student scores for the California Alternate Assessment for Math.


Select one of the following options:

  • California Alternate Assessment for Mathematics - scores are imported to an existing structure Test Detail record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for Science 2023-2024

Select one of the following options:

  • California Alternate Assessment for Mathematics - scores are imported to an existing structure Test Detail record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Science Test 2018-2024

Imports student scores for the California Science Test.


Select one of the following options:

  • California Science Test - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Spanish Assessment 2021-2024

Imports student scores for the California Spanish Assessment. 


Select one of the following options:

  • California Spanish Assessment - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.

CAASPP 2021-2023 Assessment Options

These options require the Import Type field to be set to CAASPP 2021-2023.

Click here to expand...

Test Description
Smarter Balanced for ELA 2021-2024

Imports student scores for the Smarter Balance for ELA assessment.


Select one of the following options:

  • Smarter Balanced for ELA - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
Smarter Balanced for Math 2021-2024

Imports student scores for the Smarter Balanced for Math assessment.


Select one of the following options:

  • Smarter Balanced for Math - scores are imported to an existing Test Detail structure record in the  Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the  Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for ELA

Imports student scores for the California Alternate Assessment for ELA.


Select one of the following options:

  • California Alternate Assessment for ELA - scores are imported to an existing Test Detail structure record in the  Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the  Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for Mathematics

Imports student scores for the California Alternate Assessment for Math.


Select one of the following options:

  • California Alternate Assessment for Mathematics - scores are imported to an existing structure Test Detail record in the  Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the  Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for Science 2018-2023

Select one of the following options:

  • California Alternate Assessment for Mathematics - scores are imported to an existing structure Test Detail record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the  Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Science Test 2018-2024

Imports student scores for the California Science Test.


Select one of the following options:

  • California Science Test - scores are imported to an existing Test Detail structure record in the  Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the  Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Spanish Assessment 2021-2024

Imports student scores for the California Spanish Assessment. 


Select one of the following options:

  • California Spanish Assessment - scores are imported to an existing Test Detail structure record in the  Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.

CAASPP 2019-2021 Assessment Options

These options require the Import Type field to be set to CAASPP 2019-2021.

Click here to expand...

Test Description
Smarter Balanced for ELA 2017-2020

Imports student scores for the Smarter Balance for ELA assessment.


Select one of the following options:

  • Smarter Balanced for ELA - scores are imported to an existing Test Detail structure record in the  Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the  Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
Smarter Balanced for Math 2017-2020

Imports student scores for the Smarter Balanced for Math assessment.


Select one of the following options:

  • Smarter Balanced for Math - scores are imported to an existing Test Detail structure record in the  Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the  Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for ELA

Imports student scores for the California Alternate Assessment for ELA.


Select one of the following options:

  • California Alternate Assessment for ELA - scores are imported to an existing Test Detail structure record in the Assessment Centertool. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the  Assessment Centerl, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for Mathematics

Imports student scores for the California Alternate Assessment for Math.


Select one of the following options:

  • California Alternate Assessment for Mathematics - scores are imported to an existing structure Test Detail record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the  Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Science Test 2018-2024

Imports student scores for the California Science Test.


Select one of the following options:

  • California Science Test - scores are imported to an existing Test Detail structure record in the  Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the  Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.

CAASPP 2018-2019 Assessment Options

These options require the Import Type field to be set to CAASPP 2018-2019.

Click here to expand...

Test  Description
Smarter Balanced for ELA 2017-2020

Imports student scores for the Smarter Balance for ELA assessment.


Select one of the following options:

  • Smarter Balanced for ELA - scores are imported to an existing Test Detail structure record in the  Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the  Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
Smarter Balanced for Math 2017-2020

Imports student scores for the Smarter Balanced for Math assessment.


Select one of the following options:

  • Smarter Balanced for Math - scores are imported to an existing Test Detail structure record in the  Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for ELA

Imports student scores for the California Alternate Assessment for ELA.


Select one of the following options:

  • California Alternate Assessment for ELA - scores are imported to an existing Test Detail structure record in the  Assessment Center.. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the  Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for Mathematics

Imports student scores for the California Alternate Assessment for Math.


Select one of the following options:

  • California Alternate Assessment for Mathematics - scores are imported to an existing structure Test Detail record in the Assessment Center tool. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the  Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for Science 2018-2023

Imports student scores for the California Alternate Assessment for Science.


Select one of the following options:

  • California Alternate Assessment for Science - scores are imported to an existing Test Detail structure record in the  Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Science Test 2018-2024

Imports student scores for the California Science Test.


Select one of the following options:

  • California Science Test - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the  Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Spanish Assessment - New for 2018-2019

Imports student scores for the California Spanish Assessment. 


Select one of the following options:

  • California Spanish Assessment - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the  Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.

CAASPP 2017-2018 Assessment Options

These options require the Import Type field to be set to CAASPP 2017-2018.

Click here to expand...

Test Description
Smarter Balanced for ELA 2017-2020

Imports student scores for the Smarter Balance for ELA assessment.


Select one of the following options:

  • Smarter Balanced for ELA - scores are imported to an existing Test Detail structure record in the Assessment Center tool. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the  Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
Smarter Balanced for Math 2017-2020

Imports student scores for the Smarter Balanced for Math assessment.


Select one of the following options:

  • Smarter Balanced for Math - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for ELA

Imports student scores for the California Alternate Assessment for ELA.


Select one of the following options:

  • California Alternate Assessment for ELA - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for Mathematics

Imports student scores for the California Alternate Assessment for Math.


Select one of the following options:

  • California Alternate Assessment for Mathematics - scores are imported to an existing structure Test Detail record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Alternate Assessment for Science 2018-2023

Imports student scores for the California Alternate Assessment for Science.


Select one of the following options:

  • California Alternate Assessment for Science - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
California Science Test 2017-2018

Imports student scores for the California Science Test.

Select one of the following options:

  • California Alternate Assessment for Science - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • California Science Test - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.
Standards-based Tests in Spanish for Reading/Language Arts

Imports student scores for the Standards-based Tests in Spanish for Reading/Language Arts.


Select one of the following options:

  • Standards-based Tests in Spanish for Reading/Language Arts - scores are imported to an existing Test Detail structure record in the Assessment Center. When there is more than one existing Test Detail Record, all options are listed.
  • Import to newly created test setup - a new Test Detail record is automatically created in the Assessment Center, with the minimal items needed to import assessment data, and scores are imported to that record.
  • Do not import these assessments - scores are not imported.

Import Assessment Data

Because of the time of year the students take these tests, it is assumed this Import is used several times throughout the year to import the different assessment types. Therefore, the procedures for using the Import tool are broken into three separate sections depending on which assessment data is being imported.

Please note that Excel files cannot be imported.

It is highly recommended that you test the import before importing scores.

Import Assessment Data for ELPAC Summative

  1. Select the ELPAC Summative option as the Import Type. Only the ELPAC Overall field is highlighted for import.
  2. For the Work to Perform field, select Test or Import. Or, when scores should not be imported, choose Do not import these assessments.
  3. In the ELPAC Overall dropdown, select either the ELPAC Overall option or the Import to newly created test setup.
  4. Locate and choose the appropriate file to import. Follow the instructions on your screen for locating the file.
  5. Click the Run Import button. After creating any new test/assessment setups, refresh the screen. This adds the newly created Test Setup to the dropdown list. The system processes the import and a Summary file of the data imported displays, and lists any warnings or errors that may have occurred (see image below).
  6. Review the student's Assessment record for the newly imported scores.

Screenshot of an example of import results. ELPAC Summary Import Results  

Import Assessment Data for ELPAC Initial

  1. Select the appropriate ELPAC Initial options for the appropriate year as the Import Type.
  2. For the Work to Perform field, select Test or Import.
  3. In the Initial ELPAC -  Overall 2018-2019, Initial ELPAC - Overall 2019-2020, Initial ELPAC - Overall 2020-2021, or Initial ELPAC - Overall 21-22/22-23 dropdown (depending on which import type is selected) ,  or Initial ELPAC - Overal 2023-2024, select either the Initial ELPAC - Overall option or the Import to newly created test setup. Or, when scores should not be imported, choose Do not import these assessments.
  4. When ELA Status should also be imported, mark the Import Initial ELPAC with ELA Status checkbox.
  5. Locate and choose the appropriate file to import. Follow the instructions on your screen for locating the file.
  6. Click the Run Import button. After creating any new test/assessment setups, refresh the screen. This adds the newly created Test Setup to the dropdown list.
  7. The system processes the import and a Summary file of the data imported displays, and lists any warnings or errors that may have occurred.
  8. Review the student's Assessment record for the newly imported scores.

Import Assessment Data for CAASPP

  1. Select the appropriate CAASPP option for the appropriate year as the Import Type.
  2. For the Work to Perform field, select Test or Import.
  3. For each of the CAASPP assessments, select either the name of the assessment or the Import to newly created test setup. Or, when scores should not be imported, choose Do not import these assessments.
  4. Locate and choose the appropriate file to import. Follow the instructions on your screen for locating the file.
  5. Click the Run Import button. After creating any new test/assessment setups, refresh the screen. This adds the newly created Test Setup to the dropdown list.
  6. The system processes the import and a Summary file of the data imported displays, and lists any warnings or errors that may have occurred.
  7. Review the student's Assessment record for the newly imported scores.

Error and Warning Descriptions

The CAASPP Import tool follows the regular Score Import Wizard functionality for reporting errors and warnings. The following errors and/or warnings definitions apply here.

  • Ambiguity – Multiple student matches found or multiple records in the source file for one student.
  • Discrepancy – No match or partial match found.
  • Exception – Invalid value or format of data to be imported OR a student is found who does not match the selected school(s) of the import. For these exceptions, error messages are returned indicating an invalid value for a specific field was found and the user is instructed on the appropriate format.

Reasons for Import Failures

An import immediately fails when any of the following are true:

  • Import is missing the data file to be imported.
  • Import encounters unexpected errors (details are listed in the error details).
  • A test (parent or child) does not import unless at least one of the following fields contains a value:
    • Test Type
    • Scale Score
    • Raw Score
    • Result

Data Matching Errors

Data from the file being imported must exactly match the student to whom it is mapped. Matching is based on the student identifier selected for matching/mapping when the import is created.

The import returns an error when any of the following applies to the attempted match:

  • Student identifier could not be found.
  • First name does not match student identifier.
  • Last name does not match student identifier.
  • Date of birth does not match student identifier.