Note: Wherever possible it is better to enter grades through the activity instead of in the gradebook. Any grade entered in the Gradebook will always override a grade entered through the activity – regardless if you want it to or not.
Entering grades via the Gradebook should only be done when there is no related activity in FLO (eg participation marks, in-class presentations).
Before recording the marks, it can be very helpful to first export a copy of the gradebook to enter the grades into. This will make it much easier to import the grades.
In Excel, open the spreadsheet containing the grades
Select File, then Save as
Change the file type to CSV (comma delimited), and save the file
Excel will ask if you want to keep the workbook in this format. Select Yes
Close the file. Excel will ask if you want to save changes again. Select Don't save
In the FLO gradebook, click the Import tab, and the CSV file link.
Use the Choose a file… button to browse for the CSV file, or drag and drop the file into the upload area
Click the Upload grades button
Confirm that the grades appear on the screen correctly
You now need to match data in your CSV file to data in the Gradebook. Under Identify user by, select a column in your CSV file (map from) that matches a column in FLO (map to). If you are using a file exported from FLO, you can set both Map from and Map to as FAN
Next you need to match the grades in your CSV file to a column in FLO. Under Grade item mappings, for each column you wish to import / update, select a destination column in the Gradebook. It is a good idea to only map the columns you have changed in Excel
Click Upload grades
Manually enter a grade into the Gradebook
Enter the Gradebook by clicking on the grades link in the Navigation menu
By default the Gradebook will open to the Grader report view, which displays a table of all students and all graded activities (in large topics the grader report might display over several pages)
Click on the cell corresponding to the student and the grade item. The cell will change to an editable area. Enter the grade (eg 9)
Press the Enter key to save the grade change. The cell will change colour to show that the grade was successfully entered