Your Own Excel Gradebook

Using Your Own Excel Gradebook

If use your own Excel spreadsheet to record students’ grades, do the following:

  1. Open your Excel file.
  2. Save a copy of it under another name so you have a record of all your grades.
  3. You can combine multiple sections of students in one Excel worksheet. However, please note that eCampus uploads grades to eCampus one section at a time.
  4. Remove all the columns except the columns of “Student Id”, “Student Name” and “Letter Grade”.
    • The column titles do not need to be exactly as “Student Id”, “Student Name” and “Letter Grade”, but, the column position is very important. Make sure that “Student Id” is in the first column, “Student Name” in the second column, and “Letter Grade” in the third column.”
  5. Save the file as:
    • WINDOWS: “CSV (Comma Delimited) (*.csv)” format in Windows Excel, or,
    • MAC: “Windows Formatted Comma Separated (*.csv)” format in Macintosh Excel.
  6. Repeat the above steps for each section in your course site.
  7. Follow the eCampus instructions to upload the csv file(s) one-by-one to eCampus Grade Roster.

Screen Shot 2015-01-06 at 1.45.53 PM Screen Shot 2015-01-06 at 1.47.52 PM Screen Shot 2015-01-06 at 1.48.31 PM Screen Shot 2015-01-06 at 1.48.08 PM Screen Shot 2015-01-06 at 1.48.48 PM Screen Shot 2015-01-06 at 1.49.00 PM

 Back to Importing Grades from Sakai to eCampus

Think Big We Do

Copyright © 2017 University of Rhode Island.