Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 29 Next »

In addition to following the file naming and file formatting conventions described below, scan files for any issues that might prevent a file from loading correctly (e.g., letters in field for date of birth).

File naming: Each assessment file should be a comma-separated file (CSV).

The file naming convention is districtId_assessmentType_xxxxxxx.yyy where:

  • districtId is the 6-digit district id or CDN

  • assessmentType is ACT, AP, IB, SAT or TSI

  • xxxxxxx is any description you would like to add (not to exceed 50 characters)

  • yyy is the file type extension which should be .csv

  • All of the above components (except the file extension) are separated by an underscore ( _ ).

  • Example: 723406_TSI_September2020.csv.

  • Note: There should be no spaces in the file name.

File formatting: View the text and CSV files below for more detail about the required format for each assessment type.

TSI

SAT

ACT

AP

IB

Steps:

  1. Download a CSV SAT file from the district’s College Board account.

  2. Rename the file using the file naming convention described above (CDN_SAT_description.csv)

  3. Use the assessment loader to upload the SAT file.

Steps:

  1. After logging into your account on success.act.org; select 'ACT Test Scores and Reports;' navigate to the Roster tab; and select 'Student Scores.'

  2. Select options to add “Grade,' ‘Gender,’ ‘State Org Number,’ ‘District Org Number,’ and ‘School Org Number.’

  3. Download a report in CSV format.

  4. Rename the file using the file naming convention described above (CDN_ACT_description.csv)

  5. Remove the extra information before the header "Roster View: The ACT…” so the header is the first row.

  6. Use the assessment loader to upload the ACT file.

Steps:

  1. Download a CSV AP file from the district’s College Board account.

  2. Rename the file using the file naming convention described above (CDN_AP_description.csv)

  3. Use the assessment loader to upload the AP file.

Errors: Failure to comply with the file naming standard will result in the file not being uploaded and one of the following errors being generated:

  • No labels