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

3. Mark Reflections

  1. Open reflections excel document.
  2. Delete rows 1 - 9. Refer to the Insert or delete rows, and columns guide by Microsoft.
  3. Insert a column between columns B and C. Refer to the Insert or delete rows, and columns guide by Microsoft.
  4. In the newly created column paste the Grade Centre column heading from section 1 into cell C1 (in the below screenshot the column heading is Employability Reflection [Total Pts: 1] |459976).

Cell C1 circled with heading added in

  1. Add the required mark next to each student in column C (in the below screenshot the reflection has been marked out of 1).

Marked entered in cell C2 next to student

  1. Once you have marked all students, delete all columns except the Mark column (in the below screenshot the column heading is Employability Reflection [Total Pts: 1] |459976) and the Student # column. Refer to the Insert or delete rows, and columns guide by Microsoft.

Student # and mark columns circled.

  1. Replace Student # with Username.

Username circled

  1. Save the spreadsheet as a .CSV file.

CSV circled in the drop down menu