Documentation:Connect/Upload Files to the Grade Center (How To)

From UBC Wiki
Jump to: navigation, search

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.

Video

Watch the video below on how to download files from the Grade Center and work offline:

Access the Grade Center

  1. From the left-hand course menu, select Control Panel.
  2. Click Grade Center.
  3. Click Full Grade Center.
    Full Grade Center is the second option under 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.

Recommended

  1. Organize the Grade Center by adding columns per graded class activity outside of Connect.
  2. 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.

Optional

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.

  1. Create a new spreadsheet
  2. Label the first column, Username and fill it with your students' Student Number.
    The first column must be named Username and be filled with student numbers.
  3. Label new Grade Center columns with unique names and the corresponding grades.
  4. 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.
    The Column ID lets Connect know where to input the grades when the file is uploaded.
    Note: Column IDs can be found when you open the menu beside a column's name and click Quick Column Information.
    Column ID is the last field in the Quick Column Information Window.
  5. 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.

Edit Column Information is found in the menu when you hover over the column name.

Upload files

  1. From the top menu, click Work Offline > Upload.
    Top menu, farthest right tab is where the Work Offline button is located
  2. Click Browse My Computer to upload files from your local drive or click Browse Content Collection if the files are located there.
  3. Select the delimiter type: Comma, Tab, or Auto. Choosing Auto will attempt to automatically detect the delimiter used in the selected file.
  4. Click Submit to upload the selected file.
  5. 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.
  6. 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.
  7. 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.

Related Resources

  • Getting Started with the Grade Center (pdf)