Importing MCA Results (Minnesota)

Last Modified on 10/22/2022 10:27 am CDT

This article will guide you through the process of importing MCA results into Campus. This process involves setting up a series of assessments which provide the foundation for mapping MCA results so they can properly import into Campus.  

The example layouts detailed below are based off layouts provided to us from Pearson and are intended for the Pre-ID files. 

Step 1. Set Up MCA Math Tests within Campus

The first step to importing MCA Math results is to create an MCA parent test within Test Setup (Assessments > Test Setup). To create this test, click the New Test icon and enter the following values in the fields defined below. 

MCA Parent Test Field Value

Name MCA
Parent Test No Parent
State Test Selected
State Code MCA: MN Comprehensive Assessment

Now that a parent MCA test has been created, we need to now create the MCA Math parent test below the MCA parent test. To create this test, click the New Test icon and enter the following values in the fields defined below. 

MCA Math Parent Test Field Value

Name MCA Math
Parent Test MCA
Subject Math
State Test Selected
State Code MCA: MN Comprehensive Assessment
Date Checked
Scale Score Checked
Result Checked
ATesting Grade

Checked

Note: This field is unlocked and thus may be named differently by your district.

Now that the MCA Math parent test has been created, we now need to create four reporting strand tests. To create this strand test 1, click the New Test icon and enter the following values in the fields defined below. 

MCA Math Reporting Strand 1 Field Value

Name MCA Math Reporting Strand 1
Parent Test MCA Math
Subject Math
State Test Selected
State Code MCA: MN Comprehensive Assessment
Scale Score Checked
Result Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

Strand test 2 now needs to be created. To create this test, click the New Test icon and enter the following values in the fields defined below. 

MCA Math Reporting Strand 2 Field Value

Name MCA Math Reporting Strand 2
Parent Test MCA Math
Subject Math
State Test Selected
State Code MCA: MN Comprehensive Assessment
Scale Score Checked
Result Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

Now create Strand test 3. Click the New Test icon and enter the following values in the fields defined below. 

MCA Math Reporting Strand 3 Field Value

Name MCA Math Reporting Strand 3
Parent Test MCA Math
Subject Math
State Test Selected
State Code MCA: MN Comprehensive Assessment
Scale Score Checked
Result Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

And finally, create Strand test 4. Click the New Test icon and enter the following values in the fields defined below. 

MCA Math Reporting Strand 4 Field Value

Name MCA Math Reporting Strand 4
Parent Test MTAS Math
Subject Math
State Test Selected
State Code MCA: MN Comprehensive Assessment
Scale Score Checked
Result Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

Once all MCA math tests have been created, they should appear like the image below. Move onto Step 2. 

Step 2. Set Up MCA Reading Tests within Campus

Just as we set up MCA Math tests, MCA Reading tests now need to be created in Campus. Create the MCA Reading Parent Test by clicking the New Test icon and entering the following values in the fields defined below. 

MCA Reading Parent Test Field Value

Name MCA Reading
Parent Test MCA
Subject Reading
State Test Selected
State Code MCA: MN Comprehensive Assessment
Date Checked
Scale Score Checked
Result

Checked
ATesting Grade

Checked

Note: This field is unlocked and thus may be named differently by your district.
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

Once the parent MCA Reading test has been created, we now need to create MCA Reading Reporting Strand 1. Click the New Test icon and enter the following values in the fields defined below. 

MCA Reading Reporting Strand 1 Field Value

Name MCA Reading Reporting Strand 1
Parent Test MCA Reading
Subject Reading
State Test Selected
State Code MCA: MN Comprehensive Assessment
Scale Score Checked
Result Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

Create MCA Reading Reporting Strand 2. Click the New Test icon and enter the following values in the fields defined below. 

MCA Reading Reporting Strand 2 Field Value

Name MCA Reading Reporting Strand 2
Parent Test MCA Reading
State Test Selected
State Code MCA: MN Comprehensive Assessment
Result Checked
Scale Score Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

