Tool Search: Assessment Center
Assessment Data Mapping and Importing
The Assessment Center allows schools to import local / district student test scores and assessment results from external testing agencies into Infinite Campus. Imported scores are displayed on the Student Assessment screen. Scores may also be displayed on a student’s transcript.
Assessment Center
Prerequisite
If the assessment does not exist, it must be created under Step 1- Test Detail. An assessment name is required. Users can then define the necessary details for the assessment including:
- Test Information
- Test Type
- Display Settings
- Score Fields
- Result / Proficiency Statuses
- Child Tests
See the Assessment Center - Test Detail article for more information.
Data Detail File
Step 2 - Data Detail File becomes available when either the 'Save' button or the 'Save & Next' button is selected after the Test Details are documented. If the assessment was previously created, select it on the Assessment Center homepage and then select the Data Detail File icon at the top of the screen OR select the 'Save & Next' button at the bottom of the page to advance to the Data Detail File screen.
A Student Identifier and 'Score.date' are required for Step - 3 Map Data. Make sure those data elements are included in the source file before uploading.
Data files are NOT saved for future use.
Assessment Center- Step 2 Data File Detail
Upload a Data File
| Done | Task |
|
Select a data file to upload. The file is used later in Step 3 - Map Data to create/edit the data mapping to be imported. Only Comma-Delimited file types are currently accepted. This file type, also known as a Comma-Separated Value (.csv), separates each value in the file with a comma. It is a standard file type easily read and understood by different data manipulation programs. If the wrong file is uploaded in error, select the 'X' icon on the right to remove the file.
| |
|
Mark the Source File Includes Header checkbox if the data file contains a header row for identification purposes. The first row of the file is ignored when importing. | |
|
Indicate the type of identifier to link test scores to students. Student Identifier is a required data mapping element. | |
| Select 'Save' or 'Save & Next'. |
Data File Detail Editor
| Field | Information |
| Upload Data File | |
| Select Your Data File to Upload |
Upload options:
|
| Source File Includes Header |
Mark the checkbox if the data file contains a header row for identification purposes. The first row of the file is ignored when importing. 'Fuzzy Matching' is applied to column names from the source file to field names in the test score table in Step-3 Map Data when this is selected. |
| Which fields will map to student identifiers? | Select the type of identifier to be used in linking test scores to students:
Student Identifier is a required data mapping element. |
Step 3 - Map Data is an option when either the 'Save' button or 'Save & Next' button is selected after the assessment data file has been uploaded. This step allows the user to map the data from the uploaded assessment data file to the database fields for import to a student's record in Campus.
A Student Identifier and 'Score.date' are required data mapping elements.
Assessment Center- Step 3 Map Data
Map to Database Field
| Done | Task |
|
Use the drop list options to map each column to a Campus database field. Type the name of the field in the search area to filter options. | |
Select the Options button to confirm or modify the following:
| |
|
Update / correct action items when the column is flagged with a red exclamation mark | |
|
Select the 'Save' button or the 'Save & Next' button after the mapping is completed and all action items are designated with a green check mark |
Instructions
Map the data from the selected source file to the database fields you want to import.
| Button | Information |
| About Mapping Data | Provides in-product information pertinent to the following:
|
Data Mapping Detail Fields
| Field | Information |
| Required Fields | These fields are required to be able to save.
 indicates this field still needs to be mapped. |
