Blended Learning Help Site Banner

Grades

Create grade items, publish grades to students and manage your feedback.

Exporting Gradebook Data

The information in this guide is intended for Block Convenors and Block Instructors.

Gradebook data can be exported to your computer to modify offline or keep for auditing purposes. Export student grades to an Excel spreadsheet to allow you to add and modify grades offline. You then have the ability to import the spreadsheet back into the Gradebook for your VU Collaborate Space, making the management of large classes as simple as possible. Please see Importing Gradebook Data guide for further information.

Below are the steps to export Gradebook Data:

Exporting Gradebook Data is only possible within Delivery Spaces and can only be changed by Block Convenors, Convenors, Block Instructors, Instructors and Tutors. 

Step One: Access your Gradebook


1. Click on the Assessment tab and select Grades.

Access Grades

 

Step Two: Export your Gradebook to Excel (CSV Format)


1. Select the Enter Grades tab to access the gradebook.

2. Click on the Export button.

Access the Export function from Enter Grades 

3. Select All users if you want to export the grades of all the students in the class or follow steps 2.1 to export groups. 

4. In the Key Field, you can select either Org Defined ID or Username as they both would provide student ID.

5. In Sort By, select to export in chosen order. i.e. (Name, Last name, Username).  Default orders are Org Defined ID, Last Name, First Name.

Export Grade Options 1

6. Select the Grade Values you would like to export. If you want to modify the spreadsheet data and import it back into VU Collaborate, only select Points grade.

7. Select the User Details that you would like to export. It’s recommended that you select Last Name and First Name so that you can identify students otherwise you will only be provided with their student number.

Export Grade Options 2

You can also use this function to print a list of your students in groups. 

7. Select the checkbox next to the grade items you wish to export then click on Export to CSV to export your data.

It's recommended to export as CSV files as they can be opened in Excel and this format is required to import your Gradebook back into VU Collaborate.

Choose Grades to Export

 

2.1 Exporting for Groups 

1. If you have created Groups in your Unit Space, and you only want to export grades to just one of those groups, go to Export Grades.

2.  Under Export Options select Groups and then Apply. 

3. The Groups option will appear on your screen. Click on the dropdown button, select the group that you want to export grades from and then click Apply. 

Select Groups to export grade  Select Groups to export grade 2

4. Select the Grade Values and User details you would like to export. 

5. You can select Group Membership to sort students into their respective groups. 

Export Grade Options for Group memberships

6. Select the checkbox next to the grade items you wish to export then click on Export to CSV to export your data.

It's recommended to export as CSV files as they can be opened in Excel and this format is required to import your Gradebook back into VU Collaborate.

Choose Grades to Export

 

Step Three: Download CSV File


1. A pop-up window will appear. Click on the Download button to download your CSV File.

Pop up window download button

If you do not see this view, navigate to the Downloads folder on your computer to access the CSV file.

 

Step Four: Open the CSV File


The CSV file will display student information and any grades that have been entered for each Grade item.

excel spreadsheet with same student in left column and corresponding columns with example grade data

 

Step Five: Adding/Adjusting Grades in the Spreadsheet


1. Enter the results for students in the column for each Grade item that requires a grade. You can also change previously entered grades and alter the order (eg., put into alphabetical order).

2. Grades should only be entered in the Points Grade columns. Leave any Weighted, Scheme or Final Grade columns as these will be automatically calculated when you import the data back into VU Collaborate.

Do not change the headings in any of the columns in the CSV file. This will ensure your CSV file is in the correct format, ready to import into VU Collaborate.

Column in excel spreadshet entitled Final Project Points Grade highlighted, with example mark of 40 below it.

 

Step Six: Save your Modified CSV File


1. Once you have completed your marking save your file. Do not change the name of the file; keep it the same as when you downloaded it.

2. You may be prompted to accept the CSV file format, select Yes.

3. To learn how to import the grades back into VU Collaborate please see the Importing Gradebook Data guide. 

Excel popup asking permission to save file as CSV. Yes button is highlighted

 

 


Further Support

Visit the VU Collaborate Help site at https://vucollaboratehelp.vu.edu.au for up to date information and resources on blended learning or email This email address is being protected from spambots. You need JavaScript enabled to view it..

Contact ITS Service Desk on (03) 9919 2777 or via self-service http://servicedesk.vu.edu.au for further technical support.

 

Admin Only