Create MCA Reading Reporting Strand 3. Click the New Test icon and enter the following values in the fields defined below. 

MCA Reading Reporting Strand 3 Field Value

Name MCA Reading Reporting Strand 3
Parent Test MCA Reading
State Test Selected
State Code MCA: MN Comprehensive Assessment
Scale Score Checked
Result Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

And finally, create MCA Reading Reporting Strand 4. Click the New Test icon and enter the following values in the fields defined below.

MCA Reading Reporting Strand 4 Field Value

Name MCA Reading Reporting Strand 4
Parent Test MCA Reading
Subject Reading
State Test Selected
State Code MCA: MN Comprehensive Assessment
Scale Score Checked
Result Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

Once all MCA reading tests have been created, they should appear like the image below. Move onto Step 3. 

Step 3. Set Up MCA Science Tests within Campus

Just as we set up MCA Math and Reading tests, MCA Science tests now need to be created in Campus. Create the MCA Science Parent Test by clicking the New Test icon and entering the following values in the fields defined below. 

MCA Science Parent Test Field Value

Name MCA Science
Parent Test MCA
Subject Science
State Test Selected
State Code MCA: MN Comprehensive Assessment
Date Checked
Scale Score Checked
Result Checked
ATesting Grade

Checked

Note: This field is unlocked and thus may be named differently by your district.

Once the parent MCA Science test has been created, we now need to create MCA Science Reporting Strand 1. Click the New Test icon and enter the following values in the fields defined below. 

MCA Science Reporting Strand 1 Field Value

Name MCA Science Reporting Strand 1
Parent Test MCA Science
Subject Science
State Test Selected
State Code MCA: MN Comprehensive Assessment
Scale Score Checked
Result Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

Create MCA Science Reporting Strand 2. Click the New Test icon and enter the following values in the fields defined below. 

MCA Science Reporting Strand 2 Field Value

Name MCA Science Reporting Strand 2
Parent Test MCA Science
Subject Science
State Test Selected
State Code MCA: MN Comprehensive Assessment
Scale Score Checked
Result Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

Create MCA Science Reporting Strand 3. Click the New Test icon and enter the following values in the fields defined below. 

MCA Science Reporting Strand 3 Field Value

Name MCA Science Reporting Strand 3
Parent Test MCA Science
Subject Science
State Test Selected
State Code MCA: MN Comprehensive Assessment
Scale Score Checked
Result Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

Create MCA Science Reporting Strand 4. Click the New Test icon and enter the following values in the fields defined below.

MCA Science Reporting Strand 4 Field Value

Name MCA Science Reporting Strand 4
Parent Test MCA Science
Subject Science
State Test Selected
State Code MCA: MN Comprehensive Assessment
Scale Score Checked
Result Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

Create MCA Science Reporting Strand 5. Click the New Test icon and enter the following values in the fields defined below. 

MCA Science Reporting Strand 5 Field Value

Name MCA Science Reporting Strand 5
Parent Test MCA Science
Subject Science
State Test Selected
State Code MCA: MN Comprehensive Assessment
Scale Score Checked
Result Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

Create MCA Science Reporting Strand 6. Click the New Test icon and enter the following values in the fields defined below. 

MCA Science Reporting Strand 6 Field Value

Name MCA Science Reporting Strand 6
Parent Test MCA Science
Subject Science
State Test Selected
State Code MCA: MN Comprehensive Assessment
Scale Score Checked
Result Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

Create MCA Science Reporting Strand 7. Click the New Test icon and enter the following values in the fields defined below. 

MCA Science Reporting Strand 7 Field Value

Name MCA Science Reporting Strand 7
Parent Test MCA Science
Subject Science
State Test Selected
State Code MCA: MN Comprehensive Assessment
Scale Score Checked
Result Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

Create MCA Science Reporting Strand 8. Click the New Test icon and enter the following values in the fields defined below. 

