CAASPP Import Test Setup and Assessment Layout (California)

Classic View: Assessment > CAASPP Import

Search Terms: CAASPP Import

The CAASPP (California Assessment of Student Performance and Progress) consists of seven different layouts that are aimed to assist teachers, administrators, students and parents for success through quality teaching and learning using a variety of approaches and item types.

Infinite Campus is not responsible for the assessment layouts. Please refer to the CAASPP or ELPAC sites for specific layout information. 

CAASPP Import ToolThe CAASPP Import has logic to create Test Detail structure records if you do not already have the test available in Assessment Test Setup. It creates the basic fields required for import - Name, Code, Assessment Type, Test Type, Score Fields and Result Status. If you would like more information for the Test Detail structure record, you can either modify the data after using the import or create your own record prior to using the CAASPP Import.

See the CAASPP Import article for information on using the Import tool.

CAASPP Import Type

The following information details the what fields are created when using the Import to create a Test Setup record for each assessment included in the CAASPP Import.

Smarter Balanced for ELA Test Setup

When importing assessments to a newly created Test Setup record, the following items are marked on the Test Setup Detail:

New Parent Test: Smarter Balanced for ELA

  • Name - Smarter Balanced for ELA
  • Code - SBELA
  • Assessment Type - LPF: EL for Proficiency
  • Test Type - State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)
  • Score Fields: Date, Scale Score, Result
  • Result Statuses - Values 9, 4, 3, 2, 1

Test Detail for Smarter Balanced for ELA  

New Child Test: Smarter Balanced for ELA

This layout applies to each of the Smarter Balanced for ELA child tests (Reading, Writing, Listening, Research/Inquiry)

The child Test Setup record is similar to the Parent test. The addition here is the selection of the Parent Test field and a different Code depending on the child layout being imported.

Each child test has the same Parent Test of Smarter Balanced for ELA and the same State Test Type of CASP: CA Assessment of Student Performance and Progress.

Smarter Balanced Child Test NameCodeScore FieldsResult Statuses
ValuesResult CodeLabel
Claim 1 - ReadingSBELAC1

Result

99No Score (claim not attempted)
33Above Standard (Passing Score)
22Near Standard
11Below Standard
Claim 2 - WritingSBELAC2

Result

99No Score (claim not attempted)
33Above Standard (Passing Score)
22Near Standard
11Below Standard
Claim 3 - ListeningSBELAC3Result99No Score (claim not attempted)
33Above Standard (Passing Score)
22Near Standard
11Below Standard
Claim 4 - Research/InquirySBELAC4Result99No Score (claim not attempted)
33Above Standard (Passing Score)
22Near Standard
11Below Standard


Smarter Balanced for Math Test Setup

When importing assessments to a newly created Test Setup record, the following items are marked on the Test Setup Detail:

New Parent Test: Smarter Balanced for Math

  • Name - Smarter Balanced for ELA
  • Code - SBM
  • Test Type - State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)
  • Score Fields: Date, Scale Score, Result
  • Result Statuses - Values 9, 4, 3, 2, 1

New Child Test: Smarter Balanced for Math

This layout applies to each of the Smarter Balanced for Math child tests (Concepts and Procedures, Problem Solving and Modeling Data, Communicating Reasoning)

The child Test Setup record is similar to the Parent test. The addition here is the selection of the Parent Test field and a different Code depending on the child layout being imported.

Each child test has the same Parent Test of Smarter Balanced for Math and the same State Test Type of CASP: CA Assessment of Student Performance and Progress.

Smarter Balanced Child Test NameCodeScore FieldsResult Statuses
ValuesResult CodeLabel
Claim 1 - Concepts and ProceduresSBMC1

Result

99No Score (claim not attempted)
33Above Standard (Passing Score)
22Near Standard
11Below Standard
Claim 2 - Problem Solving and Modeling DataSBMC2

Result

99No Score (claim not attempted)
33Above Standard (Passing Score)
22Near Standard
11Below Standard
Claim 3 - Communicating ReasoningSBMC3Result99No Score (claim not attempted)
33Above Standard (Passing Score)
22Near Standard
11Below Standard

California Alternate Assessments for ELA

When importing assessments to a newly created Test Setup record, the following items are marked on the Test Setup Detail:

New Parent Test: California Alternate Assessment for ELA

  • Name - California Alternate Assessment for ELA
  • Code - CAAELA
  • Test Type - State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)
  • Score Fields: Date, Scale Score, Result
  • Result Statuses - Values 9, 3, 2, 1

California Alternate Assessments for Math

When importing assessments to a newly created Test Setup record, the following items are marked on the Test Setup Detail:

New Parent Test: California Alternate Assessment for Math

  • Name - California Alternate Assessment for Math
  • Code - CAAM
  • Test Type - State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)
  • Score Fields: Date, Scale Score, Result
  • Result Statuses - Values 9, 3, 2, 1

California Alternate Assessments for Science

When importing assessments to a newly created Test Setup record, the following items are marked on the Test Setup Detail:

New Parent Test: California Alternate Assessment for Science

  • Name - California Alternate Assessment for Science
  • Code - CAAS
  • Test Type - State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)
  • Score Fields: Date

California Science Test

When importing assessments to a newly created Test Setup record, the following items are marked on the Test Setup Detail:

New Parent Test: California Science Test

  • Name - California Science Test
  • Code - CAST
  • Test Type - State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)
  • Score Fields: Date
  • Result Statuses: Values 9, 4, 3, 2, 1

New Child Test: California Science Test

The California Science Test child Test Setup record is similar to the Parent test. The addition here is the selection of the Parent Test field and a different Code depending on the child layout being imported.

Each child test has the same Parent Test of California Science Test and the same State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)

California Science Test Child Test NameCodeScore FieldsResult Statuses
ValuesResult CodeLabel
Domain 1 - Life ScienceCASTD1

Result

33Above Standard (Passing Checked)
Domain 2 - Physical ScienceCASTD222Near Standard
Domain 3 - Earth and Space ScienceCASTD311Below Standard

California Spanish Assessment

When importing assessments to a newly created Test Setup record, the following items are marked on the Test Setup Detail:

New Parent Test: California Spanish Assessment

  • Name - California Spanish Assessment
  • Code - CSA
  • Test Type - State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)
  • Score Fields: Date, Raw Score, Scale Score, Result
  • Result Statuses - Values 3, 2, 1

New Child Test: California Spanish Assessment

The California Spanish Assessment child Test Setup record is similar to the Parent test. The addition here is the selection of the Parent Test field and a different Code depending on the child layout being imported.

Each child test has the same Parent Test of California Spanish Assessment and the same State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)

California Spanish Assessment Child Test Name

CodeScore FieldsResult Statuses
ValuesResult CodeLabel
Domain 1 - ListeningCSAD1

Result

22On Track(Passing Checked)
Domain 2 - Writing MechanicsCSAD211Not On Track
Domain 3 - ReadingCSAD3

Standards-Based Tests in Spanish for Reading and Language Arts

When importing assessments to a newly created Test Setup record, the following items are marked on the Test Setup Detail:

New Parent Test: Standards-Based Tests in Spanish for Reading/Language Arts

  • Name - Standards-Based Tests in Spanish for Reading/Language Arts
  • Code - STSRLA
  • Test Type - State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)
  • Score Fields: Date, Raw Score, Scale Score, Result
  • Result Statuses - Values 9, 5, 4, 3, 2, 1

ELPAC Import Types

The ELPAC (English Language Proficiency Assessments for California) is used to assess English proficiency for students whose Primary Home Language is NOT English for students in grades K-12. This assessment replaces the CELDT as of 2018, and is aligned with the 2012 California English Language Development Standards.

This assessment is two separate tests - (1) initial identification of students as English Learners, referred to as the ELPAC Initial; (2 ) annual summative assessment to measure a student's progress in English and to identity the student's proficiency, referred to as the ELPAC Summative.

Both ELPAC and IELPAC includes six "child" layouts - Listening, Oral, Reading, Speaking, Writing and Written.

If the Import file contains an English Learners (EL) record for the student, but there is no such record in Campus, an English Learners (EL) record is created for that student. Existing EL data is NOT overwritten.

If a student does not have an assigned Primary Home Language on their EL record, the import process also adds this value for the student when it exists in the import file.

The following information details the what fields are created when using the Import to create a Test Setup record for each assessment included in the ELPAC Import.

ELPAC Summative Import Type

When importing assessments to a newly created Test Setup record, the following items are marked on the Test Setup Detail:

Note that including the year in the test name is a district preference. Tests can be set up as a single parent test to categorize EVERY version of the test. To break the tests out by a specific year, include the year in the title of the parent test. The layouts below do not include the year.

The  ELPAC child tests do not include dates in the import file, but dates are an option on the Test Setup editor, if districts choose to add that information manually.

New Parent Test: ELPAC - Overall

  • Name - ELPAC Overall
  • Code - ELPAC
  • Assessment Type - LPF: EL for Proficiency
  • Test Type - State Test: 145 - English Language Proficiency Assessment for California (ELPAC)
  • Score Fields: Date, Scale Score, Result, Braille Accommodation
  • Result Statuses - Values 4, 3, 2, 1

