Documentation:Connect/Uploading Student Grades to Faculty Service Centre(How To)

From UBC Wiki
Jump to: navigation, search

This documentation will show you how to:

  • Reformat the excel file that you have downloaded from the Grade Center so that you will be able to upload your grades to Faculty Service Center
  • Upload your grades to Faculty Service Center

Effective Practices

  • Before you upload the files to Faculty Service Center, double check that the grades are correct. This is very important because any errors submitted to the Faculty Service Center need to have sign off from Instructor, Department Head, the Dean and Director or Designate(s) to be changed.

Step 1:Download file from the Grade Center

  1. See the instruction on: how to download Files from the Grade Centre

Step 2:Reformat file

Once you have downloaded the excel file from the Grade Center, you will have to reformat the file so that it will be accepted by Faculty Service Center.

  1. After you have downloaded the excel file from the Grade Center, open the file using Microsoft Excel.
  2. The screnshot above is a sample format of the excel file. You will need to have the exact column headers as highlighted above.
  • Reformat the excel file, so that the first row of the excel file has the exact following column headers: Session, Campus, Student Number, Subject, Course, Section, Percent Grade and Standing.
  • The column needs to be bolded, but the column can be in different orders.
  • Use plain number or text only. Do not include formulas or images.
As shown in the screenshot, under Category, select Text
  • If your Session starts with 0** (For example: 001), excel will remove the 0. In this case, change the column format to number to a text column. To do this, right click on the section column> Select Format Cells> Under Category, Select Text>Press Ok.
  1. Make sure the file extension of your excel file is .xls format(Excel 97-2003 Workbook extension format ). You can also take a look at the sample excel file (spreadsheet file) that UBC Okanagan has created for your reference.
  2. Double check if the grades are correct.

Step 3:Upload file

If you do not enter the grades on the file, you will be able to enter the grades manually later. If you have entered the grades on the file, double check if the grades are correct.

  1. Access to Faculty Service Center
  2. From the top menu, click on Upload Grades
  3. At the upload grade window, choose Browse.
  4. Find your excel file and click ok. Then select Upload Files.
  5. After you have read the messages, click Continue with download button.

Change the grades after you have submitted to Faculty Service Center

If you wish to change your grades after you have submitted your grades to Faculty Service Center, follow the steps below:

  1. Access to Faculty Service Center
  2. Under Requested Class list, click on the Change Grades button.
  3. Select the student that you would like to change his/her grades
  4. Enter the reason for change and the new grade or standing.
  5. Click on the Download Grades Change Form Button
  6. Print and Sign the form and forward to appropriate people for approval. The form will require signatures of:
    1. Instructor
    2. Department Head
    3. The Dean, Director or Designate (of the Faculty offering the course)
    4. The Dean, Director or Designate (of the student’s Faculty, if different from above)

Resources

If you need more help on how to use Faculty Service Center, see the resources by Faculty Service Center Help Documentation