MCA Science Reporting Strand 8 Field Value

Name MCA Science Reporting Strand 8
Parent Test MCA Science
Subject Science
State Test Selected
State Code MCA: MN Comprehensive Assessment
Scale Score Checked
Result Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

And finally, create MCA Science Reporting Strand 9. Click the New Test icon and enter the following values in the fields defined below.

MCA Science Reporting Strand 9 Field Value

Name MCA Science Reporting Strand 9
Parent Test MCA Science
Subject Science
State Test Selected
State Code MCA: MN Comprehensive Assessment
Scale Score Checked
Result Checked
Result Statuses

See image to the left for an example of values. 

Note: This is merely an example. You will need to fill in the expected values that are on the import you receive from the state. 

Once all MCA Science tests have been created, they should appear like the image below. Move onto Step 4. 

Step 4. Import MCA Results via Assessment Import Wizard

Now that MCA assessments are entered into Campus, you are now ready to map MCA results to these tests and import the data into Campus. 

See the following sections below for step-by-step instructions on importing MCA math, reading, and science results:

Using the Score Import Wizard to Import Results

In order import your MCA results into Campus, you need to map the data from the MCA file to the assessments created in Steps 1 and 2 above. This process is done in the Score Import Wizard. The information below will walk you through the general process for using this tool to map and import the data, with the assumption that you then apply this process to the information described in the Import MCA Math Results, Import MCA Reading Results, and Import MCA Science Results sections below. 

To begin:

  1. Navigate to the Score Import Wizard (Assessment > Score Import Wizard)
  2. Click New Import Mapping.
  3. Enter the Name of the import (MCA Math, MCA Reading, or MCA Science depending on which one you are doing).
  4. Set the remaining fields to match the values described in the image below.
  5. Select Choose File, locate and select the MCA data file on your local hard drive or network.
  6. Once the file is uploaded, select Upload & Continue.

You should see the data file loaded into the Raw Data File Sample window on the right-hand side of the screen (see example in the image below). You now need to map each field from the raw data file to the assessment. To begin this process, click the New icon. 

Once New is selected, several fields will appear which need to be defined so that raw data from the file will be inserted into the proper fields on the assessment. Follow the tables described in the Import MCA Math Results, Import MCA Reading Results, and Import MCA Science Results sections for a breakdown of how you need to create and map each field per assessment.

For each field that needs to be mapped, click the New icon, enter the proper values for each field and click Save. Repeat this process for every row in the tables found in the the Import MCA Math Results, Import MCA Reading Results, and Import MCA Science Results sections. Please keep in mind each table in these sections is its own assessment import. Once all fields for a single table are mapped, you are ready to import the data. Do not create and add mappings for more than one table at the time. 

Once all data is mapped:

  1. Click the Insert or update values specified in the import to the existing record and keep all other existing data as is radio button.
  2. Select an Import Mode of 'Test'.
  3. Select an Output Format.
  4. Select Test.

Review the import test results to ensure its accuracy and correct any identified issues. 

If you have already gone through this process and are importing this data for a second (or third, or fourth, etc) time, click the Replace existing record and remove data not specified in the import radio button. 

Once you have reviewed the data and are ready to import:

  1. Click the Insert or update values specified in the import to the existing record and keep all other existing data as is radio button.
  2. Select an Import Mode of 'Import'.
  3. Select the Import button. 

MCA data has now been properly imported into Campus. Repeat this process for each Math, Reading, and Science Strand until all raw data has been imported into Campus.

Import MCA Math Results

The sections below describe the field values required when mapping raw file data to assessments created in Steps 1 and 2. Once all fields for a single table are mapped, you are ready to import the data. Do not create and add mappings for more than one table or section at the time. 

To begin mapping data for MCA Math results:

  1. Click the New icon.
  2. Start with row 1 in the table below and enter field values as they are defined in the table.
  3. Once all values for a row are entered into the Campus fields. Click the Save icon.
  4. Click New and begin this process again, starting with the next row in the table. 

