...
Welcome to TestHound Data Integration!
Follow this guide to send data from your SIS to TestHound
Table of Contents | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Introduction
TestHound is a premiere education administration software. Your district and school-level testing coordinators will use TestHound to assign, manage, and report standardize tests/scores for your students.
Data Sets:
TestHound will require at least four of the below data from your SIS. See Part 4on details on your state’s data requirements.
...
Demographics Data: Contains additional data for TX state reporting; required for TX districts.
Accommodations Data: Contains data for student testing accommodations. In most cases, this data will be sent directly to TestHound from your Accommodations Vendor.
Adding Users:
Please email the completed User List to your DI Engineer, who will add the bulk of your users to TestHound. Additional users will be added/removed by your district’s TestHound admin.
SFTP & Send Schedules
Data sets (except the user list) will be sent to TestHound using SFTP. Please schedule all files to send nightly (including weekends) before 1am CST.
...
Please send the User List directly to your DI Engineer via email. For security reasons, please do not send any other data sets via email.
Data Transfer & Responsibilities
TestHound views your SIS as the Single Source of Truth for all data. Please review the steps below for how data is sent from your SIS to TestHound.
...
6 - EAI Product -EAI will display your district data in TestHound.
Timeline & Checklist
Ideally, your TestHound data Integration will take two weeks to complete. The actual timeframe will depend on your regional center and other 3rd parties who may need to send data to TestHound.
Day 1: Tech KO:
A meeting with your TestHound DI Engineer to review the data requirements and/or configure exports in your SIS. This meeting can be up to 45 minutes.
Weeks 1: Send First Files:
By the end of the first week, SFTP will be configured and the first files (data sets) sent to TestHound.
Please configure all files to be sent nightly (including weekends) before 1am CST.
Week 2: Data Validation:
Your TestHound DI Engineer will review and validate the sent data, then follow up with you for any needed adjustments to the exports.
After: Data Management:
Once the data in TestHound is validated, you will continue to maintain data within your SI; you may be contacted by your staff if data abnormalities are discovered in TestHound.
Please reach out to your DI Engineer if you need assistance troubleshooting any of these data abnormalities.
Anchor | ||||
---|---|---|---|---|
|
See below for TestHound’s data requirements. Note that Florida and Texas districts will need to send additional data sets.
All States
The following data sets are required by all districts using TestHound:
...
Expand | ||
---|---|---|
| ||
Instructions: Download and fill out the Users Template in the Downloads section below. Then email the completed Users List to your TestHound DI Engineer. Contents: Account information for district and school testing coordinators who will be using TestHound File Naming Convention: NA Best Practices:
Roll Types: Data Requirements: Example Data: |
...
Florida - Additional Data
Students’ accommodation data is also required for Florida districts. This data set will be sent with the other files via SFTP.
...
Expand | ||
---|---|---|
| ||
Contents: data for student testing accommodations. Ideally, all accommodations data should be sent on a single file. Please email your TestHound DI Engineer if you need to send multiple accommodation files. File Naming Convention: d_th_ia_ST_ST-District-ID_auto1.csv Best Practices:
Data Requirements: Example Output: |
...
Texas - Additional Data
Students' demographics data is also required by Texas districts. This data set will be sent with the other files via SFTP.
...
Expand | ||
---|---|---|
| ||
Contents: additional student demographics data for TX state reporting. File Naming Convention: d_th_demographics_ST_ST-District-ID.csv Best Practices:
Data Requirements: Example Output: |
Instructions for Exporting SIS Data:
Ascender
Instructions:
Contact your Regional Center and provide them with the following information so they can open a ticket and begin sending the Students, Schedules, Teachers, and Demographics data sets to TestHound.
...
Please complete the User List and email it to your DI Engineer; users are the one data set not provided by your Regional Center.
...
eSchool & eSchoolPLUS
Locate your state, download the SQL scripts, and follow the instructions below.
...
Download and import the above templates to Cognos.
Run and review the CSV exports; edit the templates, as needed.
Schedule and send each CSV using the SFTP details provided by your DI Engineer.
...
PowerSchool
Locate your state, download the plugin file, and follow the instructions below.
...
Expand | ||
---|---|---|
| ||
Install the unzipped plugin file at your District Office. Then enable the TestHound plugin file.
*Note - your plugin name may differ from the one shown in the screenshot. |
...
Expand | ||
---|---|---|
| ||
Configuring Schedules Export
Assigning/Scheduling SFTP
|
Expand | ||
---|---|---|
| ||
Configuring Students Export
Assigning/Scheduling SFTP
|
Expand | ||
---|---|---|
| ||
Configuring Teachers Export
Assigning/Scheduling SFTP
|
...
Expand | ||
---|---|---|
| ||
Configuring Demographics Export
Assigning/Scheduling SFTP
|
...
Skyward Q
Follow the instructions below to add the built-in TestHound exports within Skyward Q:
...
Follow the above instructions to also add the Test Hound Demographics report to Skyward Q.
...
Skyward SMS
Download the Skyward SMS exports for your state and follow the instructions below.
...