We’re happy to announce that we now have the ability to directly import data to your QuickSchools Gradebook via Excel. This feature is still in beta, so please feel free to request for it via email, and we can turn it on for you.

Once the import functionality is enabled, an “Import” button will appear directly on your Gradebook:

When you click on “Import” you will be prompted to select an Excel file from your machine, after which you will be asked to map columns from the Excel file with fields in the QuickSchools Database. The process works very similar to importing students and teachers from Excel:

Please note that your excel file will need to contain the following 6 fields:

1. Student Name
2. Column / Assignment Name
3. Column / Assignment Date
4. Category
5. Marks
6. Total Marks Possible

The final step is to simply click on the big red button labelled “Click Here to Import Data”, and you should be all set.

If you wanted to export your Gradebook data from QuickSchools in the same Excel format (if you wanted to copy columns from one term to the next, for example), you simply need to go to the “Reports” module and search for the report called “Gradebook Data (for Export)”:

When you export the data to Excel, you will be asked to select an appropriate academic year, term and subject:

Finally, use the Excel file as necessary, to import into other systems, or even back into QuickSchools.

We’re still working through some kinks, but please do share your thoughts and comments with us.

UPDATE Nov 5, 2018

As part of Sprint D15, the Gradebook Importer now supports a Student Number column (optional in place of student number), as well as an optional “Is Final Grade” column.