G. Creating a .csv File
This section walks you through creating a CSV file for uploading grades.
After March 2015, all grades will be submitted through Mosaic and will need to follow
the new format.
Mosaic requires grade information to be uploaded in a CSV file (comma delimited
text file) in the order: Class number, Student ID, and Final Grade
Those who use a spreadsheet to track grades may find the following format to be
Student ID number
Available in Mosaic
starting March 2015
As of Oct 2014, student ID
numbers will be converted
to nine digit numbers. The
majority of students will
keep their existing seven
digit number prefixed with
two zeros. There is a small
fraction that will get a new
number. If you get errors
importing your file please
check this number for
(no % sign please)
- Other acceptable grades
Note: These instructions use Microsoft Excel as an example starting point, if you use
a different spreadsheet program the steps will be similar, but the detailed
instructions may not exactly match.
NOTE: When converting excel to csv using a Mac you need to select “windows csv
format” in the drop down menu.
Open the file that contains the final grades for the Class (es).
The columns required are Class Number, Student Number and Grade. No
column headings or other additional data is permitted in the file. The file
must be saved as a .csv file type. The remaining instructions will walk you
through how to format and save your spreadsheet into an acceptable file.