Skip to content

Importing / Exporting Gradebook Data

December 16, 2014

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:

Importing Gradebook Data from Excel

Importing Gradebook Data from Excel

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:

Map Gradebook Columns from Excel to QuickSchools Fields

Map Gradebook Columns from Excel to QuickSchools Fields

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)”:

Gradebook Data (For Export) Report

Gradebook Data (For Export) Report

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

Select Filters when Exporting Gradebook Data to Excel

Select Filters when Exporting Gradebook Data to Excel

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

Sample Gradebook Excel File

Sample Gradebook Excel File

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s