SIS Schools - Bulk Import of Marks

Bulk Import of Marks

You are able to capture multiple marks of multiple assessments on an Excel spreadsheet and import these into STASY.
To Download the Template, do the following:

Click on Examinations > Manage Marks Entry
Click on the Import Marks tab

Ensure that the Download Template radio button is selected
Select the relevant Assessment Type, Assessment Scheme, Assessment Scheme Level, Subject, Subject Variant and Assessment Events as applicable and click on the Download Template button. This will create a template where you need to capture the marks.

This will open up an Excel file that needs to be used for the mark capturing (It is important that you use this template and not amend any of the fields that are pre-populated as this may cause issues when importing the file)
Should the following message appear, click on the Yes button

Click on Enable Editing in Excel to edit the excel spreadsheet if required.
This excel spreadsheet will include all the assessment events that you selected in the above screen
You can now capture the marks that apply to the students and once completed capturing, you need to save this file in a specific format.

In Excel, once you have captured the competencies, click on File > Save As, select a relevant folder where you want to save the file
Type in a relevant file name and in the Save as Type field, select CSV (Comma delimiter) (*.csv) (if the file does not get saved as a .csv file you will not be able to import the file)

When the following message appears, click on the OK button

To Upload the Template once you have completed the mark capturing, do the following:

Click on Examinations > Manage Marks Entry
Click on the Import Marks tab
Click on the Upload Template button
Click on the Browse File button and select the file that you saved with all the captured competencies

Click on the Upload CSV File Button to upload the file into the system

The following message will appear, click OK:

The upload will appear in the screen below and will show as Pending, click on the record showing the file that you just imported and click on the Force Run button to force the job to run which will import the marks, click OK when prompted to do so.

Click on the Refresh button after a few minutes and the job should appear as Completed (in the Processing Status column)

If the job appears as Failure, this means that there are a few errors on the file that was imported. This could be due to an invalid mark being captured or an amendment made to the pre-populated fields.

Open the csv file again and check to see that all marks are captured correctly, correct any mistakes that may have been captured and reupload the file again.

Only once it says completed, has the file been uploaded successfully

To check that the marks have been uploaded, go back to mark entry and search for the class where you imported the marks and you should see the marks that you have uploaded: