Exercise #3 - Create Sample Data Map
- Jason Hoekstra
Owned by Jason Hoekstra
Step #1 - Define a CSV-to-ODS mapping for Student Assessements.
In the top menu bar, click [Maps]. This takes you to the Maps listing, showing zero maps so far.
Click [Add Data Map]
Fill out the Data Mapper form:
CSV File:
- Select the sample "Assessment-2018-GrandBendElementary.csv" and click [Upload].
- A grid will appear showing the first few rows of the CSV file.
- Select the sample "Assessment-2018-GrandBendElementary.csv" and click [Upload].
Map Name: Student Assessments End to End Testing
Map To Entity: Student Assessments
- Once this entity is selected, many new form fields appear under "CSV Fields".
CSV Fields:
Note that some values here are case sensitive, so enter them exactly as described here.
Assessment Reference:
- Identifier:
- Data Source: static
- Static Value: LAB-ASSESSMENT-2018
- Namespace:
- Data Source: static
- Static Value: http://ed-fi.org/Assessment/Assessment.xml
- Identifier:
Student Reference:
- Student Unique Id:
- Data Source: column
- Source Column: STUDENT_ID
- Default Value: 0
- Student Unique Id:
Administration Date:
- Data Source: static
- Static Value: 08-01-2018
Identifier:
- Data Source: static
- Static Value: LAB-ASSESSMENT-2018
Performance Levels:
- Make no selections here. These are not required for this example.
Score Results:
- Assessment Reporting Method Type:
- Data Source: static
- Static Value: Raw score
- This value is case sensitive! Be sure to enter it as shown.
- Result Datatype Type:
- Data Source: static
- Static Value: Integer
- Result:
- Data Source: column
- Source Column: OVERALL_SCORE
- Assessment Reporting Method Type:
Student Objective Assessments:
- Make no selections here. These are not required for this example.
Review the above settings for correctness, and then click [Save Map].
Your new map now appears in the Maps listing.