| Source File |
Lists identifying information about the uploaded data file including:
|
Data Columns for Import Fields
| Field | Information |
| Expand All | Expands all minimized columns. |
| Show All Hidden |
Displays all hidden columns. |
| Apply Fuzzy Matching Logic |
This only displays when the 'Source File Includes Header' checkbox is marked on Step 2 - Data File Detail.
Fuzzy Matching applies automatically only when Step 3-Map Data has not been saved. Fuzzy Matching logic is applied to unmapped columns. The logic only looks at the column heading and compares it to all the score fields available in 'dbo.testScore'. |
| Show Column # / Show |
Enter the column identifier to display a hidden column. Enter the identifier number/alpha of the column you want to move to that column location. |
| Show Only Mapped Columns | Displays mapped columns when marked. |
| Only display Score Fields that were checked in Test Details | Shows mapped student identifier fields and score fields indicated in Step 1- Test Details. |
| Display Column Identifier as | Display column indicators based on the selected format:
|
Assessment Data Grid Fields
'Fuzzy Matching' is applied to column names from the source file to field names in the test score table when the 'Source File Includes Header' checkbox is marked on Step 2- Data File Detail.
| Field | Information |
| X | Select to hide the column. |
| Number/Alpha |
Column identifier. |
| Column Header |
Displays the column header from source file. |
| Map to database field | Drop list options to map the column to a database field. Type the name of the field in the search area to filter options. |
| Options |
Column Options
|
Green Check Mark  |
"Action on" and all required options have been set. |
Red Exclamation Mark  |
Action item needs to be set. |
Test Mapping
Step 4 -Test Mapping becomes available when either the 'Save' button or the 'Save & Next' button is selected after the mapping is completed with no action items designated with 
. This step allows the user to test data mappings for accuracy and make changes as needed before importing.
'Save & Test' or 'Save & Batch Test' must be run before advancing to Step 5-Import Data. Testing helps greatly reduce or even completely eliminate the cleanup action needed after the assessment data has been imported.
Test Mapping Editor Fields
| Field | Information |
| Update Options |
|
| Batch Queue Results |
Displays a list of the batch test items including the:
The list can be filtered by entering a date range using the Start Date / End Date fields. |
| Save & Test / Save & Batch Test |
One of these options must be selected before advancing to Step 5 - Import Data. Testing helps to greatly reduce or even completely eliminate the amount of cleanup action needed after the assessment date file has been imported. It is recommended that you use the Save & Batch Test option if you are testing large files. The standard Save & Test process may time out because of district browser and router settings. Refer to the Batch Queue article for more information. |
Test Mapping Example
A report displays listing the potential issues. This is a TEST. No data is written to the database. All errors and warnings should be resolved before importing data to the Campus database.
Test Mapping Example
Test Mapping Fields
| Field | Information |
| Test Mapping | Name of data file. |
| Timestamp |
Day, date, and time the test was generated. |
| Username |
Name assigned to the user who generated the test. |
| Update Option | Indicates the Update Option used to test the assessment mapping.
|
| Test Mapping Import Results | |
| Total Valid Records for | Displays the name of the uploaded file and the number of valid records. |
| Total Valid Records | The number of valid records. |
| Error Count | The number of errors detected in the mapping. These should be corrected before the import. |
| Warning Count | The number of warnings detected in the mapping. These should be addressed before the import. |
| Errors / Line # | The line number where the error exists. |
| Error Code | The code of the error. |
| Error Message | Message identifying/explaining the error. |
| Error Details | Additional error information (if applicable). |
| Warnings / Line # | The line number where the warning exists. |
| Warning Code | The code of the warning. |
| Warning Message | Message identifying/explaining the warning. |
| Warning Details | Additional warning information (if applicable). |
Import Data
Step 5 - Import Data is an option when either the 'Save & Test' button or the 'Save & Batch Test' button is selected on the Test Mapping screen. This step allows the user to import the mapped data to their Campus system after all errors and warnings from the test mapping have been resolved.
Assessment Center - Step 5 Import DataImport Data Editor
| Field | Information |
| Update Options | Select an update option to import the assessment data.
|
| Batch Queue Results |
Displays a list of the batch import items including the:
The list can be filtered by entering a date range using the Start Date / End Date fields. |
| Save & Import / Save & Batch Import |
If you are importing large files, it is recommended that you use the Save & Batch Import option. The standard Save & Import process may time out because of district browser and router settings. Refer to the Batch Queue article for more information. |
