Export Test Data in ESGI for Better Insights
Overview:
Data can be exported from a District Admin Account to a CSV file, which can be reformatted and uploaded to any Student Information System (SIS). When using the exporting functionality of ESGI, district managed subject tabs (purple tabs) must be created with tests that teachers have used. Please see the Subject Tab Manager Support Page for details. This article contains step by step instructions on how to export test data as a one-time manual export along with instructions on how to set up a recurring export.
How to Export Test Data:
1. Click on the Settings Cog icon located at the bottom left corner of the application window. Doing so will open the settings column.
2. Click on Export Data located at the bottom of the settings column under the Export section.
3. From the Export Data page, you can either export test data or export your roster for the entire school year.
4. Click on Export Test Data. You will see the data export can be a one-time manual export or scheduled as a recurring export.
How to do a One-Time Manual Export:
1. Once you’re taken to the export screen, click the Manual Tab (see Image 1).
2. Search for the tests to include, then click on each box on the right side of each test to add them individually.
3. Click on the last box in the header row to select all tests.
4. The tests will be displayed under the Settings for Export section at the bottom of the page.
5. Select Export - Basic, Export w/ Answers, or Export w/ Questions from the Export Type dropdown. Please see this page for more information about the fields included in each option.
6. Select the desired date: Today, Marking Period Date or Custom Dates using the Export As Of Date drop down menu located to the right of the Export Type drop down.
7. Click EXPORT. When completed, the report will be displayed in the Report History
8. Click DOWNLOAD to download and save your export file.
Please Note: Districts that have integrated ESGI with Clever and import rosters can include the unique Clever ID by selecting the "Import ID" radio button, however it is unlikely these ID's match the SIS ID. "Export ID" allows you to set your SIS IDs against teachers and students. Please ensure Export IDs are set against teacher and student profiles, then select the "Export ID" radio buttons for both Teacher and Student ID Type.
(Image 1)
How to Set Up a Recurring Export:
1. Click the Scheduled tab and click ADD TEMPLATE.
2. Search for the tests that you would like to include.
3. Click on each box on the right side of each test to add them individually.
4. Click on the last box in the header row to select all tests. The tests will be displayed in the Selected Tests area at the bottom of the page.
5. Add a Template Name by typing it into the Template Name field, then use the drop-down menu to select your desired Export Type (see Image 2).
6. Click Enable Schedule (see Image 2).
7. Select the days and the time that you would like for your scheduled export to occur.
8. Click Send Email if you would like to receive an email notification when the report is ready. Additionally, you can click Send Report to SFTP for the file to be sent to the SFTP folder (see image 3).
Please Note: If “Send Email” and “Send Report to SFTP” are not checked, the report will run, but you will need to log into your account to download it.
9. Fill in the email address and/or fill in the SFTP information.
10. When all tests have been selected and settings have been chosen, click CREATE in the lower right corner of the Add Template window.
11. The data export will run on the next date/time scheduled.
(Image 2)
(Image 3)