Online Grade Collection
Creating a .csv File
- This section walks you through creating a .csv file. These instructions use Microsoft Excel as a sample starting point but the points detailed here apply regardless of which spreadsheet software you use.
- Open the file that contains the final grades for the Course (or Course Section).
- Remove any rows that exist above the column headings, so the column headings are the first row in the spreadsheet.
- Ensure that the column headings are named in the following manner;
"Student Number", "MacID", "Final Grade", and "Notes"
(or you may use any acceptable equivalent names as defined in Appendix 1)
Notes: - Headings must be in the first row, and are not case sensitive
- The order of the columns does not matter.
- The 'Notes' field is optional.
- Any additional columns will be ignored.
-Some Lecture Sections have spaces in them (i.e., ' 1 '), be sure to include the spaces - If a column does not exist on the spreadsheet then insert a new column.
- Give the new column the appropriate name.
- Populate the column with data accordingly.
- Repeat steps 3, 4, & 5 for any other missing columns.
- Select File --> Save as…
- Select “Save as Type” = CSV (Comma delimited) (*.csv)
- Type an appropriate file name (I.e., ANTHROP 1A03 C01), and press save.
- If the following warning appears, click OK.
- When the following warning appears, click YES.
- If you don't track your grades electronically you may download a pre-populated version of the .csv by following these steps:
- Login, if you are not logged in already.
- Click the Grade Sheets tab (if you are not already there).
- Click the course or course section you want to upload grades for.
- Scroll to the bottom of the electronic grade sheet (if required).
- Click the “download .csv” link.
- Save the .csv file to your computer.
Note: Depending on which browser you use this may happen automatically. - Open the newly downloaded .csv.
- Populate your student’s final grades in the ‘Final Grade’ column.
- Save the file.
Tip: Remember where you saved the file as you will be asked for it’s location when uploading your grades.
- 14. If you wish to start with an empty file (a file with only the required headers) then you may use the following link to download a template: Online Grades - CSV Template.csv
Notice
Upgrade your MAC ID password today
McMaster is strengthening its password system and all MAC ID passwords established before February 19, 2013 must be changed.
- Upgrade before
May 29, 2013
Service Desk
| Hours: | Monday - Friday 8:30 am - 4:30 pm |
|---|---|
| Phone: | 905-525-9140 x24357 (2HELP) |
| Email: | uts@mcmaster.ca |
| Location: | Main Campus BSB Rm. 245 |
| Service Catalogue: | |
| http://www.mcmaster.ca/uts | |
Service Bulletins
- There are no Service Bulletins at this time