At the end of the semester teachers are required to record final grades in WebReg and submit to the Admissions & Records department a full gradebook as supporting material for those final grades. To submit the Canvas gradebook:

  1. In your Canvas course click Grades in the course navigation
  2. In the gradebook click Actions | Export to download a ".csv" spreadsheet file of the grades
  3. Open that file in Excel to edit......


***A Note from Grades Desk at MPC***

-----------------------------------------------------------------------

"In the past, the grades desk as a courtesy would convert Excel files to PDF files on behalf of instructors. However during COVID and the shift in demand of workload we are no longer able to do the conversions. If you do wish to submit your grades to us to store on your behalf, please follow the guidelines laid out on the Grades Desk link on the intranet: 


https://sites.google.com/a/mpc.edu/mympc2/home/student-services/admissions-records/grades-desk#TOC-Evaluation-of-Students-Progress


Additionally, I have included the guidelines for submitting grades electronically, from the Grades Desk link on the Intranet, for your convenience: 


This documentation should be formatted to be legible and fit on a 8.5 x 11.5inch printable page(s) and should include the following on each page: 

  • Instructors Name
  • Course Title 
  • Section Number
  • Semester and Year
  • Student Names (should be included on each page if the submission is multiple pages)
  • Page numbers (if the submission is multiple pages)
  • The scanned documentation needs to have the instructors physical wet signature on each page (at this time, I can use the direct address that you sent the documentation from in lieu of a signature)
  • Please make sure to save and submit the document as a PDF
  • You must send it using your MPC district email address"

-----------------------------------------------------------------------

The full details are here: How do I export grades in the New Gradebook?


Combined Sections

If your Canvas course combined sections of different courses together, you may need to edit the spreadsheet to separate those students in different sections.  


Here's an example of a (relatively) simple solution.  Suppose you have 2 courses together and must separate the student gradebooks by section.  Let's say the sections are GWOS-12-1111 and HIST-12-2222.  Use these steps:

  1. Make a copy of the spreadsheet file.  
  2. Open the original in Excel or Google sheets.
  3. Sort by section #.
  4. Delete all of the students from section 2222 by selecting the rows and pressing the Delete key.  It's easy because the sorting step has sorted them all together.
  5. Save that spreadsheet file under the name Grades GWOS 12 1111.
  6. Open the copy of the spreadsheet file in Excel or Google sheets.
  7. Sort by section #.
  8. Delete all of the students from section 1111.
  9. Save that spreadsheet file under the name Grades HIST 12 2222.
  10. Edit both spreadsheets in accordance to the new Grades Desk Requirements (listed above)
  11. Submit the 2 files 

Help

If the above steps don't make sense, please submit a help desk ticket.  The Online Ed team would be delighted to assist you!