Still using our Classic Interface? Select here to view the help document.
In this lesson, users will learn how to validate behavior data for eduCLIMBER. When importing behavior data into eduCLIMBER, some of the records may need to be validated. The most common validations for behavior data are schools, users, locations, responses, and behaviors.
Students
If the import tool does not recognize a student contained in one of the records, the data will need to be validated. The validation tool displays the records that need attention. There are two options when validating student records: match to an existing student record or create a new student record. Each row will have either green, yellow, or black text.
Green text: Match to an existing student record
- A student record with green text indicates that the validation tool doesn’t fully recognize the student, but has found an existing record that is a very close match to the incoming record. If the incoming student record matches the selected existing student record, select the Match checkbox. Otherwise, create a new student record by selecting the New checkbox. Once all changes are completed, remember to select Save.
Yellow text: Potential match to an existing student record
- A student record with yellow text indicates that the validation tool doesn’t fully recognize the student, but has found an existing student record that is a potential match. Review the potential match and determine whether or not the existing student record matches the incoming record or if a new student record should be added to eduCLIMBER. If the student record is a match, select the Match checkbox but if the student record should be new, select the New checkbox.
Black text: student not located in the import file
- A student record with black text indicates that the validation tool couldn’t find an existing student listed in the import file. This doesn’t always mean that the student doesn’t exist, it just means that the validation tool could not find an existing student with the exact same name. In these circumstances, the following steps will help verify if it is an existing student or a new student record.
- Check to see if the student exists in eduCLIMBER by double-selecting the No Match area to generate a drop-down to search for the student.
- Search by name to see if the student exists. If a match cannot be found for the student, exit the student search screen and create a new student.
Schools
If the validation tool doesn’t recognize a school in the upload file, indicate how to handle the school. There are four options for validating schools: create, alias, exclude, and ignore.
Create the school
- This will add a new school building in eduCLIMBER. The new building will appear in drop-down menus and other areas across the platform.
Set an Alias for the school
- An alias allows the school named in the upload file to be matched to an existing school in eduCLIMBER. For example, there may be an existing elementary named Climberville Elementary but the assessment file lists the school as eduCLIMBER Elementary. An alias can be created so that any time eduCLIMBER sees eduCLIMBER Elementary it is automatically associated with Climberville Elementary.
Exclude the school
- Exclude allows the school record and all associated data to be completely ignored. The data associated with the school record will not be imported into eduCLIMBER.
Ignore the school
- Ignore allows the building to be ignored but still imports all behavior data. The behavior data will be tied to the student and buildings they may be rostered to through other data imports.
Users
If the validation tool does not recognize a user in the behavior upload, the data will need to be validated. Users will either be matched to an existing user account or created as new users.
Match the user to an existing account:
- To match the incoming user record to an existing user account, select the Match User column and search for an existing account. After selecting an existing user account, select the Match checkbox and then select Save.
Add a new user:
- If the user does not already exist in eduCLIMBER, select the New checkbox, and then select Save. A new user will be created when the import runs.
Locations
If the validation tool does not recognize a location in the behavior upload, the data will need to be validated. Locations will either be assigned as an existing location or created as a new location.
Assign as existing location:
- If the location in the file is similar to an existing location the incoming location can be assigned to the existing location. For example, the incoming file has a location named Outside of School and there is an existing location named Off School Grounds. Since these two locations are similar, Outside of School can be assigned as Off School Grounds. After selecting an existing location, select Save.
Create a new location:
- If the location does not already exist in eduCLIMBER, select the New checkbox, and then select Save. A new location will be created when the import runs.
Responses
If the validation tool does not recognize a response in the behavior upload, the data will need to be validated. Responses will either be assigned as an existing response or created as a new response.
Assign as an existing response:
- If the response in the file is similar to an existing response, the incoming response can be assigned as an existing response. For example, the incoming file has a response named Conference/Parent and there is an existing response named Conference with Parent. Since these two responses are similar, Conference/Parent can be assigned as Conference with Parent. After selecting an existing response select Save.
Create New Response:
- If the response does not already exist in eduCLIMBER, select the New checkbox, and then select Save. A new response will be created when the import runs.
Behaviors
If the validation tool does not recognize behavior in the behavior upload, the data will need to be validated. Behaviors will either be assigned as an existing behavior or created as a new behavior.
Assign as existing behavior:
- If the behavior in the file is similar to an existing behavior, the incoming behavior can be assigned as an existing behavior. For example, the incoming file has a behavior named Fighting and there is an existing behavior named Fight. Since these two behaviors are similar, "Fighting" can be assigned as "Fight". After selecting an existing behavior, select Save.
Create new behavior:
- If the behavior does not already exist in eduCLIMBER, check the New checkbox, and then select Save. A new behavior will be created when the import runs.
A Parent Name is used to classify behaviors as Major or Minor incidents. Usually, the behavior file will specify the severity level. However, if it does not, a Parent Name (Major or Minor) will need to be selected before assigning the behavior as an existing behavior or creating new behavior.
Next Steps
To learn more about validations, visit the Validating Data manual.