Formatting Grades

See the SmartSite Gradebook Help page for some tips on setting up a SmartSite gradebook.

1. Log in to SmartSite and go to the GradeBook2.
2. Click on the More Actions > Export > Only Grades
3. Choose the .csv option. (You may also be able to use the Excel option. Hasn't yet been tested)

1. Open the scores spreadsheet which you downloaded from WeBWorK.
2. Sort the students by section. This will move all administrators, TAs, and students who have dropped the course to the bottom of your WebWork scores file. Then delete these rows which should now be on the bottom. These rows should have in the section column: blank, TA, D01, D02, etc.
3. Next, sort the first name column alphabetically, then the last name column alphabetically.
4. Open the template spreadsheet which you downloaded from SmartSite and double-check that the list of students in the scores spreadsheet is exactly the same as the list of students in the template spreadsheet, with no blank rows.
5. Copy the column of scores from the scores spreadsheet to the template spreadsheet. The relevant column is marked with the homework set name in row 2 and “total” in row 7.
6. Save the template spreadsheet, which should now contain scores.

1. Back in the SmartSite Gradebook, click More Actions > Import
2. Select your modified template spreadsheet and follow the onscreen instructions. SmartSite will do the rest.

1. Log in to MyUCDavis and go to the GradeBook.
2. Click on the item for homework scores (or create it if you haven't already).
3. Click on “Download Excel”. Save the file.

1. Open the template file which you downloaded from MyUCDavis.
2. Open the scores file which you downloaded from WeBWorK.
3. Delete all rows in the scores file corresponding to administrators or students or who aren't enrolled.
4. Double-check that the list of students in the WeBWorK file is exactly the same as the list of students in the MyUCDavis file, with no blank rows.
5. Copy the column of scores from the scores file to the template file.
6. Save the file in the correct format.
   • Using Microsoft Excel
     1. Save the template file in “Tab Delimited” format.
   • Using OpenOffice Spreadsheet
     1. Save the template file in CSV format with tab as the field delimiter and “ as the text delimiter.
     2. Open the template file in vi and type

         :%s/"//g 

     3. Save the file in vi (shift+Z+Z).

1. Go back to the item for homework scores in the MyUCDavis GradeBook.
2. Click on “Upload Excel” and upload the template file to which you added the homework scores. The file type should be “GradeBook file”.
3. Click on “Upload Grades”.