Common Assessment – Accepted Data File Layout
File must be in “CSV” Format (Comma Separated Value format)
- File cannot be compressed or zipped.
- File name cannot contain spaces.
- When naming files, only use letters, numbers, dashes or underscores.
- Uploaded assessments must have 3 or more questions.
- All column header names must match exactly.
- Include ALL columns, even if they are empty.
Common Assessment data fields accepted in OnDataSuite
Assessment results files can be exported from various common assessment systems, and are not created to follow a specific output data file format. When uploading common assessment data into the file center, files must follow a strict formating parameters and contain ONLY the following fields in the EXACT ORDER displayed in the attachment below with the correct field names:
OnDataSuite Common Assessment Crosswalk PDF
Common Assessment Template Download
Tips on how to review your file upload to make sure that it was uploaded without issue
1. Check to make sure your file did not go into the data reconciliation section of the file center. If you see your file here with a high error %age, you will need to review the file and possibly delete the file and re-upload a new file. For more information on the data reconciliation process review this KB article https://kb.ondatasuite.com/knowledge-base/4-12-data-reconciliation/
2. Run the ‘Files Loaded by Year’ report located under the Assessment > Common Assessment custom report section. This will show you the list of files that have been loaded and you can click on the totals to look at the student records and spot check for any issues.
3. Drill down to a student dashboard and review the results under the Assessment > Common Assessment location
