CAASPP Import Test Setup and Assessment Layout

Tool Search: 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. 

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

Read - Import files and run the import.
Write - N/A
Add - N/A
Delete - N/A

For more information about Tool Rights and how they function, see the Tool Rights article.

The CAASPP Import has logic to create Test Detail structure records when you do not already have the test available in Assessment Center. It creates the basic fields required for import - Name, Code, Assessment Type, Test Type, Score Fields and Result Status. When 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 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 Assessment Center record, the following items are marked on the Test Detail:

New Parent Test: Smarter Balanced for ELA

Assessment DataImage

Test Information

  • Name: Smarter Balanced for ELA
  • Code: SBELA
  • Assessment Type: LPF: EL for Proficiency
Screenshot of the Assessment Center highlighting the fields for Name, Code and Assessment Type

Test Type

  • State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)

Screenshot of the Test Type section on the Assessment Center Test Detail screen highlighting the State Code field.
Score Fields
  • Date
  • Result
  • Scale Score
Screenshot of the selected Score Fields on the Assessment Center Test Detail
Result Statuses
  • 9: No Score
  • 4: Standard Exceeded
  • 3: Standards Met
  • 2: Standard Nearly Met
  • 1: Standard Not Met
Screenshot of the applicable Result Statuses for the Smarter Balnace for ELA assessment

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

Assessment DataImage

Test Information

  • Name: Smarter Balanced for ELA
  • Code: SBM
Screenshot of the Name and Code for Smarter Balanced for Math test

Test Type

  • State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)
Screenshot of the Test Type section on the Assessment Center Test Detail screen highlighting the State Code field.

Score Fields

  • Date
  • Result
  • Scale Score
Screenshot of the selected Score Fields on the Assessment Center Test Detail
Result Statuses
  • 9: No Score
  • 4: Standard Exceeded
  • 3: Standards Met
  • 2: Standard Nearly Met
  • 1: Standard Not Met
Screenshot of the applicable Result Statuses for the Smarter Balnace for Math assessment

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

Assessment DataImage

Test Information:

  • Name: California Alternate Assessment for ELA
  • Code: CAAELA
Screenshot of the Test Name and Code for the California Alternate Assessment for ELA

Test Type:

  • State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)
Screenshot of the Test Type section on the Assessment Center Test Detail screen highlighting the State Code field.

Score Fields

  • Date
  • Result
  • Scale Score
Screenshot of the selected Score Fields on the Assessment Center Test Detail
Result Statuses
  • 9: No Score
  • 3: Level 3 - Alternate
  • 2: Level 2 - Alternate
  • 1: Level 1 - Alternate
Screenshot of the Result Statuses for the CAA for ELA Assessment

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

Assessment DataImage

Test Information

  • Name: California Alternate Assessment for Math
  • Code: CAAM
Screenshot of the CAA for Math Name and Code fields

Test Type

  • State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)
Screenshot of the Test Type section on the Assessment Center Test Detail screen highlighting the State Code field.

Score Fields

  • Date
  • Result
  • Scale Score
Screenshot of the selected Score Fields on the Assessment Center Test Detail
Result Statuses
  • 9: No Score
  • 3: Level 3 - Alternate
  • 2: Level 2 - Alternate
  • 1: Level 1 - Alternate
Screenshot of the Result Statuses for the CAA for ELA Assessment

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

Assessment DataImage

Test Information

  • Name: California Alternate Assessment for Science
  • Code: CAAS
Screenshot of the CAA for Science Name and Code fields

Test Type

  • State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)
Screenshot of the Test Type section on the Assessment Center Test Detail screen highlighting the State Code field.

Score Fields

  • Date
Screenshot of the Score Fields needed for the CAA for Science assessment

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

Assessment DataImage

Test Information

  • Name: California Science Test
  • Code: CAST
Screenshot of the California Science Test Name and Code Fields

Test Type

  • State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)


Screenshot of the Test Type section on the Assessment Center Test Detail screen highlighting the State Code field.

Score Fields

  • Date
Screenshot of the Score Fields needed for the CAA for Science assessment
Result Statuses
  • 9: No Score
  • 4: Standard Exceeded
  • 3: Standards Met
  • 2: Standard Nearly Met
  • 1: Standard Not Met
Screenshot of the applicable Result Statuses for the CA Science Test

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

Assessment DataImage
Test Informaiton
  • Name: California Spanish Assessment
  • Code: CSA
Screenshot of the name and code for the California Spanish Assessment
Test Type:
  • State Test: CASP: CA Assessment of Student Performance and Progress (CAASPP)
Screenshot of the State Test selection for the California Spanish Assessment
Score Fields:
  • Date
  • Raw Score
  • Scale Score
  • Result
Screenshot of the selected score fields for the California Spanish Assessment
Result Statuses
  • 3
  • 2
  • 1
Screenshot of the Result Statuses used for the California Spanish Assessment

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

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

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.

When 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.

When 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, when districts choose to add that information manually.

New Parent Test: ELPAC - Overall

Assessment DataImage
Test Informaiton
  • Name: ELPAC Overall
  • Code: ELPAC
  • Assessment Type: LPF: EL for Profiency
Screenshot of the Name, Code and Assessment Type fields for ELPAC
Test Type:
  •  State Test: 145 - English Language Proficiency Assessment for California (ELPAC)
Screenshot of the State Code selection for ELPAC
Score Fields:
  • Braille Accommodation
  • Date
  • Result
  • Scale Score
Screenshot of the Score Fields for ELPAC
Result Statuses
  • 4: Level 4
  • 3: Level 3
  • 2: Level 2
  • 1: Level 1
Screenshot of the Result Statuses for ELPAC

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
Assessment DataImage
Test Informaiton
  • Name: ELPAC Overall
  • Code: ELPAC
  • Assessment Type: LID: EL for Identification
Screenshot of the Name, Code and Assessment Type for the Initial ELPAC - Overall test
Test Type:
  •  State Test: 145 - English Language Proficiency Assessment for California (ELPAC)
Screenshot of the State Code selection for ELPAC
Score Fields:
  • Braille Accommodation
  • Date
  • Result
  • Scale Score
Screenshot of the score fields for Initial ELPAC
Result Statuses
  • 3: Initial Fluent English Proficient (IFEP)
  • 2: Intermediate Englsh Learner
  • 1: Novice English Learner
Screenshot of the Result Statuses for Initial ELPAC

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. When 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. 

Previous Versions

CAASPP Import Test Setup and Assessment Layout (California) [.2239 - .2343]