Gradebook - manually grade students

Grades iconThis entry relates to the Gradebook.

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).

Manually import grades from an Excel file

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.

  1. In Excel, open the spreadsheet containing the grades

  2. Select File, then either Save as or Save a Copy (different options appear depending if the file is in OneDrive or not)

  3. Change the file type to CSV (comma delimited), and save the file
    save as type csv (comma delimited)

  4. In the FLO gradebook, click the Import tab, and the CSV file link.

  5. Use the Choose a file… button to browse for the CSV file, or drag and drop the file into the upload area

  6. Click the Upload grades button

  7. Confirm that the grades appear on the screen correctly

  8. 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
    map from fan and map to fan

  9. 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
    map assignment 1 column in spreadsheet to assignment 1 column in gradebook

  10. Click Upload grades

Manually enter a grade into the Gradebook

Avoid entering marks directly into the gradebook as it can create unexpected problems. 

  • Grades entered directly into the gradebook will permanently override what is entered in an assessed activity. This should only be done in exceptional circumstances.
  • Grades overridden in the gradebook do not show inside the activity.
  • Tutors cannot enter grades directly into the gradebook. If you want tutors to enter marks for assessment items that don't require a submission, create an offline assignment.

  1. Enter the Gradebook by clicking on the grades link in the Navigation menu
    Grade link in 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)
    grader report tab

  2. Click on the cell corresponding to the student and the grade item. The cell will change to an editable area. Enter the grade

  3. Press the Enter key to save the grade change. The cell will change colour to show that the grade has been overridden 
    The top mark came from an activity and has a white background. The lower mark was added manually and has a yellow background.

» How-to glossary