Assignment Feedback Sheets – using Insert field

If you are using Microsoft Word together with our Batch feedback tool for your assessment feedback you can use some of Words inbuilt functionality to place the students name directly into the document (File Name) as well as getting it to total marks for you (Formula).

Student Name

Before you up load your feedback document template sheet to the batch feedback system open it in Microsoft Word.

Click into the document where you want to insert the field. This is where you would like the student name to be.

Insert field

On the Insert tab, in the Text group, click Quick Parts, and then click Field.

File name

In the Categories list, select a category FileName you may have to scroll down the list of field names to highlight it.

Click Ok and the name of the file will be entered at that point.

Student name

When you need to update the field (to put in the student’s name) in the downloaded feedback sheets, simply right click where you put the original insert and click update field on the menu, which in this case will update the field to the file name.

Update file name

Formula

In the same way as you add the file name above you can also add a field that will sum up your marks for you. Open your Microsoft Word feedback template. Total

Click where you want to insert a field the total mark. On the Insert tab, in the Text group, click Quick Parts, and then click Field.Quick PartsIn the Categories list, select a category =(Formula)

Click on Formula. If the text says =SUM(ABOVE) then that box will total the numbers above when you update the field. If the Formula box is empty type in =SUM(ABOVE)

SumClick OK.

When you need to update the field (to put in the student’s mark) in the downloaded feedback sheets, simply left click on the original formula to highlight it. Then with it selected, right click your mouse. You can now select Update Field from the menu, which in this case will add up the marks.

 

Tip

TipsHaving done this many times there are a few tips that I find useful. They’re not necessary steps but if you do them it makes life easier.

If you put 0 in the cells above where you insert the field to sum the above in most cases it will put the =SUM(ABOVE) formula in the box and saves you having to type it.  Also if you’d like your mark to be a percentage you can pick that in the number format options that way it will sum up the total and put the percent symbol next to it.