Importing TFAR test data into Aware requires a specific file format. To begin, download a CSV file of the TFAR test data available on Cambium’s TFAR platform. For additional information on accessing that export, refer to Cambium’s TFAR help documentation.
Note: The file should import successfully into Eduphoria without needing to apply any modifications to the file. Follow the troubleshooting steps listed below only if the initial import fails.
Troubleshooting Failed TFAR Imports
Check that the following criteria are met:
- All of the fields in the table above are present. If any required fields are not present, add them to the spreadsheet and give them the proper label. This can be done manually.
- The correct name is used in the column headers. For exact column headers, refer to the TFAR Required Fields table below.
- All of the fields have the correct value, including those that are manually added by the user. For format specifications, refer to the TFAR Required Fields table below.
- The file is saved in a CSV format.
- If any required fields are not populated, you might need to manually fill in the missing data.
- Some fields require data in the column, and other fields do not. If a field does not require data, the column must still exist in the file. Any optional field can be empty. If additional columns exist other than the ones listed below, they will still be imported. However, not all of the data in the extra fields will be available in a data view.
For additional help using the TFAR exporter, refer to Cambium’s TFAR help resources.
Note: When making changes to the file, ensure it saves as a CSV file and ensure the date fields are not overridden to another format.
TFAR Required Fields
Note: Do not include quotation marks in the column header. Quotation marks are used in the table below only to assist in identifying spaces in the column header.
Field Header Value | Format (if applicable) | Expected Values |
“Test Name” | Input the test name you want to display in the quick view. The importer automatically includes any EOC grade in the name. | |
“ENROLLED GRADE” | Choose one:
|
|
“DATE-OF-BIRTH” | MMDDYYYY | |
“FIRST-NAME” | ||
“LAST-NAME” | ||
“PEIMS-ID” | ||
“TSDS UID” | ||
“LOCAL-STUDENT-ID” | ||
"County-District-Campus ID" | ||
“Test Group” | TFAR | |
“Test Subject” | Choose one:
|
|
“Test OppNumber” | ||
“Opportunity Key” | ||
“Test Reason” | ||
“Test Completion Date and Time” | MMDDYYYY | |
“Percent Correct” | ||
“Raw Score “ | ||
“Item Points Possible” | ||
“Item Student Scores” | ||
“SE Alignment” |
*The TFAR importer automatically includes the grade if it is an EOC. When naming the assessment, consider putting the grade level, subject, and “TFAR” in the title.
**The Test Subject, Test Grade, and Test Group fields must be manually input before importing. Select one of the options in the “Expected Value” column.
Comments
0 comments
Article is closed for comments.