ACR - Upload Academic Results

Overview

The TASS.web Academic Reporting ‘Upload Academic Results’ program lets you upload academic result data from a CSV file into your TASS.web database.

Click here for an Administrator Note.

User Security Permissions

The ‘Upload Academic Results’ permission point regulates user access to this program. It can be enabled in TASS.web Student Admin > Users > User Maintenance or Security Role Permissions.

Before using this program, subjects must be assigned to students, and result formats must be set up for the subject and reporting period in TASS.web Student Admin > Academic Reporting > Setup Information > Assessment Setup on the ‘Result Formats’ tab.

General Tab

Use the fields on the ‘General’ tab to select the parameters for your upload and select the file you want to upload.

Fields that require further explanation
Reporting Year and Period	Select the ‘Reporting Year and Period’ for which you will be uploading academic result data. For a Reporting Year and Period to appear in this list, the 'IA Lock' status of the Result Period, must be set to one of the following: Teacher Class Access. Teacher Class Access (Disable Progressive Assessment). Restricted Supervisor Access. Unrestricted Supervisor Access. The ‘IA Lock’ can be managed in TASS.web Student Admin > Academic Reporting > Setup Information > Reporting Setup on the 'Result Periods' tab.
Subject	If you are uploading academic results for a single subject, enter the 'Subject Code' or use the drop-down list to make your selections. For single subjects, your file format should conform to Format 1 or Format 2. If you are uploading academic results for multiple subjects, leave this field blank. For multiple subjects, your file format should conform to Format 3 or Format 4.
Filename	Use the 'Choose File' button to locate the `.csv` file that you intend to upload. Refer to the format information below for more information about acceptable `.csv` file formats. Format 1 Format 2 Format 3 Format 4 Remove the 'Field Contents' header row before uploading the `.csv` file.
Overwrite Existing Data	Select this checkbox to overwrite existing results in the TASS.web database. By default, this checkbox is unticked.

Click the 'GO' button.

The system will validate the file to ensure it meets one of the formats described below.

If validation is unsuccessful, the program will produce an exception report. You will need to address the issues in the .csv file and re-import the data.

Format 1

Use this file format when a ‘Subject Code' has been entered in this program’s ‘Subject' field, and there is more than one 'Objective Code’ and 'Result’ record per student.

Remove the 'Field Contents' header row before uploading the .csv file.

CSV Column	Field Contents	Field Type/Size	Field Description
A	Student Code	Maximum 8 Characters	Mandatory.
B	Student Name	Maximum 40 Characters	Optional (can be left blank).
C	Objective Code	Maximum 4 Characters	Mandatory. This must be a valid ‘Objective Code' configured in the Result Format for the selected ‘Subject’ and 'Reporting Year and Period’ in TASS.web Student Admin > Academic Reporting > Setup Information > Assessment Setup on the ‘Result Formats’ tab.
D	Result	Maximum 7 Characters	Mandatory. This must be a ‘Valid Result’ for the ‘Assessment Code’ selected as the grading structure for the 'Objective Code' in TASS.web Student Admin > Academic Reporting > Setup Information > Assessment Setup on the ‘Result Formats’ tab, for the selected ‘Subject’ and 'Reporting Year and Period’.
E	Objective Code	Maximum 4 Characters	This format (Format 1) can have multiple ‘Objective Code’ and ‘Result' columns in the CSV. The minimum number of CSV columns is 4, but it can also have 6, 8, 10, etc. (in multiples of 2). You can repeat the 'Objective Code' and 'Result' columns as many times as needed.
F	Result	Maximum 7 Characters

Format 2

Use this file format when a ‘Subject Code' has been entered in this program’s ‘Subject’ field, and there is only one ‘Objective Code’ and 'Result’ record per student.

Remove the 'Field Contents' header row before uploading the .csv file.

All Student Codes must have data in CSV Columns C and D.

