Documentation:Connect/Upload Files to the Grade Center (How To)
To ensure accurate entry of grades, you can grade offline using a spreadsheet such as Microsoft Excel and then import grades into the Grade Centre. You can also upload grades from other class activities through a properly formatted spreadsheet or csv file.
This document will show you how to:
- Format the Grade Center File
- Access the Grade Center
- Upload files
Note on File Security and Protection of Privacy
Before working offline with student grades on your computer, please read the Access and Privacy Brochure from the Office of the University Counsel to learn more about your responsibilities concerning the security of your files and the protection of privacy of your students.
Watch the video below on how to download files from the Grade Center and work offline:
Access the Grade Center
- From the left-hand course menu, select Control Panel.
- Click Grade Center.
- Click Full Grade Center.
Format the Grade Center File
There are 2 ways to format a file to upload to the Grade Center. If you want to work on grades outside of Connect, the recommend method is below. While it is possible to set up a Grade Centre file as outlined under the Optional heading, it is not recommended as it frequently results in errors.
- Organize the Grade Center by adding columns per graded class activity outside of Connect.
- Download the file from the Grade Center.
The downloaded file will be pre-formatted and have the appropriate columns in place. Additional columns must be created within the Grade Center and download a new version of the file.
The following instructions only apply to newly created grade files. This is intended for your information only. We do not recommend this method as part of your regular practice.
- Create a new spreadsheet
- Label the first column, Username and fill it with your students' Student Number.
- Label new Grade Center columns with unique names and the corresponding grades.
- Existing Grade Center columns with new or modified student grades need to have the exact name plus a vertical line (|) followed by the Column ID.
- Note: Column IDs can be found when you open the menu beside a column's name and click Quick Column Information.
- Click Save frequently.
Note: Uploaded new Grade Center columns will need to be given the maximum Points Possible or they will be considered bonus points in the final grade. You can add the points via the Edit Column Information'" when you click on the menu beside the column name.
- From the top menu, click Work Offline > Upload.
- Click Browse My Computer to upload files from your local drive or click Browse Content Collection if the files are located there.
- Select the delimiter type: Comma, Tab, or Auto. Choosing Auto will attempt to automatically detect the delimiter used in the selected file.
- Click Submit to upload the selected file.
- Review the list of data from the file to be uploaded on the Upload Grades Confirmation page. Clear the check boxes for any data to be excluded from the upload. Using this method, it is possible to upload only the desired columns of data from the file.
- Review the Data Preview column to ensure the correct data is being uploaded. Data that appears incorrect can denote an improperly formatted file. The data preview will only show a sample of the data in each column in the file.
- Note: Large files take significant time to process and a warning message will be displayed for any files that need extra time to process. To avoid long processing times, break up large files into separate uploads.
- Click Submit to confirm and upload the file.
- Note: Any file uploaded that contains Incomplete for a grade entry will be set to null, with no grade or text displayed. Any file uploaded that contains Complete for a grade entry will be set to an override grade of the maximum points possible (100% for a grade item) in a column that has the primary display of complete/incomplete. Any file uploaded that contains a numeric entry will be a numeric entry.
- Getting Started with the Grade Center (pdf)