Test Detail for ELPAC - Overall 

New Child Test: ELPAC 

This layout applies to each of the ELPAC Overall child tests (Oral, Listening, etc.)

The ELPAC child Test Setup record is similar to the Parent test. The addition here is the selection of the Parent Test field and a different Code depending on the child layout being imported.

Each child test has the same Parent Test of ELPAC Overall and the same State Test Type of 145: English Language Proficiency Assessments for California.

  • ELPAC Oral and ELPAC Written have the same score fields and result statuses imported.
  • ELPAC Listening, ELPAC Speaking. ELPAC Reading, and ELPAC Writing have the same score fields and result statuses imported.
ELPAC Child Test NameCodeScore FieldsResult Statuses
ValuesResult CodeLabel
ELPAC - OralELPACOral

Date

Scale Score

Result

44Level 4
33Level 3
ELPAC - WrittenELPACWritten22Level 2
11Level 1
ELPAC - ListeningELPACListening

Date

Raw Score

Result

Accommodation

Alternate Assessment


3

3Well Developed
ELPAC - SpeakingELPACSpeaking22Somewhat/Moderately
ELPAC - ReadingELPACReading11Beginning
ELPAC - WritingELPACWriting0EExempt

ELPAC Initial Import Type

When importing assessments to a newly created Test Setup record, the following items are marked on the Test Setup Detail:

New Parent Test: Initial ELPAC - Overall

  • Name - Initial ELPAC Overall
  • Code - IELPAC
  • Assessment Type - LID: EL for Identification
  • Test Type - State Test: 145 - English Language Proficiency Assessment for California (ELPAC)
  • Score Fields: Date, Scale Score, Result
  • Result Statuses - Values 1, 2, 3

The Initial ELPAC - Overall for 2018-2019 and Initial ELPAC - Overall for 2019-2020 use the same Test Detail options.

New Child Test: Initial ELPAC 

This layout applies to each of the ELPAC Overall child tests (Oral, Listening, etc.)

The IELPAC child Test Setup record is similar to the Parent test. The addition here is the selection of the Parent Test field and a different Code depending on the child layout being imported.

Each child test has the same Parent Test of IELPAC Overall and the same State Test Type of 145: English Language Proficiency Assessments for California.

IELPAC Child Test NameCodeScore FieldsResult Statuses
ValuesResult CodeLabel
IELPAC - OralIELPACOral

Date

33Well developed
Result22Somewhat to moderately developed
11Minimally developed
IELPAC - WritingIELPACWrittenDate33Well developed
Raw Score22Somewhat to moderately developed
Alternate Assessment11Minimally developed
Testing Irregularities
IELPAC - ListeningIELPACListening

Date

N/AN/AN/A

Raw Score

N/AN/AN/A

Alternate Assessment

N/AN/AN/A

Testing Irregularities

N/AN/AN/A
IELPAC - SpeakingIELPACSpeakingDateN/AN/AN/A
Raw ScoreN/AN/AN/A
Alternate AssessmentN/AN/AN/A
Testing IrregularitiesN/AN/AN/A
IELPAC - ReadingIELPACReadingDateN/AN/AN/A
Raw ScoreN/AN/AN/A
Alternate AssessmentN/AN/AN/A
Testing IrregularitiesN/AN/AN/A

Assessment Layouts and Format Updates

Assessment from ETS are given to districts in a CSV file, usually in a caret-delimited format. It may look like this:

Sample Assessment File Layout  

Conversion or mapping does not need to be done to use the CAASPP Import. If you do want to convert the caret-delimited file to a more readable format, follow these steps:

  1. In the file, highlight Column A.
  2. In the header of Excel, navigate to the Data tab and choose Text to Columns.
  3. On the pop-up editor, select the Delimited radio button, and click Next. 
  4. Change the Delimiter from Tab to Other and enter ^ into the text field. Click Next.
  5. Leave all options as is on the next screen and click Finish.
  6. The data is reformatted into columns, making it easier to locate student information. This can be used for trouble-shooting or verifying data after using the import.


The ELPAC Initial file is sent in an Excel file. Before importing, the first row (see highlighted text in the image below) needs to be removed. Initial ELPAC File  

Then, the file can be saved to a CSV format. 

  1. In Excel, go to the File tab and choose Save As.
  2. Select the desired location for where the file should be saved. 
  3. In the Save As dialog, rename the File Name if desired, and change the Save as Type to be CSV (Comma delimited). There are other CSV options that may be listed - CSV (Macintosh) and CSV (MS-DOS). 
  4. Click Save
  5. Once in CSV format, it can be imported.