Name Seq in Data File Map to Data Field Date Format Action Performed on this Field Strip Leading Zeros Number Format
Extended Strand 1 Result 19 MCA Math Reporting Strand 1.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Extended Strand 1 Scale Score 18 MCA Math Reporting Strand 1.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Extended Strand 2 Result 21 MCA Math Reporting Strand 2.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Extended Strand 2 Scale Score 20 MCA Math Reporting Strand 2.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Extended Strand 3 Result 23 MCA Math Reporting Strand 3.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Extended Strand 3 Scale Score 22 MCA Math Reporting Strand 3.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Extended Strand 4 Result 25 MCA Math Reporting Strand 4.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Extended Strand 4 Scale Score 24 MCA Math Reporting Strand 4.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Math Result 16 MCA Math.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Math Scale Score 15 MCA Math.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
School Number 4 Score.schoolID Ignore - not a selectable field Import Data Unchecked No decimal or use as is
state ID 10 student.stateID Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Test Date 7 MCA Math.date MM/DD/YY or MM/DD/YYYY Import Data Unchecked No decimal or use as is
Test Grade 9 MCA Math.testingGrade Ignore - not a selectable field Import Data Unchecked No decimal or use as is

Once all data is mapped:

  1. Click the Insert or update values specified in the import to the existing record and keep all other existing data as is radio button.
  2. Select an Import Mode of 'Test'.
  3. Select an Output Format.
  4. Select Test.

Review the import test results to ensure its accuracy and correct any identified issues. 

If you have already gone through this process and are importing this data for a second (or third, or fourth, etc) time, click the Replace existing record and remove data not specified in the import radio button. 

Once you have reviewed the data and are ready to import:

  1. Click the Insert or update values specified in the import to the existing record and keep all other existing data as is radio button.
  2. Select an Import Mode of 'Import'.
  3. Select the Import button. 

MCA math data has now been properly imported into Campus. Move onto importing MCA reading results. 

Import MCA Reading Results

The sections below describe the field values required when mapping raw file data to assessments created in Steps 1 and 2. Once all fields for a single table are mapped, you are ready to import the data. Do not create and add mappings for more than one table or section at the time. 

To begin mapping data for MCA Reading results:

  1. Click the New icon.
  2. Start with row 1 in the table below and enter field values as they are defined in the table.
  3. Once all values for a row are entered into the Campus fields. Click the Save icon.
  4. Click New and begin this process again, starting with the next row in the table. 

Name Seq in Data File Map to Data Field Date Format Action Performed on this Field Strip Leading Zeros Number Format
Reading Achievement Level 16 MCA Reading.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Reading Scale Score 15 MCA Reading.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Reading Strand 1PL 19 MCA Reading Reporting Strand1.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Reporting Strand 1 Scale Score 18 MCA Reading Reporting Strand 1.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Reading Strand 2PL 21 MCA Reading Reporting Strand2.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Reporting Strand 2 Scale Score 20 MCA Reading Reporting Strand 2.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Reading Strand 3PL 23 MCA Reading Reporting Strand3.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Reporting Strand 3 Scale Score 22 MCA Reading Reporting Strand 3.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Reading Strand 4PL 25 MCA Reading Reporting Strand4.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Reporting Strand 4 Scale Score 24 MCA Reading Reporting Strand 4.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
School Number 4 Score.schoolID Ignore - not a selectable field Import Data Unchecked No decimal or use as is
state ID 10 student.stateID Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Test Date 7 MCA Reading.date MM/DD/YY or MM/DD/YYYY Import Data Unchecked No decimal or use as is
Test Grade 9 MCA Reading.testingGrade Ignore - not a selectable field Import Data Unchecked No decimal or use as is

Once all data is mapped:

  1. Click the Insert or update values specified in the import to the existing record and keep all other existing data as is radio button.
  2. Select an Import Mode of 'Test'.
  3. Select an Output Format.
  4. Select Test.