CSV Column	Field Contents	Field Type/Size	Field Description
A	Student Code	Maximum 8 Characters	Mandatory.
B	Student Name	Maximum 40 Characters	Optional (can be left blank).
C	Objective Code	Maximum 4 Characters	Mandatory. This must be a valid ‘Objective Code' configured in the Result Format for the selected ‘Subject’ and 'Reporting Year and Period’ in TASS.web Student Admin > Academic Reporting > Setup Information > Assessment Setup on the ‘Result Formats’ tab.
D	Result	Maximum 7 Characters	Mandatory. This must be a ‘Valid Result’ for the ‘Assessment Code’ selected as the grading structure for the 'Objective Code' in TASS.web Student Admin > Academic Reporting > Setup Information > Assessment Setup on the ‘Result Formats’ tab, for the selected ‘Subject’ and 'Reporting Year and Period’.

Format 3

Use this file format when a ‘Subject Code' has not been entered in this program's ‘Subject’ field and there is more than one ‘Objective Code’ and 'Result’ record per student.

Remove the 'Field Contents' header row before uploading the .csv file.

CSV Column	Field Contents	Field Type/Size	Field Description
A	Student Code	Maximum 8 Characters	Mandatory.
B	Student Name	Maximum 40 Characters	Optional (can be left blank).
C	Subject Code	Maximum 15 Characters	Mandatory. This must be a valid ‘Subject Code' allocated to the Student in TASS.web Student Admin > Student Records > Student Information > Students on the 'Subjects’ tab. A Result Format setup must also be set up for the selected ‘Subject’ and 'Reporting Year and Period’ in TASS.web Student Admin > Academic Reporting > Setup Information > Assessment Setup on the 'Result Formats’ tab.
D	Objective Code	Maximum 4 Characters	Mandatory. This must be a valid ‘Objective Code' configured in the Result Format for the selected ‘Subject’ and 'Reporting Year and Period’ in TASS.web Student Admin > Academic Reporting > Setup Information > Assessment Setup on the ‘Result Formats’ tab.
E	Result	Maximum 7 Characters	Mandatory. This must be a ‘Valid Result’ for the ‘Assessment Code’ selected as the grading structure for the 'Objective Code' in TASS.web Student Admin > Academic Reporting > Setup Information > Assessment Setup on the ‘Result Formats’ tab, for the selected ‘Subject’ and 'Reporting Year and Period’.
F	Objective Code	Maximum 4 Characters	This format (Format 3) can have multiple ‘Objective Code’ and ‘Result' columns in the CSV. The minimum number of CSV columns is 5, but it can also have 7, 9, 11, etc. (in multiples of 2). You can repeat the 'Objective Code' and 'Result' columns as many times as needed.
G	Result	Maximum 7 Characters

Format 4

Use this file format when a ‘Subject Code' has not been entered in this program’s ‘Subject’ field, and there is only one Objective/Results record per student.

Remove the 'Field Contents' header row before uploading the .csv file.

All Student Codes must have data in CSV Columns C, D and E.

CSV Column	Field Contents	Field Type/Size	Field Description
A	Student Code	Maximum 8 Characters	Mandatory.
B	Student Name	Maximum 40 Characters	Optional (can be left blank).
C	Subject Code	Maximum 15 Characters	Mandatory. This must be a valid ‘Subject Code' allocated to the Student in TASS.web Student Admin > Student Records > Student Information > Students on the 'Subjects’ tab. A Result Format setup must also be set up for the selected ‘Subject’ and 'Reporting Year and Period’ in TASS.web Student Admin > Academic Reporting > Setup Information > Assessment Setup on the 'Result Formats’ tab.
D	Objective Code	Maximum 4 Characters	Mandatory. This must be a valid ‘Objective Code' configured in the Result Format for the selected ‘Subject’ and 'Reporting Year and Period’ in TASS.web Student Admin > Academic Reporting > Setup Information > Assessment Setup on the ‘Result Formats’ tab.
E	Result	Maximum 7 Characters	Mandatory. This must be a ‘Valid Result’ for the ‘Assessment Code’ selected as the grading structure for the 'Objective Code' in TASS.web Student Admin > Academic Reporting > Setup Information > Assessment Setup on the ‘Result Formats’ tab, for the selected ‘Subject’ and 'Reporting Year and Period’.