This guide is designed to show the process of providing marks for the self-reflections completed by students in Science courses.

1. Adding a Grade Centre Column and Downloading Column

Downloading Grade Centre Column

  1. Create a column in Grade Centre for the reflection mark. For further information, refer to the Create a Column guide.
  2. Click on the Work Offline button.
  3. Click on Download from the drop-down list.

Work offline and download buttons circled

  1. Select the Selected Column radio button.
  2. Select the created reflection column (Step 1) from the drop-down list.

Selected column radio button circled and the drop-down list

  1. Select the Comma radio button for Delimiter Type.
  2. Select the No radio button for Include Hidden Information.
  3. Click on the Submit button.

Comma and No radio buttons circled as well as the Submit button

  1. Click the Download button. 

click on download button

  1. Click on the downloaded spreadsheet to open it in Excel.

Downloaded spreadsheet circled

  1. Copy the column heading from Cell G1 (in the below screenshot the column heading is Employability Reflection [Total Pts: 1] |459976). This column heading will be added into the spreadsheet from the ePortfolio in the section 3.

Cell G1 circled on spreadsheet