Review the import test results to ensure its accuracy and correct any identified issues. 

 If you have already gone through this process and are importing this data for a second (or third, or fourth, etc) time, click the Replace existing record and remove data not specified in the import radio button. 

Once you have reviewed the data and are ready to import:

  1. Click the Insert or update values specified in the import to the existing record and keep all other existing data as is radio button.
  2. Select an Import Mode of 'Import'.
  3. Select the Import button. 

MCA reading data has now been properly imported into Campus. Move onto importing MCS science results.

Import MCA Science Results

The sections below describe the field values required when mapping raw file data to assessments created in Steps 1 and 2. Once all fields for a single table are mapped, you are ready to import the data. Do not create and add mappings for more than one table or section at the time. 

To begin mapping data for MCA Science results:

  1. Click the New icon.
  2. Start with row 1 in the table below and enter field values as they are defined in the table.
  3. Once all values for a row are entered into the Campus fields. Click the Save icon.
  4. Click New and begin this process again, starting with the next row in the table. 

Name Seq in Data File Map to Data Field Date Format Action Performed on this Field Strip Leading Zeros Number Format
Science Achievement Level 16 MCA Science.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Scale Score 15 MCA Science.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 1PL 19 MCA Science Reporting Strand1.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 1 Scale Score 18 MCA Science Reporting Strand 1.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 2PL 21 MCA Science Reporting Strand2.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 2 Scale Score 20 MCA Science Reporting Strand 2.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 3PL 23 MCA Science Reporting Strand3.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 3 Scale Score 22 MCA Science Reporting Strand 3.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 4PL 25 MCA Science Reporting Strand4.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 4 Scale Score 24 MCA Science Reporting Strand 4.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 5PL 27 MCA Science Reporting Strand5.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 5 Scale Score 26 MCA Science Reporting Strand 5.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 6PL 29 MCA Science Reporting Strand6.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 6 Scale Score 28 MCA Science Reporting Strand 6.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 7PL 31 MCA Science Reporting Strand7.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 7 Scale Score 30 MCA Science Reporting Strand 7.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 8PL 33 MCA Science Reporting Strand8.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 8 Scale Score 32 MCA Science Reporting Strand 8.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 9PL 35 MCA Science Reporting Strand9.result Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Science Strand 9 Scale Score 34 MCA Science Reporting Strand 9.scaleScore Ignore - not a selectable field Import Data Unchecked No decimal or use as is
School Number 4 Score.schoolID Ignore - not a selectable field Import Data Unchecked No decimal or use as is
state ID 10 student.stateID Ignore - not a selectable field Import Data Unchecked No decimal or use as is
Test Date 7 MCA Science.date MM/DD/YY or MM/DD/YYYY Import Data Unchecked No decimal or use as is
Test Grade 9 MCA Science.testingGrade Ignore - not a selectable field Import Data Unchecked No decimal or use as is

Once all data is mapped:

  1. Click the Insert or update values specified in the import to the existing record and keep all other existing data as is radio button.
  2. Select an Import Mode of 'Test'.
  3. Select an Output Format.
  4. Select Test.

Review the import test results to ensure its accuracy and correct any identified issues. 

 If you have already gone through this process and are importing this data for a second (or third, or fourth, etc) time, click the Replace existing record and remove data not specified in the import radio button. 

Once you have reviewed the data and are ready to import:

  1. Click the Insert or update values specified in the import to the existing record and keep all other existing data as is radio button.
  2. Select an Import Mode of 'Import'.
  3. Select the Import button. 

MCA data has now been properly imported into Campus. Move onto the next Strand. 

That's it! You have successfully imported all MCA assessment data into Campus! 

Related Articles

Was this helpful?
Thank you for your feedback!
User Icon

Thank you!

Copyright ©️ 2010-2023 Infinite Campus, Inc. All rights reserved. | Terms of Use | Privacy Policy | infinitecampus.com