Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This page will show the TestHound components available on the student page and how the CTC can use this page.

...

Expand
title Can I mass Upload Exclusions? (Template) (Texas Only)
How to Mass Upload Exclusions1.mp4

I. Accessing the Upload Exclusion feature

Step 2. Click on Exclusion Files in the upper right corner.

II. Creating a template to upload-please name your files uniquely so they are easily identifiable later.

Step 3. Download the template and populate it with the necessary fields

View file
nameExclusion template.csv
View file
nameExclusionTemplate Description.xlsx

DistrictID

StudentID

Grade

Course

Exclusion

Date

Note

III. Column Header-no spaces in the header titles


Column Definitions



DistrictID

Required; State defined six digit DistrictID, no dashes or spaces

StudentID

Required; District's local StudentID; 1-10 digits in length, no dashes or spaces-please NO PEIMS IDs

Grade

Optional; integer values 3-12; [Note: required for STAAR exclusions]

Course

Required; allowed values: A1, BI, E1, E2, US

Exclusion


Required; allowed values: ALT2, ARD, CBE, E1 LEP, FEX, IGC, OS/PS, SA,WVR20-each exclusion will need it's own line of student data.  Students will be listed multiple times for multiple exclusions

Date

Optional; allowed format mm/dd/yyyy; represents the date of the exclusion

Note

Optional; description or notes concerning the exclusion; 500 characters maximum

Courses


A1

Algebra I

BI

Biology

E1

English I

E2

English II

US

U.S. History

Exclusions



ALT2

STAAR Alternate 2

ARD

EOC ARD Exempt – Special Education

CBE

Credit-by-Exam (CBE)

E1 LEP

English I Special Provision – LEP (Limited English Proficient)

FEX

Foreign Exchange

IGC

IGC – Individual Graduation Committee

OS/PS

Out of State or Private School

SA

Substitute Assessment

WVR20

Waived-CVD 19



 V. Upload the Data

Step 1. Save the spreadsheet as a CSV (Comma-delimited-.csv)Note to Mac users: When saving the file, instead of choosing Save As CSV (Comma delimited), there should be an option for CSV UTF-8 (Comma delimited).  Saving it with that format will prevent upload errors associated with the file format.

Step 2. Click on the Upload Exclusions link.

Step 3. Upload the . CSV file

Step 4. When clicking on a student’s name, go to the Student Details Page (under Campus Management), the contents of the file will be applied to each student contained in the file.

Step 5. After uploading the file, check for errors and duplicates by clicking on the Upload Exclusions button.  Then the pencil beside the uploaded file.  A list of duplicate records and invalid student IDs will be listed below.

Errors

Data can be corrected manually by clicking on the student's name and editing in the PT table or the file can be deleted to remove the data from all students in the file, the file can be corrected, and then reloaded.

...