Open

TestHound

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 4 on details on your state’s data requirements.

Minimum Data Sets:

The following data sets are required for all TestHound districts:

1. Schedules Data: Contains current semester/term course schedules for your students. These are the courses that students are taking right now.

2. Students Data: Contains basic data for your students.

3. Teachers Data: Contains basic data for your testing administrators; staff that are in the room overseeing students taking their standardized tests.

4. Users: Contains basic information (not passwords) for your district/school testing administrators who will be using TestHound.

Additional Data Sets:

These additional data sets may be required for your district:

1. Demographics Data: Contains additional data for TX state reporting; required for TX districts.

2. 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.

Hostname: uploads.testhound.com

Port: 22

Credentials: will be provided by your DI Engineer in a separate email. This one-click link will expire in 48hrs.

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.

Open

1 - Manage Data in SIS – Sending data to TestHound begins with adding, updating, and maintaining the accuracy of course request, student, and teacher data within your SIS.

2 - Export Data from SIS – Your district IT, with help from your TestHound Data Integrations Engineer, will configure SIS data exports that create the TestHound data files.

3 - Send Files to EAI – Your SIS/District IT will send data files to TestHound on a regular basis (via SFTP or API, depending on your SIS).

4 - Maintain Servers – TestHound will create and maintain servers for the purpose of securely retrieving data from your SIS.

5 - ETL & Data Security – EAI will retrieve the data files from SFTP, encrypt, and store data using AWS. See EAI’s Data Privacy page for more information on how EAI secures your data.

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.

Data Requirements

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:

Data sets sent via SFTP

User List:

Please also complete and email the below user list to your DI Engineer.

Florida - Additional Data

Students’ accommodation data is also required for Florida districts. This data set will be sent with the other files via SFTP.

Accommodations Data Template:

Accommodations Data Requirements:

Texas - Additional Data

Students' demographics data is also required by Texas districts. This data set will be sent with the other files via SFTP.

Texas Data Templates (all files):

Demographics Data Requirements:

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.

1. The TX data templates.

2. Your district’s SFTP creds for TestHound.

3. cc your DI Engineer to the email.

Complete User List:

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.

All State Cognos Templates:

Texas Demographics Cognos Template:

Instructions:

1. Download and import the above templates to Cognos.

2. Run and review the CSV exports; edit the templates, as needed.

3. 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.

California Plugin File:

Indiana Plugin File:

Texas Plugin File:

Instructions - All States:

Instructions - Indiana Accommodations File:

Coming Soon. Contact your DI Engineer for assistance.

Instructions - Texas Demographics File:

Skyward Q

Follow the instructions below to add the built-in TestHound exports within Skyward Q:

Instructions - All Districts:

Follow the steps below in Skyward Q’s Report Manager to add the following reports:

1. In Report Manager, search for “Test Hound” to locate the Students, Schedules, and Teachers reports.

2. Search for Test Hound and add the following Reports:

3. Open the report and click on Scheduled Reports. Then Add Scheduled Report.

4. Enter a report name of your choice and a Start Time before 1am CST.

5. Click on Save & Add Export Location.

6. Enter the Skyward @ Report Name from the chart in Step 1, above.

7. Click Add FTP/SFTP Connection or search for your existing Pathways SFTP connection.

   1. Use the hostname and credentials provided by your Pathways DI Engineer to add a new SFTP connection in Skyward Q. Please click Test Connection before saving.

8. Save and manually send the file. Then email your Pathways DI Engineer to notify them that the files have been sent.

See Skyward Q’s Technical Knowledge Base for more information on configuring data exports.

Instructions - Texas Demographics File:

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.

Download File Exports - Students, Schedules, and Teachers:

Download Texas Demographics Exports:

Instructions: